Data model

Understand the records connecting healthcare supplies and separate company books.

117 tables · 770 relationships

How the model is organised

Department supplies

Facilities, Departments, DepartmentRequests, DepartmentRequestLines, DepartmentUses, DepartmentUseLines.

Facilities
Departments
DepartmentRequests
DepartmentRequestLines
DepartmentUses
DepartmentUseLines

Purchasing & suppliers

Suppliers, SupplierBankAccounts, Requisitions, RequisitionLines, PurchaseOrders, PurchaseOrderLines, GoodsReceipts, GoodsReceiptLines, ReceiptAcceptances, BillMatches.

Suppliers
SupplierBankAccounts
Requisitions
RequisitionLines
PurchaseOrders
PurchaseOrderLines
GoodsReceipts
GoodsReceiptLines
ReceiptAcceptances
BillMatches

Inventory & locations

Products, UnitsOfMeasure, ProductUnits, Warehouses, Locations, Lots, LotPortions, Serials, ShelfLifePolicies, LotDateEvents, InventoryPositions, StockLayers, StockEvents, StockMovements, InventoryReservations, StockTransfers, StockTransferLines, CountLocks, InventoryCounts, CountLines, Returns, ReturnLines, ReturnDispositions, SupplyCheckPlans, SupplyCheckCriteria, SupplyChecks, SupplyCheckResults, SupplyHolds, SupplyDispositions.

Products
UnitsOfMeasure
ProductUnits
Warehouses
Locations
Lots
LotPortions
Serials
ShelfLifePolicies
LotDateEvents
InventoryPositions
StockLayers
StockEvents
StockMovements
InventoryReservations
StockTransfers
StockTransferLines
CountLocks
InventoryCounts
CountLines
Returns
ReturnLines
ReturnDispositions
SupplyCheckPlans
SupplyCheckCriteria
SupplyChecks
SupplyCheckResults
SupplyHolds
SupplyDispositions

Supply-pack assembly

BOMs, BOMLines, ProductionRoutings, RoutingOperations, WorkOrders, WorkOrderMaterials, WorkOrderOperations, ProductionEntries, ProductionCompletions, WorkOrderCostEntries, BatchMaterialAllocations, BatchReconciliations.

BOMs
BOMLines
ProductionRoutings
RoutingOperations
WorkOrders
WorkOrderMaterials
WorkOrderOperations
ProductionEntries
ProductionCompletions
WorkOrderCostEntries
BatchMaterialAllocations
BatchReconciliations

Sales & billing

Accounts, ContactPersons, PaymentTerms, PriceLists, PriceListEntries, Quotes, QuoteLines, SalesOrders, SalesOrderLines, SalesAllocations, CreditReviews, PickTasks, Shipments, ShipmentLines, DeliveryConfirmations.

Accounts
ContactPersons
PaymentTerms
PriceLists
PriceListEntries
Quotes
QuoteLines
SalesOrders
SalesOrderLines
SalesAllocations
CreditReviews
PickTasks
Shipments
ShipmentLines
DeliveryConfirmations

Intercompany supply

IntercompanyAgreements, IntercompanyOrders, IntercompanyOrderLines, IntercompanyTitleAllocations, IntercompanyDocumentAllocations, IntercompanySettlements, IntercompanySettlementAllocations, IntercompanyReconciliations.

IntercompanyAgreements
IntercompanyOrders
IntercompanyOrderLines
IntercompanyTitleAllocations
IntercompanyDocumentAllocations
IntercompanySettlements
IntercompanySettlementAllocations
IntercompanyReconciliations

Finance

Entities, Currencies, ExchangeRates, AccountingPeriods, ChartOfAccounts, TaxCodes, StandardCosts, PostingProfiles, Invoices, InvoiceLines, Bills, BillLines, CashReceipts, CashApplications, CreditApplications, Refunds, FinanceCorrections, BankAccounts, BankStatementLines, PaymentRuns, Payments, PaymentAllocations, RevaluationRuns, RevaluationLines, JournalEntries, JournalLines, CloseTasks.

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

Reporting

Users, HealthcarePolicies, MasterChanges, DocumentRevisions, ApprovalDecisions, AuthorityDelegations, IntegrationEvents, IntegrationDeliveries, MigrationBatches, MigrationItems.

Users
HealthcarePolicies
MasterChanges
DocumentRevisions
ApprovalDecisions
AuthorityDelegations
IntegrationEvents
IntegrationDeliveries
MigrationBatches
MigrationItems

Keys and references

Each record has a stable identity and its required company scope. Facility and department identify where work belongs without combining legal ownership. Products retain explicit units and source tracking where required. References connect a real quantity, decision or financial effect to the source it can consume.

Current stock belongs to actual leaf populations; aggregate lot and movement history explains lineage rather than another available balance. Requests, reservations, transfers, actual use and issued assembly WIP have separate meanings. An assistant or import cannot turn missing physical evidence into a completed event.

Intercompany links retain exact seller and buyer identities and local document lines. Actual destination acceptance changes ownership once, while each company records its own approved accounting result. Pending counterpart posting remains a reconciliation state, with durable successful-result keys that prevent replay. A shared pair never becomes a cross-company journal or extra revenue/stock balance.

Migration order

Establish companies and policy
Ends with: Reconcile legal entities, facilities, departments, users, currencies, accounts and independent authority. Configure the reciprocal parties and destination-acceptance terms for each selected intercompany relationship.
Prepare products and work
Ends with: Verify units, tracking, source dates, stock locations, assembly instructions, required checks and standards. Retain actual current identities rather than inventing history to satisfy an import.
Reconcile opening sources
Ends with: Match current stock, owned transit, issued WIP and open commercial/financial balances to one approved opening ledger per company. Import counterpart order, title, document and settlement detail as nonposting history with consumed claims preserved.
Activate current work
Ends with: Resolve required differences and verify native requests, receipts, assembly, consumption, billing and intercompany recovery. Repeated pre-cutoff events cannot execute earlier quantity or financial effects again.

Tables

Find a table 117 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 twelve declared roles: Admin, Department Coordinator, Supply Coordinator, Supply Manager, Purchasing Manager, Warehouse Operator, Warehouse Manager, Assembly Operator, Assembly Manager, Quality Reviewer, Accountant, Finance Manager. Real company/facility/department/task scope and actual-person independence apply; services cannot approve.
`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.
`FacilityScope`	longtext	yes	Explicit Facilities/Departments and permitted action/purpose scope; no clinical/patient data is needed. Shared group membership is not authority for the other company.

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

CurrenciesCurrency precision and display rules.master

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

ExchangeRatesImmutable dated conversion evidence; no hidden fallback.master

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

AccountingPeriodsEntity-specific fiscal periods and guarded close.master

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

ChartOfAccountsEntity ledger accounts, including controlled subledger accounts.master

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

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

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

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

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

HealthcarePoliciesVersioned 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 finite entity/warehouse/action/person limits, current source snapshots, BOM/input-unit scaling, held-owned valuation, quality/date/population rules, selected standard costs, accepted net prices and conservative unknown-state handling. Technical privilege never grants product/financial release.
`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, DestinationAcceptance. ExternalGoods requires Handover; Intercompany requires exact approved DestinationAcceptance pair. No hidden dispatch-title intercompany route.
`PreparedBy`	reference	yes	→ Users. Admin prepares configuration; respective Supply Manager, Purchasing Manager, Warehouse Manager, Assembly Manager and Finance Manager decisions exclude material preparers/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 Assembly Manager BOM/routing/actual work, safe-use and terminal-output rules.
`CommercialDecision`	reference		→ ApprovalDecisions. Independent Supply Manager commercial/remaining-life policy; Quality Reviewer separately approves restriction/date implications.
`QualityDecision`	reference		→ ApprovalDecisions. Independent Quality Reviewer supply/check/portion/date policy, excluding criteria/preparer/material editors.
`SupplyRules`	longtext	yes	Required nonclinical supply provenance/checks, current identified populations, overlapping restrictions, original dates and remaining-life rules. No clinical patient, sterile process or medical safety claim.
`IntercompanyRules`	longtext	yes	Separate legal parties, actual independent seller/buyer approvals, destination-acceptance title and reciprocal return title, common commercial currency, separate local result/recovery and current carrying. Same actual person cannot sign both required company approvals; no automatic netting/consolidation.

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 Supply Manager facility/customer/commercial, Purchasing Manager supplier, Warehouse Manager custody/units, Assembly Manager technical BOM/routing, Quality Reviewer supply/date/check restrictions and Finance Manager money/cost/tax/bank/authority. All required exact snapshot decisions exclude relevant preparers/material editors.
`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 Assembly Manager decision.
`FinanceDecision`	reference		→ ApprovalDecisions. Required independent Finance Manager for costs/limits/beneficiary/tax/posting/price-floor changes.
`CommercialDecision`	reference		→ ApprovalDecisions. Required independent Supply Manager for customer/price commercial changes.
`ProductionDecision`	reference		→ ApprovalDecisions. Independent Assembly 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, StockRelease, TransferApproval, CountAdjustment, ReturnAuthorization, ReturnDisposition, ShipmentRelease, ProductionRelease, ProductionTimeAcceptance, ProductionCompletion, ProductionVariance, ProductionClose, ProductionCloseFinance, QualityRelease, QualityDisposition, DateApproval, DateReassessment, JournalApproval, RevaluationApproval, PeriodClose, PeriodReopen, MigrationActivation, DepartmentRequest, DepartmentUse, SupplyAcceptance, IntercompanyAgreement, IntercompanyReconciliation
`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/facility/department/warehouse/portion, quantity/value/currency and applicable date/authority. Exclude actual preparer/material editors and relevant producer/receiver/observer. Factual receiving recorder may confirm acceptance if independent of purchasing; separate quality reviewer remains independent of observer. Intercompany requires distinct actual seller and buyer approvers; one person with both scopes cannot satisfy both.
`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	Supply Manager, Purchasing Manager, Warehouse Manager, Finance Manager
`ActionScope`	longtext	yes	Exact actions/entities/warehouses and excluded documents.
`LimitCurrency`	reference	yes	→ Currencies. Authority currency.
`AmountLimit`	decimal	yes	Finite nonnegative ceiling; cannot exceed principal authority.
`StartsAt`	datetime	yes	Inclusive.
`EndsAt`	datetime	yes	Exclusive.
`Status`	select	yes	Draft, Active, Revoked, Expired
`GrantedBy`	reference	yes	→ Users. Independent same-domain authorized owner; no self-grant or approval escalation.

IntegrationEventsAuthenticated inbound/manual evidence with idempotent economic effects.transaction

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

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

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`BatchNumber`	text	yes	Stable import identity.
`Status`	select	yes	Draft, Validating, PendingApproval, Approved, Applied, Rejected
`CutoffAt`	datetime	yes	Frozen source/system watermark.
`SourceHash`	text	yes	Immutable extraction digest.
`OpeningJournal`	reference	yes	→ JournalEntries. Single full opening journal including subledger controls; detail never reposts it.
`Reconciliation`	longtext	yes	One company opening GL versus nonposting current stock/transit/WIP, actual original lots/portions/dates, restrictions, performed deliveries/department use and open finance/carrying/prior FX. Paired intercompany originals and local effect statuses reconcile at both cutoffs without replay. No clinical, patient or hotel source is required.
`PreparedBy`	reference	yes	→ Users. Actual preparer.
`Decision`	reference		→ ApprovalDecisions. Independent Finance Manager activation plus Warehouse Manager stock and Assembly Manager work/Quality Reviewer restrictions; each intercompany side separately approves its opening and paired source reconciliation. Required before Applied, never replay imported history.
`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, SupplyHolds, ShelfLife, Tax, Credits, UnappliedCash, Revaluation, Interfaces, Intercompany
`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 actual customer counterparty with accepted commercial and credit terms.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; legal party and monetary entitlement cannot be inferred merely from matching display names.
`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 in CreditCurrency, required before credit trading; unknown is not unlimited. Separately attributed prepayments cannot reduce more than one exposure.
`TaxEvidence`	longtext		Exemption/resale documentation and review scope; not automatic compliance proof.
`Activation`	reference		→ MasterChanges. Independent Supply Manager commercial and Finance Manager credit/tax approval as applicable.
`RelatedEntity`	reference		→ Entities. Explicit intercompany trading counterparty; still separate legal documents, no automatic elimination.
`Owner`	reference	yes	→ Users. Supply Coordinator responsible for assigned customer relationships, not authority to transfer cash across counterparties.

ContactPersonsActual customer business contacts and purposes, separate from application users and signers.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	Mass, Volume, Count, Time
`DecimalPlaces`	number	yes	Permitted nonnegative precision; indivisible unit has zero.
`Status`	select	yes	Active, Inactive

