PLANNEDGIFTPAYOUT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| REVENUEID | uniqueidentifier | yes | |
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
CREATE view dbo.PLANNEDGIFTPAYOUT with schemabinding as
select FINANCIALTRANSACTION.ID, FINANCIALTRANSACTION.PARENTID as REVENUEID,
FINANCIALTRANSACTION.ADDEDBYID, FINANCIALTRANSACTION.CHANGEDBYID, FINANCIALTRANSACTION.DATEADDED,
FINANCIALTRANSACTION.DATECHANGED, FINANCIALTRANSACTION.TS, FINANCIALTRANSACTION.TSLONG
from dbo.FINANCIALTRANSACTION
where TYPECODE = 26 and DELETEDON is null