Data model

Explore the records connecting retail orders, stock and financial results.

118 tables · 695 relationships

How the model is organised

Sales & channels

Accounts, ContactPersons, Stores, Channels, PurchaseContexts, ChannelOrders, ChannelOrderLines, Quotes, QuoteLines, SalesOrders, SalesOrderLines, SalesAllocations, CreditReviews, PaymentTerms. Customer and purchase context, source orders, accepted offers, approved commitments and their quantity/value allocations.

Accounts
ContactPersons
Stores
Channels
PurchaseContexts
ChannelOrders
ChannelOrderLines
Quotes
QuoteLines
SalesOrders
SalesOrderLines
SalesAllocations
CreditReviews
PaymentTerms

Products & pricing

Products, UnitsOfMeasure, ProductUnits, ProductStyles, ProductVariants, ProductBarcodes, ChannelProducts, PriceLists, PriceListEntries. The canonical SKU, units, variants, barcodes and channel listing mappings, with reviewed selling prices.

Products
UnitsOfMeasure
ProductUnits
ProductStyles
ProductVariants
ProductBarcodes
ChannelProducts
PriceLists
PriceListEntries

Inventory & fulfillment

Warehouses, Locations, Lots, Serials, InventoryPositions, StockLayers, StockEvents, StockMovements, InventoryReservations, StockTransfers, StockTransferLines, CountLocks, InventoryCounts, CountLines, PickTasks, Fulfillments, FulfillmentLines, DeliveryConfirmations, Returns, ReturnLines, ReturnDispositions. Owned stock and cost layers, exact claims, store or pickup handover, shipments, transfers, counts and physical returns.

Warehouses
Locations
Lots
Serials
InventoryPositions
StockLayers
StockEvents
StockMovements
InventoryReservations
StockTransfers
StockTransferLines
CountLocks
InventoryCounts
CountLines
PickTasks
Fulfillments
FulfillmentLines
DeliveryConfirmations
Returns
ReturnLines
ReturnDispositions

Purchasing

Suppliers, SupplierBankAccounts, Requisitions, RequisitionLines, PurchaseOrders, PurchaseOrderLines, GoodsReceipts, GoodsReceiptLines, ReceiptAcceptances, BillMatches. Supplier identities, approved commitments, actual arrivals, separately accepted quantities and supplier-bill matching.

Suppliers
SupplierBankAccounts
Requisitions
RequisitionLines
PurchaseOrders
PurchaseOrderLines
GoodsReceipts
GoodsReceiptLines
ReceiptAcceptances
BillMatches

Production & kitting

BOMs, BOMLines, ProductionRoutings, RoutingOperations, WorkOrders, WorkOrderMaterials, WorkOrderOperations, ProductionEntries, ProductionCompletions, WorkOrderCostEntries. Versioned recipes and operations, released work, actual material and time, accepted terminal output and source WIP costs.

BOMs
BOMLines
ProductionRoutings
RoutingOperations
WorkOrders
WorkOrderMaterials
WorkOrderOperations
ProductionEntries
ProductionCompletions
WorkOrderCostEntries

Payments & refunds

PaymentAccounts, PaymentTransactions, PaymentEvents, ProcessorEntries, ProcessorAdjustments, ProcessorSettlements, ProcessorSettlementLines, CashReceipts, CashApplications, CreditApplications, Refunds, ExchangeLinks. Collection and processor identities, clearing entries and settlement, customer applications, credits, refunds and replacement links.

PaymentAccounts
PaymentTransactions
PaymentEvents
ProcessorEntries
ProcessorAdjustments
ProcessorSettlements
ProcessorSettlementLines
CashReceipts
CashApplications
CreditApplications
Refunds
ExchangeLinks

Finance

Entities, Currencies, ExchangeRates, AccountingPeriods, ChartOfAccounts, TaxCodes, StandardCosts, PostingProfiles, Invoices, InvoiceLines, Bills, BillLines, BankAccounts, BankStatementLines, PaymentRuns, Payments, PaymentAllocations, FinanceCorrections, RevaluationRuns, RevaluationLines, JournalEntries, JournalLines, CloseTasks. Entity books, costs, posting bases, invoices, bills, bank evidence, supplier payments, financial corrections and close.

AccountingPeriods
ChartOfAccounts
PaymentTerms
Accounts
SupplierBankAccounts
Invoices
InvoiceLines
BankAccounts
PaymentRuns
Payments
PaymentAllocations
JournalEntries
JournalLines
PaymentAccounts
PaymentTransactions
PaymentEvents
LoyaltyAccounts

Controls and connected work

Users, RetailPolicies, MasterChanges, DocumentRevisions, ApprovalDecisions, AuthorityDelegations, IntegrationEvents, IntegrationDeliveries, MigrationBatches, MigrationItems. Current user scope, policy, revisions, independent decisions, integration outcomes and migration identity.

Users
RetailPolicies
MasterChanges
DocumentRevisions
ApprovalDecisions
AuthorityDelegations
IntegrationEvents
IntegrationDeliveries
MigrationBatches
MigrationItems

Keys and references

Store and channel identity remains separate from the legal entity that owns goods, accepts the order and records its financial effects. Product variants, barcodes and external listings map to one canonical SKU and reviewed unit. They do not create additional stock balances. Applicable location, lot and serial identity follows actual goods and their claims.

Customer records, purchase-specific entitlement and operational user identities have different purposes. A reviewed walk-in counterparty does not pool unrelated purchases’ available credit. Receipt attribution, application and refund retain the appropriate transaction and recipient evidence, with current scope checked again when acting.

Accepted offers, approved orders, physical fulfillment, invoices and payment outcomes have separate source identities. Partial quantities and amounts consume the remaining eligible allocation. A later return preserves the original handover history; a replacement uses its own authorized commitment rather than reopening an already resolved shipment.

Gross collections, unapplied customer balances, processor clearing and actual bank settlement are distinct. Fees, refunds, reversals and corrections retain their exact source and currency. A bank payout cannot become another collection, and an externally actual debit remains visible even after the original receipt was applied. Moving previously collected cash to the bank transfers its existing value with reviewed custody and bank evidence; it does not create another customer receipt.

Production staging remains inventory until actual issue moves material and value into work in progress. Released recipes and cost bases follow the job; unused returns, consumed material, accepted output and cost relief retain bounded source quantities. Intermediate operation progress does not create finished stock.

Migration order

Establish identities and approved masters
Ends with: Map entities, stores, channels, users, customers, suppliers, canonical SKUs, units and listing references. Prepare approved accounts, currencies, prices, stock definitions, recipes and payment-account mappings before linking operating history.
Preserve current orders and physical work
Ends with: Import accepted commitments, source-order revisions, remaining supplier quantities, stock layers, reservations, assembly work, completed handovers and returns. Retain lot/serial identity and fulfilled scope without creating a fresh receipt, production completion or shipment.
Reconcile financial and payment details once
Ends with: Reconcile one opening ledger with nonposting invoices, bills, cash, credits, processor entries, fees, payouts and pending refunds. Preserve original/current carrying values, prior revaluation and uncertain outcomes. Opening details do not create another copy of earlier collections or settlement.
Verify the cutoff and activate the first scope
Ends with: Resolve typed links, compare source and control balances, and obtain the required operational and financial review. Keep external economic watermarks and existing reservations. Only eligible new work after the agreed cutoff can create new physical or financial effects.

Tables

Find a table 118 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 ten declared roles; service users prepare/execute only guarded approved scope and cannot sign human decisions.
`EntityScope`	longtext	yes	Explicit Entities keys; current scope checked on every read/action/export.
`WarehouseScope`	longtext		Explicit permitted Warehouses; absent does not mean global access.
`ExpiresAt`	datetime		Scope expiry.
`ScopeChange`	reference		→ MasterChanges. Independent domain-reviewed grant of roles/entities/warehouse scope; Admin cannot self-grant business authority. Revocation may restrict immediately.
`StoreScope`	longtext		Explicit Stores keys; checked with entity/warehouse scope, never implied by matching a channel label.
`ChannelScope`	longtext		Explicit Channels keys for source access/action/export; no unrestricted customer or payment visibility.

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		→ RetailPolicies. Approved active entity policy.

CurrenciesCurrency precision and display rules.master

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

ExchangeRatesImmutable dated conversion evidence; no hidden fallback.master

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

AccountingPeriodsEntity-specific fiscal periods and guarded close.master

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

ChartOfAccountsEntity ledger accounts, including controlled subledger accounts.master

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

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

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

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

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

