Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SALEAMOUNT money   Default = 0 The sale amount for the stock sell before the adjustment.
 BROKERFEE money   Default = 0 The fees for the stock sell 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
 TRANSACTIONSALEAMOUNT money   Default = 0 The sale amount for the stock sell in transaction currency before the adjustment.
 TRANSACTIONBROKERFEE money   Default = 0 The fees for the stock sell in transaction currency before the adjustment.
 ORGANIZATIONSALEAMOUNT money   Default = 0 The sale amount for the stock sell in organization currency before the adjustment.
 ORGANIZATIONBROKERFEE money   Default = 0 The fees for the stock sell in organization currency before the adjustment.
 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   ADJUSTMENTHISTORYPROPERTY.ID Primary Key.
 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_ADJUSTMENTHISTORYPROPERTYSNAPSHOT_DATEADDED DATEADDED    
 IX_ADJUSTMENTHISTORYPROPERTYSNAPSHOT_DATECHANGED DATECHANGED      
 PK_ADJUSTMENTHISTORYPROPERTYSNAPSHOT ID  

Trigger Name Description
 TR_ADJUSTMENTHISTORYPROPERTYSNAPSHOT_AUDIT_UPDATE
 TR_ADJUSTMENTHISTORYPROPERTYSNAPSHOT_AUDIT_DELETE

Entity-Relationship diagram of this table