Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ADJUSTEDFIELD nvarchar(100)   Default = '' Indicates the field that caused the adjustment.
 ADJUSTEDFIELDPREVIOUSVALUE nvarchar(max)   Default = '' Indicates the value of the adjusted field before the adjustment.
 ADJUSTEDFIELDADJUSTEDVALUE nvarchar(max)   Default = '' Indicates the value of the adjusted field after 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.
 ISMONEY bit   Default = 0 Indicates whether or not the adjustment was for a monetary value.
 ADJUSTEDFIELDPREVIOUSMONEYVALUE money   Default = 0 Indicates the value of the adjusted money field before the adjustment.
 ADJUSTEDFIELDADJUSTEDMONEYVALUE money   Default = 0 Indicates the value of the adjusted money field after the adjustment.
 TRANSACTIONADJUSTEDFIELDPREVIOUSVALUE nvarchar(max)   Default = '' Indicates the value of the adjusted field before the adjustment in transaction currency.
 TRANSACTIONADJUSTEDFIELDADJUSTEDVALUE nvarchar(max)   Default = '' Indicates the value of the adjusted field after the adjustment in transaction currency.
 TRANSACTIONADJUSTEDFIELDPREVIOUSMONEYVALUE money   Default = 0 Indicates the value of the adjusted money field before the adjustment in transaction currency.
 TRANSACTIONADJUSTEDFIELDADJUSTEDMONEYVALUE money   Default = 0 Indicates the value of the adjusted money field after the adjustment in transaction currency.
 ORGANIZATIONADJUSTEDFIELDPREVIOUSVALUE nvarchar(max)   Default = '' Indicates the value of the adjusted field before the adjustment in organization currency.
 ORGANIZATIONADJUSTEDFIELDADJUSTEDVALUE nvarchar(max)   Default = '' Indicates the value of the adjusted field after the adjustment in organization currency.
 ORGANIZATIONADJUSTEDFIELDPREVIOUSMONEYVALUE money   Default = 0 Indicates the value of the adjusted money field before the adjustment in organization currency.
 ORGANIZATIONADJUSTEDFIELDADJUSTEDMONEYVALUE money   Default = 0 Indicates the value of the adjusted money field after the adjustment in organization currency.

Foreign Key Field Type Null Notes Description
 ADJUSTMENTHISTORYID uniqueidentifier   ADJUSTMENTHISTORY.ID Indicates the history item to which this detail belongs.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this adjustment.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this adjustment.

Index Name Field(s) Unique Primary Clustered
 IX_ADJUSTMENTHISTORYDETAIL_DATEADDED DATEADDED    
 IX_ADJUSTMENTHISTORYDETAIL_DATECHANGED DATECHANGED      
 PK_ADJUSTMENTHISTORYDETAIL ID  

Trigger Name Description
 TR_ADJUSTMENTHISTORYDETAIL_AUDIT_UPDATE
 TR_ADJUSTMENTHISTORYDETAIL_AUDIT_DELETE

Entity-Relationship diagram of this table