ProductsOne stocked SKU and fixed base-unit identity for each actual nonclinical supply, component or assembled pack.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	Required only where the reviewed supply SKU policy requires actual lot provenance; serial/date/portion identity then mandatory before affected use/title/output. Untracked ordinary supplies remain truly untracked. Missing required history cannot be replaced by fabricated medical or food lot data.
`Status`	select	yes	Draft, Active, OnHold, Inactive
`ProductKind`	select	yes	Stock, Assembled, Repacked
`Activation`	reference		→ MasterChanges. Independent Warehouse Manager SKU/unit/tracking, Supply Manager commercial, Assembly Manager BOM/routing and Quality Reviewer source/expiry/pack-integrity controls, with Finance Manager financial setup. Separate actual required owners sign exact scope.
`SerialControlled`	boolean	yes	Each serialized position/effect identifies exactly one base unit; all accepted unit/pack conversions preserve it.
`Kind`	select	yes	Supply, Packaging, PackComponent, AssembledPack
`ShelfLifePolicy`	reference		→ ShelfLifePolicies. Current approved default; received/released batches freeze actual applicable version, not retrospectively replaced.

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.
`ConversionEvidence`	longtext	yes	Reviewed fixed same-dimension factor or fixed pack-to-product-base count; no density, potency or catch-weight assumptions. Both source and target dimensions/pack contents are retained.

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 Supply 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 Assembly 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.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`Department`	reference		→ Departments. Actual custody department in the same property; transfer here alone does not record expense or service.

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. Supply Coordinator.
`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		Actual customer acceptance bound to complete quote revision, quantity/net/tax/currency/terms/recipient; never an internal status substitute.
`Decision`	reference		→ ApprovalDecisions. Required commercial price/margin exception decision by independent Supply Manager; routine within-policy quote sending is Supply Coordinator preparation, not the mandatory order gate.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.

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. Supply Coordinator preparing order.
`Terms`	reference	yes	→ PaymentTerms. Frozen accepted terms.
`ShipTo`	longtext	yes	Frozen actual delivery/handover location, entitled recipient and contact evidence; carrier and customer handover requirements follow the selected mode.
`TitleRule`	select	yes	Handover, DestinationAcceptance. ExternalGoods uses actual customer handover/carrier dispatch. Intercompany uses only confirmed destination acceptance on the paired source; seller owns transport, no COGS at dispatch.
`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 Supply Manager approval time bound to exact customer acceptance, prices, address, title rule and quantities.
`ShipmentMode`	select	yes	Carrier, CustomerHandover
`ReplacementFor`	reference		→ Returns. Separately accepted replacement demand for a reviewed original return; never reopens already handed-over old order quantity automatically.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`SourceRoute`	select	yes	ExternalGoods, Intercompany. Intercompany classifies this existing company effect; pair reports do not add another invoice, bank or GL balance.
`IntercompanyOrder`	reference		→ IntercompanyOrders. Required selected paired seller order. Different actual company signers and exact current shared revision remain mandatory.

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
`MinimumLifeRule`	longtext	yes	Actual approved customer/product remaining-life requirement with calendar unit, date/expiry or best-before meaning, delivery-date basis and transport allowance. Missing required evidence blocks approval/allocation; no universal shelf-life rule.
`AgreedDeliveryAt`	datetime		Current accepted actual delivery target used for remaining-life eligibility; revised target invalidates unexecuted affected claim/dispatch eligibility without overwriting OriginalPromiseAt.

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`AllocationNumber`	text	yes	Stable scope identity.
`OrderLine`	reference	yes	→ SalesOrderLines. Exact accepted line.
`ShipmentLine`	reference		→ ShipmentLines. Actual scoped fulfillment.
`InvoiceLine`	reference		→ InvoiceLines. One billing claim or correction.
`Kind`	select	yes	Shipment, Billing, Cancellation, Correction
`Status`	select	yes	Reserved, Posted, Released, Reversed
`BaseQuantity`	decimal	yes	Positive allocated base quantity, never beyond eligible remaining source.
`NetAmount`	decimal	yes	Order-currency accepted net allocated once, zero only for nonbilling quantity claim.
`TaxAmount`	decimal	yes	Scoped tax allocation; differences retained with approved basis.
`CreatedAt`	datetime	yes	Claim time.
`PostedAt`	datetime		Actual effect time.
`ReversalOf`	reference		→ SalesAllocations. Exact prior scope; cannot reopen shipped/billed demand without controlled correction.

CreditReviewsAtomic 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; Supply 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, Assembly 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.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`SourceRoute`	select	yes	ExternalPurchase, Intercompany
`IntercompanyOrder`	reference		→ IntercompanyOrders. Required selected paired buyer commitment; current reciprocal seller and buyer revisions independently approved.

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

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

GoodsReceiptsImmutable actual arrivals and separately accepted quantities.transaction

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

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.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.
`IntercompanyLine`	reference		→ IntercompanyOrderLines. Buyer actual arrival for paired source. Custody arrival before acceptance creates no buyer-owned inventory/GRNI; exact accepted tranche participates in one global title allocation.

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.
`IntercompanyDocument`	reference		→ IntercompanyDocumentAllocations. Exact paired reciprocal bill allocation where applicable, sharing the SAME existing receipt/match claim. Pair linkage creates no second matching availability or GRNI relief.

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	Current legally owned physical quantity: BookQuantity minus confirmed outgoing pending local title effect plus incoming pending effect. Corresponding IntercompanyTitleAllocations has one owner; when a local effect posts, BookQuantity changes and its pending overlay clears atomically with no physical jump. Avoid double counting buyer acquired scope and seller transit during recovery.
`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	Current legally owned eligible quantity less active claims. All confirmed-title pending-post/uncertain/cost-unknown incoming or outgoing scope remains restricted from use/resale until required local/peer effects reconcile; no duplicate availability from book quantity plus title overlay.
`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.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.
`PendingTitleOutQuantity`	decimal	yes	Confirmed intercompany ownership-out quantity whose local stock/book effect is not yet Posted. Excluded from current owned/available physical population, retained as pending accounting reconciliation and exclusive source claim.
`PendingTitleInQuantity`	decimal	yes	Confirmed ownership-in quantity whose local effect is not yet Posted. Counted once as owned physical scope but unavailable until local source/carrying and required peer effects reconcile; never added again after posting.
`BookQuantity`	decimal	yes	Net locally posted StockMovements quantity before the explicit pending-title physical overlay. QuantityOnHand equals BookQuantity minus PendingTitleOutQuantity plus PendingTitleInQuantity. This book-control basis is not a second owned-stock measure.

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	Nonnegative locally posted layer quantity before pending-title overlay. PendingTitleOutQuantity is exclusively claimed, excluded from current owned/available physical stock and displayed as pending accounting relief; pending incoming is not added to layer twice when local acquisition posts.
`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.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.
`PendingTitleOutQuantity`	decimal	yes	Confirmed intercompany ownership-out quantity whose local stock/book effect is not yet Posted. Excluded from current owned/available physical population, retained as pending accounting reconciliation and exclusive source claim.
`PendingTitleInQuantity`	decimal	yes	Confirmed ownership-in quantity whose local effect is not yet Posted. Counted once as owned physical scope but unavailable until local source/carrying and required peer effects reconcile; never added again after posting.
`PendingTitleValue`	decimal	yes	Own-company carrying awaiting missing title accounting effect, disclosed separately from currently owned physical stock. Never count outgoing pending value as a second legal owner or fabricate incoming valuation. Close cannot hide unmatched ownership/books.

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, PortionSplit, DepartmentUse, IntercompanyDispatch, IntercompanyReturnDispatch
`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.
`Portion`	reference		→ LotPortions. Affected source population for split/status/date-driven eligibility; actual movement rows retain exact source/destination leaves.
`IntercompanyTitle`	reference		→ IntercompanyTitleAllocations. Exact global accepted title/direction and unique own-company result key. Source company/amount/kind checks prevent triggering both local effects or replaying successful side during recovery.

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 product base quantity; zero for explicit value-only event. Same-lot PortionSplit balances parent/child quantities and carrying without new output/GL; quality release changes eligibility without another quantity/value posting.
`ValueDelta`	decimal	yes	Signed functional carrying value; no invented stock value.
`Reservation`	reference		→ InventoryReservations. Demand claim being transferred/consumed.
`ShipmentLine`	reference		→ ShipmentLines. Exact dispatch/title portion if applicable.
`ReturnLine`	reference		→ ReturnLines. Exact return source if applicable.
`VersionBefore`	number	yes	Expected position version; new identity checked in locked scope.
`Lot`	reference		→ Lots. Exact same entity/product lot, required when lot-controlled; display values derive from this identity.
`Serial`	reference		→ Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.

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 sales, production-material, transfer or department-use demand owner. Sales Hard/Picked/TitleIssue requires independent Supply Manager-approved order; production requires independent Assembly Manager work release; transfer and DepartmentUse require independent Warehouse Manager exact approval. All claims require current ownership/portion/date/fitness; no sales-order fiction for other demand.
`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 unperformed claim expiry only after approved source/uncertainty review. Picked/transit scope never auto-releases; new hold/expiry blocks execution while reservations remain reconciled.
`Replaces`	reference		→ InventoryReservations. Soft→Hard conversion replaces rather than adds a second claim.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.
`EligibilitySnapshot`	longtext	yes	Exact portion/revision/all applicable holds/date-policy/current effective expiry/opening/customer delivery-date basis and remaining-life test. Recheck at claim, conversion, issue, packing and actual handover; later hold/expiry blocks execution without erasing reservations/performed work.
`DepartmentUseLine`	reference		→ DepartmentUseLines. Exactly one demand family alongside OrderLine, WorkOrderMaterial or TransferLine. Requires independent Warehouse Manager DepartmentUse approval and current portion/fitness/date eligibility; never fictitious sales approval.

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.
`RequestLine`	reference		→ DepartmentRequestLines. DeliverToDepartment demand only; multiple partial source lines retain durable backlinks and shared requested quantity claims. Actual destination receipt fulfills that scope once; subsequent use does not fulfill it again.

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

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

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

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

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

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`PickNumber`	text	yes	Unique assigned task.
`OrderLine`	reference	yes	→ SalesOrderLines. Approved demand.
`Reservation`	reference	yes	→ InventoryReservations. Exact hard claim.
`Status`	select	yes	Assigned, InProgress, Picked, PartiallyPicked, Exception, Cancelled
`AssignedTo`	reference	yes	→ Users. Warehouse Operator.
`PlannedStart`	datetime	yes	Work window start.
`PlannedEnd`	datetime	yes	Work window end.
`PickedQuantity`	decimal	yes	Actual base quantity; unused reservation remains explicit.
`PickedAt`	datetime		Actual confirmation.
`StockEvent`	reference		→ StockEvents. Internal movement into picked custody only.
`EligibilityEvidence`	longtext	yes	Current exact portion quality, expiry/open-life, customer-delivery-date and remaining-life requirements; earliest-expiring eligible suggestion never substitutes for actual recheck at picking/packing/handover.

ShipmentsApproved customer shipment/customer handover scope with actual title evidence, not a documentary bank event.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`ShipmentNumber`	text	yes	Unique shipment.
`Order`	reference	yes	→ SalesOrders. One current independently approved same-entity customer order and its actual recipient/delivery terms; partial shipment lines consume exact remaining accepted order allocations.
`Warehouse`	reference	yes	→ Warehouses. Actual dispatch site.
`Mode`	select	yes	Carrier, CustomerHandover
`Status`	select	yes	Planned, Picking, Ready, HandedOver, InTransit, PartiallyDelivered, Delivered, Exception, Closed, Cancelled
`TitleRule`	select	yes	Handover, DestinationAcceptance. Frozen from approved order. For Intercompany, actual dispatch moves seller-owned stock to owned transit and only destination title allocation later issues cost; no ordinary handover fallback.
`CarrierReference`	text		Configured external handoff reference; no carrier booking claim.
`HandedOverAt`	datetime		Actual dispatch/customer handover evidence. For destination-title intercompany this is transport/custody departure only, not ownership transfer or COGS.
`HandoverEvidence`	longtext		Actual carrier/customer/recipient/location/time and exact portion/lot/serial quantities, current quality/date/remaining-life evaluation and preserved labels. Unknown or expired eligibility cannot be overridden by a ready status.
`ClosedAt`	datetime		All line quantities delivered/returned/lost/resolved with remaining ownership reconciled.
`Decision`	reference		→ ApprovalDecisions. Current exact independent action/scope/revision decision; required before corresponding approved effect.
`ReleasedBy`	reference		→ Users. Independent Warehouse Manager readiness approval, excluding packet preparer/material editor.
`ReleasedAt`	datetime		Actual approval before execution; new material scope invalidates unexecuted release.

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

Field	Type	Required	Details
`Shipment`	reference	yes	→ Shipments. One order.
`OrderLine`	reference	yes	→ SalesOrderLines. Same order only.
`Reservation`	reference	yes	→ InventoryReservations. Exact picked claim and layer identity.
`BaseQuantity`	decimal	yes	Actual assigned/shipped quantity, bounded by claim and accepted unfulfilled source.
`DispatchedQuantity`	decimal	yes	Cumulative actual departed quantity across supported modes; not universally title-transferred. Permanent history is retained through returns.
`TitleTransferredQuantity`	decimal	yes	ExternalGoods: exact actual Handover TitleIssue. Intercompany: sum confirmed forward IntercompanyTitleAllocations for actual destination-accepted quantities; pending local journal state does not undo physical title. No excess over actual dispatched/approved unfulfilled remainder.
`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. External Handover TitleIssue or IntercompanyDispatch seller-owned transit custody event. For destination-title, a later separate confirmed title source owns cost once; POD never duplicates it.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.
`IntercompanyLine`	reference		→ IntercompanyOrderLines. Required intercompany shipment mapping, sharing exact seller order and global quantity claims.

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

