WRITEOFFSPLIT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| WRITEOFFID | uniqueidentifier | ||
| DESIGNATIONID | uniqueidentifier | ||
| AMOUNT | money | ||
| 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.WRITEOFFSPLIT with schemabinding
as
select FINANCIALTRANSACTIONLINEITEM.ID, FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID as WRITEOFFID,
isnull(REVENUESPLIT_EXT.DESIGNATIONID, '00000000-0000-0000-0000-000000000000' ) as DESIGNATIONID,
FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT as AMOUNT, 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
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 = 20
and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null