Explore the records connecting customer commitments with production, stock and finance.
124 tables · 732 relationships
The current Manufacturing ERP & CRM design connects customer relationships, accepted orders, manufacturing work and local finance through 124 tables. Each record has a defined place in that flow. Application configuration and supported actions must be verified during implementation.
Accounts, ContactPersons, Leads, LeadConversions, Opportunities, OpportunityHistory, Activities, CommunicationPreferences, SalesForecasts, SalesForecastLines. Customer relationships, lead conversion, opportunities, activity history and distinct sales forecasts.
Quotes, QuoteLines, SalesOrders, SalesOrderLines, SalesAllocations, CreditReviews, PriceLists, PriceListEntries, PaymentTerms. Offered and accepted products, quantities, net prices, order allocations and the required commercial or credit decisions.
Products, UnitsOfMeasure, ProductUnits, BOMs, BOMComponents, Routings, RoutingOperations, EngineeringChangeOrders, Calendars, CalendarIntervals, WorkCenters, WorkCenterRates, CostRollups, CostRollupLines, ProductionForecasts, ForecastConsumptions, MRPRuns, DemandRequirements, PlannedOrders, PlannedOrderAllocations, MRPPeggings, MRPExceptions, WorkCenterLoads. Product units, technical revisions, operating calendars, costs, physical demand forecasts, material requirements and capacity.
WorkOrders, WorkOrderMaterials, WorkOrderOperations, ProductionEntries, ProductionFlows, ProductionCompletions, WorkOrderCostEntries, InspectionPlans, InspectionCharacteristics, QualityInspections, InspectionResults, NonConformanceReports, QualityHolds, QualityDispositions. Released production work, actual material and operation results, accepted terminal output and the relevant inspection or hold decisions.
Suppliers, SupplierBankAccounts, Requisitions, RequisitionLines, PurchaseOrders, PurchaseOrderLines, GoodsReceipts, GoodsReceiptLines, ReceiptAcceptances, BillMatches. Supplier identities, approved commitments, immutable arrivals, separately accepted quantities and supplier-bill matching.
Warehouses, Locations, Lots, Serials, InventoryPositions, StockLayers, StockEvents, StockMovements, InventoryReservations, StockTransfers, StockTransferLines, CountLocks, InventoryCounts, CountLines, PickTasks, Shipments, ShipmentLines, DeliveryConfirmations, Returns, ReturnLines, ReturnDispositions. Owned stock, traceable lots and serials, locations, claims, movements, counts, shipments and controlled returns.
Entities, Currencies, ExchangeRates, AccountingPeriods, ChartOfAccounts, TaxCodes, StandardCosts, PostingProfiles, Invoices, InvoiceLines, Bills, BillLines, BankAccounts, BankStatementLines, CashReceipts, CashApplications, PaymentRuns, Payments, PaymentAllocations, CreditApplications, Refunds, FinanceCorrections, RevaluationRuns, RevaluationLines, JournalEntries, JournalLines, CloseTasks. Entity ledgers, reviewed cost and posting bases, invoices, bills, cash, settlement, corrections and period reconciliation.
Users, ManufacturingPolicies, MasterChanges, DocumentRevisions, ApprovalDecisions, AuthorityDelegations, IntegrationEvents, IntegrationDeliveries, MigrationBatches, MigrationItems. Current user scope, policy and revision controls, independent decisions, integration outcomes and migration identity.
Customer and contact identities remain distinct from the people authorized to operate the system. Entity, product, unit, warehouse, location and applicable lot or serial identity follow the relevant transactions. Shared records do not merge ownership, company ledgers or permission scopes.
Commercial estimates, accepted quote allocations and firm order demand are different populations. Planning forecasts use product quantities and explicit consumption; a weighted opportunity amount is not a production requirement. Repeated conversions or planning runs cannot generate another copy of the same accepted demand or firmed supply.
Released work retains the applicable technical, inspection and cost versions. Operation progress, terminal output, quality acceptance, shipment and invoice posting have distinct records and effects. Cost allocations and corrections retain their original sources, remaining quantities and financial basis, rather than rewriting completed history.
Ends with: Map users, entities, customers, contacts, suppliers, products and units. Load the reviewed technical, quality, calendar, currency, account and cost definitions before linking operating transactions.
Ends with: Import pipeline history, accepted commitments, forecast consumption, released jobs and the quantities already issued, completed, returned or shipped. Keep source identities and unresolved work; historical stages must not generate new orders or production effects.
Ends with: Reconcile a full opening ledger with nonposting detailed balances, stock layers, work in progress and open items. Imported receipts, finished output, invoices or cash do not create another copy of their earlier posting.
Ends with: Resolve linked records and exceptions, reconcile the remaining work and obtain the required operational and financial review. Only eligible new work after the agreed cutoff creates new operating effects.
| Field | Type | Required | Details |
|---|---|---|---|
UserKey | text | yes | Stable provider/subject and actual-person identity; two accounts of one person are not independent. |
DisplayName | text | yes | Internal display name. |
ActorType | select | yes | Human, Service |
Status | select | yes | Active, Suspended, Disabled |
Roles | longtext | yes | Subset of the thirteen declared roles; services prepare or execute guarded approved work, never decide. |
EntityScope | longtext | yes | Explicit Entities keys; current scope checked on every read/action/export. |
WarehouseScope | longtext | Explicit permitted Warehouses; absent does not mean global access. | |
ExpiresAt | datetime | Scope expiry. | |
ScopeChange | reference | → MasterChanges. Independent domain-reviewed grant of roles/entities/warehouse scope; Admin cannot self-grant business authority. Revocation may restrict immediately. |
| 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 | → ManufacturingPolicies. Approved active entity policy. |
| Field | Type | Required | Details |
|---|---|---|---|
Code | text | yes | Unique currency code. |
DecimalPlaces | number | yes | Nonnegative permitted precision. |
Status | select | yes | Active, Inactive |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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 rules naming exact action, eligible role/Users, entity/site/product scope, finite amount/quantity limits, currency, dates and escalation; includes price precedence, firm planning fences, lot/serial, quality, counts, cost and title policies. No implicit auto approval. |
CountQuantityTolerance | decimal | yes | Nonnegative base-quantity absolute threshold by configured unit/product class; dimensionally incompatible quantities are never summed. |
CountPercentTolerance | decimal | yes | Nonnegative percentage; expected zero gives unavailable percentage and review. |
CountValueThreshold | decimal | yes | Nonnegative functional-value escalation threshold; unknown value is not zero. |
ShipmentTitleRule | select | yes | Dispatch. Actual verified handover is the single baseline title/COGS event. |
PreparedBy | reference | yes | → Users. Admin prepares configuration; independent Warehouse Manager stock, Production Manager production, Quality Inspector quality, Sales Manager commercial and Finance Manager financial owners approve affected domains. |
OperationalDecision | reference | → ApprovalDecisions. Independent Warehouse Manager for stock/warehouse operational policy; other affected domain decisions are also required through scoped policy activation. | |
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 planning/engineering/execution rules. | |
QualityDecision | reference | → ApprovalDecisions. Independent Quality Inspector for inspection/release rules; not their own prepared content. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
ChangeNumber | text | yes | Unique change request. |
TargetTable | text | yes | Existing allowed master table. |
TargetKey | text | yes | Exact immutable record/version key. |
Status | select | yes | Draft, Submitted, Approved, Applied, Rejected, Cancelled |
BeforeHash | text | yes | Expected prior content or explicit create marker. |
ProposedContent | longtext | yes | Exact after-content and affected transactions. |
ProposedHash | text | yes | Frozen proposed content. |
PreparedBy | reference | yes | → Users. Actual person. |
SubmittedAt | datetime | Actual submission time. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
Decision | reference | → ApprovalDecisions. Independent affected domain owner: Finance Manager bank/cost/rate/tax/accounts; Purchasing Manager supplier commercial activation; Warehouse Manager location/stock; Production Manager technical BOM/routing/planning; Quality Inspector inspection criteria; Sales Manager customer/commercial. Multiple affected-domain decisions reference the same frozen change; supplier bank/financial fields remain independently Finance Manager controlled. | |
AppliedAt | datetime | Guarded application; changes do not rewrite accepted or posted source snapshots. | |
OperationalDecision | reference | → ApprovalDecisions. Required independent Warehouse Manager review for stock/location/warehouse rules, not engineering or quality activation. | |
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. Required independent Production Manager for BOM/routing/calendar/capability/planning changes. | |
QualityDecision | reference | → ApprovalDecisions. Required independent Quality Inspector for inspection criteria/hold-release policy changes. |
| 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. |
| 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, LeadConversion, ForecastLock, QuoteException, OrderAcceptance, CreditException, PurchaseApproval, InvoiceApproval, BillException, PaymentRelease, Refund, FinanceCorrection, StockRelease, TransferApproval, CountAdjustment, ReturnAuthorization, ReturnDisposition, ShipmentRelease, EngineeringRelease, PlanningApproval, ProductionRelease, OperationAcceptance, QualityRelease, ProductionClose, JournalApproval, RevaluationApproval, PeriodClose, PeriodReopen, MigrationActivation |
Status | select | yes | Pending, Approved, Rejected, Expired, Superseded |
Snapshot | reference | → DocumentRevisions. Required for revisioned transaction actions; master/policy request content hash otherwise retained in Scope. | |
Scope | longtext | yes | Exact target/source revision, entity, quantity/value, currency, expiry, action and excluded preparer/editor/subject identities. |
RequestedBy | reference | yes | → Users. Actual preparer/requester. |
RequestedAt | datetime | yes | Actual time. |
DecidedBy | reference | → Users. Actual independent human with declared required role, current scope and limit. Service/Admin privilege is not domain approval. | |
DecidedAt | datetime | Actual decision time. | |
Delegation | reference | → AuthorityDelegations. Valid named delegate, preserving required role and actual-person independence. | |
AuthorityRate | reference | → ExchangeRates. Exact currency conversion for limit test; no missing-rate fallback. | |
AuthorityAmount | decimal | Amount in delegated/role authority currency; cumulative relevant commitment and gross increases included. | |
Reason | longtext | yes | Decision rationale, rejected conditions and reviewed evidence. |
AssignedTo | reference | yes | → Users. Named eligible human reviewer when Pending; independence and current role/limit rechecked at decision. |
| 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. |
| 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. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
BatchNumber | text | yes | Stable import identity. |
Status | select | yes | Draft, Validating, PendingApproval, Approved, Applied, Rejected |
CutoffAt | datetime | yes | Frozen source/system watermark. |
SourceHash | text | yes | Immutable extraction digest. |
OpeningJournal | reference | yes | → JournalEntries. Single full opening journal including subledger controls; detail never reposts it. |
Reconciliation | longtext | yes | AR/AP, credit/unapplied cash, bank, stock/transit/WIP, commitments and all nonposting opening detail totals. |
PreparedBy | reference | yes | → Users. Actual preparer. |
Decision | reference | → ApprovalDecisions. Independent Finance Manager activation plus Warehouse Manager evidence for stock/WIP. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
AppliedAt | datetime | One successful baseline activation. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
TaskNumber | text | yes | Unique period/check/cutoff scope. |
Period | reference | yes | → AccountingPeriods. Same entity. |
Kind | select | yes | Bank, AR, AP, Inventory, Transit, WIP, GRNI, Tax, Credits, UnappliedCash, Revaluation, Interfaces |
Status | select | yes | Open, InProgress, Complete, ReviewRequired, Waived |
Owner | reference | yes | → Users. Assigned Accountant or relevant operational evidence owner. |
CutoffAt | datetime | yes | Precise evidence cutoff. |
SourceHash | text | yes | Population/version hash; changed source invalidates completion. |
Evidence | longtext | yes | Reconciliation totals, exceptions and prerequisites; required missing balances cannot be hidden by Complete. |
ReviewedBy | reference | → Users. Independent Finance Manager for unresolved exceptions/allowed waiver. | |
CompletedAt | datetime | Actual evidence completion. |
| 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; normalized duplicate candidates are reviewed before creation, not automatically merged. |
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 amount in CreditCurrency; required before credit trading. Missing is unknown, never unlimited; zero permits no credit exposure without a separate exception. | |
TaxEvidence | longtext | Exemption/resale documentation and review scope; not automatic compliance proof. | |
Activation | reference | → MasterChanges. Independent Sales Manager commercial and Finance Manager credit/tax approval as applicable. | |
RelatedEntity | reference | → Entities. Explicit intercompany trading counterparty; still separate legal documents, no automatic elimination. | |
Owner | reference | yes | → Users. Sales Representative responsible for relationship within entity scope. |
Industry | text | Customer industry supplied by the business, not inferred sensitive traits. | |
Website | text | Reviewed business URL. | |
CreatedAt | datetime | yes | Actual first recorded time. |
SourceLead | reference | → Leads. Original source when converted; conversion mapping remains authoritative. |
| 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 |
Title | text | Business role supplied by the person or customer. | |
CanAcceptOffers | boolean | Reviewed named acceptance authority with evidence; a job title alone is insufficient. | |
AuthorityEvidence | longtext | Customer authorization, scope, expiry and source evidence. | |
LastVerifiedAt | datetime | Actual identity/contact verification. |
| 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. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Code | text | yes | Unique unit code. |
Dimension | text | yes | Count, mass, volume or other explicit compatible dimension. |
DecimalPlaces | number | yes | Permitted nonnegative precision; indivisible unit has zero. |
Status | select | yes | Active, Inactive |
| Field | Type | Required | Details |
|---|---|---|---|
ProductCode | text | yes | Unique SKU. |
Name | text | yes | Product description. |
BaseUnit | reference | yes | → UnitsOfMeasure. Stock and production base quantity unit. |
LotControlled | boolean | yes | Lot required on every custody and production allocation when true. |
Status | select | yes | Draft, Active, OnHold, Inactive |
ProductKind | select | yes | RawMaterial, Subassembly, FinishedGood, PurchasedPart |
Activation | reference | → MasterChanges. Independent Production Manager technical and Finance Manager financial setup review; warehouse identity rules require Warehouse Manager evidence. | |
SerialControlled | boolean | yes | Serial required on every owned quantity/effect when true; each position/layer identity has quantity zero or one. |
SupplyMethod | select | yes | Buy, Make, Either |
LeadTimeDays | number | yes | Reviewed nonnegative working-day lead time using the site calendar; a planning input, not guaranteed supplier performance. |
MinimumOrderQuantity | decimal | yes | Nonnegative base quantity; dimensionally consistent. |
OrderMultiple | decimal | yes | Positive base quantity increment; proposals round up once after netting. |
SafetyStock | decimal | yes | Nonnegative eligible base-quantity target; held/reserved/in-transit stock is not free available supply. |
DefaultBOM | reference | → BOMs. Approved effective version selected explicitly for Make; transaction freezes actual version. | |
DefaultRouting | reference | → Routings. Approved compatible version for Make. | |
Specification | attachment | Controlled product drawing/specification attachment; released snapshot retains immutable identity/hash and access scope. |
| 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. |
| 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. |
| 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. |
| 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 technical/cost-rollup evidence; no retroactive rewrite of released WIP or completed output. | |
Rollup | reference | → CostRollups. Approved manufacturing calculation, required for manufactured outputs; purchased items retain reviewed commercial/landed basis. |
| 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. |
| 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. |
| 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 |
| 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 Representative. |
PriceList | reference | → PriceLists. Selected list version or reviewed manual-price reason in snapshot. | |
NetTotal | decimal | yes | Sum frozen QuoteLines.NetAmount; no second subtraction of disclosed discounts. |
TaxTotal | decimal | yes | Sum exact tax allocations. |
SentAt | datetime | Actual successful send evidence, not intent. | |
AcceptanceEvidence | longtext | Immutable actual customer evidence with accepted content hash, terms, quantity/net/tax/address, ContactPerson identity/authority and accepted time; all required accepting parties confirmed. Internal manager approval or send acknowledgment is not customer acceptance. | |
Decision | reference | → ApprovalDecisions. Required commercial price/margin exception decision by independent Sales Manager; routine within-policy quote sending is Sales Representative preparation, not the mandatory order gate. | |
Opportunity | reference | → Opportunities. Same customer/entity source; accepted scope drives won evidence, never direct MRP demand. | |
ContactPerson | reference | → ContactPersons. Exact reviewed recipient/customer acceptance person. | |
CustomerRequirement | attachment | Immutable specification/drawing/requirements hash included in commercial and manufacturing review. |
| 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. |
| 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 Representative preparing order. |
Terms | reference | yes | → PaymentTerms. Frozen accepted terms. |
ShipTo | longtext | yes | Frozen delivery address/contact; change is material. |
TitleRule | select | yes | Dispatch. Baseline actual verified handover transfers title/stock and recognizes COGS once; accepted terms and exceptions must agree before order approval. |
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. | |
Opportunity | reference | → Opportunities. Same customer source; no second deal is created when converting accepted quote scope. |
| 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 |
| 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. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
RequisitionNumber | text | yes | Unique request. |
Status | select | yes | Draft, Submitted, Approved, Rejected, Converted, Cancelled |
RequestedAt | datetime | yes | Actual request. |
NeededBy | date | yes | Required supply date. |
RequestedBy | reference | yes | → Users. Warehouse Manager, Operator or other authorized operational requester. |
Decision | reference | → ApprovalDecisions. Independent Purchasing Manager within configured authority, Finance Manager above limit; conversion consumes only approved remaining scope. |
| 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. |
| 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. |
| 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 |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
StockEventNumber | text | yes | Unique physical/economic action. |
Kind | select | yes | ReceiptAcceptance, PutAway, Pick, Unpick, TitleIssue, TransferDispatch, TransferReceipt, MaterialIssue, MaterialReturn, ProductionOutput, Scrap, CustomerReturn, SupplierReturn, StatusChange, CountAdjustment, CostRevaluation, MigrationOpening, Correction |
Status | select | yes | Prepared, PendingApproval, Posted, Reversed, Rejected |
OccurredAt | datetime | yes | Actual evidenced event time. |
PostedAt | datetime | Atomic committed effect time. | |
SourceTable | text | yes | Existing exact typed source table. |
SourceKey | text | yes | Exact immutable source scope/revision. |
SourceHash | text | yes | Frozen content including quantity/cost/current versions. |
ConfirmedBy | reference | yes | → Users. Actor authorized for physical confirmation; financial authorization separate. |
Journal | reference | → JournalEntries. Balanced associated finance effect; same-control physical movement has none. | |
ReversalOf | reference | → StockEvents. Traced compensating event; no blind reversal after consumption/title transfer. |
| Field | Type | Required | Details |
|---|---|---|---|
StockEvent | reference | yes | → StockEvents. Parent atomic event. |
Position | reference | yes | → InventoryPositions. Exact identity. |
Layer | reference | yes | → StockLayers. Exact remaining layer. |
QuantityDelta | decimal | yes | Signed base quantity; zero only value-only standard revaluation. Status change uses equal out/in identity legs. |
ValueDelta | decimal | yes | Signed functional carrying value; no invented stock value. |
Reservation | reference | → InventoryReservations. Demand claim being transferred/consumed. | |
ShipmentLine | reference | → ShipmentLines. Exact dispatch/title portion if applicable. | |
ReturnLine | reference | → ReturnLines. Exact return source if applicable. | |
VersionBefore | number | yes | Expected position version; new identity checked in locked scope. |
Lot | reference | → Lots. Exact same entity/product lot, required when lot-controlled; display values derive from this identity. | |
Serial | reference | → Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
ReservationNumber | text | yes | Stable demand/stock claim. |
Position | reference | yes | → InventoryPositions. Exact source/current position. |
Layer | reference | yes | → StockLayers. Exact source/current remaining layer. |
OrderLine | reference | → SalesOrderLines. Exactly one demand: order line or work-order material or transfer line. | |
WorkOrderMaterial | reference | → WorkOrderMaterials. Production component demand. | |
TransferLine | reference | → StockTransferLines. Internal transfer demand. | |
BaseQuantity | decimal | yes | Positive claimed quantity; active claims cannot exceed eligible stock or demand remainder. |
Status | select | yes | Soft, Hard, Picked, InTransit, Consumed, Released, Cancelled |
CreatedAt | datetime | yes | Atomic claim time. |
ExpiresAt | datetime | Soft claim expiry only; physical picked/transit never auto-released by timer. | |
Replaces | reference | → InventoryReservations. Soft→Hard conversion replaces rather than adds a second claim. |
| 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. |
| 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. |
| 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 |
| 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 | → ManufacturingPolicies. 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. |
| 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; the final independent approver cannot approve their own observation. | |
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. |
| 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. | |
QualitySnapshot | longtext | yes | Current required release/hold eligibility for all exact lot/serial descendants; rechecked at physical pick and dispatch, not only planning. |
| 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 accepted customer order; no combined record loses order ownership. |
Warehouse | reference | yes | → Warehouses. Actual dispatch site. |
Mode | select | yes | OwnDelivery, ExternalCarrier |
Status | select | yes | Planned, Picking, Ready, Dispatched, PartiallyDelivered, Delivered, Exception, Closed, Cancelled |
TitleRule | select | yes | Dispatch. Baseline transfers inventory/title and COGS at verified actual handover; alternate legal/title models require a separately reviewed extension. |
CarrierReference | text | Configured external handoff reference; no carrier booking claim. | |
DispatchedAt | datetime | Actual physical handover/vehicle departure. | |
DispatchEvidence | longtext | Actual operator/handoff/source evidence; uncertain provider response alone is insufficient. | |
ClosedAt | datetime | All line quantities delivered/returned/lost/resolved with remaining ownership reconciled. | |
Decision | reference | → ApprovalDecisions. Current valid independent action/scope/revision decision, required before corresponding action. | |
ReleasedBy | reference | → Users. Independent Warehouse Manager verifies current approved order, picking, lot/serial and required quality releases. | |
ReleasedAt | datetime | Actual authorization before dispatch; material changes invalidate unexecuted release. |
| Field | Type | Required | Details |
|---|---|---|---|
Shipment | reference | yes | → Shipments. One order. |
OrderLine | reference | yes | → SalesOrderLines. Same order only. |
Reservation | reference | yes | → InventoryReservations. Exact picked claim and layer identity. |
BaseQuantity | decimal | yes | Actual assigned/shipped quantity, bounded by claim and accepted unfulfilled source. |
DispatchedQuantity | decimal | yes | Actual dispatched quantity; history retained through returns. |
TitleTransferredQuantity | decimal | yes | Posted TitleIssue quantity once at verified actual dispatch, bounded by exact hard claim and accepted unfulfilled order scope. |
DeliveredQuantity | decimal | yes | Cumulative actual accepted customer delivery history, net only of approved factual delivery-evidence corrections; physical customer returns do not reduce this history or reopen original shipment 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 for actual handover; later POD never issues stock again. |
| Field | Type | Required | Details |
|---|---|---|---|
ShipmentLine | reference | yes | → ShipmentLines. Exact dispatched customer/order scope; no unshipped quantity. |
AcceptedQuantity | decimal | yes | Nonnegative actual accepted quantity. |
RefusedQuantity | decimal | yes | Nonnegative physically refused quantity. |
FailedQuantity | decimal | yes | Nonnegative undelivered quantity; not lost or returned automatically. |
DamagedQuantity | decimal | yes | Disjoint damaged scope retained pending disposition; not also included accepted/refused/failed. |
ScopeQuantity | decimal | yes | Sum disjoint actual accepted/refused/failed/damaged outcomes for this attempt; eligible remaining original dispatch excludes prior accepted-delivery history and separately physically returned, approved lost or otherwise finally resolved units, with overlap removed. Failed attempts may retry only still-outstanding goods; return/restock never reopens original POD eligibility without new authorized dispatch. |
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; 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. | |
ConfirmationNumber | text | yes | Stable customer receipt/attempt source identity. |
Status | select | yes | Prepared, Confirmed, Disputed, Corrected |
OccurredAt | datetime | yes | Actual customer outcome instant. |
ConfirmedBy | reference | yes | → Users. Warehouse Operator records verified actual evidence; disputed outcome requires Warehouse Manager review. |
RecipientEvidence | longtext | yes | Actual recipient/handoff/source reference and quantities; carrier transport acknowledgment is not proof of receipt. |
| 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 activation; Finance Manager separately approves affected cost standards. Released work keeps prior version. | |
EngineeringChange | reference | → EngineeringChangeOrders. Coordinated technical revision, disposition of open work and effective boundary. |
| Field | Type | Required | Details |
|---|---|---|---|
BOM | reference | yes | → BOMs. Versioned recipe. |
LineNumber | number | yes | Stable component identity. |
Component | reference | yes | → Products. Input SKU; cycles forbidden across active recipes. |
BaseQuantity | decimal | yes | Positive input base quantity per BOM output basis. |
PlannedScrapPercent | decimal | yes | Nonnegative reviewed expected extra input, with explicit gross-input formula; not also applied to output quantity. |
Instruction | longtext | yes | Material grade/lot substitution restrictions; substitutions require reviewed new scope. |
| 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 activation; Finance Manager rate/cost changes and Quality Inspector inspection criteria require their own independent decisions. | |
StartsAt | datetime | yes | Inclusive version effectivity. |
EndsAt | datetime | Exclusive. | |
EngineeringChange | reference | → EngineeringChangeOrders. Grouped approved technical change. |
| Field | Type | Required | Details |
|---|---|---|---|
Routing | reference | yes | → Routings. Parent version. |
Sequence | number | yes | Positive unique execution order. |
Name | text | yes | Discrete manufacturing operation label. |
Instructions | longtext | yes | Concrete safety/inspection/acceptance instructions; no formal QMS certification claim. |
TerminalOperation | boolean | yes | Exactly one final output operation; intermediate throughput never becomes extra finished units. |
LabourRatePerHour | decimal | yes | Known nonnegative entity-functional absorption rate, independently finance-approved. |
OverheadBasis | select | yes | None, LabourHour, MachineHour, OutputUnit |
OverheadRate | decimal | yes | Known nonnegative rate in declared basis; no embedded amount added again. |
WorkCenter | reference | yes | → WorkCenters. Approved capable center; alternatives need reviewed capability/schedule changes. |
SetupHours | decimal | yes | Nonnegative hours per released batch, applied once; not once per finished unit. |
RunHoursPerBaseUnit | decimal | yes | Nonnegative machine/center hours per output base unit on the declared batch/yield basis. |
LabourHoursPerBaseUnit | decimal | yes | Nonnegative standard direct labour hours per output base unit; actual accepted hours cost WIP. |
QueueHours | decimal | yes | Nonnegative planning-only elapsed buffer; not labour/overhead charge. |
MoveHours | decimal | yes | Nonnegative planning-only elapsed buffer. |
OverlapAllowed | boolean | yes | Only the explicitly reviewed overlap rule in instructions; no automatic parallel throughput assumptions. |
InspectionPlan | reference | → InspectionPlans. Effective required in-process/final/first-article plan; freeze version on work release. |
| 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 | → Routings. 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; release signer must be independent of planner/preparer/material editors. |
ReleasedAt | datetime | Actual Production Manager release after feasible capacity, required technical/quality versions and known costs; shortages/quality holds remain blocking. | |
ClosedAt | datetime | All input/output/scrap/WIP/cost obligations reconciled and necessary independent finance variance decision. | |
Planner | reference | yes | → Users. Production Planner preparing actual sequence/material/capacity plan. |
PlannedOrder | reference | → PlannedOrders. Stable source; duplicate MRP runs cannot generate extra work for the same supply scope. | |
Demand | reference | → DemandRequirements. Primary accepted order or approved stock-production demand; additional bounded pegs retained by MRPPeggings. | |
CompletedQuantity | decimal | yes | Net posted ProductionCompletions terminal output only; intermediate good counts never sum here. |
ScrappedQuantity | decimal | yes | Unique final output-equivalent scrap scope, not sum of the same units rejected at several operations. |
RemainingWIP | decimal | yes | Sum posted WorkOrderCostEntries signed deltas; each completion/scrap relief allocated once. |
CloseDecision | reference | → ApprovalDecisions. Independent Production Manager quantity/obligation closure approval, excluding closure preparer/material editors; required before Closed. | |
CloseFinanceDecision | reference | → ApprovalDecisions. Independent Finance Manager approval for remaining WIP/cost variance or financial exception; previously posted completion variance is not posted again. |
| Field | Type | Required | Details |
|---|---|---|---|
WorkOrder | reference | yes | → WorkOrders. Released job. |
BOMComponent | reference | yes | → BOMComponents. Frozen technical source. |
Product | reference | yes | → Products. Input SKU. |
RequiredBaseQuantity | decimal | yes | Planned output / BOM output basis × component input × explicit scrap factor once. |
IssuedQuantity | decimal | yes | Gross actual material issue into exclusive work-order WIP custody; source inventory quantity/value removed once. Later returns and consumption remain separate derived counters from exact issue-source WorkOrderCostEntries. |
ReturnedQuantity | decimal | yes | Unused physical WIP material actually returned from remaining issue-source quantity/cost into a new inventory layer; never debit a depleted original inventory position or return consumed material. |
ConsumedQuantity | decimal | yes | Actual component base quantity used/scrapped in process; sum exact issue-source MaterialConsumedQuantity, not a second stock issue. Issued minus returned minus consumed is physically unused WIP material. |
Reservation | reference | → InventoryReservations. Exact material claim; multiple split claims linked by this source. |
| Field | Type | Required | Details |
|---|---|---|---|
WorkOrder | reference | yes | → WorkOrders. Released job. |
RoutingOperation | reference | yes | → RoutingOperations. Frozen sequence/rates/bases. |
AssignedTo | reference | yes | → Users. Assigned Operator; Shop Floor Supervisor coordinates and independently accepts actual work. |
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. | |
WorkCenter | reference | yes | → WorkCenters. Actual capable center; changing center needs approved remaining-scope schedule/rate review. |
Rate | reference | yes | → WorkCenterRates. Frozen applicable labour/overhead version; copying it into instructions does not create a second charge. |
InspectionPlan | reference | → InspectionPlans. Frozen required operation/first-article/final quality version. | |
InputQuantity | decimal | yes | Net transferred eligible work scope into this operation; first operation derives reviewed released batch/material scope. |
AcceptedQuantity | decimal | yes | Unique accepted good operation throughput, separate from terminal finished-stock output. |
RemainingQuantity | decimal | yes | Eligible input still awaiting good/reject/hold disposition; transferred accepted output is tracked separately and never subtracted a second time from input already consumed by accepted output. |
| 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 Operator; entry also records the actual producing person, which may differ from recorder. |
Status | select | yes | Draft, Submitted, Accepted, Rejected, Corrected |
StartedAt | datetime | yes | Actual time. |
EndedAt | datetime | Actual time; no overlap/double use of same person's time interval. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
GoodQuantity | decimal | yes | Nonnegative operation throughput in output base units, reconciled to unused exact input scope; held/rejected and repeated rework passes are not new good terminal units. |
ScrapQuantity | decimal | yes | Nonnegative actual rejected output-equivalent evidence; input scrap quantities separately traced. |
LabourHours | decimal | Accepted actual person-hours with overlap checks across every live entry for the same person; no charge for unclosed/invalid time and no payroll effect. Null until actual interval/basis known; finite nonnegative value required before acceptance/cost posting, with explicit known zero allowed. | |
AcceptedBy | reference | → Users. Independent Shop Floor Supervisor excluding producing person, recorder and material editors; quality release is separate. | |
CorrectionOf | reference | → ProductionEntries. Prior entry and consumed costs/completions reconciled first. | |
ProducedBy | reference | yes | → Users. Actual person doing the work; two logins belonging to that person do not permit self-acceptance. |
ScopeKey | text | yes | Stable batch/unit operation-pass identity; rework uses linked new pass and cannot create new finished quantity. |
MachineHours | decimal | Nonnegative actual accepted occupied machine hours; distinct from elapsed person-hours and setup overlap. Null until actual interval/basis known; finite nonnegative value required before acceptance/cost posting, with explicit known zero allowed. | |
AcceptedAt | datetime | Actual independent technical/time confirmation. | |
InputAllocations | longtext | yes | Validated exact ProductionFlows or released first-operation input scope with quantities; sum inputs = good + scrap + held/unfinished scope, no double-use across entries. |
HeldQuantity | decimal | yes | Nonnegative inspected/awaiting-decision operation scope, excluded from accepted transferable/completable good units. |
UnfinishedQuantity | decimal | yes | Nonnegative input scope still physically unfinished after this entry; retained for later work, never transferred/completed as good. Input allocation = GoodQuantity + ScrapQuantity + HeldQuantity + UnfinishedQuantity, all disjoint. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
CompletionNumber | text | yes | Unique terminal completion. |
WorkOrder | reference | yes | → WorkOrders. Released job. |
TerminalEntry | reference | yes | → ProductionEntries. Unused accepted terminal good quantity only. |
Status | select | yes | Prepared, PendingApproval, Approved, Posted, Reversed |
OutputQuantity | decimal | yes | Positive base output, bounded by remaining accepted terminal scope and authorized work order. |
LotNumber | text | Required output lot. | |
Location | reference | yes | → Locations. Actual received finished-stock location. |
AllocatedActualWIP | decimal | yes | Known unused approved material/labour/overhead carrying allocated by frozen production cost basis; active completion/scrap claims reduce availability before posting. Missing inputs block, explicit known zero possible. |
StandardOutputValue | decimal | yes | OutputQuantity × frozen output standard, rounded once. |
Variance | decimal | yes | AllocatedActualWIP − StandardOutputValue; positive adverse expense, negative favorable variance, once. |
CompletedAt | datetime | yes | Actual completion evidence. |
ConfirmedBy | reference | yes | → Users. Independent Shop Floor Supervisor excluding producing/recording people and material editors; required independent Quality Inspector release remains separate. |
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. 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. | |
QualityInspection | reference | → QualityInspections. Required final/first-article inspection evidence for the exact accepted terminal scope under frozen plan. | |
QualityDisposition | reference | → QualityDispositions. Independent Quality Inspector scoped release; required when plan/hold/NCR requires release, with no bypass through completion status. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
CostEntryNumber | text | yes | Unique cost source/effect. |
WorkOrder | reference | yes | → WorkOrders. One WIP owner. |
Kind | select | yes | MaterialIssue, MaterialReturn, Labour, Overhead, CompletionRelief, Scrap, Correction, Opening |
Material | reference | → WorkOrderMaterials. Exact input source when material. | |
ProductionEntry | reference | → ProductionEntries. Unused approved time/throughput basis for labour/overhead. | |
Completion | reference | → ProductionCompletions. Output WIP relief. | |
Amount | decimal | yes | Signed WIP delta in entity-functional currency; material and labour/overhead charged only once. |
AllocatedAmount | decimal | yes | Absolute positive source cost consumed by completion/scrap or unused-material-return relief. Active ReservedAmount reduces availability too; no source amount is relieved twice. |
Basis | longtext | yes | Frozen hours/units/rates, source layer quantities/value, calculation and allocation remainder. |
Status | select | yes | Prepared, Approved, Posted, Reversed |
OccurredAt | datetime | yes | Actual cost evidence time. |
Journal | reference | → JournalEntries. Balanced WIP posting; standard absorption counteraccount is not a second actual payroll expense. | |
ReversalOf | reference | → WorkOrderCostEntries. Exact signed reversal only after consumed completion/stock effects resolved. | |
ReservedAmount | decimal | yes | Active completion/scrap allocation claims in functional currency; subtract from unallocated source amount before any new claim. |
ConsumedSources | longtext | For completion/scrap/return relief: exact positive cost-entry keys, functional amounts and, for material, base quantities/lot/serial. Material amount uses original source carrying per base unit and final remainder. Sum equals actual WIP relieved; completion/scrap quantity <= physically consumed unallocated material, return quantity <= physically unused issue quantity. A reversal restores eligible claims once. | |
SourceStockEvent | reference | → StockEvents. Actual material issue/return/scrap source event; paired stock/WIP effects commit once. | |
SourceLayer | reference | → StockLayers. Original issue layer for material source; retained historical identity even after depletion, never an instruction to reverse blindly there. | |
Lot | reference | → Lots. Material issue-source lot, matching product/entity. | |
Serial | reference | → Serials. Exact material serial when controlled; issue/return/consumption quantity is one. | |
MaterialBaseQuantity | decimal | For MaterialIssue: positive immutable actual gross issue quantity, valued at the exact source layer carrying basis; null for nonmaterial entries. | |
MaterialReturnedQuantity | decimal | Sum actual unused returns allocated to this MaterialIssue source, initially known zero and bounded by unconsumed/available quantity. | |
MaterialConsumedQuantity | decimal | Sum actual component use/scrap allocated to this issue source, initially known zero; no inventory quantity effect after original issue. | |
AllocatedMaterialQuantity | decimal | Consumed source material quantity whose cost has been relieved into output/scrap, excluding separately returned quantity; capped by physically MaterialConsumedQuantity. | |
MaterialSource | reference | → WorkOrderCostEntries. MaterialReturn or corrective source points to exact original MaterialIssue; all split sources explicitly enumerated in ConsumedSources when multiple. | |
ReservedMaterialQuantity | decimal | For a MaterialIssue source, active uncommitted use/return quantity claims; physically unused availability = MaterialBaseQuantity minus MaterialReturnedQuantity minus MaterialConsumedQuantity minus ReservedMaterialQuantity. Commit replaces the claim with one actual use/return, never both. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Return | reference | yes | → Returns. Authorized direction. |
ShipmentLine | reference | → ShipmentLines. Customer source; required unless controlled migration source preserved in baseline. | |
ReceiptLine | reference | → GoodsReceiptLines. Supplier source; exact original accepted quantity/descendants. | |
OriginalInvoiceLine | reference | → InvoiceLines. Customer original billing scope if invoiced. | |
OriginalBillLine | reference | → BillLines. Supplier billed scope; null only wholly unmatched receipt portion. Split mixed billed/unbilled return scope. | |
AuthorizedQuantity | decimal | yes | Positive base quantity bounded by original net unreturned scope. |
ActualQuantity | decimal | yes | Actual physical received/dispatched quantity, bounded by authorization. |
OriginalIssuedValue | decimal | Original title-issue carrying value for post-title customer return; null before title or for supplier scope, never fabricated zero. | |
CurrentRemovalValue | decimal | yes | Current descendant carrying value for supplier return or pre-title owned-transit custody return; zero-quantity residual value is forbidden. |
OriginalCommercialValue | decimal | yes | Scoped original net/tax settlement basis kept separate from carrying removal. |
LotNumber | text | Trace original identity; changed identity requires explicit reviewed disposition. | |
PhysicalAt | datetime | Actual return receipt or supplier handover. | |
StockEvent | reference | → StockEvents. Actual custody/owned-stock effect once. | |
ReceiptAcceptance | reference | → ReceiptAcceptances. Required for supplier return of accepted owned goods; binds original posted tranche/descendants, rather than gross arrival. |
| 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 | Reviewed traced value: post-title customer restock restores original title-issue cost once; pre-title owned-transit return retains current carrying without COGS. A new-standard update is a separate event. |
Destination | reference | → Locations. Required for held/restocked/rework stock. | |
PreparedBy | reference | yes | → Users. Warehouse Operator observations. |
DecidedAt | datetime | Independent WM disposition; FM additionally authorizes loss/value exception. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
StockEvent | reference | → StockEvents. No physical/economic effect from status alone. | |
QualityDisposition | reference | → QualityDispositions. Required independent quality decision for controlled/failed product; physical/financial authority still separate. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Invoice | reference | yes | → Invoices. Parent revision. |
LineNumber | number | yes | Stable line. |
OrderLine | reference | → SalesOrderLines. Required trade debit source. | |
ShipmentLine | reference | → ShipmentLines. Required actual eligible title transfer, not planned dispatch or unverified POD. | |
OriginalLine | reference | → InvoiceLines. Required credit source. | |
ReturnLine | reference | → ReturnLines. Physical return basis when applicable; commercial-only credit explicitly reviewed. | |
BaseQuantity | decimal | yes | Positive scoped base quantity; financial-only price correction can use zero with explicit original value basis. |
NetAmount | decimal | yes | Allocated accepted order net once, or bounded original credited net; no second discount deduction. |
TaxAmount | decimal | yes | Correct eligible tax basis/rate/exemption snapshot, not unreviewed default zero. |
TaxEvidence | longtext | yes | Frozen exact rule/rate/basis and original credit allocation. |
Allocation | reference | → SalesAllocations. Reserved then posted once with invoice. |
| 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. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
BankCode | text | yes | Unique bank/currency account. |
Currency | reference | yes | → Currencies. Actual bank currency. |
LedgerAccount | reference | yes | → ChartOfAccounts. Same-entity bank control. |
Status | select | yes | Draft, Active, Blocked, Closed |
ProtectedDetails | longtext | yes | Accountant/Finance Manager only under current purpose; operator/sales exports excluded. |
BalanceQuantity | decimal | yes | Actual posted bank-currency balance, reconciled to statement. |
CarryingValue | decimal | yes | Functional carrying balance including delta bank revaluation. |
UnrealizedFX | decimal | yes | Signed prior bank FX to reclassify on scoped disposal. |
ReservedQuantity | decimal | yes | Active released/unsettled instructions/refunds; prevent duplicate spend where finite availability policy applies. |
Version | number | yes | Atomic balance/reservation version. |
Activation | reference | → MasterChanges. Independent Finance Manager. Absent until the real action; mandatory before the corresponding active/approved/posted state. |
| 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. |
| 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. Same entity and receipt currency. |
Status | select | yes | Prepared, Posted, PartiallyApplied, Applied, Returned, Reversed |
ReceivedAt | datetime | yes | Actual bank/cash receipt evidence time. |
Period | reference | yes | → AccountingPeriods. Eligible posting period. |
Amount | decimal | yes | Positive receipt-currency amount. |
UnappliedAmount | decimal | yes | Amount less posted receipt-currency applications/refunds/returns; active reservations separately reduce availability. |
UnappliedCarrying | decimal | yes | Functional remaining unapplied liability carrying, including its own revaluation. |
UnrealizedFX | decimal | yes | Gain-positive prior FX on unapplied liability, released/reclassified proportionally. |
ReservedAmount | decimal | yes | Active application/refund claims in receipt currency; never invoice currency. |
StatementLine | reference | → BankStatementLines. Actual settlement evidence or reviewed manual cash proof in Event. | |
Journal | reference | → JournalEntries. Dr Bank / Cr UnappliedCustomer once. | |
Baseline | longtext | yes | Opening receipt amount/applied/unapplied/carrying/FX and original source IDs, nonposting. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
ApplicationNumber | text | yes | Unique application. |
Receipt | reference | yes | → CashReceipts. Identified same-entity/customer receipt. |
Invoice | reference | yes | → Invoices. Posted debit invoice same customer/entity. |
Status | select | yes | Reserved, Approved, Posted, Reversed, Cancelled |
ReceiptAmount | decimal | yes | Positive cash consumed in receipt currency only. |
InvoiceCashAmount | decimal | yes | Positive cash-funded portion in invoice currency. |
DiscountAmount | decimal | yes | Nonnegative approved noncash settlement discount in invoice currency. |
WriteOffAmount | decimal | yes | Nonnegative approved invoice-currency write-off; independent FM decision required. |
ReceiptRate | reference | yes | → ExchangeRates. Receipt currency settlement reference. |
InvoiceRate | reference | yes | → ExchangeRates. Invoice currency settlement reference. |
FunctionalSettlement | decimal | yes | Reviewed equivalent cash/noncash functional value; receipt and invoice cash equivalents reconcile within explicit decimal policy. |
InvoiceCarryingReleased | decimal | yes | Current carrying of settled total invoice quantity, proportional with final remainder. |
ReceiptCarryingReleased | decimal | yes | Current unapplied liability carrying of consumed ReceiptAmount, not bank value. |
InvoiceFXReleased | decimal | yes | Prior signed unrealized invoice FX in released portion. |
ReceiptFXReleased | decimal | yes | Prior signed unapplied-liability FX in released portion. |
SettlementFXDelta | decimal | yes | Functional noncash + ReceiptCarryingReleased − InvoiceCarryingReleased, gain-positive net application delta; cash receipt does not debit bank again. |
AppliedAt | datetime | Actual committed application time. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
Journal | reference | → JournalEntries. Dr unapplied liability/noncash expense and Cr AR plus delta FX, with zero-net prior FX reclassification. | |
ReversalOf | reference | → CashApplications. Exact original allocation, carrying/FX and claimed scope restored once. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
PaymentNumber | text | yes | Stable disbursement. |
Run | reference | yes | → PaymentRuns. Approved exact run revision. |
Supplier | reference | yes | → Suppliers. Same-entity beneficiary. |
BankAccount | reference | yes | → BankAccounts. Entity source bank. |
Beneficiary | reference | yes | → SupplierBankAccounts. Approved exact beneficiary version. |
BeneficiaryHash | text | yes | Must equal released destination; changes invalidate unsent authorization. |
Currency | reference | yes | → Currencies. Bank/payment currency. |
Amount | decimal | yes | Positive proposed payment-currency total allocated or explicitly supplier prepayment. |
Status | select | yes | Reserved, Released, Submitted, Accepted, Uncertain, Settled, Rejected, Returned, Cancelled |
Instruction | reference | → IntegrationDeliveries. Intent/attempt, not settlement proof. | |
SettlementEvent | reference | → IntegrationEvents. Actual authenticated/manual-confirmed bank outcome. | |
SettledAt | datetime | Actual cash settlement. | |
BankCarryingReleased | decimal | Current functional bank value disposed, separate from AP settlement carrying. | |
Journal | reference | → JournalEntries. Cash/AP/prepayment/FX effect only on authoritative settlement. | |
PrepaymentRemaining | decimal | yes | Unapplied supplier-prepayment amount remaining in payment currency; zero for fully bill-allocated disbursement. |
PrepaymentCarrying | decimal | yes | Functional remaining supplier-prepayment asset with its own revaluation where monetary. |
PrepaymentFX | decimal | yes | Signed prior unrealized FX on remaining prepayment. |
PrepaymentReserved | decimal | yes | Active application/refund claims reduce availability; never send bank cash again to apply a settled prepayment. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
AllocationNumber | text | yes | Unique payment/bill allocation. |
Payment | reference | yes | → Payments. Parent economic disbursement. |
Bill | reference | → Bills. Posted same-supplier debit; null only explicit approved supplier prepayment. | |
Status | select | yes | Reserved, Settled, Released, Reversed |
PaymentAmount | decimal | yes | Positive payment-currency cash portion. |
BillCashAmount | decimal | yes | Bill-currency cash portion; zero only prepayment. |
DiscountAmount | decimal | yes | Approved bill-currency discount, not cash consumed. |
PaymentRate | reference | yes | → ExchangeRates. Exact settlement conversion. |
BillRate | reference | yes | → ExchangeRates. Exact bill settlement basis. |
FunctionalSettlement | decimal | yes | Cash equivalent plus approved discount in functional currency. |
BillCarryingReleased | decimal | yes | Current AP carrying of settled portion. |
BillFXReleased | decimal | yes | Prior unrealized AP gain-positive amount, reclassified zero-net. |
SettlementFXDelta | decimal | yes | BillCarryingReleased − FunctionalSettlement, gain-positive AP delta; bank disposal FX is separate. |
SettledAt | datetime | Actual effect time. | |
ReversalOf | reference | → PaymentAllocations. Original settlement reversal linked to bank return; same scope cannot reopen twice. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
CreditApplicationNumber | text | yes | Unique economic use. |
Side | select | yes | Customer, Supplier |
CreditInvoice | reference | → Invoices. Customer CreditNote; mutually exclusive with CreditBill. | |
CreditBill | reference | → Bills. Supplier CreditNote. | |
DebitInvoice | reference | → Invoices. Same customer/entity debit target. | |
DebitBill | reference | → Bills. Same supplier/entity debit target. | |
CreditAmount | decimal | yes | Positive credit-currency use; active Reserved amounts subtract availability. |
DebitAmount | decimal | yes | Positive debit-currency settlement equivalent. |
RateEvidence | longtext | yes | Frozen pair/date/type/multipliers and carrying/FX allocations; same-currency identity explicit. |
Status | select | yes | Reserved, Posted, Released, Reversed |
CreatedAt | datetime | yes | Atomic claim time. |
PostedAt | datetime | Actual zero-cash clearing. | |
Journal | reference | → JournalEntries. Clear credit-control and debit-control current carrying, remaining difference FX; reclassify prior unrealized zero-net. | |
ReversalOf | reference | → CreditApplications. Exact prior claim. | |
SupplierPrepayment | reference | → Payments. Alternative supplier-credit funding source; XOR CreditBill; settled available same-supplier prepayment only. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
RefundNumber | text | yes | Unique refund/claim. |
Direction | select | yes | ToCustomer, FromSupplier |
CreditInvoice | reference | → Invoices. One customer-credit funding source. | |
CashReceipt | reference | → CashReceipts. Alternative unapplied-customer-cash funding source; XOR CreditInvoice, never both. | |
CreditBill | reference | → Bills. Supplier-credit collection source for FromSupplier. | |
Currency | reference | yes | → Currencies. Actual bank currency. |
Amount | decimal | yes | Positive cash amount. |
SourceAmount | decimal | yes | Amount consumed in source document/receipt currency, separate from bank currency. |
SourceCarrying | decimal | yes | Current functional funding value released. |
RateEvidence | longtext | yes | Exact equivalent amount, bank carrying and prior FX reclassification basis. |
BankAccount | reference | yes | → BankAccounts. Same entity account. |
Status | select | yes | Draft, PendingApproval, Reserved, Released, Submitted, Uncertain, Settled, Rejected, Returned, Cancelled |
Instruction | reference | → IntegrationDeliveries. Transport intent only. | |
SettlementEvent | reference | → IntegrationEvents. Authoritative actual cash outcome. | |
SettledAt | datetime | Actual posting time. | |
Journal | reference | → JournalEntries. Funding control versus actual bank value/FX once; credit-funded refunds do not also reduce original cash applications. | |
SupplierPrepayment | reference | → Payments. Alternative FromSupplier funding collection; XOR CreditBill. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
CorrectionNumber | text | yes | Unique economic correction. |
Kind | select | yes | CashReturn, PaymentReturn, RefundReturn, InvoiceReversal, BillReversal, WriteOff, BankFee, PostingCorrection, OpeningCorrection |
Status | select | yes | Draft, PendingApproval, Approved, Posted, Rejected |
SourceTable | text | yes | Exact existing source type. |
SourceKey | text | yes | Original immutable source/effect identity. |
Scope | longtext | yes | Original currency/value/allocations/FX/tax/cost affected, downstream constraints and once-only restoring claims. |
OccurredAt | datetime | yes | Actual evidence date/time. |
PostingDate | date | yes | Eligible current posting date, not rewritten original. |
Period | reference | yes | → AccountingPeriods. Same entity open period. |
Journal | reference | → JournalEntries. Compensates only traced effects; new fee/rate difference separately identified. |
| 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. |
| 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 |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
JournalNumber | text | yes | Unique entity journal. |
Kind | select | yes | Trade, Stock, WIP, Cash, Tax, FX, Reclassification, Manual, Opening, Correction |
Status | select | yes | Draft, PendingApproval, Approved, Posted, Reversed |
PostingDate | date | yes | Date in eligible Period. |
Period | reference | yes | → AccountingPeriods. Same entity. |
SourceTable | text | yes | Existing typed source or explicitly authorized Manual/Opening evidence. |
SourceKey | text | yes | Unique economic source/effect; a second transport event cannot repost it. |
PostedAt | datetime | Actual local posting. | |
ReversalOf | reference | → JournalEntries. Exact prior journal/line source; no destructive editing. |
| 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. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
AcceptanceNumber | text | yes | Unique arrival/tranche identity; duplicate callbacks reuse it. |
ReceiptLine | reference | yes | → GoodsReceiptLines. One immutable actual arrival line. |
Disposition | select | yes | Accept, Reject |
Status | select | yes | Prepared, PendingReview, Confirmed, Posted, Reversed |
BaseQuantity | decimal | yes | Positive tranche quantity; active confirmed tranches cannot exceed arrived quantity less previous live tranches. |
StandardCost | reference | → StandardCosts. Required for accepted owned-stock effect; frozen version. | |
ReceiptRate | reference | → ExchangeRates. Required dated receipt valuation multiplier. | |
CommercialFunctionalValue | decimal | Accepted scoped PO net/approved capitalizable charges at receipt rate; zero only approved known-zero basis. | |
ConfirmedBy | reference | yes | → Users. Independent Warehouse Operator, not PO buyer or commercial approver. |
ConfirmedAt | datetime | Actual physical disposition confirmation. | |
Evidence | longtext | yes | Condition/quantity evidence and any independent WM/FM exception decisions; rejected quantity creates no owned stock or GRNI. |
StockEvent | reference | → StockEvents. Accepted tranche posts quantity/standard value/GRNI/variance once; rejection has no owned posting. | |
ReversalOf | reference | → ReceiptAcceptances. Exact prior tranche only after downstream stock/match/return effects reconcile. | |
Inspection | reference | → QualityInspections. Required incoming inspection population when product/receipt policy calls for it. | |
QualityDisposition | reference | → QualityDispositions. Current independent Quality Inspector release of exact accepted tranche when inspected/held; Warehouse Operator remains factual receipt actor. |
| 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. | |
LeadNumber | text | yes | Stable source lead identity; provider/source key unique within connector and entity. |
CompanyName | text | yes | Unverified business name until conversion. |
ContactName | text | yes | Business contact name. |
Email | text | Purpose-limited business email; not a unique identity by itself. | |
Phone | text | Purpose-limited business phone. | |
Source | select | yes | Web, Referral, Partner, Event, InboundCall, Outbound, Import |
Status | select | yes | New, Contacted, Qualified, Disqualified, Converted |
Owner | reference | yes | → Users. Assigned Sales Representative; active entity-scoped person. |
CreatedAt | datetime | yes | Actual first recorded timestamp; import preserves prior source time separately. |
NextActionAt | datetime | Current follow-up due time. | |
QualifiedAt | datetime | Sales Representative factual qualification time and evidence, not an automatic commercial approval. | |
QualificationEvidence | longtext | Need, product fit, customer identity and agreed next action; no invented budget or contact authority. | |
DisqualifiedReason | select | NoFit, NoResponse, Timing, Duplicate, Other | |
Conversion | reference | → LeadConversions. One completed mapping; repeat uses same result. |
| 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. | |
ConversionNumber | text | yes | Unique per original lead conversion effect. |
Lead | reference | yes | → Leads. Qualified source and expected revision, locked during conversion. |
Status | select | yes | Prepared, Confirmed, ReviewRequired, Cancelled |
Account | reference | yes | → Accounts. Existing reviewed account or one newly created prospect; same entity. |
ContactPerson | reference | yes | → ContactPersons. Reviewed person under that exact account; no email-only merge. |
Opportunity | reference | → Opportunities. Optional new deal or explicitly reviewed existing source; no repeated opportunity on retry. | |
MatchEvidence | longtext | yes | Normalization, duplicate candidates, source revision and explicit reuse/create decision. Conflicting matches block conversion. |
ConfirmedBy | reference | → Users. Sales Representative within assigned scope; new active trading/credit remains separately approved. Absent until the actual action; mandatory for the corresponding confirmed/approved state. | |
ConfirmedAt | datetime | Actual conversion time. Absent until the actual action; mandatory for the corresponding confirmed/approved state. |
| 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. |
OpportunityNumber | text | yes | Stable deal identity. |
Name | text | yes | Specific customer project or requirement. |
Account | reference | yes | → Accounts. Same-entity prospect/customer. |
PrimaryContact | reference | → ContactPersons. Same account; contact authority is checked separately. | |
SourceLead | reference | → Leads. Original qualified source. | |
Owner | reference | yes | → Users. Sales Representative; manager sees reviewed entity/team scope. |
Stage | select | yes | Qualify, Discovery, Proposal, Negotiate, Won, Lost |
Status | select | yes | Open, Closed, Reopened |
ExpectedNetAmount | decimal | Nonnegative estimate in Currency excluding tax; unknown remains null, not zero, and cannot be silently excluded from forecast review. Never accepted bookings or revenue. | |
Currency | reference | yes | → Currencies. Estimate currency; report conversion retained per forecast snapshot. |
ProbabilityPercent | decimal | yes | Finite 0–100 explicit estimate; policy default does not prove outcome. |
ForecastCategory | select | yes | Pipeline, BestCase, Commit, Omitted, Won |
ExpectedCloseDate | date | yes | Current estimate; history preserves previous values. |
ClosedAt | datetime | Actual transition time for Won or Lost, preserved in history when reopened. | |
CloseEvidence | longtext | Won binds accepted quote/order scope; Lost records reason and source; no stock/ledger effect. | |
LostReason | select | Price, Competitor, NoDecision, Timing, Fit, Other | |
NextActionAt | datetime | Current follow-up deadline. |
| 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. | |
HistoryNumber | text | yes | Unique change event. |
Opportunity | reference | yes | → Opportunities. Same deal throughout correction/reopen chain. |
Status | select | yes | Recorded, Corrected |
Before | longtext | yes | Exact previous stage/status/net/currency/probability/owner/expected and actual close values. |
After | longtext | yes | Exact next values; valid stage transition and required evidence checked. |
Reason | longtext | yes | Actor-supplied reason; Won/negotiation exceptions bind current approval/acceptance evidence. |
ChangedBy | reference | yes | → Users. Actual authorized Sales Representative or Sales Manager. |
ChangedAt | datetime | yes | Actual change time; source occurrence separately retained for imports. |
CorrectionOf | reference | → OpportunityHistory. Append-only correction, never erase original close history. |
| 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. | |
ActivityNumber | text | yes | Unique actual activity or planned task. |
Kind | select | yes | Call, Email, Meeting, Task, Note |
Status | select | yes | Planned, InProgress, Completed, Cancelled, Failed |
Lead | reference | → Leads. Lead context; at least one valid business context required. | |
Account | reference | → Accounts. Customer context. | |
ContactPerson | reference | → ContactPersons. Same account when present. | |
Opportunity | reference | → Opportunities. Same account/entity deal context. | |
Quote | reference | → Quotes. Related exact offer. | |
Order | reference | → SalesOrders. Related customer order. | |
Subject | text | yes | Business purpose; protected details stay within authorized scope. |
Owner | reference | yes | → Users. Responsible Sales Representative or Sales Manager. |
DueAt | datetime | yes | Planned next action. |
CompletedAt | datetime | Actual evidenced completion; email intent/provider acceptance alone is not successful delivery. | |
Outcome | longtext | Actual result and next step; no inferred customer response. | |
Delivery | reference | → IntegrationDeliveries. Optional configured communication attempt and outcome. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree. |
PreferenceNumber | text | yes | Unique subject/channel/purpose policy record. |
ContactPerson | reference | → ContactPersons. Exactly one subject: contact or lead. | |
Lead | reference | → Leads. Lead subject before conversion; conversion carries restrictive preferences forward. | |
Channel | select | yes | Email, Phone |
Purpose | select | yes | Relationship, Transactional |
Status | select | yes | Allowed, Suppressed, ReviewRequired |
Evidence | longtext | yes | Actual preference/source, applicable business purpose and configured policy; no blanket legal-compliance claim. |
EffectiveAt | datetime | yes | Actual effective time; restrictive changes apply immediately. |
RecordedBy | reference | yes | → Users. Scoped actual person; reinstatement requires reviewed evidence. |
| 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. | |
ForecastNumber | text | yes | Unique entity/owner/horizon/version. |
PeriodStart | date | yes | Inclusive forecast cohort start. |
PeriodEnd | date | yes | Inclusive end. |
ReportingCurrency | reference | yes | → Currencies. Single snapshot presentation currency, with explicit frozen rates per line. |
Status | select | yes | Draft, Submitted, Locked, Superseded |
AsOfAt | datetime | yes | Historical observation cutoff; future data cannot rewrite the snapshot. |
LockedBy | reference | → Users. Independent Sales Manager excluding preparer/material editors. | |
LockedAt | datetime | Actual lock time. |
| Field | Type | Required | Details |
|---|---|---|---|
Forecast | reference | yes | → SalesForecasts. Parent immutable snapshot. |
Opportunity | reference | yes | → Opportunities. At most one row per included opportunity per snapshot. |
OpportunityRevision | number | yes | Exact historical state at cutoff. |
Stage | select | yes | Qualify, Discovery, Proposal, Negotiate, Won, Lost |
Category | select | yes | Pipeline, BestCase, Commit, Omitted, Won |
Currency | reference | yes | → Currencies. Original opportunity currency. |
NetAmount | decimal | Nonnegative original estimate at cutoff; null when unknown, retained as unknown population with lock review; not silently treated as zero. | |
ProbabilityPercent | decimal | yes | Finite 0–100 snapshot value. |
Rate | reference | yes | → ExchangeRates. Explicit positive source-to-reporting conversion; missing rate blocks lock. |
WeightedAmount | decimal | NetAmount × ProbabilityPercent / 100 × retained rate, rounded once; null for unknown amount/rate and explicitly disclosed, never a firm-demand quantity. | |
ExpectedCloseDate | date | yes | Snapshot expected date, not today's revised field. |
ClosedAt | datetime | Historical actual close if present. | |
AcceptedNetAmount | decimal | yes | Disclosed sum of distinct accepted quote allocations at cutoff in report currency; separate measure, never added to weighted forecast as the same revenue. |
ValueState | select | yes | Known, UnknownAmount, MissingRate. Missing conversion blocks lock; UnknownAmount is included and explicitly reviewed/disclosed without a fabricated numeric total. |
| 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. | |
ChangeNumber | text | yes | Unique technical change. |
Product | reference | yes | → Products. Affected product. |
BOM | reference | → BOMs. Proposed immutable recipe version. | |
Routing | reference | → Routings. Proposed immutable operation version. | |
Reason | select | yes | DesignImprovement, SupplierChange, CostChange, QualityFinding, CustomerChange |
Description | longtext | yes | Exact before/after scope and affected descendants/documents. |
Status | select | yes | Draft, Defined, Assessed, PendingApproval, Approved, Applied, Verified, Rejected, Cancelled |
EffectiveAt | datetime | yes | Reviewed future or current cut-in boundary; no history rewrite. |
OpenWorkDisposition | longtext | yes | Each affected open order/WO/supply is explicitly retain-old, revise-unexecuted or controlled rework/cancel; material, customer and cost obligations reconciled. |
CostRollup | reference | → CostRollups. Known cost impact; unknown impact blocks relevant approval. | |
QualityDecision | reference | → ApprovalDecisions. Independent Quality Inspector for altered release/inspection criteria. | |
FinanceDecision | reference | → ApprovalDecisions. Independent Finance Manager for cost/rate/value impact. | |
AppliedAt | datetime | Actual guarded technical activation after all required independent decisions. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree. |
CalendarCode | text | yes | Unique site/version. |
Timezone | text | yes | IANA work-center timezone; timestamp intervals retain offsets. |
Status | select | yes | Draft, Active, Superseded |
StartsAt | datetime | yes | Inclusive effectivity. |
EndsAt | datetime | Exclusive. | |
Activation | reference | → MasterChanges. Independent Production Manager approves actual production calendar/version. |
| Field | Type | Required | Details |
|---|---|---|---|
Calendar | reference | yes | → Calendars. Parent approved version. |
WorkCenter | reference | → WorkCenters. Specific center override; null is reviewed site default. | |
StartsAt | datetime | yes | Inclusive real instant. |
EndsAt | datetime | yes | Exclusive later real instant; DST handled by actual duration. |
Kind | select | yes | Available, Shutdown, Maintenance |
CapacityUnits | number | yes | Authoritative available parallel resource count for this effective interval: positive integer <= WorkCenters.CapacityUnits; zero for Shutdown/Maintenance. Specific-center interval replaces the site default for the same period; never multiply two resource counts or overlap defaults/overrides. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree. |
CenterCode | text | yes | Unique entity/site center. |
Name | text | yes | Machine/cell label. |
Warehouse | reference | yes | → Warehouses. Actual production site. |
Calendar | reference | yes | → Calendars. Approved available intervals. |
CapacityUnits | number | yes | Positive maximum technically capable resource count; an interval uses its own reviewed count up to this cap, not a second multiplicand. |
EfficiencyPercent | decimal | yes | Finite >0 and <=100 explicit planning availability factor; applied once to capacity, not again to work hours or cost. |
Capabilities | longtext | yes | Reviewed product/process capability and restrictions; no assumed interchangeable machine. |
Supervisor | reference | yes | → Users. Assigned Shop Floor Supervisor. |
Status | select | yes | Draft, Active, Unavailable, Inactive |
Activation | reference | → MasterChanges. Independent Production Manager technical approval. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree. |
RateNumber | text | yes | Unique center/version. |
WorkCenter | reference | yes | → WorkCenters. Same entity. |
StartsAt | datetime | yes | Inclusive. |
EndsAt | datetime | Exclusive. | |
LabourRatePerHour | decimal | yes | Known nonnegative direct labour rate per actual approved person-hour. |
OverheadBasis | select | yes | None, LabourHour, MachineHour, OutputUnit |
OverheadRate | decimal | yes | Known nonnegative amount per declared basis; combined burden is never added again. |
Status | select | yes | Draft, Active, Superseded |
Activation | reference | → MasterChanges. Independent Finance Manager approval; Production Manager confirms technical basis. |
| 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. | |
RollupNumber | text | yes | Unique product/version/as-of calculation. |
Product | reference | yes | → Products. Manufactured output. |
BOM | reference | yes | → BOMs. Selected acyclic effective recipe. |
Routing | reference | yes | → Routings. Compatible technical version. |
CalculationQuantity | decimal | yes | Positive reviewed output batch in base units; setup divided by this basis once. |
CalculatedAt | datetime | yes | Actual snapshot time. |
Status | select | yes | Prepared, Calculated, PendingApproval, Approved, Applied, Superseded |
MaterialUnitCost | decimal | Sum eligible component standard extensions divided by output basis; subassembly standard not simultaneously exploded/charged again. Null until all required inputs are known; required finite nonnegative value before Calculated/Approved. | |
LabourUnitCost | decimal | Approved setup plus per-unit labour cost divided by calculation quantity once. Null until all required inputs are known; required finite nonnegative value before Calculated/Approved. | |
OverheadUnitCost | decimal | Declared overhead basis only, with no duplicated embedded burden. Null until all required inputs are known; required finite nonnegative value before Calculated/Approved. | |
UnitStandardCost | decimal | MaterialUnitCost + LabourUnitCost + OverheadUnitCost, final currency precision and retained rounding working. Null until all required inputs are known; required finite nonnegative value before Calculated/Approved. | |
Result | reference | → StandardCosts. One protected resulting version; calculation alone does not activate/revalue inventory. |
| Field | Type | Required | Details |
|---|---|---|---|
Rollup | reference | yes | → CostRollups. Parent snapshot. |
Kind | select | yes | Material, Labour, Overhead |
BOMComponent | reference | → BOMComponents. Material source. | |
RoutingOperation | reference | → RoutingOperations. Labour/overhead source. | |
StandardCost | reference | → StandardCosts. Material standard version, required for material. | |
CenterRate | reference | → WorkCenterRates. Rate version, required for labour/overhead. | |
BasisQuantity | decimal | yes | Nonnegative material units or declared hours/output-unit basis. |
Rate | decimal | Known nonnegative rate; missing stays null and blocks calculation/activation. | |
Amount | decimal | BasisQuantity × Rate; null if unknown. Final row receives deterministic rounding remainder. | |
Evidence | longtext | yes | Source versions, scrap/setup/quantity formulas and unique cost inclusion; missing or cyclic inputs reported. |
| 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. | |
ForecastNumber | text | yes | Unique entity/site/product/bucket version. |
Product | reference | yes | → Products. Stock/manufactured base-unit item. |
Warehouse | reference | yes | → Warehouses. Firm planning site. |
PeriodStart | date | yes | Inclusive demand bucket. |
PeriodEnd | date | yes | Inclusive nonoverlapping bucket end for same forecast basis. |
BaseQuantity | decimal | yes | Nonnegative total planning demand before matching accepted customer orders. |
ConsumedQuantity | decimal | yes | Sum live ForecastConsumptions, bounded by BaseQuantity. |
RemainingQuantity | decimal | yes | BaseQuantity minus live consumed quantity; never negative. |
Status | select | yes | Draft, Submitted, Approved, Superseded, Closed |
Planner | reference | yes | → Users. Production Planner. |
ApprovedAt | datetime | Actual independent Production Manager approval time; null before approval and required thereafter. This is not a CRM probability estimate. |
| 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. | |
ConsumptionNumber | text | yes | Stable forecast/order-line/remaining-scope identity. |
Forecast | reference | yes | → ProductionForecasts. Approved same-entity/product/site/bucket forecast. |
OrderLine | reference | yes | → SalesOrderLines. Approved customer demand; quote/opportunity estimates ineligible. |
BaseQuantity | decimal | yes | Positive matched order base quantity within both remaining sources. |
Status | select | yes | Active, Released, Superseded |
CreatedAt | datetime | yes | Actual atomic claim time. |
Basis | longtext | yes | Approved matching-window/precedence and source revisions; cancel/amend releases only unexecuted matched scope, preserving fulfilled demand history. |
| 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. |
RunNumber | text | yes | Unique entity/site/horizon/source revision run. |
Warehouse | reference | yes | → Warehouses. Planning site; eligible same-entity alternate/transfer supply declared explicitly. |
HorizonStart | date | yes | Inclusive. |
HorizonEnd | date | yes | Inclusive. |
AsOfAt | datetime | yes | Actual source cutoff, never today's mutable balance for a historical run. |
Status | select | yes | Prepared, Calculated, Reviewed, Superseded, ReviewRequired |
Planner | reference | yes | → Users. Production Planner. |
SourceSnapshot | longtext | yes | Exact approved order/forecast-consumption, open supply, remaining stock/claims, BOM/routing/calendar/lead-time/lot/batch versions and exclusions. |
PolicySnapshot | longtext | yes | Demand/firm-planning fences, explicit forecast consumption, netting/lot-sizing rules and eligible supply; conflicting or unknown inputs are exceptions. |
ReviewedAt | datetime | Production Planner review time; firming proposals requires independent Production Manager or purchasing approval separately. |
| 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. | |
DemandNumber | text | yes | Stable economic demand key, independent of MRP run version. |
Run | reference | yes | → MRPRuns. Current observed run, prior run history remains immutable in snapshots. |
Product | reference | yes | → Products. Required SKU/base unit. |
Warehouse | reference | yes | → Warehouses. Demand site. |
OrderLine | reference | → SalesOrderLines. Exactly one root source: approved order line or approved production forecast; component demand also links ParentDemand. | |
Forecast | reference | → ProductionForecasts. Unconsumed approved production demand only. | |
ParentDemand | reference | → DemandRequirements. Parent assembly requirement; acyclic explosion and source proportional quantity. | |
BOMComponent | reference | → BOMComponents. Frozen component source for child demand. | |
BaseQuantity | decimal | yes | Positive remaining demand after source fulfillment/cancellation/forecast consumption; no sum of unlike item units. |
NeedAt | datetime | yes | Actual planned need instant from source promise and routing/calendar lead-time offset. |
Status | select | yes | Open, Pegged, Firmed, Satisfied, Cancelled, ReviewRequired |
| 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. | |
Decision | reference | → ApprovalDecisions. Current valid independent action/scope/revision decision, required before corresponding action. | |
PlannedOrderNumber | text | yes | Stable proposed supply identity and revision. |
Run | reference | yes | → MRPRuns. Reproducible source snapshot. |
Product | reference | yes | → Products. Proposed supply SKU. |
Warehouse | reference | yes | → Warehouses. Receiving/production site. |
Kind | select | yes | Buy, Make, Transfer |
BaseQuantity | decimal | yes | Positive net shortage after eligible supply plus configured safety target, then MOQ/multiple rounding once. |
PlannedStart | datetime | yes | Calendar-aware proposal start. |
PlannedEnd | datetime | yes | Required supply availability; past-due/infeasible creates exception. |
Status | select | yes | Proposed, Reviewed, Firmed, PartiallyConverted, Converted, Cancelled, Superseded |
ConvertedQuantity | decimal | yes | GeneratedQuantity minus CancelledGeneratedQuantity; live generated scope. Available to convert = BaseQuantity minus ConvertedQuantity minus ReservedQuantity, >=0 across all run/revision/tranche claims. |
PurchaseOrderLine | reference | → PurchaseOrderLines. Generated purchase scope; spend approval separate. First linked target convenience only; all partial conversions are authoritative through PlannedOrderAllocations. | |
WorkOrder | reference | → WorkOrders. Generated make scope; independent Production Manager release separate. First linked target convenience only; all partial conversions are authoritative through PlannedOrderAllocations. | |
TransferLine | reference | → StockTransferLines. Generated same-entity transfer; Warehouse Manager approval separate. First linked target convenience only; all partial conversions are authoritative through PlannedOrderAllocations. | |
Revision | number | yes | Positive proposal revision; changing quantity/kind/site retains economic source identity and cannot undercut live generated/reserved scope. |
GeneratedQuantity | decimal | yes | Sum PlannedOrderAllocations.CreatedQuantity, immutable gross generated history. |
CancelledGeneratedQuantity | decimal | yes | Sum validated downstream CancelledQuantity; never includes received/started/fulfilled scope. |
ReservedQuantity | decimal | yes | Sum BaseQuantity on all ReservationActive PlannedOrderAllocations, including conflicted/uncertain attempts whose prior claim remains live; reduces convertibility before atomic full-target creation. |
| Field | Type | Required | Details |
|---|---|---|---|
Run | reference | yes | → MRPRuns. Parent immutable snapshot. |
Demand | reference | yes | → DemandRequirements. Specific requirement and revision. |
SupplyKind | select | yes | OnHand, Purchase, WorkOrder, Transfer, Planned |
Position | reference | → InventoryPositions. Only eligible free on-hand supply; active demand claims excluded or attributed to that same demand. | |
PurchaseLine | reference | → PurchaseOrderLines. Only approved remaining dated supply; received scope is not counted again. | |
WorkOrder | reference | → WorkOrders. Only remaining approved output not already in stock. | |
TransferLine | reference | → StockTransferLines. Only remaining valid same-entity incoming supply, not duplicate source and transit stock. | |
PlannedOrder | reference | → PlannedOrders. This run's proposal, not firm available stock. | |
BaseQuantity | decimal | yes | Positive allocated quantity bounded by demand and eligible remaining supply in the same SKU/base unit. |
AvailableAt | datetime | yes | Source availability snapshot; late supply remains visibly late. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree. |
ExceptionNumber | text | yes | Unique run/source/reason case. |
Run | reference | yes | → MRPRuns. Source snapshot. |
Demand | reference | → DemandRequirements. Affected demand. | |
PlannedOrder | reference | → PlannedOrders. Affected proposal. | |
WorkOrder | reference | → WorkOrders. Affected existing supply. | |
Kind | select | yes | Shortage, Expedite, Defer, Cancel, PastDue, Capacity, MissingMaster, MissingCost, QualityHold |
Product | reference | yes | → Products. Affected SKU. |
Quantity | decimal | Known positive affected base quantity; unknown remains null. | |
NeedAt | datetime | yes | Required need/review time. |
Owner | reference | yes | → Users. Production Planner; escalation retains specific production/purchasing/warehouse authority. |
Status | select | yes | Open, Reviewed, Actioned, Dismissed, Superseded |
Resolution | longtext | Actual approved source change or reason for dismissal; optional while Open, required before Actioned/Dismissed. Status alone cannot alter orders/stock. |
| 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. | |
LoadNumber | text | yes | Stable operation/window/snapshot identity. |
WorkCenter | reference | yes | → WorkCenters. Approved capable resource. |
Run | reference | → MRPRuns. Planning snapshot for proposed load. | |
PlannedOrder | reference | → PlannedOrders. Exactly one proposal or released WorkOrderOperation owner. | |
Operation | reference | → WorkOrderOperations. Released operation capacity reservation. | |
StartsAt | datetime | yes | Actual planned/reserved window start. |
EndsAt | datetime | yes | Later end using approved calendar intervals. |
SetupHours | decimal | yes | Nonnegative once-per-batch setup load. |
RunHours | decimal | yes | Nonnegative output basis × routing run time; no duplicated efficiency multiplier. |
AvailableHours | decimal | yes | Sum nonoverlapping effective Available interval duration × interval CapacityUnits × center EfficiencyPercent / 100 once, less other live reserved resource-hours. Never multiply the center cap again; blocked intervals contribute zero. |
Status | select | yes | Proposed, Reserved, Released, Complete, Cancelled, Conflict |
Evidence | longtext | yes | Calendar/capability/quantity/version hashes; conflict blocks release or requires explicit feasible reschedule and customer/supply review. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; source parties, prices, stock ownership, postings and authority must agree. |
LotNumber | text | yes | Unique entity/product/lot identity; display identifier alone is insufficient across products/entities. |
Product | reference | yes | → Products. Controlled SKU. |
Supplier | reference | → Suppliers. Original supplier when incoming. | |
SourceReceipt | reference | → GoodsReceiptLines. Immutable arrival source; current stock remains separate. | |
SourceCompletion | reference | → ProductionCompletions. Manufactured output source. | |
ExpiresAt | datetime | Evidence-backed shelf-life boundary; missing required expiry blocks use. | |
Status | select | yes | PendingReview, Released, Held, Exhausted |
Provenance | longtext | yes | Original source and downstream split/production lineage; lot status does not directly overwrite position quantities. |
| 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. |
| 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. | |
FlowNumber | text | yes | Stable operation scope transfer. |
WorkOrder | reference | yes | → WorkOrders. Same released production owner. |
SourceEntry | reference | → ProductionEntries. Accepted preceding operation scope; null only first operation release with exact approved batch/material basis. | |
DestinationOperation | reference | yes | → WorkOrderOperations. Same WO compatible next operation or explicitly authorized rework step. |
DestinationEntry | reference | → ProductionEntries. Actual receiving work evidence; filled once without increasing source quantity. | |
Kind | select | yes | Initial, Forward, Rework, Return |
BaseQuantity | decimal | yes | Positive same output-product base-unit work scope; available source net of all active/posted outgoing claims. |
Lot | reference | → Lots. Work scope lot where identified; resulting FG provenance may link components with different lots. | |
Serial | reference | → Serials. Exact output serial, quantity one, once assigned. | |
Status | select | yes | Prepared, Reserved, Transferred, Received, Cancelled, Reversed |
OccurredAt | datetime | yes | Actual handoff evidence. |
ConfirmedBy | reference | yes | → Users. Actual assigned Operator or Shop Floor Supervisor factual confirmation. |
QualityDisposition | reference | → QualityDispositions. Required for rework/held/deviation release, not a substitute for technical route authorization. | |
ScopeEvidence | longtext | yes | Original work-unit IDs, split/merge lineage and remaining quantities; rework recirculates the same units and never inflates terminal output. |
| 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, FirstArticle, InProcess, Final, Return |
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, FirstArticle |
SampleSize | number | yes | Positive minimum sample size; cannot exceed available population, and EveryUnit uses full population. |
AcceptanceRule | longtext | yes | Validated characteristic completeness, sample selection, acceptance/rejection thresholds and release population scope; no undisclosed statistical/AQL guarantee. |
Status | select | yes | Draft, Active, Superseded |
Activation | reference | → MasterChanges. Independent Quality Inspector approval, excluding prepared/edited criteria; changed technical requirements also need Production Manager review. |
| 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. |
| 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. Incoming source; exactly one physical source among receipt, production entry, completion or return line. | |
ProductionEntry | reference | → ProductionEntries. First-article/in-process/final observed work; same product/operation. | |
Completion | reference | → ProductionCompletions. Final prepared output scope where required, before stock posting. | |
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 | yes | Positive actual in-scope base quantity; not all historical lot quantity. |
SampleQuantity | decimal | yes | Positive inspected sample, <= population; reviewed sampling plan defines whether result can release remaining population. |
PopulationEvidence | longtext | yes | Exact source revision, unit/serial/sample selection and bounded eligible release population; no double allocation to other live dispositions. |
Status | select | yes | Planned, InProgress, PendingReview, Passed, Failed, Held, Corrected |
Inspector | reference | yes | → Users. Qualified scoped Quality Inspector; independent of producing/receiving/preparing physical source. |
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. Links required independent Quality Inspector QualityRelease for exact population, excluding physical producer/receiver and proposal preparer/material editors; observations alone do 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. |
| 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 | yes | Actual observation time. |
ObservedBy | reference | yes | → Users. Actual Quality Inspector observer. |
Evidence | longtext | yes | Measurement unit/method, instrument fitness evidence where required, source/photo/document hash; no calibration system implied. |
| 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 | yes | Positive known bounded source scope; separate cases cannot double-dispose same units. |
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 scoped Operator, Warehouse Operator, supervisor or Quality Inspector. |
RaisedAt | datetime | yes | Actual finding time. |
ClosedAt | datetime | All held/rework/scrap/return/customer and value obligations reconciled. |
| 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 source quantities/serials/descendants, reason and affected commitments; no deleted reservations or blanket whole-lot release from a partial decision. |
Status | select | yes | Active, PartiallyReleased, Released, Closed |
PlacedBy | reference | yes | → Users. Quality Inspector or actual operational person may immediately restrict unsafe/unverified stock; only required independent quality disposition releases it. |
PlacedAt | datetime | yes | Actual restriction time. |
ReleasedBy | reference | → Users. Independent Quality Inspector relative to producer/receiver and material disposition preparers; exact release decision required. |
| 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, AcceptDeviation |
BaseQuantity | decimal | yes | Positive actual population portion, bounded by unused eligible observed/source scope. |
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 Inspector excluding physical producer/receiver, proposed disposition preparer/material editors and criteria editors; a second eligible person is required when those identities overlap. | |
DecidedAt | datetime | Actual decision time. Absent until the actual action; mandatory for the corresponding confirmed/approved state. | |
AppliedAt | datetime | Actual guarded source-scope release/hold/return/rework application; not a duplicate stock/value event. |
| 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. | |
AllocationNumber | text | yes | Unique stable planned-order/revision/tranche generation identity. |
PlannedOrder | reference | yes | → PlannedOrders. Authorized supply proposal; cumulative claims across every run/revision use this same economic source. |
SourceRevision | number | yes | Exact approved proposal revision/hash, retained with quantity/product/site/kind. |
Status | select | yes | Reserved, Created, PartiallyCancelled, Cancelled, Released, Conflict |
BaseQuantity | decimal | yes | Positive immutable requested tranche quantity; all ReservationActive quantities plus gross CreatedQuantity less valid CancelledQuantity across source/revisions cannot exceed authorized PlannedOrders.BaseQuantity. |
CreatedQuantity | decimal | yes | Zero before target creation; one immutable tranche atomically creates exactly its entire BaseQuantity in one linked target, then CreatedQuantity = BaseQuantity permanently. Partial firming uses separate tranches, never partial creation inside a tranche. |
CancelledQuantity | decimal | yes | Only evidenced cancelled never-received/started/consumed generated quantity; bounded by CreatedQuantity and downstream remaining scope, no fulfilled cancellation. |
PurchaseOrderLine | reference | → PurchaseOrderLines. Exactly one generated target after Created, matching Buy kind/product/entity/site; independent spend approval still required. | |
WorkOrder | reference | → WorkOrders. Make target; independent release still required. | |
TransferLine | reference | → StockTransferLines. Transfer target; independent warehouse authority still required. | |
ReservedAt | datetime | yes | Actual atomic source claim time. |
CreatedAt | datetime | Actual target creation time; retry returns identical target and claim, no second document. | |
CancellationEvidence | longtext | Exact approved target revision and cancelled quantity, source demand/pegging reconciliation; uncertainty retains claim. | |
ContentHash | text | yes | Frozen source/target/quantity/product/site content; same key with changed content is Conflict. |
ReservationActive | boolean | yes | True while a full uncreated tranche reserves BaseQuantity; atomically false when the entire target and CreatedQuantity are committed. Conflict/uncertainty preserves the prior reservation/live commitment. Release only after authoritative evidence that no target exists; a created target uses bounded cancelled-unexecuted history instead. |
Create your ERP.AI account and get started with Proto.
We use essential cookies to run the site and optional cookies for features, analytics, and relevant content. See Cookie policy
We use cookies to enhance your experience, analyze site traffic, and serve relevant content. By clicking "Accept All," you agree to our use of cookies. You can customize your preferences at any time.
Learn more about how we use cookiesThese cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
These cookies enable additional features that enhance your experience, such as live chat, video playback, personalized content recommendations, and remembering user preferences.
These cookies help us understand how visitors interact with our site by collecting anonymous usage data. This allows us to measure performance, detect issues, and continuously improve the user experience.
These cookies allow us and advertising partners, including X, to deliver ads tailored to your interests. They track browsing habits across sites to provide relevant advertising and measure ad effectiveness.