PDACCOUNTSYSTEMFORREVENUE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| PDACCOUNTSYSTEMID | uniqueidentifier | yes | |
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
CREATE view dbo.PDACCOUNTSYSTEMFORREVENUE with schemabinding
as
Select
ID
,PDACCOUNTSYSTEMID
,ADDEDBYID
,CHANGEDBYID
,DATEADDED
,DATECHANGED
,TS
,TSLONG
From dbo.FINANCIALTRANSACTION
where TYPECODE in (0,1,4,5,6,7)