Data model

Explore the records connecting contracts, project work and company finance.

134 tables · 837 relationships

How the model is organised

Estimates & contracts

Accounts, ContactPersons, PaymentTerms, PriceLists, PriceListEntries, Quotes, QuoteLines, EstimateComponents, SalesOrders, SalesOrderLines, SalesAllocations, CreditReviews, ProjectContracts, PerformanceObligations, PerformanceAllocations, ProjectChanges, ProjectChangeLines. Customer identities, accepted offers, estimate components, contract obligations and approved changes.

Accounts
ContactPersons
PaymentTerms
PriceLists
PriceListEntries
Quotes
QuoteLines
EstimateComponents
SalesOrders
SalesOrderLines
SalesAllocations
CreditReviews
ProjectContracts
PerformanceObligations
PerformanceAllocations
ProjectChanges
ProjectChangeLines

Projects & costs

Projects, ProjectSites, CostCodes, ProjectBudgets, ProjectBudgetLines, ProjectForecasts, ProjectForecastLines, ProjectCommitments, ProjectCostEntries, ProjectCostAllocations, ProjectMaterialRequirements, ProjectMaterialUsages, CostResources, CostRateVersions, ProjectWorkLogs, ProjectWorkAllocations. Projects, sites, cost codes, approved budgets, commitments, actual cost sources and reviewed forecasts.

Projects
ProjectSites
CostCodes
ProjectBudgets
ProjectBudgetLines
ProjectForecasts
ProjectForecastLines
ProjectCommitments
ProjectCostEntries
ProjectCostAllocations
ProjectMaterialRequirements
ProjectMaterialUsages
CostResources
CostRateVersions
ProjectWorkLogs
ProjectWorkAllocations

Purchasing & subcontractors

Suppliers, SupplierBankAccounts, Requisitions, RequisitionLines, PurchaseOrders, PurchaseOrderLines, GoodsReceipts, GoodsReceiptLines, ReceiptAcceptances, BillMatches, Subcontracts, SubcontractLines, SubcontractApplications, SubcontractApplicationLines, SubcontractAcceptances, SubcontractAcceptanceLines, SubcontractAccruals. Supplier terms, approved purchasing, actual receipt acceptance, subcontract work evidence, accruals and bill matching.

Suppliers
SupplierBankAccounts
Requisitions
RequisitionLines
PurchaseOrders
PurchaseOrderLines
GoodsReceipts
GoodsReceiptLines
ReceiptAcceptances
BillMatches
Subcontracts
SubcontractLines
SubcontractApplications
SubcontractApplicationLines
SubcontractAcceptances
SubcontractAcceptanceLines
SubcontractAccruals

Materials & sites

Products, UnitsOfMeasure, ProductUnits, Warehouses, Locations, Lots, Serials, InventoryPositions, StockLayers, StockEvents, StockMovements, InventoryReservations, StockTransfers, StockTransferLines, CountLocks, InventoryCounts, CountLines, PickTasks, Shipments, ShipmentLines, DeliveryConfirmations, Returns, ReturnLines, ReturnDispositions. Canonical items and units, owned stock, custody, exact quantity claims, actual movements, handover and returns.

Products
UnitsOfMeasure
ProductUnits
Warehouses
Locations
Lots
Serials
InventoryPositions
StockLayers
StockEvents
StockMovements
InventoryReservations
StockTransfers
StockTransferLines
CountLocks
InventoryCounts
CountLines
PickTasks
Shipments
ShipmentLines
DeliveryConfirmations
Returns
ReturnLines
ReturnDispositions

Production & prefabrication

BOMs, BOMLines, ProductionRoutings, RoutingOperations, WorkOrders, WorkOrderMaterials, WorkOrderOperations, ProductionEntries, ProductionCompletions, WorkOrderCostEntries. Approved bills of material and routing, released work, actual resources, accepted output and cost reconciliation.

BOMs
BOMLines
ProductionRoutings
RoutingOperations
WorkOrders
WorkOrderMaterials
WorkOrderOperations
ProductionEntries
ProductionCompletions
WorkOrderCostEntries

Billing & collections

ProgressApplications, ProgressApplicationLines, ProgressCertificates, ProgressCertificateLines, BillingObligations, BillingAllocations, Invoices, InvoiceLines, CashReceipts, CashApplications, CreditApplications, Refunds, FinanceCorrections, RetentionBalances, RetentionMovements, AdvanceAllocations. Progress applications and certification, eligible billing scope, invoices, actual cash, retention, advances and corrections.

ProgressApplications
ProgressApplicationLines
ProgressCertificates
ProgressCertificateLines
BillingObligations
BillingAllocations
Invoices
InvoiceLines
CashReceipts
CashApplications
CreditApplications
Refunds
FinanceCorrections
RetentionBalances
RetentionMovements
AdvanceAllocations

Finance

Entities, Currencies, ExchangeRates, AccountingPeriods, ChartOfAccounts, TaxCodes, StandardCosts, PostingProfiles, Bills, BillLines, BankAccounts, BankStatementLines, PaymentRuns, Payments, PaymentAllocations, RevaluationRuns, RevaluationLines, JournalEntries, JournalLines, CloseTasks, RevenueAssessments, RevenueAssessmentLines, ContractBalances, ContractBalanceMovements. Company books, currencies, accounts, supplier balances, current carrying, recognition assessments and contract-position movements.

AccountingPeriods
ChartOfAccounts
PaymentTerms
Accounts
SupplierBankAccounts
Invoices
InvoiceLines
BankAccounts
PaymentRuns
Payments
PaymentAllocations
JournalEntries
JournalLines

Reporting

Users, ConstructionPolicies, MasterChanges, DocumentRevisions, ApprovalDecisions, AuthorityDelegations, IntegrationEvents, IntegrationDeliveries, MigrationBatches, MigrationItems. User scope, operating policies, immutable revisions, independent decisions, integration outcomes and migration identity.

Users
ConstructionPolicies
MasterChanges
DocumentRevisions
ApprovalDecisions
AuthorityDelegations
IntegrationEvents
IntegrationDeliveries
MigrationBatches
MigrationItems

Keys and references

Each company owns its contracts, goods and financial effects. Projects, sites and cost codes identify where work belongs. Canonical products and units preserve comparable quantities, while retained conversions and required lot or serial identity connect physical events to their original source.

Accepted estimate and contract revisions preserve the commercial baseline. Approved budgets describe expected costs; purchase and subcontract commitments describe authorized work still to be fulfilled. Actual cost sources and reviewed forecasts retain their separate meaning. Report calculations cannot turn a budget, supplier bill or payment into another cost for work already counted.

Owned materials remain stock while held at a warehouse or site. Actual consumption creates the eligible project-cost effect. Prefabrication keeps issued work in progress exclusive from inventory, then accepted terminal output produces finished stock and relieves its actual cost basis. Project use of that output retains the carrying amount and its production lineage.

Accepted subcontract work creates its own job cost and accrued liability. Later bills clear the exact matched accrual, with only the reviewed difference receiving a new financial effect. Customer progress applications, external certification, eligible billed scope and actual collections retain different records and dates.

Performance obligations retain the allocated price and approved recognition evidence. Recognition, billing and assigned advances feed the contract position through their own movements. Obligation detail rolls up at the reviewed accounting-contract unit before presenting a net contract asset or liability; unrelated contracts and companies stay separate. Unconditional receivables retain their own balance.

Conditional retention identifies part of the existing contract position; it does not create another asset. Unconditional held amounts remain within the appropriate gross customer or supplier balance, with separate due and release information. Advances and their recovery consume exact remaining source amounts. Release, application and correction preserve the original entitlement without repeating revenue or cost.

Migration order

Establish ownership and approved masters
Ends with: Map companies, users, customers, suppliers, projects, sites and cost codes. Prepare units, accounts, currencies, reviewed rates, warehouses and any approved production recipes before linking operating history.
Preserve accepted scope and current resources
Ends with: Import accepted estimates and contracts, approved changes, budgets, remaining commitments, stock and production work in progress. Keep original quantities, performed work, cost sources and open claims without receiving, consuming or producing them again.
Reconcile contract and financial detail once
Ends with: Reconcile one opening ledger with nonposting customer and supplier balances, accepted subcontract accruals, prior progress and billing, recognition positions, retention, advances and settlements. Preserve current carrying, prior currency adjustments and the exact remaining source allocations.
Verify the cutoff and activate the first scope
Ends with: Resolve typed references and compare every opening source population with its control. Obtain the required project, inventory and finance review, retain external economic identifiers and uncertain claims, then enable eligible new work after the agreed cutoff.

Tables

Find a table 134 tables

UsersAuthenticated actors and explicit entity/role scope; no party record automatically creates an account.master

Field	Type	Required	Details
`UserKey`	text	yes	Stable provider/subject and actual-person identity; two accounts of one person are not independent.
`DisplayName`	text	yes	Internal display name.
`ActorType`	select	yes	Human, Service
`Status`	select	yes	Active, Suspended, Disabled
`Roles`	longtext	yes	Subset of the thirteen declared roles; actual-person identity, current scope and independence are checked at every action. Services cannot sign human decisions.
`EntityScope`	longtext	yes	Explicit Entities keys; current scope checked on every read/action/export.
`WarehouseScope`	longtext		Explicit permitted Warehouses; absent does not mean global access.
`ExpiresAt`	datetime		Scope expiry.
`ScopeChange`	reference		→ MasterChanges. Independent domain-reviewed grant of roles/entities/warehouse scope; Admin cannot self-grant business authority. Revocation may restrict immediately.
`ProjectScope`	longtext	yes	Explicit permitted project keys and authorized goods-contract scope; no unrestricted access from an empty value. Financial access additionally requires entity/role scope.

EntitiesSeparate legal books and stock ownership; shared masters do not consolidate balances.master

Field	Type	Required	Details
`EntityCode`	text	yes	Unique legal entity code.
`Name`	text	yes	Legal name.
`FunctionalCurrency`	reference	yes	→ Currencies. One functional currency; changing it requires separately scoped migration.
`Timezone`	text	yes	IANA business timezone; timestamps retain offsets.
`Status`	select	yes	Setup, Active, Closed
`Policy`	reference		→ ConstructionPolicies. Approved active entity policy.

CurrenciesCurrency precision and display rules.master

Field	Type	Required	Details
`Code`	text	yes	Unique currency code.
`DecimalPlaces`	number	yes	Nonnegative permitted precision.
`Status`	select	yes	Active, Inactive

ExchangeRatesImmutable dated conversion evidence; no hidden fallback.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`FromCurrency`	reference	yes	→ Currencies. Source currency.
`ToCurrency`	reference	yes	→ Currencies. Target currency, including authority-limit conversion pairs.
`RateDate`	date	yes	Business effective date.
`RateType`	select	yes	Transaction, Settlement, Closing, Authority
`Multiplier`	decimal	yes	Strictly positive; target amount = source × multiplier. Identity conversion is 1.
`Source`	text	yes	Approved provider/manual evidence identifier.
`Status`	select	yes	Draft, Approved, Superseded
`ApprovedBy`	reference		→ Users. Independent Finance Manager; never the preparer/editor. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`ApprovedAt`	datetime		Actual confirmation time. Absent until the real action; mandatory before the corresponding active/approved/posted state.

AccountingPeriodsEntity-specific fiscal periods and guarded close.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`PeriodCode`	text	yes	Unique within entity.
`StartDate`	date	yes	Inclusive posting date.
`EndDate`	date	yes	Inclusive posting date; nonoverlap.
`Status`	select	yes	Open, SoftClosed, Closed
`ClosedAt`	datetime		Actual hard-close time.
`Decision`	reference		→ ApprovalDecisions. Independent Finance Manager close/reopen decision and cutoff evidence.

ChartOfAccountsEntity ledger accounts, including controlled subledger accounts.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`AccountCode`	text	yes	Unique within entity.
`Name`	text	yes	Account label.
`Type`	select	yes	Asset, Liability, Equity, Revenue, Expense
`ControlKind`	select	yes	None, AR, AP, Inventory, WIP, GRNI, Bank, UnappliedCustomer, UnappliedSupplier, CustomerCredit, SupplierCredit, ProcessorClearing, ProcessorSuspense, Tax
`Status`	select	yes	Draft, Active, Inactive
`Activation`	reference		→ MasterChanges. Independent Finance Manager activation; direct journals cannot bypass subledger controls.

TaxCodesConfigured additive tax treatment and evidence; no universal tax engine or filing claim.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Code`	text	yes	Unique effective code/version.
`RatePercent`	decimal	yes	Explicit nonnegative percentage, divided by 100 exactly once.
`Treatment`	select	yes	AdditiveSales, RecoverablePurchase, NonrecoverablePurchase, Exempt
`EffectiveFrom`	date	yes	Inclusive.
`EffectiveTo`	date		Exclusive.
`Evidence`	longtext	yes	Jurisdiction, taxable basis/exemption evidence and configured calculation boundary.
`PostingAccount`	reference	yes	→ ChartOfAccounts. Correct tax control/expense treatment; nonrecoverable purchase follows approved cost policy.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Finance Manager decision.

PaymentTermsDue-date terms, independent of actual cash settlement.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`TermsCode`	text	yes	Unique terms version.
`DueDays`	number	yes	Nonnegative days from invoice date, using explicit business-date convention.
`Status`	select	yes	Draft, Active, Inactive
`Activation`	reference		→ MasterChanges. Independent Finance Manager review.

ConstructionPoliciesVersioned operational and financial rules with explicit finite limits.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`PolicyNumber`	text	yes	Unique policy version.
`Status`	select	yes	Draft, PendingApproval, Active, Superseded
`EffectiveFrom`	datetime	yes	Inclusive activation boundary; no retroactive unreviewed change.
`EffectiveTo`	datetime		Exclusive.
`AuthorityCurrency`	reference	yes	→ Currencies. Currency of finite approval/credit/count limits.
`Rules`	longtext	yes	Validated action/role/person rules, finite entity/project/warehouse limits, currencies/effectivity, estimates/price/tax, project budgets/changes, work/certification, stock/cost/production and subcontract rules. No implicit auto approval, payroll/fleet/bank installation or statutory rate.
`CountQuantityTolerance`	decimal	yes	Nonnegative base-quantity absolute threshold by configured unit/product class; dimensionally incompatible quantities are never summed.
`CountPercentTolerance`	decimal	yes	Nonnegative percentage; expected zero gives unavailable percentage and review.
`CountValueThreshold`	decimal	yes	Nonnegative functional-value escalation threshold; unknown value is not zero.
`ShipmentTitleRule`	select	yes	Handover. Verified actual customer handover/pickup or carrier dispatch is sole goods title/COGS event; project-site transfer/consumption and work acceptance are separate effects.
`PreparedBy`	reference	yes	→ Users. Admin prepares configuration; Warehouse Manager operational, Production Manager recipe/execution, Commercial Manager commercial and Finance Manager financial decisions are independent of preparer/material editors.
`OperationalDecision`	reference		→ ApprovalDecisions. Independent Warehouse Manager decision for operational rules. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager decision for finance/cost/authority rules. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`ProductionDecision`	reference		→ ApprovalDecisions. Independent Production Manager for assembly/kitting/repacking rules.
`PaymentPolicy`	longtext		Verified actual bank/cash evidence, independent release/refund authority, uncertainty/reconciliation, customer/SC advance purpose, retained due eligibility and source currency limits; no gateway/processor assumption.
`CommercialDecision`	reference		→ ApprovalDecisions. Independent Commercial Manager for estimate/price/customer-contract/commercial application rules.
`ProjectRules`	longtext	yes	Approved original/revised budget and cumulative financial caps; Project Manager technical plus Finance Manager budget decision; forecast remainder disclosures; independent Site Supervisor internal work and Project Manager subcontract acceptance; customer certificate verification separate from local approval.
`RecognitionRules`	longtext	yes	Finance Manager approves accounting-unit grouping, performance allocations, OutputProgress/PointInTime evidence and cumulative revenue, retained right/tax conditions and advance monetary/historical carrying. Default statutory retention, cost-to-cost revenue, automatic consolidation and T&M billing are unsupported.

MasterChangesProtected master activation without direct Manage permission bypass.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`ChangeNumber`	text	yes	Unique change request.
`TargetTable`	text	yes	Existing allowed master table.
`TargetKey`	text	yes	Exact immutable record/version key.
`Status`	select	yes	Draft, Submitted, Approved, Applied, Rejected, Cancelled
`BeforeHash`	text	yes	Expected prior content or explicit create marker.
`ProposedContent`	longtext	yes	Exact after-content and affected transactions.
`ProposedHash`	text	yes	Frozen proposed content.
`PreparedBy`	reference	yes	→ Users. Actual person.
`SubmittedAt`	datetime		Actual submission time. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`Decision`	reference		→ ApprovalDecisions. Independent affected domain owner: Finance Manager finance/cost/tax/authority; Commercial Manager customer/price/contract; Purchasing Manager supplier; Warehouse Manager stock; Production Manager prefab technical; Project Manager project scope. All affected decisions bind one current request.
`AppliedAt`	datetime		Guarded application; changes do not rewrite accepted or posted source snapshots.
`OperationalDecision`	reference		→ ApprovalDecisions. Independent Warehouse Manager for stock/location/fulfillment; production technical changes need their separate Production Manager decision.
`FinanceDecision`	reference		→ ApprovalDecisions. Required independent Finance Manager for costs/limits/beneficiary/tax/posting/price-floor changes.
`CommercialDecision`	reference		→ ApprovalDecisions. Required independent Commercial Manager for customer/price commercial changes.
`ProductionDecision`	reference		→ ApprovalDecisions. Independent Production Manager for BOM/routing/execution changes.

DocumentRevisionsImmutable typed document snapshots and source basis.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`RevisionNumber`	text	yes	Unique target/revision key.
`TargetTable`	text	yes	Exact allowed existing table name, validated against source record.
`TargetKey`	text	yes	Exact immutable primary identifier.
`Revision`	number	yes	Monotonic revision.
`Status`	select	yes	Submitted, Approved, Accepted, Posted, Superseded, Cancelled
`ContentHash`	text	yes	Canonical body/lines/source/rates/cost/tax hash.
`Content`	longtext	yes	Complete frozen content, material editor person IDs, related source versions and scoped allocations.
`PreparedBy`	reference	yes	→ Users. Actual preparer.
`FrozenAt`	datetime	yes	Actual freeze time.

ApprovalDecisionsAuthoritative human decisions independent of document lifecycle.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`DecisionNumber`	text	yes	Unique decision identity.
`Action`	select	yes	MasterActivation, PolicyActivation, QuoteException, OrderAcceptance, ContractActivation, PerformancePolicy, ProjectChange, BudgetApproval, ForecastApproval, WorkAcceptance, SubcontractAcceptance, ProgressApplication, CertificateVerification, RevenueRecognition, RetentionRelease, AdvanceAction, ProjectClose, ProjectFinanceClose, CreditException, PurchaseApproval, InvoiceApproval, BillException, PaymentRelease, Refund, FinanceCorrection, StockRelease, TransferApproval, CountAdjustment, ReturnAuthorization, ReturnDisposition, ShipmentRelease, ProductionRelease, ProductionTimeAcceptance, ProductionCompletion, ProductionVariance, ProductionClose, ProductionCloseFinance, JournalApproval, RevaluationApproval, PeriodClose, PeriodReopen, MigrationActivation
`Status`	select	yes	Pending, Approved, Rejected, Expired, Superseded
`Snapshot`	reference		→ DocumentRevisions. Required for revisioned transaction actions; master/policy request content hash otherwise retained in Scope.
`Scope`	longtext	yes	Exact typed source/action/revision, entity/project/warehouse, amount/currency/quantity/expiry, required joint source scope and excluded actual preparer/material-editor/performer/recorder identities. Generic status, external customer acceptance or a technical decision cannot substitute for required financial authority.
`RequestedBy`	reference	yes	→ Users. Actual preparer/requester.
`RequestedAt`	datetime	yes	Actual time.
`DecidedBy`	reference		→ Users. Actual independent human with declared required role, current scope and limit. Service/Admin privilege is not domain approval.
`DecidedAt`	datetime		Actual decision time.
`Delegation`	reference		→ AuthorityDelegations. Valid named delegate, preserving required role and actual-person independence.
`AuthorityRate`	reference		→ ExchangeRates. Exact currency conversion for limit test; no missing-rate fallback.
`AuthorityAmount`	decimal		Amount in delegated/role authority currency; cumulative relevant commitment and gross increases included.
`Reason`	longtext	yes	Decision rationale, rejected conditions and reviewed evidence.
`AssignedTo`	reference	yes	→ Users. Named eligible human reviewer when Pending; independence and current role/limit rechecked at decision.

AuthorityDelegationsTime- and scope-bounded coverage, never a new role.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`DelegationNumber`	text	yes	Unique authority grant.
`Principal`	reference	yes	→ Users. Original authorized human.
`Delegate`	reference	yes	→ Users. Different actual human already holding required declared role.
`RequiredRole`	select	yes	Commercial Manager, Purchasing Manager, Warehouse Manager, Finance Manager
`ActionScope`	longtext	yes	Exact actions/entities/warehouses and excluded documents.
`LimitCurrency`	reference	yes	→ Currencies. Authority currency.
`AmountLimit`	decimal	yes	Finite nonnegative ceiling; cannot exceed principal authority.
`StartsAt`	datetime	yes	Inclusive.
`EndsAt`	datetime	yes	Exclusive.
`Status`	select	yes	Draft, Active, Revoked, Expired
`GrantedBy`	reference	yes	→ Users. Independent same-domain authorized owner; no self-grant or approval escalation.

IntegrationEventsAuthenticated inbound/manual evidence with idempotent economic effects.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`EventNumber`	text	yes	Unique source event key.
`Source`	text	yes	Configured provider or reviewed manual source.
`ExternalKey`	text	yes	Unique within source/entity; preserve provider attempts and economic identity.
`Kind`	select	yes	Receipt, Shipment, Delivery, BankSettlement, BankRejection, BankReturn, DocumentAcknowledgment, Migration, Other
`Status`	select	yes	Received, Verified, Applied, Ignored, ReviewRequired, Rejected
`PayloadHash`	text	yes	Conflict on reused key blocks effects.
`Payload`	longtext	yes	Protected evidence and expected source/version mapping.
`OccurredAt`	datetime	yes	Actual source event time.
`ReceivedAt`	datetime	yes	Received time.
`VerifiedBy`	reference		→ Users. Human reviewer or authenticated configured service; role-required decisions separate.
`AppliedAt`	datetime		Atomic local effect time.

IntegrationDeliveriesOutbound intent, attempt and reconciliation; a timeout is not nonexecution.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`DeliveryNumber`	text	yes	Unique intent/attempt.
`EconomicKey`	text	yes	Stable economic operation and destination across retries.
`Destination`	text	yes	Configured exact connector/recipient; no invented endpoint.
`Snapshot`	reference		→ DocumentRevisions. Frozen payload source.
`PayloadHash`	text	yes	Exact expected payload.
`Status`	select	yes	Prepared, Submitted, Acknowledged, Rejected, Uncertain, Reconciled, Cancelled
`CreatedAt`	datetime	yes	Intent time.
`SubmittedAt`	datetime		Actual attempt time.
`ProviderKey`	text		Provider response identifier.
`Event`	reference		→ IntegrationEvents. Authoritative response; acknowledgment is not cash/title/delivery completion.
`RetryOf`	reference		→ IntegrationDeliveries. Only after proven nonexecution; uncertain operation remains reserved.

MigrationBatchesReviewed cutover: one full opening GL plus nonposting detailed balances.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`BatchNumber`	text	yes	Stable import identity.
`Status`	select	yes	Draft, Validating, PendingApproval, Approved, Applied, Rejected
`CutoffAt`	datetime	yes	Frozen source/system watermark.
`SourceHash`	text	yes	Immutable extraction digest.
`OpeningJournal`	reference	yes	→ JournalEntries. Single full opening journal including subledger controls; detail never reposts it.
`Reconciliation`	longtext	yes	AR/AP, credit/unapplied cash, bank, stock/transit/WIP, commitments and all nonposting opening detail totals.
`PreparedBy`	reference	yes	→ Users. Actual preparer.
`Decision`	reference		→ ApprovalDecisions. Independent Finance Manager activation plus Warehouse Manager stock and Production Manager WIP/output evidence. Required before Active; import does not replay operational or monetary effects.
`AppliedAt`	datetime		One successful baseline activation.

MigrationItemsReplay-safe original identities, detailed remaining balances and prior effects.line

Field	Type	Required	Details
`Batch`	reference	yes	→ MigrationBatches. Owning cutover.
`SourceKey`	text	yes	Stable source/type/ID; unique across repeated batches for same baseline.
`TargetTable`	text	yes	Existing permitted table name.
`TargetKey`	text	yes	Resolved local immutable key.
`PayloadHash`	text	yes	Conflicting replay requires review, never a second opening.
`Baseline`	longtext	yes	Original accepted/priced/received/shipped/delivered/invoiced/settled/cancelled amounts and quantities; current carrying/revaluation, stock layers, WIP, approvals and source-event watermarks.
`Status`	select	yes	Mapped, Validated, Applied, Conflict
`AppliedAt`	datetime		Nonposting detail activation time; notifications/dispatch/payment creation suppressed. Absent until the real action; mandatory before the corresponding active/approved/posted state.

CloseTasksCurrent source reconciliation evidence for an entity cutoff.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`TaskNumber`	text	yes	Unique period/check/cutoff scope.
`Period`	reference	yes	→ AccountingPeriods. Same entity.
`Kind`	select	yes	Bank, AR, AP, Inventory, Transit, WIP, GRNI, Tax, Credits, UnappliedCash, Revaluation, Interfaces
`Status`	select	yes	Open, InProgress, Complete, ReviewRequired, Waived
`Owner`	reference	yes	→ Users. Assigned Accountant or relevant operational evidence owner.
`CutoffAt`	datetime	yes	Precise evidence cutoff.
`SourceHash`	text	yes	Population/version hash; changed source invalidates completion.
`Evidence`	longtext	yes	Reconciliation totals, exceptions and prerequisites; required missing balances cannot be hidden by Complete.
`ReviewedBy`	reference		→ Users. Independent Finance Manager for unresolved exceptions/allowed waiver.
`CompletedAt`	datetime		Actual evidence completion.

AccountsEntity-scoped customer accounting identity, including a reviewed walk-in counterparty with strictly separate transaction entitlements.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`AccountCode`	text	yes	Stable entity/customer identity. WalkIn is a reviewed accounting counterparty label, not an invented person or a global customer credit wallet.
`LegalName`	text	yes	Bill-to legal customer identity.
`Status`	select	yes	Prospect, Active, OnHold, Closed
`BillingAddress`	longtext		Verified billing identity.
`DefaultTerms`	reference		→ PaymentTerms. Accepted transaction freezes a version.
`PriceList`	reference		→ PriceLists. Default customer price list; explicit precedence.
`CreditCurrency`	reference		→ Currencies. Currency of credit limit.
`CreditLimit`	decimal		Finite nonnegative approved entity/customer credit limit; missing is never unlimited. Assigned contract advances remain source-purpose scoped and do not become generic credit again without approved ReleasePurpose.
`TaxEvidence`	longtext		Exemption/resale documentation and review scope; not automatic compliance proof.
`Activation`	reference		→ MasterChanges. Independent Commercial Manager commercial and Finance Manager credit/tax approval as applicable.
`RelatedEntity`	reference		→ Entities. Explicit intercompany trading counterparty; still separate legal documents, no automatic elimination.
`Kind`	select	yes	KnownCustomer, WalkIn
`Owner`	reference	yes	→ Users. Estimator responsible for actual customer relationships; no authority to change financial limits or pool unrelated accounts.

ContactPersonsActual known business/customer contacts; optional for anonymous walk-in purchase and never invented or treated as login/consent.master

Field	Type	Required	Details
`Account`	reference	yes	→ Accounts. Legal trading account.
`ContactCode`	text	yes	Stable person/site reference.
`Name`	text	yes	Contact name.
`Purpose`	select	yes	Billing, Ordering, Delivery, General
`Email`	text		Approved business contact.
`Phone`	text		Business contact.
`DeliveryAddress`	longtext		Actual ship-to; a changed address after acceptance requires review.
`Status`	select	yes	Active, Inactive

SuppliersEntity purchasing counterparties with separately controlled beneficiary data.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`SupplierCode`	text	yes	Unique trading account.
`LegalName`	text	yes	Legal identity.
`Status`	select	yes	Draft, Active, Suspended, Blocked
`Terms`	reference	yes	→ PaymentTerms. Effective payment terms.
`Activation`	reference		→ MasterChanges. Independent Purchasing Manager activation; finance reviews beneficiary/tax aspects separately.
`RelatedEntity`	reference		→ Entities. Explicit intercompany supplier; ordinary paired trade documents and reconciliation, no same-entity stock-transfer shortcut.

SupplierBankAccountsRestricted supplier payment destinations with independent finance confirmation.master

Field	Type	Required	Details
`Supplier`	reference	yes	→ Suppliers. Owning supplier.
`BankKey`	text	yes	Versioned beneficiary identifier.
`Currency`	reference	yes	→ Currencies. Payment currency supported.
`MaskedDetails`	text	yes	Review display only.
`ProtectedDetails`	longtext	yes	Protected connector secret/reference; Accountant and Finance Manager narrowly authorized, operators/sales excluded.
`BeneficiaryHash`	text	yes	Frozen exact destination content used by approved instruction.
`Status`	select	yes	Draft, Active, Superseded, Blocked
`Activation`	reference		→ MasterChanges. Independent Finance Manager confirmation; never preparer/editor. Absent until the real action; mandatory before the corresponding active/approved/posted state.

UnitsOfMeasureDimension and precision for stock, purchase, sale and production quantities.master

Field	Type	Required	Details
`Code`	text	yes	Unique unit code.
`Dimension`	text	yes	Count, mass, volume or other explicit compatible dimension.
`DecimalPlaces`	number	yes	Permitted nonnegative precision; indivisible unit has zero.
`Status`	select	yes	Active, Inactive

ProductsOne canonical stocked SKU for each physical product/variant or produced kit; styles, barcodes and channel aliases never create extra stock.master

Field	Type	Required	Details
`ProductCode`	text	yes	Unique SKU.
`Name`	text	yes	Product description.
`BaseUnit`	reference	yes	→ UnitsOfMeasure. Stock and production base quantity unit.
`LotControlled`	boolean	yes	Lot required on every custody and production allocation when true.
`Status`	select	yes	Draft, Active, OnHold, Inactive
`ProductKind`	select	yes	Stock, ManufacturedKit, Repacked
`Activation`	reference		→ MasterChanges. Independent Warehouse Manager stock/unit identity, Commercial Manager commercial and Production Manager manufactured-specification approval, with separate Finance Manager financial setup as affected.
`SerialControlled`	boolean	yes	Each serialized stock identity/effect identifies exactly one base unit; every pack/unit conversion preserves it.

ProductUnitsVersioned product-specific buy/sell packs and base conversions.master

Field	Type	Required	Details
`Product`	reference	yes	→ Products. Exact SKU.
`Unit`	reference	yes	→ UnitsOfMeasure. Transaction unit.
`BaseUnitsPerUnit`	decimal	yes	Strictly positive fixed factor; incompatible dimensions require explicit reviewed product conversion.
`Version`	number	yes	Immutable active conversion version.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Warehouse Manager and required Finance Manager review for financial impact. Absent until the real action; mandatory before the corresponding active/approved/posted state.

PriceListsEffective entity/currency customer pricing; no accepted-price mutation.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`PriceListCode`	text	yes	Unique version.
`Currency`	reference	yes	→ Currencies. One price currency.
`StartsAt`	datetime	yes	Inclusive.
`EndsAt`	datetime		Exclusive.
`Priority`	number	yes	Explicit precedence; equal eligible candidates block selection.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Commercial Manager; Finance Manager confirms configured floor/cost policy. Absent until the real action; mandatory before the corresponding active/approved/posted state.

PriceListEntriesQuantity-tier price basis in a named product unit.line

Field	Type	Required	Details
`PriceList`	reference	yes	→ PriceLists. Effective immutable version.
`ProductUnit`	reference	yes	→ ProductUnits. Exact quantity/price basis.
`MinimumQuantity`	decimal	yes	Nonnegative transaction-unit tier boundary; highest eligible boundary wins within selected list.
`UnitListPrice`	decimal	yes	Nonnegative known document-currency price; zero requires explicit policy.
`MinimumNetPrice`	decimal		Approved optional floor in the same unit/currency, not a cost estimate.

StandardCostsEntity/product standard per base unit with immutable effective versions.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Product`	reference	yes	→ Products. SKU.
`Version`	number	yes	Unique effective version.
`UnitStandardCost`	decimal	yes	Known nonnegative entity-functional value per base unit; explicit approved zero is possible, missing is not zero.
`StartsAt`	datetime	yes	Inclusive.
`EndsAt`	datetime		Exclusive.
`Status`	select	yes	Draft, Active, Superseded
`CostBasis`	longtext	yes	Reviewed input/labour/overhead basis; no double inclusion.
`Activation`	reference		→ MasterChanges. Independent Finance Manager activation with Production Manager or Purchasing Manager reviewed technical/commercial cost basis; no rewrite of released WIP or earlier output.

