Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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
 TRANSACTIONTYPE nvarchar(6) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Debit' WHEN 1 THEN N'Credit' END Provides a translation for the 'TRANSACTIONTYPECODE' field.
 TYPECODE tinyint   Default = 0 Indicates if this distribution is part of the reversal or the adjustment.
 TYPE nvarchar(10) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Reversal' WHEN 1 THEN N'Adjustment' END Provides a translation for the 'TYPECODE' 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
 ADJUSTMENTHISTORYWRITEOFFID uniqueidentifier   ADJUSTMENTHISTORYWRITEOFF.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_ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION_DATEADDED DATEADDED    
 IX_ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION_DATECHANGED DATECHANGED      
 PK_ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION ID  

Trigger Name Description
 TR_ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION_AUDIT_UPDATE
 TR_ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION_AUDIT_DELETE

Entity-Relationship diagram of this table