Data model

Explore the records and relationships behind your ledger, from source documents to group reporting.

57 tables · 357 relationships

How the model is organised

Currency masters

currencies, rate types and dated rates, historical equity rates, entity functional and reporting currencies, and currency-specific bank accounts. Posted documents retain the rates they used, and corrections preserve the earlier evidence.

Entities
Currencies
ExchangeRates
HistoricalRates
Contacts
ContactBankAccounts
Employees
TaxCodes
TaxJurisdictions
FixedAssetCategories
DepreciationMethods
BudgetVersions
CostCenters
CloseTaskTemplates
RevaluationSettlements

Ledger masters

the chart, entity periods, cost centres, tax configuration, fixed-asset categories, budget versions, contacts and employee authority. Approval limits have an explicit currency and entity scope.

Entities
Currencies
ExchangeRates
HistoricalRates
Contacts
ContactBankAccounts
Employees
TaxCodes
TaxJurisdictions
FixedAssetCategories
DepreciationMethods
BudgetVersions
CostCenters
CloseTaskTemplates
RevaluationSettlements

Subledger transactions

invoices, credit memos, bills, receipts and payments. Application evidence separates document currency from receipt or payment currency and retains the functional carrying value released, including the applicable revaluation allocation.

Intercompany

transactions with a posting period and functional-currency value for each entity, plus the group reporting context. Agreed balances and reviewed adjustments support consolidation.

transactions with a posting period
functional-currency value for each entity
plus the group reporting context

Banking

statements and their matched movements, account reconciliations and transfers. Receipt posting and later allocation are separate events, while returns and corrections retain their reversals.

statements
their matched movements
account reconciliations
transfers

Period-end runs

revaluation, depreciation, allocations, consolidation, tax filings and close tasks. Supporting item-level workings, approval evidence and posted journals remain linked to the run.

revaluation
depreciation
allocations
consolidation
tax filings
close tasks

Journals

entries and lines from approved source transactions and manual adjustments. Foreign amount, applied rate and functional value remain traceable to the originating document or calculation.

entries
lines from approved source transactions
manual adjustments

Keys and references

Stable identifiers connect records; human numbers follow the entity’s configured sequences. Rate evidence records the pair, direction, type and effective date. A cash application retains the amount used from the payment separately from the amount cleared on the invoice or bill, so balances are never subtracted across currencies. Posted journals are corrected through reviewed reversal or adjustment entries.

Migration order

Currencies, the chart and entity structure. Resolve the entity's functional currency and account references in a controlled second pass where the masters refer to each other.
Entity accounting periods, group-period mappings, currency rate history and historical equity rates, once their currencies, entities and accounts exist.
Bank accounts, cost centres, tax configuration, asset categories and methods, close templates, employees, entity access and approval limits.
Contacts and currency-specific bank details, with verification evidence and the agreed approval process.
Prepare a cutover schedule of the full trial balance, original foreign balances, carrying values, accumulated revaluation, unapplied cash and outstanding documents. Agree the opening journal and nonposting open-item import before loading amounts.
Import open invoices and bills without posting, linked by migration batch to the opening journal that already contains their control balances. Retain original foreign amounts and allocated revaluation so each current carrying value reconciles. Confirm every control account and foreign balance before accepting the import.
Load assets and accumulated depreciation, matched intercompany positions, approved budget versions and any remaining opening items under the same reconciliation plan. Validate the first revaluation and settlement against the signed cutover schedule before live use.

Tables

Find a table 57 tables

EntitiesLegal entities consolidated under a reporting parent, plus the groupmaster

Field	Type	Required	Details
`EntityCode`	text	yes
`Name`	text	yes
`EntityType`	select	yes	Parent, Subsidiary, Branch, JointVenture, Group (consolidation unit; no bank accounts, no subledgers)
`FunctionalCurrency`	reference	yes	→ Currencies
`ReportingCurrency`	reference	yes	→ Currencies
`ParentEntity`	reference		→ Entities (self)
`OwnershipPercent`	number		0–100, held by the parent
`ConsolidationMethod`	select		Full, Equity, Proportional (local GAAP where permitted)
`TaxID`	text
`Jurisdiction`	reference		→ TaxJurisdictions
`RealisedGainLossAccount`	reference	yes	→ ChartOfAccounts
`UnrealisedGainLossAccount`	reference	yes	→ ChartOfAccounts
`TranslationAdjustmentAccount`	reference		→ ChartOfAccounts (CTA, on the Group unit)
`NonControllingInterestAccount`	reference		→ ChartOfAccounts (Group unit)
`EffectiveFrom`	date	yes
`EffectiveTo`	date
`Active`	boolean	yes
`UnappliedCashAccount`	reference	yes	→ ChartOfAccounts (customer receipts held as a monetary credit balance until allocated)
`WithholdingReceivableAccount`	reference	yes	→ ChartOfAccounts (customer withholding supported by evidence)
`PaymentClearingAccount`	reference	yes	→ ChartOfAccounts (released payments and bank transfers)
`RevaluationMethod`	select	yes	ReverseNextPeriod, Delta; changing method requires cleared adjustments and Controller approval

CurrenciesISO currency codes used anywhere in the platform, with the precision eachmaster

Field	Type	Required	Details
`Code`	text	yes	ISO 4217, e.g. USD, EUR, JPY
`Name`	text	yes
`Symbol`	text
`DecimalPlaces`	number	yes	2 by default, 0 for JPY, 3 for KWD
`RoundingAccount`	reference		→ ChartOfAccounts (rounding differences on conversion)
`Active`	boolean	yes

ExchangeRatesDated rates by type. Spot converts documents on the day, Closing revaluesmaster

Field	Type	Required	Details
`FromCurrency`	reference	yes	→ Currencies
`ToCurrency`	reference	yes	→ Currencies
`RateType`	select	yes	Spot, Average, Closing, Budget
`EffectiveDate`	date	yes
`Rate`	decimal	yes	Positive; 1 FromCurrency = Rate ToCurrency; same-currency rate is 1
`Source`	select	yes	ECB, OANDA, CentralBank, Manual, Integration
`EnteredBy`	reference		→ Employees (manual rates)
`Locked`	boolean	yes	Frozen once any posted document, revaluation or consolidation uses it; corrections create a new version
`RateVersion`	number	yes	Increasing within currency pair, type and effective date
`ApprovedBy`	reference		→ Employees (Controller for manual or corrected closing rates; not EnteredBy)
`ApprovedAt`	datetime		Required before an approved rate can be selected
`SourceReference`	text		Provider observation or reviewed manual-rate evidence
`Supersedes`	reference		→ ExchangeRates (corrected version; original retained)

HistoricalRatesThe rate at which an equity or investment balance was originallymaster

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities
`Account`	reference	yes	→ ChartOfAccounts
`EffectiveDate`	date	yes	Date of the transaction that created the balance
`Amount`	decimal	yes	Functional-currency amount translated at this rate
`Rate`	decimal	yes	Functional to reporting currency
`Source`	select	yes	Transaction, Migration, Manual
`EnteredBy`	reference		→ Employees
`Locked`	boolean	yes	Frozen once a locked consolidation has used it
`SourceReference`	text	yes	Original equity movement or approved migration workpaper
`ApprovedBy`	reference		→ Employees (Controller other than EnteredBy)
`ApprovedAt`	datetime		Required for a manual or migration rate before use

ChartOfAccountsThe account master. Self-parenting tree for summary roll-ups; flagsmaster

Field	Type	Required	Details
`AccountCode`	text	yes
`AccountName`	text	yes
`AccountType`	select	yes	Asset, Liability, Equity, Revenue, Expense
`AccountSubType`	select		CurrentAsset, FixedAsset, CurrentLiability, LongTermLiability, COGS, OperatingExpense, OtherIncome, OtherExpense
`ParentAccount`	reference		→ ChartOfAccounts (self)
`NormalBalance`	select	yes	Debit, Credit
`IsControl`	boolean	yes	Subledger-controlled; no direct manual posting
`Currency`	reference		→ Currencies (fixed-currency accounts such as a EUR bank account)
`Revalue`	boolean	yes	Monetary account revalued at period end
`TranslationRateType`	select		Closing, Average, Historical, TransactionDate; applied under the reviewed reporting policy
`Active`	boolean	yes

AccountingPeriodsFiscal periods per entity with open and close state, the date whosemaster

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities
`PeriodName`	text	yes	e.g. FY26-04, FY26-13 for the adjustment period
`PeriodType`	select	yes	Month, Quarter, Year, Adjustment
`StartDate`	date	yes
`EndDate`	date	yes
`Status`	select	yes	Future, Open, SoftClose, HardClose, Archived
`ClosingRateDate`	date		Date whose Closing rates revalue and translate this period
`ClosedBy`	reference		→ Employees
`ClosedAt`	datetime
`ReopenedBy`	reference		→ Employees (Admin break-glass, HardClose → Open)
`ReopenedAt`	datetime
`ReopenReason`	text
`PostingRevision`	number	yes	Increments on each posted or reversed journal; close and consolidation freeze this value
`ClosingBinder`	attachment		Frozen workpaper package at HardClose
`CloseDecision`	reference		→ ApprovalDecisions

ContactsCustomers and vendors. Type distinguishes them; Both is allowed when amaster

Field	Type	Required	Details
`ContactNumber`	text	yes
`Name`	text	yes
`Type`	select	yes	Customer, Vendor, Both
`Entity`	reference		→ Entities (billing entity)
`PaymentTerms`	select		Prepaid, Net7, Net15, Net30, Net45, Net60, Net90
`Currency`	reference		→ Currencies (default document currency)
`TaxID`	text
`DefaultTaxCode`	reference		→ TaxCodes
`WithholdingTaxCode`	reference		→ TaxCodes (TaxType Withholding; deducted on receipt or payment)
`Jurisdiction`	reference		→ TaxJurisdictions
`CustomerGroup`	select		Standard, KeyAccount, Intercompany, NoDunning (dunning rule per group)
`VendorClass`	select		Goods, Services, Freight, Utilities, Government
`Email`	text
`Phone`	text
`BillingAddress`	text
`ShippingAddress`	text
`CreditLimit`	decimal		Customer only, in the contact's currency
`Active`	boolean	yes

ContactBankAccountsBank accounts a vendor is paid into or a customer refunded to, one per Line item of Contacts.line item

