WRITEOFF
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| REVENUEID | uniqueidentifier | ||
| DATE | datetime | ||
| POSTSTATUSCODE | tinyint | ||
| POSTDATE | datetime | yes | |
| REASON | nvarchar(300) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| POSTSTATUS | nvarchar(11) | yes | |
| REASONCODEID | uniqueidentifier | yes |
Definition
Copy
CREATE view dbo.WRITEOFF with schemabinding as
select FINANCIALTRANSACTION.ID,
isnull(FINANCIALTRANSACTION.PARENTID,'00000000-0000-0000-0000-000000000000') as REVENUEID,
isnull(cast(FINANCIALTRANSACTION.DATE as datetime),'') as DATE,
isnull(cast(case FINANCIALTRANSACTION.POSTSTATUSCODE when 2 then 0 when 1 then 1 when 3 then 2 end as tinyint), 2) as POSTSTATUSCODE,
cast(FINANCIALTRANSACTION.POSTDATE as datetime) as POSTDATE, WRITEOFF_EXT.REASON, FINANCIALTRANSACTION.ADDEDBYID, FINANCIALTRANSACTION.CHANGEDBYID, FINANCIALTRANSACTION.DATEADDED,
FINANCIALTRANSACTION.DATECHANGED, FINANCIALTRANSACTION.TS, FINANCIALTRANSACTION.TSLONG,
cast(case FINANCIALTRANSACTION.POSTSTATUSCODE when 2 then 'Posted' when 1 then 'Not posted' when 3 then 'Do not post' end as nvarchar(11))as POSTSTATUS,
WRITEOFF_EXT.REASONCODEID
from dbo.FINANCIALTRANSACTION inner join dbo.WRITEOFF_EXT on FINANCIALTRANSACTION.ID = WRITEOFF_EXT.ID
where TYPECODE = 20 and FINANCIALTRANSACTION.DELETEDON is null