PostingProfilesApproved source-specific stock, production and trade posting mappings.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`ProfileCode`	text	yes	Unique version.
`Product`	reference	yes	→ Products. Exact product or configured explicitly named product class mapping.
`InventoryAccount`	reference	yes	→ ChartOfAccounts. Owned inventory control.
`WIPAccount`	reference	yes	→ ChartOfAccounts. Work-order WIP control.
`GRNIAccount`	reference	yes	→ ChartOfAccounts. Receipt accrual control.
`COGSAccount`	reference	yes	→ ChartOfAccounts. Sales cost at title event only.
`RevenueAccount`	reference	yes	→ ChartOfAccounts. Revenue at supported invoice recognition basis.
`PurchaseVarianceAccount`	reference	yes	→ ChartOfAccounts. Receipt/bill price variance; never hidden in decimal rounding.
`ProductionVarianceAccount`	reference	yes	→ ChartOfAccounts. Released production variance after complete WIP reconciliation.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Finance Manager review. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`SupplierReturnClearingAccount`	reference	yes	→ ChartOfAccounts. Clears current carrying of billed supplier returns against subsequent independently approved commercial credit; residual difference is classified, never hidden.
`ScrapAccount`	reference	yes	→ ChartOfAccounts. Reviewed stock/WIP scrap or loss expense, not a duplicate completion variance.
`ProjectAccounts`	longtext	yes	Approved project expense, subcontract accrual, resource clearing, contract asset/liability, unconditional AR/AP and retention/advance control mappings with source-normal-balance and tax policy. Details within an existing control are never additional posted assets/liabilities.

WarehousesPhysical sites may host segregated entity-owned positions; legal owner stays on each position.master

Field	Type	Required	Details
`WarehouseCode`	text	yes	Unique physical site.
`Name`	text	yes	Operational name.
`Timezone`	text	yes	IANA site timezone.
`Status`	select	yes	Active, Suspended, Closed
`PermittedEntities`	longtext	yes	Explicit Entities allowed; not a transfer of ownership or access.
`Manager`	reference	yes	→ Users. Assigned Warehouse Manager with scope.

LocationsShallow warehouse bins, staging and transit custody locations.master

Field	Type	Required	Details
`Warehouse`	reference	yes	→ Warehouses. Physical/source operating site.
`LocationCode`	text	yes	Unique within warehouse.
`Kind`	select	yes	Storage, Receiving, Picking, Dispatch, Held, Transit, Production
`Status`	select	yes	Active, Blocked, Closed

QuotesVersioned customer offers with known pricing basis and real acceptance lineage.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`QuoteNumber`	text	yes	Unique entity quote.
`Account`	reference	yes	→ Accounts. Same entity.
`Status`	select	yes	Draft, Submitted, Approved, Sent, Accepted, Expired, Rejected, Superseded
`QuoteDate`	date	yes	Offer date.
`ValidUntil`	datetime	yes	Expiry of exact offer revision.
`Owner`	reference	yes	→ Users. Estimator.
`PriceList`	reference		→ PriceLists. Selected list version or reviewed manual-price reason in snapshot.
`NetTotal`	decimal	yes	Sum frozen QuoteLines.NetAmount; no second subtraction of disclosed discounts.
`TaxTotal`	decimal	yes	Sum exact tax allocations.
`SentAt`	datetime		Actual successful send evidence, not intent.
`AcceptanceEvidence`	longtext		Immutable actual customer agreement to current content hash, quantities/units, net/discount/tax, complete terms, authorized customer/recipient and actual time. External acceptance and quote approval never replace independent order/contract acceptance.
`Decision`	reference		→ ApprovalDecisions. Required commercial price/margin exception decision by independent Commercial Manager; routine within-policy quote sending is Estimator preparation, not the mandatory order gate.

QuoteLinesAll line/header discounts allocated once into accepted net value.line

Field	Type	Required	Details
`Quote`	reference	yes	→ Quotes. Parent revision.
`LineNumber`	number	yes	Stable line key.
`ProductUnit`	reference		→ ProductUnits. Required Goods SKU/unit; null for ProjectWork, which uses explicit WorkUnit and quantity1 for a fixed-price scope.
`Quantity`	decimal	yes	Positive goods/work transaction quantity; fixed-price milestone scope uses explicit one unit, not fictitious SKU stock.
`BaseQuantity`	decimal	yes	Goods Quantity times frozen conversion; ProjectWork quantity in WorkUnit only, never enters stock availability.
`UnitListPrice`	decimal	yes	Known quoted currency/unit amount.
`LineDiscount`	decimal	yes	Nonnegative amount in quote currency, bounded by list extension.
`HeaderDiscountAllocation`	decimal	yes	Nonnegative allocated share with deterministic final remainder.
`NetAmount`	decimal	yes	Quantity × UnitListPrice − LineDiscount − HeaderDiscountAllocation, rounded once; nonnegative.
`TaxCode`	reference		→ TaxCodes. Frozen effective treatment, rate and evidence; missing required tax blocks release.
`TaxAmount`	decimal	yes	Tax on eligible NetAmount once; explicit exempt zero requires evidence.
`StandardCost`	reference		→ StandardCosts. Goods frozen standard-cost basis. ProjectWork uses complete frozen EstimateComponents; unknown cost routes review, known zero is valid.
`MarginPercent`	decimal		100 times (NetAmount minus complete converted EstimateComponents or goods extended cost) divided by NetAmount; null for zero net or unknown cost, known zero cost with positive net is100%.
`Kind`	select	yes	Goods, ProjectWork
`Description`	longtext	yes	Exact offered work/goods, inclusions and exclusions, including each alternative.
`WorkUnit`	reference		→ UnitsOfMeasure. Explicit measured work or fixed milestone unit for ProjectWork, not a stock conversion.
`EstimatedCost`	decimal		Complete frozen component/cost extension in quote currency; null if incomplete, zero only reviewed known zero.

SalesOrdersAccount-accepted scope plus mandatory independent commercial approval.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Mandatory current OrderAcceptance by independent Commercial Manager. ContractActivation is additional or the same immutable decision explicitly covers both current order and contract snapshots; quote approval alone is insufficient.
`OrderNumber`	text	yes	Unique entity order.
`Account`	reference	yes	→ Accounts. Same entity.
`Quote`	reference		→ Quotes. Accepted source revision; generated orders consume its remaining accepted scope once.
`Status`	select	yes	Draft, Submitted, OnHold, Approved, InProgress, PartiallyShipped, Shipped, Invoiced, Closed, Cancelled
`OrderDate`	date	yes	Commercial date.
`Owner`	reference	yes	→ Users. Estimator preparing order.
`Terms`	reference	yes	→ PaymentTerms. Frozen accepted terms.
`ShipTo`	longtext	yes	Actual goods destination/entitled recipient and handling evidence; required for goods, not fabricated for project work. Project lines use the approved ProjectSite/work scope.
`TitleRule`	select	yes	Handover. Actual verified customer handover/pickup or carrier dispatch owns goods title/stock/COGS once. Project service work has no fabricated goods title event.
`NetTotal`	decimal	yes	Sum accepted SalesOrderLines.NetAmount.
`TaxTotal`	decimal	yes	Sum line tax once.
`CreditReview`	reference	yes	→ CreditReviews. Current entity/customer exposure snapshot and valid exception if needed.
`AcceptedAt`	datetime		Actual independent Commercial Manager decision time for current accepted order AND contract scope after actual complete customer agreement, excluding preparers/material editors and material acceptance recorder.
`FulfillmentMode`	select	yes	CustomerHandover, Pickup, Carrier, ProjectWork, Mixed
`Contract`	reference		→ ProjectContracts. One accepted agreement for all order lines; reciprocal Order must match. Required before activity; draft reciprocal links may be completed atomically.

SalesOrderLinesBounded accepted quantity/value and retained original promise.line

Field	Type	Required	Details
`SalesOrder`	reference	yes	→ SalesOrders. Exact order revision.
`LineNumber`	number	yes	Stable identity across documented amendments.
`QuoteLine`	reference		→ QuoteLines. Accepted source allocation when converted from quote.
`ProductUnit`	reference		→ ProductUnits. Required Goods exact frozen mapping; null for ProjectWork with explicit WorkUnit.
`Quantity`	decimal	yes	Accepted quantity in transaction units.
`BaseQuantity`	decimal	yes	Goods accepted base quantity; ProjectWork accepted work units only and must never create stock demand.
`NetAmount`	decimal	yes	Canonical accepted net including discounts once; final allocation gets remaining rounding cents.
`TaxAmount`	decimal	yes	Frozen accepted estimated tax; actual invoice tax differences need evidence/approval.
`OriginalPromiseAt`	datetime	yes	Original agreed full-delivery cutoff; never overwritten by rescheduling.
`RevisedPromiseAt`	datetime		Separately accepted reschedule.
`Warehouse`	reference		→ Warehouses. Same-entity planned goods source; not required or fabricated for ProjectWork.
`CancelledBaseQuantity`	decimal	yes	Approved unfulfilled scope only; dispatch/billing corrections separately traced.
`Baseline`	longtext	yes	Migration-only nonposting shipped/delivered/invoiced/cancelled quantities/net/tax; native values zero.
`Status`	select	yes	Open, Held, PartiallyFulfilled, Fulfilled, Closed, Cancelled
`Kind`	select	yes	Goods, ProjectWork
`Description`	longtext	yes	Exact accepted line/work scope and exclusions.
`WorkUnit`	reference		→ UnitsOfMeasure. Required ProjectWork measurable/fixed scope unit.
`ProjectSite`	reference		→ ProjectSites. Project line actual site when applicable; goods agreement may have none.
`BillingBasis`	select	yes	GoodsShipment, FixedMilestone, MeasuredProgress, UnitRate

SalesAllocationsAtomic claim of accepted line quantity and net/tax value across staged fulfillment/billing.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`AllocationNumber`	text	yes	Stable scope identity.
`OrderLine`	reference	yes	→ SalesOrderLines. Exact accepted line.
`ShipmentLine`	reference		→ ShipmentLines. Actual scoped fulfillment.
`InvoiceLine`	reference		→ InvoiceLines. Optional trace to associated BillingAllocation only; this record never owns an additional invoicing quantity/net claim.
`Kind`	select	yes	Shipment, Cancellation, Correction
`Status`	select	yes	Reserved, Posted, Released, Reversed
`BaseQuantity`	decimal	yes	Positive accepted Goods quantity claim; stock allocation is forbidden for ProjectWork. Cancellation of work amount uses approved ProjectChangeLines and BillingObligations cap reconciliation.
`NetAmount`	decimal	yes	Commercial net carried only for goods shipment/cancellation trace; BillingAllocations exclusively owns invoice scope, never double counts this amount.
`TaxAmount`	decimal	yes	Scoped tax allocation; differences retained with approved basis.
`CreatedAt`	datetime	yes	Claim time.
`PostedAt`	datetime		Actual effect time.
`ReversalOf`	reference		→ SalesAllocations. Exact prior scope; cannot reopen shipped/billed demand without controlled correction.
`BillingAllocation`	reference		→ BillingAllocations. Associated billing trace, not another billing reservation or net amount owner.

CreditReviewsAtomic customer exposure review and separately bounded exception.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`ReviewNumber`	text	yes	Unique review snapshot.
`Account`	reference	yes	→ Accounts. Same entity.
`Order`	reference	yes	→ SalesOrders. Order being accepted/released.
`AsOf`	datetime	yes	Snapshot time; stale material source changes require refreshed review.
`Currency`	reference	yes	→ Currencies. Account limit currency.
`Exposure`	decimal	yes	Open AR net eligible credits plus approved uninvoiced commitments, with shipped/unbilled counted once; receipts count only when available and attributed under policy.
`ProposedIncrease`	decimal	yes	Uncounted proposed gross exposure, never netted against an unrelated order decrease to hide risk.
`SourceHash`	text	yes	Invoices/orders/credits/limits and exact conversion rates; missing rate blocks.
`Status`	select	yes	WithinLimit, ExceptionRequired, ExceptionApproved, Expired, Superseded
`Decision`	reference		→ ApprovalDecisions. Independent Finance Manager finite amount/currency/expiry credit exception; Commercial Manager still approves order.

RequisitionsOperational purchasing demand without automatic spend approval.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`RequisitionNumber`	text	yes	Unique request.
`Status`	select	yes	Draft, Submitted, Approved, Rejected, Converted, Cancelled
`RequestedAt`	datetime	yes	Actual request.
`NeededBy`	date	yes	Required supply date.
`RequestedBy`	reference	yes	→ Users. Warehouse Manager, Production Operator or other authorized operational requester.
`Decision`	reference		→ ApprovalDecisions. Independent Purchasing Manager within configured authority, Finance Manager above limit; conversion consumes only approved remaining scope.

RequisitionLinesRequested product quantities and source demand identity.line

Field	Type	Required	Details
`Requisition`	reference	yes	→ Requisitions. Parent request.
`LineNumber`	number	yes	Stable key.
`ProductUnit`	reference	yes	→ ProductUnits. Requested buy unit.
`Quantity`	decimal	yes	Positive transaction units.
`Warehouse`	reference	yes	→ Warehouses. Intended receiving site.
`OrderLine`	reference		→ SalesOrderLines. Optional specific demand; proposal and generated PO are one supply.

