Data model

Explore the records linking orders, stock, delivery and finance.

93 tables · 479 relationships

How the model is organised

Foundation and controls

Users, Entities, Currencies, ExchangeRates, AccountingPeriods, ChartOfAccounts, TaxCodes, PaymentTerms, DistributionPolicies, MasterChanges, DocumentRevisions, ApprovalDecisions, AuthorityDelegations, IntegrationEvents, IntegrationDeliveries, MigrationBatches, MigrationItems, CloseTasks. Establish entity, currency, period, tax, posting authority, reviewed changes and accountable external or migration actions.

Users
Entities
Currencies
ExchangeRates
AccountingPeriods
ChartOfAccounts
TaxCodes
PaymentTerms
DistributionPolicies
MasterChanges
DocumentRevisions
ApprovalDecisions
AuthorityDelegations
IntegrationEvents
IntegrationDeliveries
MigrationBatches
MigrationItems
CloseTasks

Parties and product masters

Dealers, DealerContacts, Suppliers, SupplierBankAccounts, Products, UnitsOfMeasure, ProductUnits, PriceLists, PriceListEntries, StandardCosts, PostingProfiles, Warehouses, Locations. Define dealer and supplier identities, permitted banking details, product units, accepted pricing and entity-specific stock standards and locations.

Sales & dealer orders

Quotes, QuoteLines, SalesOrders, SalesOrderLines, SalesAllocations, CreditReviews. Preserve offered and accepted line scope, quantities, amounts and the required credit decisions.

Quotes
QuoteLines
SalesOrders
SalesOrderLines
SalesAllocations
CreditReviews

Purchasing

Requisitions, RequisitionLines, PurchaseOrders, PurchaseOrderLines, GoodsReceipts, GoodsReceiptLines, ReceiptAcceptances, BillMatches. Connect approved requests and orders with immutable arrivals, separately accepted receipt quantities and eligible supplier-bill matches.

Requisitions
RequisitionLines
PurchaseOrders
PurchaseOrderLines
GoodsReceipts
GoodsReceiptLines
ReceiptAcceptances
BillMatches

Inventory & warehouses

InventoryPositions, StockLayers, StockEvents, StockMovements, InventoryReservations, StockTransfers, StockTransferLines, InventoryCounts, CountLines, CountLocks. Keep legal ownership, physical position, remaining cost layers, claims, movements and controlled count or transfer work connected.

InventoryPositions
StockLayers
StockEvents
StockMovements
InventoryReservations
StockTransfers
StockTransferLines
InventoryCounts
CountLines
CountLocks

Delivery planning

PickTasks, Shipments, ShipmentLines, DeliveryRoutes, RouteStops, DeliveryAttempts, DeliveryResults. Tie assigned picks and shipments to ordered route stops, actual attempts and bounded delivery results.

PickTasks
Shipments
ShipmentLines
DeliveryRoutes
RouteStops
DeliveryAttempts
DeliveryResults

Production & kitting

BOMs, BOMLines, ProductionRoutings, RoutingOperations, WorkOrders, WorkOrderMaterials, WorkOrderOperations, ProductionEntries, ProductionCompletions, WorkOrderCostEntries. Retain versioned material and operation requirements, actual execution, accepted output and separate work-in-progress cost contributions.

BOMs
BOMLines
ProductionRoutings
RoutingOperations
WorkOrders
WorkOrderMaterials
WorkOrderOperations
ProductionEntries
ProductionCompletions
WorkOrderCostEntries

Return corrections

Returns, ReturnLines, ReturnDispositions. Keep original quantity and value lineage through authorization, actual returned custody and reviewed disposition.

Returns
ReturnLines
ReturnDispositions

Finance

Invoices, InvoiceLines, Bills, BillLines, CashReceipts, CashApplications, PaymentRuns, Payments, PaymentAllocations, CreditApplications, Refunds, FinanceCorrections, BankAccounts, BankStatementLines, RevaluationRuns, RevaluationLines, JournalEntries, JournalLines. Record invoices, bills, cash, credits, settlement, corrections, revaluation and balanced entity journals with their exact source allocations.

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

Keys and references

Entity and source-document identity follow every accepted commercial line, stock event and financial posting. Product-unit and price snapshots preserve the basis used for the transaction. A shared location cannot turn stock belonging to one legal owner into another owner’s available quantity.

