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
 NUMBEROFUNITS decimal(20, 3)   Default = 0 The number of stock units sold.
 PAYMENTNUMBEROFUNITS decimal(20, 3)   Default = 0 The payment's number of units received.
 PAYMENTMEDIANPRICE decimal(19, 4)   Default = 0 The payment's median price per share.
 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.
 TRANSACTIONPAYMENTMEDIANPRICE decimal(19, 4)   Default = 0 The payment's median price per share in transaction currency.
 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.
 ORGANIZATIONPAYMENTMEDIANPRICE decimal(19, 4)   Default = 0 The payment's median price per share 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   ADJUSTMENTHISTORYSTOCK.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_ADJUSTMENTHISTORYSTOCKSNAPSHOT_DATEADDED DATEADDED    
 IX_ADJUSTMENTHISTORYSTOCKSNAPSHOT_DATECHANGED DATECHANGED      
 PK_ADJUSTMENTHISTORYSTOCKSNAPSHOT ID  

Trigger Name Description
 TR_ADJUSTMENTHISTORYSTOCKSNAPSHOT_AUDIT_UPDATE
 TR_ADJUSTMENTHISTORYSTOCKSNAPSHOT_AUDIT_DELETE

Entity-Relationship diagram of this table