Data model

Follow accepted source balances through the selected calculation and published financial revision.

30 tables · 109 relationships

Data model 30 tables

Data modelTable names and relationships

How the model is organised

Entities and ownership

LegalEntities, OwnershipStructure, OwnershipChanges, ConsolidationGroups, GroupMemberships and Employees. Define entities, effective ownership and the group population.

LegalEntities
OwnershipStructure
OwnershipChanges
ConsolidationGroups
GroupMemberships
Employees

Source balances and mappings

ConsolidationPeriods, ConsolidationCoA, ChartOfAccountsMapping, SubsidiaryTrialBalances and TrialBalanceLines. Preserve the source close and its lines alongside reviewed group-account mappings.

ConsolidationPeriods
ConsolidationCoA
ChartOfAccountsMapping
SubsidiaryTrialBalances
TrialBalanceLines

Run and translation inputs

ConsolidationRuns, FXRates, FXTranslationRules, FXRateRequirements, TranslatedBalances and CumulativeTranslationAdjustment. Freeze the required population and exact input versions, including reviewed rate inputs and historical translation layers.

ConsolidationRuns
FXRates
FXTranslationRules
FXRateRequirements
TranslatedBalances
CumulativeTranslationAdjustment

Reconciliation and adjustments

IntercompanyTransactions, ICReconciliation, ICDisputes, Eliminations, EliminationLines, MinorityInterest, TopSideAdjustments and ConsolidationMovements. Retain decisions and calculation context for reconciliation, elimination and adjustment records.

IntercompanyTransactions
ICReconciliation
ICDisputes
Eliminations
EliminationLines
MinorityInterest
TopSideAdjustments
ConsolidationMovements

Published results

ConsolidatedTrialBalance, ConsolidatedFinancials, Disclosures, BoardPackExports and BoardPackDistributions. Retain immutable publication references for statements, disclosures and board packs.

ConsolidatedTrialBalance
ConsolidatedFinancials
Disclosures
BoardPackExports
BoardPackDistributions

Keys and references

Use stable source-close and line identities, canonical entity identifiers and financial revisions. Preserve historical rate layers before account aggregation. Every consolidation output identifies its source run. Reject cross-period references and duplicate source consumption.

Migration order

Verify Employees, LegalEntities and effective ownership.
Reconcile group accounts, mappings and approved translation methods.
Import accepted source balances with original evidence and currencies.
Prepare run inputs, rates, reconciliation and movement workpapers.
Reconcile calculated results and published history before granting reader access.

Tables

Find a table 30 tables

LegalEntitiesThe entity master. Every legal vehicle in the corporate group —master

Field	Type	Required	Details
`LegalEntityCode`	text	yes	Short stable code, e.g. "USCO-PARENT", "SUB-WEST-LLC"
`Name`	text	yes	Legal name
`EntityType`	select	yes	Subsidiary, Branch, JointVenture, VIE, Parent
`FunctionalCurrency`	text	yes	ISO 4217 of entity's books, e.g. USD or a ForeignCurrency code
`ReportingCurrency`	text	yes	Always USD for this app
`JurisdictionState`	text		US state, e.g. DE, CA, NY
`JurisdictionCountry`	text	yes	US for domestic, country code for foreign sub
`TaxID`	text		EIN for US entities
`FiscalYearEnd`	select		Dec31, Mar31, Jun30, Sep30, Other
`IsConsolidated`	boolean	yes	Proposed future eligibility only; approved frozen group membership governs each run
`AcquisitionDate`	date		Date entered the group
`DispositionDate`	date		Date left the group
`ParentEntity`	reference		→ LegalEntities (self) — immediate parent for display
`Active`	boolean	yes

OwnershipStructureEffective approved ownership and method records. Close calculations freeze the applicable effective intervals and workpapers; mid-period changes require their reviewed allocation method.master

