Account History SQL procedures and parameters.


The "Account History" section of AccountCentral is used to retrieve statements, balances and payment history. All website asp.net logic is contained in class: AccountCentral.controls.statementHistory

Stored Procedure: xct_spACGetARStatements
Called by: ctAC.statements.getARStatements()
The initial procedure that populates the AccountCentral.controls.statementHistory.dsUserStatements dataset.
Parameters:

  •    @userGUID uniqueidentifier, --The current user (xct_tblACUser.userGUID)
  •    @actionType varchar(255), --Passthrough of asp.net actionType variable, not currently used.
  •    @currentPageNumber int, --The current page of records (initial page = 1)
  •    @pageSize int, --How many records to pull back per page.
  •    @beginDate datetime, --Date Range Start
  •    @endDate datetime, --Date Range End
  •    @statementHistoryParams varchar(1000) --Configurable NAME|VALUE pairs for customization purposes.

@statementHistoryParams default NAME|VALUE pairs:
  •    TYPE|<blankstring> -- calls procedure: xct_spACGetARStatementsAll @userGUID,@custID,@actionType,@currentPageNumber,@pageSize,@beginDate,@endDate,@statementHistoryParams
  •    TYPE|PAYMENT -- calls procedure: xct_spACGetARStatementsPayment @userGUID,@custId,@actionType,@currentPageNumber,@pageSize,@beginDate,@endDate,@statementHistoryParams
  •    TYPE|CURRENT -- calls procedure: xct_spACGetARStatementsCurrent @userGUID,@custId,@actionType,@currentPageNumber,@pageSize,@beginDate,@endDate,@statementHistoryParams     

Stored Procedure: xct_spACGetARStatementsAll
Called if "All Statements" is selected.
Parameters:

  •    @userGUID uniqueidentifier, --The current user (xct_tblACUser.userGUID)
  •    @actionType varchar(255), --Passthrough of asp.net actionType variable, not currently used.
  •    @currentPageNumber int, --The current page of records (initial page = 1)
  •    @pageSize int, --How many records to pull back per page.
  •    @beginDate datetime, --Date Range Start
  •    @endDate datetime, --Date Range End
  •    @statementHistoryParams varchar(1000) --Configurable NAME|VALUE pairs for customization purposes.

Stored Procedure: xct_spACGetARStatementsPayment
Called if "Payments Only" is selected.
Parameters:

  •    @userGUID uniqueidentifier, --The current user (xct_tblACUser.userGUID)
  •    @actionType varchar(255), --Passthrough of asp.net actionType variable, not currently used.
  •    @currentPageNumber int, --The current page of records (initial page = 1)
  •    @pageSize int, --How many records to pull back per page.
  •    @beginDate datetime, --Date Range Start
  •    @endDate datetime, --Date Range End
  •    @statementHistoryParams varchar(1000) --Configurable NAME|VALUE pairs for customization purposes.

Stored Procedure: xct_spACGetARStatementsCurrent
Called if "Current Statement" is selected.
Parameters:

  •    @userGUID uniqueidentifier, --The current user (xct_tblACUser.userGUID)
  •    @actionType varchar(255), --Passthrough of asp.net actionType variable, not currently used.
  •    @currentPageNumber int, --The current page of records (initial page = 1)
  •    @pageSize int, --How many records to pull back per page.
  •    @beginDate datetime, --Date Range Start
  •    @endDate datetime, --Date Range End
  •    @statementHistoryParams varchar(1000) --Configurable NAME|VALUE pairs for customization purposes.