Field	Type	Required	Details
`ShipmentLine`	reference	yes	→ ShipmentLines. Exact actual dispatched source. External Handover delivery confirmation has no second title effect. Intercompany actual accepted destination evidence must agree with buyer ReceiptAcceptance and IntercompanyTitleAllocation; transport acknowledgment/refusal alone never transfers title.
`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. Retry requires remaining goods confirmed undelivered and in evidenced custody after reconciliation; unknown/disputed scope stays held, never retry authority. Restock does not reopen 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; shipment, actual customer, stock ownership and 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. Warehouse Operator with actual source/recipient evidence; disputed identity/outcome requires Warehouse Manager review.
`RecipientEvidence`	longtext	yes	Proof of actual intended customer or authorized recipient, location, event time and scoped quantities; never infer delivery from a bank document or approval.

BOMsVersioned nonsterile standard supply-pack BOM for one primary output, with independent technical and applicable supply-quality approval.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 BOM 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 Assembly Manager technical pack/BOM/routing and Quality Reviewer required source/pack/date controls; Finance Manager frozen cost standards/rates. Exclude preparers/material editors.
`QualityPlan`	reference	yes	→ SupplyCheckPlans. Compatible active in-process/final specification; different required checks listed in QualityPrerequisites.
`ScalingRule`	longtext	yes	Target primary pack output divided by frozen OutputBaseQuantity applied to each component in its own fixed unit/pack factor; retain deterministic rounding and actual component quantities. No density, potency or mixed-unit sum.
`QualityPrerequisites`	longtext	yes	Exact reviewed nonclinical component/pack integrity, source/date and process/area checks. Assembly is nonsterile standard supply-pack preparation; no clinical procedure kit, sterilization or safety certification.

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

Field	Type	Required	Details
`BOM`	reference	yes	→ BOMs. Versioned BOM.
`LineNumber`	number	yes	Stable component identity.
`Component`	reference	yes	→ Products. Input SKU; cycles forbidden across active BOMs.
`BaseQuantity`	decimal	yes	Positive input base quantity per BOM output basis.
`PlannedScrapPercent`	decimal	yes	Known nonnegative planning allowance only when LossBasis AdditionalInputPercent; otherwise0. Applied once to this line input requirement, not again to output yield. Actual use/loss is separately measured.
`Instruction`	longtext	yes	Material grade/lot substitution restrictions; substitutions require reviewed new scope.
`Kind`	select	yes	Ingredient, Packaging
`RoundingRule`	longtext	yes	Per-line unit precision, whole-pack restrictions and authorized deviation; no rounding components into an incompatible packaging count.
`LossBasis`	select	yes	None, AdditionalInputPercent, IncludedInReferenceInput
`DeclarationSnapshot`	longtext	yes	Exact reviewed component/specification/pack integrity and original date constraints; substitutions require independent BOM/work revision and applicable Quality Reviewer conditions, never silent free-text replacement.

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 BOM version.
`Version`	number	yes	Immutable technical version.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Assembly 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	Concrete batch preparation/processing/packing operation.
`Instructions`	longtext	yes	Frozen actual process/changeover/cleaning/check/pack instructions with measurement units and evidence prerequisites; no implicit validated safety method or full QMS 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 BOM 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. Assembly Manager; independent of the relevant request preparer/material editors.
`ReleasedAt`	datetime		Actual independent Assembly 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 physically accepted terminal ProductionCompletions, including valued held output; quality-released availability separately derived from exact portions. No intermediate/rework sum.
`RemainingWIP`	decimal	yes	Sum signed posted WorkOrderCostEntries, reconciled independently from unissued inventory.
`CloseDecision`	reference		→ ApprovalDecisions. Mandatory independent Assembly 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.
`BatchNumber`	text	yes	Unique actual internal production batch identity, linked to BOM/work order; not a duplicate inventory or cost owner.
`ShelfLifePolicy`	reference	yes	→ ShelfLifePolicies. Exact output policy version frozen at batch release.
`QualityPlan`	reference	yes	→ SupplyCheckPlans. Frozen applicable plan plus every additional prerequisite in released snapshot.
`AssemblySnapshot`	longtext	yes	Frozen nonsterile standard pack BOM/routing, per-component unit factors, source control/expiry constraints, one output and required supply checks. No clinical kit or sterile-process claim.
`QualityDecision`	reference		→ ApprovalDecisions. Independent Quality Reviewer required component/process/pack/date prerequisites, distinct from Assembly Manager technical release. Physical valued Held terminal output may precede final eligibility decision.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.

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	Target output divided by frozen BOM reference output, times this line input base quantity and only applicable planning-loss factor once; per-line rounding retained, never mixed-dimension sum.
`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.
`RequirementBasis`	longtext	yes	Frozen component/packaging kind, original and converted unit/dimension, scale factor, reference quantity, planning allowance and rounding; actual deviation requires current review.

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 Assembly Operator; Assembly 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 Assembly 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	Physically accepted completed throughput in the declared operation/output unit, including output still quality-held. Quality status is separate; no mixed-component sum or intermediate quantity counted as finished stock.
`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 Assembly 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 Assembly 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	Exact prior operation/batch source scope and actual BatchMaterialAllocations. Output-equivalent flow only uses compatible output units. Ingredient mass, liquid volume and packaging count each reconcile separately; process loss/measurement basis is in BatchReconciliations. Never enforce a false kg+L+each equality; rework preserves original units/history.
`HeldQuantity`	decimal	yes	Physically incomplete/unconfirmed operation scope in declared output-equivalent unit; excluded from physical terminal completion until independently confirmed. Distinct from physically completed valued output held only for pending quality.
`UnfinishedQuantity`	decimal	yes	Nonnegative physically unfinished operation scope in its declared compatible output unit, disjoint from GoodQuantity, ScrapQuantity and HeldQuantity. Reconcile output scope and measured processing loss in BatchReconciliations; never impose mixed-input = output equality or count evaporation twice.
`MeasureUnit`	reference	yes	→ UnitsOfMeasure. Compatible declared operation/output unit for throughput; distinct component units remain on material allocations.
`ProcessEvidence`	longtext	yes	Actual BOM/operation, observed processing conditions, changeover/cleaning and measured loss/sampling facts; required SupplyChecks own their actual criterion results.

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 independently accepted PHYSICAL terminal output, possibly held pending quality; no intermediate or unconfirmed quantity.
`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 Assembly Manager excluding actual producer, recorder, completion preparer/material editors; confirms exact physical terminal scope and condition evidence. Quality eligibility may remain Held pending separate Quality Reviewer decision.
`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	Independent physical completion/quantity/label evidence; actual product quality eligibility is separate. Held owned output can be valued into a held portion pending tests, but unknown physical identity or cost blocks posting.
`OutputPortion`	reference		→ LotPortions. Required actual new output leaf where OutputProduct is lot-controlled; nullable genuine untracked pack output with exact StockEvent/position/layer identity. No fabricated lot to post ordinary administrative packs; required controlled date/provenance cannot be bypassed.
`OutputEligibility`	select	yes	Held, Released
`QualityBasis`	longtext	yes	Default Held pending required independent Quality Reviewer release. Released only if every required specification/date/lineage/hold condition covers the exact output population; no whole-population release from one passing sample.
`Reconciliation`	reference		→ BatchReconciliations. Required terminal physical/material/packaging/yield/cost reconciliation before posting; may retain named unresolved quality decisions while owned output stays held.

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		Exact positive source-entry quantities/current original issue basis/cost and linked BatchMaterialAllocations. Output allocation consumes already used/normal-loss sources once; abnormal scrap and unused return have distinct eligible claims. Sum matches actual WIP relief; no cost or quantity duplicated across partial output/loss. Normal process loss included in output is not another scrap expense.
`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.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.

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.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`SourceRoute`	select	yes	ExternalGoods, Intercompany

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

Field	Type	Required	Details
`Return`	reference	yes	→ Returns. Authorized direction.
`ShipmentLine`	reference		→ ShipmentLines. Customer source; required unless controlled migration source preserved in baseline.
`ReceiptLine`	reference		→ GoodsReceiptLines. Supplier source; exact original accepted quantity/descendants.
`OriginalInvoiceLine`	reference		→ InvoiceLines. Customer original billing scope if invoiced.
`OriginalBillLine`	reference		→ BillLines. Supplier billed scope; null only wholly unmatched receipt portion. Split mixed billed/unbilled return scope.
`AuthorizedQuantity`	decimal	yes	Positive base quantity bounded by original net unreturned scope.
`ActualQuantity`	decimal	yes	Actual physical received/dispatched quantity, bounded by authorization.
`OriginalIssuedValue`	decimal		Original title-issue carrying value for post-title customer return; null before title or for supplier scope, never fabricated zero.
`CurrentRemovalValue`	decimal	yes	Current descendant carrying for supplier return; intercompany buyer keeps this value in its own return transit until actual seller acceptance. Before initial forward destination title, seller custody returns are internal movement without sale/COGS reversal. External Handover cancellation follows original custody rule.
`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 authorized custody or owned-stock effect once. IntercompanyReturnDispatch is buyer-owned transit movement, not SupplierReturn value relief; confirmed reverse title owns later buyer SupplierReturn and seller CustomerReturn results.
`ReceiptAcceptance`	reference		→ ReceiptAcceptances. Required for supplier return of accepted owned goods; binds original posted tranche/descendants, rather than gross arrival.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.
`IntercompanyLine`	reference		→ IntercompanyOrderLines. Original bilateral source; buyer supplier-return and seller customer-return retain distinct local records linked by the exact reverse TitleAllocation.
`IntercompanyTitle`	reference		→ IntercompanyTitleAllocations. ReturnAcceptance transition after actual seller acceptance. Buyer return dispatch retains buyer-owned transit/current carrying; actual seller acceptance removes buyer current and restores seller original issue basis once.

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 seller title-issue cost for customer restock; current buyer receipt-descendant carrying for supplier return. Intercompany reverse title occurs only on seller destination acceptance, with separate company values. Before forward title, return of seller-owned transit is custody only, no COGS reversal.
`Destination`	reference		→ Locations. Actual held/restocked destination, same entity/warehouse scope; new assembly/rework requires separately released production scope.
`PreparedBy`	reference	yes	→ Users. Warehouse Operator observations.
`DecidedAt`	datetime		Independent WM disposition; FM additionally authorizes loss/value exception. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`StockEvent`	reference		→ StockEvents. No physical/economic effect from status alone.

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`InvoiceNumber`	text	yes	Unique legal document.
`Account`	reference	yes	→ Accounts. Same entity.
`DocumentType`	select	yes	Invoice, CreditNote
`OriginalInvoice`	reference		→ Invoices. Required credit/correction original.
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, PartiallySettled, Settled, Disputed, Reversed, Cancelled
`InvoiceDate`	date	yes	Original legal/business date.
`PostingDate`	date	yes	Eligible date in entity Period; no closed-period rewrite.
`Period`	reference	yes	→ AccountingPeriods. Same-entity open posting period.
`DueDate`	date	yes	Frozen terms.
`NetAmount`	decimal	yes	Positive magnitude sum InvoiceLines.NetAmount; credit sign comes only from DocumentType.
`TaxAmount`	decimal	yes	Positive applicable tax magnitude, credit reverses original scoped tax.
`TotalAmount`	decimal	yes	NetAmount + TaxAmount once.
`Outstanding`	decimal	yes	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.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`SourceRoute`	select	yes	ExternalGoods, Intercompany. Intercompany classifies this existing company effect; pair reports do not add another invoice, bank or GL balance.

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 accepted goods debit source; no project/work certificate.
`ShipmentLine`	reference		→ ShipmentLines. Required actual eligible title transfer, not planned dispatch or unverified POD.
`OriginalLine`	reference		→ InvoiceLines. Required credit source.
`ReturnLine`	reference		→ ReturnLines. Physical return basis when applicable; commercial-only credit explicitly reviewed.
`BaseQuantity`	decimal	yes	Positive scoped base quantity; financial-only price correction can use zero with explicit original value basis.
`NetAmount`	decimal	yes	Allocated accepted order net once, or bounded original credited net; no second discount deduction.
`TaxAmount`	decimal	yes	Correct eligible tax basis/rate/exemption snapshot, not unreviewed default zero.
`TaxEvidence`	longtext	yes	Frozen exact rule/rate/basis and original credit allocation.
`Allocation`	reference		→ SalesAllocations. Reserved then posted once with invoice.
`IntercompanyDocument`	reference		→ IntercompanyDocumentAllocations. Exact reciprocal document slice where selected; current independent company approval/match and title prerequisites remain. One pair link consumes the same local billing claim, not extra supply.

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.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.

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.
`IntercompanyDocument`	reference		→ IntercompanyDocumentAllocations. Exact reciprocal document slice where selected; current independent company approval/match and title prerequisites remain. One pair link consumes the same local billing claim, not extra supply.

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

BankStatementLinesActual external bank evidence, not inferred payment success.transaction

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Currency`	reference	yes	→ Currencies. Document currency; amounts use this currency unless stated otherwise.
`Rate`	reference	yes	→ ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`ReceiptNumber`	text	yes	Unique cash receipt.
`Account`	reference		→ Accounts. May initially be unidentified; must be attributed with evidence before application.
`BankAccount`	reference	yes	→ BankAccounts. Actual same-entity receipt account. Currency may differ from gross receipt only with exact CollectionComponents and reviewed conversion; actual bank receipt must be evidenced, never manufactured from gross proceeds.
`Status`	select	yes	Prepared, Posted, PartiallyApplied, Applied, Returned, Reversed
`ReceivedAt`	datetime	yes	Actual verified bank/cash receipt time; advice, payment request, internal approval or transport acknowledgment is not collected money.
`Period`	reference	yes	→ AccountingPeriods. Eligible posting period.
`Amount`	decimal	yes	Positive actual gross customer collection in receipt currency. Ordinary receipt equals bank cash; explicitly approved evidenced net collection plus actual bank fee uses CollectionComponents and one FinanceCorrection fee owner, not a second receipt.
`UnappliedAmount`	decimal	yes	Amount less net posted receipt-currency applications and directly receipt-funded refunds/actual returns. Credit-funded refunds preserve historical cash applications. Active reservations and disjoint held amounts reduce availability separately; 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. Actual Dr Bank/Cash and approved exact withheld fee if present / Cr UnappliedCustomer once. Later application clears that liability/AR without new bank or fee posting.
`Baseline`	longtext	yes	Opening receipt amount/applied/unapplied/carrying/FX and original source IDs, nonposting.
`SourceKind`	select	yes	Bank, Cash
`AvailabilityState`	select	yes	Clear, Unidentified, Held, ReviewRequired
`HeldAmount`	decimal	yes	Nonnegative available receipt-currency portion held outside active reservations, bounded by UnappliedAmount minus ReservedAmount. Unresolved counterparty/funding/outcome can block execution while actual evidence remains.
`CollectionDecision`	reference		→ ApprovalDecisions. Independent Finance Manager review of any nonroutine net collection/fee/source classification; actual bank evidence remains recorded pending review.
`ActualBankAmount`	decimal		Actual received cash in BankAccount currency; required before posting. Ordinary receipt equals Amount in the same currency; reviewed outright collection may have a separately evidenced deducted fee.
`ActualBankValue`	decimal		Actual net bank functional value with rate evidence; never use gross customer receipt amount as cash when a fee was withheld.
`CollectionComponents`	longtext	yes	Ordinary receipts state no deduction. Reviewed net collection retains gross customer and actual net bank currency amounts, exact FinanceCorrections BankFee source key/value and rate/current-carrying basis in one balanced journal. Charge included once, no double bank/fee entry on later application.
`SourceRoute`	select	yes	ExternalGoods, Intercompany. Intercompany classifies this existing company effect; pair reports do not add another invoice, bank or GL balance.

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. Actual confirmed same-entity/customer available receipt purpose; active applications/refunds and disjoint holds share one remaining balance.
`Invoice`	reference	yes	→ Invoices. Same customer/entity independently approved posted eligible debit and exact current carrying.
`Status`	select	yes	Reserved, Approved, Posted, Reversed, Cancelled
`ReceiptAmount`	decimal	yes	Positive cash consumed in receipt currency only.
`InvoiceCashAmount`	decimal	yes	Positive cash-funded portion in invoice currency.
`DiscountAmount`	decimal	yes	Nonnegative approved noncash settlement discount in invoice currency.
`WriteOffAmount`	decimal	yes	Nonnegative approved invoice-currency write-off; independent FM decision required.
`ReceiptRate`	reference	yes	→ ExchangeRates. Receipt currency settlement reference.
`InvoiceRate`	reference	yes	→ ExchangeRates. Invoice currency settlement reference.
`FunctionalSettlement`	decimal	yes	Reviewed equivalent cash/noncash functional value; receipt and invoice cash equivalents reconcile within explicit decimal policy.
`InvoiceCarryingReleased`	decimal	yes	Current carrying of settled total invoice quantity, proportional with final remainder.
`ReceiptCarryingReleased`	decimal	yes	Current unapplied liability carrying of consumed ReceiptAmount, not bank value.
`InvoiceFXReleased`	decimal	yes	Prior signed unrealized invoice FX in released portion.
`ReceiptFXReleased`	decimal	yes	Prior signed unapplied-liability FX in released portion.
`SettlementFXDelta`	decimal	yes	Functional noncash + ReceiptCarryingReleased − InvoiceCarryingReleased, gain-positive net application delta; cash receipt does not debit bank again.
`AppliedAt`	datetime		Actual committed application time. Absent until the real action; mandatory before the corresponding active/approved/posted state.
`Journal`	reference		→ JournalEntries. Dr unapplied liability/noncash expense and Cr AR plus delta FX, with zero-net prior FX reclassification.
`ReversalOf`	reference		→ CashApplications. Exact original allocation, carrying/FX and claimed scope restored once.