Field	Type	Required	Details
`Parent`	reference	yes	→ LegalEntities
`Subsidiary`	reference	yes	→ LegalEntities
`OwnershipPct`	number	yes	0–100
`ConsolidationMethod`	select	yes	FullConsolidation, EquityMethod, Proportional, CostMethod
`EffectiveFrom`	date	yes
`EffectiveTo`	date		Set when superseded by an OwnershipChanges record
`AcquisitionDate`	date
`Notes`	text
`Active`	boolean	yes
`PolicyEvidence`	attachment	yes	Approved control/method assessment and specialist workpaper where needed
`ApprovedBy`	reference	yes	→ Employees; independent Group Controller / Corporate CFO
`MethodVersion`	text	yes	Reviewed method; never selected only from ownership percentage

OwnershipChangesAudit log of every ownership change — acquisition, divestiture,transaction

Field	Type	Required	Details
`ChangeNumber`	text	yes
`Parent`	reference	yes	→ LegalEntities
`Subsidiary`	reference	yes	→ LegalEntities
`ChangeType`	select	yes	Acquisition, Divestiture, ShareIssuance, BuyBack, StepUp, StepDown, Reorganization
`EffectiveDate`	date	yes
`OwnershipPctBefore`	number	yes	0–100
`OwnershipPctAfter`	number	yes	0–100
`ConsiderationUSD`	decimal		Cash + stock + assumed liabilities
`RecordedBy`	reference	yes	→ Employees
`ApprovedBy`	reference		→ Employees (Group Controller)
`ApprovedAt`	date
`Status`	select	yes	Draft, Submitted, Approved, Rejected

ConsolidationGroupsReporting groupings — geographic, divisional, or composite —master

Field	Type	Required	Details
`GroupCode`	text	yes
`Name`	text	yes
`GroupType`	select	yes	Geographic, Divisional, Statutory, Composite
`Description`	text
`Active`	boolean	yes

GroupMembershipsPer-Entity membership of a `ConsolidationGroups` row, withline

Field	Type	Required	Details
`ConsolidationGroup`	reference	yes	→ ConsolidationGroups
`LegalEntity`	reference	yes	→ LegalEntities
`EffectiveFrom`	date	yes
`EffectiveTo`	date
`Active`	boolean	yes

ConsolidationPeriodsThe unit of corporate close work, created directly by an authorised manager or idempotently from a configured close event. A financial revision freezes required entities and counts their current Accepted submissions.master

Field	Type	Required	Details
`Period`	text	yes	e.g. "2026M01"
`PeriodType`	select	yes	Month, Quarter, Year
`StartDate`	date	yes
`EndDate`	date	yes
`Status`	select	yes	Open, PendingTBs, Computing, Reviewed, Published, Locked, Reopened
`TBsExpected`	number		Count of consolidated entities expected to submit
`TBsReceived`	number	yes	Server count of DISTINCT required LegalEntities with the current Accepted submission at this revision; exclude Imported, Validated and Submitted
`OpenedBy`	reference		→ Employees
`OpenedAt`	date
`PublishedBy`	reference		→ Employees (Group Controller)
`PublishedAt`	date
`LockedAt`	date		Set by period-lock-on-publish
`FinancialRevision`	number	yes	Current candidate revision; previous publications retained
`SelectedRun`	reference		→ ConsolidationRuns; complete reviewed candidate only
`ConsolidationGroup`	reference	yes	→ ConsolidationGroups; immutable reporting group for this close; period business identity includes group and dates

ConsolidationCoAThe unified consolidated chart of accounts. Self-parenting treemaster

Field	Type	Required	Details
`AccountCode`	text	yes	Stable group account number
`AccountName`	text	yes
`AccountType`	select	yes	Asset, Liability, Equity, Revenue, Expense
`AccountSubType`	select		CurrentAsset, NonCurrentAsset, CurrentLiability, NonCurrentLiability, Equity-Common, Equity-AOCI, Equity-NCI, Revenue, COGS, OperatingExpense, OtherIncomeExpense, IncomeTaxExpense
`ParentAccount`	reference		→ ConsolidationCoA (self)
`NormalBalance`	select	yes	Debit, Credit
`IsIntercompany`	boolean	yes	True for IC AR / IC AP / IC Revenue / IC Expense — drives elimination scope
`ICCounterpartAccount`	reference		→ ConsolidationCoA — paired account on the elimination side
`Active`	boolean	yes

