USP_DATALIST_BANKACCOUNTDEPOSITCORRECTIONS

This returns a list of all deposit corrections within a bank account deposit context.

Parameters

Parameter	Parameter Type	Mode	Description
@DEPOSITID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                      CREATE procedure dbo.USP_DATALIST_BANKACCOUNTDEPOSITCORRECTIONS
        (
                    @DEPOSITID uniqueidentifier = null
                )      
                as
                    set nocount on;

          select  BANKACCOUNTDEPOSITCORRECTION.ID,
                  BANKACCOUNTDEPOSITCORRECTION.DATE,
                          BANKACCOUNTDEPOSITCORRECTION.CORRECTIONTYPE,
                  BANKACCOUNTDEPOSITCORRECTION.REFERENCE,
                  BANKACCOUNTDEPOSITCORRECTION.PAYMENTMETHOD,
                          BANKACCOUNTDEPOSITCORRECTION.TRANSACTIONAMOUNT as AMOUNT
                          ,BANKACCOUNTDEPOSIT.TRANSACTIONCURRENCYID
          from dbo.BANKACCOUNTDEPOSITCORRECTION
          inner join dbo.BANKACCOUNTDEPOSIT on BANKACCOUNTDEPOSITCORRECTION.DEPOSITID = BANKACCOUNTDEPOSIT.ID
          where 
                        DEPOSITID = @DEPOSITID
                    order by
                        DATE desc;