PLANNEDGIFTPAYOUTSPLIT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| REVENUEID | uniqueidentifier | ||
| DESIGNATIONID | uniqueidentifier | yes | |
| AMOUNT | money | ||
| TYPECODE | tinyint | ||
| TYPE | nvarchar(27) | yes | |
| APPLICATIONCODE | tinyint | ||
| APPLICATION | nvarchar(18) | yes | |
| 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 | |
| DESCRIPTION | nvarchar(700) | yes |
Definition
Copy
CREATE view dbo.PLANNEDGIFTPAYOUTSPLIT with schemabinding
as
select
FINANCIALTRANSACTIONLINEITEM.ID
,isnull(FINANCIALTRANSACTION.PARENTID,'00000000-0000-0000-0000-000000000000') as REVENUEID
,REVENUESPLIT_EXT.DESIGNATIONID, FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT as AMOUNT
,REVENUESPLIT_EXT.TYPECODE,REVENUESPLIT_EXT.TYPE
,REVENUESPLIT_EXT.APPLICATIONCODE
,cast(REVENUESPLIT_EXT.APPLICATION as nvarchar(18)) as APPLICATION
,FINANCIALTRANSACTIONLINEITEM.ADDEDBYID
,FINANCIALTRANSACTIONLINEITEM.CHANGEDBYID
,FINANCIALTRANSACTIONLINEITEM.DATEADDED
,FINANCIALTRANSACTIONLINEITEM.DATECHANGED
,FINANCIALTRANSACTIONLINEITEM.TS
,FINANCIALTRANSACTIONLINEITEM.TSLONG
,case when FINANCIALTRANSACTIONLINEITEM.DELETEDON is null then CURRENCYSET.BASECURRENCYID else null end as BASECURRENCYID
,FINANCIALTRANSACTIONLINEITEM.ORGAMOUNT as ORGANIZATIONAMOUNT
,FINANCIALTRANSACTION.ORGEXCHANGERATEID as ORGANIZATIONEXCHANGERATEID
,FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT as TRANSACTIONAMOUNT
,case when FINANCIALTRANSACTIONLINEITEM.DELETEDON is null then FINANCIALTRANSACTION.TRANSACTIONCURRENCYID else null end as TRANSACTIONCURRENCYID
,FINANCIALTRANSACTION.BASEEXCHANGERATEID
,case when FINANCIALTRANSACTIONLINEITEM.DELETEDON is null then case len(FINANCIALTRANSACTIONLINEITEM.DESCRIPTION) when 0 then null else FINANCIALTRANSACTIONLINEITEM.DESCRIPTION end else null end as DESCRIPTION
from dbo.FINANCIALTRANSACTIONLINEITEM inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
where FINANCIALTRANSACTION.TYPECODE = 26 and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null