USP_DATALIST_BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION
A datalist of bank account deposit correction GL distribution.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
| @SYSTEMDISTRIBUTION | bit | IN | System distributions |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION
(
@ID uniqueidentifier
,@SYSTEMDISTRIBUTION bit = 0
)
as
set nocount on;
select
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.BANKACCOUNTDEPOSITCORRECTIONID AS ID,
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.ID AS BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTIONID,
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.TRANSACTIONTYPE,
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.ACCOUNT,
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.PROJECT,
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.AMOUNT,
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.REFERENCE
,case when BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.TRANSACTIONAMOUNT, 0) else BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.TRANSACTIONAMOUNT end [TRANSACTIONAMOUNT]
,case when BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.AMOUNT, 0) else BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.AMOUNT end [BASEAMOUNT]
,case when BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.ORGANIZATIONAMOUNT, 0) else BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.ORGANIZATIONAMOUNT end [ORGANIZATIONAMOUNT]
,BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.TRANSACTIONCURRENCYID
,BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.BASECURRENCYID
from dbo.BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION
inner join dbo.GLTRANSACTION on GLTRANSACTION.ID = BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.GLTRANSACTIONID
where
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.BANKACCOUNTDEPOSITCORRECTIONID = @ID
and GLTRANSACTION.SYSTEMDISTRIBUTION = @SYSTEMDISTRIBUTION
order by BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION.TRANSACTIONTYPE desc;