Field	Type	Required	Details
`BankName`	text	yes
`Country`	text	yes
`Currency`	reference	yes	→ Currencies
`IBAN`	text
`SWIFT`	text
`AccountNumber`	text		Where IBAN is not used
`IsDefault`	boolean	yes	Default account for this currency
`Verified`	boolean	yes	Confirmed with the vendor by call-back before first use
`VerifiedBy`	reference		→ Employees
`VerifiedAt`	date
`Contact`	reference	yes	→ Contacts
`Revision`	number	yes	Changing payment coordinates creates a new revision and clears Verified
`EnteredBy`	reference	yes	→ Employees
`VerificationEvidence`	attachment		Independent callback or equivalent approved verification
`VerifiedRevision`	number		Must equal Revision; VerifiedBy must differ from EnteredBy

EmployeesFinance users: Controller, GL accountants, Treasury Analyst, AP and ARmaster

Field	Type	Required	Details
`EmployeeID`	text	yes
`FullName`	text	yes
`Email`	text	yes
`Role`	select	yes	Admin, Controller, GLAccountant, TreasuryAnalyst, APClerk, ARClerk, FPAAnalyst, TaxSpecialist, Auditor
`Entity`	reference		→ Entities (home entity)
`Manager`	reference		→ Employees (self)
`ApprovalLimit`	decimal		Positive monetary ceiling in ApprovalLimitCurrency; missing limit cannot authorise a monetary decision
`ApprovalLimitCurrency`	reference		→ Currencies (limit compared after conversion)
`Active`	boolean	yes

BankAccountsBank accounts per entity and currency, each mapped to its GL account. FunctionalBalance is the posted ledger carrying value, including unreversed revaluation; a live-rate exposure value is separate.master

Field	Type	Required	Details
`BankAccountNumber`	text	yes	Internal code
`Name`	text	yes
`Entity`	reference	yes	→ Entities
`Currency`	reference	yes	→ Currencies
`GLAccount`	reference	yes	→ ChartOfAccounts
`BankName`	text	yes
`IBAN`	text
`SWIFT`	text
`AccountType`	select	yes	Operating, Collections, Payroll, Savings, Lockbox
`StatementFeed`	select	yes	BankAPI, CSV, Manual
`LedgerBalance`	decimal	yes	Account currency; rollup of foreign amounts on the GL account
`FunctionalBalance`	decimal	yes	Posted functional-currency debit balance, including unreversed revaluation; not LedgerBalance times a live quote
`Active`	boolean	yes
`ExposureRate`	decimal		Current indicative currency-to-functional rate, with no posting effect
`ExposureValue`	decimal		LedgerBalance × ExposureRate; separate from FunctionalBalance

TaxCodesNamed tax rates applicable to a jurisdiction and a direction.master

Field	Type	Required	Details
`Code`	text	yes
`Name`	text	yes
`Jurisdiction`	reference	yes	→ TaxJurisdictions
`Direction`	select	yes	Sales, Purchase, Both
`Rate`	number	yes	Percentage, e.g. 8.875
`TaxType`	select	yes	Sales, Use, VAT, GST, Withholding
`RecoverablePercent`	number		For input VAT or GST, default 100
`GLAccount`	reference	yes	→ ChartOfAccounts (tax payable or receivable)
`EffectiveFrom`	date	yes
`EffectiveTo`	date
`Active`	boolean	yes

TaxJurisdictionsTax authorities that levy tax and receive filings, with the currency themaster

Field	Type	Required	Details
`JurisdictionCode`	text	yes
`Name`	text	yes
`Country`	text	yes
`Region`	text		State or province
`FilingCurrency`	reference	yes	→ Currencies
`FilingFrequency`	select	yes	Monthly, Quarterly, SemiAnnual, Annual
`TaxRateSource`	select	yes	AccountingRate, AuthorityRate (published monthly or daily by the authority)
`Active`	boolean	yes

FixedAssetCategoriesAsset categories with default depreciation method and GL accounts.master

Field	Type	Required	Details
`CategoryCode`	text	yes
`Name`	text	yes
`AssetAccount`	reference	yes	→ ChartOfAccounts
`AccumulatedDepreciationAccount`	reference	yes	→ ChartOfAccounts
`DepreciationExpenseAccount`	reference	yes	→ ChartOfAccounts
`DefaultMethod`	reference	yes	→ DepreciationMethods
`DefaultUsefulLifeMonths`	number	yes
`Active`	boolean	yes

DepreciationMethodsNamed depreciation methods used by assets.master

Field	Type	Required	Details
`MethodCode`	text	yes
`Name`	text	yes
`Type`	select	yes	StraightLine, DecliningBalance, DoubleDeclining, UnitsOfProduction, SumOfYearsDigits
`RatePercent`	number		For declining-balance methods
`Convention`	select	yes	HalfMonth, HalfYear, FullMonth, MidQuarter
`Active`	boolean	yes

BudgetVersionsNamed budget revisions: Original, Revised Q2, Forecast Q3. The versionmaster

Field	Type	Required	Details
`VersionCode`	text	yes
`Name`	text	yes
`FiscalYear`	text	yes	e.g. FY26
`Type`	select	yes	Budget, Forecast, Plan
`BudgetRateDate`	date	yes	Date whose Budget rates translate this version
`Status`	select	yes	Draft, Submitted, Locked, Archived
`LockedAt`	date
`LockedBy`	reference		→ Employees
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision

CostCentersDepartments, business units, projects or locations used for allocationmaster

Field	Type	Required	Details
`CostCenterCode`	text	yes
`Name`	text	yes
`Type`	select	yes	Department, Project, BusinessUnit, Location
`Entity`	reference	yes	→ Entities
`Parent`	reference		→ CostCenters (self)
`Manager`	reference		→ Employees
`Active`	boolean	yes

CloseTaskTemplatesThe close checklist template per entity. Opening a period generates onemaster

Field	Type	Required	Details
`TemplateCode`	text	yes
`Entity`	reference	yes	→ Entities
`Name`	text	yes
`Category`	select	yes	Subledger, Reconciliation, Accrual, Allocation, Depreciation, Revaluation, Intercompany, Tax, Consolidation, Reporting, Signoff
`DefaultOwnerRole`	select	yes	Controller, GLAccountant, TreasuryAnalyst, APClerk, ARClerk, FPAAnalyst, TaxSpecialist
`DaysAfterPeriodEnd`	number	yes	Working days; sets the DueDate
`DependsOnTemplate`	reference		→ CloseTaskTemplates (self)
`Active`	boolean	yes

JournalEntriesGL journal entries: manual, subledger-posted, recurring, reversing,transaction

Field	Type	Required	Details
`JournalEntryNumber`	text	yes
`Entity`	reference	yes	→ Entities
`Period`	reference	yes	→ AccountingPeriods
`Date`	date	yes
`Description`	text	yes
`EntryType`	select	yes	Standard, Adjusting, Closing, Reversing, Recurring, Revaluation, Elimination, Consolidation
`Source`	select	yes	Manual, AR, AP, FixedAssets, Depreciation, Allocation, Revaluation, Intercompany, Consolidation, Tax, Bank, Payroll
`Status`	select	yes	Draft, PendingApproval, Posted, Reversed, Rejected
`Currency`	reference	yes	→ Currencies (header transaction currency; functional currency for a mixed-currency clearing journal)
`RateType`	select	yes	Spot, Average, Closing, Historical
`ExchangeRate`	decimal	yes	Header currency to functional; each mixed-currency line retains its own currency and rate
`OriginalExchangeRate`	decimal		Rate proposed by rule, kept when overridden
`RateOverriddenBy`	reference		→ Employees
`RateOverrideReason`	text
`TotalDebit`	decimal	yes	Functional currency; sum of line debits
`TotalCredit`	decimal	yes	Functional currency; sum of line credits
`ReferenceType`	select		Bill, Invoice, Payment, PayRun, BankTransfer, DepreciationRun, AllocationRun, RevaluationRun, IntercompanyTransaction, ConsolidationRun, TaxFiling, Manual
`ReferenceID`	text
`PreparedBy`	reference	yes	→ Employees
`ApprovedBy`	reference		→ Employees (must differ from PreparedBy)
`PostedBy`	reference		→ Employees
`PostedAt`	date
`ReversalOf`	reference		→ JournalEntries (self)
`AutoReverseOn`	date		Approved date in the next eligible entity period; required reversals post before new-period transactions
`PostingKey`	text	yes	Unique entity + source record + business event + revision; retries return the existing journal
`SourceRevision`	number	yes	Immutable approved revision posted
`ApprovalDecision`	reference		→ ApprovalDecisions
`RateOverride`	reference		→ RateOverrides
`MigrationBatch`	text		Opening-balance batch whose control-account totals reconcile imported open items

JournalEntryLinesDebits and credits in functional currency, with the transaction-currency Line item of JournalEntries.line item

Field	Type	Required	Details
`LineNumber`	number	yes
`Account`	reference	yes	→ ChartOfAccounts
`CostCenter`	reference		→ CostCenters
`Description`	text
`ForeignCurrency`	reference		→ Currencies (when it differs from functional)
`ForeignDebit`	decimal		Transaction-currency amount
`ForeignCredit`	decimal		Transaction-currency amount
`ExchangeRate`	decimal	yes	Source valuation rate for the line: recognition rate or current carrying amount per foreign unit on clearing; computed carrying ratios are not manual market-rate overrides
`Debit`	decimal	yes	Functional currency; 0 on a credit line
`Credit`	decimal	yes	Functional currency; 0 on a debit line
`TaxCode`	reference		→ TaxCodes
`CounterpartyEntity`	reference		→ Entities (intercompany lines)
`JournalEntry`	reference	yes	→ JournalEntries
`RateOverride`	reference		→ RateOverrides (required for an authorised deviation from the applicable line rate)

InvoicesCustomer invoices and credit memos raised in the customer's currency andtransaction

