REVENUEGLDISTRIBUTIONREVENUESPLITMAP
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| REVENUESPLITID | uniqueidentifier | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
CREATE view dbo.REVENUEGLDISTRIBUTIONREVENUESPLITMAP with schemabinding
as
Select
je.ID as ID,
li.ID REVENUESPLITID,
je.ADDEDBYID,
je.CHANGEDBYID,
je.DATEADDED,
je.DATECHANGED,
je.TS,
je.TSLONG
From dbo.FINANCIALTRANSACTIONLINEITEM li
inner join dbo.JOURNALENTRY je on li.ID = je.FINANCIALTRANSACTIONLINEITEMID