Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 AMOUNT money   Default = 0 The total amount of the revenue item before the adjustment.
 PAYMENTMETHODCODE tinyint   Default = 0 Indicates the payment method of the revenue item before the adjustment.
 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.
 CONSTITUENTIDENTIFIER uniqueidentifier Indicates the ID of the constituent before the adjustment
 TRANSACTIONAMOUNT money   Default = 0 The total amount of the revenue item before the adjustment in transaction currency.
 ORGANIZATIONAMOUNT money   Default = 0 The total amount of the revenue item before the adjustment in organization currency.
 BASERATE decimal(20, 8)   Default = 0 The rate to used to convert to the base amount.
 ORGANIZATIONRATE decimal(20, 8)   Default = 0 The rate to used to convert to the organization amount.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   ADJUSTMENTHISTORY.ID Primary Key.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_ADJUSTMENTHISTORYREVENUETRANSACTION_DATEADDED DATEADDED    
 IX_ADJUSTMENTHISTORYREVENUETRANSACTION_DATECHANGED DATECHANGED      
 PK_ADJUSTMENTHISTORYREVENUETRANSACTION ID  

Trigger Name Description
 TR_ADJUSTMENTHISTORYREVENUETRANSACTION_AUDIT_UPDATE
 TR_ADJUSTMENTHISTORYREVENUETRANSACTION_AUDIT_DELETE

Entity-Relationship diagram of this table