Open topic with navigation
Stores busienss units associated with a single revenue application.
ID
uniqueidentifier
BATCHREVENUEID
false
BATCHREVENUE.ID
FK to BATCHREVENUE
BUSINESSUNITCODEID
BUSINESSUNITCODE.ID
FK to BUSINESSUNITCODE
ADDEDBYID
CHANGEAGENT.ID
FK to CHANGEAGENT.
CHANGEDBYID
AMOUNT
money
0
Amount of money given to this business unit.
DATEADDED
datetime
getdate()
Indicates the date this record was added.
DATECHANGED
Indicates the date this record was last changed.
TS
timestamp
Timestamp.
TSLONG
bigint (Computed)
true
Numeric representation of the timestamp.
REVENUESPLITBUSINESSUNITID
Used by revenue update batch to reference a one-of business unit.
IX_BATCHREVENUEBUSINESSUNIT_DATEADDED
False
True
IX_BATCHREVENUEBUSINESSUNIT_DATECHANGED
PK_BATCHREVENUEBUSINESSUNIT
UIX_BATCHREVENUEBUSINESSUNIT_BATCHREVENUEID_BUSINESSUNITCODEID
TR_BATCHREVENUEBUSINESSUNIT_AUDIT_UPDATE
TR_BATCHREVENUEBUSINESSUNIT_AUDIT_DELETE