Product and recipe definitions
Products, UnitsOfMeasure, ProductUnits, BOMs, BOMLines, ProductionRoutings, RoutingOperations, LabelVersions.
- Products
- UnitsOfMeasure
- ProductUnits
- BOMs
- BOMLines
- ProductionRoutings
- RoutingOperations
- LabelVersions
Data model
Follow recipes, lot populations, production and financial events through their sources.
108 tables · 677 relationships
The model connects approved definitions with actual work and its evidence. A lot can have several tracked populations with different release or opened-life conditions. Production quantities, quality eligibility and financial value retain separate effects while sharing the same source history.
How the model is organised
Supplier and purchasing records
Suppliers, SupplierBankAccounts, Requisitions, RequisitionLines, PurchaseOrders, PurchaseOrderLines, GoodsReceipts, GoodsReceiptLines, ReceiptAcceptances, BillMatches.
- Suppliers
- SupplierBankAccounts
- Requisitions
- RequisitionLines
- PurchaseOrders
- PurchaseOrderLines
- GoodsReceipts
- GoodsReceiptLines
- ReceiptAcceptances
- BillMatches
Stock, lot and date records
Warehouses, Locations, Lots, LotPortions, Serials, InventoryPositions, StockLayers, StockEvents, StockMovements, InventoryReservations, StockTransfers, StockTransferLines, CountLocks, InventoryCounts, CountLines, Returns, ReturnLines, ReturnDispositions, ShelfLifePolicies, LotDateEvents, StorageObservations.
- Warehouses
- Locations
- Lots
- LotPortions
- Serials
- InventoryPositions
- StockLayers
- StockEvents
- StockMovements
- InventoryReservations
- StockTransfers
- StockTransferLines
- CountLocks
- InventoryCounts
- CountLines
- Returns
- ReturnLines
- ReturnDispositions
- ShelfLifePolicies
- LotDateEvents
- StorageObservations
Batch execution and cost records
WorkOrders, WorkOrderMaterials, WorkOrderOperations, ProductionEntries, ProductionCompletions, WorkOrderCostEntries, BatchMaterialAllocations, BatchReconciliations.
- WorkOrders
- WorkOrderMaterials
- WorkOrderOperations
- ProductionEntries
- ProductionCompletions
- WorkOrderCostEntries
- BatchMaterialAllocations
- BatchReconciliations
Quality and investigation records
InspectionPlans, InspectionCharacteristics, QualityInspections, InspectionResults, NonConformanceReports, QualityHolds, QualityDispositions, TraceCases, TraceLines.
- InspectionPlans
- InspectionCharacteristics
- QualityInspections
- InspectionResults
- NonConformanceReports
- QualityHolds
- QualityDispositions
- TraceCases
- TraceLines
Customer and delivery records
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
Financial records
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.
Identity, policy and shared evidence
Users, FoodPolicies, MasterChanges, DocumentRevisions, ApprovalDecisions, AuthorityDelegations, IntegrationEvents, IntegrationDeliveries, MigrationBatches, MigrationItems.
- Users
- FoodPolicies
- MasterChanges
- DocumentRevisions
- ApprovalDecisions
- AuthorityDelegations
- IntegrationEvents
- IntegrationDeliveries
- MigrationBatches
- MigrationItems
Keys and references
Every record has a stable identity within its company and permitted scope. Product units and reviewed conversions remain attached to the work that used them. External supplier or manufacturer lot identity is preserved through internal splits and movements. A new internal population identifier does not by itself establish a new regulatory lot code.
Recipes and released batches retain the approved revisions, measurement basis, specifications and packaging information. Actual input lots connect to output through source-bound quantities and costs. A separate trace view can conservatively include all commingled descendants; its rows are not another inventory balance and cannot be summed as additional cost.
Reservations, held quantities, actual use, output and returns consume their exact remaining source scope. A partial release applies only to its identified population. Other holds and date restrictions remain effective. Posted corrections preserve the original event and link their reviewed effects instead of rewriting performed history.
Financial records keep document, source and functional currency bases. Current carrying and previous adjustments follow the source into settlement, return or disposition. Repeated imports retain their external identity; conflicting content and uncertain outcomes remain unresolved until reconciled.
Migration order
-
Prepare identities and approved definitions
Ends with: Map companies, facilities, users, customers, suppliers, products, units, accounts and policies. Load the approved recipes, routing, quality specifications and label revisions needed by the selected scope. Validate references and current decision authority.
-
Establish stock and production history
Ends with: Reconcile lot populations, original supplier/output identity, date evidence, active holds, reservations and current carrying. Map issued work, consumed input claims, terminal output and remaining WIP without recreating receipts or production. Preserve genealogy and historical customer deliveries required for tracing.
-
Reconcile the financial opening
Ends with: Agree the cutoff and one opening ledger with nonposting stock, WIP, customer and supplier detail. Preserve open orders, actual receipt and shipment history, partial billing, settlement and prior currency adjustments. Resolve duplicate identities and uncertain external events before enabling new postings.
-
Exercise the first native transactions
Ends with: Check a remaining purchase acceptance, production completion, partial release, delivery and settlement against the imported position. Run a trace exercise and a source-linked return. Obtain the required opening approval and enable eligible new work only after quantities and finance reconcile.
Tables
108 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; actual person, current entity/warehouse/quality/action scope and finite authority apply. Services cannot approve human gates. |
EntityScope | longtext | yes | Explicit Entities keys; current scope checked on every read/action/export. |
WarehouseScope | longtext | Explicit permitted Warehouses; absent does not mean global access. | |
ExpiresAt | datetime | Scope expiry. | |
ScopeChange | reference | → MasterChanges. Independent domain-reviewed grant of roles/entities/warehouse scope; Admin cannot self-grant business authority. Revocation may restrict immediately. |
EntitiesSeparate legal books and stock ownership; shared masters do not consolidate balances.master
| Field | Type | Required | Details |
|---|---|---|---|
EntityCode | text | yes | Unique legal entity code. |
Name | text | yes | Legal name. |
FunctionalCurrency | reference | yes | → Currencies. One functional currency; changing it requires separately scoped migration. |
Timezone | text | yes | IANA business timezone; timestamps retain offsets. |
Status | select | yes | Setup, Active, Closed |
Policy | reference | → FoodPolicies. 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. |
FoodPoliciesVersioned 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, recipe/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. Actual verified customer handover/pickup or carrier dispatch owns stock/COGS once; invoice, label printing, quality release and payment do not. |
PreparedBy | reference | yes | → Users. Admin prepares configuration; respective Sales Manager, Purchasing Manager, Warehouse Manager, Production 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 Production Manager for assembly/kitting/repacking rules. | |
CommercialDecision | reference | → ApprovalDecisions. Independent Sales Manager customer/price/minimum-life/contact-authority rules; Quality Manager separately approves product/date/quality implications. | |
QualityDecision | reference | → ApprovalDecisions. Independent Quality Manager recipe/specification/allergen/label, lot-portion, shelf/opened-life, storage, trace and release rules; excludes criteria/preparer/material editors. | |
FoodRules | longtext | yes | Exact active specifications, required observations, identifiable partial populations, overlapping holds, immutable lot-date inheritance, delivery-date remaining-life check and conservative unknown genealogy. No unspecified safety threshold, legal allergen list or compliance guarantee. |
MasterChangesProtected master activation without direct Manage permission bypass.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
ChangeNumber | text | yes | Unique change request. |
TargetTable | text | yes | Existing allowed master table. |
TargetKey | text | yes | Exact immutable record/version key. |
Status | select | yes | Draft, Submitted, Approved, Applied, Rejected, Cancelled |
BeforeHash | text | yes | Expected prior content or explicit create marker. |
ProposedContent | longtext | yes | Exact after-content and affected transactions. |
ProposedHash | text | yes | Frozen proposed content. |
PreparedBy | reference | yes | → Users. Actual person. |
SubmittedAt | datetime | Actual submission time. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
Decision | reference | → ApprovalDecisions. Independent affected owners: Finance Manager money/cost/tax/bank/authority; Sales Manager customer/prices/contact; Purchasing Manager supplier commercial; Warehouse Manager custody; Production Manager technical recipe/routing; Quality Manager specification, declared allergens, labels, shelf-life and quality. All required decisions bind one content snapshot and exclude material contributors. | |
AppliedAt | datetime | Guarded application; changes do not rewrite accepted or posted source snapshots. | |
OperationalDecision | reference | → ApprovalDecisions. Independent Warehouse Manager for stock/location/fulfillment; production technical changes need their separate Production Manager decision. | |
FinanceDecision | reference | → ApprovalDecisions. Required independent Finance Manager for costs/limits/beneficiary/tax/posting/price-floor changes. | |
CommercialDecision | reference | → ApprovalDecisions. Required independent Sales Manager for customer/price commercial changes. | |
ProductionDecision | reference | → ApprovalDecisions. Independent Production Manager for BOM/routing/execution changes. |
DocumentRevisionsImmutable typed document snapshots and source basis.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
RevisionNumber | text | yes | Unique target/revision key. |
TargetTable | text | yes | Exact allowed existing table name, validated against source record. |
TargetKey | text | yes | Exact immutable primary identifier. |
Revision | number | yes | Monotonic revision. |
Status | select | yes | Submitted, Approved, Accepted, Posted, Superseded, Cancelled |
ContentHash | text | yes | Canonical body/lines/source/rates/cost/tax hash. |
Content | longtext | yes | Complete frozen content, material editor person IDs, related source versions and scoped allocations. |
PreparedBy | reference | yes | → Users. Actual preparer. |
FrozenAt | datetime | yes | Actual freeze time. |
ApprovalDecisionsAuthoritative human decisions independent of document lifecycle.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
DecisionNumber | text | yes | Unique decision identity. |
Action | select | yes | MasterActivation, PolicyActivation, QuoteException, OrderAcceptance, CreditException, PurchaseApproval, InvoiceApproval, BillException, PaymentRelease, Refund, FinanceCorrection, StockRelease, TransferApproval, CountAdjustment, ReturnAuthorization, ReturnDisposition, ShipmentRelease, ProductionRelease, ProductionTimeAcceptance, ProductionCompletion, ProductionVariance, ProductionClose, ProductionCloseFinance, QualityRelease, QualityDisposition, DateApproval, DateReassessment, TraceReview, TraceContact, TraceClose, JournalApproval, RevaluationApproval, PeriodClose, PeriodReopen, MigrationActivation |
Status | select | yes | Pending, Approved, Rejected, Expired, Superseded |
Snapshot | reference | → DocumentRevisions. Required for revisioned transaction actions; master/policy request content hash otherwise retained in Scope. | |
Scope | longtext | yes | Exact current source/action/revision, entity/warehouse/lot/portion, quantity/value/currency, applicable dates/specifications/label, expiry and excluded actual preparer/material editor/producer/receiver/inspector identities. A quality/technical decision never substitutes for financial authority or external customer acceptance. |
RequestedBy | reference | yes | → Users. Actual preparer/requester. |
RequestedAt | datetime | yes | Actual time. |
DecidedBy | reference | → Users. Actual independent human with declared required role, current scope and limit. Service/Admin privilege is not domain approval. | |
DecidedAt | datetime | Actual decision time. | |
Delegation | reference | → AuthorityDelegations. Valid named delegate, preserving required role and actual-person independence. | |
AuthorityRate | reference | → ExchangeRates. Exact currency conversion for limit test; no missing-rate fallback. | |
AuthorityAmount | decimal | Amount in delegated/role authority currency; cumulative relevant commitment and gross increases included. | |
Reason | longtext | yes | Decision rationale, rejected conditions and reviewed evidence. |
AssignedTo | reference | yes | → Users. Named eligible human reviewer when Pending; independence and current role/limit rechecked at decision. |
AuthorityDelegationsTime- and scope-bounded coverage, never a new role.master
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
DelegationNumber | text | yes | Unique authority grant. |
Principal | reference | yes | → Users. Original authorized human. |
Delegate | reference | yes | → Users. Different actual human already holding required declared role. |
RequiredRole | select | yes | Sales Manager, Purchasing Manager, Warehouse Manager, Finance Manager |
ActionScope | longtext | yes | Exact actions/entities/warehouses and excluded documents. |
LimitCurrency | reference | yes | → Currencies. Authority currency. |
AmountLimit | decimal | yes | Finite nonnegative ceiling; cannot exceed principal authority. |
StartsAt | datetime | yes | Inclusive. |
EndsAt | datetime | yes | Exclusive. |
Status | select | yes | Draft, Active, Revoked, Expired |
GrantedBy | reference | yes | → Users. Independent same-domain authorized owner; no self-grant or approval escalation. |
IntegrationEventsAuthenticated inbound/manual evidence with idempotent economic effects.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
EventNumber | text | yes | Unique source event key. |
Source | text | yes | Configured provider or reviewed manual source. |
ExternalKey | text | yes | Unique within source/entity; preserve provider attempts and economic identity. |
Kind | select | yes | Receipt, Shipment, Delivery, BankSettlement, BankRejection, BankReturn, DocumentAcknowledgment, Migration, Other |
Status | select | yes | Received, Verified, Applied, Ignored, ReviewRequired, Rejected |
PayloadHash | text | yes | Conflict on reused key blocks effects. |
Payload | longtext | yes | Protected evidence and expected source/version mapping. |
OccurredAt | datetime | yes | Actual source event time. |
ReceivedAt | datetime | yes | Received time. |
VerifiedBy | reference | → Users. Human reviewer or authenticated configured service; role-required decisions separate. | |
AppliedAt | datetime | Atomic local effect time. |
IntegrationDeliveriesOutbound intent, attempt and reconciliation; a timeout is not nonexecution.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
DeliveryNumber | text | yes | Unique intent/attempt. |
EconomicKey | text | yes | Stable economic operation and destination across retries. |
Destination | text | yes | Configured exact connector/recipient; no invented endpoint. |
Snapshot | reference | → DocumentRevisions. Frozen payload source. | |
PayloadHash | text | yes | Exact expected payload. |
Status | select | yes | Prepared, Submitted, Acknowledged, Rejected, Uncertain, Reconciled, Cancelled |
CreatedAt | datetime | yes | Intent time. |
SubmittedAt | datetime | Actual attempt time. | |
ProviderKey | text | Provider response identifier. | |
Event | reference | → IntegrationEvents. Authoritative response; acknowledgment is not cash/title/delivery completion. | |
RetryOf | reference | → IntegrationDeliveries. Only after proven nonexecution; uncertain operation remains reserved. |
MigrationBatchesReviewed cutover: one full opening GL plus nonposting detailed balances.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
BatchNumber | text | yes | Stable import identity. |
Status | select | yes | Draft, Validating, PendingApproval, Approved, Applied, Rejected |
CutoffAt | datetime | yes | Frozen source/system watermark. |
SourceHash | text | yes | Immutable extraction digest. |
OpeningJournal | reference | yes | → JournalEntries. Single full opening journal including subledger controls; detail never reposts it. |
Reconciliation | longtext | yes | One entity opening GL versus reconciled nonposting current stock/transit/WIP, external lots/internal portions, original date/label/genealogy, overlapping live holds/releases, historical customer deliveries, remaining source claims and open finance/carrying/prior FX. No historical receipt, production, title, invoice or cash replay. |
PreparedBy | reference | yes | → Users. Actual preparer. |
Decision | reference | → ApprovalDecisions. Independent Finance Manager activation plus Warehouse Manager stock and Production Manager WIP/output evidence. Required before Active; import does not replay operational or monetary effects. | |
AppliedAt | datetime | One successful baseline activation. |
MigrationItemsReplay-safe original identities, detailed remaining balances and prior effects.line
| Field | Type | Required | Details |
|---|---|---|---|
Batch | reference | yes | → MigrationBatches. Owning cutover. |
SourceKey | text | yes | Stable source/type/ID; unique across repeated batches for same baseline. |
TargetTable | text | yes | Existing permitted table name. |
TargetKey | text | yes | Resolved local immutable key. |
PayloadHash | text | yes | Conflicting replay requires review, never a second opening. |
Baseline | longtext | yes | Original accepted/priced/received/shipped/delivered/invoiced/settled/cancelled amounts and quantities; current carrying/revaluation, stock layers, WIP, approvals and source-event watermarks. |
Status | select | yes | Mapped, Validated, Applied, Conflict |
AppliedAt | datetime | Nonposting detail activation time; notifications/dispatch/payment creation suppressed. Absent until the real action; mandatory before the corresponding active/approved/posted state. |
CloseTasksCurrent source reconciliation evidence for an entity cutoff.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
TaskNumber | text | yes | Unique period/check/cutoff scope. |
Period | reference | yes | → AccountingPeriods. Same entity. |
Kind | select | yes | Bank, AR, AP, Inventory, Transit, WIP, GRNI, QualityHolds, ShelfLife, Genealogy, Withdrawal, Tax, Credits, UnappliedCash, Revaluation, Interfaces |
Status | select | yes | Open, InProgress, Complete, ReviewRequired, Waived |
Owner | reference | yes | → Users. Assigned Accountant or relevant operational evidence owner. |
CutoffAt | datetime | yes | Precise evidence cutoff. |
SourceHash | text | yes | Population/version hash; changed source invalidates completion. |
Evidence | longtext | yes | Reconciliation totals, exceptions and prerequisites; required missing balances cannot be hidden by Complete. |
ReviewedBy | reference | → Users. Independent Finance Manager for unresolved exceptions/allowed waiver. | |
CompletedAt | datetime | Actual evidence completion. |
AccountsEntity-scoped 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 Sales Manager commercial and Finance Manager credit/tax approval as applicable. | |
RelatedEntity | reference | → Entities. Explicit intercompany trading counterparty; still separate legal documents, no automatic elimination. | |
Owner | reference | yes | → Users. Sales 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 canonical stocked SKU for each physical product/variant or produced kit; styles, barcodes and channel aliases never create extra stock.master
| Field | Type | Required | Details |
|---|---|---|---|
ProductCode | text | yes | Unique SKU. |
Name | text | yes | Product description. |
BaseUnit | reference | yes | → UnitsOfMeasure. Stock and production base quantity unit. |
LotControlled | boolean | yes | Must be true for every selected recipe ingredient, packaging material, intermediate and finished output: actual source lot and identified portion required before use, issue, output or handover. A false generic flag or missing provenance cannot bypass batch tracing; unknown source remains blocked/unresolved, never fabricated. |
Status | select | yes | Draft, Active, OnHold, Inactive |
ProductKind | select | yes | Stock, ManufacturedBatch, Repacked |
Activation | reference | → MasterChanges. Independent Warehouse Manager product/base-unit/lot/portion identity, Sales Manager commercial, Production Manager manufactured batch/recipe/routing and Quality Manager declarations/specification/shelf-life/label approval; separate Finance Manager financial setup where affected. ProductKind describes purchased/produced/repacked route, while Kind describes Ingredient/Packaging/Intermediate/Finished use; these classifications are orthogonal, not duplicate SKU owners. | |
SerialControlled | boolean | yes | Each serialized position/effect identifies exactly one base unit; all accepted unit/pack conversions preserve it. |
Kind | select | yes | Ingredient, Packaging, Intermediate, Finished |
ShelfLifePolicy | reference | → ShelfLifePolicies. Current approved default; received/released batches freeze actual applicable version, not retrospectively replaced. | |
AllergenDeclarations | longtext | yes | Reviewed applicable declared ingredient/handling information with supplier/formula evidence, known absence versus unknown and actual jurisdiction/customer scope; no universal legal list or automatic compliance statement. |
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 Sales Manager; Finance Manager confirms configured floor/cost policy. Absent until the real action; mandatory before the corresponding active/approved/posted state. |
PriceListEntriesQuantity-tier price basis in a named product unit.line
| Field | Type | Required | Details |
|---|---|---|---|
PriceList | reference | yes | → PriceLists. Effective immutable version. |
ProductUnit | reference | yes | → ProductUnits. Exact quantity/price basis. |
MinimumQuantity | decimal | yes | Nonnegative transaction-unit tier boundary; highest eligible boundary wins within selected list. |
UnitListPrice | decimal | yes | Nonnegative known document-currency price; zero requires explicit policy. |
MinimumNetPrice | decimal | Approved optional floor in the same unit/currency, not a cost estimate. |
StandardCostsEntity/product standard per base unit with immutable effective versions.master
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Product | reference | yes | → Products. SKU. |
Version | number | yes | Unique effective version. |
UnitStandardCost | decimal | yes | Known nonnegative entity-functional value per base unit; explicit approved zero is possible, missing is not zero. |
StartsAt | datetime | yes | Inclusive. |
EndsAt | datetime | Exclusive. | |
Status | select | yes | Draft, Active, Superseded |
CostBasis | longtext | yes | Reviewed input/labour/overhead basis; no double inclusion. |
Activation | reference | → MasterChanges. Independent Finance Manager activation with Production Manager or Purchasing Manager reviewed technical/commercial cost basis; no rewrite of released WIP or earlier output. |
PostingProfilesApproved source-specific stock, production and trade posting mappings.master
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
ProfileCode | text | yes | Unique version. |
Product | reference | yes | → Products. Exact product or configured explicitly named product class mapping. |
InventoryAccount | reference | yes | → ChartOfAccounts. Owned inventory control. |
WIPAccount | reference | yes | → ChartOfAccounts. Work-order WIP control. |
GRNIAccount | reference | yes | → ChartOfAccounts. Receipt accrual control. |
COGSAccount | reference | yes | → ChartOfAccounts. Sales cost at title event only. |
RevenueAccount | reference | yes | → ChartOfAccounts. Revenue at supported invoice recognition basis. |
PurchaseVarianceAccount | reference | yes | → ChartOfAccounts. Receipt/bill price variance; never hidden in decimal rounding. |
ProductionVarianceAccount | reference | yes | → ChartOfAccounts. Released production variance after complete WIP reconciliation. |
Status | select | yes | Draft, Active, Superseded |
Activation | reference | → MasterChanges. Independent Finance Manager review. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
SupplierReturnClearingAccount | reference | yes | → ChartOfAccounts. Clears current carrying of billed supplier returns against subsequent independently approved commercial credit; residual difference is classified, never hidden. |
ScrapAccount | reference | yes | → ChartOfAccounts. Reviewed stock/WIP scrap or loss expense, not a duplicate completion variance. |
WarehousesPhysical sites may host segregated entity-owned positions; legal owner stays on each position.master
| Field | Type | Required | Details |
|---|---|---|---|
WarehouseCode | text | yes | Unique physical site. |
Name | text | yes | Operational name. |
Timezone | text | yes | IANA site timezone. |
Status | select | yes | Active, Suspended, Closed |
PermittedEntities | longtext | yes | Explicit Entities allowed; not a transfer of ownership or access. |
Manager | reference | yes | → Users. Assigned Warehouse Manager with scope. |
LocationsShallow warehouse bins, staging and transit custody locations.master
| Field | Type | Required | Details |
|---|---|---|---|
Warehouse | reference | yes | → Warehouses. Physical/source operating site. |
LocationCode | text | yes | Unique within warehouse. |
Kind | select | yes | Storage, Receiving, Picking, Dispatch, Held, Transit, Production |
Status | select | yes | Active, Blocked, Closed |
QuotesVersioned customer offers with known pricing basis and real acceptance lineage.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Currency | reference | yes | → Currencies. Document currency; amounts use this currency unless stated otherwise. |
Rate | reference | yes | → ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
QuoteNumber | text | yes | Unique entity quote. |
Account | reference | yes | → Accounts. Same entity. |
Status | select | yes | Draft, Submitted, Approved, Sent, Accepted, Expired, Rejected, Superseded |
QuoteDate | date | yes | Offer date. |
ValidUntil | datetime | yes | Expiry of exact offer revision. |
Owner | reference | yes | → Users. Sales 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 Sales Manager; routine within-policy quote sending is Sales Coordinator preparation, not the mandatory order gate. |
QuoteLinesAll line/header discounts allocated once into accepted net value.line
| Field | Type | Required | Details |
|---|---|---|---|
Quote | reference | yes | → Quotes. Parent revision. |
LineNumber | number | yes | Stable line key. |
ProductUnit | reference | yes | → ProductUnits. Frozen conversion basis. |
Quantity | decimal | yes | Positive quoted transaction units. |
BaseQuantity | decimal | yes | Quantity × frozen conversion factor. |
UnitListPrice | decimal | yes | Known quoted currency/unit amount. |
LineDiscount | decimal | yes | Nonnegative amount in quote currency, bounded by list extension. |
HeaderDiscountAllocation | decimal | yes | Nonnegative allocated share with deterministic final remainder. |
NetAmount | decimal | yes | Quantity × UnitListPrice − LineDiscount − HeaderDiscountAllocation, rounded once; nonnegative. |
TaxCode | reference | → TaxCodes. Frozen effective treatment, rate and evidence; missing required tax blocks release. | |
TaxAmount | decimal | yes | Tax on eligible NetAmount once; explicit exempt zero requires evidence. |
StandardCost | reference | → StandardCosts. Entity cost basis; absent/unknown cost routes margin review, never zero. | |
MarginPercent | decimal | 100 × (NetAmount − converted extended cost) / NetAmount; null for zero net/unknown basis. |
SalesOrdersAccount-accepted scope plus mandatory independent commercial approval.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Currency | reference | yes | → Currencies. Document currency; amounts use this currency unless stated otherwise. |
Rate | reference | yes | → ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
OrderNumber | text | yes | Unique entity order. |
Account | reference | yes | → Accounts. Same entity. |
Quote | reference | → Quotes. Accepted source revision; generated orders consume its remaining accepted scope once. | |
Status | select | yes | Draft, Submitted, OnHold, Approved, InProgress, PartiallyShipped, Shipped, Invoiced, Closed, Cancelled |
OrderDate | date | yes | Commercial date. |
Owner | reference | yes | → Users. Sales 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. Actual verified customer handover/pickup or carrier dispatch transfers stock/COGS once. Unsupported commercial title terms require reviewed implementation scope before activation. |
NetTotal | decimal | yes | Sum accepted SalesOrderLines.NetAmount. |
TaxTotal | decimal | yes | Sum line tax once. |
CreditReview | reference | yes | → CreditReviews. Current entity/customer exposure snapshot and valid exception if needed. |
AcceptedAt | datetime | Independent Sales Manager approval time bound to exact customer acceptance, prices, address, title rule and quantities. | |
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. |
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; Sales Manager still approves order. |
RequisitionsOperational purchasing demand without automatic spend approval.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
RequisitionNumber | text | yes | Unique request. |
Status | select | yes | Draft, Submitted, Approved, Rejected, Converted, Cancelled |
RequestedAt | datetime | yes | Actual request. |
NeededBy | date | yes | Required supply date. |
RequestedBy | reference | yes | → Users. Warehouse Manager, Production Operator or other authorized operational requester. |
Decision | reference | → ApprovalDecisions. Independent Purchasing Manager within configured authority, Finance Manager above limit; conversion consumes only approved remaining scope. |
RequisitionLinesRequested product quantities and source demand identity.line
| Field | Type | Required | Details |
|---|---|---|---|
Requisition | reference | yes | → Requisitions. Parent request. |
LineNumber | number | yes | Stable key. |
ProductUnit | reference | yes | → ProductUnits. Requested buy unit. |
Quantity | decimal | yes | Positive transaction units. |
Warehouse | reference | yes | → Warehouses. Intended receiving site. |
OrderLine | reference | → SalesOrderLines. Optional specific demand; proposal and generated PO are one supply. |
PurchaseOrdersImmutable approved supplier commitments; cumulative amendments cannot bypass authority.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Currency | reference | yes | → Currencies. Document currency; amounts use this currency unless stated otherwise. |
Rate | reference | yes | → ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
PurchaseOrderNumber | text | yes | Unique supplier order. |
Supplier | reference | yes | → Suppliers. Active same-entity supplier. |
Status | select | yes | Draft, Submitted, Approved, Sent, PartiallyReceived, Received, Closed, Cancelled |
OrderDate | date | yes | Commercial date. |
Buyer | reference | yes | → Users. Purchasing Manager preparing the order. |
OriginalApprovedTotal | decimal | yes | Original approved commitment in order currency; retained through amendments. |
CumulativeGrossIncreases | decimal | yes | Sum positive line-level increases/new-line amounts over all approved amendments; decreases never conceal increases/category changes. |
CurrentTotal | decimal | yes | Current net plus approved applicable tax/freight, in document currency. |
ApprovalBasis | decimal | yes | At least max(CurrentTotal, OriginalApprovedTotal + CumulativeGrossIncreases), converted using retained authority rate; changed scope reviewed too. |
SentAt | datetime | Actual outbound evidence. |
PurchaseOrderLinesBuy-unit quantities, frozen commercial costs and current accepted scope.line
| Field | Type | Required | Details |
|---|---|---|---|
PurchaseOrder | reference | yes | → PurchaseOrders. Parent accepted revision. |
LineNumber | number | yes | Stable key; fulfilled quantity/cost cannot be silently repriced. |
RequisitionLine | reference | → RequisitionLines. Converted demand allocation. | |
ProductUnit | reference | yes | → ProductUnits. Frozen conversion. |
Quantity | decimal | yes | Positive ordered buy units. |
BaseQuantity | decimal | yes | Quantity × frozen base factor. |
UnitNetPrice | decimal | yes | Known net document-currency price per buy unit, already discounted. |
NetAmount | decimal | yes | Quantity × UnitNetPrice rounded once. |
TaxCode | reference | → TaxCodes. Effective purchase treatment/evidence. | |
TaxAmount | decimal | yes | Tax on eligible net once. |
Warehouse | reference | yes | → Warehouses. Receiving site. |
OriginalPromiseAt | datetime | yes | Original supplier promised cutoff. |
RevisedPromiseAt | datetime | Separate reviewed current promise. | |
CancelledBaseQuantity | decimal | yes | Approved unreceived/unmatched remaining scope only. |
Baseline | longtext | yes | Nonposting accepted/returned/matched/cancelled quantities and commercial values at migration. |
Status | select | yes | Open, PartiallyReceived, Received, Closed, Cancelled |
GoodsReceiptsImmutable actual arrivals and separately accepted quantities.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
ReceiptNumber | text | yes | Unique supplier arrival. |
PurchaseOrder | reference | yes | → PurchaseOrders. Approved same-entity supplier order. |
Warehouse | reference | yes | → Warehouses. Actual site. |
Status | select | yes | Draft, Arrived, PendingReview, Accepted, PartiallyAccepted, Rejected, Corrected |
ArrivedAt | datetime | yes | Actual arrival, never scheduled date. |
ReceivedBy | reference | yes | → Users. Warehouse Operator independent of PO creator/buyer and commercial approver. |
ConfirmedAt | datetime | Physical evidence confirmed and accepted line effects committed. | |
Evidence | longtext | yes | Supplier document, delivery count and condition/inspection evidence. |
GoodsReceiptLinesReceipt history does not change as accepted inventory moves or is consumed.line
| Field | Type | Required | Details |
|---|---|---|---|
Receipt | reference | yes | → GoodsReceipts. Actual arrival. |
OrderLine | reference | yes | → PurchaseOrderLines. Exact approved supply. |
ArrivedBaseQuantity | decimal | yes | Nonnegative actual arrived total. |
AcceptedBaseQuantity | decimal | yes | Derived total live posted Accept tranches; receipt history is not reduced by later picking/consumption/shipping. Accepted supplier returns are separate fulfillment corrections. |
RejectedBaseQuantity | decimal | yes | Derived total live confirmed Reject tranches; never usable owned inventory or GRNI. |
PendingBaseQuantity | decimal | yes | ArrivedBaseQuantity minus accepted and rejected tranches; held pending stock is not posted as owned usable inventory. |
LotNumber | text | Required for lot-controlled product. | |
Location | reference | yes | → Locations. Receiving/held storage location as appropriate. |
StandardCost | reference | → StandardCosts. Proposed reviewed cost only; each actual ReceiptAcceptances tranche freezes its own effective cost. | |
CommercialFunctionalValue | decimal | Proposed value only; authoritative accepted values are the sum of posted ReceiptAcceptances, not a second payable or receipt. | |
ReceiptRate | reference | → ExchangeRates. Proposed receipt valuation; each accepted tranche freezes the actual required dated rate. | |
AcceptanceEvent | reference | → StockEvents. Optional first-acceptance convenience link; all authoritative tranches/effects are ReceiptAcceptances. No one-event-per-full-arrival assumption. | |
Lot | reference | → Lots. Required incoming controlled identity; supplier lot mapping verified before acceptance. | |
Serial | reference | → Serials. Required per serialized arrived unit; duplicate serial arrival cannot create owned stock. | |
Portion | reference | → LotPortions. Required for lot-controlled food 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. |
BillMatchesReserve and consume accepted receipt versus bill quantities/value once.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
MatchNumber | text | yes | Unique matching allocation. |
BillLine | reference | yes | → BillLines. Exact proposed/posted supplier invoice line. |
ReceiptLine | reference | yes | → GoodsReceiptLines. Unused accepted supplier supply. |
Status | select | yes | Reserved, Matched, Released, Reversed |
BaseQuantity | decimal | yes | Positive scope bounded by net accepted unreturned/unmatched supply and bill quantity. |
ReceiptAccrualFunctional | decimal | yes | Original GRNI amount allocated with final remainder. |
BillNetFunctional | decimal | yes | Same-scope invoice net/capitalizable tax at bill rate. |
VarianceFunctional | decimal | yes | BillNetFunctional − ReceiptAccrualFunctional; price/rate components documented, not another full inventory debit. |
CreatedAt | datetime | yes | Claim time. |
PostedAt | datetime | Posted once with the bill. | |
Decision | reference | → ApprovalDecisions. Independent Finance Manager for mismatches/non-PO exceptions; a changed PO needs independent procurement approval too. | |
ReversalOf | reference | → BillMatches. Exact prior match and downstream credit evidence. | |
ReceiptAcceptance | reference | yes | → ReceiptAcceptances. Exact posted accepted tranche; ReceiptLine must be its parent. Reserved/posted matches bounded by this tranche's unreturned unmatched quantity. |
InventoryPositionsCurrent owned stock by complete identity and custody state; provenance is not a second balance.master
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Product | reference | yes | → Products. Stock SKU. |
Warehouse | reference | yes | → Warehouses. Operating site; source site retained for away transit. |
Location | reference | yes | → Locations. Storage, picking, transit or production custody. |
LotNumber | text | Required if controlled; identity cannot be edited to relabel stock. | |
CustodyState | select | yes | Available, Held, Picked, Transit, Production. Production is staged but not yet financially issued inventory; actually issued material leaves these inventory positions into separately traced work-order WIP custody. |
QuantityOnHand | decimal | yes | Nonnegative current base quantity; only posted signed stock movements update it. |
CarryingValue | decimal | yes | Nonnegative entity-functional inventory carrying, sum remaining StockLayers once. Issued material value is in WorkOrderCostEntries/WIP, not another production-position balance. |
ReservedQuantity | decimal | yes | Sum live Soft/Hard/Picked/InTransit claims on this exact position; physical picked/transit remains committed, no automatic timer release. |
AvailableQuantity | decimal | yes | Eligible available quantity less active claims; held/picked/transit/production unavailable to another order. |
Version | number | yes | Monotonic position version checked atomically. |
Status | select | yes | Active, Empty, Blocked |
Lot | reference | → Lots. Exact same entity/product lot; required when lot-controlled. Legacy display LotNumber must agree, never independent identity. | |
Serial | reference | → Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row. | |
Portion | reference | → LotPortions. Required for lot-controlled food 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. |
StockLayersRemaining quantity/carrying value with receipt/output/return lineage.master
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Position | reference | yes | → InventoryPositions. Current exact owned identity. |
Product | reference | yes | → Products. Same SKU. |
OriginEvent | reference | yes | → StockEvents. Original acceptance/output/migration provenance. |
ParentLayer | reference | → StockLayers. Split/moved origin; parent stores only remaining balance, never duplicates descendant quantities. | |
OriginalQuantity | decimal | yes | Immutable layer created base quantity. |
RemainingQuantity | decimal | yes | Current nonnegative quantity. |
RemainingValue | decimal | yes | Current standard carrying value; zero quantity requires zero value with residual resolved explicitly. |
StandardCost | reference | → StandardCosts. Applied current standard version or traced customer-return carrying basis. | |
UnconsumedSource | longtext | yes | Origin commercial/reference quantities and descendant trace, including changes and returns. |
Version | number | yes | Atomic allocation/version. |
Status | select | yes | Open, Depleted, Held |
Lot | reference | → Lots. Exact same entity/product lot, required when lot-controlled; display values derive from this identity. | |
Serial | reference | → Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row. | |
Portion | reference | → LotPortions. Required for lot-controlled food 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. |
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 |
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. |
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 food 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 or transfer demand owner. Hard/Picked/TitleIssue sales claims require the current independent Sales Manager-approved order. Production-material claims require current independent Production Manager work release and approved material scope; transfer claims require independent Warehouse Manager transfer approval. Every path also requires exact eligible owned stock and current quality/date/portion checks; no fictitious sales order for production/transfer 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 food 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. |
StockTransfersSame-entity transfer with actual dispatch/partial receipt and retained owned transit.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
TransferNumber | text | yes | Unique internal transfer. |
SourceWarehouse | reference | yes | → Warehouses. Source site. |
DestinationWarehouse | reference | yes | → Warehouses. Different allowed destination site. |
Status | select | yes | Draft, PendingApproval, Approved, PartiallyDispatched, InTransit, PartiallyReceived, Received, Closed, Cancelled |
RequestedAt | datetime | yes | Request time. |
DispatchedAt | datetime | First actual dispatch, not planned date. | |
CompletedAt | datetime | All dispatched quantity received or independently resolved with explicit loss/return evidence. |
StockTransferLinesPartial transfer quantities retain equal in-transit ownership and cost.line
| Field | Type | Required | Details |
|---|---|---|---|
Transfer | reference | yes | → StockTransfers. Same entity. |
Product | reference | yes | → Products. SKU. |
BaseQuantity | decimal | yes | Positive approved quantity. |
LotNumber | text | Required controlled identity. | |
SourceLocation | reference | yes | → Locations. Actual source. |
DestinationLocation | reference | yes | → Locations. Actual destination. |
DispatchedQuantity | decimal | yes | Posted net actual dispatch, not request. |
ReceivedQuantity | decimal | yes | Posted accepted destination quantity; bounded by unresolved dispatched quantity. |
ResolvedLossQuantity | decimal | yes | Separately approved loss/damage disposition, never marked received. |
TransitValue | decimal | yes | Unresolved dispatched carrying value; never disappears on close. |
CountLocksTime-bounded counted scope protecting all identities, including newly appearing positions.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
LockNumber | text | yes | Unique lock request. |
Count | reference | yes | → InventoryCounts. Owning count. |
Warehouse | reference | yes | → Warehouses. Counted warehouse. |
Scope | longtext | yes | Exact physical locations/products/identities, including empty/new positions and null-bin population. Away transit excluded from floor population. |
SnapshotHash | text | yes | Whole locked-scope identity/version population; unrelated site changes do not invalidate it. |
StartsAt | datetime | yes | Actual successful lock. |
EndsAt | datetime | yes | Expiry; resumed movements require fresh snapshot/recount. |
Status | select | yes | Active, Released, Expired, Invalidated |
InventoryCountsBlind scoped counts with explicit review and cost before adjustment.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
CountNumber | text | yes | Unique count. |
Warehouse | reference | yes | → Warehouses. Physical scope. |
Status | select | yes | Planned, Locked, Counting, PendingReview, Approved, Posted, Closed, Invalidated |
PlannedStart | datetime | yes | Planned window. |
PlannedEnd | datetime | yes | Planned end. |
Owner | reference | yes | → Users. Warehouse Manager. |
Counter | reference | yes | → Users. Warehouse Operator independent of adjustment approval. |
Policy | reference | yes | → FoodPolicies. 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 food 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, PartiallyDelivered, Delivered, Exception, Closed, Cancelled |
TitleRule | select | yes | Handover. Actual customer handover/carrier dispatch issues exact eligible portions and current cost once; labels, approvals and payment requests do not. |
CarrierReference | text | Configured external handoff reference; no carrier booking claim. | |
HandedOverAt | datetime | Actual verified customer handover or carrier dispatch instant; a ready state, label or booking acknowledgment is insufficient. | |
HandoverEvidence | longtext | Actual 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 title-handover quantity across the supported mode; history stays intact through later returns. |
TitleTransferredQuantity | decimal | yes | Exact once-only TitleIssue quantity at actual handover/dispatch; bounded by approved remaining order and hard stock claim. |
DeliveredQuantity | decimal | yes | Cumulative accepted customer-delivery history, net only of approved factual evidence corrections. Physical returns never decrement this history or reopen old fulfillment eligibility. |
ReturnedQuantity | decimal | yes | Actual reconciled returned quantity, separate from original dispatch history. |
CarryingValueIssued | decimal | yes | Exact layer carrying value consumed by title transfer; no second cost at invoice/POD. |
OriginalDispatchEvent | reference | → StockEvents. TitleIssue at actual handover/dispatch; later carrier POD never issues stock/COGS again. | |
Portion | reference | → LotPortions. Required for lot-controlled food 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. |
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 title-handed-over source. Actual customer handover/pickup may create this same acceptance evidence atomically, never a second title issue. |
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 food recipe/formula for one primary output with independent technical and 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 recipe output basis. |
Version | number | yes | Immutable technical revision. |
StartsAt | datetime | yes | Inclusive. |
EndsAt | datetime | Exclusive. | |
Status | select | yes | Draft, Active, Superseded |
Activation | reference | → MasterChanges. Independent Production Manager technical recipe and independent Quality Manager applicable ingredient/specification/allergen/label approval, excluding preparers/editors; Finance Manager separately approves cost standards/rates. | |
LabelVersion | reference | → LabelVersions. Reviewed product/packaging/artwork default required for labeled output; each actual batch freezes its version. | |
QualityPlan | reference | yes | → InspectionPlans. Compatible active in-process/final specification; different required checks listed in QualityPrerequisites. |
AllergenSnapshot | longtext | yes | Exact effective ingredient/formula declarations and source evidence; unresolved or contradictory required declarations hold release. No automatic legal determination from ingredient names. |
ScalingRule | longtext | yes | Target primary output divided by frozen BOMs.OutputBaseQuantity, applied to every line in its own base unit, with deterministic rounding and reviewed deviations; no unlike-unit sum or double planning loss. |
QualityPrerequisites | longtext | yes | Exact effective incoming/process/final tests, changeover/cleaning/conditions and label confirmation required for this recipe/operation. These are configured evidence requirements, not a validated safety program invented by this system. |
BOMLinesComponent quantities per explicit output basis, preserving dimensions and allowed loss.line
| Field | Type | Required | Details |
|---|---|---|---|
BOM | reference | yes | → BOMs. Versioned recipe. |
LineNumber | number | yes | Stable component identity. |
Component | reference | yes | → Products. Input SKU; cycles forbidden across active recipes. |
BaseQuantity | decimal | yes | Positive input base quantity per BOM output basis. |
PlannedScrapPercent | decimal | yes | 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 ingredients into an incompatible packaging count. |
LossBasis | select | yes | None, AdditionalInputPercent, IncludedInReferenceInput |
DeclarationSnapshot | longtext | yes | Exact ingredient/specification/allergen and packaging/label constraints; substitutions require independently approved recipe/batch revision, never free-text silent ingredient 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 recipe version. |
Version | number | yes | Immutable technical version. |
Status | select | yes | Draft, Active, Superseded |
Activation | reference | → MasterChanges. Independent Production Manager technical instructions; separate Finance Manager cost-rate approval. |
RoutingOperationsOrdered work instructions and declared labour/overhead bases.line
| Field | Type | Required | Details |
|---|---|---|---|
Routing | reference | yes | → ProductionRoutings. Parent version. |
Sequence | number | yes | Positive unique execution order. |
Name | text | yes | 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 recipe version. |
Routing | reference | yes | → ProductionRoutings. Frozen technical version. |
OutputProduct | reference | yes | → Products. One primary output. |
OutputStandard | reference | yes | → StandardCosts. Frozen entity-functional output standard at release. |
Warehouse | reference | yes | → Warehouses. Actual production site. |
OrderLine | reference | → SalesOrderLines. Optional make-for-order allocation, one demand not a second sales line. | |
PlannedQuantity | decimal | yes | Positive output base quantity. |
Status | select | yes | Draft, PendingApproval, Released, InProgress, PartiallyCompleted, Completed, PendingClose, Closed, Cancelled |
PlannedStart | datetime | yes | Feasible manually planned time. |
PlannedEnd | datetime | yes | Planned end; no optimizer promise. |
Manager | reference | yes | → Users. Production Manager; independent of the relevant request preparer/material editors. |
ReleasedAt | datetime | Actual independent Production Manager release after known material/cost/technical/condition and feasible manual schedule checks; no MRP or APS assumption. | |
ClosedAt | datetime | All input/output/scrap/WIP/cost obligations reconciled and necessary independent finance variance decision. | |
CompletedQuantity | decimal | yes | Net posted 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 Production Manager quantity/obligation close approval, excluding closure preparer/material editors. | |
CloseFinanceDecision | reference | → ApprovalDecisions. Additional independent Finance Manager approval for remaining WIP/variance/financial exception, not substitute for quantity close. | |
BatchNumber | text | yes | Unique actual internal production batch identity, linked to recipe/work order; not a duplicate inventory or cost owner. |
LabelVersion | reference | → LabelVersions. Exact released applicable label/artwork/pack basis and actual source verification; required labeled output. | |
ShelfLifePolicy | reference | yes | → ShelfLifePolicies. Exact output policy version frozen at batch release. |
QualityPlan | reference | yes | → InspectionPlans. Frozen applicable plan plus every additional prerequisite in released snapshot. |
FoodSnapshot | longtext | yes | Recipe/line dimension factors, planned primary output, ingredient/packaging/label/allergen/specification snapshots, actual source constraints, compatible yield basis and quality prerequisites. Unknown prerequisites block release rather than silently pass. |
QualityDecision | reference | → ApprovalDecisions. Independent Quality Manager recipe/specification/label/date prerequisites; no requirement to pretend final product is released before physically accepted held output can be valued. |
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 ingredient/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 Production Operator; Production Manager independently confirms actual throughput/time. |
Status | select | yes | Ready, InProgress, Complete, Exception, Cancelled |
PlannedStart | datetime | yes | Assigned window. |
PlannedEnd | datetime | yes | End. |
ActualStart | datetime | Actual work start. | |
ActualEnd | datetime | Actual work end, positive interval when labour hours charged. |
ProductionEntriesActual operation throughput, scrap and labour evidence; intermediate counts do not sum to output.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
EntryNumber | text | yes | Stable operation/time/output identity. |
Operation | reference | yes | → WorkOrderOperations. Released work operation. |
RecordedBy | reference | yes | → Users. Actual Production Operator recorder; ProducedBy identifies actual producer, which may differ. |
Status | select | yes | Draft, Submitted, Accepted, Rejected, Corrected |
StartedAt | datetime | yes | Actual time. |
EndedAt | datetime | Actual time; no overlap/double use of same person's time interval. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
GoodQuantity | decimal | yes | Physically accepted completed throughput in the declared operation/output unit, including output still quality-held. Quality status is separate; no mixed-ingredient 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 Production Manager excluding producer, recorder and material editors; actual condition evidence required. | |
CorrectionOf | reference | → ProductionEntries. Prior entry and consumed costs/completions reconciled first. | |
ProducedBy | reference | yes | → Users. Actual Production Operator producing the units; recorder can differ and neither may approve the same source. |
ScopeKey | text | yes | Stable batch/unit/operation-pass identity; rework has linked prior pass and exact unit lineage, never a second finished unit. |
MachineHours | decimal | Nonnegative actual accepted occupied machine hours; distinct from elapsed person-hours and setup overlap. Null until actual interval/basis known; finite nonnegative value required before acceptance/cost posting, with explicit known zero allowed. | |
AcceptedAt | datetime | Actual independent technical/time confirmation. | |
InputAllocations | longtext | yes | 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 ingredient units remain on material allocations. |
ProcessEvidence | longtext | yes | Actual recipe/operation, observed processing conditions, changeover/cleaning and measured loss/sampling facts; required QualityInspections 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 Production 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 Manager review. | |
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 | yes | → LotPortions. Exact new output population/lot with source genealogy/date/label evidence; stock and WIP effect creates this once, not quality release. |
OutputEligibility | select | yes | Held, Released |
QualityBasis | longtext | yes | Default Held pending required independent Quality Manager release. Released only if every required test/label/date/lineage/hold condition covers exact output; no header-wide 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 food 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. |
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. Before actual customer handover, cancellation restores existing owned staging/custody without sale/COGS reversal; no delivery-title branch. |
OriginalCommercialValue | decimal | yes | Scoped original net/tax settlement basis kept separate from carrying removal. |
LotNumber | text | Trace original identity; changed identity requires explicit reviewed disposition. | |
PhysicalAt | datetime | Actual return receipt or supplier handover. | |
StockEvent | reference | → StockEvents. Actual custody/owned-stock effect once. | |
ReceiptAcceptance | reference | → ReceiptAcceptances. Required for supplier return of accepted owned goods; binds original posted tranche/descendants, rather than gross arrival. | |
Portion | reference | → LotPortions. Required for lot-controlled food 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. |
ReturnDispositionsIndependent actual goods disposition without automatic credit or refund.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
DispositionNumber | text | yes | Unique return-scope decision. |
ReturnLine | reference | yes | → ReturnLines. Actual received/authorized scope. |
Kind | select | yes | Restock, Scrap, ReturnToCustomer, ReturnToSupplier, Quarantine |
Status | select | yes | Prepared, PendingApproval, Approved, Posted, Reversed |
BaseQuantity | decimal | yes | Positive bounded actual quantity not already disposed. |
CarryingValue | decimal | yes | Original title-issue cost for actual customer restock; current descendant carrying for supplier return. Before actual customer handover, cancellation restores existing owned staging/custody without a COGS reversal; no delivery-title customer path. |
Destination | reference | → Locations. Actual held/restocked destination, same entity/warehouse scope; new assembly/rework requires separately released production scope. | |
PreparedBy | reference | yes | → Users. Warehouse Operator observations. |
DecidedAt | datetime | Independent WM disposition; FM additionally authorizes loss/value exception. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
StockEvent | reference | → StockEvents. No physical/economic effect from status alone. |
InvoicesLocal customer debit/credit documents with mandatory independent Finance Manager approval.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Currency | reference | yes | → Currencies. Document currency; amounts use this currency unless stated otherwise. |
Rate | reference | yes | → ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
InvoiceNumber | text | yes | Unique legal document. |
Account | reference | yes | → Accounts. Same entity. |
DocumentType | select | yes | Invoice, CreditNote |
OriginalInvoice | reference | → Invoices. Required credit/correction original. | |
Status | select | yes | Draft, PendingApproval, Approved, Posted, PartiallySettled, Settled, Disputed, Reversed, Cancelled |
InvoiceDate | date | yes | Original legal/business date. |
PostingDate | date | yes | Eligible date in entity Period; no closed-period rewrite. |
Period | reference | yes | → AccountingPeriods. Same-entity open posting period. |
DueDate | date | yes | Frozen terms. |
NetAmount | decimal | yes | Positive magnitude sum InvoiceLines.NetAmount; credit sign comes only from DocumentType. |
TaxAmount | decimal | yes | Positive applicable tax magnitude, credit reverses original scoped tax. |
TotalAmount | decimal | yes | NetAmount + TaxAmount once. |
Outstanding | decimal | yes | Debit original less posted cash/credit/approved corrections and cutover baseline; credits use CreditRemaining separately. |
CurrentCarrying | decimal | yes | Functional carrying value of current open debit/credit, including delta revaluation. |
UnrealizedFX | decimal | yes | Signed gain-positive prior FX on remaining scope; reclassified once when settled. |
CreditRemaining | decimal | yes | Credit-note value less posted uses/refunds; active reservations reduce allocatable balance further. |
PostedAt | datetime | Local journal posting time; send acknowledgment is separate. | |
Journal | reference | → JournalEntries. Debit: Dr AR / Cr Revenue and tax; CreditNote: Dr reversal revenue/tax / Cr CustomerCredit, then applications/refunds separately. | |
Baseline | longtext | yes | Nonposting original/settled/credit and current carrying/FX amounts at migration; native zero. |
InvoiceLinesExact unbilled title-transferred accepted price allocation or original credit scope.line
| Field | Type | Required | Details |
|---|---|---|---|
Invoice | reference | yes | → Invoices. Parent revision. |
LineNumber | number | yes | Stable line. |
OrderLine | reference | → SalesOrderLines. Required 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. |
BillsLocal supplier debit/credit documents with matching, carrying and separate settlement.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Currency | reference | yes | → Currencies. Document currency; amounts use this currency unless stated otherwise. |
Rate | reference | yes | → ExchangeRates. Frozen positive document-to-entity-functional multiplier and dated purpose; identity rate explicit. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
BillNumber | text | yes | Unique entity/supplier/external invoice identity; duplicate invoice hash review. |
Supplier | reference | yes | → Suppliers. Same entity. |
DocumentType | select | yes | Bill, CreditNote |
OriginalBill | reference | → Bills. Credit original. | |
Status | select | yes | Draft, Matching, PendingApproval, Approved, Posted, PartiallySettled, Settled, Disputed, Reversed, Cancelled |
BillDate | date | yes | Supplier document date. |
PostingDate | date | yes | Open entity period date. |
Period | reference | yes | → AccountingPeriods. Same entity. |
DueDate | date | yes | Frozen terms. |
NetAmount | decimal | yes | Positive net magnitude. |
TaxAmount | decimal | yes | Positive tax magnitude. |
TotalAmount | decimal | yes | Net plus tax once. |
Outstanding | decimal | yes | Debit original less posted settlement/credits/corrections and baseline; not cash-only balance. |
CurrentCarrying | decimal | yes | Functional remaining open amount including delta FX. |
UnrealizedFX | decimal | yes | Signed gain-positive prior FX on remaining scope. |
CreditRemaining | decimal | yes | Supplier-credit magnitude less posted applications/refunds; subtract active reservations too for availability. |
PostedAt | datetime | Local posting. | |
Journal | reference | → JournalEntries. Matched bill clears scoped GRNI plus approved variance/tax to AP; no second full inventory debit. Credit creates SupplierCredit asset with original reversal basis. | |
Baseline | longtext | yes | Nonposting source/open/carrying/settlement/FX balances at migration. |
BillLinesSupplier charges matched to accepted receipts, with explicit nonstock exceptions.line
| Field | Type | Required | Details |
|---|---|---|---|
Bill | reference | yes | → Bills. Parent revision. |
LineNumber | number | yes | Stable key. |
OrderLine | reference | → PurchaseOrderLines. Approved commercial source for stock purchases. | |
OriginalLine | reference | → BillLines. Required credit source. | |
ReturnLine | reference | → ReturnLines. Exact returned source if credit. | |
Product | reference | yes | → Products. Exact SKU/charge. |
BaseQuantity | decimal | yes | Positive stock quantity; zero allowed only approved financial-only correction/charge. |
NetAmount | decimal | yes | Document-currency net price amount; positive credit magnitude. |
TaxCode | reference | → TaxCodes. Frozen treatment. | |
TaxAmount | decimal | yes | Tax once; recovery/nonrecoverable destination explicit. |
ExpenseAccount | reference | → ChartOfAccounts. Required approved nonstock/non-PO expense basis; never invents receipt. |
BankAccountsEntity-owned bank currency balances and restricted destination data.master
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
BankCode | text | yes | Unique bank/currency account. |
Currency | reference | yes | → Currencies. Actual bank currency. |
LedgerAccount | reference | yes | → ChartOfAccounts. Same-entity source-controlled bank/cash-on-hand/cash-in-transit/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. |
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 |
FinanceCorrectionsIndependent reviewed reversals, bank returns, write-offs and charges without editing posted history.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
CorrectionNumber | text | yes | Unique economic correction. |
Kind | select | yes | CashReturn, PaymentReturn, RefundReturn, InvoiceReversal, BillReversal, WriteOff, BankFee, PostingCorrection, OpeningCorrection |
Status | select | yes | Draft, PendingApproval, Approved, Posted, Rejected |
SourceTable | text | yes | Exact existing source type. |
SourceKey | text | yes | Original immutable source/effect identity. |
Scope | longtext | yes | 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. Compensates only traced effects; new fee/rate difference separately identified. |
RevaluationRunsDelta remeasurement of entity monetary balances after reconciliation, not presentation consolidation.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
RunNumber | text | yes | Unique cutoff run. |
Period | reference | yes | → AccountingPeriods. Same entity. |
Status | select | yes | Draft, Calculated, PendingApproval, Approved, Posted, Reversed |
AsOf | datetime | yes | Frozen monetary population/cutoff. |
SourceHash | text | yes | Current reconciled open item/bank/unapplied/credit balances and rates; stale changes require recalculation. |
PostedAt | datetime | Actual delta posting. | |
Journal | reference | → JournalEntries. Balance changes versus unrealized FX, exactly once. |
RevaluationLinesOne remaining monetary source, not both detail and its control total.line
| Field | Type | Required | Details |
|---|---|---|---|
Run | reference | yes | → RevaluationRuns. Reviewed cutoff. |
SourceTable | select | yes | Invoices, Bills, CashReceipts, BankAccounts, Payments |
SourceKey | text | yes | Exact open debit/credit/unapplied/bank source and kind. |
Currency | reference | yes | → Currencies. Source currency. |
OpenAmount | decimal | yes | Remaining signed economic currency balance, positive magnitude plus source debit/liability direction. |
Rate | reference | yes | → ExchangeRates. Reviewed Closing rate to entity functional currency. |
BeforeCarrying | decimal | yes | Current functional carrying before this delta. |
AfterCarrying | decimal | yes | OpenAmount × rate using source normal balance. |
Delta | decimal | yes | After − before; gain sign determined by asset/liability, not an unconditional profit. |
PriorFX | decimal | yes | Retained signed prior unrealized FX. |
Status | select | yes | Calculated, Posted, Reversed |
JournalEntriesBalanced entity-functional journals with source identity and immutable postings.finance
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
JournalNumber | text | yes | Unique entity journal. |
Kind | select | yes | Trade, Stock, WIP, Cash, CashTransfer, Tax, FX, Reclassification, Manual, Opening, Correction |
Status | select | yes | Draft, PendingApproval, Approved, Posted, Reversed |
PostingDate | date | yes | Date in eligible Period. |
Period | reference | yes | → AccountingPeriods. Same entity. |
SourceTable | text | yes | Existing typed source or explicitly authorized Manual/Opening evidence. |
SourceKey | text | yes | Unique economic source/effect; a second transport event cannot repost it. |
PostedAt | datetime | Actual local posting. | |
ReversalOf | reference | → JournalEntries. Exact prior journal/line source; no destructive editing. | |
CashTransferFrom | reference | → BankAccounts. Required for CashTransfer; source Bank/CashOnHand/CashInTransit under actual custody evidence, same entity and different from destination. | |
CashTransferTo | reference | → BankAccounts. 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 stock/receipt/invoice/payment/WIP/FX source allocation and rule version. |
ReceiptAcceptancesIndependent bounded disposition tranches against one immutable actual arrival.transaction
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
AcceptanceNumber | text | yes | Unique arrival/tranche identity; duplicate callbacks reuse it. |
ReceiptLine | reference | yes | → GoodsReceiptLines. One immutable actual arrival line. |
Disposition | select | yes | Accept, Reject |
Status | select | yes | Prepared, PendingReview, Confirmed, Posted, Reversed |
BaseQuantity | decimal | yes | Positive tranche quantity; active confirmed tranches cannot exceed arrived quantity less previous live tranches. |
StandardCost | reference | → StandardCosts. Required for accepted owned-stock effect; frozen version. | |
ReceiptRate | reference | → ExchangeRates. Required dated receipt valuation multiplier. | |
CommercialFunctionalValue | decimal | Accepted scoped PO net/approved capitalizable charges at receipt rate; zero only approved known-zero basis. | |
ConfirmedBy | reference | → Users. Actual independent Warehouse Operator, not PO buyer/commercial approver; null until confirmation and mandatory before Confirmed/Posted with required condition/cost evidence. | |
ConfirmedAt | datetime | Actual physical disposition confirmation. | |
Evidence | longtext | yes | 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 tranche posts quantity/standard value/GRNI/variance once; rejection has no owned posting. | |
ReversalOf | reference | → ReceiptAcceptances. Exact prior tranche only after downstream stock/match/return effects reconcile. | |
Portion | reference | → LotPortions. Required for lot-controlled food 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/label/storage requirements and independent Quality Manager release where complete; default Held for unresolved required tests. Quantity acceptance is not a fitness conclusion. |
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 received ingredient/packaging/specification/allergen source version and conflicts with approved recipe expectations; unknown or conflict holds affected quality review. |
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. |
InspectionPlansVersioned 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. Inspected material or output SKU. |
Kind | select | yes | Incoming, InProcess, Final, Return, Storage, Changeover, LabelCheck |
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 |
SampleSize | number | yes | Positive minimum sample size; cannot exceed available population, and EveryUnit uses full population. |
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 Manager specification/sampling/criteria approval excluding preparers/editors; Production Manager additionally approves technical process implications. |
InspectionCharacteristicsActual measurable or pass/fail criteria with explicit units and known limits.line
| Field | Type | Required | Details |
|---|---|---|---|
Plan | reference | yes | → InspectionPlans. 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. |
QualityInspectionsImmutable 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 | → InspectionPlans. Effective frozen version. |
ReceiptLine | reference | → GoodsReceiptLines. Actual incoming source. Exactly one physical source among receipt, production entry, completion, return or storage observation; changeover/label check may use actual released batch/entry and its population. | |
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 qualified scoped Quality Inspector independent of physical producer/receiver whose work is inspected; records facts, does not release its own observation 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 Manager exact population QualityRelease/QualityDisposition excluding physical producer/receiver, inspector, criteria editors and disposition preparer/material editors. Observation pass alone does not authorize release. | |
CorrectionOf | reference | → QualityInspections. 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. | |
StorageObservation | reference | → StorageObservations. Actual storage source when Kind Storage; instead of fabricated receipt/output. Source selection and compatible population are explicit. | |
LabelVersion | reference | → LabelVersions. Actual tested label/packaging revision when applicable, must match released batch/recipe. | |
WorkOrder | reference | → WorkOrders. Required batch context for nonmaterial changeover/cleaning/process prerequisite checks; no fabricated stock population. Material tests instead bind actual source population. |
InspectionResultsOne observed sample/characteristic result with evidence and explicit unavailable measurements.line
| Field | Type | Required | Details |
|---|---|---|---|
Inspection | reference | yes | → QualityInspections. Parent immutable observed scope. |
Characteristic | reference | yes | → InspectionCharacteristics. Must belong to frozen plan. |
SampleKey | text | yes | Exact sampled unit/serial/point; unique characteristic/sample observation per pass. |
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 Quality Inspector observer; null until observed, required for a completed result. | |
Evidence | longtext | yes | Measurement unit/method, instrument fitness evidence where required, source/photo/document hash; no calibration system implied. |
NonConformanceReportsBasic nonconformance containment, cause and scoped disposition; not a complete corrective-action management suite.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. |
NCRNumber | text | yes | Unique finding/case identity. |
Product | reference | yes | → Products. Affected SKU. |
Inspection | reference | → QualityInspections. Source failure or observation. | |
WorkOrder | reference | → WorkOrders. Affected production owner. | |
ReceiptLine | reference | → GoodsReceiptLines. Affected incoming source. | |
ReturnLine | reference | → ReturnLines. Customer/return source. | |
Lot | reference | → Lots. Exact affected lot. | |
Serial | reference | → Serials. Exact individual where applicable. | |
AffectedQuantity | decimal | Positive affected goods quantity for material findings, bounded to identified product/portion scope. Null for actual nonmaterial work-order/operation cleaning/changeover findings with exact context; no invented goods quantity. | |
Description | longtext | yes | Actual nonconformance and immediate containment. |
Cause | longtext | yes | Reviewed explanation or explicit unresolved investigation, not fabricated root cause. |
Status | select | yes | Open, Contained, Investigating, PendingDisposition, Dispositioned, Closed |
RaisedBy | reference | yes | → Users. Actual authorized Production Operator, Warehouse Operator, Production Manager, Quality Inspector or Quality Manager. |
RaisedAt | datetime | yes | Actual finding time. |
ClosedAt | datetime | All held/rework/scrap/return/customer and value obligations reconciled. | |
Portion | reference | → LotPortions. Actual bounded affected population, matching source lot/product; exact portions avoid duplicate disposition. |
QualityHoldsRestrictive 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 | → QualityInspections. Triggering inspection. | |
NCR | reference | → NonConformanceReports. Triggering case. | |
Scope | longtext | yes | Exact product/lot/portion/ancestor/batch quantities, occurrence, descendant exposure and reason. Multiple holds are independent conjunctive restrictions; releasing one cannot clear another. Existing reserved or moved stock remains blocked; performed deliveries remain historical and trigger trace response, not fictitious stock rollback. |
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 Manager decision can release its exact hold; no Admin override. |
PlacedAt | datetime | yes | Actual restriction time. |
ReleasedBy | reference | → Users. Independent Quality Manager 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. | |
StorageObservation | reference | → StorageObservations. Actual excursion or missing condition evidence trigger. | |
TraceCase | reference | → TraceCases. Affected exposure case, not a second stock quantity owner. |
QualityDispositionsBounded 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 | → QualityInspections. Observed actual scope. | |
NCR | reference | → NonConformanceReports. Nonconformance case; at least inspection or NCR required. | |
Hold | reference | → QualityHolds. 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 unit/serial population and criteria, deviation acceptance/engineering/customer authority where needed; sampling result cannot silently release unrelated scope. |
TechnicalDecision | reference | → ApprovalDecisions. Independent Production Manager for rework/routing/deviation impact. | |
CommercialDecision | reference | → ApprovalDecisions. Independent Sales 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 Manager 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 Manager 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 | yes | → LotPortions. Exact source identified population; must agree with inspection/hold and all other applicable restrictions. |
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. |
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 original source manufacture/open-life/expiry and apply any newly justified tighter output constraints. Repack never extends life by default; transformed output needs approved actual process evidence and source constraints. |
EvidenceRule | longtext | yes | Supplier/manufacturing date evidence, unknown handling, storage conditions and permitted correction/extension review; no universal food-safety threshold or legal date claim. |
Activation | reference | → MasterChanges. Independent Quality Manager, excluding preparer/material criteria editors; Production Manager technical implications separately reviewed. | |
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, Production Operator, Quality Inspector 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 Manager 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. |
StorageObservationsActual manual or imported condition observations with bounded place/time/population coverage.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. | |
ObservationNumber | text | yes | Unique actual measurement/source identity. |
Kind | select | yes | Point, Interval, Excursion |
Portion | reference | → LotPortions. Specific population, or location interval with exact population evidence; no unrestricted whole-lot assumption. | |
Location | reference | → Locations. Actual storage/handling location; at least portion or location required. | |
ObservedFrom | datetime | yes | Actual point/interval start. |
ObservedTo | datetime | Actual end for completed interval; point uses no invented interval coverage. | |
Characteristic | reference | yes | → InspectionCharacteristics. Approved numeric/pass-fail storage requirement with unit/method; plan version must match affected product/context. |
NumericValue | decimal | Actual known value in declared unit; zero is valid, unknown remains null. | |
PassValue | boolean | Actual pass/fail observation where applicable; missing is not pass. | |
Unit | text | yes | Observed unit, must be compatible with criterion; no silent conversion. |
ObservedBy | reference | yes | → Users. Actual scoped Quality Inspector or Warehouse Operator observer; importer preserves original observer/source. |
PopulationEvidence | longtext | yes | Exact present lot portions and movement/time lineage exposed to this interval; missing lineage conservatively held for review, not assumed clear. Point measurements do not prove continuous conditions. |
Evidence | longtext | yes | Source instrument/method/record hash and data completeness; no installed sensor or automatic control claim. |
Status | select | yes | Recorded, PendingReview, Accepted, Excursion, Invalid, Corrected |
Hold | reference | → QualityHolds. Restrictive affected scope from excursion/missing required evidence; no automatic release from a later normal reading. | |
CorrectionOf | reference | → StorageObservations. Exact prior observation; released/used descendants retained and reconciled. |
LabelVersionsIndependently approved product label and packaging evidence frozen into actual recipes and batches.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. |
LabelNumber | text | yes | Unique covered product/market/customer/version identity, not a certification mark. |
Product | reference | yes | → Products. Actual finished/intermediate product covered. |
PackagingProduct | reference | → Products. Exact packaging/label stock SKU when consumed. | |
Status | select | yes | Draft, PendingApproval, Active, Superseded, Withdrawn |
EffectiveFrom | datetime | yes | Inclusive actual approval effectiveness; no retroactive silent artwork switch. |
EffectiveTo | datetime | Exclusive. | |
ArtworkEvidence | longtext | yes | Immutable reviewed artwork/file/hash and text, language/customer/pack basis; no generated universal legal label. |
DeclaredAllergens | longtext | yes | Applicable reviewed declarations and source ingredient/formula versions, explicit unresolved information. No universal legal allergen list or automatic absence claim. |
PackBasis | longtext | yes | Declared product quantity/unit and fixed packaging mapping, lot/date coding instructions, approved printing/relabeling controls and actual version verification. |
Activation | reference | → MasterChanges. Independent Quality Manager exact declaration/artwork review, with Production Manager technical packing basis and Sales Manager actual customer-change authority when affected. |
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 recipe batch. |
Material | reference | yes | → WorkOrderMaterials. Exact frozen ingredient/packaging requirement. |
SourceCost | reference | yes | → WorkOrderCostEntries. Original posted MaterialIssue, retaining source layer/lot/portion and original base-unit carrying. |
InputPortion | reference | yes | → LotPortions. Actual input population at the action: same original issue lot/product/entity and original portion or evidenced current descendant in its immutable split map. Past allocations retain original identity; new use/return must select a current leaf mapping to that issue source and cannot invent additional issued availability. |
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. | |
LabelVersion | reference | → LabelVersions. Actual consumed label/packaging version where applicable; frozen batch version must agree or hold/review. | |
ExposureBasis | select | yes | CommingledBatch, PhysicallySegregatedScope, PackagingScope, Unknown |
ExposureEvidence | longtext | yes | Commingled ingredient 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 recipe 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 ingredient mass. |
ExpectedOutput | decimal | yes | Positive approved reference/target primary output in this unit; recipe 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 ingredient 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 Manager required condition/label/genealogy exceptions; not substitute for technical quantities or finance value. | |
FinanceDecision | reference | → ApprovalDecisions. Independent Finance Manager nonzero variance/scrap/residual cost authority. | |
ReviewedBy | reference | → Users. Independent Production Manager excluding producer/recorder/reconciliation preparer/editors; null until actual review. | |
ReviewedAt | datetime | Actual independent approval; null while draft/pending. |
TraceCasesBounded lot/batch withdrawal response with reviewed exposure, controlled contact and reconciled closure; not a legal recall determination.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. | |
CaseNumber | text | yes | Unique internal investigation/withdrawal identity. |
Kind | select | yes | TraceInvestigation, Withdrawal, RecallResponse |
Status | select | yes | Draft, Containing, PendingReview, Active, Reconciling, PendingClose, Closed |
Reason | longtext | yes | Actual trigger, evidence and selected response; terminology does not establish legal applicability or regulator notification. |
SourceLot | reference | → Lots. Actual original source identity when known. | |
SourcePortion | reference | → LotPortions. Known narrowed population; unknown scope requires conservative case evidence, not fabricated precision. | |
SourceBatch | reference | → WorkOrders. Actual batch trigger where applicable. | |
OpenedAt | datetime | yes | Actual response start. |
OpenedBy | reference | yes | → Users. Quality Inspector, Quality Manager or authorized operational person raises evidence/restrictive hold. |
CutoffAt | datetime | yes | Exposure snapshot cutoff; refresh for new descendants/events without deleting prior versions. |
ExposureEvidence | longtext | yes | Backward input and forward batch/portion/transfer/shipment graph with complete/unknown links; conservative commingled inclusion distinct from summable stock quantities/cost. |
ReviewDecision | reference | → ApprovalDecisions. Independent Quality Manager affected-scope/response review excluding preparers/material editors. | |
ContactDecision | reference | → ApprovalDecisions. Independent Sales Manager exact recipient/message scope after Quality Manager-approved affected facts; does not authorize unrelated communications. | |
CloseDecision | reference | → ApprovalDecisions. Independent Quality Manager closure only after every unique target is reconciled or independently ruled out with evidence, all holds/dispositions and response gaps resolved or factually documented as unrecoverable with explicit retained obligations. Unknown lineage/quantity/unanswered required response cannot be marked complete by status; no fabricated recovery. | |
ClosedAt | datetime | Actual closure, never merely notification sent or date elapsed. |
TraceLinesOne disjoint current population or historical delivery target in a versioned trace case, with exact response evidence.line
| Field | Type | Required | Details |
|---|---|---|---|
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. | |
Case | reference | yes | → TraceCases. Parent reviewed response snapshot. |
LineNumber | number | yes | Unique case target/source key. |
Kind | select | yes | InputSource, InProcess, OwnedStock, ThirdPartyCustody, Transfer, CustomerDelivery, Unresolved |
Portion | reference | → LotPortions. Exact affected leaf/ancestor exposure source; summable stock is leaf scope only. | |
Batch | reference | → WorkOrders. Actual in-process or descendant batch. | |
ShipmentLine | reference | → ShipmentLines. Exact historical actual customer handover; immutable performed scope cannot be erased. | |
TransferLine | reference | → StockTransferLines. Actual transfer/custody target where in transit or at another facility. | |
Customer | reference | → Accounts. Actual entitled recipient for customer delivery target. | |
Contact | reference | → ContactPersons. Actual purpose-appropriate customer contact; no invented recipient. | |
Exposure | select | yes | Potential, Confirmed, RuledOut, Unknown |
ExposedQuantity | decimal | Known target base quantity in its own product unit, not ingredient percentage; null when QuantityKnown false. Never report unresolved scope as a complete zero. | |
QuantityKnown | boolean | yes | True only when actual exposed quantity is established; false requires null ExposedQuantity and visible unresolved scope, excluded from claims of complete quantity reconciliation. |
PopulationKey | text | yes | Exact case source family/leaf or historical delivery identity; avoid duplicate ancestor+child/onhand+shipment totals. |
Hold | reference | → QualityHolds. Actual current restrictive scope; historical delivery evidence needs response, not fabricated on-hand stock. | |
Disposition | reference | → QualityDispositions. Exact independently approved material decision with separate stock/value effects. | |
ReturnLine | reference | → ReturnLines. Actual authorized recovery, never assumed from a contacted customer. | |
Status | select | yes | Identified, Held, ContactPrepared, ContactAuthorized, Contacted, Responded, DispositionPending, Reconciled, Unresolved |
ResponseEvidence | longtext | yes | Actual source/recipient/time, quantity/accounting unit, response, confirmed recovery/disposal or unresolved facts. A response is not automatic stock return, invoice credit or financial close. |
Delivery | reference | → IntegrationDeliveries. Exact independently authorized contact intent/attempt/acknowledgment; acknowledgment is not recovery or customer response. Repeated attempts share one approved message identity. | |
RespondedAt | datetime | Actual evidenced response time; no fabricated completion. |