PurchaseOrdersImmutable approved supplier commitments; cumulative amendments cannot bypass authority.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`PurchaseOrderNumber`	text	yes	Unique supplier order.
`Supplier`	reference	yes	→ Suppliers. Active same-entity supplier.
`Status`	select	yes	Draft, Submitted, Approved, Sent, PartiallyReceived, Received, Closed, Cancelled
`OrderDate`	date	yes	Commercial date.
`Buyer`	reference	yes	→ Users. Purchasing Manager preparing the order.
`OriginalApprovedTotal`	decimal	yes	Original approved commitment in order currency; retained through amendments.
`CumulativeGrossIncreases`	decimal	yes	Sum positive line-level increases/new-line amounts over all approved amendments; decreases never conceal increases/category changes.
`CurrentTotal`	decimal	yes	Current net plus approved applicable tax/freight, in document currency.
`ApprovalBasis`	decimal	yes	At least max(CurrentTotal, OriginalApprovedTotal + CumulativeGrossIncreases), converted using retained authority rate; changed scope reviewed too.
`SentAt`	datetime		Actual outbound evidence.

PurchaseOrderLinesBuy-unit quantities, frozen commercial costs and current accepted scope.line

Field	Type	Required	Details
`PurchaseOrder`	reference	yes	→ PurchaseOrders. Parent accepted revision.
`LineNumber`	number	yes	Stable key; fulfilled quantity/cost cannot be silently repriced.
`RequisitionLine`	reference		→ RequisitionLines. Converted demand allocation.
`ProductUnit`	reference	yes	→ ProductUnits. Frozen conversion.
`Quantity`	decimal	yes	Positive ordered buy units.
`BaseQuantity`	decimal	yes	Quantity × frozen base factor.
`UnitNetPrice`	decimal	yes	Known net document-currency price per buy unit, already discounted.
`NetAmount`	decimal	yes	Quantity × UnitNetPrice rounded once.
`TaxCode`	reference		→ TaxCodes. Effective purchase treatment/evidence.
`TaxAmount`	decimal	yes	Tax on eligible net once.
`Warehouse`	reference	yes	→ Warehouses. Receiving site.
`OriginalPromiseAt`	datetime	yes	Original supplier promised cutoff.
`RevisedPromiseAt`	datetime		Separate reviewed current promise.
`CancelledBaseQuantity`	decimal	yes	Approved unreceived/unmatched remaining scope only.
`Baseline`	longtext	yes	Nonposting accepted/returned/matched/cancelled quantities and commercial values at migration.
`Status`	select	yes	Open, PartiallyReceived, Received, Closed, Cancelled

GoodsReceiptsImmutable actual arrivals and separately accepted quantities.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`ReceiptNumber`	text	yes	Unique supplier arrival.
`PurchaseOrder`	reference	yes	→ PurchaseOrders. Approved same-entity supplier order.
`Warehouse`	reference	yes	→ Warehouses. Actual site.
`Status`	select	yes	Draft, Arrived, PendingReview, Accepted, PartiallyAccepted, Rejected, Corrected
`ArrivedAt`	datetime	yes	Actual arrival, never scheduled date.
`ReceivedBy`	reference	yes	→ Users. Warehouse Operator independent of PO creator/buyer and commercial approver.
`ConfirmedAt`	datetime		Physical evidence confirmed and accepted line effects committed.
`Evidence`	longtext	yes	Supplier document, delivery count and condition/inspection evidence.

GoodsReceiptLinesReceipt history does not change as accepted inventory moves or is consumed.line

Field	Type	Required	Details
`Receipt`	reference	yes	→ GoodsReceipts. Actual arrival.
`OrderLine`	reference	yes	→ PurchaseOrderLines. Exact approved supply.
`ArrivedBaseQuantity`	decimal	yes	Nonnegative actual arrived total.
`AcceptedBaseQuantity`	decimal	yes	Derived total live posted Accept tranches; receipt history is not reduced by later picking/consumption/shipping. Accepted supplier returns are separate fulfillment corrections.
`RejectedBaseQuantity`	decimal	yes	Derived total live confirmed Reject tranches; never usable owned inventory or GRNI.
`PendingBaseQuantity`	decimal	yes	ArrivedBaseQuantity minus accepted and rejected tranches; held pending stock is not posted as owned usable inventory.
`LotNumber`	text		Required for lot-controlled product.
`Location`	reference	yes	→ Locations. Receiving/held storage location as appropriate.
`StandardCost`	reference		→ StandardCosts. Proposed reviewed cost only; each actual ReceiptAcceptances tranche freezes its own effective cost.
`CommercialFunctionalValue`	decimal		Proposed value only; authoritative accepted values are the sum of posted ReceiptAcceptances, not a second payable or receipt.
`ReceiptRate`	reference		→ ExchangeRates. Proposed receipt valuation; each accepted tranche freezes the actual required dated rate.
`AcceptanceEvent`	reference		→ StockEvents. Optional first-acceptance convenience link; all authoritative tranches/effects are ReceiptAcceptances. No one-event-per-full-arrival assumption.
`Lot`	reference		→ Lots. Required incoming controlled identity; supplier lot mapping verified before acceptance.
`Serial`	reference		→ Serials. Required per serialized arrived unit; duplicate serial arrival cannot create owned stock.

BillMatchesReserve and consume accepted receipt versus bill quantities/value once.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`MatchNumber`	text	yes	Unique matching allocation.
`BillLine`	reference	yes	→ BillLines. Exact proposed/posted supplier invoice line.
`ReceiptLine`	reference		→ GoodsReceiptLines. Required only stock match with ReceiptAcceptance; null for SubcontractAccrual/direct source.
`Status`	select	yes	Reserved, Matched, Released, Reversed
`BaseQuantity`	decimal	yes	Positive scoped stock/work quantity in source unit, or explicit fixed work amount unit. Active claims plus posted matched portion bounded by original corrected accepted scope; current source remainder excludes posted history already.
`ReceiptAccrualFunctional`	decimal	yes	Source carrying relieved: exact stock GRNI or current subcontract accrual carrying, proportional with final remainder. Name retained for compatibility; never assumes original value after revaluation.
`BillNetFunctional`	decimal	yes	Same-scope invoice net/capitalizable tax at bill rate.
`VarianceFunctional`	decimal	yes	BillNetFunctional minus source carrying relieved; explicitly separate purchase price/project cost correction and incremental FX/prior unrealized reclassification. Never posts the whole accepted subcontract cost again.
`CreatedAt`	datetime	yes	Claim time.
`PostedAt`	datetime		Posted once with the bill.
`Decision`	reference		→ ApprovalDecisions. Independent Finance Manager for mismatches/non-PO exceptions; a changed PO needs independent procurement approval too.
`ReversalOf`	reference		→ BillMatches. Exact prior match and downstream credit evidence.
`ReceiptAcceptance`	reference		→ ReceiptAcceptances. XOR SubcontractAccrual. Stock match exact accepted tranche and original receipt parent; no invented physical receipt for service.
`SubcontractAccrual`	reference		→ SubcontractAccruals. Exact positive accepted-work accrual XOR ReceiptAcceptance; active claims bounded by current unbilled amount, with amount and quantity slices evidenced.
`SourceAmount`	decimal	yes	Source-currency portion consumed; source and bill currencies stay distinct with reviewed conversions.
`SourceFXReleased`	decimal	yes	Prior unrealized FX on released subcontract accrual, zero-net reclassified alongside incremental settlement FX; stock GRNI policy basis explicit.

InventoryPositionsCurrent owned stock by complete identity and custody state; provenance is not a second balance.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Product`	reference	yes	→ Products. Stock SKU.
`Warehouse`	reference	yes	→ Warehouses. Operating site; source site retained for away transit.
`Location`	reference	yes	→ Locations. Storage, picking, transit or production custody.
`LotNumber`	text		Required if controlled; identity cannot be edited to relabel stock.
`CustodyState`	select	yes	Available, Held, Picked, Transit, Production. Production is staged but not yet financially issued inventory; actually issued material leaves these inventory positions into separately traced work-order WIP custody.
`QuantityOnHand`	decimal	yes	Nonnegative current base quantity; only posted signed stock movements update it.
`CarryingValue`	decimal	yes	Nonnegative entity-functional inventory carrying, sum remaining StockLayers once. Issued material value is in WorkOrderCostEntries/WIP, not another production-position balance.
`ReservedQuantity`	decimal	yes	Sum live Soft/Hard/Picked/InTransit claims on this exact position; physical picked/transit remains committed, no automatic timer release.
`AvailableQuantity`	decimal	yes	Eligible available quantity less active claims; held/picked/transit/production unavailable to another order.
`Version`	number	yes	Monotonic position version checked atomically.
`Status`	select	yes	Active, Empty, Blocked
`Lot`	reference		→ Lots. Exact same entity/product lot; required when lot-controlled. Legacy display LotNumber must agree, never independent identity.
`Serial`	reference		→ Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row.

StockLayersRemaining quantity/carrying value with receipt/output/return lineage.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Position`	reference	yes	→ InventoryPositions. Current exact owned identity.
`Product`	reference	yes	→ Products. Same SKU.
`OriginEvent`	reference	yes	→ StockEvents. Original acceptance/output/migration provenance.
`ParentLayer`	reference		→ StockLayers. Split/moved origin; parent stores only remaining balance, never duplicates descendant quantities.
`OriginalQuantity`	decimal	yes	Immutable layer created base quantity.
`RemainingQuantity`	decimal	yes	Current nonnegative quantity.
`RemainingValue`	decimal	yes	Current standard carrying value; zero quantity requires zero value with residual resolved explicitly.
`StandardCost`	reference		→ StandardCosts. Applied current standard version or traced customer-return carrying basis.
`UnconsumedSource`	longtext	yes	Origin commercial/reference quantities and descendant trace, including changes and returns.
`Version`	number	yes	Atomic allocation/version.
`Status`	select	yes	Open, Depleted, Held
`Lot`	reference		→ Lots. Exact same entity/product lot, required when lot-controlled; display values derive from this identity.
`Serial`	reference		→ Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row.

StockEventsOne immutable group of stock movements and the associated journal effect.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`StockEventNumber`	text	yes	Unique physical/economic action.
`Kind`	select	yes	ReceiptAcceptance, PutAway, Pick, Unpick, TitleIssue, TransferDispatch, TransferReceipt, MaterialIssue, MaterialReturn, ProductionOutput, Scrap, CustomerReturn, SupplierReturn, StatusChange, CountAdjustment, CostRevaluation, MigrationOpening, Correction, ProjectConsume, ProjectRecover
`Status`	select	yes	Prepared, PendingApproval, Posted, Reversed, Rejected
`OccurredAt`	datetime	yes	Actual evidenced event time.
`PostedAt`	datetime		Atomic committed effect time.
`SourceTable`	text	yes	Existing exact typed source table.
`SourceKey`	text	yes	Exact immutable source scope/revision.
`SourceHash`	text	yes	Frozen content including quantity/cost/current versions.
`ConfirmedBy`	reference	yes	→ Users. Actor authorized for physical confirmation; financial authorization separate.
`Journal`	reference		→ JournalEntries. Balanced associated finance effect; same-control physical movement has none.
`ReversalOf`	reference		→ StockEvents. Traced compensating event; no blind reversal after consumption/title transfer.
`ProjectUsage`	reference		→ ProjectMaterialUsages. ProjectConsume/ProjectRecover sole stock and job-expense owner; source position/lot/serial/layer and original consumed cost are exact.

StockMovementsSigned position/layer legs; transfers balance quantity and value by SKU.line

Field	Type	Required	Details
`StockEvent`	reference	yes	→ StockEvents. Parent atomic event.
`Position`	reference	yes	→ InventoryPositions. Exact identity.
`Layer`	reference	yes	→ StockLayers. Exact remaining layer.
`QuantityDelta`	decimal	yes	Signed base quantity; zero only value-only standard revaluation. Status change uses equal out/in identity legs.
`ValueDelta`	decimal	yes	Signed functional carrying value; no invented stock value.
`Reservation`	reference		→ InventoryReservations. Demand claim being transferred/consumed.
`ShipmentLine`	reference		→ ShipmentLines. Exact dispatch/title portion if applicable.
`ReturnLine`	reference		→ ReturnLines. Exact return source if applicable.
`VersionBefore`	number	yes	Expected position version; new identity checked in locked scope.
`Lot`	reference		→ Lots. Exact same entity/product lot, required when lot-controlled; display values derive from this identity.
`Serial`	reference		→ Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row.

InventoryReservationsExclusive bounded demand claims through picking and owned transit.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`ReservationNumber`	text	yes	Stable demand/stock claim.
`Position`	reference	yes	→ InventoryPositions. Exact source/current position.
`Layer`	reference	yes	→ StockLayers. Exact source/current remaining layer.
`OrderLine`	reference		→ SalesOrderLines. Exactly one order/material/transfer demand. Reviewed policy may hold Soft scope for valid pending accepted intake; Hard/Picked/title requires independent approved sales order.
`WorkOrderMaterial`	reference		→ WorkOrderMaterials. Production component demand.
`TransferLine`	reference		→ StockTransferLines. Internal transfer demand.
`BaseQuantity`	decimal	yes	Positive claimed quantity; active claims cannot exceed eligible stock or demand remainder.
`Status`	select	yes	Soft, Hard, Picked, InTransit, Consumed, Released, Cancelled
`CreatedAt`	datetime	yes	Atomic claim time.
`ExpiresAt`	datetime		Soft claim expiry only for unexecuted, unpaid, nonuncertain intent under policy. Actual picked/transit or captured/uncertain paid commitments never auto-release; cancellation/payment reconciliation and source evidence required.
`Replaces`	reference		→ InventoryReservations. Soft→Hard conversion replaces rather than adds a second claim.
`ProjectRequirement`	reference		→ ProjectMaterialRequirements. Alternative project-use demand, exclusive with goods OrderLine or WorkOrder demand; same identity/current stock shares one availability pool.

StockTransfersSame-entity transfer with actual dispatch/partial receipt and retained owned transit.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`TransferNumber`	text	yes	Unique internal transfer.
`SourceWarehouse`	reference	yes	→ Warehouses. Source site.
`DestinationWarehouse`	reference	yes	→ Warehouses. Different allowed destination site.
`Status`	select	yes	Draft, PendingApproval, Approved, PartiallyDispatched, InTransit, PartiallyReceived, Received, Closed, Cancelled
`RequestedAt`	datetime	yes	Request time.
`DispatchedAt`	datetime		First actual dispatch, not planned date.
`CompletedAt`	datetime		All dispatched quantity received or independently resolved with explicit loss/return evidence.

StockTransferLinesPartial transfer quantities retain equal in-transit ownership and cost.line

Field	Type	Required	Details
`Transfer`	reference	yes	→ StockTransfers. Same entity.
`Product`	reference	yes	→ Products. SKU.
`BaseQuantity`	decimal	yes	Positive approved quantity.
`LotNumber`	text		Required controlled identity.
`SourceLocation`	reference	yes	→ Locations. Actual source.
`DestinationLocation`	reference	yes	→ Locations. Actual destination.
`DispatchedQuantity`	decimal	yes	Posted net actual dispatch, not request.
`ReceivedQuantity`	decimal	yes	Posted accepted destination quantity; bounded by unresolved dispatched quantity.
`ResolvedLossQuantity`	decimal	yes	Separately approved loss/damage disposition, never marked received.
`TransitValue`	decimal	yes	Unresolved dispatched carrying value; never disappears on close.

CountLocksTime-bounded counted scope protecting all identities, including newly appearing positions.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`LockNumber`	text	yes	Unique lock request.
`Count`	reference	yes	→ InventoryCounts. Owning count.
`Warehouse`	reference	yes	→ Warehouses. Counted warehouse.
`Scope`	longtext	yes	Exact physical locations/products/identities, including empty/new positions and null-bin population. Away transit excluded from floor population.
`SnapshotHash`	text	yes	Whole locked-scope identity/version population; unrelated site changes do not invalidate it.
`StartsAt`	datetime	yes	Actual successful lock.
`EndsAt`	datetime	yes	Expiry; resumed movements require fresh snapshot/recount.
`Status`	select	yes	Active, Released, Expired, Invalidated

InventoryCountsBlind scoped counts with explicit review and cost before adjustment.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`CountNumber`	text	yes	Unique count.
`Warehouse`	reference	yes	→ Warehouses. Physical scope.
`Status`	select	yes	Planned, Locked, Counting, PendingReview, Approved, Posted, Closed, Invalidated
`PlannedStart`	datetime	yes	Planned window.
`PlannedEnd`	datetime	yes	Planned end.
`Owner`	reference	yes	→ Users. Warehouse Manager.
`Counter`	reference	yes	→ Users. Warehouse Operator independent of adjustment approval.
`Policy`	reference	yes	→ ConstructionPolicies. Frozen tolerance/value/lock rules.
`Lock`	reference		→ CountLocks. Required current scope lock at observation/posting.
`PostedAt`	datetime		Atomic adjustment time, with stock event and ledger effects.
`FinanceDecision`	reference		→ ApprovalDecisions. Additional independent Finance Manager approval for found/identity-changing/held/reserved/above-value difference; unknown cost must be resolved first.

CountLinesObserved base quantity and signed variance against an unchanged locked population.line

Field	Type	Required	Details
`Count`	reference	yes	→ InventoryCounts. Owning count.
`Position`	reference		→ InventoryPositions. Existing counted identity; null only newly found complete identity.
`Identity`	longtext	yes	Complete entity/product/warehouse/location/lot/serial/custody identity, including newly appearing identities within the locked physical scope.
`ExpectedQuantity`	decimal	yes	Frozen physical quantity, never away owned-transit balance.
`CountedQuantity`	decimal	yes	Nonnegative blind actual quantity in base unit.
`RecountQuantity`	decimal		Independent required recount when outside quantity/percent tolerance.
`VarianceQuantity`	decimal	yes	Accepted observed quantity − expected.
`VariancePercent`	decimal		100 × absolute variance / expected when expected > 0; null otherwise, requiring review.
`UnitCost`	decimal		Known reviewed carrying/standard cost; missing blocks posting even after quantity approval.
`VarianceValue`	decimal		Signed functional variance after finite reviewed UnitCost is known; null while unknown, mandatory before approval/posting. A known calculated zero remains valid.
`ObservedAt`	datetime	yes	Actual observation time.
`RecountedBy`	reference		→ Users. Different actual Warehouse Operator or Warehouse Manager from initial counter; final approver cannot approve its own physical count.
`StockEvent`	reference		→ StockEvents. One posted correction.
`Lot`	reference		→ Lots. Exact same entity/product lot, required when lot-controlled; display values derive from this identity.
`Serial`	reference		→ Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row.

PickTasksActual picked quantities remain exclusively tied to the order and do not post COGS.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`PickNumber`	text	yes	Unique assigned task.
`OrderLine`	reference	yes	→ SalesOrderLines. Approved demand.
`Reservation`	reference	yes	→ InventoryReservations. Exact hard claim.
`Status`	select	yes	Assigned, InProgress, Picked, PartiallyPicked, Exception, Cancelled
`AssignedTo`	reference	yes	→ Users. Warehouse Operator.
`PlannedStart`	datetime	yes	Work window start.
`PlannedEnd`	datetime	yes	Work window end.
`PickedQuantity`	decimal	yes	Actual base quantity; unused reservation remains explicit.
`PickedAt`	datetime		Actual confirmation.
`StockEvent`	reference		→ StockEvents. Internal movement into picked custody only.

ShipmentsCurrent approved fulfillment packet and actual title handover, with separate customer-delivery history for carrier work.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`ShipmentNumber`	text	yes	Unique shipment.
`Order`	reference	yes	→ SalesOrders. One independently approved goods order, agreement and entitled customer; no combined packet loses line ownership.
`Warehouse`	reference	yes	→ Warehouses. Actual dispatch site.
`Mode`	select	yes	CustomerHandover, Pickup, Carrier
`Status`	select	yes	Planned, Picking, Ready, HandedOver, PartiallyDelivered, Delivered, Exception, Closed, Cancelled
`TitleRule`	select	yes	Handover. Actual customer handover for CustomerHandover/Pickup or verified carrier dispatch for Carrier is the one stock/title/COGS event.
`CarrierReference`	text		Configured external handoff reference; no carrier booking claim.
`HandedOverAt`	datetime		Actual verified customer handover or carrier dispatch instant; a ready state, label or booking acknowledgment is insufficient.
`HandoverEvidence`	longtext		Actual operator, intended recipient/carrier, source packet and exact line quantities/identities; uncertainty retains claims and cannot issue stock.
`ClosedAt`	datetime		All line quantities delivered/returned/lost/resolved with remaining ownership reconciled.
`Decision`	reference		→ ApprovalDecisions. Current exact independent action/scope/revision decision; required before corresponding approved effect.
`ReleasedBy`	reference		→ Users. Independent Warehouse Manager readiness approval, excluding packet preparer/material editor.
`ReleasedAt`	datetime		Actual approval before execution; new material scope invalidates unexecuted release.

ShipmentLinesActual dispatch quantities and current title-transferred/delivered portions.line

Field	Type	Required	Details
`Shipment`	reference	yes	→ Shipments. One order.
`OrderLine`	reference	yes	→ SalesOrderLines. Same order only.
`Reservation`	reference	yes	→ InventoryReservations. Exact picked claim and layer identity.
`BaseQuantity`	decimal	yes	Actual assigned/shipped quantity, bounded by claim and accepted unfulfilled source.
`DispatchedQuantity`	decimal	yes	Cumulative actual title-handover quantity across the supported mode; history stays intact through later returns.
`TitleTransferredQuantity`	decimal	yes	Exact once-only TitleIssue quantity at actual handover/dispatch; bounded by approved remaining order and hard stock claim.
`DeliveredQuantity`	decimal	yes	Cumulative accepted customer-delivery history, net only of approved factual evidence corrections. Physical returns never decrement this history or reopen old fulfillment eligibility.
`ReturnedQuantity`	decimal	yes	Actual reconciled returned quantity, separate from original dispatch history.
`CarryingValueIssued`	decimal	yes	Exact layer carrying value consumed by title transfer; no second cost at invoice/POD.
`OriginalDispatchEvent`	reference		→ StockEvents. TitleIssue at actual handover/dispatch; later carrier POD never issues stock/COGS again.

DeliveryConfirmationsActual customer delivery confirmation against an already handed-over packet, without another title or cost event.transaction

Field	Type	Required	Details
`ShipmentLine`	reference	yes	→ ShipmentLines. Exact customer handover/pickup or carrier delivery observation; dispatch-title stock/COGS has only its original title event.
`AcceptedQuantity`	decimal	yes	Nonnegative actual accepted quantity.
`RefusedQuantity`	decimal	yes	Nonnegative physically refused quantity.
`FailedQuantity`	decimal	yes	Nonnegative undelivered quantity; not lost or returned automatically.
`DamagedQuantity`	decimal	yes	Disjoint damaged scope retained pending disposition; not also included accepted/refused/failed.
`ScopeQuantity`	decimal	yes	Disjoint accepted/refused/failed/damaged outcomes bounded by original actual handed-over units excluding the union of prior accepted, physically returned, approved lost or finally resolved units. Failed visits may retry remaining goods; restock never reopens original POD eligibility.
`ReturnLine`	reference		→ ReturnLines. Refused/damaged actual return custody if applicable.
`CorrectionOf`	reference		→ DeliveryConfirmations. Exact prior result; approvals and downstream billing/title effects reconciled before correction.
`Entity`	reference	yes	→ Entities. Same owning entity as shipment/order/customer and actual handover evidence.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`ConfirmationNumber`	text	yes	Stable actual confirmation/attempt economic identity.
`Status`	select	yes	Prepared, Confirmed, Disputed, Corrected
`OccurredAt`	datetime	yes	Actual customer result time, not scheduled pickup/arrival.
`ConfirmedBy`	reference	yes	→ Users. Warehouse Operator with actual source/recipient evidence; disputed identity/outcome requires Warehouse Manager review.
`RecipientEvidence`	longtext	yes	Actual authorized customer recipient, handover/custody identity, artifact/time and quantity proof. Customer pickup verifies entitlement to this shipment; no invented personal identity.

