Explore the records connecting trades, goods and financial results.
109 tables · 706 relationships
Trading ERP connects customer and supplier agreements with stock, documentary credits and company books through 109 tables. Each record has a defined place in the flow, with linked source evidence available for investigation and reconciliation.
Accounts, ContactPersons, PaymentTerms, PriceLists, PriceListEntries, Quotes, QuoteLines, SalesOrders, SalesOrderLines, SalesAllocations, CreditReviews. Customer identities, commercial terms, accepted offers, approved orders and their quantity and value allocations.
TradeDeals, TradeAllocations, TradeCostAllocations. Deals, bounded links between existing supply and demand, and attribution of actual trade expenses.
Suppliers, SupplierBankAccounts, Requisitions, RequisitionLines, PurchaseOrders, PurchaseOrderLines, GoodsReceipts, GoodsReceiptLines, ReceiptAcceptances, BillMatches. Supplier identities and bank details, approved commitments, actual arrivals, accepted receipt quantities and bill matching.
Products, UnitsOfMeasure, ProductUnits, Warehouses, Locations, Lots, Serials, InventoryPositions, StockLayers, StockEvents, StockMovements, InventoryReservations, StockTransfers, StockTransferLines, CountLocks, InventoryCounts, CountLines, PickTasks, Shipments, ShipmentLines, DeliveryConfirmations, Returns, ReturnLines, ReturnDispositions. Products and units, owned stock and cost layers, exact claims, handover and delivery, transfers, counts and physical returns.
FinancialInstitutions, DocumentaryCredits, CreditAmendments, CreditConditions, CreditPresentations, CreditDocuments, CreditDiscrepancies, CreditDrawings, CreditAllocations, CreditCharges, CreditCollateralMovements, CreditBankEvents, BankObligations, BankObligationAllocations. Bank parties, credit terms and amendments, presentation families, documentary evidence, drawings, fees, collateral and financing obligations.
BOMs, BOMLines, ProductionRoutings, RoutingOperations, WorkOrders, WorkOrderMaterials, WorkOrderOperations, ProductionEntries, ProductionCompletions, WorkOrderCostEntries. Versioned recipes and operations, released work, actual material and time, accepted terminal output and attributable work-in-progress costs.
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. Company books, costs, currencies, invoices, bills, actual bank and cash sources, allocations, corrections and financial close.
Users, TradingPolicies, MasterChanges, DocumentRevisions, ApprovalDecisions, AuthorityDelegations, IntegrationEvents, IntegrationDeliveries, MigrationBatches, MigrationItems. Current user scope, operating policies, immutable revisions, independent decisions, integration outcomes and migration identity.
Each company owns its commercial commitments, goods and financial effects. Products use canonical units with retained transaction conversions; lot and serial identity follows the relevant goods. Customer and supplier records are counterparties, while operational users are people or restricted service identities.
A trade links existing demand, purchasing, stock or production scope. Its allocations consume only the eligible remaining quantity and value across all active claims. Connecting a deal does not create another sales order, inventory reservation or shipment. Attributed expenses retain their original posting; a contribution report does not charge them again.
Actual customer handover or carrier dispatch issues stock and its carrying cost once under the selected operating policy. Invoice posting records receivables, revenue and tax separately. Delivery confirmation preserves cumulative acceptance after later returns, and a replacement uses its own approved commitment.
Documentary credits retain external bank identity and immutable terms. Issuer amendments, confirming-bank coverage and beneficiary-effective terms have distinct evidence and dates. A presentation records its applicable terms and underlying source allocations. Revised or re-presented packets share one drawing family, preserving existing claims until verified release.
Bank undertakings, actual supplier settlement, export advances and company reimbursement remain different events. Recognized bank obligations, receivables, payables and restricted cover retain their own current balances and currency effects. Proceeds actually held by a bank after lender collection remain a separate bank receivable until actual remittance or evidenced fee settlement; asset and liability balances are not automatically netted. A financing advance does not automatically clear customer debt, and applying existing collateral cannot also debit company cash.
Material remains inventory while staged, then actual issue moves it into exclusive work in progress. Unused returns, consumed material, accepted terminal output and cost relief retain exact source quantities. Intermediate operation progress cannot create finished stock or repeat a production variance.
Ends with: Map companies, users, customers, suppliers, financial institutions, products and units. Prepare approved accounts, currencies, prices, costs, warehouses, recipes and policies before linking operating history.
Ends with: Import accepted sales, remaining purchasing, trade allocations, stock layers, reservations, assembly work, handovers and returns. Retain original identities and performed quantities without receiving, producing or shipping them again.
Ends with: Reconcile one opening ledger with nonposting invoices, bills, cash, credits, documentary-credit utilization, accepted maturities, bank obligations and restricted cover. Preserve prior currency adjustments, partial settlement, fees and uncertain outcomes. Historical evidence cannot create a new draw or payment.
Ends with: Resolve typed references and compare source balances with their controls. Obtain required operational and financial review, retain external economic identifiers and active claims, then enable eligible new work after the agreed cutoff.
| 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 eleven declared roles; current entity/warehouse/action scope required. Services may prepare/execute guarded approved work but cannot sign human decisions. |
EntityScope | longtext | yes | Explicit Entities keys; current scope checked on every read/action/export. |
WarehouseScope | longtext | Explicit permitted Warehouses; absent does not mean global access. | |
ExpiresAt | datetime | Scope expiry. | |
ScopeChange | reference | → MasterChanges. Independent domain-reviewed grant of roles/entities/warehouse scope; Admin cannot self-grant business authority. Revocation may restrict immediately. |
| 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 | → TradingPolicies. 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, BankFunding, RestrictedCash, LCReconciliation, 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 finite named-user/role action rules for entity/warehouse, dates/currencies/limits, accepted prices/units, trade quantity/value claims, credit/LC documentary and monetary evidence, independent operational decisions and conservative unknown-state handling. No installed bank connector or universal legal rule. |
CountQuantityTolerance | decimal | yes | Nonnegative base-quantity absolute threshold by configured unit/product class; dimensionally incompatible quantities are never summed. |
CountPercentTolerance | decimal | yes | Nonnegative percentage; expected zero gives unavailable percentage and review. |
CountValueThreshold | decimal | yes | Nonnegative functional-value escalation threshold; unknown value is not zero. |
ShipmentTitleRule | select | yes | Handover. Actual verified customer handover/pickup or carrier dispatch is the sole baseline title/COGS event. Recorded trade terms/LC documents do not silently select another title model. |
PreparedBy | reference | yes | → Users. Admin prepares configuration; respective Sales Manager, Purchasing Manager, Warehouse Manager, Production Manager and Finance Manager decisions exclude material preparers/editors. |
OperationalDecision | reference | → ApprovalDecisions. Independent Warehouse Manager decision for operational rules. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
FinanceDecision | reference | → ApprovalDecisions. Independent Finance Manager decision for finance/cost/authority rules. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
ProductionDecision | reference | → ApprovalDecisions. Independent Production Manager for assembly/kitting/repacking rules. | |
CommercialDecision | reference | → ApprovalDecisions. Independent Sales Manager pricing/customer/trade rules before affected activation. | |
DocumentaryPolicy | longtext | Validated instrument-specific incorporated rules, bank-event verification, calendars/deadlines, party amendment/confirmation requirements, financial classification, finite exposure/fee/cover limits and escalation; no default universal examination period. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
ChangeNumber | text | yes | Unique change request. |
TargetTable | text | yes | Existing allowed master table. |
TargetKey | text | yes | Exact immutable record/version key. |
Status | select | yes | Draft, Submitted, Approved, Applied, Rejected, Cancelled |
BeforeHash | text | yes | Expected prior content or explicit create marker. |
ProposedContent | longtext | yes | Exact after-content and affected transactions. |
ProposedHash | text | yes | Frozen proposed content. |
PreparedBy | reference | yes | → Users. Actual person. |
SubmittedAt | datetime | Actual submission time. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
Decision | reference | → ApprovalDecisions. Independent affected owner: Finance Manager financial institutions/bank/cost/tax/currency/authority and documentary financial rules; Sales Manager customer/pricing/trade commercial; Purchasing Manager supplier commercial; Warehouse Manager stock/location; Production Manager technical recipe/routing. Multiple affected decisions bind one request. | |
AppliedAt | datetime | Guarded application; changes do not rewrite accepted or posted source snapshots. | |
OperationalDecision | reference | → ApprovalDecisions. Independent Warehouse Manager for stock/location/fulfillment; production technical changes need their separate Production Manager decision. | |
FinanceDecision | reference | → ApprovalDecisions. Required independent Finance Manager for costs/limits/beneficiary/tax/posting/price-floor changes. | |
CommercialDecision | reference | → ApprovalDecisions. Required independent Sales Manager for customer/price commercial changes. | |
ProductionDecision | reference | → ApprovalDecisions. Independent Production Manager for BOM/routing/execution changes. |
| 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, QuoteException, OrderAcceptance, CreditException, TradeAllocation, TradeCostAllocation, PurchaseApproval, InvoiceApproval, BillException, PaymentRelease, Refund, FinanceCorrection, StockRelease, TransferApproval, CountAdjustment, ReturnAuthorization, ReturnDisposition, ShipmentRelease, ProductionRelease, ProductionTimeAcceptance, ProductionCompletion, ProductionVariance, ProductionClose, ProductionCloseFinance, LCRequest, LCAmendment, LCPresentation, LCWaiver, LCClassification, LCFunding, LCReimbursement, LCCollateral, LCCharge, LCClosure, JournalApproval, RevaluationApproval, PeriodClose, PeriodReopen, MigrationActivation |
Status | select | yes | Pending, Approved, Rejected, Expired, Superseded |
Snapshot | reference | → DocumentRevisions. Required for revisioned transaction actions; master/policy request content hash otherwise retained in Scope. | |
Scope | longtext | yes | Exact source/action/revision, entity/warehouse, quantity/value/currency, party/bank and applicable term snapshot, expiry and excluded preparer/material editor/producer identities. Internal approval never states an external bank has issued, accepted, paid or waived anything. |
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 | Exact entity full opening GL/control versus nonposting stock/transit/WIP/open documents/cash/prepayments, LC term/event/drawing claims, funded bank asset/liability/cover/charges and prior FX; no historical bank request or financial replay. |
PreparedBy | reference | yes | → Users. Actual preparer. |
Decision | reference | → ApprovalDecisions. Independent Finance Manager activation plus Warehouse Manager stock and Production Manager WIP/output evidence. Required before Active; import does not replay operational or monetary effects. | |
AppliedAt | datetime | One successful baseline activation. |
| 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, DocumentaryCredits, BankFunding, Collateral, BankHeldProceeds, 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; legal party and monetary entitlement cannot be inferred merely from matching display names. |
LegalName | text | yes | Bill-to legal customer identity. |
Status | select | yes | Prospect, Active, OnHold, Closed |
BillingAddress | longtext | Verified billing identity. | |
DefaultTerms | reference | → PaymentTerms. Accepted transaction freezes a version. | |
PriceList | reference | → PriceLists. Default customer price list; explicit precedence. | |
CreditCurrency | reference | → Currencies. Currency of credit limit. | |
CreditLimit | decimal | Finite nonnegative approved limit in CreditCurrency, required before credit trading; unknown is not unlimited. Separately attributed prepayments cannot reduce more than one exposure. | |
TaxEvidence | longtext | Exemption/resale documentation and review scope; not automatic compliance proof. | |
Activation | reference | → MasterChanges. Independent Sales Manager commercial and Finance Manager credit/tax approval as applicable. | |
RelatedEntity | reference | → Entities. Explicit intercompany trading counterparty; still separate legal documents, no automatic elimination. | |
Owner | reference | yes | → Users. Sales Representative responsible for assigned customer relationships, not authority to transfer cash across counterparties. |
| 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 |
| 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 | Stock, ManufacturedKit, Repacked |
Activation | reference | → MasterChanges. Independent Warehouse Manager stock/unit identity, Sales Manager commercial and Production Manager manufactured-specification approval, with separate Finance Manager financial setup as affected. | |
SerialControlled | boolean | yes | Each serialized position/effect identifies exactly one base unit; all accepted unit/pack conversions preserve it. |
| 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 or Purchasing Manager reviewed technical/commercial cost basis; no rewrite of released WIP or earlier output. |
| 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 | Actual customer acceptance bound to complete quote revision, quantity/net/tax/currency/terms/recipient; never an internal status substitute. | |
Decision | reference | → ApprovalDecisions. Required commercial price/margin exception decision by independent Sales Manager; routine within-policy quote sending is Sales Representative preparation, not the mandatory order gate. |
| 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 actual delivery/handover location, entitled recipient and contact evidence; carrier and customer handover requirements follow the selected mode. |
TitleRule | select | yes | Handover. Actual verified customer handover/pickup or carrier dispatch transfers stock/COGS once. Unsupported commercial title terms require reviewed implementation scope before activation. |
NetTotal | decimal | yes | Sum accepted SalesOrderLines.NetAmount. |
TaxTotal | decimal | yes | Sum line tax once. |
CreditReview | reference | yes | → CreditReviews. Current entity/customer exposure snapshot and valid exception if needed. |
AcceptedAt | datetime | Independent Sales Manager approval time bound to exact customer acceptance, prices, address, title rule and quantities. | |
ShipmentMode | select | yes | Carrier, CustomerHandover |
ReplacementFor | reference | → Returns. Separately accepted replacement demand for a reviewed original return; never reopens already handed-over old order quantity automatically. |
| 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, Production Operator or other authorized operational requester. |
Decision | reference | → ApprovalDecisions. Independent Purchasing Manager within configured authority, Finance Manager above limit; conversion consumes only approved remaining scope. |
| 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 order/material/transfer demand; current independently approved order required for Hard/Picked/TitleIssue. Trade matching alone creates no physical stock reservation. | |
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 unexecuted claim expiry only under approved policy after cash/LC/uncertainty and source review. Actual picked/transit or externally committed scope never auto-releases. | |
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 | → TradingPolicies. 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; final approver cannot approve its own physical count. | |
StockEvent | reference | → StockEvents. One posted correction. | |
Lot | reference | → Lots. Exact same entity/product lot, required when lot-controlled; display values derive from this identity. | |
Serial | reference | → Serials. Exact individual identity; required for serial-controlled product. Movement/scope is exactly one serial/base unit per row. |
| 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. |
| 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 independently approved customer order and purchase context; no combined packet loses ownership. |
Warehouse | reference | yes | → Warehouses. Actual dispatch site. |
Mode | select | yes | Carrier, CustomerHandover |
Status | select | yes | Planned, Picking, Ready, HandedOver, PartiallyDelivered, Delivered, Exception, Closed, Cancelled |
TitleRule | select | yes | Handover. Actual physical customer handover or carrier dispatch issues stock and cost once; documentary acceptance, labels and request acknowledgment do not. |
CarrierReference | text | Configured external handoff reference; no carrier booking claim. | |
HandedOverAt | datetime | Actual verified customer handover or carrier dispatch instant; a ready state, label or booking acknowledgment is insufficient. | |
HandoverEvidence | longtext | Actual carrier/customer, timestamp, entitled recipient/location and exact physical quantity/lot/serial proof; no store/channel, optimizer or installed carrier claim. | |
ClosedAt | datetime | All line quantities delivered/returned/lost/resolved with remaining ownership reconciled. | |
Decision | reference | → ApprovalDecisions. Current exact independent action/scope/revision decision; required before corresponding approved effect. | |
ReleasedBy | reference | → Users. Independent Warehouse Manager readiness approval, excluding packet preparer/material editor. | |
ReleasedAt | datetime | Actual approval before execution; new material scope invalidates unexecuted release. |
| Field | Type | Required | Details |
|---|---|---|---|
Shipment | reference | yes | → Shipments. One order. |
OrderLine | reference | yes | → SalesOrderLines. Same order only. |
Reservation | reference | yes | → InventoryReservations. Exact picked claim and layer identity. |
BaseQuantity | decimal | yes | Actual assigned/shipped quantity, bounded by claim and accepted unfulfilled source. |
DispatchedQuantity | decimal | yes | Cumulative actual title-handover quantity across the supported mode; history stays intact through later returns. |
TitleTransferredQuantity | decimal | yes | Exact once-only TitleIssue quantity at actual handover/dispatch; bounded by approved remaining order and hard stock claim. |
DeliveredQuantity | decimal | yes | Cumulative accepted customer-delivery history, net only of approved factual evidence corrections. Physical returns never decrement this history or reopen old fulfillment eligibility. |
ReturnedQuantity | decimal | yes | Actual reconciled returned quantity, separate from original dispatch history. |
CarryingValueIssued | decimal | yes | Exact layer carrying value consumed by title transfer; no second cost at invoice/POD. |
OriginalDispatchEvent | reference | → StockEvents. TitleIssue at actual handover/dispatch; later carrier POD never issues stock/COGS again. |
| Field | Type | Required | Details |
|---|---|---|---|
ShipmentLine | reference | yes | → ShipmentLines. Exact title-handed-over source. Actual customer handover/pickup may create this same acceptance evidence atomically, never a second title issue. |
AcceptedQuantity | decimal | yes | Nonnegative actual accepted quantity. |
RefusedQuantity | decimal | yes | Nonnegative physically refused quantity. |
FailedQuantity | decimal | yes | Nonnegative undelivered quantity; not lost or returned automatically. |
DamagedQuantity | decimal | yes | Disjoint damaged scope retained pending disposition; not also included accepted/refused/failed. |
ScopeQuantity | decimal | yes | Disjoint accepted/refused/failed/damaged outcomes bounded by original actual handed-over units excluding the union of prior accepted, physically returned, approved lost or finally resolved units. Failed visits may retry remaining goods; restock never reopens original POD eligibility. |
ReturnLine | reference | → ReturnLines. Refused/damaged actual return custody if applicable. | |
CorrectionOf | reference | → DeliveryConfirmations. Exact prior result; approvals and downstream billing/title effects reconciled before correction. | |
Entity | reference | yes | → Entities. Owning legal entity; shipment, actual customer, stock ownership and financial sources must agree. |
OperationKey | text | yes | Stable economic action identity; identical canonical content returns same effect, changed content enters review. |
Event | reference | → IntegrationEvents. Authenticated import or reviewed manual source evidence. | |
ConfirmationNumber | text | yes | Stable actual confirmation/attempt economic identity. |
Status | select | yes | Prepared, Confirmed, Disputed, Corrected |
OccurredAt | datetime | yes | Actual customer result time, not scheduled pickup/arrival. |
ConfirmedBy | reference | yes | → Users. Warehouse Operator with actual source/recipient evidence; disputed identity/outcome requires Warehouse Manager review. |
RecipientEvidence | longtext | yes | Proof of actual intended customer or authorized recipient, location, event time and scoped quantities; never infer delivery from a bank document or approval. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
BOMCode | text | yes | Unique product/version. |
OutputProduct | reference | yes | → Products. One primary output SKU; co-products are separately scoped, not implied. |
OutputBaseQuantity | decimal | yes | Strictly positive recipe output basis. |
Version | number | yes | Immutable technical revision. |
StartsAt | datetime | yes | Inclusive. |
EndsAt | datetime | Exclusive. | |
Status | select | yes | Draft, Active, Superseded |
Activation | reference | → MasterChanges. Independent Production Manager technical recipe activation; Finance Manager separately approves standard/rate/value changes. |
| 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 instructions; separate Finance Manager cost-rate approval. |
| Field | Type | Required | Details |
|---|---|---|---|
Routing | reference | yes | → ProductionRoutings. Parent version. |
Sequence | number | yes | Positive unique execution order. |
Name | text | yes | Assembly/repacking operation. |
Instructions | longtext | yes | Concrete safety/inspection/acceptance instructions; no formal QMS certification claim. |
TerminalOperation | boolean | yes | Exactly one final output operation; intermediate throughput never becomes extra finished units. |
LabourRatePerHour | decimal | yes | Known nonnegative entity-functional absorption rate, independently finance-approved. |
OverheadBasis | select | yes | None, LabourHour, OutputUnit |
OverheadRate | decimal | yes | Known nonnegative rate in declared basis; no embedded amount added again. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
WorkOrderNumber | text | yes | Unique production order. |
BOM | reference | yes | → BOMs. Frozen released recipe version. |
Routing | reference | yes | → ProductionRoutings. Frozen technical version. |
OutputProduct | reference | yes | → Products. One primary output. |
OutputStandard | reference | yes | → StandardCosts. Frozen entity-functional output standard at release. |
Warehouse | reference | yes | → Warehouses. Actual production site. |
OrderLine | reference | → SalesOrderLines. Optional make-for-order allocation, one demand not a second sales line. | |
PlannedQuantity | decimal | yes | Positive output base quantity. |
Status | select | yes | Draft, PendingApproval, Released, InProgress, PartiallyCompleted, Completed, PendingClose, Closed, Cancelled |
PlannedStart | datetime | yes | Feasible manually planned time. |
PlannedEnd | datetime | yes | Planned end; no optimizer promise. |
Manager | reference | yes | → Users. Production Manager; independent of the relevant request preparer/material editors. |
ReleasedAt | datetime | Actual independent Production Manager release after known material/cost/technical/condition and feasible manual schedule checks; no MRP or APS assumption. | |
ClosedAt | datetime | All input/output/scrap/WIP/cost obligations reconciled and necessary independent finance variance decision. | |
CompletedQuantity | decimal | yes | Net posted accepted terminal ProductionCompletions only; no intermediate/rework good-count sum. |
RemainingWIP | decimal | yes | Sum signed posted WorkOrderCostEntries, reconciled independently from unissued inventory. |
CloseDecision | reference | → ApprovalDecisions. Mandatory independent Production Manager quantity/obligation close approval, excluding closure preparer/material editors. | |
CloseFinanceDecision | reference | → ApprovalDecisions. Additional independent Finance Manager approval for remaining WIP/variance/financial exception, not substitute for quantity close. |
| Field | Type | Required | Details |
|---|---|---|---|
WorkOrder | reference | yes | → WorkOrders. Released job. |
BOMLine | reference | yes | → BOMLines. Frozen technical source. |
Product | reference | yes | → Products. Input SKU. |
RequiredBaseQuantity | decimal | yes | Planned output / BOM output basis × component input × explicit scrap factor once. |
IssuedQuantity | decimal | yes | Gross actual material issue into exclusive work-order WIP custody; source inventory quantity/value removed once. Later returns and consumption remain separate derived counters from exact issue-source WorkOrderCostEntries. |
ReturnedQuantity | decimal | yes | Unused physical WIP material actually returned from remaining issue-source quantity/cost into a new inventory layer; never debit a depleted original inventory position or return consumed material. |
ConsumedQuantity | decimal | yes | Actual component base quantity used/scrapped in process; sum exact issue-source MaterialConsumedQuantity, not a second stock issue. Issued minus returned minus consumed is physically unused WIP material. |
Reservation | reference | → InventoryReservations. Exact material claim; multiple split claims linked by this source. |
| Field | Type | Required | Details |
|---|---|---|---|
WorkOrder | reference | yes | → WorkOrders. Released job. |
RoutingOperation | reference | yes | → RoutingOperations. Frozen sequence/rates/bases. |
AssignedTo | reference | yes | → Users. Assigned Production Operator; Production Manager independently confirms actual throughput/time. |
Status | select | yes | Ready, InProgress, Complete, Exception, Cancelled |
PlannedStart | datetime | yes | Assigned window. |
PlannedEnd | datetime | yes | End. |
ActualStart | datetime | Actual work start. | |
ActualEnd | datetime | Actual work end, positive interval when labour hours charged. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
EntryNumber | text | yes | Stable operation/time/output identity. |
Operation | reference | yes | → WorkOrderOperations. Released work operation. |
RecordedBy | reference | yes | → Users. Actual Production Operator recorder; ProducedBy identifies actual producer, which may differ. |
Status | select | yes | Draft, Submitted, Accepted, Rejected, Corrected |
StartedAt | datetime | yes | Actual time. |
EndedAt | datetime | Actual time; no overlap/double use of same person's time interval. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
GoodQuantity | decimal | yes | Nonnegative operation throughput in output base units, reconciled to unused exact input scope; held/rejected and repeated rework passes are not new good terminal units. |
ScrapQuantity | decimal | yes | Nonnegative actual rejected output-equivalent evidence; input scrap quantities separately traced. |
LabourHours | decimal | Accepted actual person-hours with overlap checks across every live entry for the same person; no charge for unclosed/invalid time and no payroll effect. Null until actual interval/basis known; finite nonnegative value required before acceptance/cost posting, with explicit known zero allowed. | |
AcceptedBy | reference | → Users. Independent Production Manager excluding producer, recorder and material editors; actual condition evidence required. | |
CorrectionOf | reference | → ProductionEntries. Prior entry and consumed costs/completions reconciled first. | |
ProducedBy | reference | yes | → Users. Actual Production Operator producing the units; recorder can differ and neither may approve the same source. |
ScopeKey | text | yes | Stable batch/unit/operation-pass identity; rework has linked prior pass and exact unit lineage, never a second finished unit. |
MachineHours | decimal | Nonnegative actual accepted occupied machine hours; distinct from elapsed person-hours and setup overlap. Null until actual interval/basis known; finite nonnegative value required before acceptance/cost posting, with explicit known zero allowed. | |
AcceptedAt | datetime | Actual independent technical/time confirmation. | |
InputAllocations | longtext | yes | Validated exact released first-operation batch/material scope or prior accepted operation-entry quantities/unit IDs. Inputs = GoodQuantity + ScrapQuantity + HeldQuantity + UnfinishedQuantity; rework reuses original unit identity and cannot create extra terminal output. No implicit MRP or QMS record. |
HeldQuantity | decimal | yes | Nonnegative inspected/awaiting-decision operation scope, excluded from accepted transferable/completable good units. |
UnfinishedQuantity | decimal | yes | Nonnegative input scope still physically unfinished after this entry; retained for later work, never transferred/completed as good. Input allocation = GoodQuantity + ScrapQuantity + HeldQuantity + UnfinishedQuantity, all disjoint. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
CompletionNumber | text | yes | Unique terminal completion. |
WorkOrder | reference | yes | → WorkOrders. Released job. |
TerminalEntry | reference | yes | → ProductionEntries. Unused accepted terminal good quantity only. |
Status | select | yes | Prepared, PendingApproval, Approved, Posted, Reversed |
OutputQuantity | decimal | yes | Positive base output, bounded by remaining accepted terminal scope and authorized work order. |
LotNumber | text | Required output lot. | |
Location | reference | yes | → Locations. Actual received finished-stock location. |
AllocatedActualWIP | decimal | yes | Unused approved material/labour/overhead source carrying attributed to actual consumed material and accepted time; active cost/quantity claims reduce availability. Unknown cost blocks posting. |
StandardOutputValue | decimal | yes | OutputQuantity × frozen output standard, rounded once. |
Variance | decimal | yes | AllocatedActualWIP − StandardOutputValue; positive adverse expense, negative favorable variance, once. |
CompletedAt | datetime | Actual independently accepted terminal completion time, required before approved/posted scope; not draft creation. | |
ConfirmedBy | reference | → Users. Independent Production Manager excluding actual producer, recorder, completion preparer/material editors; confirms exact terminal good scope and actual acceptable condition. | |
FinanceDecision | reference | → ApprovalDecisions. Independent Finance Manager approves nonzero variance/cost exception before posting; quantity acceptance alone does not authorize value. | |
StockEvent | reference | → StockEvents. Dr finished inventory standard / Cr WIP allocated actual / signed production variance. | |
Lot | reference | → Lots. Required exact output lot when controlled. | |
Serial | reference | → Serials. Required individual identity when serialized; quantity exactly one per row. | |
ConditionEvidence | longtext | yes | Actual independently accepted terminal good condition and any held/rework/scrap scope; no automatic full QMS/inspection-suite claim. |
| 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 for supplier return. Before actual customer handover, cancellation restores existing owned staging/custody without sale/COGS reversal; no delivery-title branch. |
OriginalCommercialValue | decimal | yes | Scoped original net/tax settlement basis kept separate from carrying removal. |
LotNumber | text | Trace original identity; changed identity requires explicit reviewed disposition. | |
PhysicalAt | datetime | Actual return receipt or supplier handover. | |
StockEvent | reference | → StockEvents. Actual custody/owned-stock effect once. | |
ReceiptAcceptance | reference | → ReceiptAcceptances. Required for supplier return of accepted owned goods; binds original posted tranche/descendants, rather than gross arrival. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
DispositionNumber | text | yes | Unique return-scope decision. |
ReturnLine | reference | yes | → ReturnLines. Actual received/authorized scope. |
Kind | select | yes | Restock, Scrap, ReturnToCustomer, ReturnToSupplier, Quarantine |
Status | select | yes | Prepared, PendingApproval, Approved, Posted, Reversed |
BaseQuantity | decimal | yes | Positive bounded actual quantity not already disposed. |
CarryingValue | decimal | yes | Original title-issue cost for actual customer restock; current descendant carrying for supplier return. Before actual customer handover, cancellation restores existing owned staging/custody without a COGS reversal; no delivery-title customer path. |
Destination | reference | → Locations. Actual held/restocked destination, same entity/warehouse scope; new assembly/rework requires separately released production scope. | |
PreparedBy | reference | yes | → Users. Warehouse Operator observations. |
DecidedAt | datetime | Independent WM disposition; FM additionally authorizes loss/value exception. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
StockEvent | reference | → StockEvents. No physical/economic effect from status alone. |
| 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. |
CreditDrawing | reference | → CreditDrawings. Optional documentary context; actual LC source allocations are exclusive and do not grant invoice approval or settle AR by themselves. |
| 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 source-controlled bank/cash-on-hand/cash-in-transit/restricted-cash account according to Kind. |
Status | select | yes | Draft, Active, Blocked, Closed |
ProtectedDetails | longtext | yes | Accountant/Finance Manager only under current purpose; operator/sales exports excluded. |
BalanceQuantity | decimal | yes | Posted own-currency balance, reconciled to actual bank statement or reviewed physical cash/transfer evidence; opening/collection/deposit is not duplicated. |
CarryingValue | decimal | yes | Functional carrying balance including delta bank revaluation. |
UnrealizedFX | decimal | yes | Signed prior bank FX to reclassify on scoped disposal. |
ReservedQuantity | decimal | yes | Active released/unsettled instructions/refunds; prevent duplicate spend where finite availability policy applies. |
Version | number | yes | Atomic balance/reservation version. |
Activation | reference | → MasterChanges. Independent Finance Manager. Absent until the real action; mandatory before the corresponding active/approved/posted state. | |
Kind | select | yes | Bank, CashOnHand, CashInTransit, RestrictedCash. Restricted balances remain owned monetary assets; availability excludes source-preserving collateral claims and no automatic expense/net liability offset. |
Institution | reference | → FinancialInstitutions. Actual company bank/custodian when applicable; external LC bank identity alone does not create an owned account. |
| 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. Actual same-entity receipt account. Currency may differ from gross receipt only with exact CollectionComponents and reviewed conversion; actual bank receipt must be evidenced, never manufactured from gross proceeds. |
Status | select | yes | Prepared, Posted, PartiallyApplied, Applied, Returned, Reversed |
ReceivedAt | datetime | yes | Actual verified bank/cash receipt time; bank advice, undertaking, negotiation label or transport acknowledgment is not money. |
Period | reference | yes | → AccountingPeriods. Eligible posting period. |
Amount | decimal | yes | Positive gross customer collection in receipt Currency. Ordinary cash equals actual bank amount; approved outright export proceeds may be gross of exact documented withheld charges. ActualBankAmount and CollectionComponents preserve the net cash separately. Intent, undertaking and recourse financing are not collections. |
UnappliedAmount | decimal | yes | Gross Amount less live posted receipt-currency applications and only directly cash-funded refunds/approved actual receipt returns. Credit-funded refunds, bank funding and later LC reimbursement do not also reduce original cash. Never negative. |
UnappliedCarrying | decimal | yes | Functional remaining unapplied liability carrying, including its own revaluation. |
UnrealizedFX | decimal | yes | Gain-positive prior FX on unapplied liability, released/reclassified proportionally. |
ReservedAmount | decimal | yes | Active application/refund claims in receipt currency; never invoice currency. |
StatementLine | reference | → BankStatementLines. Actual settlement evidence or reviewed manual cash proof in Event. | |
Journal | reference | → JournalEntries. Ordinary Dr actual Bank/Cash / Cr UnappliedCustomer once. Approved outright collection may Dr actual net Bank plus exact recognized charge / Cr gross UnappliedCustomer with explicit FX components. Later CashApplications consumes the gross liability against AR without bank or fees again. Recourse advance uses BankObligations, never this receipt path. | |
Baseline | longtext | yes | Opening receipt amount/applied/unapplied/carrying/FX and original source IDs, nonposting. |
SourceKind | select | yes | Bank, Cash. Ordinary actual customer collections only; export recourse advance uses BankObligations funding, not unapplied customer money. |
AvailabilityState | select | yes | Clear, Unidentified, Held, ReviewRequired |
HeldAmount | decimal | yes | Nonnegative available receipt-currency portion held outside active reservations, bounded by UnappliedAmount minus ReservedAmount. Unresolved counterparty/funding/outcome can block execution while actual evidence remains. |
CreditBankEvent | reference | → CreditBankEvents. Verified actual outright export collection evidence; no receipt for a recourse advance or direct lender collection that uses BankObligationAllocations. | |
CollectionDecision | reference | → ApprovalDecisions. Independent Finance Manager classification before an LC gross/net collection effect; actual net funds evidence remains visible while classification is unresolved. | |
ActualBankAmount | decimal | Actual received cash in BankAccount currency; required before posting. Ordinary receipt equals Amount in the same currency; reviewed outright collection may have a separately evidenced deducted fee. | |
ActualBankValue | decimal | Actual net bank functional value with rate evidence; never use gross customer receipt amount as cash when a fee was withheld. | |
CollectionComponents | longtext | yes | Ordinary receipts state no deduction. For approved outright collection, exact customer gross amount/currency, actual net bank amount/currency, CreditCharges economic keys/amounts and rate/FX evidence reconcile one balanced journal. Each deducted charge is recognized only here or its exact linked canonical journal, never twice; fee withholding must be authorized in the customer settlement basis. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
ApplicationNumber | text | yes | Unique application. |
Receipt | reference | yes | → CashReceipts. Confirmed identified same-entity actual-customer receipt; exact authorized purpose and source entitlement must permit this invoice. LC/direct-lender and ordinary claims share one remaining balance. |
Invoice | reference | yes | → Invoices. Same entity and actual customer debit; current approved receipt entitlement/purpose and exclusive source claims required, including LC/direct-lender claims. |
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 | → BankAccounts. Required actual same-entity source for CompanyCash; null for LCBankFunding, which creates the explicit bank obligation. | |
Beneficiary | reference | yes | → SupplierBankAccounts. Approved exact beneficiary version. |
BeneficiaryHash | text | yes | Must equal released destination; changes invalidate unsent authorization. |
Currency | reference | yes | → Currencies. Bank/payment currency. |
Amount | decimal | yes | Positive proposed payment-currency total allocated or explicitly supplier prepayment. |
Status | select | yes | Reserved, Released, Submitted, Accepted, Uncertain, Settled, Rejected, Returned, Cancelled |
Instruction | reference | → IntegrationDeliveries. Intent/attempt, not settlement proof. | |
SettlementEvent | reference | → IntegrationEvents. Actual authenticated/manual-confirmed bank outcome. | |
SettledAt | datetime | Actual verified supplier settlement time, whether company cash or bank-funded; an undertaking, request or approval does not set it. | |
BankCarryingReleased | decimal | CompanyCash current functional carrying released; null for LCBankFunding with no company cash movement. | |
Journal | reference | → JournalEntries. CompanyCash clears current AP/prepayment versus bank once. LCBankFunding clears actual eligible AP or creates supplier prepayment versus BankObligations, with separate FX/charge scope, no fictitious company cash. Linked funding records share this economic journal rather than duplicate it. | |
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. |
FundingKind | select | yes | CompanyCash, LCBankFunding. Only actual supplier economic settlement, not a deferred undertaking alone, can create the latter posted settlement. |
BankObligation | reference | → BankObligations. Required actual recognized LC import funding source; same entity/party/drawing. Its obligation currency and payment currency may differ only with exact funded components, rates and source claims; no company cash is also posted. | |
CreditBankEvent | reference | → CreditBankEvents. Required verified ActualSupplierSettlement for LCBankFunding; internal release or Undertaking is insufficient. |
| 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 amount in payment currency actually settling supplier scope, funded by CompanyCash or LCBankFunding; not a second company cash movement for the bank-funded path. |
BillCashAmount | decimal | yes | Bill-currency actual supplier settlement portion, whether CompanyCash or LCBankFunding; a bank undertaking alone is not supplier settlement. Zero only for explicit supplier prepayment. |
DiscountAmount | decimal | yes | Approved bill-currency discount, not cash consumed. |
PaymentRate | reference | yes | → ExchangeRates. Exact settlement conversion. |
BillRate | reference | yes | → ExchangeRates. Exact bill settlement basis. |
FunctionalSettlement | decimal | yes | Actual functional value of supplier payment, with separately retained bank-funding/current-carrying basis and charge/FX components; never a fictitious company cash debit. |
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. | |
CreditAllocation | reference | → CreditAllocations. Actual import documentary source claim where funded by an LC bank; current bill outstanding and ordinary/LC claims checked together. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
CreditApplicationNumber | text | yes | Unique economic use. |
Side | select | yes | Customer, Supplier |
CreditInvoice | reference | → Invoices. Customer CreditNote; mutually exclusive with CreditBill. | |
CreditBill | reference | → Bills. Supplier CreditNote. | |
DebitInvoice | reference | → Invoices. Same actual customer/entity debit; no cross-party credit transfer by matching a deal label. | |
DebitBill | reference | → Bills. Same supplier/entity debit target. | |
CreditAmount | decimal | yes | Positive credit-currency use; active Reserved amounts subtract availability. |
DebitAmount | decimal | yes | Positive debit-currency settlement equivalent. |
RateEvidence | longtext | yes | Frozen pair/date/type/multipliers and carrying/FX allocations; same-currency identity explicit. |
Status | select | yes | Reserved, Posted, Released, Reversed |
CreatedAt | datetime | yes | Atomic claim time. |
PostedAt | datetime | Actual zero-cash clearing. | |
Journal | reference | → JournalEntries. Clear credit-control and debit-control current carrying, remaining difference FX; reclassify prior unrealized zero-net. | |
ReversalOf | reference | → CreditApplications. Exact prior claim. | |
SupplierPrepayment | reference | → Payments. Alternative same-supplier prepayment from actually settled CompanyCash or LCBankFunding source; XOR CreditBill. Later AP use creates no new cash or bank obligation. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; every linked monetary/owned-stock source must agree. |
Revision | number | yes | Positive monotonic working revision; submitted content is immutable. |
Snapshot | reference | → DocumentRevisions. Exact reviewed content and material source snapshots. | |
CreatedBy | reference | yes | → Users. Actual preparer person; material editors retained in snapshot. |
CreatedAt | datetime | yes | Offset-aware creation timestamp. |
OperationKey | text | yes | Unique economic effect key; same key/hash returns same result, different content is ReviewRequired. |
Event | reference | → IntegrationEvents. Authenticated inbound event or reviewed manual evidence. | |
Decision | reference | → ApprovalDecisions. Current valid independent decision for this revision, amount, entity and action. | |
RefundNumber | text | yes | Unique refund/claim. |
Direction | select | yes | ToCustomer, FromSupplier |
CreditInvoice | reference | → Invoices. One customer-credit funding source. | |
CashReceipt | reference | → CashReceipts. Alternative unapplied-customer-cash funding source; XOR CreditInvoice, never both. | |
CreditBill | reference | → Bills. Supplier-credit collection source for FromSupplier. | |
Currency | reference | yes | → Currencies. Actual bank/cash settlement currency; SourceAmount stays in original credit/receipt/prepayment currency. |
Amount | decimal | yes | Positive cash amount. |
SourceAmount | decimal | yes | Amount consumed in source document/receipt currency, separate from bank currency. |
SourceCarrying | decimal | yes | Current functional funding value released. |
RateEvidence | longtext | yes | Exact equivalent amount, bank carrying and prior FX reclassification basis. |
BankAccount | reference | yes | → BankAccounts. Required actual same-entity cash account with protected recipient/funding route. |
Status | select | yes | Draft, PendingApproval, Reserved, Released, Submitted, Uncertain, Settled, Rejected, Returned, Cancelled, Held |
Instruction | reference | → IntegrationDeliveries. Transport intent only. | |
SettlementEvent | reference | → IntegrationEvents. Authoritative actual cash outcome. | |
SettledAt | datetime | Actual posting time. | |
Journal | reference | → JournalEntries. Funding control against actual cash/current carrying once plus reviewed FX; credit-funded refund preserves original receipt and cash applications. | |
SupplierPrepayment | reference | → Payments. Alternative FromSupplier funding collection; XOR CreditBill. | |
Method | select | yes | Bank, Cash. Actual company cash or supplier refund outcome only; an LC obligation/collateral release is not an ordinary customer refund. |
| 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, LCResolution |
Status | select | yes | Draft, PendingApproval, Approved, Posted, Rejected |
SourceTable | text | yes | Exact existing source type. |
SourceKey | text | yes | Original immutable source/effect identity. |
Scope | longtext | yes | Exact original currency/value/allocations/FX/tax/cost and actor/source lineage; restores each claim once. LCResolution traces bank obligation, supplier/customer settlement, collateral and charges separately, never fabricates company cash or repeats original settlement. |
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. | |
CreditBankEvent | reference | → CreditBankEvents. Original actual bank evidence for LC-related correction, held conflict or classified actual debit. | |
BankObligation | reference | → BankObligations. Exact recognized funding source where applicable; prior underlying AP/AR and later reimbursement effects must reconcile separately. |
| 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, BankObligations. Restricted cash uses its actual owned BankAccounts source; do not revalue collateral detail and the same bank total twice. Undrawn contingent LC face amounts are exposure, not automatic monetary ledger balances. |
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, CashTransfer, LCFunding, LCCollateral, Tax, FX, Reclassification, Manual, Opening, Correction |
Status | select | yes | Draft, PendingApproval, Approved, Posted, Reversed |
PostingDate | date | yes | Date in eligible Period. |
Period | reference | yes | → AccountingPeriods. Same entity. |
SourceTable | text | yes | Existing typed source or explicitly authorized Manual/Opening evidence. |
SourceKey | text | yes | Unique economic source/effect; a second transport event cannot repost it. |
PostedAt | datetime | Actual local posting. | |
ReversalOf | reference | → JournalEntries. Exact prior journal/line source; no destructive editing. | |
CashTransferFrom | reference | → BankAccounts. Required for CashTransfer; source Bank/CashOnHand/CashInTransit under actual custody evidence, same entity and different from destination. | |
CashTransferTo | reference | → BankAccounts. Actual same-entity destination including restricted cash; no customer receipt/revenue or supplier payment. LC placement/application/release additionally binds CreditCollateralMovements. | |
CashTransferSourceAmount | decimal | Positive actual source-currency amount, exclusively reserved against source cash availability until confirmed movement. | |
CashTransferDestinationAmount | decimal | Positive actual destination-currency amount; same-currency identity explicit, foreign conversion separately evidenced. | |
CashTransferSourceCarrying | decimal | Exact positive current functional carrying removed from source with prior FX allocation. | |
CashTransferDestinationValue | decimal | Actual positive functional value received at destination; difference is reviewed FX/fee, never invented rounding or revenue. | |
CashTransferEvidence | longtext | Actual custody/bank confirmation, finite source claim and recipient/amount/FX/fee proof. Cash handed to transit is not bank receipt; second actual deposit consumes only remaining transit scope. | |
CashTransferStatement | reference | → BankStatementLines. Required actual bank evidence for bank leg; cash-only custody needs reviewed manual proof. | |
PriorCashTransfer | reference | → JournalEntries. Exact earlier CashTransfer transit leg; later deposit/reversal cannot consume more than remaining in-transit source. |
| 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 | → Users. Actual independent Warehouse Operator, not PO buyer/commercial approver; null until confirmation and mandatory before Confirmed/Posted with required condition/cost evidence. | |
ConfirmedAt | datetime | Actual physical disposition confirmation. | |
Evidence | longtext | yes | 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. |
| 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; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
DealNumber | text | yes | Unique entity trade/deal identity. |
Name | text | yes | Useful buyer/seller scope description. |
Owner | reference | yes | → Users. Sales Representative accountable for commercial coordination. |
Status | select | yes | Draft, PendingReview, Approved, Active, PendingClose, Closed, Cancelled |
PrimaryCustomer | reference | → Accounts. Descriptive primary same-entity customer; each actual order/allocation retains its own counterparty and authority. | |
ReportingCurrency | reference | yes | → Currencies. Disclosed comparison basis; underlying transactions retain original and functional currencies. |
ExpectedCloseAt | datetime | yes | Planning target, never actual settlement evidence. |
ClosedAt | datetime | Actual quantity/value/LC/cost reconciliation and independent commercial/financial closure. | |
Scope | longtext | yes | Validated actual counterparties, products, source revisions, expected versus committed quantities/net and exclusions. Sales Manager approves commercial scope; financial/cost/LC exceptions require Finance Manager separately. |
FinanceDecision | reference | → ApprovalDecisions. Independent Finance Manager for monetary/cost/exposure exceptions or unresolved financial closure. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
AllocationNumber | text | yes | Unique source/demand/deal allocation identity. |
Deal | reference | yes | → TradeDeals. Same entity current approved commercial scope. |
OrderLine | reference | yes | → SalesOrderLines. One independently approved demand line and its accepted product/base-unit/net/tax basis. |
SupplyKind | select | yes | Unassigned, PurchaseOrder, WorkOrder, StockLayer |
PurchaseOrderLine | reference | → PurchaseOrderLines. Exactly this source for PurchaseOrder kind; approved remaining supply and same output SKU. | |
WorkOrder | reference | → WorkOrders. Exactly this source for WorkOrder kind; actual released output supply, not input components or another demand. | |
StockLayer | reference | → StockLayers. Exactly this source for StockLayer kind; remaining eligible owned source and provenance family. | |
Product | reference | yes | → Products. Same demand/supply SKU; different components are not equivalent finished goods. |
BaseQuantity | decimal | yes | Positive assigned order-base quantity; same physical unit as eligible source. Sum live assignments and retained executed claims cannot exceed accepted uncancelled demand or corresponding source supply. |
ReleasedQuantity | decimal | yes | Nonnegative explicitly released unexecuted portion; never erases fulfilled, consumed or handed-over assignment history. |
ExecutedQuantity | decimal | yes | Nonnegative actual assigned fulfilled demand scope, bounded by BaseQuantity minus ReleasedQuantity; links retained in ExecutionEvidence. |
DemandNetAmount | decimal | yes | Accepted order-currency net attributed to this portion; final scoped allocation gets remainder, no second discount/revenue. |
DemandTaxAmount | decimal | yes | Corresponding accepted tax basis, separately reconciled to actual invoices. |
SourceFamilyKey | text | yes | Canonical original PO/work-output/stock-provenance source; moving from PO receipt to descendant layer must not allocate the same supply again under another representation. |
Status | select | yes | Draft, Reserved, Approved, Active, PartiallyExecuted, Completed, Released, Reversed, Held |
CommittedAt | datetime | Actual independent approved assignment time; no automatic PO/stock creation. | |
ExecutionEvidence | longtext | yes | Validated exact receipt/output/layer/reservation/shipment/invoice quantity and value joins. A source can supply many demand lines but every remaining/actual unit is attributed once; reallocation checks existing physical/financial obligations. |
Replaces | reference | → TradeAllocations. Linked prior assignment; release only eligible remaining scope atomically with new assignment, retaining performed history. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
CostAllocationNumber | text | yes | Stable economic attribution identity. |
Deal | reference | yes | → TradeDeals. Owning same-entity trade scope. |
TradeAllocation | reference | → TradeAllocations. Specific demand/supply portion when directly attributable. | |
Basis | select | yes | Estimate, Commitment, Actual, Reversal |
Category | select | yes | Goods, ReceiptVariance, ProductionVariance, BankFee, Interest, Freight, Other |
Status | select | yes | Draft, PendingReview, Approved, Applied, Reversed, Superseded |
Currency | reference | yes | → Currencies. Original estimate/source cost currency. |
Amount | decimal | Signed known attributed cost; null while estimate incomplete, required finite before approved comparison/application. Known zero explicit; reversal has original source lineage. | |
FunctionalAmount | decimal | Known signed entity-functional attributed cost, same source cutoff/rate; null while unknown. | |
Rate | reference | → ExchangeRates. Required conversion when not already original source functional value; retains pair/date/type. | |
SourceTable | text | Actual/Commitment names exact allowed source type (BillLines, JournalLines, CreditCharges, WorkOrderCostEntries, ReceiptAcceptances or approved purchase line); absent for a pure estimate. | |
SourceKey | text | Exact immutable source record/line and revision; Actual must trace original posted expense/cost once. | |
EconomicCostKey | text | Canonical original economic cost across bill/charge/journal mirrors; cumulative live attribution cannot exceed actual eligible cost even through multiple representations. | |
Classification | longtext | yes | Reviewed estimate/committed/posted population, expense versus already embedded stock/COGS basis, comparison cutoff and allocation method/remainder. No automatic landed-cost capitalization; no counting stock cost and its source purchase as two expenses. |
AppliedAt | datetime | Actual attribution time, not a financial posting date. | |
ReversalOf | reference | → TradeCostAllocations. Exact prior allocated scope; correction preserves original cost/history. |
| Field | Type | Required | Details |
|---|---|---|---|
InstitutionCode | text | yes | Unique institution/branch identity. |
Name | text | yes | Actual legal bank/institution name. |
Country | text | yes | Actual country/branch reference, not a legal compliance assumption. |
BankReference | text | yes | Actual reviewed identifier; never an invented SWIFT connection or proof of account ownership. |
VerificationEvidence | longtext | yes | Purpose-limited actual counterparty/contact/source evidence with date and independent financial review. |
Status | select | yes | Draft, Active, Suspended, Blocked |
Activation | reference | → MasterChanges. Independent Finance Manager approval excluding preparer/material editor. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
CreditNumber | text | yes | Unique local LC identity; not itself bank issuance. |
ExternalReference | text | yes | Actual bank instrument/reference namespace, required before verified issued/advised states; a local draft may use an explicit pending identifier rather than inventing a bank number. |
Orientation | select | yes | ImporterApplicant, ExporterBeneficiary |
Customer | reference | → Accounts. Required external applicant/customer for ExporterBeneficiary; same owning-entity relationship. | |
Supplier | reference | → Suppliers. Required external beneficiary/supplier for ImporterApplicant; verified legal party. | |
IssuingBank | reference | yes | → FinancialInstitutions. Actual proposed/verified issuing institution. |
AdvisingBank | reference | → FinancialInstitutions. Actual bank when applicable, not assumed to undertake payment merely by advising. | |
ConfirmingBank | reference | → FinancialInstitutions. Only an actually evidenced confirming bank; confirmation may cover different amount/terms/period. | |
NominatedBank | reference | → FinancialInstitutions. Actual nominated/negotiating institution and its documented undertaking/role. | |
Currency | reference | yes | → Currencies. Instrument currency; currency change requires separately reviewed instrument scope, not arithmetic addition across currencies. |
RequestedAmount | decimal | yes | Positive local requested face amount; not evidence of issued exposure. |
IssuerAmount | decimal | Actual current issuer-issued face amount from verified bank events/amendments; nullable before actual evidence. | |
EffectiveAmount | decimal | Actual beneficiary-effective drawable face limit for its complete terms snapshot; cannot be reduced below retained used/reserved scope. | |
ConfirmedAmount | decimal | Actual confirmed coverage in this currency; unknown/absent confirmation is null, not presumed equal to face. | |
Availability | select | yes | Sight, DeferredPayment, Acceptance, Negotiation |
LocalStatus | select | yes | Draft, PendingApproval, Approved, Submitted, Cancelled |
Status | select | yes | Unissued, Issued, Advised, Active, PartiallyUsed, FullyUsed, Expired, Closed, Disputed, Cancelled |
IssuerSnapshot | reference | → DocumentRevisions. Complete actual issuer-issued terms, separate from local request and beneficiary effectiveness. | |
EffectiveSnapshot | reference | → DocumentRevisions. Complete currently beneficiary-effective terms and actual required-party evidence; never mix amendment clauses selectively. | |
ConfirmationSnapshot | reference | → DocumentRevisions. Actual confirmer-covered terms only; issuing-bank amendment does not automatically extend coverage. | |
IssuedAt | datetime | Actual bank issuance evidence time, not local request submission. | |
EffectiveAt | datetime | Actual governing party effectiveness time with proof. | |
ConfirmedAt | datetime | Actual relevant bank confirmation time and scope. | |
ExpiryAt | datetime | Instrument expiry with place/timezone and recorded calendar rule; blocks new unsupported work, not established maturity/obligation. | |
ShipmentDeadline | datetime | Actual latest shipment condition from applicable terms; no inferred deadline. | |
PresentationDeadline | datetime | Actual date or computed deadline with retained calculation/evidence; rules conditional on the incorporated instrument. | |
Terms | longtext | yes | Complete reviewed parties/amount/availability/maturity/document requirements, place/calendar/timezone, partial shipment/drawing limits/tolerances and applicable rules/version. No default UCP/eUCP or universal examination period; excludes standby/revolving/transferable/back-to-back bank products. |
BankEvent | reference | → CreditBankEvents. Latest authoritative state evidence; full historical events remain immutable. | |
ReservedAmount | decimal | yes | Known nonnegative sum active drawing reservations in instrument currency, including presented/discrepant/uncertain scope; never a second reserve for re-presentation of one drawing. |
UsedAmount | decimal | yes | Sum currently established drawing AcceptedAmount, which includes actual paid scope once; subsequent reimbursement or refunded money never automatically restores LC availability. |
AvailableAmount | decimal | EffectiveAmount minus UsedAmount minus ReservedAmount under current applicable terms; null before valid terms, nonnegative for new use. Issuer exposure and confirmed coverage are separately disclosed. | |
Owner | reference | yes | → Users. Trade Finance Coordinator preparing and verifying correspondence; cannot sign independent Finance Manager decisions or impersonate a bank. |
CloseDecision | reference | → ApprovalDecisions. Mandatory independent Finance Manager instrument closure after actual release/expiry evidence and all drawing/undertaking/financial/cover/charge obligations reconciled; expiry alone never closes established maturity. | |
ClosedAt | datetime | Actual authorized full closure time. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
AmendmentNumber | text | yes | Unique local request and external amendment family. |
Credit | reference | yes | → DocumentaryCredits. Original instrument, same entity/currency. |
ExternalAmendmentKey | text | yes | Stable actual bank reference once known; explicit local pending identity before issuance. |
PriorSnapshot | reference | yes | → DocumentRevisions. Exact complete terms requested to change. |
ProposedSnapshot | reference | yes | → DocumentRevisions. Complete proposed replacement terms, including signed amount/deadline/condition changes. |
Status | select | yes | Draft, PendingApproval, Approved, Requested, IssuerIssued, AwaitingPartyEvidence, Effective, Rejected, Withdrawn, Disputed |
AmountDelta | decimal | yes | Signed instrument-currency requested change; actual issuer/effective/confirmed limits each follow their own evidenced snapshot rather than applying this delta on local approval. |
IssuerEvent | reference | → CreditBankEvents. Actual issuer amendment issuance; does not itself prove beneficiary effectiveness or confirmer extension. | |
IssuerSnapshot | reference | → DocumentRevisions. Complete actual issuer-issued amendment terms, possibly differing from request; differences need local review before protected use. | |
BeneficiaryEvent | reference | → CreditBankEvents. Actual required beneficiary/party acceptance or rejection evidence under reviewed instrument; no invented consent or partial mix of clauses. | |
EffectiveSnapshot | reference | → DocumentRevisions. Entire beneficiary-effective amended terms; old drawings retain their own original snapshot. | |
ConfirmationEvent | reference | → CreditBankEvents. Actual confirming-bank extension/refusal/limited coverage evidence, separately preserved. | |
ConfirmationSnapshot | reference | → DocumentRevisions. Exact confirmed portion/terms and currency amount, not implied by issuer/beneficiary state. | |
IssuerAt | datetime | Actual issuer event time. | |
EffectiveAt | datetime | Actual effectiveness time from governing required-party evidence. | |
ConfirmationAt | datetime | Actual confirming coverage event time. | |
ExposureEvidence | longtext | yes | Prior/current issuer amount, beneficiary-effective amount and confirmed scope; existing reservations/accepted/paid drawings and bank obligations. No release below live source scope or early exposure release because local amendment was rejected. |
| Field | Type | Required | Details |
|---|---|---|---|
Credit | reference | yes | → DocumentaryCredits. Owning instrument. |
TermsSnapshot | reference | yes | → DocumentRevisions. Exact applicable original/amended terms. |
ConditionNumber | text | yes | Stable condition identity within revision. |
Kind | select | yes | Document, Shipment, Presentation, Amount, Other |
Requirement | longtext | yes | Actual issuer/form/count/content/shipment/place requirement and evidence; no generic invented checklist replaces instrument terms. |
DeadlineAt | datetime | Actual explicit deadline if fixed; null if absent or unresolved, not fabricated. | |
CalendarRule | longtext | yes | Applicable place/timezone, actual working calendar and retained calculation for relative deadlines; unknown blocks compliance assertion. |
Mandatory | boolean | yes | Whether instrument requires this condition for scoped presentation; absence still needs actual evidence. |
Status | select | yes | Draft, Active, Superseded, Unresolved |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
BankEventNumber | text | yes | Unique evidence identity. |
Credit | reference | yes | → DocumentaryCredits. Instrument family. |
Institution | reference | → FinancialInstitutions. Actual source bank when bank-issued; required party correspondence retains actual source in Evidence. | |
ExternalEventKey | text | yes | Stable source namespace/event key. |
EconomicKey | text | yes | Canonical actual event identity across advice/message/statement mirrors; same effect cannot be applied twice. |
Kind | select | yes | Issued, Advised, Confirmed, AmendmentIssued, BeneficiaryAccepted, BeneficiaryRejected, ConfirmationChanged, Presented, DiscrepancyNotified, WaiverRequested, BankAccepted, DeferredUndertaking, AcceptanceUndertaking, ActualSupplierSettlement, ActualBeneficiarySettlement, RecourseAdvance, ActualReimbursement, DirectLenderCollection, BankRemittance, CollateralPlaced, CollateralApplied, CollateralReleased, Charge, BankRelease, Expiry, Cancellation, Return, Correction |
Status | select | yes | Observed, PendingVerification, Verified, Applied, Uncertain, Conflict, Rejected |
OccurredAt | datetime | Actual bank/party/economic occurrence; null until known, mandatory for verified effect. Received time cannot silently substitute. | |
ReceivedAt | datetime | yes | Actual ingestion/manual receipt time. |
Evidence | longtext | yes | Authenticated source or independently verified manual bank/party documents, message/reference/hash, actual event meaning, amount/currency/party and distinction between undertaking, actual supplier/proceeds settlement and reimbursement. No installed SWIFT/API claim. |
VerifiedBy | reference | → Users. Actual Trade Finance Coordinator or explicitly qualified Finance Manager verifier; not itself authority to approve own protected financial classification. | |
VerifiedAt | datetime | Actual verification time. | |
Drawing | reference | → CreditDrawings. Exact partial drawing family where applicable. | |
Amendment | reference | → CreditAmendments. Exact complete amendment family where applicable. | |
Amount | decimal | Actual event amount in Currency when monetary; unknown remains null, event kind/direction determines meaning, not inferred cash. | |
Currency | reference | → Currencies. Actual amount currency, distinct from credit/source/cash currency where necessary. | |
ClassificationDecision | reference | → ApprovalDecisions. Independent Finance Manager for protected financial effect/classification; actual observed bank evidence remains durable while approval/mapping is unresolved. | |
AppliedAt | datetime | Actual once-only linked state/financial application; communication acknowledgment alone creates no cash or title. | |
CorrectionOf | reference | → CreditBankEvents. Original actual evidence/economic effect; compensating consequences and original state/history retained. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
DrawingNumber | text | yes | Unique original drawing family; corrected/re-presented packets reuse this family and remaining source scope. |
Credit | reference | yes | → DocumentaryCredits. Applicable instrument and entity. |
TermsSnapshot | reference | yes | → DocumentRevisions. Exact reviewed coherent governing/presentation basis. Where actual incorporated rules permit presentation itself to evidence amendment acceptance, retain that chosen packet basis and unresolved effectiveness until the verified event; no separate acceptance letter is universally required and no proposed terms silently become effective. |
Amount | decimal | yes | Positive instrument-currency maximum requested drawing scope, immutable after presentation except linked reviewed scope revision. |
Currency | reference | yes | → Currencies. Matches instrument currency; underlying invoice/bill/cash may differ with retained conversion. |
Status | select | yes | Draft, Reserved, Presented, Discrepant, Uncertain, Accepted, PartiallySettled, Settled, Released, Rejected, Closed |
ReservedAmount | decimal | yes | Requested scope not yet established or authoritatively released, including active presented/discrepant/uncertain portions. Amount = ReservedAmount + AcceptedAmount + ReleasedAmount; re-presentation does not add another reserve. |
AcceptedAmount | decimal | yes | Live established bank undertaking plus its already actually settled portion, counted once. PaidAmount is included, not added again; only authoritative release of unperformed accepted scope can reduce it with retained event history. |
PaidAmount | decimal | yes | Actual LC supplier/beneficiary economic settlement within AcceptedAmount; a DeferredUndertaking/AcceptanceUndertaking or recourse advance is not this actual settlement. Historical paid use never restores available face merely because reimbursed/returned. |
ReleasedAmount | decimal | yes | Authoritatively released/rejected unperformed original scope, excluding actual paid scope; exact events preserve history. |
MaturityAt | datetime | Actual accepted deferred/acceptance due date and instrument calendar; survives presentation expiry until resolved. | |
PresentedAt | datetime | First actual bank presentation evidence, not local send intent. | |
AcceptedAt | datetime | Actual first established bank undertaking for scoped amount; does not assert cash moved. | |
LastSettlementAt | datetime | Actual last supplier/beneficiary settlement, not company reimbursement. | |
UndertakingEvent | reference | → CreditBankEvents. Actual bank acceptance/deferred undertaking evidence for exact established scope. | |
SettlementEvent | reference | → CreditBankEvents. Actual supplier/beneficiary economic settlement evidence; full event history retained. | |
SourceEvidence | longtext | yes | Validated source invoice/order/shipment/bill scopes, exact accepted/paid/released event amounts, recourse/confirmation coverage, rates and current claims; ambiguous outcome retains reserved exposure and blocks reuse. |
FinanceDecision | reference | → ApprovalDecisions. Independent Finance Manager exact financial classification/recognized effect, separate from documentary request/presentation approval. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
PresentationNumber | text | yes | Unique packet attempt, distinct from original economic drawing family. |
Drawing | reference | yes | → CreditDrawings. One existing drawing family; no new reservation merely because a packet is corrected or retried. |
TermsSnapshot | reference | yes | → DocumentRevisions. One coherent reviewed packet basis matching its drawing, including amendment acceptance via actual presentation where applicable; issuer-issued, beneficiary-effective and confirmation coverage remain separate. No mix of incompatible old/new conditions. |
Bank | reference | yes | → FinancialInstitutions. Actual receiving/nominated bank. |
Amount | decimal | yes | Positive presented instrument-currency scope bounded by this drawing and exact source allocations; concurrent active attempts cannot overlap the same scope. |
Status | select | yes | Draft, PendingApproval, Approved, Submitted, Presented, Examining, Discrepant, Accepted, Rejected, Superseded, Closed, Uncertain |
SubmittedAt | datetime | Actual transmission intent/outbound evidence, not presumed bank receipt. | |
PresentedAt | datetime | Actual evidenced bank receipt/presentation instant at applicable place/timezone. | |
ExaminationDueAt | datetime | Reviewed actual terms/rules/calendar calculation; null if unresolved, no universal fixed examination window. | |
Instruction | reference | → IntegrationDeliveries. Frozen packet transmission and transport acknowledgment, not bank acceptance. | |
BankEvent | reference | → CreditBankEvents. Authoritative actual bank presentation/outcome evidence. | |
Replaces | reference | → CreditPresentations. Prior packet attempt in same drawing family; old outcome/claims retained until authoritative release/replacement evidence. | |
PacketEvidence | longtext | yes | Exact document hashes, required conditions/issuer/form/count, shipment/amount/deadline calculations, bank receipt and applicable confirmation scope. Independent local review is not a bank compliance guarantee. |
| Field | Type | Required | Details |
|---|---|---|---|
Presentation | reference | yes | → CreditPresentations. Exact packet attempt. |
DocumentNumber | text | yes | Stable packet/document identity. |
Condition | reference | yes | → CreditConditions. Exact instrument requirement/version addressed. |
DocumentKind | select | yes | CommercialInvoice, TransportDocument, PackingList, OriginEvidence, InsuranceEvidence, Draft, Other |
Issuer | text | yes | Actual named issuer/source, not invented authority. |
IssuedAt | datetime | Actual document issue time/date evidence, null until known. | |
Version | text | yes | Exact immutable document revision. |
ContentHash | text | yes | Actual file/content hash. |
Document | attachment | Actual protected versioned evidence when Available/Checked and before a submission that requires it. Null for Missing/Draft; never fabricate an attachment to satisfy a schema check. | |
SourceTable | text | Exact ERP source type when generated from a sales/stock/financial record. | |
SourceKey | text | Exact immutable source key/revision; document generation is not source posting. | |
Status | select | yes | Draft, Available, Checked, Missing, Conflict, Superseded |
CheckEvidence | longtext | yes | Actual reviewed form/issuer/copy/count/content/date observations and checker identity, including unresolved discrepancies; not a claim of bank acceptance. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
DiscrepancyNumber | text | yes | Unique issue/packet family; retries do not create another financial use. |
Presentation | reference | yes | → CreditPresentations. Affected exact packet. |
Condition | reference | → CreditConditions. Specific applicable requirement when known. | |
Document | reference | → CreditDocuments. Specific actual document when applicable. | |
Status | select | yes | Observed, UnderReview, CorrectionPrepared, WaiverRequested, AwaitingBank, BankAccepted, BankRejected, Resolved, Uncertain |
Issue | longtext | yes | Actual discrepancy source, evidence, amount/quantity/deadline effects and bank notification. |
ReportedAt | datetime | yes | Actual observation/notification time. |
LocalDecision | reference | → ApprovalDecisions. Independent Finance Manager approves protected correction/waiver request with exact scope; does not state bank acceptance. | |
WaiverEvent | reference | → CreditBankEvents. Actual applicant/party waiver request/evidence, separate from bank decision. | |
BankDecisionEvent | reference | → CreditBankEvents. Actual bank acceptance/rejection/release; local request cannot substitute. | |
ResolvedAt | datetime | Actual evidenced closure of issue, with drawing/terms consequences retained. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
AllocationNumber | text | yes | Unique economic source/drawing portion, reused on same-content retry. |
Drawing | reference | yes | → CreditDrawings. Original partial drawing family. |
Presentation | reference | → CreditPresentations. Current packet attempt; replacement retains same original scope and cannot duplicate use. | |
Side | select | yes | Import, Export |
SourceKind | select | yes | SalesOrderLine, InvoiceLine, PurchaseOrderLine, BillLine |
SalesOrderLine | reference | → SalesOrderLines. Required only for export preinvoice commercial scope; later invoice claim replaces this representation, not another face use. | |
InvoiceLine | reference | → InvoiceLines. Required only for export actual invoice scope; unencumbered eligible net/tax and AR claims rechecked. | |
PurchaseOrderLine | reference | → PurchaseOrderLines. Required only for import prebilled commercial scope; actual bank prepayment retains exact supplier and later AP-use claims. | |
BillLine | reference | → BillLines. Required only for import actual bill scope; ordinary Payments/credits and LC settlement cannot claim the same open payable twice. | |
ShipmentLine | reference | → ShipmentLines. Supporting actual shipment identity/quantity when terms require it; no separate stock issue or duplicate LC face claim. | |
TradeAllocation | reference | → TradeAllocations. Actual deal/demand/supply attribution, not authority to create additional goods/cash. | |
CreditAmount | decimal | yes | Positive instrument-currency claim; sum active and established uses <= drawing scope, with deterministic final remainder. |
SourceCurrency | reference | yes | → Currencies. Underlying commercial/debit currency. |
SourceAmount | decimal | yes | Positive scoped gross/eligible amount in source currency, separate from CreditAmount. |
BaseQuantity | decimal | Actual positive source base quantity where applicable; null for approved pure financial scope with explicit terms, never invented physical quantity. | |
RateEvidence | longtext | yes | Exact source/credit conversion pairs/dates/purpose, net/tax allocation, eligible outstanding and partial rounding, including confirmed coverage. Physical quantities are never added across different SKUs. |
Status | select | yes | Reserved, Presented, Established, Settled, Released, Reversed, Held |
CreatedAt | datetime | yes | Atomic claim time. |
SettledAt | datetime | Actual financial effect time for this exact source portion, not bank undertaking alone. | |
PaymentAllocation | reference | → PaymentAllocations. Actual import AP settlement source once; no duplicate company-cash payment. | |
CashApplication | reference | → CashApplications. Actual outright export cash settlement source once; not recourse advance. | |
BankAllocation | reference | → BankObligationAllocations. Actual direct lender collection or other approved bank obligation/source effect with no fictitious company cash. | |
Journal | reference | → JournalEntries. Exact economic effect shared with linked source, never another independent copy of the journal. | |
Replaces | reference | → CreditAllocations. Atomic released old source representation/new exact source; underlying performed scope and LC family use retained. | |
ReversalOf | reference | → CreditAllocations. Exact prior amount/quantity/FX/source claim; external release and downstream financial corrections required before reuse. | |
SettlementKind | select | yes | Unsettled, OrdinaryApplication, DirectDebtSettlement, HeldProceedsRecognition. One source slice uses one posting owner; shared event components partition total AR scope and cannot overlap. |
RecognitionObligation | reference | → BankObligations. Required only for HeldProceedsRecognition: exact new BankReceivable/BankHeldProceeds source receiving this invoice-line scope. It works with zero remaining recourse debt and requires no fictitious repayment or CashReceipt. | |
SourceCarrying | decimal | Current functional AR portion released by HeldProceedsRecognition, required before posting; ordinary settlements retain this in their actual application record instead. | |
PriorFXReleased | decimal | Exact attributed prior AR unrealized amount released/reclassified at zero additional net FX for held-proceeds recognition. | |
FinanceDecision | reference | → ApprovalDecisions. Independent Finance Manager exact direct-collection/held-proceeds classification, source currency/value/fees and source claim decision. | |
SettlementComponents | longtext | yes | Unsettled states no effect. Each actual collection has one source event/economic group and balanced journal: disjoint AR slices fund debt settlement, actual fees, actual cash if evidenced and held proceeds. Ordinary application delegates to its one application record. HeldProceedsRecognition consumes its own reserved AR invoice-line slice and creates the linked BankReceivable at actual amount/current value. No source slice also appears in another bank allocation/application. Corrections retain all original component identities. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
ChargeNumber | text | yes | Unique canonical economic fee/interest identity across bank/bill/journal mirrors. |
Credit | reference | yes | → DocumentaryCredits. Instrument/facility scope. |
Drawing | reference | → CreditDrawings. Exact utilized drawing when attributable. | |
BankEvent | reference | → CreditBankEvents. Actual bank charge/deduction/refund evidence. | |
Kind | select | yes | IssueFee, AmendmentFee, PresentationFee, DiscrepancyFee, ConfirmationFee, NegotiationFee, Interest, Other, Reversal |
Basis | select | yes | Estimate, Actual |
Status | select | yes | Observed, PendingReview, Approved, Posted, Disputed, Reversed |
Currency | reference | yes | → Currencies. Actual charge currency. |
Amount | decimal | Known signed original charge, positive expense and negative actual reversal/refund; null while unknown estimate/evidence, mandatory before posting. | |
FunctionalAmount | decimal | Known signed actual financial amount, with retained rate/source; not default zero. | |
Rate | reference | → ExchangeRates. Required actual conversion/purpose when not already a verified functional source. | |
OccurredAt | datetime | Actual source occurrence; unknown remains unresolved. | |
ExpenseAccount | reference | → ChartOfAccounts. Approved expense classification; no automatic landed-cost capitalization. | |
BillLine | reference | → BillLines. Original actual bill source if invoiced; a direct funding/statement charge instead uses its own journal, not both. | |
StatementLine | reference | → BankStatementLines. Actual bank debit/credit where applicable, or part of exact gross/net funding event. | |
BankObligation | reference | → BankObligations. Charge included in actual bank-funded liability or deducted from advance/held proceeds; exact amount is part of that shared economic journal. | |
Journal | reference | → JournalEntries. One actual source expense/reversal journal; linked funding/bill does not post it again. | |
Classification | longtext | yes | Reviewed expense/purpose/rate/period, gross-versus-net source components, reserved versus actual amount, and exact Finance Manager decision. Estimate is not actual expense; unsupported classification remains held/visible. |
ReversalOf | reference | → CreditCharges. Exact prior charge and claimed/allocated scope; fee refund never erases original history. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
CollateralNumber | text | yes | Unique actual movement/claim identity. |
Credit | reference | yes | → DocumentaryCredits. Covered instrument and same entity. |
Drawing | reference | → CreditDrawings. Specific drawing requirement if applicable. | |
Kind | select | yes | Placement, TopUp, Application, Release, Correction |
Status | select | yes | Draft, PendingApproval, Approved, Reserved, Submitted, Uncertain, Posted, Released, Reversed |
Currency | reference | yes | → Currencies. Actual restricted cash source currency. |
Amount | decimal | yes | Positive restricted-source currency amount; actual source and destination currencies may differ only with retained conversion. |
SourceAccount | reference | → BankAccounts. Placement source or existing RestrictedCash source for application/release; not an external bank identity. | |
DestinationAccount | reference | → BankAccounts. Actual restricted cash destination for placement/top-up, or actual released cash destination. Null for direct application to a bank obligation without another company-bank deposit. | |
OriginalPlacement | reference | → CreditCollateralMovements. Exact actual posted placement source; new active claim is bounded by its remaining unapplied/unreleased amount less other active claims, not less already deducted posted history. Final use takes exact remaining carrying; correction never revives consumed collateral blindly. | |
BankObligation | reference | → BankObligations. Actual CompanyPayable obligation reduced by collateral application; independent settlement allocation shares this effect. | |
BankAllocation | reference | → BankObligationAllocations. Exact approved partial repayment/application; cannot also debit unrestricted bank cash. | |
SourceCarrying | decimal | Actual current functional asset carrying released, including prior FX; null before known, mandatory before posting. | |
DestinationAmount | decimal | Actual destination-currency amount for transfer legs; no invented amount for obligation application. | |
DestinationValue | decimal | Actual functional asset value received or liability carrying reduced, with distinct new FX/fee treatment. | |
RateEvidence | longtext | yes | Actual conversion, current carrying and prior FX allocations; restricted cash is an asset, not expense or automatic net liability. |
BankEvent | reference | → CreditBankEvents. Actual bank/custodian placement/application/release; intent/approval does not move assets. | |
OccurredAt | datetime | Actual movement time. | |
Journal | reference | → JournalEntries. Shared typed asset-transfer or obligation-versus-restricted-asset effect once; no second supplier payment/customer receipt. | |
ReversalOf | reference | → CreditCollateralMovements. Original movement; remaining obligations/cover/source claims and downstream settlement checked before compensation. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
ObligationNumber | text | yes | Unique original monetary recognition/source family; partial repayment uses separate allocations. |
Credit | reference | yes | → DocumentaryCredits. Owning LC instrument, same entity. |
Drawing | reference | → CreditDrawings. Exact actual drawing/funding scope; undrawn commitment does not itself create this monetary balance. | |
Institution | reference | yes | → FinancialInstitutions. Actual bank creditor/debtor. |
BalanceSide | select | yes | CompanyPayable, BankReceivable |
OriginKind | select | yes | ImportSupplierFunding, ExportRecourseAdvance, BankHeldProceeds, RecognizedUndertaking, Correction, Opening |
Currency | reference | yes | → Currencies. Monetary obligation currency, independent of LC face, underlying invoice/bill and cash currencies. |
Amount | decimal | yes | Positive immutable original recognized monetary amount; classification/evidence determines asset or liability, never an automatic LC-face posting. |
OutstandingAmount | decimal | yes | Remaining own-currency amount after posted exact allocations/corrections; no negative remainder. |
CurrentCarrying | decimal | yes | Nonnegative current functional value of remaining source, including unreversed revaluation. Zero remaining amount requires zero remaining carrying; final settlement takes the exact remainder, never strands value. |
UnrealizedFX | decimal | yes | Signed gain-positive attributed prior FX on remaining monetary source, zero-net reclassified when settled. |
ReservedAmount | decimal | yes | Active own-currency repayment/collection/application claims; available = OutstandingAmount minus active claims, never below zero. |
Status | select | yes | Prepared, PendingClassification, Approved, Open, PartiallySettled, Settled, Held, Reversed |
RecognizedAt | datetime | Actual reviewed monetary recognition time based on event/agreement, not local credit approval or the bare word honor. | |
MaturityAt | datetime | Actual contractual liability/receivable due date; instrument presentation expiry does not erase it. | |
Rate | reference | → ExchangeRates. Original positive obligation-to-functional multiplier and actual date/type, required before recognition. | |
BankEvent | reference | → CreditBankEvents. Verified actual bank funding/supplier settlement/proceeds/undertaking classification event, not an inferred payment. | |
SourcePayment | reference | → Payments. Import actual supplier settlement or supplier prepayment funded by this obligation; shares original economic journal and no company cash debit. | |
FundingBankAccount | reference | → BankAccounts. Actual company-bank receipt for recourse advance only when money is received; null for import funding or bank-held proceeds not yet remitted. | |
FundingCashAmount | decimal | Actual cash amount in FundingBankAccount currency, normally net of separately evidenced fees; null with no company cash movement. | |
FundingCashValue | decimal | Actual functional bank value for that net cash leg; gross principal/fees and source current carrying reconcile separately. | |
ControlAccount | reference | → ChartOfAccounts. Approved BankFunding liability or bank-held-proceeds asset account for BalanceSide, never both or ordinary customer AR/AP without explicit correction. | |
FundingComponents | longtext | yes | Validated exact actual bank event and gross/net monetary components: eligible AP/supplier prepayment, recourse cash/fees, or actual customer collection applied to lender plus residual proceeds. Original source amounts/currencies/current carrying/FX and canonical charge keys sum to one balanced journal; no second ordinary receipt/payment. A deferred undertaking alone requires explicit recognition basis and cannot claim actual supplier settlement. |
Journal | reference | → JournalEntries. Original shared recognition journal; import payment/fees or direct collection components link to this same economic effect, not duplicate postings. | |
Baseline | longtext | yes | Nonposting opening original/settled/outstanding/carrying/prior FX and external source IDs; native known-zero history. |
CorrectionOf | reference | → BankObligations. Exact prior source monetary recognition with downstream allocations and actual bank obligations reconciled. | |
SourceAllocation | reference | → CreditAllocations. Exact HeldProceedsRecognition claim for a bank-held asset, including all-held proceeds where recourse debt is zero. Paired debt/fee/held/cash components share one actual event and balanced journal, but consume disjoint original AR slices. |
| Field | Type | Required | Details |
|---|---|---|---|
Entity | reference | yes | → Entities. Owning legal entity; linked commercial, stock and financial source ownership must agree. |
Revision | number | yes | Positive monotonic content revision; submitted/material editors and accepted scope are immutable. |
Snapshot | reference | → DocumentRevisions. Exact source terms/lines/amounts/party/actor/policy hash; required before review and effect. | |
CreatedBy | reference | yes | → Users. Actual preparer identity, not a role alias. |
CreatedAt | datetime | yes | Actual offset-aware creation time. |
OperationKey | text | yes | Stable economic action identity; identical content returns the same result, conflict enters review. |
Event | reference | → IntegrationEvents. Authenticated external or reviewed manual evidence with source identity/hash. | |
Decision | reference | → ApprovalDecisions. Exact current independent action/scope/revision authority, mandatory before the corresponding authorized effect. | |
BankAllocationNumber | text | yes | Unique economic settlement identity; retries return same effect. |
Obligation | reference | yes | → BankObligations. One exact remaining monetary source and BalanceSide. |
Kind | select | yes | CompanyReimbursement, DirectLenderCollection, CollateralApplication, BankRemittance, Correction |
Status | select | yes | Draft, PendingApproval, Reserved, Submitted, Uncertain, Posted, Released, Reversed |
ObligationAmount | decimal | yes | Positive amount in obligation currency. New active reservation cannot exceed OutstandingAmount less all other active reservations/holds; posted history is already deducted from OutstandingAmount and is not subtracted again. Equivalently cumulative net posted plus active claims cannot exceed adjusted recognized source amount. |
BankAccount | reference | → BankAccounts. Actual company cash source/destination only for CompanyReimbursement/BankRemittance, not fictitious for direct lender or collateral paths. | |
CashAmount | decimal | Actual nonnegative company-bank amount. For BankRemittance this is net proceeds, not gross receivable consumed; zero is allowed only when verified deductions consume the entire residual, with no invented cash leg. Gross source, Charge and FX components must fully reconcile. | |
CashCarrying | decimal | Actual company cash functional carrying/value, nonnegative and zero when no cash moves. Required before posting for cash movements; no bank amount/account is invented for a fully fee-deducted remittance. | |
Invoice | reference | → Invoices. Exact still-outstanding customer AR for DirectLenderCollection only; customer actually pays bank under verified agreement, not another company cash receipt. | |
InvoiceAmount | decimal | AR-currency portion allocated to this debt-settlement component only. Separate held-proceeds/fee/cash components consume disjoint invoice claims, and their sum equals actual gross lender collection. No positive debt allocation is fabricated when the debt is zero; CreditAllocations with SettlementKind HeldProceedsRecognition owns that AR-to-asset slice. | |
InvoiceCarrying | decimal | Current functional AR released; shared claims include CashApplications, CreditApplications and all LC/direct-lender allocations. | |
CreditAllocation | reference | → CreditAllocations. Exact original drawing/source claim; no second documentary or AR use. | |
Collateral | reference | → CreditCollateralMovements. Exact actual restricted-asset application and source-currency/current-value claim; no duplicate unrestricted cash debit. | |
ObligationCarrying | decimal | Current functional liability/receivable portion released; null until known, mandatory before posting. | |
PriorFXReleased | decimal | Attributed source obligation prior unrealized gain/loss, reclassified with zero new net FX. | |
RateEvidence | longtext | yes | All currencies/current carrying/prior FX and gross/net splits. A BankRemittance may settle a newly recognized held-proceeds source in the same atomic event: gross receivable consumed = actual net cash plus its exact authorized Charge in reconciled currency/value, with separately classified FX. The intermediate source opens and settles once with zero ending balance; it is not outstanding held proceeds at cutoff. No second AR discharge or fee posting. |
BankEvent | reference | → CreditBankEvents. Actual bank reimbursement, direct customer collection, collateral application, remittance or return; submission/acknowledgment is insufficient. | |
SettledAt | datetime | Actual economic settlement time; cannot be set merely by internal approval. | |
Journal | reference | → JournalEntries. Shared balanced settlement/correction once. Company reimbursement clears bank liability versus cash; direct lender collection clears only its exact AR/debt component without company cash. Distinct CreditAllocations held-proceeds components create BankReceivable sources in the same journal. Bank remittance clears that source, not AR again. | |
ReversalOf | reference | → BankObligationAllocations. Exact original amount/source/currency/FX claim; restore only eligible corrected scope and retain actual history. | |
Charge | reference | → CreditCharges. Actual deducted fee in a BankRemittance gross/net component, same verified event and shared canonical journal. ObligationAmount is gross bank-receivable currency consumed; CashAmount/CashCarrying are actual net bank proceeds and this exact charge supplies the remaining authorized amount/value. No fee is also posted elsewhere. |
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.