PaymentRunsFrozen payable settlement proposals and protected beneficiary snapshots.transaction

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

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`PaymentNumber`	text	yes	Stable disbursement.
`Run`	reference	yes	→ PaymentRuns. Approved exact run revision.
`Supplier`	reference	yes	→ Suppliers. Same-entity beneficiary.
`BankAccount`	reference	yes	→ BankAccounts. Actual independently authorized same-entity source cash account and payment currency.
`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 verified company bank/cash settlement time; an instruction, transport acknowledgment or approval does not set it.
`BankCarryingReleased`	decimal		Current functional cash carrying actually disposed at settlement, with exact prior FX and no second AP payment.
`Journal`	reference		→ JournalEntries. Actual confirmed cash settlement clears current AP or creates supplier prepayment once, with explicit currency/current-carrying/prior FX components.
`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 actual cash portion, reserved once before independently released settlement.
`BillCashAmount`	decimal	yes	Exact bill-currency actual settlement portion; zero only for explicit approved supplier 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	Actual company bank/cash settlement functional value with exact current-carrying, approved discount and FX components; source currency and bill currency retained separately, no external bank-funding branch.
`BillCarryingReleased`	decimal	yes	Current AP carrying of settled portion.
`BillFXReleased`	decimal	yes	Prior unrealized AP gain-positive amount, reclassified zero-net.
`SettlementFXDelta`	decimal	yes	BillCarryingReleased − FunctionalSettlement, gain-positive AP delta; bank disposal FX is separate.
`SettledAt`	datetime		Actual effect time.
`ReversalOf`	reference		→ PaymentAllocations. Original settlement reversal linked to bank return; same scope cannot reopen twice.

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`CreditApplicationNumber`	text	yes	Unique economic use.
`Side`	select	yes	Customer, Supplier
`CreditInvoice`	reference		→ Invoices. Customer CreditNote; mutually exclusive with CreditBill.
`CreditBill`	reference		→ Bills. Supplier CreditNote.
`DebitInvoice`	reference		→ Invoices. Same actual customer/entity debit; no cross-party credit transfer by matching a deal label.
`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 actually settled available same-supplier prepayment, XOR CreditBill; exact source claim and no new cash on application.

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

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`Revision`	number	yes	Positive monotonic working revision; submitted content is immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content and material source snapshots.
`CreatedBy`	reference	yes	→ Users. Actual preparer person; material editors retained in snapshot.
`CreatedAt`	datetime	yes	Offset-aware creation timestamp.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`Decision`	reference		→ ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action.
`RefundNumber`	text	yes	Unique refund/claim.
`Direction`	select	yes	ToCustomer, FromSupplier
`CreditInvoice`	reference		→ Invoices. One customer-credit funding source.
`CashReceipt`	reference		→ CashReceipts. Alternative unapplied-customer-cash funding source; XOR CreditInvoice, never both.
`CreditBill`	reference		→ Bills. Supplier-credit collection source for FromSupplier.
`Currency`	reference	yes	→ Currencies. Actual bank/cash settlement currency; SourceAmount stays in original credit/receipt/prepayment currency.
`Amount`	decimal	yes	Positive cash amount.
`SourceAmount`	decimal	yes	Amount consumed in source document/receipt currency, separate from bank currency.
`SourceCarrying`	decimal	yes	Current functional funding value released.
`RateEvidence`	longtext	yes	Exact equivalent amount, bank carrying and prior FX reclassification basis.
`BankAccount`	reference	yes	→ BankAccounts. Required actual same-entity cash account with protected recipient/funding route.
`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 cash/current carrying once plus reviewed FX; credit-funded refund preserves original receipt and cash applications.
`SupplierPrepayment`	reference		→ Payments. Alternative FromSupplier funding collection; XOR CreditBill.
`Method`	select	yes	Bank, Cash
`SourceRoute`	select	yes	ExternalGoods, Intercompany. Intercompany classifies this existing company effect; pair reports do not add another invoice, bank or GL balance.

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, SupplierRefundReceipt
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, Rejected, Uncertain
`SourceTable`	text	yes	Exact existing source type.
`SourceKey`	text	yes	Original immutable source/effect identity.
`Scope`	longtext	yes	Exact original amount/currencies/current carrying/prior FX/tax/cost and actor/source lineage; each original claim restored once only after dependent effects reconcile. A credit/correction never releases stock quality or erases actual batch/lot history.
`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. Traced source correction only. SupplierRefundReceipt debits actual Bank/Cash plus separately evidenced withheld fee if any, credits original SupplierCredit/prepayment current carrying with incremental FX and zero-net prior FX reclassification. No new revenue, AP or third intercompany cash effect.
`SupplierCredit`	reference		→ Bills. SupplierRefundReceipt consumes exactly one same-company/supplier CreditNote remaining source, XOR SupplierPrepayment. Shared active claims with CreditApplications/refunds cannot exceed current available credit; no restoring original AP or purchasing inventory again.
`SupplierPrepayment`	reference		→ Payments. Alternative actual settled same-supplier prepayment source for SupplierRefundReceipt. Exact current remaining currency/carrying and shared claims required, not an unpaid promise.
`BankAccount`	reference		→ BankAccounts. Actual same-company incoming bank/cash account for SupplierRefundReceipt; independent actual receipt evidence required. Counterparty outgoing payment alone is not receipt.
`StatementLine`	reference		→ BankStatementLines. Actual bank evidence claimed globally once; manual cash requires independently reviewed custody proof.
`SourceAmount`	decimal		Positive original supplier-credit/prepayment currency slice, reserved exclusively until confirmed receipt or authoritative failure. Already posted consumption is not subtracted from remaining a second time.
`SourceCarryingReleased`	decimal		Exact nonnegative current source functional carrying, proportional/final remainder; source reaches zero amount/value together.
`SourceFXReleased`	decimal		Signed prior unrealized FX for this source slice, zero-net realized reclassification once.
`CashAmount`	decimal		Positive actual received bank-currency amount; no bank from counterpart approval or uncertain acknowledgment.
`CashFunctionalValue`	decimal		Actual functional bank value; difference versus source current carrying/actual fee is incremental FX, not duplicate original gain.
`ReceiptEvidence`	longtext		Actual bank/cash date/key/currency/fee/rate evidence and exact source/beneficiary. Independent Finance Manager approves finite source refund and once-only journal; uncertainty retains source claim.

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

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

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

Field	Type	Required	Details
`Run`	reference	yes	→ RevaluationRuns. Reviewed cutoff.
`SourceTable`	select	yes	Invoices, Bills, CashReceipts, BankAccounts, Payments
`SourceKey`	text	yes	Exact local open monetary source and normal balance. Each company owns its own current carrying/prior FX; intercompany comparison does not import the peer gain or net functional values.
`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, Tax, FX, Reclassification, Manual, Opening, Correction, DepartmentUse
`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. Actual same-entity cash-transfer destination with actual source/destination evidence; no second customer receipt/revenue or supplier payment.
`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 own-company stock/receipt/invoice/payment/WIP/department/FX source and rule version. Intercompany global id is lineage; the other company journal remains a separate authorized effect, never a shared or third journal.
`Facility`	reference		→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`Department`	reference		→ Departments. Actual cost/custody allocation for DepartmentUse or assembly work, not another additive journal.

ReceiptAcceptancesIndependent bounded disposition tranches against one immutable actual arrival.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; every linked monetary/owned-stock source must agree.
`OperationKey`	text	yes	Unique economic effect key; same key/hash returns same result, different content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`AcceptanceNumber`	text	yes	Unique arrival/tranche identity; duplicate callbacks reuse it.
`ReceiptLine`	reference	yes	→ GoodsReceiptLines. One immutable actual arrival line.
`Disposition`	select	yes	Accept, Reject
`Status`	select	yes	Prepared, PendingReview, Confirmed, Posted, Reversed
`BaseQuantity`	decimal	yes	Positive tranche quantity; active confirmed tranches cannot exceed arrived quantity less previous live tranches.
`StandardCost`	reference		→ StandardCosts. Required for accepted owned-stock effect; frozen version.
`ReceiptRate`	reference		→ ExchangeRates. Required dated receipt valuation multiplier.
`CommercialFunctionalValue`	decimal		Accepted scoped PO net/approved capitalizable charges at receipt rate; zero only approved known-zero basis.
`ConfirmedBy`	reference		→ Users. Actual independent Warehouse Operator, not PO buyer/commercial approver; null until confirmation and mandatory before Confirmed/Posted with required condition/cost evidence.
`ConfirmedAt`	datetime		Actual physical disposition confirmation.
`Evidence`	longtext	yes	Independent quantity/condition/ownership/cost evidence and required WM/FM exceptions; Accept may post OWNED HELD inventory/GRNI while quality tests remain pending. Reject without accepted ownership creates no owned posting. Bill receipt/match does not quality-release stock.
`StockEvent`	reference		→ StockEvents. Accepted external tranche posts owned quantity/standard/GRNI/variance once. Intercompany accepted tranche posts buyer-side acquisition under unique title BuyerEffectKey, never an additional ordinary receipt effect. Rejected/pending custody is not buyer ownership.
`ReversalOf`	reference		→ ReceiptAcceptances. Exact prior tranche only after downstream stock/match/return effects reconcile.
`Portion`	reference		→ LotPortions. Required for lot-controlled supply scope before actual receipt/claim/issue/move/count/title/return/value effect; exact nonaggregate leaf, matching product/entity/Lot. Null only genuine non-lot scope or an unconfirmed draft. Historical references survive split/consumption; current effect cannot debit a depleted ancestor.
`QualityState`	select	yes	Held, Released, Rejected
`QualityEvidence`	longtext	yes	Actual specification/portion/date/pack/storage requirements and independent Quality Reviewer release where complete; default Held for unresolved required checks. Quantity acceptance is not a supply-condition release.
`IntercompanyTitle`	reference		→ IntercompanyTitleAllocations. Required for paired forward acquisition. Actual independently accepted quantity confirms global title once; this company stock/GRNI event uses only its BuyerEffectKey. Peer delay changes recovery status, never duplicates title.

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		Optional aggregate display of most restrictive applicable known portion boundary; actual eligibility uses exact LotPortions date history, never this header alone.
`Status`	select	yes	PendingReview, Released, Held, Exhausted
`Provenance`	longtext	yes	Actual original source and all portion/split/production lineage. Header Status is aggregate display only: partial release can never authorize all lot positions; every use checks exact portion plus all ancestor/global holds and dates.
`ExternalLotCode`	text	yes	Actual supplier/manufacturer lot identity and source retained through internal population splits; internal PortionNumber is not a newly asserted external/regulatory code.
`SourceIdentity`	longtext	yes	Actual lot-code source party/location/receipt/manufacturing evidence and parent transformation genealogy; imported unknowns explicitly flagged, no invented traceability certification.
`SupplierDeclarations`	longtext	yes	Actual source supplier/component/specification/date evidence and any mismatch with approved pack requirements; unknown required history stays restrictive. No food allergen or clinical certification assumption.

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.

LotPortionsIdentifiable internal lot populations with actual segregation and source-preserving splits; not independent regulatory lot codes.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`PortionNumber`	text	yes	Unique internal population/container identity within Lot; physical marking or equivalent segregation evidence required before separate release.
`Lot`	reference	yes	→ Lots. Immutable entity/product external source-lot identity; internal split never asserts a new supplier/manufacturer lot.
`Parent`	reference		→ LotPortions. Same lot ancestor; acyclic. Parent stock is replaced by disjoint leaf children, not retained alongside them.
`IsAggregate`	boolean	yes	True for parent whose whole population was split; cannot be an active stock/reservation/issue/release leaf.
`OriginalQuantity`	decimal	yes	Immutable quantity present at this population creation in its product base unit. Split child original quantities sum the remaining physically present stock plus WIP scope being split, not already consumed/delivered history; older parent OriginalQuantity remains historical and is never added to children.
`PopulationEvidence`	longtext	yes	Actual container/segregation identities and source time, plus immutable split map of current stock, still-physical WIP and live claim slices. Splitting a parent spanning stock/WIP maps every remaining physical source to disjoint children atomically; original issued/consumed/cost history is unchanged. Historical allocations may retain ancestor IDs, while new effects prove exact descendant/source lineage.
`CurrentStockQuantity`	decimal	yes	Derived net current position quantity for this leaf only; no independent stock owner or addition of ancestors.
`CurrentWIPQuantity`	decimal	yes	Derived actual physically remaining identifiable in-process material in its own unit; issued unused stock is WIP custody, not inventory. Material lost/evaporated or incorporated into completed output is not counted as physically remaining merely because its cost stays in WIP. Financial WIP is separate.
`Status`	select	yes	PendingReview, Held, Released, Exhausted, Disposed, Aggregate
`ParentSplitEvent`	reference		→ StockEvents. One scoped split identity balances current stock movements and maps still-physical WIP/claims into disjoint leaves without new WIP cost or GL. Immutable prior issue/cost/input references remain; new actions resolve the exact descendant mapping, never debit a depleted aggregate ancestor.
`ManufacturedAt`	datetime		Current evidenced manufacture time derived from immutable applicable LotDateEvents; inherited history survives splits.
`FirstOpenedAt`	datetime		Earliest actual applicable opening for this population/ancestor; partial opening requires a separate identifiable child first.
`ExpiresAt`	datetime		Current effective expiry after all applicable source/policy/history constraints; unknown required boundary blocks use.
`BestBeforeAt`	datetime		Evidence-backed quality-date boundary, distinct from expiry and reviewed policy consequences.
`OpenLifeEndsAt`	datetime		Current first-opening plus reviewed life or earlier applicable bound; does not reset on reseal/repack.
`DateBasis`	longtext	yes	Exact applicable policy/event versions, parent inheritance, timezone/date cutoffs and reviewed corrections; no copied dates without provenance.
`Version`	number	yes	Atomic population/eligibility revision shared by splits, claims, date and hold changes.
`CreatedAt`	datetime	yes	Actual internal population creation time, not manufacture date.

