Ledgers & derived

Accounts ledgers & derived — 8 entities with their key fields and relationships.

Append-only tables written by transactions rather than entered by a user. Never edited directly — they are rebuilt by reposting.

8 entities in Accounts.

Account Closing Balance

Stores aggregated account balances at a closing date so financial reports can begin from a saved closing position instead of replaying all GL Entries.

Naming: hash · 16 fields · 0 inbound refs

Key fields

Relationships

Advance Payment Ledger Entry

Tracks how an advance-payment voucher is linked, valued, or delinked against another voucher.

Naming: hash · 11 fields · 0 inbound refs

Relationships

Bank Account Balance

Stores a bank account’s balance on a specific date for reconciliation and balance history.

Naming: hash · 4 fields · 0 inbound refs

Key fields

Relationships

Bisect Nodes

Stores the date-range nodes used to divide accounting statements and locate periods with balance-sheet and profit-and-loss differences.

Naming: autoincrement · 9 fields · 3 inbound refs

Relationships

GL Entry

Records one debit or credit line posted by a voucher to the general ledger.

Naming: Expression (old style) · 47 fields · 0 inbound refs

Key fields

Relationships

Ledger Health

Records vouchers where automated checks found a debit-credit mismatch or a difference between the general and payment ledgers.

Naming: autoincrement · 5 fields · 0 inbound refs

Relationships

No outgoing relationships.

Loyalty Point Entry

Records loyalty points earned, redeemed, or adjusted for a customer and links them to the originating invoice when applicable.

Naming: hash · 12 fields · 1 inbound ref

Key fields

Relationships

Payment Ledger Entry

Records receivable or payable amounts and their allocation between vouchers, providing the ledger used for outstanding balances.

Naming: hash · 20 fields · 0 inbound refs

Key fields

Relationships