Reservations and fulfillment allocations consume bounded eligible scope. Picking does not create another sale; actual dispatch or accepted delivery issues stock according to the reviewed title terms. An invoice uses eligible quantities and amounts without issuing that stock again. Returns, credits and refunds trace their separate original physical, commercial and funding sources.

Standard stock and completed production value remain distinct from the applicable actual-cost variance. Production work in progress retains actual inputs and accepted output, and period close reconciles the remaining balances. Document currency, functional carrying value and cash settlement components cannot be substituted for one another.

Migration order

Establish identity and configuration
Ends with: Map entities, currencies, periods, accounts, parties, products, units, locations and approved policy versions before linking operational records.
Reconcile accepted open scope
Ends with: Import original commitments, remaining order or purchasing quantities, stock and cost layers, active reservations, delivery history and work in progress with their source identities.
Load financial controls once
Ends with: Reconcile opening entity journals with nonposting detailed open items and operational history. Past receipts, shipments, invoices or cash must not post again because their history was imported.
Verify the cutoff and enable new work
Ends with: Retain unresolved provider action identities, review the totals and obtain the required independent activation. Only eligible new actions after the agreed cutoff create new operating effects.

Tables

Find a table 93 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 eight declared roles; services can prepare or execute guarded approved work, never decide.
`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.

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		→ DistributionPolicies. 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, 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.

DistributionPoliciesVersioned 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	Named action-to-role routes, limits, entity/warehouse scope, tolerances, price precedence, count locks, due dates, delivery and cost policies; no unspecified auto approval.
`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	Dispatch, Delivery
`PreparedBy`	reference	yes	→ Users. Admin prepares technical policy; Warehouse Manager operational and Finance Manager finance domain owners provide independent decisions.
`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.

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 domain owner, excluding preparer/editor; finance for bank/cost/price/tax/accounts, WM for technical BOM/routing/warehouse, SM for dealer commercial scope. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`AppliedAt`	datetime		Guarded application; changes do not rewrite accepted or posted source snapshots.
`OperationalDecision`	reference		→ ApprovalDecisions. Required independent Warehouse Manager technical review where operational scope changes.
`FinanceDecision`	reference		→ ApprovalDecisions. Required independent Finance Manager for costs/limits/beneficiary/tax/posting/price-floor changes.
`CommercialDecision`	reference		→ ApprovalDecisions. Required independent Sales Manager for dealer/price commercial 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, OrderAcceptance, CreditException, PurchaseApproval, InvoiceApproval, BillException, PaymentRelease, Refund, FinanceCorrection, StockRelease, TransferApproval, CountAdjustment, ReturnAuthorization, ReturnDisposition, RouteRelease, ProductionRelease, ProductionClose, 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 target/source revision, entity, quantity/value, currency, expiry, action and excluded preparer/editor/subject identities.
`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	Sales 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 evidence for stock/WIP. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`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.

DealersEntity-scoped trade customers, including dealer terms, holds and billing identity.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`DealerCode`	text	yes	Unique trading account, not an application user.
`LegalName`	text	yes	Bill-to legal customer identity.
`Status`	select	yes	Prospect, Active, OnHold, Closed
`BillingAddress`	longtext	yes	Verified billing identity.
`DefaultTerms`	reference	yes	→ PaymentTerms. Accepted transaction freezes a version.
`PriceList`	reference		→ PriceLists. Default dealer price list; explicit precedence.
`CreditCurrency`	reference	yes	→ Currencies. Currency of credit limit.
`CreditLimit`	decimal	yes	Finite nonnegative approved limit; zero means no credit exposure unless explicit exception.
`TaxEvidence`	longtext		Exemption/resale documentation and review scope; not automatic compliance proof.
`Activation`	reference		→ MasterChanges. Independent Sales Manager commercial and Finance Manager credit/tax approval as applicable.
`RelatedEntity`	reference		→ Entities. Explicit intercompany trading counterparty; still separate legal documents, no automatic elimination.

DealerContactsContacts and delivery sites belong to the dealer and are separate from authentication.master

Field	Type	Required	Details
`Dealer`	reference	yes	→ Dealers. 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

ProductsTrade goods and assembly outputs; master values do not rewrite transactions.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, Kit, Repacked, NonstockCharge
`Activation`	reference		→ MasterChanges. Independent Warehouse Manager technical and Finance Manager financial setup review.

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 dealer 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 Sales 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 confirmation with Warehouse Manager technical evidence. Absent until the real action; mandatory before the corresponding active/approved/posted state.

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.

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 dealer 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.
`Dealer`	reference	yes	→ Dealers. 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. Sales Representative.
`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		Dealer acceptance of exact offer revision; not substituted for independent order gate.
`Decision`	reference		→ ApprovalDecisions. Required commercial price/margin exception decision by independent Sales Manager; routine within-policy quote sending is Sales Representative 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	yes	→ ProductUnits. Frozen conversion basis.
`Quantity`	decimal	yes	Positive quoted transaction units.
`BaseQuantity`	decimal	yes	Quantity × frozen conversion factor.
`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. Entity cost basis; absent/unknown cost routes margin review, never zero.
`MarginPercent`	decimal		100 × (NetAmount − converted extended cost) / NetAmount; null for zero net/unknown basis.

SalesOrdersDealer-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. Current valid independent decision for this revision, amount, entity and action.
`OrderNumber`	text	yes	Unique entity order.
`Dealer`	reference	yes	→ Dealers. 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. Sales Representative preparing order.
`Terms`	reference	yes	→ PaymentTerms. Frozen accepted terms.
`ShipTo`	longtext	yes	Frozen delivery address/contact; change is material.
`TitleRule`	select	yes	Dispatch, Delivery
`NetTotal`	decimal	yes	Sum accepted SalesOrderLines.NetAmount.
`TaxTotal`	decimal	yes	Sum line tax once.
`CreditReview`	reference	yes	→ CreditReviews. Current entity/dealer exposure snapshot and valid exception if needed.
`AcceptedAt`	datetime		Independent Sales Manager approval time bound to exact dealer acceptance, prices, address, title rule and quantities.

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	yes	→ ProductUnits. Frozen unit and factor.
`Quantity`	decimal	yes	Accepted quantity in transaction units.
`BaseQuantity`	decimal	yes	Accepted base quantity.
`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. Planned source, not a second demand.
`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

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. One billing claim or correction.
`Kind`	select	yes	Shipment, Billing, Cancellation, Correction
`Status`	select	yes	Reserved, Posted, Released, Reversed
`BaseQuantity`	decimal	yes	Positive allocated base quantity, never beyond eligible remaining source.
`NetAmount`	decimal	yes	Order-currency accepted net allocated once, zero only for nonbilling quantity claim.
`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.