ShelfLifePoliciesVersioned product-specific shelf, opening and remaining-life rules with explicit evidence and date meaning.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`PolicyNumber`	text	yes	Unique product/version.
`Product`	reference	yes	→ Products. Exact controlled item/base-unit identity.
`Status`	select	yes	Draft, PendingApproval, Active, Superseded
`EffectiveFrom`	datetime	yes	Inclusive; active policy changes do not silently rewrite existing lots/batches.
`EffectiveTo`	datetime		Exclusive.
`DateTimezone`	text	yes	Explicit location/contract timezone for date-only source cutoffs; normalized actual instants retained.
`ManufactureRequired`	boolean	yes	True when manufacture anchor is mandatory; missing date holds affected population.
`ExpiryRequired`	boolean	yes	True when actual supplier or derived expiry is mandatory.
`ShelfLifeDays`	decimal		Known nonnegative calendar-day life from actual manufacture under explicit convention; null means no derived-life rule, not indefinite fitness.
`BestBeforeDays`	decimal		Optional reviewed manufacture-based quality boundary.
`OpenLifeHours`	decimal		Known nonnegative life from first actual opening, required where selected; no reseal reset.
`BestBeforeAction`	select	yes	Block, ReviewRequired, AllowWithReviewedPolicy
`MinimumLifeRule`	longtext	yes	Product/customer constraints in compatible calendar units and actual agreed delivery-date basis. Missing required date/transport allowance is review, not unlimited shelf life.
`RepackRule`	longtext	yes	Preserve all applicable original component manufacture/expiry/opening restrictions; pack output cannot extend earliest relevant component limit. Apply any actual justified tighter output restriction. Assembly/opening is not evidence of sterility or clinical suitability.
`EvidenceRule`	longtext	yes	Actual supplier/component date and condition evidence, defined unknown handling and controlled correction; no invented universal medical shelf-life or clinical safety threshold.
`Activation`	reference		→ MasterChanges. Independent Quality Reviewer excluding preparer/material criteria editors; additional independent Assembly Manager approval where the same policy change affects technical assembly processes.
`DateCutoffRule`	longtext	yes	Explicit interpretation of each date-only label: last permissible local date ends at the next local midnight exclusive when configured, or actual supplied instant. Calendar-day rules preserve local calendar/timezone; OpenLifeHours uses elapsed hours. Minimum life uses its stated calendar/date or elapsed basis, never mixes conventions or guesses a missing cutoff.

LotDateEventsImmutable scoped manufacture, received, opening and date-decision evidence; current dates are controlled projections.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`DateEventNumber`	text	yes	Unique source occurrence/decision identity.
`Portion`	reference	yes	→ LotPortions. Exact leaf or explicitly whole ancestor scope; opening a partial amount requires prior physical split.
`Kind`	select	yes	Manufacture, Receipt, SupplierDateEvidence, FirstOpening, Reassessment, Correction
`Status`	select	yes	Recorded, PendingReview, Approved, Applied, Rejected, Superseded
`OccurredAt`	datetime	yes	Actual event or evidence occurrence; approval timestamp is separate.
`RecordedBy`	reference	yes	→ Users. Actual Warehouse Operator, Assembly Operator or authorized importer; factual observer is not date-extension approver.
`ManufacturedAt`	datetime		Actual manufacture evidence, not receipt/repack date substituted automatically.
`ExpiryAt`	datetime		Evidenced supplier/approved effective boundary where provided.
`BestBeforeAt`	datetime		Separate evidence-backed boundary.
`OpenedAt`	datetime		Actual first opening of this exact physical population; absent for unopened stock.
`Policy`	reference	yes	→ ShelfLifePolicies. Exact applicable approved version.
`SourceEvidence`	longtext	yes	Original document/event/hash, timezone/date interpretation, actual process/storage basis, previous/new values and affected descendants/commitments.
`CorrectionOf`	reference		→ LotDateEvents. Exact incorrect prior fact or reassessment chain; history preserved and downstream uses/deliveries reviewed before application.
`ApprovedBy`	reference		→ Users. Independent Quality Reviewer for protected original date approval, correction or extension, excluding preparer/material editors.
`ApprovedAt`	datetime		Actual protected decision.
`AppliedAt`	datetime		Atomic scoped projection update; all affected claims revalidated without erasing performed work.

BatchMaterialAllocationsTyped actual ingredient/packaging use and disjoint output/loss cost claims, separate from conservative exposure lineage.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`OperationKey`	text	yes	Stable economic action identity; identical content returns the same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`AllocationNumber`	text	yes	Stable batch/source/action/slice identity.
`WorkOrder`	reference	yes	→ WorkOrders. One released BOM batch.
`Material`	reference	yes	→ WorkOrderMaterials. Exact frozen component/packaging requirement.
`SourceCost`	reference	yes	→ WorkOrderCostEntries. Original posted MaterialIssue, retaining source layer/lot/portion and original base-unit carrying.
`InputPortion`	reference		→ LotPortions. Required only for actual lot-controlled input; exact original issue or conserved current split leaf. Null for genuine untracked source, whose SourceCost/SourceStockEvent/SourceLayer identify actual quantity and carrying. Tracking absence never erases original issue claims.
`Kind`	select	yes	Use, NormalProcessLoss, PackagingLoss, AbnormalScrap, OutputAllocation, UnusedReturn, Correction
`Status`	select	yes	Prepared, Reserved, Confirmed, Posted, Released, Reversed
`BaseQuantity`	decimal	yes	Positive input-product base quantity. Use, NormalProcessLoss, PackagingLoss and AbnormalScrap are DISJOINT physical-consumption slices against SourceCost; their sum cannot exceed original issue less actual returns/other use/active claims. OutputAllocation only allocates already consumed SourceUse, never consumes input again. If process evaporation cannot be assigned in an input unit, retain it as non-consuming measured output loss in BatchReconciliations, not a second material claim.
`FunctionalAmount`	decimal	yes	Exact corresponding source cost at original issue basis with final remainder; known zero valid. No mixed-currency or unrelated input-value sum.
`SourceUse`	reference		→ BatchMaterialAllocations. Required OutputAllocation parent: confirmed Use or NormalProcessLoss/PackagingLoss with LossTreatment IncludedInOutput. Claims consume remaining parent quantity/value once. SeparateScrap parents use their approved scrap relief only, never output allocation; no orphaned packaging-loss cost.
`Completion`	reference		→ ProductionCompletions. Required OutputAllocation terminal output slice; same approved batch, one exact output lot/portion. No extra finished stock from this trace row.
`OutputPortion`	reference		→ LotPortions. Actual completion output population; must match Completion; no invented lot for process loss.
`ProductionEntry`	reference		→ ProductionEntries. Actual operation evidence for use/loss/packaging consumption.
`CostRelief`	reference		→ WorkOrderCostEntries. Exact one completion/scrap/unused-return relief journal owner; these allocations explain its consumed sources, not another posting.
`ExposureBasis`	select	yes	CommingledBatch, PhysicallySegregatedScope, PackagingScope, Unknown
`ExposureEvidence`	longtext	yes	Commingled component can affect ALL batch output/descendants independent of allocated input cost fraction. Narrower exposure requires actual segregation evidence. Unknown input/output connection creates explicit conservative unresolved scope; allocation does not guarantee clean trace.
`RemainingUseQuantity`	decimal	yes	On confirmed Use or IncludedInOutput normal/packaging loss only: source consumed quantity minus net posted output allocations; child and SeparateScrap rows0. Packaging-loss allocation therefore has an explicit completion path. Actual input consumption remains preserved, not restored when cost is allocated.
`RemainingUseValue`	decimal	yes	Same included-output source remaining cost after posted allocation; normal process/packaging loss included here cannot also be expensed separately. Full final allocation takes exact residual, leaving zero quantity/value.
`ReservedQuantity`	decimal	yes	On confirmed Use or NormalProcessLoss/PackagingLoss with LossTreatment IncludedInOutput only: active OutputAllocation quantity claims against current RemainingUseQuantity. Child/SeparateScrap rows hold0 here and own their BaseQuantity claim by status. Posted allocation already reduces remaining and is not subtracted twice.
`ReservedValue`	decimal	yes	On original source only: active OutputAllocation source-cost claims; child0. Same exact quantity/cost source basis and statuses, no second reservation.
`OccurredAt`	datetime	yes	Actual operation/allocation evidence time.
`PostedAt`	datetime		Actual committed use/cost-claim effect.
`ReversalOf`	reference		→ BatchMaterialAllocations. Exact source with output, quality, genealogy and cost consequences reconciled before restoration.
`LossTreatment`	select	yes	NotLoss, IncludedInOutput, SeparateScrap
`ConfirmedAt`	datetime		Actual independently accepted physical use/loss time; confirmation updates original issued-material consumed quantity once. Posted is later same-row financial-allocation effect where needed, never second consumption.

BatchReconciliationsIndependent actual batch yield, component and packaging reconciliation with compatible units and exact WIP closure.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree.
`Revision`	number	yes	Positive monotonic content revision; submitted/material editors and accepted scope are immutable.
`Snapshot`	reference		→ DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity, not a role alias.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`Decision`	reference		→ ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect.
`ReconciliationNumber`	text	yes	Unique work-order/cutoff/version.
`WorkOrder`	reference	yes	→ WorkOrders. One BOM batch; prior accepted reconciliation retained.
`Kind`	select	yes	Interim, Terminal, Close
`Status`	select	yes	Draft, PendingReview, Approved, Rejected, Superseded
`CutoffAt`	datetime	yes	Actual retained source/evidence cutoff.
`Basis`	select	yes	OutputYield, CompatibleMassBalance, CompatibleVolumeBalance, CountBalance
`MeasureUnit`	reference	yes	→ UnitsOfMeasure. Declared compatible balance/yield unit. OutputYield compares expected and actual primary output, not a false total component mass.
`ExpectedOutput`	decimal	yes	Positive approved reference/target primary output in this unit; BOM scale and changes frozen.
`PhysicalGoodOutput`	decimal	yes	Net accepted terminal physical output including valued held output; quality eligibility reported separately, no intermediate throughput sum.
`HeldOutput`	decimal	yes	Subset of PhysicalGoodOutput currently quality-held; not added to it again.
`YieldPercent`	decimal		100 times comparable physical output divided by expected output; null if basis incomplete/incompatible, never sum kg+L+each.
`InputBalances`	longtext	yes	Validated per-product/base-unit original issue, actual use, unused return, normal process loss, abnormal scrap and physically unused remainder with exact source allocations. Each source closes in its own dimension; packing each reconciles separately from component mass/volume. No implicit density/potency/catch-weight conversion.
`OutputBalance`	longtext	yes	Declared expected/actual primary output, measured compatible process loss, sample/scrap and unfinished scope, deviations and measurement uncertainty. Only claim physical mass/volume closure where ALL included streams share reviewed compatible units; otherwise use output yield and separate per-input balances.
`CostBalance`	longtext	yes	Exact source WIP, normal loss included in output basis versus separately approved abnormal scrap, terminal output standard/variance and unrelieved residual. No loss cost relieved twice or completion variance repeated at close.
`QualityDecision`	reference		→ ApprovalDecisions. Independent Quality Reviewer for required supply condition, source/date and population-lineage exceptions; not a substitute for Assembly Manager technical quantity acceptance or Finance Manager value authority.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager nonzero variance/scrap/residual cost authority.
`ReviewedBy`	reference		→ Users. Independent Assembly Manager excluding producer/recorder/reconciliation preparer/editors; null until actual review.
`ReviewedAt`	datetime		Actual independent approval; null while draft/pending.

SupplyCheckPlansVersioned product/operation criteria and sample/population rules for incoming, first-article, in-process and final decisions.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree.
`PlanNumber`	text	yes	Unique product/type/version.
`Product`	reference	yes	→ Products. Material/output or applicable BOM context. Nonmaterial checks bind actual WorkOrder/operation context and criteria, without invented goods quantity.
`Kind`	select	yes	Incoming, InProcess, Final, Return, Storage, ProcessCheck, PackIntegrity
`RoutingOperation`	reference		→ RoutingOperations. Required for operation-specific scope; same compatible product/version.
`Version`	number	yes	Immutable positive revision.
`StartsAt`	datetime	yes	Inclusive.
`EndsAt`	datetime		Exclusive.
`SamplingRule`	select	yes	EveryUnit, FixedSample, DefinedPopulation, Nonmaterial
`SampleSize`	number		Positive bounded minimum for material sampling; nullable and not applicable for Nonmaterial checks. No fictitious goods sample for actual cleaning/changeover context.
`AcceptanceRule`	longtext	yes	Validated required-characteristic completeness, actual sample selection, release population and known bounds. All applicable other tests/holds/date/label/lineage prerequisites remain mandatory. No universal safety threshold, statistical guarantee or legal certification.
`Status`	select	yes	Draft, Active, Superseded
`Activation`	reference		→ MasterChanges. Independent Quality Reviewer specification/sampling/criteria approval excluding preparers/editors; additional independent Assembly Manager approval only where the same change affects technical assembly processes.

SupplyCheckCriteriaActual measurable or pass/fail criteria with explicit units and known limits.line

Field	Type	Required	Details
`Plan`	reference	yes	→ SupplyCheckPlans. Frozen plan version.
`CharacteristicCode`	text	yes	Unique within plan.
`Name`	text	yes	Concrete test/dimension/visual requirement.
`Type`	select	yes	Numeric, PassFail
`Unit`	text	yes	Measurement unit for Numeric or explicit not-applicable for PassFail.
`LowerLimit`	decimal		Known inclusive lower bound when required; no invented zero for unknown.
`UpperLimit`	decimal		Known inclusive upper bound when required, >= lower.
`Required`	boolean	yes	Missing required result blocks decision.
`Method`	longtext	yes	Reviewed inspection method, equipment fitness/evidence requirements and allowed tolerances; no automatic certification claim.