RetailPoliciesVersioned operational and financial rules with explicit finite limits.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`PolicyNumber`	text	yes	Unique policy version.
`Status`	select	yes	Draft, PendingApproval, Active, Superseded
`EffectiveFrom`	datetime	yes	Inclusive activation boundary; no retroactive unreviewed change.
`EffectiveTo`	datetime		Exclusive.
`AuthorityCurrency`	reference	yes	→ Currencies. Currency of finite approval/credit/count limits.
`Rules`	longtext	yes	Validated action-to-role/User rules, finite entity/store/channel/warehouse limits, currencies/effectivity, accepted price/tax precedence, reservation/paid-hold expiry, walk-in entitlement, production/stock/cost, capture/refund/processor clearing and suspension rules. No implicit auto approval or provider installation.
`CountQuantityTolerance`	decimal	yes	Nonnegative base-quantity absolute threshold by configured unit/product class; dimensionally incompatible quantities are never summed.
`CountPercentTolerance`	decimal	yes	Nonnegative percentage; expected zero gives unavailable percentage and review.
`CountValueThreshold`	decimal	yes	Nonnegative functional-value escalation threshold; unknown value is not zero.
`ShipmentTitleRule`	select	yes	Handover. Verified actual store/pickup customer handover or carrier dispatch is the sole baseline title/COGS event; readiness/labels are not title.
`PreparedBy`	reference	yes	→ Users. Admin prepares configuration; Warehouse Manager operational, Production Manager recipe/execution, Sales Manager commercial and Finance Manager financial decisions are independent of preparer/material editors.
`OperationalDecision`	reference		→ ApprovalDecisions. Independent Warehouse Manager decision for operational rules. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager decision for finance/cost/authority rules. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`ProductionDecision`	reference		→ ApprovalDecisions. Independent Production Manager for assembly/kitting/repacking rules.
`PaymentPolicy`	longtext		Validated provider evidence requirements, finite fee mappings, suspense fallback, disputed source holds, settlement allocation and refund authority; Finance Manager approval required.
`CommercialDecision`	reference		→ ApprovalDecisions. Independent Sales Manager approval for pricing, source-order and purchase-context rules; required only before affected policy activation.

MasterChangesProtected master activation without direct Manage permission bypass.transaction

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

DocumentRevisionsImmutable typed document snapshots and source basis.transaction

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

ApprovalDecisionsAuthoritative human decisions independent of document lifecycle.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`DecisionNumber`	text	yes	Unique decision identity.
`Action`	select	yes	MasterActivation, PolicyActivation, QuoteException, OrderAcceptance, CreditException, PurchaseApproval, InvoiceApproval, BillException, PaymentRelease, Refund, FinanceCorrection, ProcessorSettlement, ProcessorClassification, ContextTransfer, StockRelease, TransferApproval, CountAdjustment, ReturnAuthorization, ReturnDisposition, FulfillmentRelease, ProductionRelease, ProductionTimeAcceptance, ProductionCompletion, ProductionVariance, ProductionClose, ProductionCloseFinance, JournalApproval, RevaluationApproval, PeriodClose, PeriodReopen, MigrationActivation
`Status`	select	yes	Pending, Approved, Rejected, Expired, Superseded
`Snapshot`	reference		→ DocumentRevisions. Required for revisioned transaction actions; master/policy request content hash otherwise retained in Scope.
`Scope`	longtext	yes	Exact source/action/revision, entity/store/channel/warehouse, quantity/value/currency, purchase entitlement, expiry and excluded preparer/editor/subject identities. A generic status or source-platform approval is not independent authority.
`RequestedBy`	reference	yes	→ Users. Actual preparer/requester.
`RequestedAt`	datetime	yes	Actual time.
`DecidedBy`	reference		→ Users. Actual independent human with declared required role, current scope and limit. Service/Admin privilege is not domain approval.
`DecidedAt`	datetime		Actual decision time.
`Delegation`	reference		→ AuthorityDelegations. Valid named delegate, preserving required role and actual-person independence.
`AuthorityRate`	reference		→ ExchangeRates. Exact currency conversion for limit test; no missing-rate fallback.
`AuthorityAmount`	decimal		Amount in delegated/role authority currency; cumulative relevant commitment and gross increases included.
`Reason`	longtext	yes	Decision rationale, rejected conditions and reviewed evidence.
`AssignedTo`	reference	yes	→ Users. Named eligible human reviewer when Pending; independence and current role/limit rechecked at decision.

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`DelegationNumber`	text	yes	Unique authority grant.
`Principal`	reference	yes	→ Users. Original authorized human.
`Delegate`	reference	yes	→ Users. Different actual human already holding required declared role.
`RequiredRole`	select	yes	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, Fulfillment, Delivery, BankSettlement, BankRejection, BankReturn, DocumentAcknowledgment, Migration, Other
`Status`	select	yes	Received, Verified, Applied, Ignored, ReviewRequired, Rejected
`PayloadHash`	text	yes	Conflict on reused key blocks effects.
`Payload`	longtext	yes	Protected evidence and expected source/version mapping.
`OccurredAt`	datetime	yes	Actual source event time.
`ReceivedAt`	datetime	yes	Received time.
`VerifiedBy`	reference		→ Users. Human reviewer or authenticated configured service; role-required decisions separate.
`AppliedAt`	datetime		Atomic local effect time.

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

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

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

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

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

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

CloseTasksCurrent source reconciliation evidence for an entity cutoff.transaction

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`AccountCode`	text	yes	Stable entity/customer identity. WalkIn is a reviewed accounting counterparty label, not an invented person or a global customer credit wallet.
`LegalName`	text	yes	Bill-to legal customer identity.
`Status`	select	yes	Prospect, Active, OnHold, Closed
`BillingAddress`	longtext		Verified billing identity.
`DefaultTerms`	reference		→ PaymentTerms. Accepted transaction freezes a version.
`PriceList`	reference		→ PriceLists. Default customer price list; explicit precedence.
`CreditCurrency`	reference		→ Currencies. Currency of credit limit.
`CreditLimit`	decimal		Finite nonnegative approved limit, required for credit trading; unknown is never unlimited. Walk-in funds/credits remain PurchaseContexts-scoped even under the same account.
`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.
`Kind`	select	yes	KnownCustomer, WalkIn
`Owner`	reference	yes	→ Users. Sales Associate responsible for source customer context, not authorization to pool unrelated walk-in funds.

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

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

SuppliersEntity purchasing counterparties with separately controlled beneficiary data.master

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

SupplierBankAccountsRestricted supplier payment destinations with independent finance confirmation.master

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

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

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

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

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

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

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`PriceListCode`	text	yes	Unique version.
`Currency`	reference	yes	→ Currencies. One price currency.
`StartsAt`	datetime	yes	Inclusive.
`EndsAt`	datetime		Exclusive.
`Priority`	number	yes	Explicit precedence; equal eligible candidates block selection.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent 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 activation with Production Manager or Purchasing Manager reviewed technical/commercial cost basis; no rewrite of released WIP or earlier output.

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

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

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

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

LocationsShallow warehouse bins, staging and transit custody locations.master

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

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

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

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.

SalesOrdersAccount-accepted scope plus mandatory independent commercial approval.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`OrderNumber`	text	yes	Unique entity order.
`Account`	reference	yes	→ Accounts. Same entity.
`Quote`	reference		→ Quotes. Accepted source revision; generated orders consume its remaining accepted scope once.
`Status`	select	yes	Draft, Submitted, OnHold, Approved, InProgress, PartiallyShipped, Shipped, Invoiced, Closed, Cancelled
`OrderDate`	date	yes	Commercial date.
`Owner`	reference	yes	→ Users. Sales Associate preparing order.
`Terms`	reference	yes	→ PaymentTerms. Frozen accepted terms.
`ShipTo`	longtext	yes	Frozen fulfillment location and actual entitled recipient/contact evidence. Carrier needs actual delivery address; StoreHandover/Pickup uses actual store and recipient verification, not a fabricated customer address.
`TitleRule`	select	yes	Handover. Actual verified direct store/pickup customer handover or carrier dispatch transfers title/stock and COGS once; no delivery-title variant in this baseline.
`NetTotal`	decimal	yes	Sum accepted SalesOrderLines.NetAmount.
`TaxTotal`	decimal	yes	Sum line tax once.
`CreditReview`	reference	yes	→ CreditReviews. Current entity/customer exposure snapshot and valid exception if needed.
`AcceptedAt`	datetime		Independent Sales Manager approval time bound to exact customer acceptance, prices, address, title rule and quantities.
`Context`	reference	yes	→ PurchaseContexts. One original purchase entitlement; independent sales approval cannot merge unrelated walk-in contexts.
`Channel`	reference	yes	→ Channels. Store or online intake source.
`ChannelOrder`	reference		→ ChannelOrders. Actual source order identity; unique conversion across repeated/reordered imports.
`FulfillmentMode`	select	yes	StoreHandover, Pickup, Carrier
`Store`	reference		→ Stores. Required for store handover/pickup; inventory uses the actual linked warehouse/location.

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
`ChannelOrderLine`	reference		→ ChannelOrderLines. Exact source accepted line when imported; consistent with any QuoteLine, not a second authorization of quantity/value.

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.
`FulfillmentLine`	reference		→ FulfillmentLines. Actual scoped fulfillment.
`InvoiceLine`	reference		→ InvoiceLines. One billing claim or correction.
`Kind`	select	yes	Fulfillment, 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 customer exposure review and separately bounded exception.transaction

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

RequisitionLinesRequested product quantities and source demand identity.line

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

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

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

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

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

GoodsReceiptsImmutable actual arrivals and separately accepted quantities.transaction

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

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

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`MatchNumber`	text	yes	Unique matching allocation.
`BillLine`	reference	yes	→ BillLines. Exact proposed/posted supplier invoice line.
`ReceiptLine`	reference	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. Production is staged but not yet financially issued inventory; actually issued material leaves these inventory positions into separately traced work-order WIP custody.
`QuantityOnHand`	decimal	yes	Nonnegative current base quantity; only posted signed stock movements update it.
`CarryingValue`	decimal	yes	Nonnegative entity-functional inventory carrying, sum remaining StockLayers once. Issued material value is in WorkOrderCostEntries/WIP, not another production-position balance.
`ReservedQuantity`	decimal	yes	Sum live Soft/Hard/Picked/InTransit claims on this exact position; physical picked/transit remains committed, no automatic timer release.
`AvailableQuantity`	decimal	yes	Eligible available quantity less active claims; held/picked/transit/production unavailable to another order.
`Version`	number	yes	Monotonic position version checked atomically.
`Status`	select	yes	Active, Empty, Blocked
`Lot`	reference		→ Lots. Exact same entity/product lot; required when lot-controlled. Legacy display LotNumber must agree, never independent identity.
`Serial`	reference		→ Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row.

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

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`StockEventNumber`	text	yes	Unique physical/economic action.
`Kind`	select	yes	ReceiptAcceptance, PutAway, Pick, Unpick, TitleIssue, TransferDispatch, TransferReceipt, MaterialIssue, MaterialReturn, ProductionOutput, Scrap, CustomerReturn, SupplierReturn, StatusChange, CountAdjustment, CostRevaluation, MigrationOpening, Correction
`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.
`FulfillmentLine`	reference		→ FulfillmentLines. Exact dispatch/title portion if applicable.
`ReturnLine`	reference		→ ReturnLines. Exact return source if applicable.
`VersionBefore`	number	yes	Expected position version; new identity checked in locked scope.
`Lot`	reference		→ Lots. Exact same entity/product lot, required when lot-controlled; display values derive from this identity.
`Serial`	reference		→ Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row.