Field	Type	Required	Details
`InvoiceNumber`	text	yes
`DocumentType`	select	yes	Invoice, CreditMemo
`CreditedInvoice`	reference		→ Invoices (self; CreditMemo only)
`Entity`	reference	yes	→ Entities (billing entity)
`Customer`	reference	yes	→ Contacts (Type IN Customer, Both)
`InvoiceDate`	date	yes
`DueDate`	date	yes
`Period`	reference	yes	→ AccountingPeriods
`Currency`	reference	yes	→ Currencies (transaction currency)
`RateType`	select	yes	Spot, Contract (rate fixed by agreement with the customer)
`ExchangeRate`	decimal	yes	Transaction to functional at InvoiceDate
`OriginalExchangeRate`	decimal		Rate proposed by rule, kept when overridden
`RateOverriddenBy`	reference		→ Employees
`RateOverrideReason`	text
`Status`	select	yes	Draft, PendingApproval, Posted, Sent, PartiallyPaid, Paid, Void, WrittenOff
`Subtotal`	decimal	yes	Sum of InvoiceItems.LineTotal
`TaxTotal`	decimal	yes	Sum of InvoiceItems.TaxAmount
`TotalAmount`	decimal	yes	Subtotal + TaxTotal, transaction currency
`FunctionalTotal`	decimal	yes	TotalAmount × ExchangeRate
`AmountPaid`	decimal	yes	Active posted cash/withholding applications in document currency; reversed applications excluded
`AmountOutstanding`	decimal	yes	Invoice/Bill: TotalAmount − AmountPaid − AmountCredited; credit document: TotalAmount − AmountCredited. Credit amounts are positive magnitudes; posting direction follows DocumentType.
`Disputed`	boolean	yes	Excluded from dunning while set
`DunningLevel`	number		Last reminder step sent
`SourceOrder`	text		CRM or order-management reference
`Terms`	select	yes	Prepaid, Net7, Net15, Net30, Net45, Net60, Net90
`EnteredBy`	reference	yes	→ Employees
`ApprovedBy`	reference		→ Employees (different authorised AR Clerk within converted limit, Controller above it; credit memo decisions retained)
`JournalEntry`	reference		→ JournalEntries (posted on Posted)
`Notes`	text
`AmountCredited`	decimal	yes	Active CreditApplications applied to or from this document, in its currency
`FunctionalOutstanding`	decimal	yes	Remaining original functional basis plus unreversed item revaluation; reconciles to control-account carrying value
`RateOverride`	reference		→ RateOverrides
`ApprovalDecision`	reference		→ ApprovalDecisions
`SourceRevision`	number	yes	Changing amount, rate or terms invalidates pending approval
`MigrationBatch`	text		Opening item linked to a reconciled migration control balance
`OpeningJournal`	reference		→ JournalEntries (opening-balance journal already includes this item's control amount; import creates no duplicate journal)
`WriteOffJournal`	reference		→ JournalEntries (independently approved write-off of current carrying value)
`WriteOffReason`	text		Required before WrittenOff; unsettled original basis and allocated revaluation are derecognised once
`WriteOffDecision`	reference		→ ApprovalDecisions (Controller other than write-off preparer)

InvoiceItemsAR line items with revenue account, cost center and tax in transaction Line item of Invoices.line item

Field	Type	Required	Details
`LineNumber`	number	yes
`Description`	text	yes
`Quantity`	number	yes
`UnitPrice`	decimal	yes	Transaction currency
`LineTotal`	decimal	yes	Quantity × UnitPrice
`RevenueAccount`	reference	yes	→ ChartOfAccounts
`CostCenter`	reference		→ CostCenters
`TaxCode`	reference		→ TaxCodes
`TaxAmount`	decimal	yes	LineTotal × TaxCode.Rate ÷ 100, transaction currency
`TaxExchangeRate`	decimal		Rate the tax authority prescribes; equals the document rate when the jurisdiction uses the accounting rate
`TaxRateSource`	select		AccountingRate, AuthorityRate, Manual
`TaxAmountFunctional`	decimal	yes	TaxAmount × the document accounting ExchangeRate for the GL; authority-reporting valuation is retained separately
`TaxAmountAuthority`	decimal		TaxAmount × TaxExchangeRate in functional-equivalent terms for the authority report; no automatic GL posting
`TaxConversionDifference`	decimal		TaxAmountAuthority − TaxAmountFunctional; reviewed filing adjustment if required, never automatically treated as rounding

PaymentsReceivedCustomer receipts in the currency they arrived in, applied to opentransaction

Field	Type	Required	Details
`PaymentNumber`	text	yes
`Entity`	reference	yes	→ Entities
`Customer`	reference		→ Contacts (optional until applied, for receipts created from a statement line)
`PaymentDate`	date	yes
`Period`	reference	yes	→ AccountingPeriods
`Method`	select	yes	ACH, SEPA, Wire, Check, Card, Cash, Other
`Currency`	reference	yes	→ Currencies (currency received)
`Amount`	decimal	yes	Currency received
`ExchangeRate`	decimal	yes	Received currency to functional at PaymentDate
`OriginalExchangeRate`	decimal		Rate proposed by rule, kept when overridden
`RateOverriddenBy`	reference		→ Employees
`RateOverrideReason`	text
`FunctionalAmount`	decimal	yes	Amount × ExchangeRate
`WithholdingTaxCode`	reference		→ TaxCodes
`WithholdingTaxAmount`	decimal		Sum of active application withholding converted to receipt currency; not part of cash Amount
`AppliedAmount`	decimal	yes	Sum of active PaymentApplications.ReceiptAmount, in receipt currency only
`UnappliedAmount`	decimal	yes	Amount − AppliedAmount
`RealisedGainLoss`	decimal	yes	Sum of PaymentApplications.RealisedGainLoss; positive is gain
`BankAccount`	reference	yes	→ BankAccounts
`Status`	select	yes	Received, PartiallyApplied, Applied, Unapplied, Reversed
`Reference`	text		Remittance reference
`JournalEntry`	reference		→ JournalEntries (receipt recognition: Bank Dr / unapplied cash Cr before application)
`UnappliedFunctionalAmount`	decimal	yes	Current carrying amount of the unapplied cash liability, including unreversed revaluation
`ReceivedBy`	reference	yes	→ Employees (person or configured bank-import identity)
`RateOverride`	reference		→ RateOverrides
`ReversalEntry`	reference		→ JournalEntries
`ReversalReason`	text		Returned receipt or correction; all dependent applications must reverse first
`BankReference`	text		Unique bank transaction identifier per account; prevents duplicate receipt import

PaymentApplicationsOne posted receipt allocation per invoice. AppliedAmount includes cash and evidenced withholding in invoice currency; ReceiptAmount is only the cash consumed in receipt currency. The journal clears each side's current carrying value, so a prior FX adjustment is never posted again. Line item of PaymentsReceived.line item

Field	Type	Required	Details
`LineNumber`	number	yes
`Invoice`	reference	yes	→ Invoices
`AppliedAmount`	decimal	yes	Positive invoice-currency amount settled, including WithholdingAmount
`InvoiceRate`	decimal	yes	From the invoice
`ReceiptRate`	decimal	yes	Invoice currency to functional at the receipt date: DocumentToReceiptRate × receipt ExchangeRate; retained original settlement-rate evidence
`FunctionalAtInvoiceRate`	decimal	yes	AppliedAmount × InvoiceRate; original basis only, not the carrying amount after revaluation
`FunctionalAtReceiptRate`	decimal	yes	AppliedAmount × ReceiptRate; historical receipt-date value, separate from current ReceiptCarryingAmount
`RealisedGainLoss`	decimal	yes	ReceiptCarryingAmount + WithholdingFunctionalAmount − CarryingAmountSettled; positive gain credits realised FX
`AppliedAt`	datetime	yes
`AppliedBy`	reference	yes	→ Employees (the matcher's service account when automatic)
`PaymentReceived`	reference	yes	→ PaymentsReceived
`ReceiptAmount`	decimal	yes	(AppliedAmount − WithholdingAmount) × DocumentToReceiptRate, rounded in receipt currency
`DocumentToReceiptRate`	decimal	yes	Receipt-currency units per invoice-currency unit; 1 when equal; positive approved rate or actual remittance cross rate
`WithholdingAmount`	decimal	yes	Invoice-currency amount settled by withholding, default 0; requires tax code and evidence
`WithholdingFunctionalAmount`	decimal	yes	WithholdingAmount × WithholdingRate; separate evidenced withholding conversion, not cash
`WithholdingEvidence`	attachment		Required for nonzero withholding
`ReceiptCarryingAmount`	decimal	yes	Current unapplied functional liability released for ReceiptAmount; proportional allocation of its remaining carrying value
`CarryingAmountSettled`	decimal	yes	Original invoice basis settled + RevaluationReleased
`RevaluationReleased`	decimal	yes	Allocated signed change in invoice carrying magnitude from active RevaluationItems; tracking only, no additional P&L entry
`Period`	reference	yes	→ AccountingPeriods (eligible entity posting period containing application date)
`ApplicationDate`	date	yes	Effective posting date; cannot silently backdate into HardClose
`Status`	select	yes	Draft, Posted, Reversed
`JournalEntry`	reference		→ JournalEntries
`ReversalEntry`	reference		→ JournalEntries
`RateOverride`	reference		→ RateOverrides
`WithholdingRate`	decimal	yes	Approved functional-currency units per document-currency unit on the settlement date; 1 for functional-currency documents
`WithholdingRateEvidence`	text		Accounting or required authority-rate source; material differences follow a reviewed tax policy
`WithholdingTaxCode`	reference		→ TaxCodes (required for nonzero withholding; header code is only a default)

BillsVendor bills and vendor credits in the vendor's currency, checked againsttransaction

Field	Type	Required	Details
`BillNumber`	text	yes
`DocumentType`	select	yes	Bill, VendorCredit
`CreditedBill`	reference		→ Bills (self; VendorCredit only)
`Entity`	reference	yes	→ Entities
`Vendor`	reference	yes	→ Contacts (Type IN Vendor, Both)
`VendorInvoiceNumber`	text	yes	Vendor's own number
`BillDate`	date	yes
`DueDate`	date	yes
`Period`	reference	yes	→ AccountingPeriods
`Currency`	reference	yes	→ Currencies (transaction currency)
`RateType`	select	yes	Spot, Contract (rate fixed by agreement with the vendor)
`ExchangeRate`	decimal	yes	Transaction to functional at BillDate
`OriginalExchangeRate`	decimal		Rate proposed by rule, kept when overridden
`RateOverriddenBy`	reference		→ Employees
`RateOverrideReason`	text
`Status`	select	yes	Draft, PendingApproval, Approved, Scheduled, PartiallyPaid, Paid, Disputed, Void
`Subtotal`	decimal	yes	Sum of BillItems.LineTotal
`TaxTotal`	decimal	yes	Sum of BillItems.TaxAmount
`TotalAmount`	decimal	yes	Subtotal + TaxTotal, transaction currency
`FunctionalTotal`	decimal	yes	TotalAmount × ExchangeRate
`AmountPaid`	decimal	yes	Active posted cash/withholding applications in document currency; reversed applications excluded
`AmountOutstanding`	decimal	yes	Invoice/Bill: TotalAmount − AmountPaid − AmountCredited; credit document: TotalAmount − AmountCredited. Credit amounts are positive magnitudes; posting direction follows DocumentType.
`PurchaseOrderReference`	text		Order number in the procurement system
`ReceiptReference`	text		Receipt number in the procurement system
`ReferenceMatchStatus`	select	yes	NotChecked, Matched, NoOrder, NoReceipt, Variance, ApprovedNonPO (documented non-PO exception)
`EnteredBy`	reference	yes	→ Employees (cannot approve the same bill)
`Approver`	reference		→ Employees (routed to, by ApprovalLimit)
`ApprovedBy`	reference		→ Employees
`Terms`	select	yes	Prepaid, Net7, Net15, Net30, Net45, Net60, Net90
`JournalEntry`	reference		→ JournalEntries (posted on Approved)
`AmountCredited`	decimal	yes	Active CreditApplications applied to or from this document, in its currency
`FunctionalOutstanding`	decimal	yes	Remaining original functional basis plus unreversed item revaluation; reconciles to control-account carrying value
`RateOverride`	reference		→ RateOverrides
`ApprovalDecision`	reference		→ ApprovalDecisions
`SourceRevision`	number	yes	Changing amount, rate or terms invalidates pending approval
`MigrationBatch`	text		Opening item linked to a reconciled migration control balance
`OpeningJournal`	reference		→ JournalEntries (opening-balance journal already includes this item's control amount; import creates no duplicate journal)
`ReferenceCheckedBy`	reference		→ Employees (AP Clerk who checked external procurement evidence)
`ReferenceCheckedAt`	datetime		Required before bill approval
`ReferenceEvidence`	attachment		Procurement match response or reviewed non-PO support
`NonPOReason`	text		Required where no purchase order is expected
`NonPOApprovedBy`	reference		→ Employees (Controller other than EnteredBy)
`NonPOApprovedAt`	datetime		Required for ApprovedNonPO

BillItemsAP line items with expense or asset account, cost center and tax in Line item of Bills.line item

Field	Type	Required	Details
`LineNumber`	number	yes
`Description`	text	yes
`Quantity`	number	yes
`UnitCost`	decimal	yes	Transaction currency
`LineTotal`	decimal	yes	Quantity × UnitCost
`ExpenseAccount`	reference	yes	→ ChartOfAccounts
`CostCenter`	reference		→ CostCenters
`TaxCode`	reference		→ TaxCodes
`TaxAmount`	decimal	yes	LineTotal × TaxCode.Rate ÷ 100, transaction currency
`TaxExchangeRate`	decimal		Rate the tax authority prescribes; equals the document rate when the jurisdiction uses the accounting rate
`TaxRateSource`	select		AccountingRate, AuthorityRate, Manual
`TaxAmountFunctional`	decimal	yes	TaxAmount × the document accounting ExchangeRate for the GL; authority-reporting valuation is retained separately
`FixedAsset`	reference		→ FixedAssets (when capitalised)
`TaxAmountAuthority`	decimal		TaxAmount × TaxExchangeRate in functional-equivalent terms for the authority report; no automatic GL posting
`TaxConversionDifference`	decimal		TaxAmountAuthority − TaxAmountFunctional; reviewed filing adjustment if required, never automatically treated as rounding

PayRunsVendor payment batch for one entity, bank account and matching payment currency. A different authorised AP Clerk releases within their converted limit; Controller releases above that limit. A rejected attempt stays as evidence and is retried through new payment records.transaction

Field	Type	Required	Details
`PayRunNumber`	text	yes
`Entity`	reference	yes	→ Entities
`BankAccount`	reference	yes	→ BankAccounts
`Currency`	reference	yes	→ Currencies (must equal BankAccount.Currency; foreign bill amounts convert before scheduling)
`PaymentDate`	date	yes
`Period`	reference	yes	→ AccountingPeriods
`Method`	select	yes	ACH, SEPA, Wire, Check
`PaymentCount`	number	yes
`TotalAmount`	decimal	yes	Payment currency
`FunctionalTotal`	decimal	yes	Payment-date functional value for accounting; approval separately converts TotalAmount to the decision maker's limit currency
`Status`	select	yes	Draft, Proposed, PendingRelease, Released, Transmitted, Acknowledged, Rejected
`PreparedBy`	reference	yes	→ Employees (cannot release the same run)
`ReleasedBy`	reference		→ Employees
`ReleasedAt`	datetime
`PaymentFileReference`	text		File name or bank batch id
`Notes`	text
`ExchangeRate`	decimal	yes	Payment currency to functional; frozen on release
`ApprovalDecision`	reference		→ ApprovalDecisions
`SourceRevision`	number	yes	Change to payees, amounts or bank snapshots invalidates release
`BankResponseReference`	text		Idempotent bank acknowledgement or rejection identifier
`RejectedAt`	datetime		Bank rejection time
`RejectionReason`	text		Required on Rejected
`RetryOf`	reference		→ PayRuns (new reviewed batch; original remains Rejected)

PaymentsMadeVendor payments, single or batched into a pay run, drawn on the banktransaction

Field	Type	Required	Details
`PaymentNumber`	text	yes
`Entity`	reference	yes	→ Entities
`Vendor`	reference	yes	→ Contacts
`VendorBankAccount`	reference		→ ContactBankAccounts (Verified, in the payment currency)
`PayRun`	reference		→ PayRuns (empty for a single urgent payment)
`PaymentDate`	date	yes
`Period`	reference	yes	→ AccountingPeriods
`Method`	select	yes	ACH, SEPA, Wire, Check, Card, Cash
`Currency`	reference	yes	→ Currencies (currency paid)
`Amount`	decimal	yes	Currency paid
`ExchangeRate`	decimal	yes	Paid currency to functional at PaymentDate
`OriginalExchangeRate`	decimal		Rate proposed by rule, kept when overridden
`RateOverriddenBy`	reference		→ Employees
`RateOverrideReason`	text
`FunctionalAmount`	decimal	yes	Amount × ExchangeRate
`WithholdingTaxCode`	reference		→ TaxCodes
`WithholdingTaxAmount`	decimal		Sum of active BillPaymentApplications withholding converted to payment currency; withheld tax is additional to cash Amount
`RealisedGainLoss`	decimal	yes	Sum of active BillPaymentApplications.RealisedGainLoss + BankRealisedGainLoss; positive is gain
`BankAccount`	reference	yes	→ BankAccounts
`Status`	select	yes	Draft, Scheduled, Released, Cleared, Voided, Bounced, Rejected
`Reference`	text		Check number, ACH or SEPA trace
`ReleasedBy`	reference		→ Employees (from the pay run, or the releaser of a single payment)
`JournalEntry`	reference		→ JournalEntries (one release event, current AP carrying Dr / bank carrying Cr / withholding payable Cr / residual FX)
`PreparedBy`	reference	yes	→ Employees
`ApprovalDecision`	reference		→ ApprovalDecisions (mandatory independent release even for a single urgent payment)
`RateOverride`	reference		→ RateOverrides
`BankAccountRevision`	number		Verified ContactBankAccounts revision frozen on release; changed coordinates require new release
`BankVerificationEvidence`	text		Immutable verification reference; raw account details restricted to bank-authorised roles
`BankCarryingAmount`	decimal	yes	Functional carrying amount removed from the bank for cash Amount; proportional posted currency balance, including remaining revaluation
`BankRealisedGainLoss`	decimal	yes	FunctionalAmount − BankCarryingAmount; positive gain credits realised FX on disposing of bank currency
`ReversalEntry`	reference		→ JournalEntries (exact release reversal in an eligible period)
`ReversalReason`	text		Required for rejected, bounced or voided posted payment
`RejectedAt`	datetime		Bank rejection time
`RetryOf`	reference		→ PaymentsMade (new approved attempt; old application effects already reversed)
`BankResponseReference`	text		Unique bank event reference for confirmation/rejection deduplication
`AppliedAmount`	decimal	yes	Sum of active BillPaymentApplications.PaymentAmount in payment currency; must equal cash Amount before release
`SourceRevision`	number	yes	Any change to amount, payee, bank revision or rate invalidates the release decision
`PaymentAccountSnapshot`	text		Encrypted immutable routing/account snapshot; visible only to AP Clerk, Treasury Analyst and Admin

BillPaymentApplicationsOne allocation of a payment to a bill, with bill-currency settlement and payment-currency cash shown separately. Withholding settles the bill but is owed to the tax authority rather than paid to the vendor. Line item of PaymentsMade.line item

Field	Type	Required	Details
`LineNumber`	number	yes
`Bill`	reference	yes	→ Bills
`AppliedAmount`	decimal	yes	Positive bill-currency amount settled, including WithholdingAmount
`BillRate`	decimal	yes	From the bill
`PaymentRate`	decimal	yes	Bill currency to functional at PaymentDate: DocumentToPaymentRate × payment ExchangeRate
`FunctionalAtBillRate`	decimal	yes	AppliedAmount × BillRate; original basis before revaluation
`FunctionalAtPaymentRate`	decimal	yes	PaymentAmount × payment ExchangeRate + WithholdingFunctionalAmount
`RealisedGainLoss`	decimal	yes	CarryingAmountSettled − FunctionalAtPaymentRate; positive gain credits realised FX; bank disposal FX is separate
`AppliedAt`	datetime	yes
`AppliedBy`	reference	yes	→ Employees
`PaymentMade`	reference	yes	→ PaymentsMade
`PaymentAmount`	decimal	yes	(AppliedAmount − WithholdingAmount) × DocumentToPaymentRate; payment currency
`DocumentToPaymentRate`	decimal	yes	Payment-currency units per bill-currency unit; 1 when equal; positive actual/approved cross rate
`WithholdingAmount`	decimal	yes	Bill-currency withheld portion, default 0
`WithholdingFunctionalAmount`	decimal	yes	WithholdingAmount × WithholdingRate; separate evidenced withholding conversion, not cash
`CarryingAmountSettled`	decimal	yes	Original bill basis settled + RevaluationReleased
`RevaluationReleased`	decimal	yes	Allocated signed change in bill carrying magnitude; tracking only, not another FX posting
`Status`	select	yes	Draft, Posted, Reversed
`JournalEntry`	reference		→ JournalEntries (the payment release journal)
`ReversalEntry`	reference		→ JournalEntries (same payment reversal; must not reverse again per line)
`RateOverride`	reference		→ RateOverrides
`WithholdingRate`	decimal	yes	Approved functional-currency units per document-currency unit on the settlement date; 1 for functional-currency documents
`WithholdingRateEvidence`	text		Accounting or required authority-rate source; material differences follow a reviewed tax policy
`WithholdingTaxCode`	reference		→ TaxCodes (required for nonzero withholding; header code is only a default)

IntercompanyTransactionsTransactions between two entities in the group, raised once. The fromtransaction

Field	Type	Required	Details
`TransactionNumber`	text	yes
`FromEntity`	reference	yes	→ Entities (books the receivable or the charge out)
`ToEntity`	reference	yes	→ Entities (books the payable or the charge in)
`Type`	select	yes	Sale, Recharge, Loan, LoanRepayment, Dividend, CashTransfer, Settlement
`TransactionDate`	date	yes
`Period`	reference	yes	→ AccountingPeriods (compatibility alias of FromPeriod; never used for ToEntity posting)
`Currency`	reference	yes	→ Currencies (agreed transaction currency)
`Amount`	decimal	yes	Transaction currency
`FromExchangeRate`	decimal	yes	Transaction to FromEntity functional
`ToExchangeRate`	decimal	yes	Transaction to ToEntity functional
`FromEntityAmount`	decimal	yes	FromEntity functional currency
`ToEntityAmount`	decimal	yes	ToEntity functional currency
`Status`	select	yes	Draft, Submitted, Matched, Disputed, Settled, Eliminated
`MatchDifference`	decimal		Difference after both functional amounts are translated into ReportingCurrency using frozen from/to reporting rates
`FromJournalEntry`	reference		→ JournalEntries (posted on Submitted)
`ToJournalEntry`	reference		→ JournalEntries (posted on Matched)
`RaisedBy`	reference	yes	→ Employees
`ConfirmedBy`	reference		→ Employees (counterparty entity; must differ from RaisedBy)
`ConfirmedAt`	datetime
`DisputeReason`	text
`Notes`	text
`FromPeriod`	reference	yes	→ AccountingPeriods (must belong to FromEntity and include its posting date)
`ToPeriod`	reference	yes	→ AccountingPeriods (must belong to ToEntity and permit the confirmation posting)
`ReportingPeriod`	reference	yes	→ AccountingPeriods (group reporting context)
`ReportingCurrency`	reference	yes	→ Currencies
`FromPostingDate`	date	yes	Posting date for the from-side journal
`ToPostingDate`	date		Confirmed posting date for the to-side journal
`FromReportingRate`	decimal		FromEntity functional to reporting currency at agreed reconciliation date
`ToReportingRate`	decimal		ToEntity functional to reporting currency at agreed reconciliation date
`AdjustmentReason`	text		Reviewed difference explanation; posted journals are not edited
`AdjustmentApprovedBy`	reference		→ Employees (Controller other than the adjustment preparer)
`AdjustmentJournal`	reference		→ JournalEntries (eligible entity correction or group adjustment; no unsupported plug)
`FromFunctionalOutstanding`	decimal	yes	Current carrying amount on the from-side open item
`ToFunctionalOutstanding`	decimal	yes	Current carrying amount on the confirmed to-side open item
`FromForeignOutstanding`	decimal	yes	Unsettled from-side amount in Currency, reconciled to linked settlement journals
`ToForeignOutstanding`	decimal	yes	Unsettled confirmed to-side amount in Currency, reconciled independently

IntercompanyBalancesPeriod-end agreement of the open balance between two entities in onetransaction

Field	Type	Required	Details
`BalanceNumber`	text	yes
`Period`	reference	yes	→ AccountingPeriods (group reporting period)
`BalanceDate`	date	yes	Period end
`EntityA`	reference	yes	→ Entities
`EntityB`	reference	yes	→ Entities
`Currency`	reference	yes	→ Currencies
`ABalance`	decimal	yes	A's receivable from B, transaction currency
`BBalance`	decimal	yes	B's payable to A, transaction currency
`Difference`	decimal	yes	ABalance − BBalance
`Status`	select	yes	Open, Agreed, Disputed
`AgreedBy`	reference		→ Employees
`AgreedAt`	datetime
`Notes`	text
`EntityAPeriod`	reference	yes	→ AccountingPeriods (EntityA period covering BalanceDate)
`EntityBPeriod`	reference	yes	→ AccountingPeriods (EntityB period covering BalanceDate)
`AAgreedBy`	reference		→ Employees (EntityA reviewer)
`BAgreedBy`	reference		→ Employees (different EntityB reviewer)
`DifferenceReason`	text		Required for any nonzero difference and linked adjustment
`AdjustmentJournal`	reference		→ JournalEntries

RevaluationRunsMonth-end revaluation of open foreign-currency balances for one entitytransaction

Field	Type	Required	Details
`RunNumber`	text	yes
`Entity`	reference	yes	→ Entities
`Period`	reference	yes	→ AccountingPeriods
`RunDate`	date	yes
`RateType`	select	yes	Closing, Spot
`RateDate`	date	yes	Date of the rates applied
`Scope`	select	yes	AllMonetary, BankOnly, ARAP, Intercompany
`ReversalMethod`	select	yes	ReverseNextPeriod, Delta (carrying amount stays restated; next run posts the movement)
`Status`	select	yes	Draft, Calculated, PendingApproval, Posted, Reversed
`AccountsRevalued`	number	yes
`TotalUnrealisedGain`	decimal	yes	Functional currency
`TotalUnrealisedLoss`	decimal	yes	Functional currency
`JournalEntry`	reference		→ JournalEntries
`ReversalEntry`	reference		→ JournalEntries (ReverseNextPeriod only; auto-reversal on day one of the next period)
`PreparedBy`	reference	yes	→ Employees (cannot approve the same run)
`ApprovedBy`	reference		→ Employees
`PostedAt`	date
`SourcePostingRevision`	number	yes	AccountingPeriods.PostingRevision frozen at calculation; intervening source changes require recalculation
`ApprovalDecision`	reference		→ ApprovalDecisions
`ReversalPeriod`	reference		→ AccountingPeriods (ReverseNextPeriod; required eligible next entity period)
`ReversalDate`	date		Must post before new-period transactions
`Supersedes`	reference		→ RevaluationRuns (a corrected run after reversal; no duplicate live coverage)

RevaluationLinesAccount/currency totals of item-level workings in RevaluationItems, separated by debit or credit balance side. Booked values mean current carrying values before this run, including earlier unreversed adjustments. Line item of RevaluationRuns.line item

Field	Type	Required	Details
`LineNumber`	number	yes
`RevaluationRun`	reference	yes	→ RevaluationRuns
`Entity`	reference	yes	→ Entities (from the run)
`Period`	reference	yes	→ AccountingPeriods (from the run)
`Account`	reference	yes	→ ChartOfAccounts
`Currency`	reference	yes	→ Currencies (foreign currency of the balance)
`ForeignBalance`	decimal	yes	Sum of item foreign balance magnitudes, never net unlike debit/credit items
`BookedFunctionalBalance`	decimal	yes	Sum of item CarryingBefore magnitudes on this BalanceSide
`BookedAverageRate`	decimal	yes	BookedFunctionalBalance ÷ ForeignBalance; 0 if no foreign balance
`ClosingRate`	decimal	yes	Rate applied
`RevaluedFunctionalBalance`	decimal	yes	ForeignBalance × ClosingRate
`UnrealisedGainLoss`	decimal	yes	Revalued minus booked for Debit balances; booked minus revalued for Credit balances; positive is gain
`OpenItemCount`	number		AR, AP and intercompany accounts revalue per open item
`BalanceSide`	select	yes	Debit, Credit
`CarryingAdjustment`	decimal	yes	RevaluedFunctionalBalance − BookedFunctionalBalance; signed change in carrying magnitude

FixedAssetsDepreciable assets on the register, held in the entity's functionaltransaction

Field	Type	Required	Details
`AssetNumber`	text	yes
`Name`	text	yes
`Entity`	reference	yes	→ Entities
`Category`	reference	yes	→ FixedAssetCategories
`DepreciationMethod`	reference	yes	→ DepreciationMethods
`AcquisitionDate`	date	yes
`InServiceDate`	date	yes
`Cost`	decimal	yes	Capitalised cost, functional currency
`SalvageValue`	decimal	yes	Default 0
`UsefulLifeMonths`	number	yes
`AccumulatedDepreciation`	decimal	yes	Sum of posted DepreciationLines, net of reversed lines and disposal removals
`NetBookValue`	decimal	yes	Cost − AccumulatedDepreciation − AccumulatedImpairment; asset movements reconcile disposals and transfers
`Location`	text
`CostCenter`	reference		→ CostCenters
`Status`	select	yes	UnderConstruction, InService, Impaired, Disposed, Transferred
`DisposalDate`	date
`DisposalProceeds`	decimal
`SourceBill`	reference		→ Bills
`AccumulatedImpairment`	decimal	yes	Posted impairment less approved reversals through AssetMovements
`ExpectedLifetimeUnits`	decimal		Required positive total for UnitsOfProduction; reviewed before depreciation
`AcquisitionJournal`	reference		→ JournalEntries (source bill posting or approved opening entry, never duplicate capitalisation)

DepreciationRunsMonthly depreciation batches per entity per period.transaction

Field	Type	Required	Details
`RunNumber`	text	yes
`Entity`	reference	yes	→ Entities
`Period`	reference	yes	→ AccountingPeriods
`RunDate`	date	yes
`Status`	select	yes	Draft, Calculated, PendingApproval, Posted, Reversed
`AssetsProcessed`	number	yes
`TotalDepreciation`	decimal	yes
`JournalEntry`	reference		→ JournalEntries
`PreparedBy`	reference	yes	→ Employees
`PostedBy`	reference		→ Employees
`PostedAt`	date
`ApprovalDecision`	reference		→ ApprovalDecisions (Controller other than PreparedBy)
`SourceRevision`	number	yes	Inputs frozen at calculation; revised inputs require recalculation and new approval
`ReversalEntry`	reference		→ JournalEntries

BudgetsBudget header per entity per version per fiscal year, in the entity'stransaction

Field	Type	Required	Details
`BudgetNumber`	text	yes
`Version`	reference	yes	→ BudgetVersions
`Entity`	reference	yes	→ Entities
`FiscalYear`	text	yes
`Currency`	reference	yes	→ Currencies
`Status`	select	yes	Draft, Submitted, Locked, Archived (mirrors BudgetVersions.Status)
`SubmittedAt`	date
`ReviewedBy`	reference		→ Employees
`TotalRevenue`	decimal	yes	Sum of BudgetLines on Revenue accounts
`TotalExpense`	decimal	yes	Sum of BudgetLines on Expense accounts
`Owner`	reference	yes	→ Employees

BudgetLinesAccount × cost center × period amounts. Line item of Budgets.line item

Field	Type	Required	Details
`Account`	reference	yes	→ ChartOfAccounts
`CostCenter`	reference		→ CostCenters
`Period`	reference	yes	→ AccountingPeriods
`BudgetAmount`	decimal	yes	Entity currency
`Notes`	text

ConsolidationRunsMulti-entity consolidation for a reporting period into the group unit:transaction

Field	Type	Required	Details
`RunNumber`	text	yes
`ReportingParent`	reference	yes	→ Entities (EntityType Group)
`Period`	reference	yes	→ AccountingPeriods
`RunDate`	date	yes
`ReportingCurrency`	reference	yes	→ Currencies
`EntityStatusAtRun`	select	yes	SoftClose, HardClose (every entity included was at least this far)
`BalanceSheetRateType`	select	yes	Closing, Spot
`IncomeStatementRateType`	select	yes	Average, TransactionDate (Average only if an appropriate approximation; volatile or material movements use actual dated rates)
`EquityRateType`	select	yes	Historical (reviewed account policy; no arbitrary closing-rate substitution)
`Status`	select	yes	Draft, Calculated, PendingApproval, Locked, Superseded
`SupersededBy`	reference		→ ConsolidationRuns (self)
`EntitiesIncluded`	number	yes
`TranslationAdjustment`	decimal	yes	Posted to the group unit's CTA account
`NonControllingInterest`	decimal		Reporting currency
`PreparedBy`	reference	yes	→ Employees
`LockedBy`	reference		→ Employees
`LockedAt`	date
`ApprovalDecision`	reference		→ ApprovalDecisions (locking Controller must differ from PreparedBy)
`AverageRateAssessment`	text		Document why averages approximate actual transaction dates; required when Average is selected
`GroupJournalEntry`	reference		→ JournalEntries (translation and CTA in reporting unit; underlying entity ledgers unchanged)
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision

TranslatedBalancesThe translated trial balance: one line per entity per account with the Line item of ConsolidationRuns.line item

Field	Type	Required	Details
`LineNumber`	number	yes
`Entity`	reference	yes	→ Entities
`Account`	reference	yes	→ ChartOfAccounts
`FunctionalCurrency`	reference	yes	→ Currencies
`FunctionalBalance`	decimal	yes	Closing carrying balance for Measure ClosingBalance; activity in scope for PeriodMovement; never sum successive closing balances
`RateType`	select	yes	Closing, Average, Historical, TransactionDate
`RateApplied`	decimal	yes	From ExchangeRates, or HistoricalRates for Historical
`ReportingBalance`	decimal	yes	FunctionalBalance × RateApplied for a single-rate line; TransactionDate lines retain the source journal line and its actual rate
`PriorPeriodReportingBalance`	decimal		From the prior locked run
`TranslationDifference`	decimal		Movement not explained by functional-currency movement at the period's rates
`ConsolidationRun`	reference	yes	→ ConsolidationRuns
`SourceScope`	reference	yes	→ ConsolidationEntities
`Measure`	select	yes	ClosingBalance, PeriodMovement; do not add consecutive closing balances
`SourceJournalLine`	reference		→ JournalEntryLines (required for TransactionDate translation)
`HistoricalRate`	reference		→ HistoricalRates (required for historical-rate source lots)
`RateRecord`	reference		→ ExchangeRates (actual selected version for Closing, Average or TransactionDate)
`RateDate`	date	yes	Effective translation date, or date of the historical source lot

EliminationEntriesIntercompany elimination and consolidation adjustment entries attached totransaction

Field	Type	Required	Details
`EntryNumber`	text	yes
`ConsolidationRun`	reference	yes	→ ConsolidationRuns
`EntryDate`	date	yes
`Type`	select	yes	IntercompanySales, IntercompanyARAP, IntercompanyLoan, InvestmentInSubsidiary, NonControllingInterest, UnrealisedProfit, Adjustment
`Description`	text	yes
`FromEntity`	reference		→ Entities
`ToEntity`	reference		→ Entities
`IntercompanyTransaction`	reference		→ IntercompanyTransactions
`Currency`	reference	yes	→ Currencies (reporting currency)
`Amount`	decimal	yes
`JournalEntry`	reference		→ JournalEntries (posted in the Group unit)
`Status`	select	yes	Draft, PendingApproval, Applied, Reversed
`PreparedBy`	reference	yes	→ Employees
`ApprovalDecision`	reference		→ ApprovalDecisions (independent Controller review before Applied)
`AdjustmentReason`	text		Required for Type Adjustment or unexplained initial matching difference
`Evidence`	attachment		Reconciliation/ownership/valuation workpaper supporting the entry
`ReversalEntry`	reference		→ JournalEntries
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision

TaxFilingsTax reporting for an entity and reporting period, with separately eligible posting and payment periods. Filing reclassifies amounts already accrued to settlement accounts and posts only approved differences; it never duplicates the tax liability already recognised on source documents.transaction

Field	Type	Required	Details
`FilingNumber`	text	yes
`Entity`	reference	yes	→ Entities
`Jurisdiction`	reference	yes	→ TaxJurisdictions
`Period`	reference	yes	→ AccountingPeriods (reporting period, which may already be HardClose)
`TaxType`	select	yes	Sales, Use, VAT, GST, Withholding
`Status`	select	yes	Draft, InReview, Filed, Paid, Amended
`Currency`	reference	yes	→ Currencies (filing currency)
`RateType`	select	yes	AuthorityRate, Closing, Average
`ExchangeRate`	decimal	yes	Functional to filing currency; 1 when they are the same
`TaxableSales`	decimal	yes
`TaxablePurchases`	decimal	yes
`OutputTax`	decimal	yes
`InputTax`	decimal	yes
`NetLiability`	decimal	yes	OutputTax − InputTax
`DueDate`	date	yes
`FiledAt`	date
`FiledBy`	reference		→ Employees
`ConfirmationNumber`	text		From the tax authority
`LiabilityJournalEntry`	reference		→ JournalEntries (approved reclassification/difference in PostingPeriod, not the closed reporting period)
`PaidAt`	date
`PaymentReference`	text
`PaymentJournalEntry`	reference		→ JournalEntries (posted on Paid: tax payable to bank)
`PostingPeriod`	reference	yes	→ AccountingPeriods (eligible open/authorised SoftClose period of Entity)
`PostingDate`	date	yes	Within PostingPeriod
`PaymentPeriod`	reference		→ AccountingPeriods (eligible Entity period for actual payment)
`PaymentDate`	date		Within PaymentPeriod
`PreparedBy`	reference	yes	→ Employees (Tax Specialist)
`ApprovalDecision`	reference		→ ApprovalDecisions (Controller other than PreparedBy)
`AuthorityRateEvidence`	attachment		Required if the filing uses an authority rate different from the accounting policy
`AccruedTaxBalance`	decimal	yes	Existing relevant control-account carrying amount in functional currency
`ApprovedAdjustment`	decimal	yes	Difference reviewed against the already accrued liability; no second full liability
`BankAccount`	reference		→ BankAccounts (required for payment journal)
`Supersedes`	reference		→ TaxFilings (amendment preserves the filed return)
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision
`PaymentApprovalDecision`	reference		→ ApprovalDecisions (independent authorisation of the actual bank payment)

CloseTasksPeriod-close checklist items with owners and dependencies, generated fromtransaction

Field	Type	Required	Details
`TaskNumber`	text	yes
`Period`	reference	yes	→ AccountingPeriods
`Entity`	reference	yes	→ Entities
`Template`	reference		→ CloseTaskTemplates
`Name`	text	yes
`Category`	select	yes	Subledger, Reconciliation, Accrual, Allocation, Depreciation, Revaluation, Intercompany, Tax, Consolidation, Reporting, Signoff
`Owner`	reference	yes	→ Employees
`DueDate`	date	yes
`Status`	select	yes	NotStarted, InProgress, Blocked, Complete, WaivedWithApproval
`DependsOn`	reference		→ CloseTasks (self)
`CompletedAt`	datetime
`CompletedBy`	reference		→ Employees
`Notes`	text
`Attachment`	attachment		Supporting document
`WaiverRequestedBy`	reference		→ Employees
`WaiverReason`	text		Required before WaivedWithApproval
`WaiverApprovedBy`	reference		→ Employees (Controller other than requester)
`WaiverApprovedAt`	datetime		Required before WaivedWithApproval
`ApprovalDecision`	reference		→ ApprovalDecisions
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision

BankStatementsImported statements per bank account, in the account's currency, withtransaction

Field	Type	Required	Details
`StatementNumber`	text	yes
`BankAccount`	reference	yes	→ BankAccounts
`Entity`	reference	yes	→ Entities
`StatementDate`	date	yes
`OpeningBalance`	decimal	yes	Account currency
`ClosingBalance`	decimal	yes	Account currency
`Currency`	reference	yes	→ Currencies
`Source`	select	yes	BankAPI, CSV, Manual
`ImportedAt`	date	yes
`LineCount`	number	yes
`UnmatchedCount`	number	yes	Lines still Unmatched
`Status`	select	yes	Imported, InReconciliation, Reconciled

BankStatementLinesOne line per statement movement, matched to the receipt, payment, Line item of BankStatements.line item

Field	Type	Required	Details
`LineNumber`	number	yes
`ValueDate`	date	yes
`Amount`	decimal	yes	Signed, account currency
`Reference`	text		Bank narrative or remittance reference
`CounterpartyName`	text
`MatchStatus`	select	yes	Unmatched, Matched, Excluded
`MatchedReceipt`	reference		→ PaymentsReceived (created from the line when no document exists)
`MatchedPayment`	reference		→ PaymentsMade
`MatchedTransfer`	reference		→ BankTransfers
`MatchedJournal`	reference		→ JournalEntries (bank charges, interest, conversion differences)
`MatchedBy`	reference		→ Employees (the matcher's service account when automatic)
`BankStatement`	reference	yes	→ BankStatements
`ExternalLineID`	text	yes	Unique account/feed/source transaction identifier; repeated import does not create a new movement
`ExcludedReason`	text		Required for Excluded; excluded lines remain in the statement reconciliation

BankReconciliationsThe reconciliation of a statement to GL activity on the bank account, intransaction

Field	Type	Required	Details
`ReconciliationNumber`	text	yes
`BankAccount`	reference	yes	→ BankAccounts
`Entity`	reference	yes	→ Entities
`Period`	reference	yes	→ AccountingPeriods
`Statement`	reference	yes	→ BankStatements
`ReconciliationDate`	date	yes
`GLBalance`	decimal	yes	Account currency
`StatementBalance`	decimal	yes	Account currency
`DepositsInTransit`	decimal	yes	Receipts booked that the bank has not credited
`OutstandingPayments`	decimal	yes	Payments released that the bank has not cleared
`AdjustedStatementBalance`	decimal	yes	StatementBalance + DepositsInTransit − OutstandingPayments
`BookAdjustments`	decimal	yes	Bank charges, interest and conversion differences booked from the screen; signed
`AdjustedGLBalance`	decimal	yes	GLBalance + BookAdjustments
`Difference`	decimal	yes	AdjustedGLBalance − AdjustedStatementBalance; zero when balanced
`Status`	select	yes	InProgress, Balanced, Unbalanced, Approved
`PreparedBy`	reference	yes	→ Employees (cannot approve the same reconciliation)
`ApprovedBy`	reference		→ Employees
`ApprovedAt`	date
`ApprovalDecision`	reference		→ ApprovalDecisions
`LedgerRevision`	number	yes	Frozen revision of included activity; subsequent bank postings invalidate approval
`AdjustmentJournals`	text		Journal references included once; GLBalance is the before-adjustment snapshot
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision

BankTransfersMovements between two bank accounts of one entity, in the same ortransaction

Field	Type	Required	Details
`TransferNumber`	text	yes
`Entity`	reference	yes	→ Entities
`FromBankAccount`	reference	yes	→ BankAccounts
`ToBankAccount`	reference	yes	→ BankAccounts
`CurrencyOut`	reference	yes	→ Currencies
`AmountOut`	decimal	yes
`CurrencyIn`	reference	yes	→ Currencies
`AmountIn`	decimal	yes	As credited by the bank
`BankRate`	decimal		AmountIn ÷ AmountOut when the currencies differ
`TransferDate`	date	yes
`Period`	reference	yes	→ AccountingPeriods
`FunctionalOut`	decimal	yes	Current posted carrying amount of AmountOut removed from the source bank currency balance
`FunctionalIn`	decimal	yes	AmountIn valued at the approved receipt-date rate
`RealisedGainLoss`	decimal	yes	FunctionalIn − FunctionalOut, excluding separately booked bank fees; prior carrying FX is not repeated
`Status`	select	yes	Draft, Released, Cleared, Cancelled
`JournalEntry`	reference		→ JournalEntries (posted on Released)
`PreparedBy`	reference	yes	→ Employees
`ReleasedBy`	reference		→ Employees
`ApprovalDecision`	reference		→ ApprovalDecisions (Controller or another authorised Treasury Analyst, never PreparedBy)
`RateOverride`	reference		→ RateOverrides
`ReversalEntry`	reference		→ JournalEntries
`ReversalReason`	text		Required to cancel a posted transfer
`BankFee`	decimal	yes	Separately identified functional-currency expense, default 0
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision
`IncomingExchangeRate`	decimal	yes	Incoming currency to functional at TransferDate; FunctionalIn = AmountIn × IncomingExchangeRate

AllocationRunsCost-center allocations of shared services run at period end.transaction

Field	Type	Required	Details
`RunNumber`	text	yes
`Entity`	reference	yes	→ Entities
`Period`	reference	yes	→ AccountingPeriods
`RunDate`	date	yes
`AllocationType`	select	yes	HeadCount, Revenue, SquareFootage, FixedPercent, Custom
`SourceCostCenter`	reference	yes	→ CostCenters
`Basis`	text	yes	Description of the driver
`TotalAllocated`	decimal	yes
`Status`	select	yes	Draft, Calculated, PendingApproval, Posted, Reversed
`JournalEntry`	reference		→ JournalEntries
`PreparedBy`	reference	yes	→ Employees
`PostedAt`	date
`ApprovalDecision`	reference		→ ApprovalDecisions (Controller other than PreparedBy)
`SourceRevision`	number	yes	Inputs frozen at calculation; revised inputs require recalculation and new approval
`ReversalEntry`	reference		→ JournalEntries
`SourceAccount`	reference	yes	→ ChartOfAccounts (account whose eligible cost is reclassified)
`SourceAmount`	decimal	yes	Functional-currency amount available to allocate; excludes prior allocations from this source event
`DriverEvidence`	attachment	yes	Frozen headcount, revenue, area, percentage or reviewed custom-driver schedule

RateExceptionsA missing or unusable conversion blocks the affected business event until an approved rate is available; it never silently falls back to 1 or a stale rate.transaction

Field	Type	Required	Details
`ExceptionNumber`	text	yes	Unique open exception for source, pair, type and required date
`Entity`	reference	yes	→ Entities
`SourceTable`	text	yes	Existing table whose posting or approval needs the rate
`SourceRecordID`	text	yes	Existing source identifier
`FromCurrency`	reference	yes	→ Currencies
`ToCurrency`	reference	yes	→ Currencies
`RateType`	select	yes	Spot, Closing, Average, Budget, Historical, AuthorityRate, Contract
`RequiredDate`	date	yes	Applicable source/decision date
`DetectedAt`	datetime	yes	First detection
`Status`	select	yes	Open, Resolved, Cancelled
`ResolutionRate`	reference		→ ExchangeRates
`ResolutionOverride`	reference		→ RateOverrides
`ResolvedBy`	reference		→ Employees
`ResolvedAt`	datetime		Retry only after resolution; same business-event posting key

RateOverridesReviewed deviation from an applicable rate. The effective record and original source remain immutable; every affected posting references the approved override.transaction

Field	Type	Required	Details
`OverrideNumber`	text	yes	Unique override request
`Entity`	reference	yes	→ Entities
`SourceTable`	text	yes	Existing affected table
`SourceRecordID`	text	yes	Existing affected record
`FromCurrency`	reference	yes	→ Currencies
`ToCurrency`	reference	yes	→ Currencies
`RateDate`	date	yes	Effective conversion date
`RateType`	select	yes	Spot, Closing, Average, Budget, Historical, AuthorityRate, Contract
`OriginalRate`	decimal		Rate proposed by the rule; absent only for an explicitly missing-rate exception
`ProposedRate`	decimal	yes	Positive target units per source unit
`SourceRate`	reference		→ ExchangeRates
`Reason`	text	yes	Why this rate is appropriate
`Evidence`	attachment	yes	Contract, provider observation or reviewed authority-rate support
`RequestedBy`	reference	yes	→ Employees (Treasury Analyst)
`ApprovalDecision`	reference		→ ApprovalDecisions (Controller other than RequestedBy)
`Status`	select	yes	Draft, PendingApproval, Approved, Rejected, Superseded
`ApprovedAt`	datetime		Source edit after approval requires a new request
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision

ApprovalDelegationsDated, entity-scoped substitution for an absent approver. It does not grant the delegate new permissions, bypass conflicts, or increase either person's monetary authority.transaction

Field	Type	Required	Details
`DelegationNumber`	text	yes	Unique grant
`Entity`	reference	yes	→ Entities
`Delegator`	reference	yes	→ Employees
`Delegate`	reference	yes	→ Employees (different active person with the required role)
`SourceType`	text	yes	Allowed existing document table or decision type
`StartsAt`	datetime	yes	Inclusive effective time
`EndsAt`	datetime	yes	Exclusive expiry after StartsAt
`Status`	select	yes	Draft, Approved, Revoked, Expired
`ApprovedBy`	reference		→ Employees (Controller other than Delegator and Delegate)
`ApprovedAt`	datetime		Required before Approved
`Reason`	text	yes	Absence and bounded scope
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision

ApprovalDecisionsImmutable decision evidence tied to the exact source revision. Both the actual actor and the represented approver remain visible. Monetary limits are compared only after explicit conversion to the approver's limit currency.transaction

Field	Type	Required	Details
`DecisionNumber`	text	yes	Unique source + revision + decision-stage identifier
`Entity`	reference	yes	→ Entities
`SourceType`	text	yes	Existing source table, validated against its record type
`SourceRecordID`	text	yes	Existing source record identifier
`SourceRevision`	number	yes	Approved immutable source revision
`DecisionStage`	text	yes	Bill approval, release, rate override, close waiver or other named decision
`RequestedDate`	date	yes	Request date
`PreparedBy`	reference	yes	→ Employees (source preparer snapshot)
`ActualActor`	reference		→ Employees (authenticated person; never the preparer)
`AuthorisedFor`	reference		→ Employees (same actor unless delegated)
`Delegation`	reference		→ ApprovalDelegations (must be valid at DecidedAt)
`SourceAmount`	decimal		Absolute amount in SourceCurrency for a monetary decision
`SourceCurrency`	reference		→ Currencies
`DecisionCurrency`	reference		→ Currencies (ApprovalLimitCurrency snapshot)
`ConversionRate`	decimal		Decision-currency units per SourceCurrency unit; 1 only when equal
`ConversionRateRecord`	reference		→ ExchangeRates
`RateOverride`	reference		→ RateOverrides
`RateDate`	date		Decision conversion date
`DecisionAmount`	decimal		abs(SourceAmount) × ConversionRate, rounded in DecisionCurrency
`LimitSnapshot`	decimal		Applicable ceiling; delegation requires independent checks against both people's limits
`DelegateDecisionAmount`	decimal		SourceAmount converted into the delegate's own approval-limit currency
`DelegateLimitCurrency`	reference		→ Currencies
`DelegateConversionRate`	decimal		Separate rate when delegate and delegator limit currencies differ
`DelegateLimitSnapshot`	decimal		Delegate's own ceiling
`Status`	select	yes	Requested, Approved, Rejected, Cancelled
`DecidedAt`	datetime		Immutable decision time
`Reason`	text		Required on rejection, exception or waiver
`ConversionRateType`	select		Spot, Contract, Manual; required for a monetary conversion
`DelegateConversionRateRecord`	reference		→ ExchangeRates (delegate's separate limit-currency conversion)
`DelegateRateDate`	date		Date of the delegate's conversion
`DelegateRateOverride`	reference		→ RateOverrides (if the delegate's separate conversion is overridden)

RevaluationItemsOpen-item or bank-balance workings underneath account totals. Each posted adjustment remains allocated to its source until reversed or that portion is settled. Debit/Credit identifies balance direction; amounts are nonnegative magnitudes. Line item of RevaluationRuns.line item

Field	Type	Required	Details
`LineNumber`	number	yes	Unique within run
`RevaluationRun`	reference	yes	→ RevaluationRuns
`RevaluationLine`	reference	yes	→ RevaluationLines
`SourceType`	select	yes	Invoice, Bill, UnappliedReceipt, IntercompanyFrom, IntercompanyTo, Bank, JournalLine
`Invoice`	reference		→ Invoices
`Bill`	reference		→ Bills
`Receipt`	reference		→ PaymentsReceived
`IntercompanyTransaction`	reference		→ IntercompanyTransactions
`BankAccount`	reference		→ BankAccounts
`JournalLine`	reference		→ JournalEntryLines
`BalanceSide`	select	yes	Debit, Credit; identifies the sign independently of account classification
`Currency`	reference	yes	→ Currencies
`ForeignOpenAmount`	decimal	yes	Positive outstanding magnitude at the frozen cutoff
`OriginalFunctionalOpen`	decimal	yes	Remaining original basis
`PriorRevaluation`	decimal	yes	Signed unreversed carrying adjustment remaining from earlier items
`CarryingBefore`	decimal	yes	OriginalFunctionalOpen + PriorRevaluation
`ClosingRate`	decimal	yes	Approved functional units per foreign unit
`RevaluedAmount`	decimal	yes	ForeignOpenAmount × ClosingRate
`Adjustment`	decimal	yes	RevaluedAmount − CarryingBefore; signed change in carrying magnitude
`UnrealisedGainLoss`	decimal	yes	Adjustment for Debit, minus Adjustment for Credit; positive credits unrealised FX
`ReleasedAdjustment`	decimal	yes	Sum of active RevaluationSettlements; excludes reverse-period journal releases
`RemainingAdjustment`	decimal	yes	Adjustment − ReleasedAdjustment until reversed; 0 after the run's exact reversal
`Status`	select	yes	Calculated, Posted, Reversed
`MigrationBatch`	text		Imported original basis and prior FX schedule tied to an OpeningJournal, without reposting past FX
`OpeningJournal`	reference		→ JournalEntries (required for an imported prior carrying adjustment)
`ClosingRateRecord`	reference		→ ExchangeRates (selected immutable rate version)
`RateOverride`	reference		→ RateOverrides (approved deviation used instead)

RevaluationSettlementsAllocation of an existing item adjustment to the portion derecognised. These rows explain carrying-value clearing and do not create another FX posting. Reversing the settlement restores the same allocated adjustment once. Line item of RevaluationItems.line item

Field	Type	Required	Details
`LineNumber`	number	yes	Unique allocation identifier
`RevaluationItem`	reference	yes	→ RevaluationItems
`ReceiptApplication`	reference		→ PaymentApplications
`BillApplication`	reference		→ BillPaymentApplications
`CreditApplication`	reference		→ CreditApplications
`PaymentMade`	reference		→ PaymentsMade (bank-currency disposal)
`BankTransfer`	reference		→ BankTransfers
`SettlementDate`	date	yes	Effective date of the clearing event
`ForeignAmount`	decimal	yes	Portion of this source's still-open foreign amount settled
`ReleasedAdjustment`	decimal	yes	Pro-rata share of the item's remaining adjustment; last settlement takes rounding residual
`JournalEntry`	reference	yes	→ JournalEntries (existing clearing event, not a new revaluation journal)
`Status`	select	yes	Active, Reversed
`SettlementType`	select	yes	ReceiptApplication, BillApplication, CreditApplication, Payment, BankTransfer, WriteOff, Intercompany
`SourceJournalLine`	reference		→ JournalEntryLines (required for journal-only write-off/intercompany allocation; links the exact source clearing)

CreditApplicationsAllocation of an approved customer credit memo or vendor credit to a debit document of the same entity, counterparty and currency. Current carrying amounts clear each side; cross-currency credits require a separately reviewed settlement rather than mixed-currency subtraction.transaction

Field	Type	Required	Details
`ApplicationNumber`	text	yes	Unique allocation
`Entity`	reference	yes	→ Entities
`ApplicationDate`	date	yes	Posting date
`Period`	reference	yes	→ AccountingPeriods
`Type`	select	yes	CustomerCredit, VendorCredit
`Invoice`	reference		→ Invoices (customer debit invoice)
`CreditInvoice`	reference		→ Invoices (posted CreditMemo)
`Bill`	reference		→ Bills (vendor debit bill)
`CreditBill`	reference		→ Bills (approved VendorCredit)
`Currency`	reference	yes	→ Currencies (same on both documents)
`AppliedAmount`	decimal	yes	Positive document-currency magnitude, no more than either remaining balance
`DocumentCarryingAmount`	decimal	yes	Current carrying magnitude of debit document portion
`CreditCarryingAmount`	decimal	yes	Current carrying magnitude of credit-document portion
`RealisedGainLoss`	decimal	yes	CustomerCredit: CreditCarryingAmount − DocumentCarryingAmount; VendorCredit: DocumentCarryingAmount − CreditCarryingAmount
`AppliedBy`	reference	yes	→ Employees
`Status`	select	yes	Draft, Posted, Reversed
`JournalEntry`	reference		→ JournalEntries
`ReversalEntry`	reference		→ JournalEntries

DepreciationLinesAsset-level depreciation calculations frozen with the run, including method inputs and any units-of-production evidence. Posted lines and reversals reconcile the asset register to the ledger. Line item of DepreciationRuns.line item

Field	Type	Required	Details
`LineNumber`	number	yes	Unique asset within run
`DepreciationRun`	reference	yes	→ DepreciationRuns
`Asset`	reference	yes	→ FixedAssets
`Method`	reference	yes	→ DepreciationMethods
`CostBasis`	decimal	yes	Capitalised basis used
`OpeningAccumulatedDepreciation`	decimal	yes	Posted balance before this run
`OpeningImpairment`	decimal	yes	Posted impairment before this run
`SalvageValue`	decimal	yes	Floor used
`RemainingLifeMonths`	number	yes	Remaining useful life at cutoff
`Convention`	text	yes	Frozen method convention and proration
`UnitsThisPeriod`	decimal		Required for UnitsOfProduction
`ExpectedLifetimeUnits`	decimal		Reviewed denominator for UnitsOfProduction
`DriverEvidence`	attachment		Required for production units or manual method inputs
`DepreciationAmount`	decimal	yes	Functional-currency charge; never reduces carrying value below approved residual floor
`ClosingNetBookValue`	decimal	yes	Opening carrying value minus charge
`ExpenseAccount`	reference	yes	→ ChartOfAccounts
`AccumulatedAccount`	reference	yes	→ ChartOfAccounts
`CostCenter`	reference		→ CostCenters
`Status`	select	yes	Calculated, Posted, Reversed

AssetMovementsReviewed capitalisation, impairment, transfer and disposal evidence. Cost and accumulated balances move together; posted source bills are linked rather than capitalised twice.transaction

Field	Type	Required	Details
`MovementNumber`	text	yes	Unique source event
`Asset`	reference	yes	→ FixedAssets
`Entity`	reference	yes	→ Entities
`Period`	reference	yes	→ AccountingPeriods
`MovementDate`	date	yes	Effective posting date
`Type`	select	yes	Capitalisation, Impairment, ImpairmentReversal, Transfer, Disposal
`CostChange`	decimal	yes	Signed change to asset cost
`AccumulatedDepreciationChange`	decimal	yes	Signed register adjustment, e.g. remove balance on disposal
`ImpairmentChange`	decimal	yes	Signed impairment amount
`Proceeds`	decimal	yes	Functional-currency disposal proceeds, otherwise 0
`GainLoss`	decimal	yes	Disposal proceeds less carrying value removed; positive gain
`TargetCostCenter`	reference		→ CostCenters (same-entity transfer; cross-entity uses IntercompanyTransactions)
`PreparedBy`	reference	yes	→ Employees
`ApprovalDecision`	reference		→ ApprovalDecisions
`Evidence`	attachment	yes	Acquisition, valuation, transfer or disposal support
`Status`	select	yes	Draft, PendingApproval, Posted, Reversed
`JournalEntry`	reference		→ JournalEntries
`ReversalEntry`	reference		→ JournalEntries
`SourceRevision`	number	yes	Frozen on approval; any material change requires a new decision

AllocationLinesFrozen source-to-target allocation workings. All drivers and percentages reconcile to the run and the final line receives the documented rounding residual. Line item of AllocationRuns.line item

Field	Type	Required	Details
`LineNumber`	number	yes	Unique target within run
`AllocationRun`	reference	yes	→ AllocationRuns
`TargetCostCenter`	reference	yes	→ CostCenters (same Entity as run)
`TargetAccount`	reference	yes	→ ChartOfAccounts
`DriverQuantity`	decimal	yes	Nonnegative target basis
`DriverTotal`	decimal	yes	Positive sum over targets; zero total blocks calculation
`Share`	decimal	yes	DriverQuantity ÷ DriverTotal, or approved FixedPercent as a fraction; shares sum to 1
`AllocatedAmount`	decimal	yes	SourceAmount × Share, with final rounding residual; total equals TotalAllocated
`RoundingAdjustment`	decimal	yes	Explicit rounding difference included in AllocatedAmount
`Status`	select	yes	Calculated, Posted, Reversed

ConsolidationEntitiesEntity-period coverage included in a group run. Local fiscal periods are mapped to the group date range explicitly; income movements may span several local periods, while closing balances are selected once per entity. Line item of ConsolidationRuns.line item

Field	Type	Required	Details
`LineNumber`	number	yes	Unique entity/period/coverage within run
`ConsolidationRun`	reference	yes	→ ConsolidationRuns
`Entity`	reference	yes	→ Entities
`SourcePeriod`	reference	yes	→ AccountingPeriods (belongs to Entity)
`CoverageFrom`	date	yes	Inclusive source date range inside the group reporting range
`CoverageThrough`	date	yes	Inclusive end; ranges for an entity cover the group period without overlaps or gaps
`IsClosingPeriod`	boolean	yes	Exactly one per included entity; carries the closing balance at group cutoff
`SourcePostingRevision`	number	yes	Frozen local ledger revision; change invalidates run
`SourceStatus`	select	yes	SoftClose, HardClose
`OwnershipPercent`	decimal	yes	Approved ownership at reporting cutoff
`ConsolidationMethod`	select	yes	Full, Equity, Proportional (only where the reviewed reporting policy permits)
`ReviewedBy`	reference		→ Employees (Controller)
`ReviewedAt`	datetime		Required before group lock

ERP•AI workspace

Start now Multi-currency Accounting

Create your ERP.AI account and get started with Proto.

Start now Download agent

Previous · reference 2 of 6Reports and dashboards Next · reference 4 of 6Integrations

Multi-currency Accounting

Modules

Multi-currency Accounting

Processes

Multi-currency Accounting

Industries

Multi-currency Accounting

Reference

Multi-currency Accounting

Data model

How the model is organised

Currency masters

Ledger masters

Subledger transactions

Intercompany

Banking

Period-end runs

Journals

Keys and references

Migration order

Tables

Start now Multi-currency Accounting

Multi-currency Accounting

Modules

Multi-currency Accounting

Processes

Multi-currency Accounting

Industries

Multi-currency Accounting

Reference

Data model

How the model is organised

Currency masters

Ledger masters

Subledger transactions

Intercompany

Banking

Period-end runs

Journals

Keys and references

Migration order

Tables

Start now Multi-currency Accounting

Your Privacy, Your Choice

Manage Your Cookie Preferences