SupplyChecksImmutable sampled observations and reviewed population decisions, separately scoped from operations and financial completion.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree.
`Revision`	number	yes	Monotonic working revision; submitted content and material editors frozen.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content/source versions; required before approval, acceptance or posting.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Unique economic effect key; same canonical content returns the same effect, conflicting content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`InspectionNumber`	text	yes	Unique actual inspection/source/pass identity.
`Plan`	reference	yes	→ SupplyCheckPlans. Effective frozen version.
`ReceiptLine`	reference		→ GoodsReceiptLines. Incoming source. Exactly one actual material source family: receipt, production entry/completion, return, or explicit Portion plus Location for a storage check. Nonmaterial cleaning/changeover binds WorkOrder/operation context instead.
`ProductionEntry`	reference		→ ProductionEntries. First-article/in-process/final observed work; same product/operation.
`Completion`	reference		→ ProductionCompletions. Exact terminal output source: inspect the evidenced output population before or after its valued Held stock posting. Quality release changes eligibility only and never posts stock/value again; full physical completion cannot require an already-released quality status.
`ReturnLine`	reference		→ ReturnLines. Actual returned custody source.
`Product`	reference	yes	→ Products. Matches source/plan.
`Lot`	reference		→ Lots. Required controlled population identity.
`Serial`	reference		→ Serials. Individual identity when inspecting one serial; multi-serial scope explicitly enumerated in PopulationEvidence.
`PopulationQuantity`	decimal		Positive actual material population quantity where applicable; null for nonmaterial batch checks with explicit work-order scope. No invented goods count for cleaning.
`SampleQuantity`	decimal		Positive sampled quantity no more than material population for actual material tests; null for nonmaterial batch prerequisite check, whose required criteria/results must still be complete.
`PopulationEvidence`	longtext	yes	Actual population/source/unit/sample selection for material checks; nonmaterial checks identify exact released work-order/operation/changeover and required criteria without fabricated goods. All relevant tests/holds must clear independently. A passing sample cannot release unrelated populations.
`Status`	select	yes	Planned, InProgress, PendingReview, Passed, Failed, Held, Corrected
`Inspector`	reference	yes	→ Users. Actual scoped Warehouse Operator or Assembly Operator observer, independent of physical producer/receiver being inspected. Independent Quality Reviewer signs required acceptance; observer cannot accept own packet.
`StartedAt`	datetime		Actual inspection start, absent while merely Planned; planned scheduling is not an observation timestamp.
`CompletedAt`	datetime		Actual completed observations and decision time.
`Decision`	reference		→ ApprovalDecisions. Independent Quality Reviewer SupplyAcceptance check acceptance, excluding physical producer/receiver, actual inspector and criteria/packet material editors. Nonmaterial checks use this decision directly, without a material SupplyDispositions record or invented portion/quantity.
`CorrectionOf`	reference		→ SupplyChecks. Prior inspection; released/consumed/shipped scope traced before corrective action.
`PlannedStart`	datetime	yes	Planned inspection window start, distinct from actual StartedAt.
`PlannedEnd`	datetime	yes	Planned later end; production release cannot presume inspection completion.
`Portion`	reference		→ LotPortions. Required for actual material/label population; null for an explicitly nonmaterial batch changeover/cleaning check with WorkOrder/context evidence. Partial physical release requires identifiable segregated leaf portions.
`WorkOrder`	reference		→ WorkOrders. Required batch context for nonmaterial changeover/cleaning/process prerequisite checks; no fabricated stock population. Material tests instead bind actual source population.
`Location`	reference		→ Locations. Actual storage observation location when that source family is selected; same property/product/portion context. Observations are manual/imported evidence, not live sensors.

SupplyCheckResultsOne observed sample/characteristic result with evidence and explicit unavailable measurements.line

Field	Type	Required	Details
`Inspection`	reference	yes	→ SupplyChecks. Parent immutable observed scope.
`Characteristic`	reference	yes	→ SupplyCheckCriteria. Must belong to frozen plan.
`SampleKey`	text	yes	Exact actual material sample/serial/point, or exact nonmaterial work-order/operation/check-context identity; unique criterion/observation per pass. Never invent a sampled unit for cleaning.
`NumericResult`	decimal		Numeric result for Numeric criterion; missing remains null and prevents required completion.
`PassResult`	boolean		Explicit observation for PassFail criterion; missing is not pass.
`Outcome`	select	yes	Pass, Fail, Missing, Invalid
`ObservedAt`	datetime		Actual recorded observation instant; null until result exists, required for non-Missing completed observation.
`ObservedBy`	reference		→ Users. Actual authorized independent Warehouse Operator or Assembly Operator observer, absent until real observation.
`Evidence`	longtext	yes	Measurement unit/method, instrument fitness evidence where required, source/photo/document hash; no calibration system implied.

SupplyHoldsRestrictive exact material/output eligibility scope that follows descendants and blocks issue/dispatch even after relocation.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree.
`OperationKey`	text	yes	Unique economic effect key; same canonical content returns the same effect, conflicting content is ReviewRequired.
`Event`	reference		→ IntegrationEvents. Authenticated inbound event or reviewed manual evidence.
`HoldNumber`	text	yes	Stable containment scope identity.
`Product`	reference	yes	→ Products. Affected SKU.
`Lot`	reference		→ Lots. Affected controlled lot scope.
`Serial`	reference		→ Serials. Exact serial where applicable.
`Position`	reference		→ InventoryPositions. Current physical identity when present; descendant scope retained beyond relocation.
`WorkOrder`	reference		→ WorkOrders. In-process scope when no finished position exists.
`Inspection`	reference		→ SupplyChecks. Triggering inspection.
`Scope`	longtext	yes	Exact nonclinical product/lot/portion/batch/current descendant restriction and actual reason. All overlapping holds apply; one release cannot clear another. Moved/consumed history remains visible for bounded incident review; no clinical recall platform or fictional reversal.
`Status`	select	yes	Active, PartiallyReleased, Released, Closed
`PlacedBy`	reference	yes	→ Users. Any authorized actual operational/quality person may immediately restrict unsafe/unverified scope. Only independent Quality Reviewer decision can release its exact hold; no Admin override.
`PlacedAt`	datetime	yes	Actual restriction time.
`ReleasedBy`	reference		→ Users. Independent Quality Reviewer excluding producer/receiver/inspector/criteria/disposition preparers as applicable; resolves only this hold, leaving every other applicable hold effective.
`Portion`	reference		→ LotPortions. Actual affected leaf or ancestor scope; propagates to corresponding moved/split/transformed descendants under reviewed exposure rules.

SupplyDispositionsBounded quality accept/rework/scrap/return decisions; production, stock and finance effects retain their own guarded evidence.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree.
`Revision`	number	yes	Monotonic working revision; submitted content and material editors frozen.
`Snapshot`	reference		→ DocumentRevisions. Exact reviewed content/source versions; required before approval, acceptance or posting.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`Decision`	reference		→ ApprovalDecisions. Current valid independent action/scope/revision decision, required before corresponding action.
`DispositionNumber`	text	yes	Unique source population/action decision.
`Inspection`	reference		→ SupplyChecks. Observed actual scope.
`Hold`	reference		→ SupplyHolds. Specific hold scope to release/rework/close.
`Action`	select	yes	Release, Rework, Scrap, ReturnToSupplier, RetainHold, Reject
`BaseQuantity`	decimal	yes	Positive bounded actual identified population quantity. Release applies whole named leaf portions; partial requested quantity first requires evidenced physical segregation/split. Never unlock remainder via lot-header status.
`Status`	select	yes	Prepared, PendingApproval, Approved, Applied, Rejected, Cancelled
`Evidence`	longtext	yes	Exact material population, unit and criteria, current hold/date/fitness basis and separately approved rework/financial effect. Sampling cannot release unrelated scope. Nonmaterial check acceptance uses SupplyChecks.Decision directly; this material-only table always requires real quantity/portion.
`TechnicalDecision`	reference		→ ApprovalDecisions. Independent Assembly Manager for any separately scoped rework/routing technical change, additional to Quality Reviewer restrictions.
`CommercialDecision`	reference		→ ApprovalDecisions. Independent Supply Manager plus actual customer acceptance when customer requirements/commitments change.
`FinanceDecision`	reference		→ ApprovalDecisions. Independent Finance Manager for scrap/loss/value or credit impact; quality authority alone cannot post financial loss.
`DecidedBy`	reference		→ Users. Independent Quality Reviewer excluding physical producer/receiver, inspector, criteria editors and proposed disposition preparer/material editors; another eligible actual manager required for overlap.
`DecidedAt`	datetime		Actual decision time. Absent until the actual action; mandatory for the corresponding confirmed/approved state.
`AppliedAt`	datetime		Actual independent Quality Reviewer guarded eligibility application or linked approved physical action. Release posts no stock/output/value; Warehouse Operator executes actual authorized disposal/return with required WM/FM decisions.
`Portion`	reference		→ LotPortions. Required controlled material leaf, consistent with inspection/holds. Nullable for genuinely untracked material, which instead requires exact Position and whole identified physical scope; no fictitious medical lot.
`TargetPortion`	reference		→ LotPortions. Existing segregated child for partial action, same original external lot. Required if disposition does not cover the whole original leaf; split itself does not release or add value.
`Position`	reference		→ InventoryPositions. Required untracked material source when Portion is null. Release covers the whole exact observed position; partial untracked release first requires actual segregation into a different identified location/position under guarded movement, not changing a whole-bin status from a partial sample.
`TargetPosition`	reference		→ InventoryPositions. Actual physically segregated destination for partial untracked disposition; source/destination quantities/current carrying conserved, no invented available population.

FacilitiesNonclinical operating facilities within separately controlled legal companies.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. One legal owner. Ordinary document, warehouse, source and ledger references belong to this company; explicit intercompany coordination is the only typed cross-company link.
`FacilityCode`	text	yes	Unique company/facility identity.
`Name`	text	yes	Actual operating facility name.
`Timezone`	text	yes	IANA timezone for operational dates; actual timestamps retain offsets.
`Status`	select	yes	Draft, Active, Suspended, Closed
`Policy`	reference		→ HealthcarePolicies. Current company/facility supply and financial policy.
`Activation`	reference		→ MasterChanges. Independent Supply Manager operational and Finance Manager ownership/account policy approval.

DepartmentsActual facility departments and nonclinical supply-cost destinations.master

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. One legal owner. Ordinary document, warehouse, source and ledger references belong to this company; explicit intercompany coordination is the only typed cross-company link.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`DepartmentCode`	text	yes	Unique within facility.
`Name`	text	yes	Actual department label; no patient/procedure identity.
`Kind`	select	yes	CentralStore, Department, Assembly, Administration, FacilitySupport
`Status`	select	yes	Draft, Active, Inactive
`Warehouse`	reference		→ Warehouses. Actual owned custody location; delivery here does not prove consumption.
`ExpenseAccount`	reference	yes	→ ChartOfAccounts. Approved company department expense destination.
`Coordinator`	reference	yes	→ Users. Scoped actual Department Coordinator.
`Activation`	reference		→ MasterChanges. Supply Manager operating and Finance Manager cost/account approval.

DepartmentUsesIndependently authorized actual irreversible department supply consumption, separate from requests, internal transfers and goods billing.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. One legal owner; all property, commercial, stock and financial sources must belong to this entity.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`Revision`	number	yes	Positive immutable submitted revision; material editors recorded.
`Snapshot`	reference		→ DocumentRevisions. Exact current content/source/policy hash, required before protected decision/effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual offset-aware creation time.
`OperationKey`	text	yes	Stable economic action identity; same content returns same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated source or reviewed manual evidence retaining occurrence/receipt time.
`Decision`	reference		→ ApprovalDecisions. Independent Warehouse Manager exact DepartmentUse quantity/source/current-carrying authorization, excluding request preparer/material editors/actual performer. Required before guarded consumption; actual unauthorized/over-use observation remains durable Exception and needs reviewed correction, never ignored.
`UseNumber`	text	yes	Unique actual department/service use identity.
`Department`	reference	yes	→ Departments. Exact expense/cost owner.
`Kind`	select	yes	DepartmentSupply, AdministrationSupply, FacilitySupply
`Status`	select	yes	Draft, PendingApproval, Approved, Performed, Posted, Reversed, Exception
`WorkOrder`	reference		→ WorkOrders. Optional actual assembled-pack lineage; actual use consumes only finished owned stock layers, never also original WIP.
`PerformedBy`	reference	yes	→ Users. Actual physical consumer, which may be a Department Coordinator or other actual department worker. Never substitute the warehouse recorder/executor for the real performer.
`PerformedAt`	datetime		Actual evidenced consumption time; request/transfer/task completion is not consumption.
`Evidence`	longtext	yes	Actual quantities/source custody/recipient/service evidence; unapproved or excess actual use remains durable exception with stock claims held until reviewed, never fabricated free stock.
`StockEvent`	reference		→ StockEvents. One DepartmentUse quantity/carrying relief against approved expense/supply-cost, not title/revenue or second WIP.
`FinanceDecision`	reference		→ ApprovalDecisions. Additional independent Finance Manager protected value/loss exception; quality and Warehouse Manager use authority remain mandatory.
`RecordedBy`	reference	yes	→ Users. Warehouse Operator records exact source/quantity evidence supplied by actual department performer/Department Coordinator. Evidence submission grants no stock posting authority.
`ExecutedBy`	reference		→ Users. Warehouse Operator guarded actual use StockEvent execution after independent Warehouse Manager exact authorization, current Quality Reviewer restrictions and required Finance Manager exception. May differ from performer/recorder.

DepartmentUseLinesExact source quantity/value slices consumed once by one actual department-use event.line