InventoryReservationsExclusive bounded demand claims through picking and owned transit.transaction

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

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. Fulfillment Operator independent of adjustment approval.
`Policy`	reference	yes	→ RetailPolicies. Frozen tolerance/value/lock rules.
`Lock`	reference		→ CountLocks. Required current scope lock at observation/posting.
`PostedAt`	datetime		Atomic adjustment time, with stock event and ledger effects.
`FinanceDecision`	reference		→ ApprovalDecisions. Additional independent Finance Manager approval for found/identity-changing/held/reserved/above-value difference; unknown cost must be resolved first.

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

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`PickNumber`	text	yes	Unique assigned task.
`OrderLine`	reference	yes	→ SalesOrderLines. Approved demand.
`Reservation`	reference	yes	→ InventoryReservations. Exact hard claim.
`Status`	select	yes	Assigned, InProgress, Picked, PartiallyPicked, Exception, Cancelled
`AssignedTo`	reference	yes	→ Users. Fulfillment 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.

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

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

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

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

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

Field	Type	Required	Details
`FulfillmentLine`	reference	yes	→ FulfillmentLines. Exact title-handed-over source. Direct store/pickup actual handover can atomically create the same customer acceptance evidence once.
`AcceptedQuantity`	decimal	yes	Nonnegative actual accepted quantity.
`RefusedQuantity`	decimal	yes	Nonnegative physically refused quantity.
`FailedQuantity`	decimal	yes	Nonnegative undelivered quantity; not lost or returned automatically.
`DamagedQuantity`	decimal	yes	Disjoint damaged scope retained pending disposition; not also included accepted/refused/failed.
`ScopeQuantity`	decimal	yes	Disjoint accepted/refused/failed/damaged outcomes bounded by original actual handed-over units excluding the union of prior accepted, physically returned, approved lost or finally resolved units. Failed visits may retry remaining goods; restock never reopens original POD eligibility.
`ReturnLine`	reference		→ ReturnLines. Refused/damaged actual return custody if applicable.
`CorrectionOf`	reference		→ DeliveryConfirmations. Exact prior result; approvals and downstream billing/title effects reconciled before correction.
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`ConfirmationNumber`	text	yes	Stable actual confirmation/attempt economic identity.
`Status`	select	yes	Prepared, Confirmed, Disputed, Corrected
`OccurredAt`	datetime	yes	Actual customer result time, not scheduled pickup/arrival.
`ConfirmedBy`	reference	yes	→ Users. Fulfillment Operator with actual source/recipient evidence; disputed identity/outcome requires Warehouse Manager review.
`RecipientEvidence`	longtext	yes	Transaction-scoped proof of actual intended recipient/handover; unknown walk-in identity is not invented or reused for another purchase.

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

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

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

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

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

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

RoutingOperationsOrdered work instructions and declared labour/overhead bases.line

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

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

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

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

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

WorkOrderOperationsFrozen instructions and assigned actual work.line

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

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

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

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

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

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

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

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

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

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

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

ReturnDispositionsIndependent actual goods disposition without automatic credit or refund.transaction

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`InvoiceNumber`	text	yes	Unique legal document.
`Account`	reference	yes	→ Accounts. Same entity.
`DocumentType`	select	yes	Invoice, CreditNote
`OriginalInvoice`	reference		→ Invoices. Required credit/correction original.
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, PartiallySettled, Settled, Disputed, Reversed, Cancelled
`InvoiceDate`	date	yes	Original legal/business date.
`PostingDate`	date	yes	Eligible date in entity Period; no closed-period rewrite.
`Period`	reference	yes	→ AccountingPeriods. Same-entity open posting period.
`DueDate`	date	yes	Frozen terms.
`NetAmount`	decimal	yes	Positive magnitude sum InvoiceLines.NetAmount; credit sign comes only from DocumentType.
`TaxAmount`	decimal	yes	Positive applicable tax magnitude, credit reverses original scoped tax.
`TotalAmount`	decimal	yes	NetAmount + TaxAmount once.
`Outstanding`	decimal	yes	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.
`Context`	reference	yes	→ PurchaseContexts. Same actual purchase scope as eligible source order; customer credit inherits original invoice context.
`Channel`	reference	yes	→ Channels. Actual source sales channel for reporting, not independent revenue source.

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.
`FulfillmentLine`	reference		→ FulfillmentLines. 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.
`LoyaltyRedemption`	reference		→ LoyaltyReservations. Exact committed discount allocation; consumed once in accepted net line amounts, never again as a cash tender.

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 source-controlled bank/cash-on-hand/cash-in-transit account according to Kind; never processor clearing.
`Status`	select	yes	Draft, Active, Blocked, Closed
`ProtectedDetails`	longtext	yes	Accountant/Finance Manager only under current purpose; operator/sales exports excluded.
`BalanceQuantity`	decimal	yes	Posted own-currency balance, reconciled to actual bank statement or reviewed physical cash/transfer evidence; opening/collection/deposit is not duplicated.
`CarryingValue`	decimal	yes	Functional carrying balance including delta bank revaluation.
`UnrealizedFX`	decimal	yes	Signed prior bank FX to reclassify on scoped disposal.
`ReservedQuantity`	decimal	yes	Active released/unsettled instructions/refunds; prevent duplicate spend where finite availability policy applies.
`Version`	number	yes	Atomic balance/reservation version.
`Activation`	reference		→ MasterChanges. Independent Finance Manager. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`Kind`	select	yes	Bank, CashOnHand, CashInTransit
`Store`	reference		→ Stores. Optional physical cash custody store; same entity, no drawer/session model.

