ores.refdata.book

UUID uniquely identifying this book.

Surrogate key for the book record.

Party that owns this book.

References the parties table.

ctx.generate_uuid()

Book name, unique within party.

e.g., 'FXO_EUR_VOL_01'.

std::string("BOOK_") + std::to_string(faker::number::integer(1, 999))

Optional free-text description of the book.

std::string(faker::lorem::sentence())

Links to exactly one portfolio.

Mandatory: Every book must belong to a portfolio.

ctx.generate_uuid()

Business unit that owns this book.

Optional FK to business_units. Should reference a unit that is an owner_unit_id in the book's portfolio ancestry chain.

std::nullopt

Functional/accounting currency, designated by the ledger.

ISO 4217 currency code.

// X-0 is the sentinel code the eventing integration fixture seeds
// before writing this row: the functional-currency trigger accepts only
// codes of active currencies for the write tenant, so no fixed code is
// valid on its own and the seed must come first. A caller that does not
// seed it must overwrite this with a code it has written, or the insert
// is rejected.
std::string("X-0")

Reference to external General Ledger.

e.g., 'GL-10150-FXO'. Nullable if not integrated.

std::string("GL-10150-TEST")

Internal finance code for P&L attribution.

Links to cost center in finance system.

std::string("CC-001")

Lifecycle status of the book.

References book_statuses lookup (Active, Closed, Frozen). Defaults to Active so a freshly-constructed book (the Add dialog, before the Status combo's async populate completes) always carries a value the FK-validation trigger accepts.

std::string("Active")

Basel III/IV FRTB trading book / banking book classification.

References regulatory_book_types lookup (Trading, Banking). Defaults to Trading for the same reason book_status defaults to Active.

std::string("Trading")

Whether this book is eligible for spot-sweep transfers to the designated Sweep target book – independent of ledger_feed_type and book_purpose_type; see Book classification.

false

Rates centre determining which revaluation market data snapshot this book uses at end-of-day; see Book groups and rates centres.

Soft FK to business_centres by code (e.g. "GBLO", "USNY"), reusing the same location reference already used by counterparty/party/business_unit rather than modeling a dedicated rates-centre entity. Defaults to WRLD (the global sentinel business centre, seeded for every tenant) for the same reason book_status defaults to Active – a freshly-constructed book always carries a value the FK-validation trigger accepts.

std::string("WRLD")