CreditReviewsAtomic dealer 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.
`Dealer`	reference	yes	→ Dealers. 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. Dealer 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; Sales 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, 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.

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	yes	→ GoodsReceiptLines. Unused accepted supplier supply.
`Status`	select	yes	Reserved, Matched, Released, Reversed
`BaseQuantity`	decimal	yes	Positive scope bounded by net accepted unreturned/unmatched supply and bill quantity.
`ReceiptAccrualFunctional`	decimal	yes	Original GRNI amount allocated with final remainder.
`BillNetFunctional`	decimal	yes	Same-scope invoice net/capitalizable tax at bill rate.
`VarianceFunctional`	decimal	yes	BillNetFunctional − ReceiptAccrualFunctional; price/rate components documented, not another full inventory debit.
`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	yes	→ ReceiptAcceptances. Exact posted accepted tranche; ReceiptLine must be its parent. Reserved/posted matches bounded by this tranche's unreturned unmatched quantity.

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
`QuantityOnHand`	decimal	yes	Nonnegative current base quantity; only posted signed stock movements update it.
`CarryingValue`	decimal	yes	Nonnegative entity-functional carrying amount; sum remaining StockLayers once.
`ReservedQuantity`	decimal	yes	Active Soft/Hard/Picked reservations; owned transit remains committed to source demand.
`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

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

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, DispatchTransit, TitleIssue, TransferDispatch, TransferReceipt, MaterialIssue, MaterialReturn, ProductionOutput, Scrap, CustomerReturn, SupplierReturn, StatusChange, CountAdjustment, CostRevaluation, MigrationOpening, Correction
`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.

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.

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 demand: order line or work-order material or transfer line.
`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; physical picked/transit never auto-released by timer.
`Replaces`	reference		→ InventoryReservations. Soft→Hard conversion replaces rather than adds a second claim.

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	→ DistributionPolicies. 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	Entity/product/location/lot/custody, including new identity keys.
`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 Operator or WM from initial counter; not final independent approval of own work.
`StockEvent`	reference		→ StockEvents. One posted correction.

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.

ShipmentsActual dispatch and title/delivery state separated for partial deliveries.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 dealer order; routes combine shipments without losing ownership.
`Warehouse`	reference	yes	→ Warehouses. Actual dispatch site.
`Mode`	select	yes	OwnDelivery, ExternalCarrier
`Status`	select	yes	Planned, Picking, Ready, Dispatched, PartiallyDelivered, Delivered, Exception, Closed, Cancelled
`TitleRule`	select	yes	Dispatch, Delivery
`CarrierReference`	text		Configured external handoff reference; no carrier booking claim.
`DispatchedAt`	datetime		Actual physical handover/vehicle departure.
`DispatchEvidence`	longtext		Actual operator/handoff/source evidence; uncertain provider response alone is insufficient.
`ClosedAt`	datetime		All line quantities delivered/returned/lost/resolved with remaining ownership reconciled.

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	Actual dispatched quantity; history retained through returns.
`TitleTransferredQuantity`	decimal	yes	Posted TitleIssue quantity once at order title rule, bounded by actual dispatch/eligible delivery evidence.
`DeliveredQuantity`	decimal	yes	Net actual accepted customer receipt; refusal/failed attempt is not delivery.
`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. DispatchTransit or TitleIssue according to terms; multiple partial title events traced via StockMovements.

