Ledger Transaction

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/ledger_transaction/**/*.parquet', Lineage.fiboModule = 'FBC', Lineage.fiboConcept = 'LedgerTransaction', Lineage.datasetTitle = 'Ledger Transactions'}
// Books-of-record cash entries posted to accounts: trades, fees, dividends, interest, subscriptions, redemptions, FX, corporate actions.
Class fibo::fbc::LedgerTransaction
{
    // TransactionIdentifier: Internal surrogate key for a ledger transaction.
    transactionId : Integer[1];
    // PostingDate: The date a transaction is recorded against an account in the books of record.
    postingDate : StrictDate[1];
    // AccountIdentifier: Internal surrogate key uniquely identifying an account within this system.
    accountId : Integer[1];
    // TransactionType: Kind of ledger entry (TRADE_BUY, TRADE_SELL, DIVIDEND, INTEREST, FEE_BROKER, FEE_MGMT, FX, SUBSCRIPTION, REDEMPTION, CORPORATE_ACTION).
    transactionType : String[1];
    // GrossAmount: Trade quantity × price, before commissions and fees.
    amount : Decimal[1];
    // ISO4217CurrencyCode: Three-letter code (e.g., USD, EUR, JPY) that uniquely identifies a currency under ISO 4217.
    currencyCode : String[1];
    // ReferenceTable: Name of the source table the ledger entry references (trade, corporate_action_event, subscription).
    referenceTable : String[0..1];
    // ReferenceID: Identifier in the referenced source table.
    referenceId : Integer[0..1];
    // Description: Free-text human-readable label for the record.
    description : String[0..1];
}