REVENUEGLDISTRIBUTIONREVENUESPLITMAPTEMP2

Table to map revenue GL distribution records to revenue split records.

Fields

Field Field Type Null Notes Description
ID uniqueidentifier Primary Key.
REVENUESPLITID uniqueidentifier yes Foreign key to the REVENUESPLIT table.
ADDEDBYID uniqueidentifier FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier FK to CHANGEAGENT.
DATEADDED datetime Indicates the date this record was added.
DATECHANGED datetime Indicates the date this record was last changed.
TS timestamp Timestamp.
TSLONG bigint (Computed) yes CONVERT(bigint, TS) Numeric representation of the timestamp.