DeliveryRoutesManual route/stop sequence and assigned execution; no optimization or live tracking.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.
`RouteNumber`	text	yes	Unique route/day plan.
`Warehouse`	reference	yes	→ Warehouses. Origin operating site.
`Status`	select	yes	Draft, PendingApproval, Released, InProgress, Exception, Completed, Closed, Cancelled
`Coordinator`	reference	yes	→ Users. Warehouse Manager responsible for dispatch and exceptions.
`AssignedOperator`	reference	yes	→ Users. Warehouse Operator recording actual work; external driver/contact is evidence, not a new application role.
`TransportReference`	text	yes	Internal vehicle/crew or configured carrier reference, no fleet maintenance feature.
`PlannedStart`	datetime	yes	Dispatch plan.
`PlannedEnd`	datetime	yes	Return/completion plan.
`ReleasedAt`	datetime		Independent WM release of feasible sequence/capacity and assigned approved shipments.
`ClosedAt`	datetime		Only with complete delivery/result and returned/retained-transit reconciliation.

RouteStopsExplicit stable sequence and exact order/shipment ownership.line

Field	Type	Required	Details
`Route`	reference	yes	→ DeliveryRoutes. One released route revision.
`Sequence`	number	yes	Positive unique sequence in route, manually chosen.
`Shipment`	reference	yes	→ Shipments. Exact shipment; active released stop assignment unique for remaining scope.
`AddressSnapshot`	longtext	yes	Frozen accepted destination; changes require reviewed replan.
`PlannedStart`	datetime	yes	Agreed stop window.
`PlannedEnd`	datetime	yes	Window end.
`Status`	select	yes	Planned, EnRoute, Partial, Delivered, Failed, Refused, Rescheduled, Resolved
`SuccessorStop`	reference		→ RouteStops. Reviewed remaining-scope reschedule; original attempt preserved, no duplicated shipment.

DeliveryAttemptsActual visit/handoff facts, separate from line outcomes and legal title.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.
`AttemptNumber`	text	yes	Unique provider/manual visit identity.
`Stop`	reference	yes	→ RouteStops. Released assignment.
`Status`	select	yes	Recorded, Verified, ReviewRequired, Corrected
`ArrivedAt`	datetime	yes	Actual visit time.
`CompletedAt`	datetime	yes	Actual attempt finish; not planned window.
`RecordedBy`	reference	yes	→ Users. Assigned Warehouse Operator or validated configured source; service cannot approve exceptions.
`Proof`	attachment		Protected delivery proof.
`Evidence`	longtext	yes	Recipient identity/signature/reference, damaged/refused/failed reasons; no fabricated signature.

DeliveryResultsEach attempt allocates line outcomes once; one visit may partially deliver many lines.line

