Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 REVENUEIDENTIFIER nvarchar(36)   Default = '' Indicates the revenue detail to which this stream is being applied. Do not join on this field.
 AMOUNT money   Default = 0 Indicates the amount applied to this revenue stream.
 TYPECODE tinyint   Default = 0 Indicates the type of this revenue stream.
 TYPE nvarchar(30)   Default = '' Indicates the type of this revenue stream.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 REVENUECATEGORYCODEIDENTIFIER nvarchar(36)   Default = '00000000-0000-0000-0000-000000000000' Indicates the revenue category of the revenue item before the adjustment.
 REVENUECATEGORYCODETRANSLATION nvarchar(100)   Default = '' Provides a translation of the revenue category code indicated in REVENUECATEGORYCODEIDENTIFIER
 APPLICATIONCODE tinyint   Default = 0 Indicates the application of this revenue stream.
 APPLICATION nvarchar(30)   Default = '' Indicates the application of this revenue stream.
 TRANSACTIONAMOUNT money   Default = 0 Indicates the amount applied to this revenue stream in transaction currency.
 ORGANIZATIONAMOUNT money   Default = 0 Indicates the amount applied to this revenue stream in organization currency.

Foreign Key Field Type Null Notes Description
 ADJUSTMENTHISTORYID uniqueidentifier   ADJUSTMENTHISTORY.ID Indicates the adjustment history item that this snapshot applies to.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_ADJUSTMENTHISTORYREVENUE_DATEADDED DATEADDED    
 IX_ADJUSTMENTHISTORYREVENUE_DATECHANGED DATECHANGED      
 PK_ADJUSTMENTHISTORYREVENUE ID  

Trigger Name Description
 TR_ADJUSTMENTHISTORYREVENUE_AUDIT_UPDATE
 TR_ADJUSTMENTHISTORYREVENUE_AUDIT_DELETE

Entity-Relationship diagram of this table