ChartOfAccountsMappingPer-Entity mapping from the entity's local CoA account string tomaster

Field	Type	Required	Details
`LegalEntity`	reference	yes	→ LegalEntities
`LocalAccountCode`	text	yes	Source GL account string
`LocalAccountName`	text
`ConsolidationAccount`	reference	yes	→ ConsolidationCoA
`EffectiveFrom`	date	yes
`EffectiveTo`	date
`MappingNote`	text		Why this mapping (audit)
`ApprovedBy`	reference		→ Employees (Consolidation Manager)
`ApprovedAt`	date
`Active`	boolean	yes
`PreparedBy`	reference	yes	→ Employees; proposing principal
`Status`	select	yes	Draft, Submitted, Approved, Rejected, Superseded

SubsidiaryTrialBalancesPer-Entity per-Period trial-balance submission. The atomic headertransaction

Field	Type	Required	Details
`LegalEntity`	reference	yes	→ LegalEntities
`Period`	reference	yes	→ ConsolidationPeriods
`LocalCurrency`	text	yes	The entity's FunctionalCurrency at submission time
`AsOfDate`	date	yes	Period end
`Source`	select	yes	finAccountingSync, CSV, Manual, ERPIntegration
`TotalDebits`	decimal	yes	fx: SUM(TrialBalanceLines.LocalDebit)
`TotalCredits`	decimal	yes	fx: SUM(TrialBalanceLines.LocalCredit)
`BalanceCheck`	decimal	yes	fx: TotalDebits − TotalCredits // must be 0
`Status`	select	yes	Draft, Imported, Validated, Submitted, Accepted, Rejected
`SubmittedBy`	reference		→ Employees (Subsidiary Controller)
`SubmittedAt`	date
`AcceptedBy`	reference		→ Employees (Consolidation Manager)
`AcceptedAt`	date
`RejectionReason`	text
`SubmissionNumber`	text	yes	Stable human-readable record number
`SourceRevision`	text	yes	Immutable source-close identity plus digest; duplicate imports return existing submission
`Supersedes`	reference		→ SubsidiaryTrialBalances; prior accepted revision retained

TrialBalanceLinesThe per-Account balance row inside a TB submission. Carries theline

Field	Type	Required	Details
`TrialBalance`	reference	yes	→ SubsidiaryTrialBalances
`LocalAccountCode`	text	yes	Source line as submitted
`LocalAccountName`	text
`ConsolidationAccount`	reference		→ ConsolidationCoA; may be absent during import exception, required for validation and acceptance
`LocalDebit`	decimal	yes	In the entity's FunctionalCurrency
`LocalCredit`	decimal	yes	In the entity's FunctionalCurrency
`LocalNet`	decimal	yes	fx: LocalDebit − LocalCredit
`MappingException`	boolean		True when no mapping resolved at import
`HistoricalBasis`	text		Preserved source layer needed for historical translation

FXRatesExchange rates for translation. One row permaster

Field	Type	Required	Details
`FromCurrency`	text	yes	A ForeignCurrency code
`ToCurrency`	text	yes	Always USD for this app
`RateType`	select	yes	SpotPeriodEnd, AverageMonth, AverageQuarter, AverageYear, Historical
`EffectiveDate`	date	yes
`Period`	reference		→ ConsolidationPeriods (set for SpotPeriodEnd / Average* rows)
`Rate`	number	yes	1 FromCurrency = Rate USD
`Source`	select	yes	CentralBankFeed, Bloomberg, Reuters, Manual, Integration
`LoadedAt`	date	yes
`Active`	boolean	yes
`HistoricalBasis`	text		Historical transaction/layer key where required
`SourceEvidence`	attachment	yes	Reviewed source rate evidence
`PreparedBy`	reference	yes	→ Employees; resolved preparation principal
`ApprovedBy`	reference		→ Employees; independent reviewer for manual replacement
`Status`	select	yes	Draft, Submitted, Approved, Rejected, Superseded