Field	Type	Required	Details
`Attempt`	reference	yes	→ DeliveryAttempts. Verified visit.
`ShipmentLine`	reference	yes	→ ShipmentLines. Must belong to stop shipment.
`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	Sum four disjoint outcomes, bounded by this attempt's remaining assigned quantity.
`TitleEvent`	reference		→ StockEvents. Delivery-title accepted portion only; Dispatch-title creates no second issue.
`ReturnLine`	reference		→ ReturnLines. Refused/damaged actual return custody if applicable.
`CorrectionOf`	reference		→ DeliveryResults. Exact prior result; approvals and downstream billing/title effects reconciled before correction.

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 Warehouse Manager technical activation; Finance Manager confirms standard cost/rate changes separately. Absent until the real action; mandatory before the corresponding active/approved/posted state.

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 Warehouse Manager technical activation; cost-rate policy remains independently Finance Manager approved. Absent until the real action; mandatory before the corresponding active/approved/posted state.

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. Warehouse Manager.
`ReleasedAt`	datetime		Independent WM release with valid materials, technical basis and cost inputs.
`ClosedAt`	datetime		All input/output/scrap/WIP/cost obligations reconciled and necessary independent finance variance decision.

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	Actual cumulative gross material issues; unchanged by separately traced ReturnedQuantity. Net issued = IssuedQuantity − ReturnedQuantity; consumed plus physically remaining/scrapped scope must reconcile without subtracting returns twice.
`ReturnedQuantity`	decimal	yes	Actual traced unused material returned from production custody; never returns consumed quantity.
`ConsumedQuantity`	decimal	yes	Input quantity consumed into completed output or actual recorded scrap; not necessarily numerically equal to output units.
`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. Warehouse Operator.
`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. Warehouse Operator.
`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 unit.
`ScrapQuantity`	decimal	yes	Nonnegative actual rejected output-equivalent evidence; input scrap quantities separately traced.
`LabourHours`	decimal	yes	Accepted elapsed billable-to-WIP hours; declared attendance basis, not payroll.
`AcceptedBy`	reference		→ Users. Independent Warehouse Manager technical confirmation of actual scope; cannot accept own record.
`CorrectionOf`	reference		→ ProductionEntries. Prior entry and consumed costs/completions reconciled first.

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 component/labour/overhead carrying cost attributed by frozen cost-allocation basis; no unknown inputs or overconsumed pool.
`StandardOutputValue`	decimal	yes	OutputQuantity × frozen output standard, rounded once.
`Variance`	decimal	yes	AllocatedActualWIP − StandardOutputValue; positive adverse expense, negative favorable variance, once.
`CompletedAt`	datetime	yes	Actual completion evidence.
`ConfirmedBy`	reference	yes	→ Users. Independent Warehouse Manager from producing/recording operator.
`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.

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 cost amount already consumed in completion/scrap relief; reserved allocations reduce availability too.
`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 relief/scrap: exact positive cost-entry keys and amounts allocated, within same work order; sum equals relieved actual WIP and updates each source once. Reversal restores those claims once.

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
`Dealer`	reference		→ Dealers. 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 value for supplier return or pre-title owned-transit custody return; 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, Hold, Rework, Scrap, SendToSupplier, ReturnToDealer
`Status`	select	yes	Prepared, PendingApproval, Approved, Posted, Reversed
`BaseQuantity`	decimal	yes	Positive bounded actual quantity not already disposed.
`CarryingValue`	decimal	yes	Reviewed traced value: post-title customer restock restores original title-issue cost once; pre-title owned-transit return retains current carrying without COGS. A new-standard update is a separate event.
`Destination`	reference		→ Locations. Required for held/restocked/rework stock.
`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.
`Dealer`	reference	yes	→ Dealers. 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	Debit original less posted cash/credit/approved corrections and cutover baseline; credits use CreditRemaining separately.
`CurrentCarrying`	decimal	yes	Functional carrying value of current open debit/credit, including delta revaluation.
`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: Dr AR / Cr Revenue and tax; CreditNote: Dr reversal revenue/tax / Cr CustomerCredit, then applications/refunds separately.
`Baseline`	longtext	yes	Nonposting original/settled/credit and current carrying/FX amounts at migration; native zero.

