Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TYPECODE tinyint   Default = 0 Indicates if this distribution is part of the reversal or the adjustment.
 PROJECT nvarchar(100)   Default = '' Indicates the project for this distribution.
 REFERENCE nvarchar(255)   Default = '' Indicates the reference for this distribution.
 AMOUNT money   Default = 0 Indicates the amount for this distribution.
 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.
 ACCOUNT nvarchar(100)   Default = '' Indicates the account for this distribution.
 TRANSACTIONTYPECODE tinyint   Default = 0 The transaction type (debit or credit) for the record
 TYPE nvarchar(10) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Reversal' WHEN 1 THEN N'Adjustment' END Provides a translation for the 'TYPECODE' field.
 TRANSACTIONTYPE nvarchar(6) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Debit' WHEN 1 THEN N'Credit' END Provides a translation for the 'TRANSACTIONTYPECODE' field.
 TRANSACTIONAMOUNT money   Default = 0 Indicates the amount for this distribution in transaction currency.
 ORGANIZATIONAMOUNT money   Default = 0 Indicates the amount for this distribution in organization currency.

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

Index Name Field(s) Unique Primary Clustered
 IX_ADJUSTMENTHISTORYDISTRIBUTION_DATEADDED DATEADDED    
 IX_ADJUSTMENTHISTORYDISTRIBUTION_DATECHANGED DATECHANGED      
 PK_ADJUSTMENTHISTORYDISTRIBUTION ID  

Trigger Name Description
 TR_ADJUSTMENTHISTORYDISTRIBUTION_AUDIT_UPDATE
 TR_ADJUSTMENTHISTORYDISTRIBUTION_AUDIT_DELETE

Entity-Relationship diagram of this table