FXTranslationRulesReviewed account or account-class translation treatment. The configured method determines the closing, average or historical rate requirements; it does not provide universal accounting certification.master

Field	Type	Required	Details
`RuleCode`	text	yes
`ConsolidationAccount`	reference		→ ConsolidationCoA — null = applies to all in AccountSubType
`AccountSubType`	select		CurrentAsset, NonCurrentAsset, CurrentLiability, NonCurrentLiability, Equity-Common, Equity-AOCI, Equity-NCI, Revenue, COGS, OperatingExpense, OtherIncomeExpense, IncomeTaxExpense
`TranslationMethod`	select	yes	CurrentRate, AverageRate, HistoricalRate
`RateTypeUsed`	select	yes	SpotPeriodEnd, AverageMonth, AverageQuarter, AverageYear, Historical
`RoundsToCTA`	boolean	yes	Reviewed attribution policy for this rule; never infer a universal treatment from account type alone
`GAAPReference`	text		e.g. "ASC 830-30-45"
`Active`	boolean	yes

TranslatedBalancesSource-line and historical-layer outputs of one frozen run. Apply the approved rate before grouping by account; retain the source line, rate and method.transaction

Field	Type	Required	Details
`LegalEntity`	reference	yes	→ LegalEntities
`Period`	reference	yes	→ ConsolidationPeriods
`ConsolidationAccount`	reference	yes	→ ConsolidationCoA
`LocalAmount`	decimal	yes	In entity FunctionalCurrency, signed (Dr+ / Cr−)
`LocalCurrency`	text	yes
`FXRule`	reference	yes	→ FXTranslationRules
`FXRate`	reference	yes	→ FXRates
`RateValue`	number	yes	Snapshot of FXRates.Rate at job time
`TranslatedAmountUSD`	decimal	yes	LocalAmount × RateValue
`CTAComponent`	decimal		Workpaper attribution only; totals reconcile to the required closing adjustment, not an independently additive period charge
`TranslatedAt`	date	yes
`BalanceNumber`	text	yes	Stable human-readable record number
`Run`	reference	yes	→ ConsolidationRuns; exact frozen input and output revision
`Status`	select	yes	Draft, Complete, Superseded
`SourceLine`	reference	yes	→ TrialBalanceLines; output grain is run plus source line/layer, aggregate after translation

CumulativeTranslationAdjustmentOpening, required closing and difference for one run. The current-period delta equals required closing less prior published closing; repeated calculation does not double the closing adjustment.transaction

Field	Type	Required	Details
`LegalEntity`	reference	yes	→ LegalEntities
`Period`	reference	yes	→ ConsolidationPeriods
`OpeningCTA`	decimal	yes	Carry-forward from prior period
`PeriodCTADelta`	decimal	yes	Server computed: RequiredClosingCTA minus OpeningCTA
`ClosingCTA`	decimal	yes	Server computed: OpeningCTA plus PeriodCTADelta equals RequiredClosingCTA
`ComputedAt`	date	yes
`AdjustmentNumber`	text	yes	Stable human-readable record number
`Run`	reference	yes	→ ConsolidationRuns; exact frozen input and output revision
`Status`	select	yes	Draft, Complete, Superseded
`RequiredClosingCTA`	decimal	yes	Reviewed closing balancing amount for the complete translated closing trial balance
`ConsolidationAccount`	reference	yes	→ ConsolidationCoA; reviewed equity/CTA account frozen in the run; one closing effect per entity and run

IntercompanyTransactionsIC AR / IC AP, IC sales / IC purchases, IC loans, IC interest,transaction