BankStatementLinesActual external bank evidence, not inferred payment success.transaction

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`ReceiptNumber`	text	yes	Unique cash receipt.
`Account`	reference		→ Accounts. May initially be unidentified; must be attributed with evidence before application.
`BankAccount`	reference		→ BankAccounts. Required and matching entity/currency for Bank or Cash collection; null for Processor capture, which uses PaymentAccount.
`Status`	select	yes	Prepared, Posted, PartiallyApplied, Applied, Returned, Reversed
`ReceivedAt`	datetime	yes	Actual confirmed bank/cash receipt or actual verified processor capture instant; intent/authorization/transport acknowledgment is not receipt.
`Period`	reference	yes	→ AccountingPeriods. Eligible posting period.
`Amount`	decimal	yes	Positive receipt-currency amount.
`UnappliedAmount`	decimal	yes	Gross Amount less live posted receipt-currency applications and only directly cash-funded refunds/approved actual receipt-return corrections. Credit-funded refund and processor payout never reduce this receipt or its historical application. Never negative.
`UnappliedCarrying`	decimal	yes	Functional remaining unapplied liability carrying, including its own revaluation.
`UnrealizedFX`	decimal	yes	Gain-positive prior FX on unapplied liability, released/reclassified proportionally.
`ReservedAmount`	decimal	yes	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 actual Bank/CashOnHand or processor Clearing / Cr UnappliedCustomer once. Linked ProcessorEntry is the same clearing effect, not an extra journal.
`Baseline`	longtext	yes	Opening receipt amount/applied/unapplied/carrying/FX and original source IDs, nonposting.
`SourceKind`	select	yes	Bank, Cash, Processor
`Context`	reference		→ PurchaseContexts. Required resolved entitlement before application/refund; unidentified actual capture remains recorded but held.
`PaymentAccount`	reference		→ PaymentAccounts. Required for Processor, same entity and currency; not bank cash.
`CaptureEvent`	reference		→ PaymentEvents. Unique actual verified Capture economic scope; required for Processor and cannot be reused for another receipt.
`ProcessorEntry`	reference		→ ProcessorEntries. Unique positive clearing-source asset; its carrying/settlement is separate from UnappliedCarrying liability.
`AvailabilityState`	select	yes	Clear, Unidentified, Held, ReviewRequired
`HeldAmount`	decimal	yes	Nonnegative currently unapplied portion held outside existing reservations; bounded by UnappliedAmount minus ReservedAmount. Broader unresolved context/capture hold can block all new action without deleting existing claims.
`POSShift`	reference		→ POSShifts. Actual source shift for cash received; one existing receipt effect, not a second closing receipt.

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`ApplicationNumber`	text	yes	Unique application.
`Receipt`	reference	yes	→ CashReceipts. Confirmed, identified same-entity/account AND same purchase entitlement; independent authorized ExchangeLinks required for a replacement-context transfer.
`Invoice`	reference	yes	→ Invoices. Independently approved posted debit, same customer/entity/context unless exact approved exchange transfer permits it.
`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.
`Exchange`	reference		→ ExchangeLinks. Required for authorized cross-context replacement application; never generic shared walk-in pooling.

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 and purchase context, or exact independently approved ExchangeLinks transfer; no unrelated walk-in credit reuse.
`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.
`Exchange`	reference		→ ExchangeLinks. Required for any customer credit transfer to a different purchase context; exact claimant and independent finance permission. Same generic walk-in Account is insufficient.

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 refund destination currency: bank/cash currency or processor clearing/capture 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		→ BankAccounts. Required for Bank/Cash method; same entity, permitted actual recipient/funding route. Null for processor method.
`Status`	select	yes	Draft, PendingApproval, Reserved, Released, Submitted, Uncertain, Settled, Rejected, Returned, Cancelled, Held
`Instruction`	reference		→ IntegrationDeliveries. Transport intent only.
`SettlementEvent`	reference		→ IntegrationEvents. Authoritative actual cash outcome.
`SettledAt`	datetime		Actual posting time.
`Journal`	reference		→ JournalEntries. Funding control against actual Bank/Cash or new negative processor Clearing source once, plus reviewed FX. Credit-funded refund preserves original receipt/application; prior payout does not invalidate refund or cause another cash reduction.
`SupplierPrepayment`	reference		→ Payments. Alternative FromSupplier funding collection; XOR CreditBill.
`Method`	select	yes	Bank, Cash, Processor. Processor is ToCustomer only against verified original capture; incoming supplier refund uses actual Bank/Cash evidence.
`Context`	reference		→ PurchaseContexts. Required for ToCustomer; original credit/receipt transaction entitlement, not merely common counterparty.
`Exchange`	reference		→ ExchangeLinks. Reviewed replacement difference linkage when relevant; every refund still requires its own independent approval.
`PaymentAccount`	reference		→ PaymentAccounts. Required for Processor, same entity/currency and approved actual refund route.
`OriginalCapture`	reference		→ PaymentEvents. Required verified Capture for Processor routing; exact refundable capture family and amount ceiling, not evidence of remaining clearing cash.
`CaptureAmount`	decimal		Positive amount claimed in original capture currency, required for Processor; here equals Amount because one account/currency. SourceAmount remains funding document/receipt currency.
`ProcessorEntry`	reference		→ ProcessorEntries. Actual confirmed refund creates one new negative clearing obligation, even when original capture has already paid out.
`DisputeEvidence`	longtext	yes	Current affected capture/context holds and actual claimant/recipient verification; no execution against unresolved overlapping claim without independent FM resolution.
`POSShift`	reference		→ POSShifts. Actual cash-refund custody session; only confirmed cash refunds affect expected drawer cash. Card refunds do not.

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, ProcessorResolution
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, Rejected
`SourceTable`	text	yes	Exact existing source type.
`SourceKey`	text	yes	Original immutable source/effect identity.
`Scope`	longtext	yes	Exact original currency/value/allocations/FX/tax/cost and actor/source lineage; restores/reclassifies each claim once. ProcessorResolution may reverse affected historical applications via linked compensating records and clear newly reopened unapplied balance against already recorded processor suspense; never make spendable customer funds negative or repost the actual clearing debit.
`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.
`ProcessorAdjustment`	reference		→ ProcessorAdjustments. Required for ProcessorResolution; actual clearing delta already recorded, so resolution reclassifies suspense/expense or exact customer claims without another bank/clearing debit.
`Context`	reference		→ PurchaseContexts. Required when changing retail customer cash/credit/refund entitlement; preserves actual purchase scope.

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, ProcessorEntries. Processor asset/payable sources and their customer unapplied liabilities are separate monetary balances; never revalue both source entries and their same control total.
`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, CashTransfer, Processor, Tax, FX, Reclassification, Manual, Opening, Correction
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, Reversed
`PostingDate`	date	yes	Date in eligible Period.
`Period`	reference	yes	→ AccountingPeriods. Same entity.
`SourceTable`	text	yes	Existing typed source or explicitly authorized Manual/Opening evidence.
`SourceKey`	text	yes	Unique economic source/effect; a second transport event cannot repost it.
`PostedAt`	datetime		Actual local posting.
`ReversalOf`	reference		→ JournalEntries. Exact prior journal/line source; no destructive editing.
`CashTransferFrom`	reference		→ BankAccounts. Required for CashTransfer; source Bank/CashOnHand/CashInTransit under actual custody evidence, same entity and different from destination.
`CashTransferTo`	reference		→ BankAccounts. Required actual same-entity bank/cash destination; no new CashReceipt/customer/revenue.
`CashTransferSourceAmount`	decimal		Positive actual source-currency amount, exclusively reserved against source cash availability until confirmed movement.
`CashTransferDestinationAmount`	decimal		Positive actual destination-currency amount; same-currency identity explicit, foreign conversion separately evidenced.
`CashTransferSourceCarrying`	decimal		Exact positive current functional carrying removed from source with prior FX allocation.
`CashTransferDestinationValue`	decimal		Actual positive functional value received at destination; difference is reviewed FX/fee, never invented rounding or revenue.
`CashTransferEvidence`	longtext		Actual custody/bank confirmation, finite source claim and recipient/amount/FX/fee proof. Cash handed to transit is not bank receipt; second actual deposit consumes only remaining transit scope.
`CashTransferStatement`	reference		→ BankStatementLines. Required actual bank evidence for bank leg; cash-only custody needs reviewed manual proof.
`PriorCashTransfer`	reference		→ JournalEntries. Exact earlier CashTransfer transit leg; later deposit/reversal cannot consume more than remaining in-transit source.

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

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

ReceiptAcceptancesIndependent bounded disposition tranches against one immutable actual arrival.transaction

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

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

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

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

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

StoresPhysical store context linked to a real stock warehouse/location and entity; no POS terminal or cash-drawer installation.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`StoreCode`	text	yes	Unique store identity within entity.
`Name`	text	yes	Public/operational store name.
`Warehouse`	reference	yes	→ Warehouses. Actual stock site; stock is not duplicated in a separate store balance.
`DefaultLocation`	reference	yes	→ Locations. Same warehouse default handover/staging location.
`Timezone`	text	yes	IANA local operational timezone; actual timestamps retain offsets.
`WalkInAccount`	reference	yes	→ Accounts. Reviewed same-entity Kind WalkIn counterparty; each purchase still has independent entitlement scope.
`CashAccount`	reference		→ BankAccounts. Reviewed same-entity cash-on-hand account when cash collection is supported; shift reconciliation links registers to this actual account without duplicating cash balances.
`Status`	select	yes	Draft, Active, Suspended, Closed
`Activation`	reference		→ MasterChanges. Independent Sales Manager, Warehouse Manager and Finance Manager approve their affected commercial/stock/cash domains.