BOMsEffective distribution assembly/repacking recipes with explicit output basis.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`BOMCode`	text	yes	Unique product/version.
`OutputProduct`	reference	yes	→ Products. One primary output SKU; co-products are separately scoped, not implied.
`OutputBaseQuantity`	decimal	yes	Strictly positive recipe output basis.
`Version`	number	yes	Immutable technical revision.
`StartsAt`	datetime	yes	Inclusive.
`EndsAt`	datetime		Exclusive.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Production Manager technical recipe activation; Finance Manager separately approves standard/rate/value changes.

BOMLinesComponent quantities per explicit output basis, preserving dimensions and allowed loss.line

Field	Type	Required	Details
`BOM`	reference	yes	→ BOMs. Versioned recipe.
`LineNumber`	number	yes	Stable component identity.
`Component`	reference	yes	→ Products. Input SKU; cycles forbidden across active recipes.
`BaseQuantity`	decimal	yes	Positive input base quantity per BOM output basis.
`PlannedScrapPercent`	decimal	yes	Nonnegative reviewed expected extra input, with explicit gross-input formula; not also applied to output quantity.
`Instruction`	longtext	yes	Material grade/lot substitution restrictions; substitutions require reviewed new scope.

ProductionRoutingsVersioned assembly/repacking instructions, distinct from delivery routes.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`RoutingCode`	text	yes	Unique version.
`BOM`	reference	yes	→ BOMs. Compatible active recipe version.
`Version`	number	yes	Immutable technical version.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Production Manager technical instructions; separate Finance Manager cost-rate approval.

RoutingOperationsOrdered work instructions and declared labour/overhead bases.line

Field	Type	Required	Details
`Routing`	reference	yes	→ ProductionRoutings. Parent version.
`Sequence`	number	yes	Positive unique execution order.
`Name`	text	yes	Assembly/repacking operation.
`Instructions`	longtext	yes	Concrete safety/inspection/acceptance instructions; no formal QMS certification claim.
`TerminalOperation`	boolean	yes	Exactly one final output operation; intermediate throughput never becomes extra finished units.
`LabourRatePerHour`	decimal	yes	Known nonnegative entity-functional absorption rate, independently finance-approved.
`OverheadBasis`	select	yes	None, LabourHour, OutputUnit
`OverheadRate`	decimal	yes	Known nonnegative rate in declared basis; no embedded amount added again.

WorkOrdersReleased bounded assembly/kitting/repacking, without plant APS or payroll scope.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`WorkOrderNumber`	text	yes	Unique production order.
`BOM`	reference	yes	→ BOMs. Frozen released recipe version.
`Routing`	reference	yes	→ ProductionRoutings. Frozen technical version.
`OutputProduct`	reference	yes	→ Products. One primary output.
`OutputStandard`	reference	yes	→ StandardCosts. Frozen entity-functional output standard at release.
`Warehouse`	reference	yes	→ Warehouses. Actual production site.
`OrderLine`	reference		→ SalesOrderLines. Optional make-for-order allocation, one demand not a second sales line.
`PlannedQuantity`	decimal	yes	Positive output base quantity.
`Status`	select	yes	Draft, PendingApproval, Released, InProgress, PartiallyCompleted, Completed, PendingClose, Closed, Cancelled
`PlannedStart`	datetime	yes	Feasible manually planned time.
`PlannedEnd`	datetime	yes	Planned end; no optimizer promise.
`Manager`	reference	yes	→ Users. Production Manager; independent of the relevant request preparer/material editors.
`ReleasedAt`	datetime		Actual independent Production Manager release after known material/cost/technical/condition and feasible manual schedule checks; no MRP or APS assumption.
`ClosedAt`	datetime		All input/output/scrap/WIP/cost obligations reconciled and necessary independent finance variance decision.
`CompletedQuantity`	decimal	yes	Net posted accepted terminal ProductionCompletions only; no intermediate/rework good-count sum.
`RemainingWIP`	decimal	yes	Sum signed posted WorkOrderCostEntries, reconciled independently from unissued inventory.
`CloseDecision`	reference		→ ApprovalDecisions. Mandatory independent Production Manager quantity/obligation close approval, excluding closure preparer/material editors.
`CloseFinanceDecision`	reference		→ ApprovalDecisions. Additional independent Finance Manager approval for remaining WIP/variance/financial exception, not substitute for quantity close.
`Project`	reference		→ Projects. Optional attribution/planned destination only; prefab material/labor remain exclusive WIP/finished stock. Do not post full fabrication cost to job expense before actual use.

WorkOrderMaterialsFrozen required input and actual traced issue/return scope.line

Field	Type	Required	Details
`WorkOrder`	reference	yes	→ WorkOrders. Released job.
`BOMLine`	reference	yes	→ BOMLines. Frozen technical source.
`Product`	reference	yes	→ Products. Input SKU.
`RequiredBaseQuantity`	decimal	yes	Planned output / BOM output basis × component input × explicit scrap factor once.
`IssuedQuantity`	decimal	yes	Gross actual material issue into exclusive work-order WIP custody; source inventory quantity/value removed once. Later returns and consumption remain separate derived counters from exact issue-source WorkOrderCostEntries.
`ReturnedQuantity`	decimal	yes	Unused physical WIP material actually returned from remaining issue-source quantity/cost into a new inventory layer; never debit a depleted original inventory position or return consumed material.
`ConsumedQuantity`	decimal	yes	Actual component base quantity used/scrapped in process; sum exact issue-source MaterialConsumedQuantity, not a second stock issue. Issued minus returned minus consumed is physically unused WIP material.
`Reservation`	reference		→ InventoryReservations. Exact material claim; multiple split claims linked by this source.

WorkOrderOperationsFrozen instructions and assigned actual work.line

Field	Type	Required	Details
`WorkOrder`	reference	yes	→ WorkOrders. Released job.
`RoutingOperation`	reference	yes	→ RoutingOperations. Frozen sequence/rates/bases.
`AssignedTo`	reference	yes	→ Users. Assigned Production Operator; Production Manager independently confirms actual throughput/time.
`Status`	select	yes	Ready, InProgress, Complete, Exception, Cancelled
`PlannedStart`	datetime	yes	Assigned window.
`PlannedEnd`	datetime	yes	End.
`ActualStart`	datetime		Actual work start.
`ActualEnd`	datetime		Actual work end, positive interval when labour hours charged.

ProductionEntriesActual operation throughput, scrap and labour evidence; intermediate counts do not sum to output.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`EntryNumber`	text	yes	Stable operation/time/output identity.
`Operation`	reference	yes	→ WorkOrderOperations. Released work operation.
`RecordedBy`	reference	yes	→ Users. Actual Production Operator recorder; ProducedBy identifies actual producer, which may differ.
`Status`	select	yes	Draft, Submitted, Accepted, Rejected, Corrected
`StartedAt`	datetime	yes	Actual time.
`EndedAt`	datetime		Actual time; no overlap/double use of same person's time interval. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`GoodQuantity`	decimal	yes	Nonnegative operation throughput in output base units, reconciled to unused exact input scope; held/rejected and repeated rework passes are not new good terminal units.
`ScrapQuantity`	decimal	yes	Nonnegative actual rejected output-equivalent evidence; input scrap quantities separately traced.
`LabourHours`	decimal		Accepted actual person-hours with global actual-person checks across ProductionEntries and ProjectWorkLogs; production intervals are exclusive, project-only declared shares total at most1. Null until complete valid actual interval, nonnegative known value required before acceptance/cost; no payroll effect.
`AcceptedBy`	reference		→ Users. Independent Production Manager excluding producer, recorder and material editors; actual condition evidence required.
`CorrectionOf`	reference		→ ProductionEntries. Prior entry and consumed costs/completions reconciled first.
`ProducedBy`	reference	yes	→ Users. Actual Production Operator producing the units; recorder can differ and neither may approve the same source.
`ScopeKey`	text	yes	Stable batch/unit/operation-pass identity; rework has linked prior pass and exact unit lineage, never a second finished unit.
`MachineHours`	decimal		Nonnegative actual accepted occupied machine hours; distinct from elapsed person-hours and setup overlap. Null until actual interval/basis known; finite nonnegative value required before acceptance/cost posting, with explicit known zero allowed.
`AcceptedAt`	datetime		Actual independent technical/time confirmation.
`InputAllocations`	longtext	yes	Validated exact released first-operation batch/material scope or prior accepted operation-entry quantities/unit IDs. Inputs = GoodQuantity + ScrapQuantity + HeldQuantity + UnfinishedQuantity; rework reuses original unit identity and cannot create extra terminal output. No implicit MRP or QMS record.
`HeldQuantity`	decimal	yes	Nonnegative inspected/awaiting-decision operation scope, excluded from accepted transferable/completable good units.
`UnfinishedQuantity`	decimal	yes	Nonnegative input scope still physically unfinished after this entry; retained for later work, never transferred/completed as good. Input allocation = GoodQuantity + ScrapQuantity + HeldQuantity + UnfinishedQuantity, all disjoint.

ProductionCompletionsAccepted terminal output and WIP cost allocation, once per actual completed scope.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`CompletionNumber`	text	yes	Unique terminal completion.
`WorkOrder`	reference	yes	→ WorkOrders. Released job.
`TerminalEntry`	reference	yes	→ ProductionEntries. Unused accepted terminal good quantity only.
`Status`	select	yes	Prepared, PendingApproval, Approved, Posted, Reversed
`OutputQuantity`	decimal	yes	Positive base output, bounded by remaining accepted terminal scope and authorized work order.
`LotNumber`	text		Required output lot.
`Location`	reference	yes	→ Locations. Actual received finished-stock location.
`AllocatedActualWIP`	decimal	yes	Unused approved material/labour/overhead source carrying attributed to actual consumed material and accepted time; active cost/quantity claims reduce availability. Unknown cost blocks posting.
`StandardOutputValue`	decimal	yes	OutputQuantity × frozen output standard, rounded once.
`Variance`	decimal	yes	AllocatedActualWIP − StandardOutputValue; positive adverse expense, negative favorable variance, once.
`CompletedAt`	datetime		Actual independently accepted terminal completion time, required before approved/posted scope; not draft creation.
`ConfirmedBy`	reference		→ Users. Independent Production Manager excluding actual producer, recorder, completion preparer/material editors; confirms exact terminal good scope and actual acceptable condition.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager approves nonzero variance/cost exception before posting; quantity acceptance alone does not authorize value.
`StockEvent`	reference		→ StockEvents. Dr finished inventory standard / Cr WIP allocated actual / signed production variance.
`Lot`	reference		→ Lots. Required exact output lot when controlled.
`Serial`	reference		→ Serials. Required individual identity when serialized; quantity exactly one per row.
`ConditionEvidence`	longtext	yes	Actual independently accepted terminal good condition and any held/rework/scrap scope; no automatic full QMS/inspection-suite claim.

WorkOrderCostEntriesImmutable WIP debit/credit sources and bounded actual-cost allocation.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`CostEntryNumber`	text	yes	Unique cost source/effect.
`WorkOrder`	reference	yes	→ WorkOrders. One WIP owner.
`Kind`	select	yes	MaterialIssue, MaterialReturn, Labour, Overhead, CompletionRelief, Scrap, Correction, Opening
`Material`	reference		→ WorkOrderMaterials. Exact input source when material.
`ProductionEntry`	reference		→ ProductionEntries. Unused approved time/throughput basis for labour/overhead.
`Completion`	reference		→ ProductionCompletions. Output WIP relief.
`Amount`	decimal	yes	Signed WIP delta in entity-functional currency; material and labour/overhead charged only once.
`AllocatedAmount`	decimal	yes	Absolute positive source cost consumed by completion/scrap or unused-material-return relief. Active ReservedAmount reduces availability too; no source amount is relieved twice.
`Basis`	longtext	yes	Frozen hours/units/rates, source layer quantities/value, calculation and allocation remainder.
`Status`	select	yes	Prepared, Approved, Posted, Reversed
`OccurredAt`	datetime	yes	Actual cost evidence time.
`Journal`	reference		→ JournalEntries. Balanced WIP posting; standard absorption counteraccount is not a second actual payroll expense.
`ReversalOf`	reference		→ WorkOrderCostEntries. Exact signed reversal only after consumed completion/stock effects resolved.
`ReservedAmount`	decimal	yes	Active completion/scrap allocation claims in functional currency; subtract from unallocated source amount before any new claim.
`ConsumedSources`	longtext		For completion/scrap/return relief: exact positive cost-entry keys, functional amounts and, for material, base quantities/lot/serial. Material amount uses original source carrying per base unit and final remainder. Sum equals actual WIP relieved; completion/scrap quantity <= physically consumed unallocated material, return quantity <= physically unused issue quantity. A reversal restores eligible claims once.
`SourceStockEvent`	reference		→ StockEvents. Actual material issue/return/scrap source event; paired stock/WIP effects commit once.
`SourceLayer`	reference		→ StockLayers. Original issue layer for material source; retained historical identity even after depletion, never an instruction to reverse blindly there.
`Lot`	reference		→ Lots. Material issue-source lot, matching product/entity.
`Serial`	reference		→ Serials. Exact material serial when controlled; issue/return/consumption quantity is one.
`MaterialBaseQuantity`	decimal		For MaterialIssue: positive immutable actual gross issue quantity, valued at the exact source layer carrying basis; null for nonmaterial entries.
`MaterialReturnedQuantity`	decimal		Sum actual unused returns allocated to this MaterialIssue source, initially known zero and bounded by unconsumed/available quantity.
`MaterialConsumedQuantity`	decimal		Sum actual component use/scrap allocated to this issue source, initially known zero; no inventory quantity effect after original issue.
`AllocatedMaterialQuantity`	decimal		Consumed source material quantity whose cost has been relieved into output/scrap, excluding separately returned quantity; capped by physically MaterialConsumedQuantity.
`MaterialSource`	reference		→ WorkOrderCostEntries. MaterialReturn or corrective source points to exact original MaterialIssue; all split sources explicitly enumerated in ConsumedSources when multiple.
`ReservedMaterialQuantity`	decimal		For a MaterialIssue source, active uncommitted use/return quantity claims; physically unused availability = MaterialBaseQuantity minus MaterialReturnedQuantity minus MaterialConsumedQuantity minus ReservedMaterialQuantity. Commit replaces the claim with one actual use/return, never both.
`Project`	reference		→ Projects. Optional attribution/planned destination only; prefab material/labor remain exclusive WIP/finished stock. Do not post full fabrication cost to job expense before actual use.

ReturnsBounded customer/supplier physical return authorization, separate from commercial credits.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`ReturnNumber`	text	yes	Unique authorization.
`Direction`	select	yes	CustomerToUs, UsToSupplier
`Account`	reference		→ Accounts. Required only customer return.
`Supplier`	reference		→ Suppliers. Required only supplier return.
`Status`	select	yes	Draft, PendingApproval, Authorized, PartiallyReceived, Received, PartiallyDispatched, Dispatched, PendingDisposition, Closed, Cancelled
`RequestedAt`	datetime	yes	Actual request.
`ExpiresAt`	datetime	yes	Authorization expiry; actual already received custody cannot disappear on expiry.
`Reason`	longtext	yes	Reason and original source/quantity conditions.

ReturnLinesExact original commercial/stock scope and actual returned quantities.line

Field	Type	Required	Details
`Return`	reference	yes	→ Returns. Authorized direction.
`ShipmentLine`	reference		→ ShipmentLines. Customer source; required unless controlled migration source preserved in baseline.
`ReceiptLine`	reference		→ GoodsReceiptLines. Supplier source; exact original accepted quantity/descendants.
`OriginalInvoiceLine`	reference		→ InvoiceLines. Customer original billing scope if invoiced.
`OriginalBillLine`	reference		→ BillLines. Supplier billed scope; null only wholly unmatched receipt portion. Split mixed billed/unbilled return scope.
`AuthorizedQuantity`	decimal	yes	Positive base quantity bounded by original net unreturned scope.
`ActualQuantity`	decimal	yes	Actual physical received/dispatched quantity, bounded by authorization.
`OriginalIssuedValue`	decimal		Original title-issue carrying value for post-title customer return; null before title or for supplier scope, never fabricated zero.
`CurrentRemovalValue`	decimal	yes	Current descendant carrying for supplier return; a customer cancellation before handover returns existing owned staging to eligible custody without sale/COGS reversal. Zero-quantity residual value is forbidden.
`OriginalCommercialValue`	decimal	yes	Scoped original net/tax settlement basis kept separate from carrying removal.
`LotNumber`	text		Trace original identity; changed identity requires explicit reviewed disposition.
`PhysicalAt`	datetime		Actual return receipt or supplier handover.
`StockEvent`	reference		→ StockEvents. Actual custody/owned-stock effect once.
`ReceiptAcceptance`	reference		→ ReceiptAcceptances. Required for supplier return of accepted owned goods; binds original posted tranche/descendants, rather than gross arrival.

ReturnDispositionsIndependent actual goods disposition without automatic credit or refund.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`DispositionNumber`	text	yes	Unique return-scope decision.
`ReturnLine`	reference	yes	→ ReturnLines. Actual received/authorized scope.
`Kind`	select	yes	Restock, Scrap, ReturnToCustomer, ReturnToSupplier, Quarantine
`Status`	select	yes	Prepared, PendingApproval, Approved, Posted, Reversed
`BaseQuantity`	decimal	yes	Positive bounded actual quantity not already disposed.
`CarryingValue`	decimal	yes	Original title-issue cost for actual customer restock; current descendant carrying for supplier return. Before actual customer handover, cancellation restores existing owned staging/custody without a COGS reversal; no delivery-title customer path.
`Destination`	reference		→ Locations. Actual held/restocked destination, same entity/warehouse scope; new assembly/rework requires separately released production scope.
`PreparedBy`	reference	yes	→ Users. Warehouse Operator observations.
`DecidedAt`	datetime		Independent WM disposition; FM additionally authorizes loss/value exception. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`StockEvent`	reference		→ StockEvents. No physical/economic effect from status alone.

InvoicesLocal customer debit/credit documents with mandatory independent Finance Manager approval.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`InvoiceNumber`	text	yes	Unique legal document.
`Account`	reference	yes	→ Accounts. Same entity.
`DocumentType`	select	yes	Invoice, CreditNote
`OriginalInvoice`	reference		→ Invoices. Required credit/correction original.
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, PartiallySettled, Settled, Disputed, Reversed, Cancelled
`InvoiceDate`	date	yes	Original legal/business date.
`PostingDate`	date	yes	Eligible date in entity Period; no closed-period rewrite.
`Period`	reference	yes	→ AccountingPeriods. Same-entity open posting period.
`DueDate`	date	yes	Frozen terms.
`NetAmount`	decimal	yes	Positive magnitude sum InvoiceLines.NetAmount; credit sign comes only from DocumentType.
`TaxAmount`	decimal	yes	Positive applicable tax magnitude, credit reverses original scoped tax.
`TotalAmount`	decimal	yes	NetAmount + TaxAmount once.
`Outstanding`	decimal	yes	Current unconditional AR principal/tax recognized by invoice plus actual conditional-retention releases, minus net posted cash/advance/credit/corrections and baseline. Commercial TotalAmount may include conditional retained rights not yet AR. Held unconditional retention remains outstanding but not payable before release.
`CurrentCarrying`	decimal	yes	Current open unconditional AR functional carrying, initially sum each InvoiceLines funded/unfunded FunctionalNet and separate tax components, less exact settlement slices plus monetary revaluation. Historical advance-funded slice and its atomic application use identical carrying, without a fictitious FX plug.
`UnrealizedFX`	decimal	yes	Signed gain-positive prior FX on remaining scope; reclassified once when settled.
`CreditRemaining`	decimal	yes	Credit-note value less posted uses/refunds; active reservations reduce allocatable balance further.
`PostedAt`	datetime		Local journal posting time; send acknowledgment is separate.
`Journal`	reference		→ JournalEntries. Debit invoice Dr unconditional AR / Cr accounting-unit contract position and assessed tax; conditional retained commercial scope alone adds no AR/position. Credit reverses exact original unconditional B/tax into customer credit or scoped AR correction. Revenue corrections require separate approved RevenueAssessment; same-event journals can be shared, never repeat revenue.
`Baseline`	longtext	yes	Nonposting original/settled/credit and current carrying/FX amounts at migration; native zero.
`Contract`	reference	yes	→ ProjectContracts. Same entity/customer accounting agreement; Goods and Project use the same reviewed performance basis.
`UnconditionalAmount`	decimal	yes	Original unconditional net plus assessed tax and later valid conditional releases, less scoped credits/corrections; distinct from original commercial TotalAmount.
`HeldRetentionAmount`	decimal	yes	Unconditional retained AR still held, a subcomponent of Outstanding; conditional rights are not included here.
`DueAvailable`	decimal	yes	Outstanding minus current held retention and active settlement reservations; never negative, released retains original invoice identity.

InvoiceLinesExact goods, project, milestone or advance billing allocation with separately recognized unconditional AR and conditional retained scope.line

Field	Type	Required	Details
`Invoice`	reference	yes	→ Invoices. Parent revision.
`LineNumber`	number	yes	Stable line.
`OrderLine`	reference		→ SalesOrderLines. Required trade debit source.
`ShipmentLine`	reference		→ ShipmentLines. Required only GoodsShipment billing eligible actual handover. Project work and advance billing use BillingAllocation and never fabricate shipment.
`OriginalLine`	reference		→ InvoiceLines. Required credit source.
`ReturnLine`	reference		→ ReturnLines. Physical return basis when applicable; commercial-only credit explicitly reviewed.
`BaseQuantity`	decimal	yes	Positive goods/work scope in its accepted unit; zero allowed for explicit financial-only/advance/retention reclassification. It never fabricates project stock movement.
`NetAmount`	decimal	yes	Positive new commercial billed net from BillingAllocation after all prior billed amounts; conditional retention is included commercially here but excluded from UnconditionalNet. Credits use exact original scoped amount.
`TaxAmount`	decimal	yes	Correct eligible tax basis/rate/exemption snapshot, not unreviewed default zero.
`TaxEvidence`	longtext	yes	Frozen exact rule/rate/basis and original credit allocation.
`Allocation`	reference		→ SalesAllocations. Optional goods-title trace only; BillingAllocation owns the sole commercial invoice claim.
`BillingAllocation`	reference	yes	→ BillingAllocations. Exact sole reserved/posted commercial billing source; reciprocal InvoiceLine, entity, contract and order must agree.
`UnconditionalNet`	decimal	yes	New commercial NetAmount less linked BillingAllocations.ConditionalRetentionNet; includes unconditional held retention. Later conditional release uses RetentionMovements against original line and increases AR/B, not commercial NetAmount or billed cap again.
`ContractMovement`	reference		→ ContractBalanceMovements. Invoice/credit B delta for this line; revenue is separate recognized evidence, not automatically NetAmount.
`AdvanceBasis`	reference		→ AdvanceAllocations. Original Customer Assign whose exact remaining portion funds this line; one source per funded line, split lines for multiple funding bases. Null for unfunded portion. Claim is shared with AdvanceApplication, not an extra reservation.
`AdvanceApplication`	reference		→ AdvanceAllocations. Initial Customer Apply action linked by InvoiceLine; funded invoice/app posts atomically. Later conditional-retention release uses its own RetentionMovements.Advance and AdvanceAllocations.RetentionMovement, never overwrites this initial posted pointer.
`FunctionalNet`	decimal	yes	Functional carrying ONLY of UnconditionalNet, excluding conditional retained commercial net. Exact historical advance-funded unconditional slice uses AdvanceAllocations.BasisTransferred; unfunded unconditional slice uses reviewed invoice basis; monetary funded slice uses reviewed current carrying/FX. Separate tax components; credits reverse original unconditional basis. Never multiply full commercial NetAmount into AR when conditional retention exists.
`ConditionalFunctionalBasis`	decimal		Known allocated functional basis of linked conditional retained commercial scope when measurable, tagged only within existing contract position and NOT posted into invoice AR or added as a separate asset. Later actual conditional release uses reviewed component current/historical basis and tax evidence, not automatic original invoice rate; unknown stays null until required release valuation is resolved.

