Trade

FIBO-grounded class definition for this concept: properties, multiplicities, and source-column annotations. Per-dataset Mapping and Table blocks live on each dataset's Pure Model tab.

<<Lineage.parquetBacked>>
{Lineage.parquetPath = 'out/parquet/trade/**/*.parquet', Lineage.fiboModule = 'FBC', Lineage.fiboConcept = 'Trade', Lineage.datasetTitle = 'Trades'}
// Booked trades in accounts — the canonical post-allocation record used for position keeping and accounting.
Class fibo::fbc::Trade
{
    // TradeIdentifier: Internal surrogate key for a booked trade.
    tradeId : Integer[1];
    // AllocationIdentifier: Internal surrogate key for an allocation.
    allocationId : Integer[0..1];
    // AccountIdentifier: Internal surrogate key uniquely identifying an account within this system.
    accountId : Integer[1];
    // InstrumentSurrogateID: Internal surrogate key uniquely identifying a financial instrument within this system. External identifiers (ISIN, CUSIP, FIGI) live in instrument_identifier.
    instrumentId : Integer[1];
    // OrderSide: Direction of the order (buy, sell, short sell, cover).
    side : String[1];
    // Quantity: Number of units (shares, contracts, face value) held or traded.
    quantity : Decimal[1];
    // ExecutedPrice: Price at which an execution actually occurred.
    price : Decimal[1];
    // ISO4217CurrencyCode: Three-letter code (e.g., USD, EUR, JPY) that uniquely identifies a currency under ISO 4217.
    currencyCode : String[1];
    // TradeDate: Date on which a trade was executed.
    tradeDate : StrictDate[1];
    // SettlementDate: Date on which cash and securities exchange hands to complete a trade (commonly T+1 or T+2 for equities).
    settlementDate : StrictDate[1];
    // Counterparty: The other party to a financial contract or trade.
    counterpartyLei : String[0..1];
    // GrossAmount: Trade quantity × price, before commissions and fees.
    grossAmount : Decimal[1];
    // NetAmount: Gross amount adjusted for commissions and fees — the cash that actually moves between accounts.
    netAmount : Decimal[1];
    // Commission: Fee paid to a broker for executing a trade.
    commission : Decimal[0..1];
    // Fees: Other transaction costs charged by venues, regulators, or clearing houses.
    fees : Decimal[0..1];
}