ChannelsLogical store/online intake context and source identity namespace; a record does not mean a connected storefront or provider.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`ChannelCode`	text	yes	Unique source namespace, stable across imports and retries.
`Name`	text	yes	Configured store/online source label.
`Kind`	select	yes	Store, Online
`Store`	reference		→ Stores. Required for store channel; same entity.
`DefaultWarehouse`	reference	yes	→ Warehouses. Reviewed fulfillment source; allocation may use other explicitly authorized same-entity sites.
`DefaultCurrency`	reference	yes	→ Currencies. Default document currency, never substitutes for actual accepted source currency.
`DefaultPriceList`	reference		→ PriceLists. Selected approved version; imported price evidence still reviewed for conflicts.
`WalkInAccount`	reference	yes	→ Accounts. Reviewed same-entity counterparty when actual person is unknown; cannot pool spendable funds across purchases.
`IntakeMode`	select	yes	Manual, AuthenticatedImport
`Status`	select	yes	Draft, Active, Suspended, Closed
`Activation`	reference		→ MasterChanges. Independent Sales Manager commercial and Finance Manager monetary/source policy review.

PurchaseContextsImmutable customer-entitlement scope tying one purchase intent, accepted evidence, collections, credits and refunds together.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`ContextNumber`	text	yes	Unique transaction/purchase scope; distinct even when the same walk-in Account is reused.
`Account`	reference	yes	→ Accounts. Known customer or configured walk-in, same entity.
`ContactPerson`	reference		→ ContactPersons. Optional actual known person; absent is not a fabricated identity.
`Channel`	reference	yes	→ Channels. Source namespace.
`SourcePurchaseKey`	text	yes	Stable actual external order/purchase-proposal/manual transaction key; no unrelated purchase reuse.
`Status`	select	yes	Open, Verified, Held, Closed
`EntitlementEvidence`	longtext	yes	Actual accepted purchase/receipt/recipient/refund proof, source references and verification; customer PII limited to supplied necessary facts. Walk-in proof never grants access to other purchases.
`VerifiedBy`	reference		→ Users. Actual Sales Manager or Finance Manager for protected entitlement assignment/transfer; routine exact known matching follows approved policy.
`VerifiedAt`	datetime		Actual verification.

ChannelOrdersImmutable source purchase proposal/online agreement and current review state, distinct from independent local sales-order approval.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted scope/material editors frozen.
`Snapshot`	reference		→ DocumentRevisions. Exact source/line/price/tax/rate/actor evidence; mandatory before relevant review or posting.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`ChannelOrderNumber`	text	yes	Unique intake record.
`Channel`	reference	yes	→ Channels. Stable source namespace.
`ExternalOrderKey`	text	yes	Unique source order key within channel/entity; retries and revisions reuse this economic identity.
`ExternalRevision`	text	yes	Exact source content revision/hash.
`Context`	reference	yes	→ PurchaseContexts. Transaction-specific customer entitlement.
`Currency`	reference	yes	→ Currencies. Actual accepted transaction currency; mixed/unknown currency must resolve before conversion.
`Status`	select	yes	Received, PendingReview, ApprovedForConversion, Converted, CancellationRequested, Cancelled, Conflict
`SourceAcceptedAt`	datetime		Actual customer agreement time if supplied; null when only a proposal or unknown.
`AcceptedEvidence`	longtext	yes	Actual source quantity/net/discount/tax/terms/customer/handover evidence; external Accepted does not authorize the local human gate.
`Quote`	reference		→ Quotes. Optional exact accepted offer; compatible source line quantities/values checked.
`SalesOrder`	reference		→ SalesOrders. Single generated local source order; split fulfillment uses its allocations, not repeated conversion.
`ReceivedAt`	datetime	yes	Actual local evidence ingestion time, separate from source occurrence.
`POSShift`	reference		→ POSShifts. Actual originating register shift for authenticated POS orders; same entity, store and channel. Unmatched external evidence remains held.

ChannelOrderLinesStable source line identity and reviewed canonical SKU/unit/net/tax allocation, never an extra stock balance.line

Field	Type	Required	Details
`ChannelOrder`	reference	yes	→ ChannelOrders. Parent source revision.
`ExternalLineKey`	text	yes	Stable within original source order, preserved through revisions/cancellations.
`ExternalSKU`	text	yes	Actual source SKU/variant identifier, not silently substituted by display name.
`ChannelProduct`	reference		→ ChannelProducts. Exact reviewed effective mapping; unresolved mapping blocks local approval/reservation/fulfillment.
`ProductUnit`	reference		→ ProductUnits. Frozen mapped canonical SKU and conversion factor; null until known.
`Quantity`	decimal	yes	Positive accepted source selling-unit quantity.
`BaseQuantity`	decimal		Quantity × frozen unit conversion, null until resolved.
`ListExtension`	decimal		Known nonnegative transaction-currency list extension, where supplied; actual net and discounts must reconcile.
`LineDiscount`	decimal		Nonnegative explicit source line reduction.
`OrderDiscountAllocation`	decimal		Nonnegative source-order discount share with final remainder.
`NetAmount`	decimal	yes	Actual accepted nonnegative net. Detailed basis equals known list extension minus line/order reductions once; AcceptedNet is the evidenced amount, with no invented list price or discount. Required before approval; malformed/missing amounts stay in raw inbound conflict, not a fabricated line.
`TaxAmount`	decimal	yes	Actual accepted tax amount/basis evidence; material differences require review, not silently zero.
`SourceEvidence`	longtext	yes	Exact raw line, unit/price/tax/discount/promise and source hash; no incompatible inferred SKU/variant.
`PriceBasis`	select	yes	Detailed, AcceptedNet. Detailed requires known list/discount basis; AcceptedNet preserves actual net-only agreement and leaves absent list/reductions null.

ProductStylesNonstock merchandising grouping for actual canonical SKU variants.master

Field	Type	Required	Details
`StyleCode`	text	yes	Unique merchandising style/group.
`Name`	text	yes	Display grouping only.
`Description`	longtext	yes	Business supplied family/attribute description.
`Status`	select	yes	Draft, Active, Inactive
`Activation`	reference		→ MasterChanges. Independent Sales Manager review; a style is never stock, a BOM or a sellable virtual kit.

ProductVariantsReviewed variant attributes identify exactly one canonical stocked product.master

Field	Type	Required	Details
`VariantCode`	text	yes	Stable variant identity.
`Style`	reference	yes	→ ProductStyles. Nonstock parent grouping.
`Product`	reference	yes	→ Products. One canonical physical SKU; all channels/barcodes reserve this same stock identity.
`Attributes`	longtext	yes	Validated attribute names/values; unique normalized combination within style maps to one SKU.
`Status`	select	yes	Draft, Active, Inactive
`Activation`	reference		→ MasterChanges. Independent Sales Manager commercial and Warehouse Manager identity/unit review.

ProductBarcodesBarcode-to-canonical selling unit mapping without scanner/hardware claims.master

Field	Type	Required	Details
`Barcode`	text	yes	Unique active identifier in its reviewed namespace; leading zeros retained.
`Namespace`	text	yes	Configured manufacturer/internal code namespace; ambiguous matches block action.
`ProductUnit`	reference	yes	→ ProductUnits. Exact canonical SKU and selling-unit conversion; a case barcode is not one base unit unless factor says so.
`Status`	select	yes	Draft, Active, Inactive
`Activation`	reference		→ MasterChanges. Independent Warehouse Manager identity/unit review.

ChannelProductsVersioned external SKU/variant mapping into the same canonical product and unit model.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`MappingNumber`	text	yes	Unique channel/external-SKU/version.
`Channel`	reference	yes	→ Channels. Source namespace and entity.
`ExternalSKU`	text	yes	Actual provider/store source identifier.
`ExternalVariantKey`	text		Actual variant key where distinct from SKU.
`ProductUnit`	reference	yes	→ ProductUnits. Exact canonical product plus quantity conversion.
`Variant`	reference		→ ProductVariants. When present, must identify the same canonical Product.
`StartsAt`	datetime	yes	Inclusive effective boundary.
`EndsAt`	datetime		Exclusive.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Sales Manager and Warehouse Manager affected-domain approval.

ExchangeLinksSeparately authorized replacement orders and source-credit transfer for an evidenced customer exchange.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted scope/material editors frozen.
`Snapshot`	reference		→ DocumentRevisions. Exact source/line/price/tax/rate/actor evidence; mandatory before relevant review or posting.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`Decision`	reference		→ ApprovalDecisions. Current exact independent action/scope/revision decision; required before corresponding approved effect.
`ExchangeNumber`	text	yes	Unique return/replacement scope link.
`Return`	reference	yes	→ Returns. Approved physical return source; credit/actual disposition remains separate.
`OriginalContext`	reference	yes	→ PurchaseContexts. Original transaction entitlement.
`ReplacementContext`	reference	yes	→ PurchaseContexts. New separately accepted replacement purchase, never an unrelated walk-in.
`ReplacementOrder`	reference	yes	→ SalesOrders. Independent Sales Manager-approved new order with its own stock/net/tax obligations.
`Status`	select	yes	Prepared, PendingApproval, Approved, InProgress, Complete, Cancelled
`EntitlementEvidence`	longtext	yes	Same actual customer/authorized claimant proof and exact allowed credit/source transfer, even when both accounts use a generic walk-in counterparty.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager authorizes any source-credit transfer/refund difference; no automatic credit netting or bypass of invoice/refund gates.
`CreditApplication`	reference		→ CreditApplications. Actual bounded transfer/application after its exact source is available.
`DifferenceEvidence`	longtext	yes	Accepted replacement net/tax less eligible original credit in a common reviewed currency; extra collection/refund is separately evidenced, not an unexplained negative order.