BillsLocal supplier debit/credit documents with matching, carrying and separate settlement.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`BillNumber`	text	yes	Unique entity/supplier/external invoice identity; duplicate invoice hash review.
`Supplier`	reference	yes	→ Suppliers. Same entity.
`DocumentType`	select	yes	Bill, CreditNote
`OriginalBill`	reference		→ Bills. Credit original.
`Status`	select	yes	Draft, Matching, PendingApproval, Approved, Posted, PartiallySettled, Settled, Disputed, Reversed, Cancelled
`BillDate`	date	yes	Supplier document date.
`PostingDate`	date	yes	Open entity period date.
`Period`	reference	yes	→ AccountingPeriods. Same entity.
`DueDate`	date	yes	Frozen terms.
`NetAmount`	decimal	yes	Positive net magnitude.
`TaxAmount`	decimal	yes	Positive tax magnitude.
`TotalAmount`	decimal	yes	Net plus tax once.
`Outstanding`	decimal	yes	Debit original less posted settlement/credits/corrections and baseline; not cash-only balance.
`CurrentCarrying`	decimal	yes	Functional remaining open amount including delta FX.
`UnrealizedFX`	decimal	yes	Signed gain-positive prior FX on remaining scope.
`CreditRemaining`	decimal	yes	Supplier-credit magnitude less posted applications/refunds; subtract active reservations too for availability.
`PostedAt`	datetime		Local posting.
`Journal`	reference		→ JournalEntries. Stock clears exact GRNI; subcontract work clears accepted-work accrual at current carrying; direct eligible job charge owns ProjectCostEntry; actual absorbed-resource invoice clears resource clearing through FinanceCorrection. Only reviewed new price/cost difference adds expense. All create gross AP/tax once; retained payable is a subcomponent. Credit reverses original source/correction once.
`Baseline`	longtext	yes	Nonposting source/open/carrying/settlement/FX balances at migration.
`HeldRetentionAmount`	decimal	yes	Outstanding gross AP portion withheld under actual approved terms; not a second payable and not deducted from total AP Outstanding.
`DueAvailable`	decimal	yes	Outstanding minus held retention and active payment/prepayment/credit claims. Release changes eligibility only; no new cost/AP.

BillLinesSupplier charges matched to accepted receipts, with explicit nonstock exceptions.line

Field	Type	Required	Details
`Bill`	reference	yes	→ Bills. Parent revision.
`LineNumber`	number	yes	Stable key.
`OrderLine`	reference		→ PurchaseOrderLines. Approved commercial source for stock purchases.
`OriginalLine`	reference		→ BillLines. Required credit source.
`ReturnLine`	reference		→ ReturnLines. Exact returned source if credit.
`Product`	reference	yes	→ Products. Exact SKU/charge.
`BaseQuantity`	decimal	yes	Positive stock quantity; zero allowed only approved financial-only correction/charge.
`NetAmount`	decimal	yes	Document-currency net price amount; positive credit magnitude.
`TaxCode`	reference		→ TaxCodes. Frozen treatment.
`TaxAmount`	decimal	yes	Tax once; recovery/nonrecoverable destination explicit.
`ExpenseAccount`	reference		→ ChartOfAccounts. Required approved nonstock/non-PO expense basis; never invents receipt.
`SubcontractLine`	reference		→ SubcontractLines. Accepted subcontract scope for service invoice; BillMatches owns exact accrual relief.
`Project`	reference		→ Projects. Required direct eligible job charge; stock purchase has no automatic job expense.
`CostCode`	reference		→ CostCodes. Exact project cost code for direct charge or reviewed price difference.
`CostEntry`	reference		→ ProjectCostEntries. One new source expense/correction mirror only; accepted-work principal is already cost and cannot produce another entry here.
`ResourceReconciliation`	reference		→ FinanceCorrections. Actual resource bill clearing prior approved absorbed cost, Kind ResourceCostReconciliation; disjoint scope from direct expense.

BankAccountsEntity-owned bank currency balances and restricted destination data.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`BankCode`	text	yes	Unique bank/currency account.
`Currency`	reference	yes	→ Currencies. Actual bank currency.
`LedgerAccount`	reference	yes	→ ChartOfAccounts. Same-entity source-controlled bank/cash-on-hand/cash-in-transit account according to Kind; never processor clearing.
`Status`	select	yes	Draft, Active, Blocked, Closed
`ProtectedDetails`	longtext	yes	Accountant/Finance Manager only under current purpose; operator/sales exports excluded.
`BalanceQuantity`	decimal	yes	Posted own-currency balance, reconciled to actual bank statement or reviewed physical cash/transfer evidence; opening/collection/deposit is not duplicated.
`CarryingValue`	decimal	yes	Functional carrying balance including delta bank revaluation.
`UnrealizedFX`	decimal	yes	Signed prior bank FX to reclassify on scoped disposal.
`ReservedQuantity`	decimal	yes	Active released/unsettled instructions/refunds; prevent duplicate spend where finite availability policy applies.
`Version`	number	yes	Atomic balance/reservation version.
`Activation`	reference		→ MasterChanges. Independent Finance Manager. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`Kind`	select	yes	Bank, CashOnHand, CashInTransit

BankStatementLinesActual external bank evidence, not inferred payment success.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`StatementLineNumber`	text	yes	Unique bank transaction identity.
`BankAccount`	reference	yes	→ BankAccounts. Same entity/currency.
`Status`	select	yes	Imported, Matched, Reconciled, Disputed
`OccurredAt`	datetime	yes	Actual bank time.
`ValueDate`	date	yes	Bank value date.
`SignedAmount`	decimal	yes	Bank-currency receipt positive/payment negative; charges separately identifiable.
`ExternalReference`	text	yes	Provider statement/transaction identity.
`MatchedSource`	longtext		Exact local payment/receipt/refund/fee effect; same bank line cannot fund two effects.
`ReconciledBy`	reference		→ Users. Accountant confirmation; own exception needs independent Finance Manager.

CashReceiptsActual customer cash recognized once to unapplied liability before invoice allocation.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`ReceiptNumber`	text	yes	Unique cash receipt.
`Account`	reference		→ Accounts. May initially be unidentified; must be attributed with evidence before application.
`BankAccount`	reference	yes	→ BankAccounts. Required reviewed actual bank or CashOnHand account for same entity/currency.
`Status`	select	yes	Prepared, Posted, PartiallyApplied, Applied, Returned, Reversed
`ReceivedAt`	datetime		Actual confirmed bank/cash collection; order approval, invoice, payment request and transport acknowledgment are not receipt.
`Period`	reference	yes	→ AccountingPeriods. Eligible posting period.
`Amount`	decimal	yes	Positive receipt-currency amount.
`UnappliedAmount`	decimal	yes	Amount minus net posted ordinary ReceiptAmount applications, Customer Assign SourceAmount and directly receipt-funded refunds/actual returns; valid ReleasePurpose restores original unapplied source once. Later assigned-advance application/refund and credit-funded refunds never reduce this receipt again. Never negative.
`UnappliedCarrying`	decimal	yes	Functional remaining unapplied liability carrying, including its own revaluation.
`UnrealizedFX`	decimal	yes	Gain-positive prior FX on unapplied liability, released/reclassified proportionally.
`ReservedAmount`	decimal	yes	Current active ordinary application/refund/Customer Assign claims only, in receipt currency. HeldAmount is separate disjoint hold; available equals UnappliedAmount minus ReservedAmount minus HeldAmount. Posted assignments already removed from UnappliedAmount are not reserved again.
`StatementLine`	reference		→ BankStatementLines. Actual settlement evidence or reviewed manual cash proof in Event.
`Journal`	reference		→ JournalEntries. Actual Dr Bank/CashOnHand / Cr UnappliedCustomer once. Later assignment/application changes liability/contract/AR only, no second bank debit.
`Baseline`	longtext	yes	Opening receipt amount/applied/unapplied/carrying/FX and original source IDs, nonposting.
`SourceKind`	select	yes	Bank, Cash
`AvailabilityState`	select	yes	Clear, Unidentified, Held, ReviewRequired
`HeldAmount`	decimal	yes	Nonnegative unapplied hold outside active reservations; no more than UnappliedAmount minus ReservedAmount. Disputed identity/outcome blocks further action while actual cash remains recorded.

CashApplicationsCross-currency cash allocation consumes both receipt and invoice scope atomically.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`ApplicationNumber`	text	yes	Unique application.
`Receipt`	reference	yes	→ CashReceipts. Confirmed attributed same-entity/customer available unapplied source; posted assigned advances are unavailable here and use AdvanceAllocations instead.
`Invoice`	reference	yes	→ Invoices. Approved posted same-customer/entity unconditional due AR. Held retention excluded until released; a conditional right is never ordinary AR.
`Status`	select	yes	Reserved, Approved, Posted, Reversed, Cancelled
`ReceiptAmount`	decimal	yes	Positive cash consumed in receipt currency only.
`InvoiceCashAmount`	decimal	yes	Positive cash-funded portion in invoice currency.
`DiscountAmount`	decimal	yes	Nonnegative approved noncash settlement discount in invoice currency.
`WriteOffAmount`	decimal	yes	Nonnegative approved invoice-currency write-off; independent FM decision required.
`ReceiptRate`	reference	yes	→ ExchangeRates. Receipt currency settlement reference.
`InvoiceRate`	reference	yes	→ ExchangeRates. Invoice currency settlement reference.
`FunctionalSettlement`	decimal	yes	Reviewed equivalent cash/noncash functional value; receipt and invoice cash equivalents reconcile within explicit decimal policy.
`InvoiceCarryingReleased`	decimal	yes	Current carrying of settled total invoice quantity, proportional with final remainder.
`ReceiptCarryingReleased`	decimal	yes	Current unapplied liability carrying of consumed ReceiptAmount, not bank value.
`InvoiceFXReleased`	decimal	yes	Prior signed unrealized invoice FX in released portion.
`ReceiptFXReleased`	decimal	yes	Prior signed unapplied-liability FX in released portion.
`SettlementFXDelta`	decimal	yes	Functional noncash + ReceiptCarryingReleased − InvoiceCarryingReleased, gain-positive net application delta; cash receipt does not debit bank again.
`AppliedAt`	datetime		Actual committed application time. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`Journal`	reference		→ JournalEntries. Dr unapplied liability/noncash expense and Cr AR plus delta FX, with zero-net prior FX reclassification.
`ReversalOf`	reference		→ CashApplications. Exact original allocation, carrying/FX and claimed scope restored once.

PaymentRunsFrozen payable settlement proposals and protected beneficiary snapshots.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`RunNumber`	text	yes	Unique payment proposal.
`Status`	select	yes	Draft, PendingApproval, Released, Submitted, PartiallySettled, Settled, Exception, Closed, Cancelled
`PaymentDate`	date	yes	Intended execution date.
`PreparedBy`	reference	yes	→ Users. Accountant.
`ReleasedAt`	datetime		Independent Finance Manager release excluding preparer/material editors and underlying bill exception approver where required; use a different eligible FM person.

PaymentsOne economic supplier disbursement with authoritative settlement/rejection/return evidence.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`PaymentNumber`	text	yes	Stable disbursement.
`Run`	reference	yes	→ PaymentRuns. Approved exact run revision.
`Supplier`	reference	yes	→ Suppliers. Same-entity beneficiary.
`BankAccount`	reference	yes	→ BankAccounts. Entity source bank.
`Beneficiary`	reference	yes	→ SupplierBankAccounts. Approved exact beneficiary version.
`BeneficiaryHash`	text	yes	Must equal released destination; changes invalidate unsent authorization.
`Currency`	reference	yes	→ Currencies. Bank/payment currency.
`Amount`	decimal	yes	Positive proposed payment-currency total allocated or explicitly supplier prepayment.
`Status`	select	yes	Reserved, Released, Submitted, Accepted, Uncertain, Settled, Rejected, Returned, Cancelled
`Instruction`	reference		→ IntegrationDeliveries. Intent/attempt, not settlement proof.
`SettlementEvent`	reference		→ IntegrationEvents. Actual authenticated/manual-confirmed bank outcome.
`SettledAt`	datetime		Actual cash settlement.
`BankCarryingReleased`	decimal		Current functional bank value disposed, separate from AP settlement carrying.
`Journal`	reference		→ JournalEntries. Cash/AP/prepayment/FX effect only on authoritative settlement.
`PrepaymentRemaining`	decimal	yes	Unapplied supplier-prepayment amount remaining in payment currency; zero for fully bill-allocated disbursement.
`PrepaymentCarrying`	decimal	yes	Functional remaining supplier-prepayment asset with its own revaluation where monetary.
`PrepaymentFX`	decimal	yes	Signed prior unrealized FX on remaining prepayment.
`PrepaymentReserved`	decimal	yes	Active ordinary applications/refunds and purpose Assign claims share source availability; assigning subcontract purpose reserves that slice for linked AdvanceAllocations and cannot duplicate spendable prepayment.

PaymentAllocationsReserved bill and payment currency quantities with current-carrying settlement.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`AllocationNumber`	text	yes	Unique payment/bill allocation.
`Payment`	reference	yes	→ Payments. Parent economic disbursement.
`Bill`	reference		→ Bills. Posted same-supplier unconditional payable eligible for payment, excluding unreleased retention; null only actual approved prepayment.
`Status`	select	yes	Reserved, Settled, Released, Reversed
`PaymentAmount`	decimal	yes	Positive payment-currency cash portion.
`BillCashAmount`	decimal	yes	Bill-currency cash portion; zero only prepayment.
`DiscountAmount`	decimal	yes	Approved bill-currency discount, not cash consumed.
`PaymentRate`	reference	yes	→ ExchangeRates. Exact settlement conversion.
`BillRate`	reference	yes	→ ExchangeRates. Exact bill settlement basis.
`FunctionalSettlement`	decimal	yes	Cash equivalent plus approved discount in functional currency.
`BillCarryingReleased`	decimal	yes	Current AP carrying of settled portion.
`BillFXReleased`	decimal	yes	Prior unrealized AP gain-positive amount, reclassified zero-net.
`SettlementFXDelta`	decimal	yes	BillCarryingReleased − FunctionalSettlement, gain-positive AP delta; bank disposal FX is separate.
`SettledAt`	datetime		Actual effect time.
`ReversalOf`	reference		→ PaymentAllocations. Original settlement reversal linked to bank return; same scope cannot reopen twice.

CreditApplicationsBounded customer/supplier credit allocation with retained surplus and reservations.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`CreditApplicationNumber`	text	yes	Unique economic use.
`Side`	select	yes	Customer, Supplier
`CreditInvoice`	reference		→ Invoices. Customer CreditNote; mutually exclusive with CreditBill.
`CreditBill`	reference		→ Bills. Supplier CreditNote.
`DebitInvoice`	reference		→ Invoices. Same actual customer/entity approved unconditional AR, excluding held retention until release; no unrelated account transfer.
`DebitBill`	reference		→ Bills. Same supplier/entity debit target.
`CreditAmount`	decimal	yes	Positive credit-currency use; active Reserved amounts subtract availability.
`DebitAmount`	decimal	yes	Positive debit-currency settlement equivalent.
`RateEvidence`	longtext	yes	Frozen pair/date/type/multipliers and carrying/FX allocations; same-currency identity explicit.
`Status`	select	yes	Reserved, Posted, Released, Reversed
`CreatedAt`	datetime	yes	Atomic claim time.
`PostedAt`	datetime		Actual zero-cash clearing.
`Journal`	reference		→ JournalEntries. Clear credit-control and debit-control current carrying, remaining difference FX; reclassify prior unrealized zero-net.
`ReversalOf`	reference		→ CreditApplications. Exact prior claim.
`SupplierPrepayment`	reference		→ Payments. Alternative supplier-credit funding source; XOR CreditBill; settled available same-supplier prepayment only.

RefundsIndependent finance-authorized cash movement from exactly one available credit/unapplied source.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`RefundNumber`	text	yes	Unique refund/claim.
`Direction`	select	yes	ToCustomer, FromSupplier
`CreditInvoice`	reference		→ Invoices. One customer-credit funding source.
`CashReceipt`	reference		→ CashReceipts. Direct unapplied cash funding XOR CreditInvoice or Advance; assigned funds must use their Advance source, not this receipt again.
`CreditBill`	reference		→ Bills. Supplier-credit collection source for FromSupplier.
`Currency`	reference	yes	→ Currencies. Actual bank/cash refund currency, separately valued from original source.
`Amount`	decimal	yes	Positive cash amount.
`SourceAmount`	decimal	yes	Amount consumed in source document/receipt currency, separate from bank currency.
`SourceCarrying`	decimal	yes	Current functional funding value released.
`RateEvidence`	longtext	yes	Exact equivalent amount, bank carrying and prior FX reclassification basis.
`BankAccount`	reference	yes	→ BankAccounts. Required actual permitted same-entity bank/CashOnHand route and independently verified beneficiary.
`Status`	select	yes	Draft, PendingApproval, Reserved, Released, Submitted, Uncertain, Settled, Rejected, Returned, Cancelled, Held
`Instruction`	reference		→ IntegrationDeliveries. Transport intent only.
`SettlementEvent`	reference		→ IntegrationEvents. Authoritative actual cash outcome.
`SettledAt`	datetime		Actual posting time.
`Journal`	reference		→ JournalEntries. Clear exact funding liability/credit/prepayment/current carrying against actual bank/cash once with reviewed delta FX and prior FX reclassification. Credit or assigned-advance funding preserves original cash receipt/application history.
`SupplierPrepayment`	reference		→ Payments. Alternative FromSupplier funding collection; XOR CreditBill.
`Method`	select	yes	Bank, Cash
`DisputeEvidence`	longtext	yes	Actual claimant/beneficiary, source entitlement, overlapping reservations and disputed/uncertain outcome; no release without independent Finance Manager decision and authentic settlement evidence.
`Advance`	reference		→ AdvanceAllocations. Original assigned Customer or Supplier advance; XOR other funding sources. Linked Kind Refund consumes its source once and shares this journal. Supplier advance delegates original Payments asset; no double prepayment subtraction.

FinanceCorrectionsIndependent reviewed reversals, bank returns, write-offs and charges without editing posted history.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`CorrectionNumber`	text	yes	Unique economic correction.
`Kind`	select	yes	CashReturn, PaymentReturn, RefundReturn, InvoiceReversal, BillReversal, WriteOff, BankFee, CashTransfer, ResourceCostReconciliation, PostingCorrection, OpeningCorrection
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, Rejected
`SourceTable`	text	yes	Exact existing source type.
`SourceKey`	text	yes	Original immutable source/effect identity.
`Scope`	longtext	yes	Exact immutable source/value/quantity/currency/carrying/FX/tax, original effects and downstream claims; compensating actions never erase cash or make spendable balances negative. ResourceCostReconciliation binds actual resource cost to prior absorbed source rows and only approved differences post job expense.
`OccurredAt`	datetime	yes	Actual evidence date/time.
`PostingDate`	date	yes	Eligible current posting date, not rewritten original.
`Period`	reference	yes	→ AccountingPeriods. Same entity open period.
`Journal`	reference		→ JournalEntries. Compensates only traced effects; new fee/rate difference separately identified.
`Resource`	reference		→ CostResources. Required ResourceCostReconciliation; actual cost/import/bill source and approved absorbed work source scopes in AllocationEvidence.
`AllocationEvidence`	longtext	yes	Typed immutable source table/key/revision, prior absorption ProjectWorkLogs/ProjectCostEntries and actual BillLines or authenticated external-cost event; each exact currency/functional portion is reserved/consumed once. Difference allocation by project/code is explicit; resource clearing may stay unresolved but cannot be disguised as another full job expense. CashTransfer uses real source/destination BankAccounts and actual separate legs, preserving original customer receipt; no cash-drawer system implied.

RevaluationRunsDelta remeasurement of entity monetary balances after reconciliation, not presentation consolidation.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`RunNumber`	text	yes	Unique cutoff run.
`Period`	reference	yes	→ AccountingPeriods. Same entity.
`Status`	select	yes	Draft, Calculated, PendingApproval, Approved, Posted, Reversed
`AsOf`	datetime	yes	Frozen monetary population/cutoff.
`SourceHash`	text	yes	Current reconciled open item/bank/unapplied/credit balances and rates; stale changes require recalculation.
`PostedAt`	datetime		Actual delta posting.
`Journal`	reference		→ JournalEntries. Balance changes versus unrealized FX, exactly once.

RevaluationLinesOne remaining monetary source, not both detail and its control total.line

Field	Type	Required	Details
`Run`	reference	yes	→ RevaluationRuns. Reviewed cutoff.
`SourceTable`	select	yes	Invoices, Bills, CashReceipts, BankAccounts, Payments, SubcontractAccruals, ContractBalances. Only actual monetary open source components under reviewed policy; nonmonetary historic advances/contract components retain frozen basis. Retention and assigned advance detail are not revalued again when included in AR/AP/contract position or original prepayment; no duplicated control and detail valuation.
`SourceKey`	text	yes	Exact source and normal-balance/component identity, including accounting-unit monetary contract component; current open scope, prior FX and classification evidenced.
`Currency`	reference	yes	→ Currencies. Source currency.
`OpenAmount`	decimal	yes	Remaining signed economic currency balance, positive magnitude plus source debit/liability direction.
`Rate`	reference	yes	→ ExchangeRates. Reviewed Closing rate to entity functional currency.
`BeforeCarrying`	decimal	yes	Current functional carrying before this delta.
`AfterCarrying`	decimal	yes	OpenAmount × rate using source normal balance.
`Delta`	decimal	yes	After − before; gain sign determined by asset/liability, not an unconditional profit.
`PriorFX`	decimal	yes	Retained signed prior unrealized FX.
`Status`	select	yes	Calculated, Posted, Reversed