Field	Type	Required	Details
`Use`	reference	yes	→ DepartmentUses. Owning authorized actual use.
`LineNumber`	number	yes	Unique source slice.
`Product`	reference	yes	→ Products. Actual nonclinical supply/pack SKU/base unit.
`Reservation`	reference	yes	→ InventoryReservations. Exclusive DepartmentUse demand claim; no fabricated sales order or production work demand.
`Layer`	reference	yes	→ StockLayers. Exact current source carrying and custody.
`Portion`	reference		→ LotPortions. Exact current controlled leaf when product policy requires; null for genuine untracked supply. Current source/date/hold restrictions remain mandatory.
`BaseQuantity`	decimal	yes	Positive actual used quantity, bounded by authorized/reserved/available source; cannot be a room count or charge amount.
`CarryingRemoved`	decimal	yes	Exact current source-layer carrying removed once to approved department expense; nonnegative known zero allowed, final remainder exact. Transfer, request, invoice or clinical/service count cannot add another use.
`ExpenseAccount`	reference	yes	→ ChartOfAccounts. Same-company department expense account.
`OriginalUseLine`	reference		→ DepartmentUseLines. Exact controlled correction; actual consumption is irreversible, so only evidenced unused/erroneous original scope can restore stock with required condition/source decisions.
`RequestLine`	reference		→ DepartmentRequestLines. Optional demand lineage. FulfillsRequest true only for ConsumeFromCentral; actual use of previously delivered departmental stock retains context without fulfilling DeliverToDepartment twice.
`FulfillsRequest`	boolean	yes	True only exact direct-use demand fulfillment; otherwise false. Shared pending/current use allocations cannot exceed request remainder.

DepartmentRequestsAuthorized nonclinical department demand distinct from purchase and actual stock use.transaction

Field	Type	Required	Details
`Entity`	reference	yes	→ Entities. One legal owner. Ordinary document, warehouse, source and ledger references belong to this company; explicit intercompany coordination is the only typed cross-company link.
`Facility`	reference	yes	→ Facilities. Actual facility belonging to the ordinary document Entity; intercompany sources keep distinct company facilities.
`Revision`	number	yes	Positive immutable submitted revision; changes retain prior material contributors.
`Snapshot`	reference		→ DocumentRevisions. Exact current source/content hash required for protected decision/effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual creation timestamp.
`OperationKey`	text	yes	Stable economic action key; same content returns same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated actual source or reviewed manual evidence; occurrence/receipt remain separate.
`Decision`	reference		→ ApprovalDecisions. Exact current independently approved action/revision; required before its protected effect.
`RequestNumber`	text	yes	Stable department/request identity.
`Department`	reference	yes	→ Departments. Same company/facility beneficiary.
`Status`	select	yes	Draft, Submitted, Approved, PartiallyFulfilled, Fulfilled, Cancelled, Exception
`NeededBy`	datetime	yes	Actual required operational date/time.
`Purpose`	longtext	yes	Nonclinical supply requirement without patient or clinical detail.
`ApprovedAt`	datetime		Independent Warehouse Manager bounded quantity/action authorization, with Finance Manager protected value exception if required.
`FinanceDecision`	reference		→ ApprovalDecisions. Additional financial authority where policy requires.

DepartmentRequestLinesConserved internal demand with one selected fulfillment basis and durable source backlinks.line

Field	Type	Required	Details
`Request`	reference	yes	→ DepartmentRequests. Parent approved department request.
`LineNumber`	number	yes	Unique line.
`Product`	reference	yes	→ Products. Reviewed nonclinical SKU/base unit.
`BaseQuantity`	decimal	yes	Gross authorized quantity including approved positive increases before separately recorded cancellations. FulfilledQuantity and CancelledQuantity are subtracted once: gross10 minus fulfilled4 minus cancelled2 leaves4. Never reduce BaseQuantity by the same cancellation again; changes preserve original history.
`FulfillmentBasis`	select	yes	DeliverToDepartment, ConsumeFromCentral
`FulfilledQuantity`	decimal	yes	Disjoint actual destination-received StockTransferLines for DeliverToDepartment, or posted DepartmentUseLines flagged FulfillsRequest for ConsumeFromCentral. Later department consumption after delivery is not a second fulfillment. Linked local source line identities are durable tranches.
`ReservedQuantity`	decimal	yes	Active approved linked transfer/use claims against remaining demand, excluding already fulfilled history. Retry/replacement cannot exceed BaseQuantity minus net authorized cancellation and FulfilledQuantity.
`CancelledQuantity`	decimal	yes	Approved only unperformed unreserved remainder; cancellation cannot restore already consumed/delivered entitlement.
`Status`	select	yes	Draft, Approved, PartiallyFulfilled, Fulfilled, Cancelled, Exception

IntercompanyAgreementsVersioned reciprocal legal-party and commercial authority without shared company books.master

Field	Type	Required	Details
`SellerEntity`	reference	yes	→ Entities. Original supplying legal company; must differ from BuyerEntity.
`BuyerEntity`	reference	yes	→ Entities. Original receiving legal company; ordinary local sources remain strictly in their own company.
`Revision`	number	yes	Positive immutable submitted revision; changes retain prior material contributors.
`Snapshot`	reference		→ DocumentRevisions. Exact current source/content hash required for protected decision/effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual creation timestamp.
`AgreementNumber`	text	yes	Unique bilateral agreement/version.
`SellerAccount`	reference	yes	→ Accounts. Customer in SellerEntity representing BuyerEntity; no reuse of buyer-side supplier record as a seller account.
`BuyerSupplier`	reference	yes	→ Suppliers. Supplier in BuyerEntity representing SellerEntity; independently activated reciprocal identity.
`TransactionCurrency`	reference	yes	→ Currencies. One common commercial currency for each paired agreement/order/document; company functional and actual bank currencies remain independent.
`TitleRule`	select	yes	DestinationAcceptance
`ReturnTitleRule`	select	yes	ReturnDestinationAcceptance
`Terms`	longtext	yes	Actual price/tax/payment/acceptance/return and mapping terms; customer-configured legal/tax evidence, no automatic group policy.
`Status`	select	yes	Draft, PendingApproval, Active, Suspended, Superseded
`EffectiveFrom`	datetime	yes	Inclusive approved boundary.
`EffectiveTo`	datetime		Exclusive.
`SellerDecision`	reference		→ ApprovalDecisions. Seller Supply Manager independent commercial approval of exact agreement; excludes preparers/material editors and counterpart required signer.
`BuyerDecision`	reference		→ ApprovalDecisions. Buyer Purchasing Manager independent commitment/party approval within authority, Finance Manager otherwise; different actual person from seller required signer.
`SellerFinanceDecision`	reference		→ ApprovalDecisions. Seller Finance Manager financial/currency/tax/account authority, independent of source preparers and counterpart required approver.
`BuyerFinanceDecision`	reference		→ ApprovalDecisions. Separate buyer Finance Manager authority; same actual person cannot supply both required company approvals.

IntercompanyOrdersReciprocal approved company order pair with immutable original and remaining-scope revision agreement.transaction

Field	Type	Required	Details
`SellerEntity`	reference	yes	→ Entities. Original supplying legal company; must differ from BuyerEntity.
`BuyerEntity`	reference	yes	→ Entities. Original receiving legal company; ordinary local sources remain strictly in their own company.
`Revision`	number	yes	Positive immutable submitted revision; changes retain prior material contributors.
`Snapshot`	reference		→ DocumentRevisions. Exact current source/content hash required for protected decision/effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual creation timestamp.
`OperationKey`	text	yes	Stable economic action key; same content returns same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated actual source or reviewed manual evidence; occurrence/receipt remain separate.
`PairNumber`	text	yes	Global bilateral order identity; retries prepare the same pair, never another counterpart order.
`Agreement`	reference	yes	→ IntercompanyAgreements. Exact active frozen approved relationship.
`SellerOrder`	reference	yes	→ SalesOrders. Actual seller-company order; original headline Supply Manager approval remains mandatory.
`BuyerOrder`	reference	yes	→ PurchaseOrders. Actual buyer-company purchase commitment; independent buyer Purchasing Manager or Finance Manager approval remains mandatory.
`Currency`	reference	yes	→ Currencies. Agreed common transaction currency, matching paired documents.
`Status`	select	yes	Draft, PendingApprovals, Approved, PartiallyPerformed, Performed, PartiallyPosted, Uncertain, Reconciling, Closed, Cancelled
`SellerDecision`	reference		→ ApprovalDecisions. Exact current seller order/revision approval, independent actual seller signer.
`BuyerDecision`	reference		→ ApprovalDecisions. Exact current buyer commitment/revision approval, separate actual buyer signer; never inferred from seller approval.
`AgreementHash`	text	yes	Exact shared line/quantity/unit/net/tax/title/term revision hash; changed remaining scope needs each affected side approval.
`ApprovedAt`	datetime		Only after both current decisions; one approved side leaves PendingApprovals.
`ClosedAt`	datetime		After all physical/title/document/settlement/correction differences reconciled; no close from one side alone.

IntercompanyOrderLinesDurable exact seller/buyer demand mapping and shared commercial conservation.line

Field	Type	Required	Details
`Pair`	reference	yes	→ IntercompanyOrders. Approved order pair.
`LineNumber`	number	yes	Global stable pair-line number.
`SellerLine`	reference	yes	→ SalesOrderLines. Unique seller source line in pair SellerOrder; shared source claims prevent another pair using same scope.
`BuyerLine`	reference	yes	→ PurchaseOrderLines. Unique reciprocal buyer line; automation may create draft only and cannot bypass buyer approval.
`SellerProduct`	reference	yes	→ Products. Actual supplying SKU.
`BuyerProduct`	reference	yes	→ Products. Actual receiving SKU, same underlying goods under reviewed mapping; no automatic equivalence by display name.
`UnitFactor`	decimal	yes	Positive fixed buyer base units per seller base unit, dimension-compatible or fixed pack evidence; serialized identity remains exact.
`ConversionEvidence`	longtext	yes	Frozen SKU/base-unit/pack/serial mapping and deterministic precision. No implicit density or clinical identifier.
`SellerBaseQuantity`	decimal	yes	Positive approved original seller quantity; actual cumulative title/active claims plus approved cancelled unperformed scope cannot exceed it.
`BuyerBaseQuantity`	decimal	yes	SellerBaseQuantity times frozen UnitFactor, deterministically rounded only where valid.
`NetAmount`	decimal	yes	Accepted common-currency full net, nonnegative; proportional partial title/bill allocations take exact final remainder.
`TaxBasis`	longtext	yes	Each company's reviewed taxable basis/treatment; shared commercial invoice facts reconciled, recoverability/accounting may differ. Never force functional/tax GL values equal.
`TitleQuantity`	decimal	yes	Cumulative confirmed forward destination title only; returns retained separately and do not reopen original forward entitlement.
`ReturnedQuantity`	decimal	yes	Confirmed reciprocal return title quantity against original acquired and still-returnable descendants.
`ReservedQuantity`	decimal	yes	Disjoint pending forward dispatch/title claims against current unperformed remainder; confirmed-title pending-post claims remain held until recovery.
`CancelledQuantity`	decimal	yes	Independently approved remaining unperformed cancellation, with both affected company decisions.
`Status`	select	yes	Draft, Approved, PartiallyPerformed, Performed, Reconciling, Closed, Cancelled

IntercompanyTitleAllocationsOne actual ownership transition with separately authorized local company effects and recovery.transaction

Field	Type	Required	Details
`SellerEntity`	reference	yes	→ Entities. Original supplying legal company; must differ from BuyerEntity.
`BuyerEntity`	reference	yes	→ Entities. Original receiving legal company; ordinary local sources remain strictly in their own company.
`Revision`	number	yes	Positive immutable submitted revision; changes retain prior material contributors.
`Snapshot`	reference		→ DocumentRevisions. Exact current source/content hash required for protected decision/effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual creation timestamp.
`OperationKey`	text	yes	Stable economic action key; same content returns same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated actual source or reviewed manual evidence; occurrence/receipt remain separate.
`TitleNumber`	text	yes	Global forward/return physical acceptance identity; exact same event retries cannot move ownership again.
`PairLine`	reference	yes	→ IntercompanyOrderLines. Exact original bilateral source and mapping.
`Kind`	select	yes	ForwardAcceptance, ReturnAcceptance
`OriginalTitle`	reference		→ IntercompanyTitleAllocations. Required ReturnAcceptance source: original acquired quantity/carrying lineage; returns never reopen its original forward demand.
`SellerShipmentLine`	reference		→ ShipmentLines. Required forward dispatched seller-owned transit source; cannot also execute ordinary Handover TitleIssue.
`BuyerReceiptAcceptance`	reference		→ ReceiptAcceptances. Required forward actual destination accepted tranche, independently of purchasing; pending arrival/refusal is not title. Held-but-owned acceptance is allowed and remains restricted.
`BuyerReturnLine`	reference		→ ReturnLines. Required return dispatch source: actual buyer-owned remaining receipt descendants in return transit.
`SellerReturnLine`	reference		→ ReturnLines. Required actual seller return acceptance/custody source; original seller title issue basis retained.
`SellerBaseQuantity`	decimal	yes	Positive accepted source quantity; bounded by actual dispatched unaccepted remainder for forward or actual returnable/returned scope for return.
`BuyerBaseQuantity`	decimal	yes	Exact accepted mapping under frozen UnitFactor; not another physical population.
`CommercialNet`	decimal	yes	Exact allocated common-currency original agreed net, with final remainder; not either company's carrying value.
`SellerCarrying`	decimal		Nonnegative known seller original/current title-issue carrying; null while actual title has occurred but required valuation is unresolved. Required before seller monetary effect. Forward removes seller transit; return creates held layer at original seller issue basis. No fabricated zero for missing value.
`BuyerStandardValue`	decimal		Forward accepted buyer standard value in buyer functional currency; nullable while valuation unresolved or not applicable to return. Known zero valid; required before forward buyer monetary effect, not before preserving actual accepted title.
`BuyerAccrualValue`	decimal		Forward agreed commercial basis at reviewed buyer rate, owning original GRNI; nullable before valuation or for return. Required before forward buyer posting; physical accepted ownership remains durable and restricted if unknown.
`BuyerReturnCarrying`	decimal		Return only: exact current buyer receipt-descendant value removed, including pooling/revaluation. Null when not return or unresolved; required before buyer return monetary effect. No invented zero for irrelevant direction.
`SellerDecision`	reference		→ ApprovalDecisions. Exact current authorized seller-side physical/commercial/value scope; seller FM additional protected monetary approval required.
`BuyerDecision`	reference		→ ApprovalDecisions. Exact independent buyer-side receiving/return/value authority; actual physical acceptance may be confirmed by independent-of-purchasing Warehouse Operator with separate required quality/finance decisions.
`AcceptedBy`	reference		→ Users. Actual destination receiver for this direction; independent of relevant purchasing/dispatch/preparer conflict. Actual receipt recorder may confirm facts if independent of purchasing.
`AcceptedAt`	datetime		Actual destination ownership-transfer evidence time; only this confirmed fact changes physical owner, even if one company's accounting effect remains delayed.
`AcceptanceEvidence`	longtext	yes	Exact dispatched/current custody, destination acceptance/quantity/identity/time, source versions and both authorization snapshots; mismatch/refusal/unknown remains visible, never invented title.
`PhysicalOwner`	select	yes	Seller, Buyer. Forward before Accepted=Seller, after actual accepted title=Buyer; Return before Accepted=Buyer, after actual seller acceptance=Seller. Local effect status cannot roll back this actual fact. Current ownership reports use this overlay once; layer accounting differences remain separate until recovery.
`Status`	select	yes	Prepared, PendingAcceptance, Accepted, PartiallyPosted, Posted, Uncertain, Exception, Reversed
`SellerEffectKey`	text	yes	Stable seller-company local effect key derived from global title/direction; successful local effect is never replayed during peer recovery.
`BuyerEffectKey`	text	yes	Stable separate buyer-company local effect key; no cross-company shared journal or distributed-atomicity assumption.
`SellerEffectStatus`	select	yes	NotStarted, Reserved, Posted, Uncertain, Failed, Reversed
`BuyerEffectStatus`	select	yes	NotStarted, Reserved, Posted, Uncertain, Failed, Reversed
`SellerStockEvent`	reference		→ StockEvents. Seller company forward TitleIssue or reciprocal CustomerReturn effect, with its own journal and decision; never buyer event.
`BuyerStockEvent`	reference		→ StockEvents. Buyer company forward ReceiptAcceptance acquisition or reciprocal SupplierReturn effect, with its own journal and decision; never seller event.
`Recovery`	longtext	yes	Exact local result/hash/error/version and retry evidence. Accepted physical ownership overlays current stock once, removing outgoing owned transit and adding incoming owned-but-posting-restricted scope; pending accounting value is shown separately, not a second owned population. Restrict conflicting use/title/document reversal until both required effects reconcile. Only missing approved effect may retry.
`ReversalOf`	reference		→ IntercompanyTitleAllocations. A genuine corrected ownership fact uses a distinct reviewed delta and reconciles performed descendants; never erase actual acceptance or replay original success.
`SellerPosition`	reference		→ InventoryPositions. Exact seller-owned/transferred/returned physical position; needed before actual acceptance and current projection. Seller pending overlay clears only when its own local effect posts.
`BuyerPosition`	reference		→ InventoryPositions. Exact buyer actual destination/return-transit position; accepted ownership may create an owned-but-posting-restricted physical projection before valued layer posting. No fabricated cost or duplicate old-owner population.
`SellerLayer`	reference		→ StockLayers. Exact seller current/original issue financial source; pending outgoing quantity stays exclusively claimed and is not physically available despite delayed book relief.
`BuyerLayer`	reference		→ StockLayers. Exact buyer acquisition/current return source; nullable until forward native acquisition layer can be valued/posted. Actual title remains visible while unknown required valuation is held.