PaymentAccountsConfigured provider merchant/currency account and reviewed local clearing policy; not an installed payment gateway.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`PaymentAccountCode`	text	yes	Stable provider/merchant/currency namespace.
`ProviderName`	text	yes	Configured source name, no supported-provider claim without implementation evidence.
`MerchantReference`	text	yes	Reviewed actual account identifier, protected within financial scope.
`Currency`	reference	yes	→ Currencies. One clearing currency per account; multiple provider currencies use separate reviewed accounts.
`ClearingAccount`	reference	yes	→ ChartOfAccounts. Dedicated source-controlled processor clearing asset/liability; separate from bank, revenue and customer unapplied liability.
`SuspenseAccount`	reference	yes	→ ChartOfAccounts. Configured source-controlled processor discrepancy/suspense, used for authoritative unexplained debits under approved policy until independent classification.
`FeeAccount`	reference	yes	→ ChartOfAccounts. Approved fee expense mapping; no invented fee rate.
`DefaultBankAccount`	reference	yes	→ BankAccounts. Actual expected payout/debit bank; foreign bank currency uses separate conversion evidence.
`EvidencePolicy`	longtext	yes	Authentication/manual verification, capture/economic keys, actual fee mapping/limits, signed settlement and suspense/hold handling, with independent Finance Manager activation.
`Status`	select	yes	Draft, Active, Suspended, Closed
`Activation`	reference		→ MasterChanges. Independent Finance Manager excluding preparer/editor and beneficiary proposer where required.

PaymentTransactionsStable original payment intent/capture family, including partial capture/refund/dispute ceilings.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`PaymentNumber`	text	yes	Unique original provider payment identity.
`PaymentAccount`	reference	yes	→ PaymentAccounts. Exact provider/merchant/currency source.
`ExternalPaymentKey`	text	yes	Unique within payment account; repeated callbacks keep same family.
`Context`	reference		→ PurchaseContexts. Actual transaction entitlement; unresolved context blocks application/refund, not ingestion of real money evidence.
`ChannelOrder`	reference		→ ChannelOrders. Optional source order may arrive before or after payment; exact key/revision match required.
`Currency`	reference	yes	→ Currencies. Must equal provider account clearing currency for this payment family.
`Status`	select	yes	Intent, Authorized, PartiallyCaptured, Captured, PartiallyRefunded, Refunded, Disputed, Reversed, Failed, Cancelled, ReviewRequired
`AuthorizedAmount`	decimal	yes	Current evidenced authorization amount; not captured money or spendable receipt.
`CapturedAmount`	decimal	yes	Gross sum unique actual confirmed capture events, unchanged by separately recorded refunds/reversals.
`RefundedAmount`	decimal	yes	Actual confirmed refund gross, separate history.
`RefundReservedAmount`	decimal	yes	All active/uncertain refund claims on capture family; never released merely by timeout.
`DisputedAmount`	decimal	yes	Overlapping unresolved/reversed source amounts held against further discretionary spending/refunds; exact unit-of-money scopes prevent double subtraction.
`OccurredAt`	datetime	yes	Actual original source occurrence.
`POSShift`	reference		→ POSShifts. Source register shift for card or other tender evidence; never included in physical drawer cash.

PaymentEventsAuthenticated or independently verified manual source facts; economic effect identities survive duplicate/reordered callbacks.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`PaymentEventNumber`	text	yes	Unique evidence/event record.
`Payment`	reference	yes	→ PaymentTransactions. Original same-currency payment family.
`ExternalEventKey`	text	yes	Unique source event delivery key.
`EconomicKey`	text	yes	Stable underlying authorization/capture/refund/adjustment identity; duplicate alias events do not produce extra economic effect.
`Kind`	select	yes	Intent, Authorization, Capture, AuthorizationVoid, CaptureReversal, Refund, RefundFailure, DisputeDebit, DisputeRecovery, Failure, Correction
`Status`	select	yes	Received, Verified, Applied, Uncertain, Conflict, Rejected
`Amount`	decimal	yes	Nonnegative actual amount in transaction currency; purpose/sign determined by Kind, not guessed from transport text.
`OccurredAt`	datetime	yes	Actual source event time.
`ReceivedAt`	datetime	yes	Local ingestion time; late/out-of-order is visible.
`Evidence`	longtext	yes	Immutable raw source hash, authenticated origin or reviewed manual proof, source revision and actual effect references.
`VerifiedBy`	reference		→ Users. Authorized Accountant or scoped service under independently approved evidence policy; manual money proof requires real review.
`CaptureReceipt`	reference		→ CashReceipts. Unique local confirmed capture gross; intent/auth never creates this.
`Refund`	reference		→ Refunds. Exact authorized local refund if matched; unexpected actual external refund becomes reviewed processor adjustment/suspense rather than disappearing.
`Adjustment`	reference		→ ProcessorAdjustments. Actual external reversal/dispute/fee/correction scope when relevant.

ProcessorEntriesImmutable signed clearing-source deltas with separate current carrying and exclusive settlement allocation.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`ProcessorEntryNumber`	text	yes	Unique economic clearing source.
`PaymentAccount`	reference	yes	→ PaymentAccounts. One merchant/currency clearing account.
`Kind`	select	yes	Capture, Refund, Fee, ExternalDebit, Recovery, Correction, Opening
`Currency`	reference	yes	→ Currencies. Payment account currency.
`Amount`	decimal	yes	Immutable nonzero signed clearing-currency source: capture/recovery increases asset, refund/fee/debit decreases it. Opposite signs never overwrite original entry.
`OriginalFunctionalValue`	decimal	yes	Signed original entity-functional value at actual source event rate.
`CurrentCarryingValue`	decimal	yes	Signed remaining source carrying for the unallocated Amount portion; negative sources are payable/contra-clearing, not negative customer spendable balance. Revaluation and partial settlement preserve source attribution.
`AllocatedAmount`	decimal	yes	Cumulative signed source amount settled; same sign as Amount and bounded in absolute value.
`ReservedAmount`	decimal	yes	Active signed settlement claims; same sign, absolute allocated+reserved cannot exceed original absolute source amount.
`PriorUnrealized`	decimal	yes	Attributed signed prior unrealized on remaining source, released/reclassified only with exact settled/corrected portion.
`Status`	select	yes	Open, PartiallySettled, Settled, Held, Reversed
`OccurredAt`	datetime	yes	Actual source occurrence.
`CashReceipt`	reference		→ CashReceipts. Capture asset source; linked receipt independently carries customer unapplied liability.
`Refund`	reference		→ Refunds. Actual authorized refund clearing effect; no source CashReceipt reduction for credit-funded refund.
`Adjustment`	reference		→ ProcessorAdjustments. Exact fee/dispute/recovery/suspense effect.
`Journal`	reference		→ JournalEntries. Balanced local source effect, same journal as linked receipt/refund/adjustment. Nullable before source posts; required once economic delta exists.
`ReversalOf`	reference		→ ProcessorEntries. Exact compensating source with downstream settlement and customer obligations reconciled.

ProcessorAdjustmentsActual provider debits/fees/recoveries and independently classified financial consequences, without a full chargeback case-management product.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted scope/material editors frozen.
`Snapshot`	reference		→ DocumentRevisions. Exact source/line/price/tax/rate/actor evidence; mandatory before relevant review or posting.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`AdjustmentNumber`	text	yes	Unique actual provider ledger/economic adjustment.
`PaymentAccount`	reference	yes	→ PaymentAccounts. Exact merchant/currency source.
`Payment`	reference		→ PaymentTransactions. Affected capture family, when known; unresolved actual money evidence is still retained.
`PaymentEvent`	reference		→ PaymentEvents. Authenticated/verified source fact.
`Kind`	select	yes	Fee, DisputeDebit, DisputeRecovery, UnexpectedRefund, CaptureReversal, Correction
`Status`	select	yes	Observed, Posted, Reversed, Conflict
`ClassificationStatus`	select	yes	PolicyMapped, PendingReview, Approved, Reclassified, Resolved
`Currency`	reference	yes	→ Currencies. Same processor account currency.
`Amount`	decimal	yes	Nonzero signed clearing delta: debit/fee negative, recovery positive; actual evidence determines sign.
`Rate`	reference	yes	→ ExchangeRates. Actual source-to-functional rate and purpose; missing mapping/rate is explicit unresolved evidence, never invented zero.
`CounterAccount`	reference	yes	→ ChartOfAccounts. Approved expense mapping or configured processor suspense for authoritative unexplained adjustment; suspense is not a claimed recoverable asset or final loss determination.
`Evidence`	longtext	yes	Exact actual debit/fee/recovery, immutable amount/source, classification status and unresolved customer/receipt/refund overlap.
`OriginalAdjustment`	reference		→ ProcessorAdjustments. Recovery/correction source; cumulative recovery cannot exceed eligible original scope unless separately evidenced new event.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager for nonroutine classification, reclassification, expense/write-off or customer/application correction.
`Resolution`	reference		→ FinanceCorrections. Exact bounded source correction/reclassification; original clearing delta is already recorded and cannot post again.
`ProcessorEntry`	reference		→ ProcessorEntries. Unique signed local clearing entry.
`PostedAt`	datetime		Actual local posting; authoritative unexplained debit follows approved suspense mapping without waiting to invent customer availability.