InvoiceLinesExact unbilled title-transferred accepted price allocation or original credit 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 actual eligible title transfer, not planned dispatch or unverified POD.
`OriginalLine`	reference		→ InvoiceLines. Required credit source.
`ReturnLine`	reference		→ ReturnLines. Physical return basis when applicable; commercial-only credit explicitly reviewed.
`BaseQuantity`	decimal	yes	Positive scoped base quantity; financial-only price correction can use zero with explicit original value basis.
`NetAmount`	decimal	yes	Allocated accepted order net once, or bounded original credited net; no second discount deduction.
`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. Reserved then posted once with invoice.

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. Matched bill clears scoped GRNI plus approved variance/tax to AP; no second full inventory debit. Credit creates SupplierCredit asset with original reversal basis.
`Baseline`	longtext	yes	Nonposting source/open/carrying/settlement/FX balances at migration.

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.

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 bank control.
`Status`	select	yes	Draft, Active, Blocked, Closed
`ProtectedDetails`	longtext	yes	Accountant/Finance Manager only under current purpose; operator/sales exports excluded.
`BalanceQuantity`	decimal	yes	Actual posted bank-currency balance, reconciled to statement.
`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.

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.
`Dealer`	reference		→ Dealers. May initially be unidentified; must be attributed with evidence before application.
`BankAccount`	reference	yes	→ BankAccounts. Same entity and receipt currency.
`Status`	select	yes	Prepared, Posted, PartiallyApplied, Applied, Returned, Reversed
`ReceivedAt`	datetime	yes	Actual bank/cash receipt evidence time.
`Period`	reference	yes	→ AccountingPeriods. Eligible posting period.
`Amount`	decimal	yes	Positive receipt-currency amount.
`UnappliedAmount`	decimal	yes	Amount less posted receipt-currency applications/refunds/returns; active reservations separately reduce availability.
`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	Active application/refund claims in receipt currency; never invoice currency.
`StatementLine`	reference		→ BankStatementLines. Actual settlement evidence or reviewed manual cash proof in Event.
`Journal`	reference		→ JournalEntries. Dr Bank / Cr UnappliedCustomer once.
`Baseline`	longtext	yes	Opening receipt amount/applied/unapplied/carrying/FX and original source IDs, nonposting.

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. Identified same-entity/dealer receipt.
`Invoice`	reference	yes	→ Invoices. Posted debit invoice same dealer/entity.
`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 application/refund claims reduce availability; never send bank cash again to apply a settled 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 debit; null only explicit approved supplier 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 customer/entity debit target.
`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. Alternative unapplied-customer-cash funding source; XOR CreditInvoice, never both.
`CreditBill`	reference		→ Bills. Supplier-credit collection source for FromSupplier.
`Currency`	reference	yes	→ Currencies. Actual bank currency.
`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. Same entity account.
`Status`	select	yes	Draft, PendingApproval, Reserved, Released, Submitted, Uncertain, Settled, Rejected, Returned, Cancelled
`Instruction`	reference		→ IntegrationDeliveries. Transport intent only.
`SettlementEvent`	reference		→ IntegrationEvents. Authoritative actual cash outcome.
`SettledAt`	datetime		Actual posting time.
`Journal`	reference		→ JournalEntries. Funding control versus actual bank value/FX once; credit-funded refunds do not also reduce original cash applications.
`SupplierPrepayment`	reference		→ Payments. Alternative FromSupplier funding collection; XOR CreditBill.

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, 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	Original currency/value/allocations/FX/tax/cost affected, downstream constraints and once-only restoring claims.
`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.

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
`SourceKey`	text	yes	Exact open debit/credit/unapplied/bank source and kind.
`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, Stock, WIP, Cash, 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.

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	yes	→ Users. Independent Warehouse Operator, not PO buyer or commercial approver.
`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.

ERP•AI workspace

Start now Distribution ERP

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

Start now Download agent

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

Distribution ERP

Modules

Distribution ERP

Processes

Distribution ERP

Industries

Distribution ERP

Reference

Distribution ERP

Data model

How the model is organised

Foundation and controls

Parties and product masters

Sales & dealer orders

Purchasing

Inventory & warehouses

Delivery planning

Production & kitting

Return corrections

Finance

Keys and references

Migration order

Tables

Start now Distribution ERP

Distribution ERP

Modules

Distribution ERP

Processes

Distribution ERP

Industries

Distribution ERP

Reference

Data model

How the model is organised

Foundation and controls

Parties and product masters

Sales & dealer orders

Purchasing

Inventory & warehouses

Delivery planning

Production & kitting

Return corrections

Finance

Keys and references

Migration order

Tables

Start now Distribution ERP

Your Privacy, Your Choice

Manage Your Cookie Preferences