JournalEntriesBalanced entity-functional journals with source identity and immutable postings.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`JournalNumber`	text	yes	Unique entity journal.
`Kind`	select	yes	Trade, Project, Stock, WIP, Cash, CashTransfer, Tax, FX, Reclassification, Manual, Opening, Correction
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, Reversed
`PostingDate`	date	yes	Date in eligible Period.
`Period`	reference	yes	→ AccountingPeriods. Same entity.
`SourceTable`	text	yes	Existing typed source or explicitly authorized Manual/Opening evidence.
`SourceKey`	text	yes	Unique economic source/effect; a second transport event cannot repost it.
`PostedAt`	datetime		Actual local posting.
`ReversalOf`	reference		→ JournalEntries. Exact prior journal/line source; no destructive editing.
`CashTransferFrom`	reference		→ BankAccounts. Required for CashTransfer; source Bank/CashOnHand/CashInTransit under actual custody evidence, same entity and different from destination.
`CashTransferTo`	reference		→ BankAccounts. Required actual same-entity bank/cash destination; no new CashReceipt/customer/revenue.
`CashTransferSourceAmount`	decimal		Positive actual source-currency amount, exclusively reserved against source cash availability until confirmed movement.
`CashTransferDestinationAmount`	decimal		Positive actual destination-currency amount; same-currency identity explicit, foreign conversion separately evidenced.
`CashTransferSourceCarrying`	decimal		Exact positive current functional carrying removed from source with prior FX allocation.
`CashTransferDestinationValue`	decimal		Actual positive functional value received at destination; difference is reviewed FX/fee, never invented rounding or revenue.
`CashTransferEvidence`	longtext		Actual custody/bank confirmation, finite source claim and recipient/amount/FX/fee proof. Cash handed to transit is not bank receipt; second actual deposit consumes only remaining transit scope.
`CashTransferStatement`	reference		→ BankStatementLines. Required actual bank evidence for bank leg; cash-only custody needs reviewed manual proof.
`PriorCashTransfer`	reference		→ JournalEntries. Exact earlier CashTransfer transit leg; later deposit/reversal cannot consume more than remaining in-transit source.
`SourceComponents`	longtext	yes	Typed immutable economic components sharing this journal, including stock/cost mirror, acceptance/accrual, billing/contract movement, revenue assessment, retention/advance allocation, current carrying and prior FX reclassification. Each component may occur once, with balanced net debits/credits.

JournalLinesNonnegative debit/credit magnitudes, one side per line, balanced in functional precision.line

Field	Type	Required	Details
`Journal`	reference	yes	→ JournalEntries. Same entity source.
`LineNumber`	number	yes	Stable line.
`Account`	reference	yes	→ ChartOfAccounts. Same entity; source-specific control mappings required.
`Debit`	decimal	yes	Nonnegative, not both debit and credit positive.
`Credit`	decimal	yes	Nonnegative.
`OriginalCurrency`	reference		→ Currencies. Foreign source denomination where relevant.
`OriginalAmount`	decimal		Source amount with explicit sign/basis, not another posting.
`SourceAllocation`	longtext	yes	Exact stock/receipt/invoice/payment/WIP/FX source allocation and rule version.

ReceiptAcceptancesIndependent bounded disposition tranches against one immutable actual arrival.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`AcceptanceNumber`	text	yes	Unique arrival/tranche identity; duplicate callbacks reuse it.
`ReceiptLine`	reference	yes	→ GoodsReceiptLines. One immutable actual arrival line.
`Disposition`	select	yes	Accept, Reject
`Status`	select	yes	Prepared, PendingReview, Confirmed, Posted, Reversed
`BaseQuantity`	decimal	yes	Positive tranche quantity; active confirmed tranches cannot exceed arrived quantity less previous live tranches.
`StandardCost`	reference		→ StandardCosts. Required for accepted owned-stock effect; frozen version.
`ReceiptRate`	reference		→ ExchangeRates. Required dated receipt valuation multiplier.
`CommercialFunctionalValue`	decimal		Accepted scoped PO net/approved capitalizable charges at receipt rate; zero only approved known-zero basis.
`ConfirmedBy`	reference		→ Users. Actual independent Warehouse Operator, not PO buyer/commercial approver; null until confirmation and mandatory before Confirmed/Posted with required condition/cost evidence.
`ConfirmedAt`	datetime		Actual physical disposition confirmation.
`Evidence`	longtext	yes	Condition/quantity evidence and any independent WM/FM exception decisions; rejected quantity creates no owned stock or GRNI.
`StockEvent`	reference		→ StockEvents. Accepted tranche posts quantity/standard value/GRNI/variance once; rejection has no owned posting.
`ReversalOf`	reference		→ ReceiptAcceptances. Exact prior tranche only after downstream stock/match/return effects reconcile.

LotsEntity/product lot identity with supplier/production provenance and independently controlled eligibility.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree.
`LotNumber`	text	yes	Unique entity/product/lot identity; display identifier alone is insufficient across products/entities.
`Product`	reference	yes	→ Products. Controlled SKU.
`Supplier`	reference		→ Suppliers. Original supplier when incoming.
`SourceReceipt`	reference		→ GoodsReceiptLines. Immutable arrival source; current stock remains separate.
`SourceCompletion`	reference		→ ProductionCompletions. Manufactured output source.
`ExpiresAt`	datetime		Evidence-backed shelf-life boundary; missing required expiry blocks use.
`Status`	select	yes	PendingReview, Released, Held, Exhausted
`Provenance`	longtext	yes	Original source and downstream split/production lineage; lot status does not directly overwrite position quantities.

SerialsUnique individual stock identity; same serial cannot be simultaneously stocked, consumed or delivered twice.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree.
`SerialNumber`	text	yes	Unique entity/product serial identity with immutable provenance.
`Product`	reference	yes	→ Products. Serial-controlled SKU.
`Lot`	reference		→ Lots. Matching lot when also lot-controlled.
`Status`	select	yes	PendingReview, InStock, InProduction, Shipped, Returned, Scrapped
`Provenance`	longtext	yes	Original receipt/output, exact net current position and all movement/return links; status is derived from actual events.

ProjectsOwning-company project boundary, customer and controlled operational/financial close.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`ProjectCode`	text	yes	Unique entity/project identity; a code does not authorize cross-entity stock or cash use.
`Name`	text	yes	Project name.
`Customer`	reference	yes	→ Accounts. Actual same-entity customer.
`Manager`	reference	yes	→ Users. Scoped Project Manager.
`Status`	select	yes	Prospect, Bid, Active, OnHold, OperationallyComplete, PendingFinancialClose, Closed, Cancelled
`PlannedStart`	date	yes	Planned commencement.
`PlannedEnd`	date	yes	Planned completion.
`ActualStart`	datetime		Actual evidenced commencement.
`OperationalCompletedAt`	datetime		Independent Project Manager quantity/scope closure; financial obligations may remain separately visible.
`FinancialClosedAt`	datetime		Independent Finance Manager closure only after all retained/advance/accrual/contract/AR/AP obligations reconcile.
`CloseDecision`	reference		→ ApprovalDecisions. Exact independent Project Manager operational scope, excluding preparers/material editors.
`FinanceCloseDecision`	reference		→ ApprovalDecisions. Exact independent Finance Manager complete financial source reconciliation.

ProjectSitesPhysical project locations and optional owned-stock custody mapping.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`SiteCode`	text	yes	Unique entity/site code.
`Project`	reference	yes	→ Projects. Owning project; warehouse assignment is not a sale.
`Name`	text	yes	Actual site name.
`Address`	longtext	yes	Location and handling facts.
`Supervisor`	reference	yes	→ Users. Scoped Site Supervisor.
`Warehouse`	reference		→ Warehouses. Same-entity inventory custody when stock is held at this site.
`Location`	reference		→ Locations. Optional valid location within the selected warehouse.
`Status`	select	yes	Draft, Active, Restricted, Closed
`Activation`	reference		→ ApprovalDecisions. Independent Project Manager site scope and Warehouse Manager stock-location approval where relevant.