ProcessorSettlementsObserved provider payout/debit batch reconciled to exact signed clearing sources, then independently approved for local posting.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; stores, channels, customers, stock ownership and all financial sources must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted scope/material editors frozen.
`Snapshot`	reference		→ DocumentRevisions. Exact source/line/price/tax/rate/actor evidence; mandatory before relevant review or posting.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical canonical content returns same effect, changed content enters review.
`Event`	reference		→ IntegrationEvents. Authenticated import or reviewed manual source evidence.
`Decision`	reference		→ ApprovalDecisions. Current exact independent action/scope/revision decision; required before corresponding approved effect.
`SettlementNumber`	text	yes	Unique provider settlement identity.
`PaymentAccount`	reference	yes	→ PaymentAccounts. Exact merchant/currency namespace.
`ExternalSettlementKey`	text	yes	Stable actual provider payout/debit key; retry cannot duplicate bank/cash.
`Currency`	reference	yes	→ Currencies. Processor clearing currency.
`Status`	select	yes	Observed, Matching, PendingApproval, Approved, Posted, Uncertain, Disputed, Reversed
`SettlementAmount`	decimal	yes	Signed sum reserved/posted ProcessorSettlementLines.Amount: positive actual payout, negative actual merchant-bank debit, zero verified offset batch. Sources may include negative refunds/fees/disputes, including refunds after all original capture clearing was paid out.
`BankAccount`	reference		→ BankAccounts. Required verified actual same-entity bank for a nonzero bank leg; null for a verified zero-offset packet with no bank movement.
`BankAmount`	decimal	yes	Signed actual bank-currency amount received/paid; no amount fabricated from an intent.
`Rate`	reference	yes	→ ExchangeRates. Positive actual clearing-currency-to-entity-functional reference; BankRate separately values actual bank currency. Claimed material provider conversion/fee differences require evidence/classification.
`BankStatementLine`	reference		→ BankStatementLines. Actual bank confirmation before Posted for nonzero transfer; zero-offset uses verified provider settlement evidence instead.
`OccurredAt`	datetime	yes	Actual provider settlement time, distinct from local approval/posting.
`Evidence`	longtext	yes	Provider batch lines, net payout/debit, separately recorded fees/refunds/debits, source hashes and actual bank evidence.
`PostedAt`	datetime		Local atomic bank-versus-clearing effect after independent Finance Manager reconciliation approval; this does not initiate a provider payout.
`Journal`	reference		→ JournalEntries. Positive net bank receipt or negative merchant debit clears the signed source carrying once; fees/debits already posted are not repeated. For verified zero-offset currency scope, bank amount/value is zero and only nonzero net carrying FX or required zero-net prior FX reclassification posts; absent when both are zero, never a fabricated zero journal.
`BankRate`	reference		→ ExchangeRates. Required actual bank-currency-to-functional basis for a nonzero bank leg; null for verified zero offset. Independent of clearing-currency Rate; identity conversion explicit.
`ClearingCarryingReleased`	decimal	yes	Signed sum allocated line current carrying, retained for exact partial-source correction.
`BankPostingValue`	decimal	yes	Signed functional bank effect: incoming receipt at actual approved rate, outgoing disposal at its actual existing bank carrying; explicit bank FX lineage retained.
`SettlementFXDelta`	decimal	yes	BankPostingValue minus ClearingCarryingReleased, gain-positive new net FX; prior clearing/bank FX reclassified separately with zero net effect. A verified zero-offset has BankPostingValue 0 but can have nonzero signed carrying and therefore real FX delta.
`BankFXReleased`	decimal	yes	Prior unrealized on disposed bank-currency portion, zero for incoming new cash; never counted as another net gain.

ProcessorSettlementLinesExclusive signed partial clearing-source claims for one actual payout/debit batch.line

Field	Type	Required	Details
`Settlement`	reference	yes	→ ProcessorSettlements. Parent entity/account/currency batch.
`ProcessorEntry`	reference	yes	→ ProcessorEntries. Exact eligible same-account source; a source can be partially settled across batches without overuse.
`Amount`	decimal	yes	Nonzero signed source-currency allocation with same sign as entry and bounded absolute available source amount after all active reservations.
`CarryingAmount`	decimal	yes	Signed exact current source carrying released for this allocation; original/carrying/unrealized proportions and final remainder retained.
`PriorUnrealized`	decimal	yes	Signed attributable prior FX reclassified with zero net effect, not recognized twice.
`Status`	select	yes	Reserved, Posted, Released, Reversed
`OriginalFunctionalAmount`	decimal	yes	Signed original functional source portion for exact correction/FX lineage.
`Evidence`	longtext	yes	Source revision/current carrying and exclusive claim identity; uncertain batch retains claims, authoritative nonexecution releases them.

POSRegistersConfigured integration identity of a physical or logical register; no hardware installation is implied.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. All linked store, currency, policy and ownership scopes must agree.
`Store`	reference	yes	→ Stores.
`Channel`	reference	yes	→ Channels.
`RegisterCode`	text	yes
`ExternalNamespace`	text	yes	Unique source/provider/register identity, effective and reviewed.
`CashAccount`	reference	yes	→ BankAccounts. Same-entity CashOnHand account; register is custody context, not another ledger balance.
`Status`	select	yes	Draft, Active, Suspended, Closed
`Activation`	reference	yes	→ MasterChanges. Sales Manager source/scope and Finance Manager cash-account approval required.

POSShiftsOne source register session with reconciled cash custody and an independently approved closing revision.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. All linked store, currency, policy and ownership scopes must agree.
`ShiftNumber`	text	yes
`Revision`	number	yes	Positive monotonic revision; submitted/posted data immutable.
`PreparedBy`	reference	yes	→ Users. Actual preparer; material editors retained for independence checks.
`CreatedAt`	datetime	yes	Actual offset-aware time.
`OperationKey`	text	yes	Stable economic key and payload hash; identical replay has one effect, conflicting content is held.
`Snapshot`	reference		→ DocumentRevisions. Frozen payload and source manifest required at submission.
`Decision`	reference		→ ApprovalDecisions. Independent decision on the exact snapshot and revision; changing material content invalidates it.
`Register`	reference	yes	→ POSRegisters.
`ExternalShiftKey`	text	yes	Unique within register namespace; reopening does not create another original session.
`StartedAt`	datetime	yes
`EndedAt`	datetime		Actual close time later than start; open shift has none.
`StartDate`	date	yes	Local operational date from actual timezone.
`EndDate`	date		Local end date, retained for scheduling.
`Currency`	reference	yes	→ Currencies. Drawer currency; mixed currencies use separate count/effect scopes.
`SourceWatermark`	text	yes	Complete manifest and last acknowledged source sequence/hash through close; missing/late events prevent final certification.
`OpeningCash`	decimal	yes	Actual counted opening float with predecessor/transfer evidence; not new revenue.
`ExpectedCash`	decimal	yes	Frozen opening plus confirmed cash receipts plus signed custody movements minus evidenced cash refunds, with each economic effect once.
`CountedCash`	decimal	yes	Derived from retained tender counts; not typed to force a match.
`Variance`	decimal	yes	Counted minus expected in drawer currency; not mixed with card or processor totals.
`CashVarianceJournal`	reference		→ JournalEntries. Approved difference only against configured cash-over/short or reviewed suspense account; not a repost of shift turnover.
`Status`	select	yes	Open, PendingReview, Approved, Closed, Exception
`ClosedAt`	datetime		Only after source completeness, independent finance decision and confirmed variance/transfer accounting.

POSTenderCountsImmutable submitted count lines by drawer currency and denomination; recounts preserve the original.line

Field	Type	Required	Details
`Shift`	reference	yes	→ POSShifts.
`CountNumber`	text	yes
`CountedAt`	datetime	yes
`CountedBy`	reference	yes	→ Users. Actual independent count actor; cannot approve the same close.
`Denomination`	decimal	yes	Positive face value in shift currency.
`Quantity`	number	yes	Nonnegative integer count.
`Amount`	decimal	yes	Denomination times quantity in currency precision.
`RecountOf`	reference		→ POSTenderCounts. Retain old count; select exactly one approved complete count set for close.
`Status`	select	yes	Draft, Submitted, Accepted, Superseded

