UNREALIZEDGAINLOSSGLDISTRIBUTION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| REVENUEID | uniqueidentifier | yes | |
| PROJECT | nvarchar(100) | ||
| REFERENCE | nvarchar(255) | ||
| AMOUNT | money | ||
| ACCOUNT | nvarchar(100) | ||
| TRANSACTIONTYPECODE | tinyint | ||
| TRANSACTIONTYPE | nvarchar(6) | yes | |
| GLTRANSACTIONID | uniqueidentifier | ||
| OUTDATED | bit | ||
| BASECURRENCYID | uniqueidentifier | yes | |
| ORGANIZATIONAMOUNT | money | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
CREATE view dbo.UNREALIZEDGAINLOSSGLDISTRIBUTION with schemabinding as
select
JE_EXT.GLTRANSACTIONID as ID
,case when FTLI.DELETEDON is null then FTLI.FINANCIALTRANSACTIONID else null end as REVENUEID
,JE_EXT.PROJECT
,JE.COMMENT as REFERENCE
,JE.BASEAMOUNT as AMOUNT
,isnull(A.ACCOUNTNUMBER,JE_EXT.ACCOUNT) as ACCOUNT
,JE.TRANSACTIONTYPECODE
,JE.TRANSACTIONTYPE
,JE.ID as GLTRANSACTIONID
,JE_EXT.OUTDATED
,case when CS.BASECURRENCYID = '00000000-0000-0000-0000-000000000000' then null else CS.BASECURRENCYID end BASECURRENCYID
,JE.ORGAMOUNT as ORGANIZATIONAMOUNT
,JE_EXT.ADDEDBYID
,JE_EXT.CHANGEDBYID
,JE_EXT.DATEADDED
,JE_EXT.DATECHANGED
,JE_EXT.TS
,JE_EXT.TSLONG
from dbo.JOURNALENTRY JE
inner join dbo.FINANCIALTRANSACTIONLINEITEM FTLI on FTLI.ID = JE.FINANCIALTRANSACTIONLINEITEMID
inner join dbo.FINANCIALTRANSACTION FT on FT.ID = FTLI.FINANCIALTRANSACTIONID
inner join dbo.JOURNALENTRY_EXT JE_EXT on JE.ID = JE_EXT.ID and TABLENAMECODE = 14
left outer join dbo.GLACCOUNT A on JE.GLACCOUNTID = A.ID
inner join dbo.PDACCOUNTSYSTEM on FT.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
inner join dbo.CURRENCYSET CS on PDACCOUNTSYSTEM.CURRENCYSETID = CS.ID