Stores a snapshot of relevant stock detail information at the time of an adjustment.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
SALEAMOUNT
|
money
|
false
|
|
The sale amount for the stock sell before the adjustment.
|
|
BROKERFEE
|
money
|
false
|
|
The fees for the stock sell before the adjustment.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
CONSTITUENTIDENTIFIER
|
uniqueidentifier
|
true
|
|
Indicates the ID of the constituent before the adjustment
|
|
NUMBEROFUNITS
|
decimal(20, 3)
|
false
|
|
The number of stock units sold.
|
|
PAYMENTNUMBEROFUNITS
|
decimal(20, 3)
|
false
|
|
The payment's number of units received.
|
|
PAYMENTMEDIANPRICE
|
decimal(19, 4)
|
false
|
|
The payment's median price per share.
|
|
TRANSACTIONSALEAMOUNT
|
money
|
false
|
|
The sale amount for the stock sell in transaction currency before the adjustment.
|
|
TRANSACTIONBROKERFEE
|
money
|
false
|
|
The fees for the stock sell in transaction currency before the adjustment.
|
|
TRANSACTIONPAYMENTMEDIANPRICE
|
decimal(19, 4)
|
false
|
|
The payment's median price per share in transaction currency.
|
|
ORGANIZATIONSALEAMOUNT
|
money
|
false
|
|
The sale amount for the stock sell in organization currency before the adjustment.
|
|
ORGANIZATIONBROKERFEE
|
money
|
false
|
|
The fees for the stock sell in organization currency before the adjustment.
|
|
ORGANIZATIONPAYMENTMEDIANPRICE
|
decimal(19, 4)
|
false
|
|
The payment's median price per share in organization currency.
|
|
BASERATE
|
decimal(20, 8)
|
false
|
|
The rate to used to convert to the base amount.
|
|
ORGANIZATIONRATE
|
decimal(20, 8)
|
false
|
|
The rate to used to convert to the organization amount.
|