CostCodesProject work/cost breakdown with one authoritative parent and explicit unit basis.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Code`	text	yes	Unique code within project.
`Project`	reference	yes	→ Projects. Owning project.
`Parent`	reference		→ CostCodes. Same-project parent; acyclic hierarchy, rollups do not duplicate child amounts.
`Name`	text	yes	Work/cost description.
`Category`	select	yes	Material, Labor, Equipment, Subcontract, Other, Mixed
`Unit`	reference		→ UnitsOfMeasure. Measured work unit where applicable; money is not a physical SKU unit.
`Status`	select	yes	Draft, Active, Suspended, Closed
`Activation`	reference		→ ApprovalDecisions. Independent Project Manager technical structure and Finance Manager accounting/budget coding where affected.

EstimateComponentsFrozen quantity and known-cost assumptions behind one offered quote line.line

Field	Type	Required	Details
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`QuoteLine`	reference	yes	→ QuoteLines. Exact offered alternative/work scope.
`ComponentNumber`	text	yes	Stable line/component identity.
`Kind`	select	yes	Material, Labor, Equipment, Subcontract, Other
`Description`	text	yes	Concrete assumption and included work.
`ProductUnit`	reference		→ ProductUnits. Material unit mapping only; no fabricated product for labor/service.
`Resource`	reference		→ CostResources. Labor/equipment resource class when used.
`Supplier`	reference		→ Suppliers. Optional actual subcontract/material quotation source.
`Quantity`	decimal	yes	Nonnegative estimated units/hours; exact unit and extension in Basis.
`UnitCost`	decimal		Reviewed known cost in quote currency; null if unknown, known zero valid.
`TotalCost`	decimal		Quantity times known unit cost plus explicitly separate fixed component; null if incomplete, never fabricate zero.
`CostKnown`	boolean	yes	True only when all required cost/conversion evidence is complete.
`Basis`	longtext	yes	Unit, fixed/variable amounts, cost source/date/currency/rate, assumptions and price inclusion; all offered alternatives remain visible to review.
`Rate`	reference		→ ExchangeRates. Actual reviewed conversion to quote currency where needed.
`Evidence`	attachment		Original estimate/quotation evidence with protected access.
`Status`	select	yes	Draft, Frozen, Superseded

ProjectContractsAccepted project commercial agreement linked to its independently approved order scope.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`ContractNumber`	text	yes	Unique accepted agreement identity.
`Project`	reference		→ Projects. Required only for Kind Project; standalone Goods agreement has no fabricated construction project.
`Customer`	reference	yes	→ Accounts. Actual contracting customer.
`Order`	reference	yes	→ SalesOrders. One authoritative accepted commercial order; its Goods/ProjectWork lines own accepted quantity/net/tax, not a second contract value.
`Currency`	reference	yes	→ Currencies. Contract transaction currency.
`Status`	select	yes	Draft, PendingApproval, PendingAcceptance, Active, Suspended, OperationallyComplete, PendingClose, Closed, Cancelled
`ContractDate`	date	yes	Original document date.
`StartDate`	date	yes	Agreed start.
`EndDate`	date	yes	Agreed end, not automatic financial close.
`AcceptedAt`	datetime		Actual complete customer acceptance plus internal Commercial Manager approval evidence.
`AcceptanceEvidence`	longtext	yes	Actual authorized customer identity, complete terms/artifact hash and commercial revision; no installed signature provider assumed.
`OriginalNet`	decimal	yes	Original accepted order net once.
`CurrentNet`	decimal	yes	Original net plus approved applied changes; no duplicate order/contract sum.
`CumulativeGrossIncreases`	decimal	yes	All positive line-level approved increases; decreases do not conceal new exposure.
`BillingTerms`	longtext	yes	Project: fixed-price milestone/measured progress or unit-rate scope, stored-material eligibility, external certification, caps, prior billing, advances and retention. Goods: actual handover scope and agreed billing/advance terms. No statutory default or T&M billing.
`RecognitionPolicy`	longtext	yes	Finance Manager-reviewed performance obligations, transaction-price allocation, output/measured-progress or point-in-time evidence, monetary classification and correction basis; certification/billing/cost ratios do not automatically establish recognition.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager performance/recognition, retention/advance/tax and finance policy approval.
`ClosedAt`	datetime		Actual final contract closure after all surviving source balances reconcile.
`AccountingUnit`	reference	yes	→ ProjectContracts. Reviewed accounting contract/root grouping; default self. Members share entity/customer/currency and approved contract-accounting basis. Grouping is immutable after effects except fully reconciled approved change; no unrelated portfolio/entity netting.
`Kind`	select	yes	Project, Goods

PerformanceObligationsOne reviewed obligation with allocated consideration and explicit recognition evidence.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`ObligationCode`	text	yes	Unique contract/revision performance scope.
`Contract`	reference	yes	→ ProjectContracts. Owning accepted contract.
`Description`	longtext	yes	Promised distinct work/goods and completion evidence; grouping and allocation basis reviewed by Finance Manager.
`Method`	select	yes	OutputProgress, PointInTime
`Measure`	longtext	yes	Reviewed measurable units/milestones and satisfaction criteria; no cost-to-cost or automatic invoice percentage.
`AllocatedPrice`	decimal	yes	Sum current effective PerformanceAllocations in contract currency; protected changes retain prior recognized/billed/fulfilled scope.
`Currency`	reference	yes	→ Currencies. Contract currency.
`Status`	select	yes	Draft, PendingApproval, Active, OnHold, Satisfied, Closed, Superseded
`Activation`	reference		→ ApprovalDecisions. Independent Finance Manager price allocation/method, with Commercial Manager accepted scope evidence.
`SatisfiedAt`	datetime		Actual supported satisfaction time; not inferred from final invoice/cash.

PerformanceAllocationsExact accepted line value allocated to performance obligations without duplicate sale scope.line

Field	Type	Required	Details
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`Obligation`	reference	yes	→ PerformanceObligations. Target obligation.
`OrderLine`	reference	yes	→ SalesOrderLines. Same accepted contract order line, Goods or ProjectWork.
`AllocationNumber`	text	yes	Unique line/obligation/current-revision allocation.
`AllocatedNet`	decimal	yes	Nonnegative reviewed transaction-price portion in contract currency; across obligations equals accepted allocated consideration with deterministic final rounding.
`Basis`	longtext	yes	Reviewed allocation assumptions, approved variable/change consideration and exact line scopes; disputed/unapproved changes do not expand price.
`Status`	select	yes	Draft, Approved, Effective, Superseded, Reversed
`Decision`	reference		→ ApprovalDecisions. Independent Finance Manager exact allocation; Commercial Manager approves underlying commercial change.

ProjectChangesProposed versus accepted project change with preserved executed scope.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`ChangeNumber`	text	yes	Unique proposed variation/change identity.
`Contract`	reference	yes	→ ProjectContracts. Owning contract/project.
`Status`	select	yes	Draft, Submitted, UnderReview, Approved, Rejected, Applied, Superseded
`RequestedAt`	datetime	yes	Actual request time.
`AcceptedAt`	datetime		Actual complete customer acceptance where commercial terms change.
`AppliedAt`	datetime		Atomic current-revision application after all required decisions.
`Evidence`	longtext	yes	Customer/technical scope, prior/current quantities/value, changed cost/billing/recognition/retention basis and impacted commitments; unaccepted variation remains outside authority.
`TechnicalDecision`	reference		→ ApprovalDecisions. Independent Project Manager technical/schedule scope approval excluding preparer/material editors.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager budget/valuation/recognition/advance/retention effects.

ProjectChangeLinesLine-level additions, replacements and cancellations against exact remaining accepted scope.line

Field	Type	Required	Details
`Change`	reference	yes	→ ProjectChanges. Parent change.
`LineNumber`	number	yes	Unique line sequence.
`OrderLine`	reference	yes	→ SalesOrderLines. Exact existing or proposed new contract line; new line has no active authority before applied change.
`CostCode`	reference		→ CostCodes. Affected project code.
`Kind`	select	yes	Add, ReplaceRemaining, ReduceRemaining, Correct
`OldNet`	decimal	yes	Frozen previous affected net value.
`NewNet`	decimal	yes	Proposed affected net; cannot reduce below retained certified/billed/recognized/committed obligations without explicit coordinated corrections.
`GrossIncrease`	decimal	yes	Maximum of NewNet minus OldNet and zero; summed cumulatively for authority.
`Scope`	longtext	yes	Exact quantities/unit, completed/stored/billed/recognized/committed portions, replacement identity and required downstream correction; no silent reset of historical claims.
`Status`	select	yes	Proposed, Approved, Applied, Rejected, Superseded

ProjectBudgetsImmutable approved project cost budget version distinct from actual and forecast.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`BudgetNumber`	text	yes	Unique project/budget version.
`Project`	reference	yes	→ Projects. Owning project.
`Currency`	reference	yes	→ Currencies. Budget/reporting currency with retained functional conversion.
`Kind`	select	yes	Original, ApprovedRevision
`Status`	select	yes	Draft, PendingApproval, Approved, Locked, Superseded
`EffectiveDate`	date	yes	Approved reporting effective date, never rewrites past actual cost.
`Change`	reference		→ ProjectChanges. Approved scope change if applicable.
`TechnicalDecision`	reference		→ ApprovalDecisions. Independent Project Manager quantity/cost-code basis.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager financial cap/conversion approval.
`LockedAt`	datetime		Actual approved immutable snapshot time.

ProjectBudgetLinesOne budget cost-code/category scope with explicit quantity and rate basis.line

Field	Type	Required	Details
`Budget`	reference	yes	→ ProjectBudgets. Parent version.
`LineNumber`	number	yes	Unique line sequence.
`CostCode`	reference	yes	→ CostCodes. Same-project scope.
`Category`	select	yes	Material, Labor, Equipment, Subcontract, Other
`Quantity`	decimal	yes	Nonnegative planned units/hours; no financial posting.
`Rate`	decimal		Reviewed budget currency unit rate; null if unknown draft.
`Amount`	decimal		Known quantity/rate/fixed scope budget value, mandatory finite before approval.
`Basis`	longtext	yes	Unit, quantity, fixed amount, currency/rate and included source scope.
`Status`	select	yes	Draft, Approved, Superseded

ProjectForecastsDated independent remaining-cost forecast that never replaces the approved budget or actual ledger.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`ForecastNumber`	text	yes	Unique project/cutoff version.
`Project`	reference	yes	→ Projects. Owning project.
`Budget`	reference	yes	→ ProjectBudgets. Compared approved baseline.
`Currency`	reference	yes	→ Currencies. Explicit report currency.
`CutoffAt`	datetime	yes	Actual/commitment/stock snapshot cutoff.
`Status`	select	yes	Draft, PendingReview, Approved, Superseded
`Basis`	longtext	yes	Exact actual cost population and independently estimated remaining scope; no cost-to-cost revenue inference.
`ReviewedAt`	datetime		Independent Project Manager forecast review with Finance Manager currency/financial reconciliation where required.

ProjectForecastLinesDisjoint remaining-cost buckets with explicit included commitments and owned unused stock.line

Field	Type	Required	Details
`Forecast`	reference	yes	→ ProjectForecasts. Parent snapshot.
`LineNumber`	number	yes	Unique line.
`CostCode`	reference	yes	→ CostCodes. Same project.
`Category`	select	yes	Material, Labor, Equipment, Subcontract, Other
`RemainingCost`	decimal		Known estimate-to-complete in forecast currency; null if unresolved, known zero valid.
`IncludedScope`	longtext	yes	Exact remaining commitment quantities/value, owned unused material expected to be consumed, other uncommitted work and source IDs; these included amounts cannot be added again to RemainingCost.
`Basis`	longtext	yes	Source dates, units/rates/conversions and uncertainty. Actual plus RemainingCost is forecast final cost only when cutoff/source scope is disjoint.
`Status`	select	yes	Draft, Reviewed, Unresolved, Superseded

ProjectCommitmentsConserved allocation of approved unperformed purchase or subcontract scope to project costs.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`CommitmentNumber`	text	yes	Unique source family/project/code allocation.
`Project`	reference	yes	→ Projects. Owning project.
`CostCode`	reference	yes	→ CostCodes. Same-project cost scope.
`SourceKind`	select	yes	PurchaseOrder, Subcontract
`PurchaseOrderLine`	reference		→ PurchaseOrderLines. Exactly one source with SubcontractLine.
`SubcontractLine`	reference		→ SubcontractLines. Approved work scope, never the same obligation represented again as PO.
`Currency`	reference	yes	→ Currencies. Original commitment currency.
`OriginalAmount`	decimal	yes	Original approved allocated net commitment.
`CurrentAmount`	decimal	yes	Net currently approved source amount after all applied increases and unperformed reductions; fulfilled accepted history is preserved. ReleasedAmount is informational history already included here, not another deduction.
`FulfilledAmount`	decimal	yes	Accepted/consumed original-source amount, not billed or paid amount; receiving inventory may fulfill procurement but does not itself create job expense.
`ReleasedAmount`	decimal	yes	Cumulative approved unperformed reductions/cancellations already reflected in CurrentAmount; retained separately for audit, not subtracted from RemainingAmount again.
`ReservedAmount`	decimal	yes	Active acceptance/conversion/change claims against remaining unperformed source.
`RemainingAmount`	decimal	yes	CurrentAmount minus FulfilledAmount, never negative; e.g.original60 less10 cancellation gives CurrentAmount50, less20 fulfilled leaves30. New active claims subtract only other active claims from this remaining scope.
`Status`	select	yes	Draft, Approved, Active, PartiallyFulfilled, Fulfilled, Released, Held, Closed
`CommittedAt`	datetime		Actual authority/reservation time.
`SourceBasis`	longtext	yes	Exact original/current revision, quantity/net/tax currency, project allocation and family identity; conversion to receipt/bill never duplicates commitment or actual cost.

ProjectCostEntriesOne immutable signed economic expense source with journal lineage, not another copy of the posting.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`CostNumber`	text	yes	Unique source/action/expense-leg identity.
`Origin`	select	yes	MaterialConsumption, AcceptedLabor, AcceptedEquipment, SubcontractAcceptance, DirectBill, PriceVariance, PrefabVariance, Recovery, Reclassification, Correction, Opening
`Currency`	reference	yes	→ Currencies. Original source currency.
`Amount`	decimal	yes	Signed original expense amount; corrections retain original and bounded signed compensation.
`FunctionalAmount`	decimal	yes	Signed entity-functional expense amount from the exact source journal/rate.
`CostDate`	date	yes	Actual incurred/accepted source date.
`PostedAt`	datetime		Actual native posting time; null in Prepared/PendingReview. Opening retains historical actual time only when evidenced; never manufacture one.
`Period`	reference	yes	→ AccountingPeriods. Same-entity posting period.
`Journal`	reference		→ JournalEntries. Required for native Posted expense; references the source journal, never posts another full expense. Opening uses nonposting baseline.
`SourceTable`	text	yes	Validated native source table or approved imported source family.
`SourceKey`	text	yes	Exact source/action/leg ID, deduplicated across imports and native effects.
`SourceEvidence`	longtext	yes	Original quantity/unit/current carrying/rate and financial owner; stock receipt/PO/payment do not independently create job cost.
`Status`	select	yes	Prepared, PendingReview, Posted, Reversed, Opening
`Decision`	reference		→ ApprovalDecisions. Required independent financial decision for manual/incremental expense or reclassification.
`Reverses`	reference		→ ProjectCostEntries. Exact bounded original cost/quantity; no arbitrary negative expense.
`Migration`	reference		→ MigrationItems. Nonposting carried source and opening journal reconciliation.

ProjectCostAllocationsProject/code attribution of an existing expense source, including explicit balanced reallocations.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`AllocationNumber`	text	yes	Unique expense source/project/code allocation.
`CostEntry`	reference	yes	→ ProjectCostEntries. Existing source expense; original and reversal legs remain visible.
`Project`	reference	yes	→ Projects. Same-entity destination.
`CostCode`	reference	yes	→ CostCodes. Same-project code.
`Amount`	decimal	yes	Signed source-currency attribution, bounded by remaining unallocated source; reallocations use paired negative/positive legs.
`FunctionalAmount`	decimal	yes	Corresponding signed current source expense basis, never a new valuation or expense.
`Kind`	select	yes	ActualExpense, Attribution, Transfer, Correction, Opening
`Status`	select	yes	Draft, PendingApproval, Approved, Applied, Reversed
`Basis`	longtext	yes	Exact source slices, rate, project purpose and paired transfer IDs; prefab variance attribution may join consumed finished-goods cost for management reporting, but cannot post variance or finished cost a second time.
`Decision`	reference		→ ApprovalDecisions. Independent Project Manager scope and Finance Manager financial attribution/reallocation approval where required.
`AppliedAt`	datetime		Actual attribution time.
`ReversalOf`	reference		→ ProjectCostAllocations. Bounded original allocation correction.

ProjectMaterialRequirementsApproved field-material demand and current shared stock claims; a requirement is not consumption.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`RequirementNumber`	text	yes	Unique project/code/product need.
`Project`	reference	yes	→ Projects. Owning project.
`Site`	reference	yes	→ ProjectSites. Actual site.
`CostCode`	reference	yes	→ CostCodes. Same-project cost scope.
`Product`	reference	yes	→ Products. Canonical material identity.
`BaseQuantity`	decimal	yes	Approved positive total need in product base units; revisions preserve used scope.
`UsedQuantity`	decimal	yes	Actual net eligible ProjectMaterialUsages, not merely delivered-to-site quantity.
`CancelledQuantity`	decimal	yes	Approved unused scope release.
`RequiredAt`	datetime	yes	Operational need time.
`Status`	select	yes	Draft, PendingApproval, Approved, PartiallyUsed, Used, Held, Cancelled, Closed
`SourceBasis`	longtext	yes	Budget/change/technical basis, original requirement family and units; avoid duplicate procurement/fabrication demand for the same need.

ProjectMaterialUsagesActual field consumption or evidenced recovery with exact stock, expense and source lineage.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`UsageNumber`	text	yes	Unique physical/economic source action.
`Requirement`	reference	yes	→ ProjectMaterialRequirements. Approved demand/code/site.
`Kind`	select	yes	Consume, Recover, Correct
`BaseQuantity`	decimal	yes	Positive exact physical base quantity; consume only eligible stock under shared claims.
`Position`	reference	yes	→ InventoryPositions. Actual source/destination identity according to action, never a depleted origin fabricated by reversal.
`Reservation`	reference		→ InventoryReservations. Exact current eligible project material claim.
`OriginalUsage`	reference		→ ProjectMaterialUsages. Required recovery/correction original source; bounded by actual proven remaining recoverable scope and downstream use.
`OccurredAt`	datetime	yes	Actual field event time.
`RecordedBy`	reference	yes	→ Users. Actual Warehouse Operator/Project Worker recorder.
`AcceptedBy`	reference		→ Users. Independent Site Supervisor actual-use evidence, excluding recorder/producer; Warehouse Manager approves physical recovery where required.
`Status`	select	yes	Prepared, PendingAcceptance, Accepted, Posted, Held, Reversed
`Evidence`	longtext	yes	Actual quantities/lot/serial/unit, physical use or genuine recovery and independent factual review; unused own-site stock return is a transfer, not negative job expense.
`StockEvent`	reference		→ StockEvents. Single stock movement and current carrying owner.
`CostEntry`	reference		→ ProjectCostEntries. Mirror of the one Dr project expense / Cr owned inventory effect, or exact approved recovery; no second expense journal.

CostResourcesInternal labor/equipment cost resource basis without payroll, fleet or asset register claims.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`ResourceCode`	text	yes	Unique entity resource or cost class.
`Name`	text	yes	Resource/class description.
`Kind`	select	yes	Labor, Equipment
`Person`	reference		→ Users. Actual worker identity when a person-specific labor source is used; no employment/payroll record implied.
`Unit`	reference		→ UnitsOfMeasure. Hour or explicitly configured measured usage unit.
`ClearingAccount`	reference	yes	→ ChartOfAccounts. Reviewed expense absorption/accrual counterpart; actual external cost later clears/reconciles this owner rather than duplicating project expense.
`Status`	select	yes	Draft, Active, Suspended, Retired
`Activation`	reference		→ ApprovalDecisions. Independent Finance Manager rate/counterpart authority and Project Manager operational eligibility.
`ReconciliationPolicy`	longtext	yes	Accepted internal rate absorption posts project expense against this resource clearing/accrual source. Actual bill/import cost for the same resource/period debits that clearing instead of project expense again; FinanceCorrections ResourceCostReconciliation owns exact prior absorbed/source-cost claims and independently approved difference/reclassification, with unmatched residual visible at close. No payroll or fleet execution is implied.

CostRateVersionsEffective reviewed internal cost snapshots for actual accepted field labor/equipment usage.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`RateCode`	text	yes	Unique effective version.
`Resource`	reference	yes	→ CostResources. Same-entity resource.
`Currency`	reference	yes	→ Currencies. Rate currency.
`Rate`	decimal	yes	Nonnegative known cost per approved unit; zero is explicit known zero.
`EffectiveFrom`	datetime	yes	Inclusive actual-work start bound.
`EffectiveTo`	datetime		Exclusive end; active versions cannot overlap for same resource/purpose.
`Status`	select	yes	Draft, PendingApproval, Active, Superseded
`Basis`	longtext	yes	What the rate includes, actual-work time basis, source cost/absorption reconciliation and accepted usage unit; rate change does not recost posted history.
`Approval`	reference		→ ApprovalDecisions. Independent Finance Manager activation excluding rate preparer/material editors.

ProjectWorkLogsActual field labor/equipment evidence with separate recorder, performer and independent acceptor.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`WorkNumber`	text	yes	Unique actual resource/interval/economic identity.
`Project`	reference	yes	→ Projects. Owning project.
`Site`	reference	yes	→ ProjectSites. Actual site.
`Resource`	reference	yes	→ CostResources. Labor/equipment use.
`PerformedBy`	reference	yes	→ Users. Actual Project Worker/operator identity for labor or equipment operation.
`RecordedBy`	reference	yes	→ Users. Actual recorder; may differ from performer, both retained.
`StartedAt`	datetime	yes	Actual start with timezone.
`EndedAt`	datetime		Actual end; incomplete/zero duration cannot supply cost or billing evidence.
`Quantity`	decimal	yes	Nonnegative actual accepted hours/usage; elapsed interval and declared shares must reconcile.
`Status`	select	yes	Draft, Running, Submitted, Accepted, Rejected, Posted, Reversed
`AcceptedBy`	reference		→ Users. Independent Site Supervisor, excluding performer/recorder/material editors; this is factual cost acceptance, not customer certification or revenue recognition.
`AcceptedAt`	datetime		Actual independent acceptance.
`RateVersion`	reference		→ CostRateVersions. Effective actual-work rate snapshot, required before known cost posting.
`Rate`	reference		→ ExchangeRates. Reviewed conversion to functional cost where needed.
`Evidence`	longtext	yes	Actual work, interval/unit and declared share evidence. All accepted person-time is checked across ProjectWorkLogs and ProductionEntries by actual person, not role/account: production exclusive intervals prohibit concurrent project shares; project-only share allocations total at most1 at each instant. No duplicate absorption across jobs/prefab.
`CostEntry`	reference		→ ProjectCostEntries. One nonzero accepted quantity/rate expense source with reviewed resource clearing counterpart. Known-zero rate/work value retains actual accepted evidence without a fabricated journal. Later actual cost clears/reconciles that same counterpart; only approved difference adds expense.
`ReversalOf`	reference		→ ProjectWorkLogs. Exact original accepted/posted scope and allocations; corrections preserve source history.

ProjectWorkAllocationsDisjoint allocations of accepted field hours/usage to cost codes, not a second time record.line

Field	Type	Required	Details
`WorkLog`	reference	yes	→ ProjectWorkLogs. Parent actual work.
`AllocationNumber`	text	yes	Unique work/code allocation.
`CostCode`	reference	yes	→ CostCodes. Same-project code.
`Quantity`	decimal	yes	Nonnegative share of actual accepted work; all active/posted shares <= parent accepted quantity.
`Status`	select	yes	Draft, Accepted, Posted, Reversed
`Basis`	longtext	yes	Exact actual interval/fraction/output and cost share, deterministic final rounding; this cost source is not T&M billing entitlement.
`CostAllocation`	reference		→ ProjectCostAllocations. Existing source expense attribution, no additional expense.

SubcontractsSeparate approved supplier work obligation with advances, retention and versioned commercial scope.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`SubcontractNumber`	text	yes	Unique entity/project supplier agreement.
`Project`	reference	yes	→ Projects. Owning project.
`Supplier`	reference	yes	→ Suppliers. Actual subcontractor; active status required for new commitments, protected bank details separately approved.
`Currency`	reference	yes	→ Currencies. Agreement currency.
`Status`	select	yes	Draft, Submitted, Approved, Active, Suspended, PartiallyPerformed, Performed, PendingClose, Closed, Cancelled
`ContractDate`	date	yes	Original agreement date.
`StartDate`	date	yes	Planned performance start.
`EndDate`	date	yes	Planned completion, not automatic financial closure.
`OriginalAmount`	decimal	yes	Original approved net work scope.
`CurrentAmount`	decimal	yes	Current approved total; document revisions retain each line's original/new scope.
`CumulativeGrossIncreases`	decimal	yes	Sum positive line-level approved increases across amendments; reductions never hide new work authority.
`ApprovalBasis`	decimal	yes	Maximum of current proposed total and original amount plus cumulative gross increases, converted using finite authority currency evidence.
`Terms`	longtext	yes	Accepted work/unit prices, measurement, independent acceptance, changes, configured retention/advance recovery, tax and payment basis; no statutory rate/deadline assumed.
`QualificationEvidence`	longtext	yes	Configured current scope-specific evidence and actual reviewer; documents are not universal licensing/compliance certification or portal access.
`AmendmentEvidence`	longtext	yes	Immutable previous/current line snapshots and applied version mapping, customer-project change dependencies and preserved fulfilled/accrued/billed/paid/retained sources.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager above-limit work, protected advance/retention/currency and financial exceptions.
`ClosedAt`	datetime		Actual reconciled scope/financial closure; retained/unpaid obligations cannot disappear.

SubcontractLinesApproved measured or fixed supplier work scope mapped to the project cost breakdown.line

Field	Type	Required	Details
`Subcontract`	reference	yes	→ Subcontracts. Parent agreement.
`LineNumber`	number	yes	Unique stable scope identity.
`CostCode`	reference	yes	→ CostCodes. Same project.
`Description`	longtext	yes	Actual work and acceptance deliverables.
`Basis`	select	yes	FixedMilestone, UnitRate
`Unit`	reference		→ UnitsOfMeasure. Required measured work unit for UnitRate; not a warehouse SKU.
`Quantity`	decimal	yes	Approved positive measured quantity, or1 for a defined fixed milestone.
`UnitPrice`	decimal	yes	Known agreement-currency net price per accepted unit.
`NetAmount`	decimal	yes	Approved quantity/rate net with deterministic rounding.
`AcceptedQuantity`	decimal	yes	Cumulative net actual accepted work after exact corrections, not supplier applications or bills.
`AcceptedAmount`	decimal	yes	Cumulative approved accepted work value in agreement currency.
`CancelledAmount`	decimal	yes	Approved unperformed release only.
`Status`	select	yes	Draft, Approved, Active, PartiallyAccepted, Accepted, Held, Cancelled, Closed
`ScopeEvidence`	longtext	yes	Measurement/stored-material eligibility if contractually selected, milestones, cumulative caps and original current revision; outside approved scope remains pending change.

SubcontractApplicationsSupplier cumulative work/payment request, separate from local actual acceptance and AP.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`ApplicationNumber`	text	yes	Unique supplier/application/revision identity.
`Subcontract`	reference	yes	→ Subcontracts. Same project/entity supplier agreement.
`PeriodFrom`	date	yes	Claim interval start.
`PeriodTo`	date	yes	Claim interval end.
`SubmittedAt`	datetime	yes	Actual supplier submission.
`Status`	select	yes	Received, UnderReview, AcceptedPartially, Accepted, Disputed, Superseded, Rejected
`Evidence`	longtext	yes	Actual supplier claimed work, prior application/revision and support; a request does not create job cost, accrual, AP or cash.
`Replaces`	reference		→ SubcontractApplications. Corrected packet retains one cumulative source family.

SubcontractApplicationLinesSupplier cumulative claimed units/value distinguished from incremental accepted work.line

Field	Type	Required	Details
`Application`	reference	yes	→ SubcontractApplications. Parent request.
`LineNumber`	number	yes	Unique request line.
`SubcontractLine`	reference	yes	→ SubcontractLines. Approved original work scope.
`ClaimedCumulativeQuantity`	decimal	yes	Nonnegative claimed total including previous work; not a new additive transaction.
`ClaimedCumulativeValue`	decimal	yes	Claimed net in subcontract currency.
`PreviouslyAcceptedQuantity`	decimal	yes	Frozen actual prior accepted source population at review cutoff.
`PreviouslyAcceptedValue`	decimal	yes	Frozen actual prior accepted value, not previously paid cash.
`Evidence`	longtext	yes	Exact measured work and revision/source history, unresolved difference held.
`Status`	select	yes	Claimed, UnderReview, AcceptedPartially, Accepted, Disputed, Rejected

SubcontractAcceptancesIndependent actual-work decision and known-cost posting packet, separate from supplier billing.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`AcceptanceNumber`	text	yes	Unique actual accepted tranche.
`Subcontract`	reference	yes	→ Subcontracts. Approved agreement.
`Application`	reference		→ SubcontractApplications. Actual request/evidence if received; independent acceptance can precede supplier billing.
`OccurredAt`	datetime	yes	Actual accepted supply/work date.
`RecordedBy`	reference	yes	→ Users. Site Supervisor actual observer/recorder with supplier evidence.
`Status`	select	yes	Prepared, Submitted, Accepted, PendingValuation, Posted, Rejected, Reversed
`AcceptedBy`	reference		→ Users. Independent Project Manager technical work acceptance, excluding recorder, supplier performer and commercial preparer/material editors.
`AcceptedAt`	datetime		Actual approval/acceptance time.
`Evidence`	longtext	yes	Actual measured scope and inspection/work evidence; no fabricated stock receipt for labor. Unknown value remains PendingValuation and cannot post zero.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager actual value/variance/retention/advance exceptions before posting.
`Journal`	reference		→ JournalEntries. One Dr project expense / Cr subcontract accrual effect for posted known accepted net; lines create exact accrual and cost source, not another journal each.
`ReversalOf`	reference		→ SubcontractAcceptances. Bounded original source and downstream match/payment/retention reconciliation.

SubcontractAcceptanceLinesIncremental accepted work claims against previously approved cumulative supplier scope.line

Field	Type	Required	Details
`Acceptance`	reference	yes	→ SubcontractAcceptances. Parent actual decision.
`LineNumber`	number	yes	Unique tranche line.
`SubcontractLine`	reference	yes	→ SubcontractLines. Approved remaining original work.
`ApplicationLine`	reference		→ SubcontractApplicationLines. Claimed cumulative source where present.
`Quantity`	decimal	yes	Positive incremental accepted quantity, never the full cumulative quantity again.
`NetAmount`	decimal		Known accepted incremental agreement-currency value; null if unresolved before valuation, finite mandatory at posting.
`FunctionalAmount`	decimal		Exact accepted expense/accrual amount at reviewed effective rate.
`Rate`	reference		→ ExchangeRates. Required if agreement differs from functional currency.
`Status`	select	yes	Prepared, Accepted, PendingValuation, Posted, Reversed
`Accrual`	reference		→ SubcontractAccruals. Required for positive posted known accepted value. Explicitly known-zero accepted work has valid quantity/evidence with no fictitious liability or zero-value journal; unknown value remains PendingValuation.
`CostEntry`	reference		→ ProjectCostEntries. One nonzero source expense mirror; known-zero work retains accepted quantity/rate evidence without a fabricated cost entry/journal.
`Commitment`	reference		→ ProjectCommitments. Exact approved source allocation whose fulfilled work increases; invoice/payment does not fulfill it again.

SubcontractAccrualsRecognized accepted-work liability remaining to be converted to AP, with current carrying.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`AccrualNumber`	text	yes	Unique accepted-work/source-line identity.
`AcceptanceLine`	reference	yes	→ SubcontractAcceptanceLines. Posted known independent work acceptance, never a supplier invoice substitute.
`Subcontract`	reference	yes	→ Subcontracts. Same supplier/entity agreement.
`Currency`	reference	yes	→ Currencies. Original accepted-work currency.
`OriginalAmount`	decimal	yes	Positive accepted incremental net amount once.
`RemainingAmount`	decimal	yes	Original plus exact corrections minus posted bill matches; no negative remainder.
`ReservedAmount`	decimal	yes	Active matching/correction claims against current remaining amount; posted history already excluded.
`CurrentCarrying`	decimal	yes	Nonnegative current functional liability including approved revaluation; zero remaining amount requires zero carrying.
`UnrealizedFX`	decimal	yes	Signed prior unrealized FX on remaining monetary accrual only.
`RecognizedAt`	datetime		Actual native acceptance posting time; required for native Open/PartiallyMatched/Matched. Opening may retain evidenced historical time or null with reviewed cutover cutoff, never fabricated history.
`Status`	select	yes	Open, PartiallyMatched, Matched, Held, Reversed, Opening
`Journal`	reference		→ JournalEntries. Same acceptance expense/accrual journal, not a second posting.
`Baseline`	reference		→ MigrationItems. Nonposting remaining source reconciled to full opening GL.

ProgressApplicationsCustomer progress request with internal commercial approval, separate from external certification.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`ApplicationNumber`	text	yes	Unique contract/period/request revision.
`Contract`	reference	yes	→ ProjectContracts. Accepted customer contract.
`PeriodFrom`	date	yes	Application interval start.
`PeriodTo`	date	yes	Application cutoff, not cash date.
`Status`	select	yes	Draft, Submitted, Approved, Sent, PartiallyCertified, Certified, Disputed, Superseded, Rejected
`PreparedBy`	reference	yes	→ Users. Project Manager or Site Supervisor assembling actual evidence.
`TechnicalDecision`	reference		→ ApprovalDecisions. Independent Project Manager measured quantity/stored work basis excluding preparer/material editors.
`CommercialDecision`	reference		→ ApprovalDecisions. Independent Commercial Manager exact application/accepted changes before sending.
`SentAt`	datetime		Actual successful transmission/manual delivery, not internal request time.
`Replaces`	reference		→ ProgressApplications. Corrected cumulative packet; same original scope cannot be claimed twice.
`Evidence`	longtext	yes	Actual completed/stored work, customer terms and prior applications/certifications with source identity; no revenue or invoice posting merely from requesting progress.

ProgressApplicationLinesCumulative completed and eligible stored values within one accepted contract line.line

Field	Type	Required	Details
`Application`	reference	yes	→ ProgressApplications. Parent request.
`LineNumber`	number	yes	Unique line.
`OrderLine`	reference	yes	→ SalesOrderLines. Accepted Goods/ProjectWork scope belonging to the contract.
`CostCode`	reference		→ CostCodes. Work breakdown evidence, not the price authority.
`CompletedQuantity`	decimal	yes	Cumulative completed accepted-basis quantity; unit-rate work uses exact contractual unit.
`CompletedValue`	decimal	yes	Cumulative claimed completed value within accepted scope.
`StoredQuantity`	decimal	yes	Eligible currently stored uninstalled quantity, with exact nonoverlapping identity/evidence; not implied owned inventory.
`StoredValue`	decimal	yes	Contractually eligible stored value, never adds again after the same material moves into CompletedValue.
`TransferredStoredValue`	decimal	yes	Current-period stored-to-completed reclassification included in those cumulative components; adds no new total entitlement.
`CumulativeValue`	decimal	yes	CompletedValue plus StoredValue after exact overlap corrections, at most approved scope.
`PreviousCertifiedValue`	decimal	yes	Actual prior net certified population, not prior customer cash.
`Evidence`	longtext	yes	Exact measured units/milestone/source/stored identity and original price/discount/retention/tax basis; cumulative changes preserve prior certification/billing claims.
`Status`	select	yes	Draft, Submitted, CertifiedPartially, Certified, Disputed, Superseded

ProgressCertificatesActual external customer/authorized certifier determination with independent local verification.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`CertificateNumber`	text	yes	Unique actual external certificate/source revision.
`Application`	reference	yes	→ ProgressApplications. Exact requested packet; external certified result can differ.
`Contract`	reference	yes	→ ProjectContracts. Owning accepted contract.
`IssuedAt`	datetime	yes	Actual external issue time.
`ReceivedAt`	datetime	yes	Actual local receipt time, separate from external occurrence.
`ExternalCertifier`	text	yes	Actual authorized customer/surveyor/other agreed party identity and capacity, not an invented local role.
`Status`	select	yes	Received, PendingVerification, Verified, Disputed, Superseded, Reversed
`Artifact`	attachment	yes	Actual immutable certification content/hash; no licensed form assumed or fabricated approval.
`VerifiedBy`	reference		→ Users. Independent Project Manager verifies provenance, authorized external capacity and exact scope, excluding local preparer/material editors.
`VerifiedAt`	datetime		Actual successful local evidence check.
`Replaces`	reference		→ ProgressCertificates. Explicit corrected certificate; prior billed/recognized/retained claims must reconcile before changing financial eligibility.
`Evidence`	longtext	yes	Actual authority/terms/prior-cumulative certification and exceptions; verification does not itself recognize revenue or approve an invoice.

ProgressCertificateLinesVerified cumulative certified work with conserved increment and prior-source history.line

Field	Type	Required	Details
`Certificate`	reference	yes	→ ProgressCertificates. Parent actual external determination.
`ApplicationLine`	reference	yes	→ ProgressApplicationLines. Exact requested accepted commercial scope.
`LineNumber`	number	yes	Unique certified line.
`CertifiedCompletedQuantity`	decimal	yes	Actual externally certified cumulative completed quantity.
`CertifiedCompletedValue`	decimal	yes	Actual certified cumulative completed net value.
`CertifiedStoredValue`	decimal	yes	Actual eligible stored value disjoint from completed scope; later installation reclassifies instead of adding again.
`CertifiedCumulativeNet`	decimal	yes	Completed plus stored net, not beyond approved current scope absent approved change.
`PriorCertifiedNet`	decimal	yes	Previous effective certificate total for this source family; corrections preserve all dependent claims.
`IncrementNet`	decimal	yes	Signed difference versus prior certified total, not the entire cumulative amount again; negative changes require reviewed dependency correction.
`RetentionBasis`	longtext	yes	Configured contractual rate/cap/base, cumulative prior withheld/released values and classification; no default percentage or automatic statutory timing.
`Status`	select	yes	Unverified, Verified, Held, Superseded, Reversed

BillingObligationsOne accepted commercial billing cap, separate from recognition, retention maturity and cash.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`ObligationNumber`	text	yes	Unique contract/order-line billing identity.
`Contract`	reference	yes	→ ProjectContracts. Owning contract.
`OrderLine`	reference	yes	→ SalesOrderLines. Exact accepted line; no duplicate cap in a second project or split.
`Mode`	select	yes	GoodsShipment, FixedMilestone, MeasuredProgress, UnitRate
`Currency`	reference	yes	→ Currencies. Accepted contract currency.
`AuthorizedNet`	decimal	yes	Current accepted total net after approved changes, preserving already billed scope.
`EligibleCumulativeNet`	decimal	yes	Actual entitled cumulative amount from verified shipment/certificate/milestone evidence; not revenue progress or cash.
`BilledNet`	decimal	yes	Net commercial positive billing consumed including advance billing and conditional-retention portions; credit alone does not reopen entitlement without explicit restoration decision.
`ReservedNet`	decimal	yes	Active draft billing claims; new claims bounded by eligible remaining after prior billed/other reserved, except explicitly authorized advance allowance.
`AdvanceBillingCap`	decimal	yes	Configured finite upfront billing allowance within AuthorizedNet; future progress/final billing offsets those prior billed amounts regardless of cash paid.
`Status`	select	yes	Draft, Active, Held, FullyBilled, Cancelled, Closed
`Basis`	longtext	yes	Exact terms/changes, milestone or unit evidence, prior billed source IDs and rounding, advances and retention; ordinary retained-goods scope needs actual Handover title evidence.
`ActivatedAt`	datetime		Actual accepted commercial basis activation after order gate.

BillingAllocationsAtomic newly billed source slices and exact financial classification, preserving prior billed offsets.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`AllocationNumber`	text	yes	Unique original source/action/invoice-line claim.
`Obligation`	reference	yes	→ BillingObligations. One accepted commercial cap.
`InvoiceLine`	reference	yes	→ InvoiceLines. Exact target debit/credit line.
`Kind`	select	yes	Goods, Progress, Milestone, Advance, Final, CreditCorrection
`ShipmentLine`	reference		→ ShipmentLines. Required Goods source with actual eligible title transfer; not fabricated for project work.
`CertificateLine`	reference		→ ProgressCertificateLines. Required where agreed progress/unit-rate evidence is certification; exact verified cumulative source.
`GrossReconciledNet`	decimal	yes	Full eligible source scope being reconciled before previous billing offsets.
`PriorBilledNet`	decimal	yes	Exact prior issued billing offsets, independent of payment status; links in Basis.
`NetAmount`	decimal	yes	New net commercial billing amount = eligible GrossReconciledNet minus PriorBilledNet for a cumulative/final claim; positive unless exact approved credit correction. Each original discount applied once.
`ConditionalRetentionNet`	decimal	yes	Nonnegative portion of this new commercial billing whose payment right is still conditional; not unconditional AR or a second contract asset.
`UnconditionalRetentionNet`	decimal	yes	Nonnegative unconditional but contractually held portion; remains in gross AR, separately unavailable until release.
`CurrentDueNet`	decimal	yes	NetAmount less both retention portions; advance cash application is a separate settlement, not another reduction of billed net.
`TaxBasis`	longtext	yes	Exact configured tax basis/timing, currently assessed tax versus deferred/conditional tax, rate/evidence/prior offsets; tax is never inferred from retention percent.
`Status`	select	yes	Reserved, Approved, Posted, Released, Reversed
`Basis`	longtext	yes	Source currency/unit/net/retention/tax and exact prior billing IDs; current plus conditional plus unconditional retained portions reconcile NetAmount. Material stored-to-installed reclassification does not create another new billable slice.
`PostedAt`	datetime		Local financial effect time, separate from customer acknowledgment.
`ReversalOf`	reference		→ BillingAllocations. Exact original slice; restoration requires explicit authority and no surviving downstream claim conflict.

RevenueAssessmentsIndependent cumulative performance review owning revenue recognition separately from billing and cash.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`AssessmentNumber`	text	yes	Unique accounting-contract/cutoff/revision evaluation.
`Contract`	reference	yes	→ ProjectContracts. Reviewed accounting unit root; included contracts must share approved unit/entity/currency, never arbitrary portfolio netting.
`CutoffAt`	datetime	yes	Actual performance evidence cutoff.
`Period`	reference	yes	→ AccountingPeriods. Same-entity eligible recognition period.
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, Rejected, Reversed
`PreparedBy`	reference	yes	→ Users. Accountant prepares evaluated schedule from actual Project Manager performance evidence.
`Evidence`	longtext	yes	Exact obligations/allocated prices, measured outputs or point-in-time satisfaction, cumulative prior recognized scope and current/current-carrying journals; certification/invoice/cash is not automatically performance.
`TechnicalReview`	reference		→ ApprovalDecisions. Independent Project Manager validates actual performance evidence, excluding original performer/recorder/material preparer where relevant.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager method, cumulative recognized amounts, price changes, asset/liability grouping and currency basis before posting.
`PostedAt`	datetime		Actual atomic recognition/reclassification effect.
`Journal`	reference		→ JournalEntries. One balanced unit-level recognition journal with obligation detail, no per-obligation gross asset/liability presentation by default.
`ReversalOf`	reference		→ RevenueAssessments. Approved exact prior assessment correction and dependent billing/retention evidence retained.

RevenueAssessmentLinesPerformance-obligation detail with explicit cumulative recognized revenue and signed incremental adjustment.line

Field	Type	Required	Details
`Assessment`	reference	yes	→ RevenueAssessments. Parent approved schedule.
`Obligation`	reference	yes	→ PerformanceObligations. Reviewed allocated transaction price and method.
`LineNumber`	number	yes	Unique obligation line per assessment.
`AllocatedPrice`	decimal	yes	Exact current approved allocation in contract currency, not unaccepted variation.
`SatisfiedMeasure`	decimal	yes	Known actual cumulative output/units/milestone measure; cannot be cost/budget percentage by inference.
`TotalMeasure`	decimal	yes	Positive complete output denominator, or1 for explicitly defined point-in-time unit; unknown measurement blocks approval.
`CumulativeRecognizedNet`	decimal	yes	Approved eligible cumulative price times supported output fraction, or actual satisfied point-in-time allocated scope; capped by approved consideration unless separately authorized corrected allocation.
`PriorRecognizedNet`	decimal	yes	Exact cumulative net posted recognition before this assessment, including corrections/opening history.
`DeltaNet`	decimal	yes	Signed CumulativeRecognizedNet minus PriorRecognizedNet; repeated same assessment cannot recognize again.
`FunctionalDelta`	decimal	yes	Signed revenue functional amount on the reviewed recognition/historical advance/current source basis; explicit currency components retained, not a second FX gain.
`Evidence`	longtext	yes	Actual output/satisfaction/source identities, allocation/rate basis and explanation independent of certificates or cost incurred; zero delta needs no fictitious nonzero journal.
`Status`	select	yes	Draft, Approved, Posted, Reversed
`Movement`	reference		→ ContractBalanceMovements. One unit-level component group; obligation details feed aggregate net contract position before asset/liability posting.

ContractBalancesCurrent net asset/liability per reviewed accounting contract unit, with obligation detail kept separately.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`BalanceNumber`	text	yes	Unique entity/accounting-unit/currency identity.
`AccountingUnit`	reference	yes	→ ProjectContracts. Explicit reviewed root grouping; all member contracts/obligations share eligible entity/currency and approved contract-accounting basis.
`Currency`	reference	yes	→ Currencies. Accounting contract transaction currency.
`RecognizedNet`	decimal	yes	Cumulative approved net revenue across included obligations, including signed corrections and opening history.
`UnconditionalBilledNet`	decimal	yes	Cumulative net moved into unconditional receivables through invoices/releases less exact credits/reclassifications; conditional retained commercial billing is excluded until right becomes unconditional.
`UnbilledAdvanceNet`	decimal	yes	Remaining actual customer advance assigned to this unit but not yet applied to invoiced AR or refunded; advance invoices are already in UnconditionalBilledNet and cannot also populate this amount.
`PositionNet`	decimal	yes	RecognizedNet minus UnconditionalBilledNet minus UnbilledAdvanceNet, aggregated at this unit, never independently grossed by obligation.
`AssetAmount`	decimal	yes	Maximum PositionNet and zero.
`LiabilityAmount`	decimal	yes	Maximum negative PositionNet and zero; cannot be positive alongside AssetAmount for the same unit.
`AssetCarrying`	decimal	yes	Nonnegative current functional carrying of net contract asset; zero when no asset remains.
`LiabilityCarrying`	decimal	yes	Nonnegative current functional carrying of net contract liability, with reviewed monetary/nonmonetary/historical-advance classification; zero when none remains.
`AssetUnrealizedFX`	decimal	yes	Signed prior unrealized on monetary net asset only; no duplicate AR/conditional retention remeasurement.
`LiabilityUnrealizedFX`	decimal	yes	Signed prior unrealized only when reviewed classification is monetary; nonmonetary advance liability retains applicable historical basis.
`Classification`	longtext	yes	Finance Manager-approved accounting unit, asset/liability account and monetary/historical valuation, rate sources and disclosure. Obligation80 earned/0billed plus obligation0earned/100billed in the same eligible unit gives liability20, not gross asset80/liability100.
`Version`	number	yes	Monotonic atomic balance revision for aggregate recognition/billing/advance claims.
`Status`	select	yes	Open, Held, Reconciled, Closed, Opening
`AsOf`	datetime		Last effective event cutoff.
`Baseline`	reference		→ MigrationItems. Nonposting unit/obligation source detail reconciled to one opening ledger.

ContractBalanceMovementsOne typed financial delta with all claim owners and exact before/after contract-unit balances.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`MovementNumber`	text	yes	Unique unit/source/action/group identity.
`Balance`	reference	yes	→ ContractBalances. Single reviewed accounting unit and current version.
`Kind`	select	yes	Recognition, Invoice, AdvanceAssign, AdvanceApply, AdvanceRefund, AdvanceReleasePurpose, ConditionalRetentionRelease, RetentionReclass, Credit, Correction, Opening
`Obligation`	reference		→ PerformanceObligations. Detailed source allocation; the posting is still assessed at aggregate accounting unit.
`RevenueLine`	reference		→ RevenueAssessmentLines. Recognition source component.
`BillingAllocation`	reference		→ BillingAllocations. Invoice/credit source component.
`Advance`	reference		→ AdvanceAllocations. Exact customer advance assign/application/refund, never supplier advance.
`RetentionMovement`	reference		→ RetentionMovements. Exact conditional right release/reclassification.
`RecognizedDelta`	decimal	yes	Signed cumulative revenue change, nonzero only under approved recognition/correction.
`UnconditionalBilledDelta`	decimal	yes	Signed amount entering/leaving unconditional AR, independent of AR cash settlement.
`UnbilledAdvanceDelta`	decimal	yes	Signed actual assigned advance remaining change; applying to an invoice reduces this amount once, not both a second billing deduction and a second cash receipt.
`BeforeVersion`	number	yes	Exact aggregate version used by guarded posting.
`BeforeState`	longtext	yes	Original unit R/B/A, current asset/liability amount/carrying and source claim snapshots.
`AfterState`	longtext	yes	Reconciled aggregate R/B/A and net position after all grouped components; only one net contract asset/liability side, with obligation detail preserved.
`FunctionalComponents`	longtext	yes	Immutable typed component slices: source AdvanceAllocation/InvoiceLine/RevenueAssessmentLine key, currency amount, historic or current basis, before/after amount/carrying, and prior FX. Funded invoice plus Apply moves A basis into B basis unchanged and posts atomically; the original advance source reaching zero never destroys that basis. Unfunded invoice components use reviewed invoice-date basis. Revenue consumes exact surviving components with final remainder. No global net amount times one current rate; no catch-all FX plug. Monetary AR subsequently revalues separately from nonmonetary contract position.
`Status`	select	yes	Prepared, Reserved, Approved, Posted, Reversed, Opening
`OccurredAt`	datetime	yes	Actual source evidence date/time.
`PostedAt`	datetime		Atomic aggregate/source journal time.
`Journal`	reference		→ JournalEntries. Shared economic group journal; native nonzero effect required, zero-delta/no-value change may be evidenced without invented journal amounts.
`ReversalOf`	reference		→ ContractBalanceMovements. Exact compensating source/claim; dependency/current-balance checks required.

RetentionBalancesContractually held source consideration with explicit conditional right versus existing receivable/payable classification.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`RetentionNumber`	text	yes	Unique side/contract/source-line retained component.
`Side`	select	yes	Customer, Supplier
`Contract`	reference		→ ProjectContracts. Required Customer accounting/commercial contract.
`Subcontract`	reference		→ Subcontracts. Required Supplier source agreement, exclusive with Contract.
`InvoiceLine`	reference		→ InvoiceLines. Original customer billed/retained component; no new commercial billing cap at release.
`BillLine`	reference		→ BillLines. Original subcontract bill component under the selected bill-time retention split.
`BillingAllocation`	reference		→ BillingAllocations. Exact original customer commercial/retained source.
`CertificateLine`	reference		→ ProgressCertificateLines. Supporting actual customer entitlement, not automatic revenue.
`Accrual`	reference		→ SubcontractAccruals. Supplier accepted-work source; retention is initially part of gross accrual and later gross AP, not another liability.
`Currency`	reference	yes	→ Currencies. Original retained source currency.
`OriginalAmount`	decimal	yes	Positive original withheld net amount; zero retention requires no fictitious balance record.
`RemainingAmount`	decimal	yes	Total retained amount still outstanding: original plus approved corrections minus actual settlements/credits only. Ordinary release moves HeldAmount to ReleasedUnsettledAmount without reducing this total; reclassification to another owner uses one paired transfer, never a second deduction.
`HeldAmount`	decimal	yes	Current contractually unreleased portion, a subset of remaining outstanding source entitlement.
`ReleasedUnsettledAmount`	decimal	yes	Released/due but uncollected/unpaid portion; HeldAmount plus ReleasedUnsettledAmount equals RemainingAmount after corrections/settlements.
`ReservedAmount`	decimal	yes	Active release/credit/settlement claims by exact portion; release and payment stages preserve one source identity.
`Classification`	select	yes	ConditionalCustomerRight, UnconditionalCustomerHeld, SupplierAccruedHeld, SupplierPayableHeld, ReleasedDue, Settled
`RecognizedOwner`	longtext	yes	Conditional customer right is a tagged portion of the accounting-unit contract position only to the extent recognized; it never creates an extra gross asset against a net contract liability. Unconditional customer retention is inside original AR; supplier retention inside original accrual/AP. Revalue only that owning source, never this detail again.
`ValuationEvidence`	longtext	yes	Original/current source amount and carrying allocation, monetary/nonmonetary classification, prior FX and exact parent source; unknown or unrecognized conditional entitlement has no fabricated positive carrying.
`ReleaseTerms`	longtext	yes	Actual contractual rate/cap/base and conditions, supporting completion/certificate/defect evidence and assessed due date; no default statutory deadline.
`DueDate`	date		Known contractual due date when unconditional/released; null if still conditional without date.
`Status`	select	yes	Held, PartiallyReleased, Released, PartiallySettled, Settled, Disputed, Reversed, Opening
`WithheldAt`	datetime		Actual withholding classification time.
`Baseline`	reference		→ MigrationItems. Nonposting held/released/settled/carrying history, reconciled to parent financial source.

RetentionMovementsSource-preserving withholding, release, settlement and correction of retained consideration.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`MovementNumber`	text	yes	Unique retained-source action.
`Retention`	reference	yes	→ RetentionBalances. Original component and exact current classification.
`Kind`	select	yes	Withhold, ReleaseConditional, ReleaseDue, Settle, Credit, Correct, Opening
`Amount`	decimal	yes	Positive scoped original-currency amount except explicit signed correction, capped by eligible held/released outstanding source less active claims.
`Status`	select	yes	Prepared, PendingApproval, Reserved, Approved, Posted, Released, Reversed, Opening
`OccurredAt`	datetime	yes	Actual supporting event time, not internal draft date.
`Evidence`	longtext	yes	Exact conditional/unconditional status, external release facts and local Finance Manager approval; Project Manager technical completion may support but does not alone change a monetary right.
`ContractMovement`	reference		→ ContractBalanceMovements. Customer conditional release/reclassification: changes unconditional billed net/AR and existing contract position with no revenue/new commercial billing. No ContractMovement for purely due-date release of existing unconditional AR/AP.
`CashApplication`	reference		→ CashApplications. Actual customer settlement of now-eligible original AR source; shared event, not another receipt.
`PaymentAllocation`	reference		→ PaymentAllocations. Actual supplier settlement of existing gross AP, not another work cost.
`CreditApplication`	reference		→ CreditApplications. Exact original retained credit/offset allocation if used.
`Advance`	reference		→ AdvanceAllocations. Exact approved Apply action for this newly eligible retained source, reciprocal RetentionMovement and original InvoiceLine; shares release/application journal and historical/current basis without another commercial billing record or duplicate advance use.
`TaxEvidence`	longtext	yes	Frozen original tax basis, previously assessed versus conditionally deferred tax and actual release assessment; release never automatically charges the original tax twice.
`Journal`	reference		→ JournalEntries. Shared existing AR/AP/contract-position/tax/settlement source journal when required; ReleaseDue alone is maturity/availability evidence, not another revenue/expense.
`ReversalOf`	reference		→ RetentionMovements. Exact bounded source correction with downstream released/settled claims reconciled.

AdvanceAllocationsCustomer contract advance or supplier prepayment purpose and exact later use, preserving original cash history.finance

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`AdvanceNumber`	text	yes	Unique source assignment/application/refund identity.
`Side`	select	yes	Customer, Supplier
`Kind`	select	yes	Assign, Apply, Refund, ReleasePurpose, Correct, Opening
`Contract`	reference		→ ProjectContracts. Customer source accounting unit/commercial purpose.
`Subcontract`	reference		→ Subcontracts. Supplier prepayment purpose, exclusive with Contract.
`SourceAdvance`	reference		→ AdvanceAllocations. Original posted Assign source for Apply/Refund/ReleasePurpose; preserves one remaining balance and no duplicated cash.
`Receipt`	reference		→ CashReceipts. Required actual confirmed customer receipt for Customer Assign. An unpaid advance invoice creates B/unconditional AR and contract position, never a cash-funded Assign/spendable advance. Later cash either applies ordinarily to that invoice or is assigned as genuinely unbilled advance; the same scope cannot enter both B and A.
`SupplierPayment`	reference		→ Payments. Actually settled supplier prepayment for Assign; purpose allocation alone adds no liability or cash.
`Currency`	reference	yes	→ Currencies. Customer contract or supplier agreement denomination of the assigned source.
`Amount`	decimal	yes	Positive scoped amount in this Currency; source receipt/payment and target invoice/bill currencies remain separate.
`SourceAmount`	decimal		Exact receipt/payment-currency amount consumed on Assign or original-source portion attributed on later use; approved rates/final remainder retained.
`OriginalAssignedAmount`	decimal	yes	Positive original amount on Assign, otherwise0 with SourceAdvance required.
`RemainingAmount`	decimal	yes	On Assign/Opening only: original assigned amount minus net posted Apply, Refund and ReleasePurpose portions. On child actions zero: their Amount is a claim against SourceAdvance. Active Reserved claims reduce source availability, not posted history twice.
`ReservedAmount`	decimal	yes	On Assign/Opening only: current active use/refund/release claims against its remaining amount, including uncertain execution. Child action records hold zero here; each is counted once by status and Amount.
`Invoice`	reference		→ Invoices. Customer target original approved unconditional receivable for Apply; not a new billing entitlement.
`InvoiceAmount`	decimal		Exact invoice-currency amount settled by this advance use, independently capped by eligible outstanding AR/current due scope.
`Bill`	reference		→ Bills. Supplier target original approved gross payable for Apply.
`BillAmount`	decimal		Exact bill-currency AP amount consumed by supplier prepayment recovery.
`CreditApplication`	reference		→ CreditApplications. Supplier application delegates to this exact ordinary supplier-prepayment owner; both records share one journal/claim, never duplicate AP use.
`Refund`	reference		→ Refunds. Actual independently approved refund consumes this remaining source, not original receipt/prepayment twice.
`ContractMovement`	reference		→ ContractBalanceMovements. Customer Assign increases A; Apply, Refund and ReleasePurpose decrease A. ReleasePurpose restores original unapplied liability with no bank/AR effect and is blocked by applied or uncertain overlapping claims. Supplier assignment/release is purpose-only and never a contract movement.
`ValuationEvidence`	longtext	yes	Exact source/target currencies, source current/historical carrying, prior FX, retained advance basis and conversion. Assigned customer detail is part of the unit net contract position, not another standalone liability added to it.
`Status`	select	yes	Prepared, PendingApproval, Reserved, Posted, PartiallyUsed, Used, Held, Released, Reversed, Opening
`OccurredAt`	datetime	yes	Actual approved source event date.
`PostedAt`	datetime		Actual atomic financial/purpose allocation time.
`Journal`	reference		→ JournalEntries. Customer Assign Dr original unapplied / Cr contract position; Apply Dr contract position / Cr AR; ReleasePurpose Dr contract position / Cr original unapplied; Refund Dr contract position / Cr actual bank. All use exact source carrying/tax/FX basis. Supplier assignment/release is purpose-only; Apply delegates to original prepayment clearing once. Cash only moves at original receipt/payment or actual refund.
`ReversalOf`	reference		→ AdvanceAllocations. Original scope and downstream invoice/payment/retention claims traced before correction.
`Baseline`	reference		→ MigrationItems. Nonposting remaining assigned advance and original cash history reconciled to one opening GL.
`InvoiceLine`	reference		→ InvoiceLines. Customer Apply exact unconditional slice: initial funded billing uses reciprocal InvoiceLines.AdvanceApplication; later conditional-retention release uses RetentionMovements.Advance instead, preserving the original posted line and its initial pointer. No new BillingAllocation or commercial bill for release.
`BasisTransferred`	decimal		Exact source functional basis transferred into billed contract-position component on Customer Apply; finite known amount, historical for nonmonetary source. SourceAdvance remaining can reach zero while this basis survives on InvoiceLine/ContractBalanceMovement until performance/credit, not lost or revalued anew.
`RetentionMovement`	reference		→ RetentionMovements. Required for Customer Apply against newly unconditional original retained AR. Reciprocal Advance, original InvoiceLine and source ContractMovement must agree; separately approved release/application share exact historical/current basis and one atomic journal, while original line remains immutable.

ERP•AI workspace

Start now Construction ERP

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

Start now Download agent

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

Construction ERP

Modules

Construction ERP

Processes

Construction ERP

Industries

Construction ERP

Reference

Construction ERP

Data model

How the model is organised

Estimates & contracts

Projects & costs

Purchasing & subcontractors

Materials & sites

Production & prefabrication

Billing & collections

Finance

Reporting

Keys and references

Migration order

Tables

Start now Construction ERP

Construction ERP

Modules

Construction ERP

Processes

Construction ERP

Industries

Construction ERP

Reference

Data model

How the model is organised

Estimates & contracts

Projects & costs

Purchasing & subcontractors

Materials & sites

Production & prefabrication

Billing & collections

Finance

Reporting

Keys and references

Migration order

Tables

Start now Construction ERP

Your Privacy, Your Choice

Manage Your Cookie Preferences