POSCashEventsDocumented float, paid-in, pickup, safe drop or correction; each custody effect has one accounting source.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. All linked store, currency, policy and ownership scopes must agree.
`CashEventNumber`	text	yes
`Revision`	number	yes	Positive monotonic revision; submitted/posted data immutable.
`PreparedBy`	reference	yes	→ Users. Actual preparer; material editors retained for independence checks.
`CreatedAt`	datetime	yes	Actual offset-aware time.
`OperationKey`	text	yes	Stable economic key and payload hash; identical replay has one effect, conflicting content is held.
`Snapshot`	reference		→ DocumentRevisions. Frozen payload and source manifest required at submission.
`Decision`	reference		→ ApprovalDecisions. Independent decision on the exact snapshot and revision; changing material content invalidates it.
`Shift`	reference	yes	→ POSShifts.
`OccurredAt`	datetime	yes
`Kind`	select	yes	Float, PaidIn, Pickup, SafeDrop, Correction
`SignedAmount`	decimal	yes	Positive into drawer, negative out; actual same-currency amount, bounded by available cash where an instruction is initiated.
`FromAccount`	reference	yes	→ BankAccounts. Actual same-entity source.
`ToAccount`	reference	yes	→ BankAccounts. Different same-entity custody destination; a safe drop or transit is not bank receipt.
`Evidence`	attachment	yes	Actual transfer/custody proof.
`Journal`	reference	yes	→ JournalEntries. Existing CashTransfer or reviewed Correction effect; one operation key, exact carrying and period.
`Status`	select	yes	Draft, PendingApproval, Approved, Confirmed, Failed
`ReversalOf`	reference		→ POSCashEvents. Exact retained original; opposite effect only after resolving any downstream custody.

LoyaltyProgramsVersioned non-cash promotional points rules; gift cards, purchased value and programs requiring unsupported liability accounting are excluded.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. All linked store, currency, policy and ownership scopes must agree.
`ProgramCode`	text	yes
`Name`	text	yes
`Version`	number	yes
`EffectiveFrom`	datetime	yes
`EffectiveTo`	datetime		Exclusive upper bound; no overlapping active versions.
`Rules`	longtext	yes	Frozen eligible products/stores, accepted net-spend basis excluding tax/shipping/refunded scope, integer rounding, earn timing, redemption conversion/caps, stacking and return treatment.
`ExpiryDays`	number	yes	Explicit calendar/timezone expiry rule per earned event; no indefinite default.
`AccountingPolicy`	longtext	yes	Finance-approved promotional-discount treatment and accepted net/tax allocation. Activation blocks when required program liability accounting is unsupported.
`PreparedBy`	reference	yes	→ Users. Actual preparer; material editors retained for independence checks.
`CommercialActivation`	reference	yes	→ MasterChanges. Independent Sales Manager rules approval.
`FinanceActivation`	reference	yes	→ MasterChanges. Independent Finance Manager treatment approval.
`Status`	select	yes	Draft, Active, Suspended, Retired

LoyaltyMembersVerified customer membership separate from a shared walk-in accounting counterparty.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. All linked store, currency, policy and ownership scopes must agree.
`MemberNumber`	text	yes
`Account`	reference	yes	→ Accounts. Actual verified named customer; never shared WalkIn entitlement.
`VerifiedIdentityKey`	text	yes	Stable protected identity; no merge solely on name or email.
`ConsentEvidence`	longtext	yes	Actual program enrollment/terms version and necessary permission basis; separate from marketing permission.
`JoinedAt`	datetime	yes
`Status`	select	yes	Pending, Active, Suspended, Closed

LoyaltyAccountsSpendable promotional-unit balance derived atomically from immutable events and active reservations.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. All linked store, currency, policy and ownership scopes must agree.
`Member`	reference	yes	→ LoyaltyMembers.
`Program`	reference	yes	→ LoyaltyPrograms. Version family identity; events retain exact rules version.
`AccountNumber`	text	yes
`EarnedUnits`	number	yes	Integer signed posted earned/reversed balance; no manually editable total.
`AvailableUnits`	number	yes	Nonnegative eligible unexpired earned units less posted spending and active reservations; overdue clawback debt must be cleared before new redemption.
`ClawbackDebt`	number	yes	Nonnegative returned/reversed earn units already spent; no monetary collection or silent negative spendable balance.
`Version`	number	yes	Atomic compare-and-swap guard across all earning, reservation, commit, release, expiry and reversal actions.
`Status`	select	yes	Active, Held, Closed

LoyaltyEventsAppend-only earned, spent, expired, adjusted or reversed promotional units with original source lineage.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. All linked store, currency, policy and ownership scopes must agree.
`LoyaltyEventNumber`	text	yes
`Revision`	number	yes	Positive monotonic revision; submitted/posted data immutable.
`PreparedBy`	reference	yes	→ Users. Actual preparer; material editors retained for independence checks.
`CreatedAt`	datetime	yes	Actual offset-aware time.
`OperationKey`	text	yes	Stable economic key and payload hash; identical replay has one effect, conflicting content is held.
`Snapshot`	reference		→ DocumentRevisions. Frozen payload and source manifest required at submission.
`Decision`	reference		→ ApprovalDecisions. Independent decision on the exact snapshot and revision; changing material content invalidates it.
`Account`	reference	yes	→ LoyaltyAccounts.
`Program`	reference	yes	→ LoyaltyPrograms. Exact approved rules version.
`OccurredAt`	datetime	yes
`Kind`	select	yes	Earn, Redeem, Expire, Adjustment, Reversal
`SignedUnits`	number	yes	Nonzero integer effect; positive earn, negative spend/expiry. Units are never money or cash tender.
`Invoice`	reference		→ Invoices. Exact posted sale/credit with confirmed eligible payment and handover for earn policy; only remaining eligible net scope.
`Reservation`	reference		→ LoyaltyReservations. Mandatory exact reservation for redemption commit.
`OriginalEvent`	reference		→ LoyaltyEvents. Required for reversal or expiry allocation; sums plus active claims cannot exceed original remaining units.
`ExpiresAt`	datetime		Frozen actual earned-lot deadline based on approved timezone/calendar; required on earned units.
`Evidence`	longtext	yes	Stable source-line allocation, eligible basis, rule/rounding version and exact unit lineage.
`Status`	select	yes	Draft, PendingApproval, Posted, Rejected

LoyaltyReservationsFinite reward-unit claim attached to one verified purchase and its accepted discount allocation.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. All linked store, currency, policy and ownership scopes must agree.
`ReservationNumber`	text	yes
`Revision`	number	yes	Positive monotonic revision; submitted/posted data immutable.
`PreparedBy`	reference	yes	→ Users. Actual preparer; material editors retained for independence checks.
`CreatedAt`	datetime	yes	Actual offset-aware time.
`OperationKey`	text	yes	Stable economic key and payload hash; identical replay has one effect, conflicting content is held.
`Snapshot`	reference		→ DocumentRevisions. Frozen payload and source manifest required at submission.
`Decision`	reference		→ ApprovalDecisions. Independent decision on the exact snapshot and revision; changing material content invalidates it.
`Account`	reference	yes	→ LoyaltyAccounts.
`Program`	reference	yes	→ LoyaltyPrograms.
`Purchase`	reference	yes	→ PurchaseContexts. Same verified member entitlement; never another walk-in purchase.
`ReservedAt`	datetime	yes
`ExpiresAt`	datetime	yes	Explicit bounded hold; uncertain externally committed redemptions remain held until nonexecution or actual result is verified.
`Units`	number	yes	Positive integer reserved atomically from eligible earned lots in expiry order.
`Currency`	reference	yes	→ Currencies. Discount currency; units have separately frozen conversion.
`DiscountAmount`	decimal	yes	Positive approved offer allocation within eligible accepted net lines; never cash or a second tender.
`SourceAllocations`	longtext	yes	Exact earned-lot unit claims and target invoice/accepted-line discount allocations; line totals equal frozen discount.
`Invoice`	reference		→ Invoices. Exact posted eligible invoice when committed; no duplicate discount on retry.
`Status`	select	yes	Reserved, Submitted, Committed, Released, Expired, Exception

ERP•AI workspace

Start now ERP for Retail

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

Start now Download agent

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

ERP for Retail

Modules

ERP for Retail

Processes

ERP for Retail

Industries

ERP for Retail

Reference

ERP for Retail

Data model

How the model is organised

Sales & channels

Products & pricing

Inventory & fulfillment

Purchasing

Production & kitting

Payments & refunds

Finance

Controls and connected work

Keys and references

Migration order

Tables

Start now ERP for Retail

ERP for Retail

Modules

ERP for Retail

Processes

ERP for Retail

Industries

ERP for Retail

Reference

Data model

How the model is organised

Sales & channels

Products & pricing

Inventory & fulfillment

Purchasing

Production & kitting

Payments & refunds

Finance

Controls and connected work

Keys and references

Migration order

Tables

Start now ERP for Retail

Your Privacy, Your Choice

Manage Your Cookie Preferences