IntercompanyDocumentAllocationsFinite reciprocal invoice/bill or credit source pairing without a second commercial ledger.transaction

Field	Type	Required	Details
`SellerEntity`	reference	yes	→ Entities. Original supplying legal company; must differ from BuyerEntity.
`BuyerEntity`	reference	yes	→ Entities. Original receiving legal company; ordinary local sources remain strictly in their own company.
`OperationKey`	text	yes	Stable economic action key; same content returns same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated actual source or reviewed manual evidence; occurrence/receipt remain separate.
`DocumentAllocationNumber`	text	yes	Stable exact paired commercial document slice.
`PairLine`	reference	yes	→ IntercompanyOrderLines. Original approved commercial scope.
`TitleAllocation`	reference	yes	→ IntercompanyTitleAllocations. Exact confirmed accepted title/return source eligible for this pair's billing/credit, with partial-post prerequisites reconciled.
`Kind`	select	yes	Debit, Credit
`SellerInvoiceLine`	reference	yes	→ InvoiceLines. Seller-company actual independently FM-approved invoice/credit line; original source lineage retained.
`BuyerBillLine`	reference	yes	→ BillLines. Buyer-company actual bill/credit matched to its accepted/accrual source; independent buyer review and required FM exceptions.
`SellerBaseQuantity`	decimal	yes	Positive exact billed/credited slice; shared with ordinary local invoice/bill claims and other pair rows. Credit scope never creates forward entitlement.
`BuyerBaseQuantity`	decimal	yes	Mapped actual source quantity under the same fixed factor.
`NetAmount`	decimal	yes	Nonnegative common-currency agreed slice, exact final remainder. Seller/buyer functional carrying remains independently recorded.
`TaxReconciliation`	longtext	yes	Actual seller document tax and buyer treatment/recoverability/account mapping; authorized differences retained, no arbitrary net-price adjustment to force both journals equal.
`Status`	select	yes	Reserved, SellerPosted, BuyerPosted, Posted, Uncertain, Mismatch, Released, Reversed
`SellerEffectKey`	text	yes	Exact seller local document/source slice identity.
`BuyerEffectKey`	text	yes	Exact buyer local document/source slice identity.
`PostedAt`	datetime		Both exact document effects verified; one-side posting remains explicit and cannot be counted as peer approval.
`ReversalOf`	reference		→ IntercompanyDocumentAllocations. Original paired debit/credit source and dependent payment/stock scope; correction has distinct delta identity.

IntercompanySettlementsReconciliation of actual outgoing and incoming cash, with independent bank dates and company effects.transaction

Field	Type	Required	Details
`SellerEntity`	reference	yes	→ Entities. Original supplying legal company; must differ from BuyerEntity.
`BuyerEntity`	reference	yes	→ Entities. Original receiving legal company; ordinary local sources remain strictly in their own company.
`Revision`	number	yes	Positive immutable submitted revision; changes retain prior material contributors.
`Snapshot`	reference		→ DocumentRevisions. Exact current source/content hash required for protected decision/effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual creation timestamp.
`OperationKey`	text	yes	Stable economic action key; same content returns same result, conflict enters review.
`Event`	reference		→ IntegrationEvents. Authenticated actual source or reviewed manual evidence; occurrence/receipt remain separate.
`SettlementNumber`	text	yes	Global intended economic transfer identity; no third cash ledger.
`Pair`	reference	yes	→ IntercompanyOrders. Original bilateral source; a finite packet may settle its exact eligible documents only.
`Direction`	select	yes	BuyerToSeller, SellerToBuyer
`Currency`	reference	yes	→ Currencies. Agreed reconciliation currency; each actual bank/source document retains its own currency and reviewed rate.
`GrossAmount`	decimal	yes	Positive proposed common-currency transfer scope under current local source approvals. Once local money executes, intercompany reconciliation matches original executed slices even if AR/AP is now zero; this header cannot initiate another payment or receipt.
`Status`	select	yes	Draft, PendingApproval, Approved, OutgoingConfirmed, IncomingConfirmed, PartiallyMatched, Reconciled, Uncertain, Exception, Cancelled
`PayerDecision`	reference		→ ApprovalDecisions. Independent payer Finance Manager exact current payment/refund release, scoped to actual company bank/beneficiary and amount.
`PayeeDecision`	reference		→ ApprovalDecisions. Independent payee required receipt/fee/correction approval; never inferred from payer. Separate actual person from required payer approver.
`Reconciliation`	longtext	yes	Gross source, actual outgoing/incoming bank evidence and separate fees/FX/current carrying/dates. Approval or instruction cannot establish cash received; timing difference stays outstanding. No automatic cash pooling/netting or group financing.
`ReconciledAt`	datetime		Only after actual source allocations and differences are explained at compatible cutoffs.

IntercompanySettlementAllocationsExact actual company payment/receipt applications linked for comparison without duplicating either effect.line

Field	Type	Required	Details
`Settlement`	reference	yes	→ IntercompanySettlements. Approved intended transfer and actual comparison packet.
`AllocationNumber`	text	yes	Stable source-pair/gross tranche identity.
`DocumentAllocation`	reference		→ IntercompanyDocumentAllocations. Required for document-backed debit/credit pairing. Nullable for genuine unbilled supplier-prepayment/customer-unapplied funding or refund, whose actual payment/receipt/refund sources are explicitly linked; no fictional invoice/credit.
`GrossAmount`	decimal	yes	Positive intended/executed common-currency tranche. Before execution local payment/refund sources enforce their own spendable claims. Pair matching thereafter consumes only UNPAIRED capacity of immutable executed PaymentAllocations, CashReceipts/CashApplications, Refunds or SupplierRefundReceipt slices, not remaining AR/AP/unapplied balances and never a second financial reservation. Posted payment100 with remaining AP0 still offers unpaired executed100. Pending counterpart is permitted; actual matched capacity cannot exceed either executed slice less other active/confirmed pairing claims.
`BuyerPaymentAllocation`	reference		→ PaymentAllocations. Actual buyer outgoing supplier settlement in BuyerToSeller direction. Company bank result required; instruction alone leaves pending.
`SellerCashApplication`	reference		→ CashApplications. Optional actual seller application backed by SellerReceipt; required only when the incoming money has actually applied to the document. Unbilled receipt has no application/invoice. Pair capacity is the executed original receipt slice, not its current unapplied balance.
`SellerRefund`	reference		→ Refunds. SellerToBuyer actual customer-credit/unapplied refund source; separately approved actual cash effect.
`BuyerRefundReceipt`	reference		→ FinanceCorrections. SellerToBuyer actual SupplierRefundReceipt against buyer supplier credit/prepayment, with its exact actual bank/source/current-carrying claims; never inferred from seller refund or posted as buyer revenue.
`OutgoingEvidence`	longtext	yes	Exact actual local money effect/result/date/source-currency/current carrying and bank key; unknown is retained.
`IncomingEvidence`	longtext	yes	Independent actual receipt evidence, source identity/amount/currency/date/withheld fee. No inferred incoming bank from outgoing status.
`Status`	select	yes	Reserved, OutgoingConfirmed, IncomingConfirmed, Matched, Uncertain, Exception, Released, Reversed
`MatchedAt`	datetime		Actual verified matching of conserved gross source and explained fees/FX, not cash simultaneity.
`ReversalOf`	reference		→ IntercompanySettlementAllocations. Actual bank return or traced monetary correction against original local effects, never blind reopening of both sides.
`SellerReceipt`	reference		→ CashReceipts. Actual seller receipt backing SellerCashApplication if supplied, or actual unbilled unapplied receipt. Same gross slice is paired once; receipt and its application are linked views of the same money, not additive incoming capacity.
`OriginalSettlementAllocation`	reference		→ IntercompanySettlementAllocations. Original unbilled funding pair for a later refund, with typed original supplier prepayment and customer receipt sources in local Refunds/FinanceCorrections. Imported sources use explicit reconciled opening lineage rather than an invented invoice.
`Replaces`	reference		→ IntercompanySettlementAllocations. Atomic refinement of an unmatched reconciliation tranche into disjoint smaller tranches when partial counterpart receipts arrive. Predecessor pairing claims release as successor claims reserve the same executed source total; posted local money is untouched. Matched historical scope cannot be edited or released for duplicate pairing.

IntercompanyReconciliationsFinite paired-source coverage and discrepancy review across independent books.transaction

Field	Type	Required	Details
`SellerEntity`	reference	yes	→ Entities. Original supplying legal company; must differ from BuyerEntity.
`BuyerEntity`	reference	yes	→ Entities. Original receiving legal company; ordinary local sources remain strictly in their own company.
`Revision`	number	yes	Positive immutable submitted revision; changes retain prior material contributors.
`Snapshot`	reference		→ DocumentRevisions. Exact current source/content hash required for protected decision/effect.
`CreatedBy`	reference	yes	→ Users. Actual preparer identity.
`CreatedAt`	datetime	yes	Actual creation timestamp.
`ReconciliationNumber`	text	yes	Unique pair/cutoff/version review.
`Pair`	reference	yes	→ IntercompanyOrders. Exact approved bilateral population.
`SellerCutoff`	datetime	yes	Actual seller physical/document/financial source completeness cutoff.
`BuyerCutoff`	datetime	yes	Actual buyer comparable cutoff; unequal coverage remains explicit.
`Status`	select	yes	Draft, PendingReview, Approved, Unresolved, Superseded
`PhysicalPosition`	longtext	yes	One current owner per confirmed title/return, seller/buyer own transit by direction, actual accepted/returned/consumed scope and pending local effects. Do not sum outgoing source history plus incoming acquired population.
`CommercialPosition`	longtext	yes	Remaining agreement/order/title/billed/credited quantities and common-currency net/tax; exact line/granularity, final remainders and authorized differences.
`FinancialPosition`	longtext	yes	Separate company AR/AP/credits/bank, current carrying/prior FX and periods; local transactions and pair tags are the same effects, not additive balances.
`Differences`	longtext	yes	Missing/uncertain local result, peer approval, custody mismatch, rate/tax/fee/date/cutoff and unreconciled opening/correction. No arbitrary due-to/due-from balancing plug.
`SellerDecision`	reference		→ ApprovalDecisions. Independent seller Finance Manager finite review, with actual operations evidence owner where needed.
`BuyerDecision`	reference		→ ApprovalDecisions. Separate independent buyer Finance Manager; same actual person cannot satisfy both required decisions.
`ReviewedAt`	datetime		Only after both required exact review decisions; later facts require new version.

ERP•AI workspace

Start now Healthcare ERP

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

Start now Download agent

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

Healthcare ERP

Modules

Healthcare ERP

Processes

Healthcare ERP

Industries

Healthcare ERP

Reference

Healthcare ERP

Data model

How the model is organised

Department supplies

Purchasing & suppliers

Inventory & locations

Supply-pack assembly

Sales & billing

Intercompany supply

Finance

Reporting

Keys and references

Migration order

Tables

Start now Healthcare ERP

Healthcare ERP

Modules

Healthcare ERP

Processes

Healthcare ERP

Industries

Healthcare ERP

Reference

Data model

How the model is organised

Department supplies

Purchasing & suppliers

Inventory & locations

Supply-pack assembly

Sales & billing

Intercompany supply

Finance

Reporting

Keys and references

Migration order

Tables

Start now Healthcare ERP

Your Privacy, Your Choice

Manage Your Cookie Preferences