Field	Type	Required	Details
`ICTransactionNumber`	text	yes
`Period`	reference	yes	→ ConsolidationPeriods
`FromEntity`	reference	yes	→ LegalEntities — the side reporting the transaction
`ToEntity`	reference	yes	→ LegalEntities — the counterparty
`ICType`	select	yes	ICAR-AP, ICRevenueExpense, ICLoan, ICInterest, ICManagementFee, ICDividend, IntraGroupProfitInInventory, Other
`FromAccount`	reference	yes	→ ConsolidationCoA — typically IsIntercompany = true
`ToAccount`	reference		→ ConsolidationCoA — paired account on the counterparty
`LocalAmount`	decimal	yes	In FromEntity's FunctionalCurrency
`LocalCurrency`	text	yes
`AmountUSD`	decimal		Reviewed reporting-currency amount from the applicable frozen account/rate basis; do not apply a closing rate to every IC type
`ReportedBy`	reference	yes	→ Employees (Subsidiary Controller of FromEntity)
`ReportedAt`	date	yes
`SourceRef`	text		Source GL JE / Invoice / Bill ID
`Status`	select	yes	Reported, Matched, Disputed, Superseded

ICReconciliationMatch status of an IC pair. One row per (FromEntity, ToEntity,transaction

Field	Type	Required	Details
`Period`	reference	yes	→ ConsolidationPeriods
`FromEntity`	reference	yes	→ LegalEntities
`ToEntity`	reference	yes	→ LegalEntities
`ICType`	select	yes	ICAR-AP, ICRevenueExpense, ICLoan, ICInterest, ICManagementFee, ICDividend, IntraGroupProfitInInventory, Other
`FromSideAmountUSD`	decimal	yes
`ToSideAmountUSD`	decimal	yes
`Difference`	decimal	yes	fx: FromSideAmountUSD + ToSideAmountUSD // sign convention pairs to ~0
`ToleranceUSD`	decimal	yes	Materiality threshold for auto-match
`Status`	select	yes	Matched, Unmatched, WithinTolerance, Disputed, Eliminated
`MatchedAt`	date
`Elimination`	reference		→ Eliminations — set when paired JE is generated
`ReconciliationNumber`	text	yes	Stable human-readable record number
`Run`	reference	yes	→ ConsolidationRuns; exact calculation context
`SourceIdentities`	longtext	yes	Normalised reciprocal source document/line identity and allocated amount set; consume each side once per run
`DispositionEvidence`	attachment		Required reviewed disposition for nonzero difference or override
`PreparedBy`	reference	yes	→ Employees
`ApprovedBy`	reference		→ Employees; independent exception reviewer

ICDisputesA retained difference between reciprocal source balances. An independently approved disposition may resolve the work item, but cannot fabricate a match or permit an unbalanced elimination.transaction

Field	Type	Required	Details
`DisputeNumber`	text	yes
`Period`	reference	yes	→ ConsolidationPeriods
`Reconciliation`	reference	yes	→ ICReconciliation
`FromEntity`	reference	yes	→ LegalEntities
`ToEntity`	reference	yes	→ LegalEntities
`DifferenceUSD`	decimal	yes
`DisputeReason`	select	yes	TimingDifference, AmountMismatch, NotBookedOtherSide, FXMismatch, ClassificationMismatch, Other
`RaisedBy`	reference	yes	→ Employees
`RaisedAt`	date	yes
`Status`	select	yes	Open, InReview, Resolved, OverriddenByConsolMgr
`Resolution`	text
`ResolvedBy`	reference		→ Employees
`ResolvedAt`	date

EliminationsAuto-generated (and occasionally manual) elimination journaltransaction

Field	Type	Required	Details
`EliminationNumber`	text	yes
`Period`	reference	yes	→ ConsolidationPeriods
`EliminationType`	select	yes	ICAR-AP, ICRevenueExpense, Investment-Equity, IntraGroupProfit, ICLoanInterest, ICDividend, Other
`Source`	select	yes	AutoFromMatcher, ManualByConsolMgr, TopSideRouting
`FromEntity`	reference		→ LegalEntities — null for entity-pair-agnostic eliminations
`ToEntity`	reference		→ LegalEntities
`TotalDebitUSD`	decimal	yes	fx: SUM(EliminationLines.DebitUSD)
`TotalCreditUSD`	decimal	yes	fx: SUM(EliminationLines.CreditUSD)
`BalanceCheck`	decimal	yes	fx: TotalDebitUSD − TotalCreditUSD // must be 0
`Status`	select	yes	Draft, Submitted, Approved, Posted, Rejected, Reversed
`GeneratedAt`	date	yes
`ApprovedBy`	reference		→ Employees; independent Consolidation Manager for analyst preparation, or Group Controller / Corporate CFO for manager preparation
`ApprovedAt`	date
`Run`	reference	yes	→ ConsolidationRuns; exact calculation context
`PreparedBy`	reference	yes	→ Employees; includes initiating actor for generated candidates
`Workpaper`	attachment		Required for manual, acquisition, investment/equity or complex elimination treatment
`ReversalOf`	reference		→ Eliminations; posted correction uses linked reversal

EliminationLinesOne Dr / Cr line per `ConsolidationCoA` target on an eliminationline

Field	Type	Required	Details
`Elimination`	reference	yes	→ Eliminations
`ConsolidationAccount`	reference	yes	→ ConsolidationCoA
`Description`	text
`DebitUSD`	decimal	yes	0 if credit line
`CreditUSD`	decimal	yes	0 if debit line
`RelatedEntity`	reference		→ LegalEntities — for traceability on entity-specific eliminations

MinorityInterestReviewed allocation per subsidiary and run. The simple common-equity formula uses the approved basis; complex ownership and rights need the configured specialist workpaper.transaction

Field	Type	Required	Details
`Subsidiary`	reference	yes	→ LegalEntities
`Period`	reference	yes	→ ConsolidationPeriods
`OwnershipStructure`	reference	yes	→ OwnershipStructure — the row in effect at PeriodEnd
`OwnershipPctParent`	number	yes	0–100 — parent's controlling share
`NCIPct`	decimal	yes	fx: 100 − OwnershipPctParent
`SubsidiaryEquityUSD`	decimal	yes	Translated equity of the sub
`SubsidiaryNetIncomeUSD`	decimal	yes	Translated NI for the period
`NCIBalance`	decimal	yes	fx: SubsidiaryEquityUSD × NCIPct / 100
`NCIShareOfNetIncome`	decimal	yes	fx: SubsidiaryNetIncomeUSD × NCIPct / 100
`ComputedAt`	date	yes
`AllocationNumber`	text	yes	Stable human-readable record number
`Run`	reference	yes	→ ConsolidationRuns; exact frozen input and output revision
`Status`	select	yes	Draft, Complete, Superseded
`AllocationEvidence`	attachment	yes	Approved simple/common-equity basis or specialist method for complex/effective-date allocation

TopSideAdjustmentsCorporate-level adjustments that don't belong in any subsidiary'stransaction

Field	Type	Required	Details
`AdjustmentNumber`	text	yes
`Period`	reference	yes	→ ConsolidationPeriods
`ConsolidationAccount`	reference	yes	→ ConsolidationCoA
`OffsetAccount`	reference	yes	→ ConsolidationCoA — the contra side, must balance
`Reason`	select	yes	Reclassification, Materiality, GAAPAdjustment, TrueUp, AcquisitionAccounting, Other
`Description`	text	yes
`AmountUSD`	decimal	yes	Signed (Dr+ on AmountUSD, Cr+ implicit on offset)
`RaisedBy`	reference	yes	→ Employees (Consolidation Manager / Analyst)
`RaisedAt`	date	yes
`ApprovedBy`	reference		→ Employees (Group Controller)
`ApprovedAt`	date
`Status`	select	yes	Draft, Submitted, Approved, Rejected, Posted
`SupportingFileURL`	text		Working-paper attachment
`Run`	reference	yes	→ ConsolidationRuns; exact calculation context

ConsolidatedTrialBalanceAccount-level group result from one frozen complete run. Include translated balances, the closing CTA account effect, posted elimination history with linked reversals, approved paired top-side effects and supported balanced NCI reclassifications.transaction

Field	Type	Required	Details
`Period`	reference	yes	→ ConsolidationPeriods
`ConsolidationAccount`	reference	yes	→ ConsolidationCoA
`TranslatedSubtotalUSD`	decimal	yes	Sum of TranslatedBalances across consolidated entities
`EliminationsUSD`	decimal	yes	Sum signed debit-minus-credit effects from posted history in the selected run: include Posted and Reversed originals once and each Posted linked reversal once
`NCIAllocationUSD`	decimal	yes	Supported balanced reclassification effect for this account, with equal offset; never add total subsidiary equity twice
`TopSideAdjustmentsUSD`	decimal	yes	Sum approved current run adjustments: AmountUSD on ConsolidationAccount and negative AmountUSD on OffsetAccount
`ConsolidatedBalanceUSD`	decimal	yes	fx: TranslatedSubtotalUSD + CTAAmountUSD + EliminationsUSD + NCIAllocationUSD + TopSideAdjustmentsUSD
`BuiltAt`	date	yes
`BalanceNumber`	text	yes	Stable human-readable record number
`Run`	reference	yes	→ ConsolidationRuns; exact frozen input and output revision
`Status`	select	yes	Draft, Complete, Superseded
`CTAAmountUSD`	decimal	yes	Sum RequiredClosingCTA for this account from Complete CumulativeTranslationAdjustment rows in the same run; never add OpeningCTA or PeriodCTADelta again

ConsolidatedFinancialsReviewed statements generated from one selected complete run and supporting movement evidence. Signed is private; publication commits an immutable artifact set and financial lock together.transaction

Field	Type	Required	Details
`Period`	reference	yes	→ ConsolidationPeriods
`StatementType`	select	yes	IncomeStatement, BalanceSheet, CashFlowStatement, StatementOfEquity, ManagementSummary
`ReportingCurrency`	text	yes	USD
`GAAPBasis`	select	yes	USGAAP
`FileURL`	text	yes	PDF
`DataURL`	text		JSON snapshot
`Status`	select	yes	Draft, Reviewed, Signed, Published, Restated
`PreparedBy`	reference	yes	→ Employees
`ReviewedBy`	reference		→ Employees (Consolidation Manager)
`SignedBy`	reference		→ Employees (Group Controller / Corporate CFO)
`SignedAt`	date
`RestatementOf`	reference		→ ConsolidatedFinancials (self)
`StatementNumber`	text	yes	Stable human-readable record number
`Run`	reference	yes	→ ConsolidationRuns; exact calculation context
`PreparedAt`	datetime	yes	Server preparation timestamp
`PublicationReceipt`	text		Immutable artifact-set identity, digests and financial revision; required only when Status is Published

DisclosuresNarrative footnotes attached to a `ConsolidatedFinancials`transaction

Field	Type	Required	Details
`DisclosureNumber`	text	yes
`Period`	reference	yes	→ ConsolidationPeriods
`RelatedStatement`	reference		→ ConsolidatedFinancials
`Topic`	select	yes	AccountingPolicies, Segment, RelatedParty, SubsequentEvents, Commitments, Contingencies, FXRisk, Concentrations, Other
`Narrative`	text	yes	Footnote text
`AuthoredBy`	reference	yes	→ Employees
`ApprovedBy`	reference		→ Employees (Group Controller)
`Status`	select	yes	Draft, Reviewed, Approved, Published
`PreparedAt`	datetime	yes	Server preparation timestamp

BoardPackExportsA pack generated from the already published financial artifact set. Signed-but-unpublished documents cannot be distributed or read by executive readers.transaction

Field	Type	Required	Details
`ExportNumber`	text	yes
`Period`	reference	yes	→ ConsolidationPeriods
`GeneratedAt`	date	yes
`FileURL`	text	yes	PDF
`DataURL`	text		JSON snapshot of pack contents
`DistributedAt`	date
`Status`	select	yes	Generated, Distributed, Viewed, Archived
`Publication`	reference	yes	→ ConsolidatedFinancials; published artifact set only

BoardPackDistributionsPer-Recipient distribution log for a `BoardPackExports` row —line

Field	Type	Required	Details
`BoardPackExport`	reference	yes	→ BoardPackExports
`Recipient`	reference	yes	→ Employees
`DistributedAt`	date	yes
`ViewedAt`	date
`AccessRevoked`	boolean
`Status`	select	yes	Pending, Delivered, Failed, Viewed, Revoked

EmployeesAuthenticated staff and reader identities; role assignments and entity grants are server-controlled.master

Field	Type	Required	Details
`EmployeeNumber`	text	yes	Stable principal number
`PrincipalId`	text	yes	Authenticated immutable identifier
`FullName`	text	yes
`LegalEntity`	reference		→ LegalEntities; subsidiary scope
`Active`	boolean	yes
`AccessExpiresAt`	datetime		Required for time-limited auditor engagement

ConsolidationRunsImmutable input snapshot and atomic output candidate for a financial revision.transaction

Field	Type	Required	Details
`RunNumber`	text	yes
`Period`	reference	yes	→ ConsolidationPeriods
`Revision`	number	yes	Monotonic period financial revision
`SourceDigest`	text	yes	Digest of accepted input identities and approved policy versions
`Inputs`	longtext	yes	Required entity population, accepted submission ids, mapping/ownership/rate versions and approved workpapers
`Status`	select	yes	Draft, Ready, Computing, Complete, Failed, Superseded
`StartedAt`	datetime
`CompletedAt`	datetime
`PreparedBy`	reference	yes	→ Employees
`ReviewedBy`	reference		→ Employees; independent financial reviewer
`ErrorDetails`	longtext		Retained unresolved inputs or failed validations

FXRateRequirementsThe actual required rate inventory; an absent rate remains a record with an unresolved state.transaction

Field	Type	Required	Details
`RequirementNumber`	text	yes
`Run`	reference	yes	→ ConsolidationRuns
`FromCurrency`	text	yes
`RateType`	select	yes	SpotPeriodEnd, AverageMonth, AverageQuarter, AverageYear, Historical
`EffectiveDate`	date	yes
`HistoricalBasis`	text		Required historical transaction or layer identity where applicable
`FXRate`	reference		→ FXRates; match direction, date, type and reviewed historical layer
`Status`	select	yes	Missing, PendingReview, Resolved

ConsolidationMovementsReviewed cash-flow and equity movement workpapers, including acquisition, disposal, FX and non-cash explanations.transaction

Field	Type	Required	Details
`MovementNumber`	text	yes
`Run`	reference	yes	→ ConsolidationRuns
`LegalEntity`	reference	yes	→ LegalEntities
`ConsolidationAccount`	reference	yes	→ ConsolidationCoA
`MovementDate`	date	yes
`Category`	select	yes	Operating, Investing, Financing, FXOnCash, Acquisition, Disposal, NonCash, Equity, Other
`AmountUSD`	decimal	yes	Signed reporting-currency movement under reviewed classification
`SourceEvidence`	attachment	yes
`PreparedBy`	reference	yes	→ Employees
`ApprovedBy`	reference		→ Employees; independent reviewer
`Status`	select	yes	Draft, Submitted, Approved, Rejected

ERP•AI workspace

Start now Financial Consolidation

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

Start now Download agent

Previous · reference 2 of 6Consolidation reports Next · reference 4 of 6Integrations

Financial Consolidation

Modules

Financial Consolidation

Processes

Financial Consolidation

Industries

Financial Consolidation

Reference

Financial Consolidation

Data model

How the model is organised

Entities and ownership

Source balances and mappings

Run and translation inputs

Reconciliation and adjustments

Published results

Keys and references

Migration order

Tables

Start now Financial Consolidation

Financial Consolidation

Modules

Financial Consolidation

Processes

Financial Consolidation

Industries

Financial Consolidation

Reference

Data model

How the model is organised

Entities and ownership

Source balances and mappings

Run and translation inputs

Reconciliation and adjustments

Published results

Keys and references

Migration order

Tables

Start now Financial Consolidation

Your Privacy, Your Choice

Manage Your Cookie Preferences