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 first code the synthetic currency generator emits (see
// the currency entity's own generator): the functional-currency
// validation only accepts codes of active currencies, and every test
// tenant inherits the system tenant's accumulated active set, which
// always contains X-0 -- every generator process starts its counter at
// zero, so X-0 is present whenever any synthetic currency exists.
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")