BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| PROJECT | nvarchar(100) | ||
| REFERENCE | nvarchar(255) | ||
| AMOUNT | money | ||
| ACCOUNT | nvarchar(100) | ||
| TRANSACTIONTYPECODE | tinyint | ||
| TRANSACTIONTYPE | nvarchar(6) | yes | |
| GLTRANSACTIONID | uniqueidentifier | ||
| BANKACCOUNTDEPOSITCORRECTIONID | uniqueidentifier | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| BASECURRENCYID | uniqueidentifier | yes | |
| ORGANIZATIONAMOUNT | money | ||
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | |
| TRANSACTIONAMOUNT | money | ||
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | |
| BASEEXCHANGERATEID | uniqueidentifier | yes |
Definition
Copy
CREATE view dbo.BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION with schemabinding as
select
JOURNALENTRY_EXT.GLTRANSACTIONID as ID
,JOURNALENTRY_EXT.PROJECT
,JOURNALENTRY.COMMENT as REFERENCE -- REFERENCE
,JOURNALENTRY.BASEAMOUNT as AMOUNT -- AMOUNT
,GLACCOUNT.ACCOUNTNUMBER as ACCOUNT --ACCOUNT
,JOURNALENTRY.TRANSACTIONTYPECODE
,JOURNALENTRY.TRANSACTIONTYPE
,JOURNALENTRY.ID as GLTRANSACTIONID
,FINANCIALTRANSACTION.ID AS BANKACCOUNTDEPOSITCORRECTIONID
,JOURNALENTRY_EXT.ADDEDBYID
,JOURNALENTRY_EXT.CHANGEDBYID
,JOURNALENTRY_EXT.DATEADDED
,JOURNALENTRY_EXT.DATECHANGED
,JOURNALENTRY_EXT.TS
,JOURNALENTRY_EXT.TSLONG
,case CURRENCYSET.BASECURRENCYID
when '00000000-0000-0000-0000-000000000000' then null
else CURRENCYSET.BASECURRENCYID end as BASECURRENCYID
,JOURNALENTRY.ORGAMOUNT as ORGANIZATIONAMOUNT
,JOURNALENTRY_EXT.PRECALCORGANIZATIONEXCHANGERATEID as ORGANIZATIONEXCHANGERATEID
,JOURNALENTRY.TRANSACTIONAMOUNT as TRANSACTIONAMOUNT
,case JOURNALENTRY.TRANSACTIONCURRENCYID
when '00000000-0000-0000-0000-000000000000' then null
else JOURNALENTRY.TRANSACTIONCURRENCYID end
as TRANSACTIONCURRENCYID
,JOURNALENTRY_EXT.PRECALCBASEEXCHANGERATEID BASEEXCHANGERATEID
from dbo.JOURNALENTRY
inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.ID = JOURNALENTRY.FINANCIALTRANSACTIONLINEITEMID
inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
inner join dbo.JOURNALENTRY_EXT on JOURNALENTRY.ID = JOURNALENTRY_EXT.ID and JOURNALENTRY_EXT.TABLENAMECODE = 3
inner join dbo.GLACCOUNT on JOURNALENTRY.GLACCOUNTID = GLACCOUNT.ID
inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID