The tables behind Chemicals ERP

Entity-scoped trade customers, including dealer terms, holds and billing identity.

Contacts and delivery sites belong to the dealer and are separate from authentication.

Versioned dealer offers with known pricing basis and real acceptance lineage.

All line/header discounts allocated once into accepted net value.

Dealer-accepted scope plus mandatory independent commercial approval.

Bounded accepted quantity/value and retained original promise.

Atomic dealer exposure review and separately bounded exception.

Effective entity/currency dealer pricing; no accepted-price mutation.

Quantity-tier price basis in a named product unit.

Versioned product-specific buy/sell packs and base conversions.

Authoritative human decisions independent of document lifecycle.

Entity purchasing counterparties with separately controlled beneficiary data.

Operational purchasing demand without automatic spend approval.

Requested product quantities and source demand identity.

Immutable approved supplier commitments; cumulative amendments cannot bypass authority.

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

Immutable actual arrivals and separately accepted quantities.

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

Independent bounded disposition tranches against one immutable actual arrival.

Local supplier debit/credit documents with matching, carrying and separate settlement.

Supplier charges matched to accepted receipts, with explicit nonstock exceptions.

Reserve and consume accepted receipt versus bill quantities/value once.

Trade goods and assembly outputs; master values do not rewrite transactions.

Versioned product-specific buy/sell packs and base conversions.

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

Shallow warehouse bins, staging and transit custody locations.

Current owned stock by complete identity and custody state; provenance is not a second balance.

Exclusive bounded demand claims through picking and owned transit.

Same-entity transfer with actual dispatch/partial receipt and retained owned transit.

Partial transfer quantities retain equal in-transit ownership and cost.

One immutable group of stock movements and the associated journal effect.

Signed position/layer legs; transfers balance quantity and value by SKU.

Remaining quantity/carrying value with receipt/output/return lineage.

Blind scoped counts with explicit review and cost before adjustment.

Observed base quantity and signed variance against an unchanged locked population.

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

Effective distribution assembly/repacking recipes with explicit output basis.

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

Versioned assembly/repacking instructions, distinct from delivery routes.

Ordered work instructions and declared labour/overhead bases.

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

Frozen required input and actual traced issue/return scope.

Frozen instructions and assigned actual work.

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

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

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

Entity/product standard per base unit with immutable effective versions.

Current owned stock by complete identity and custody state; provenance is not a second balance.

Exclusive bounded demand claims through picking and owned transit.

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

Actual dispatch and title/delivery state separated for partial deliveries.

Actual dispatch quantities and current title-transferred/delivered portions.

Manual route/stop sequence and assigned execution; no optimization or live tracking.

Explicit stable sequence and exact order/shipment ownership.

Actual visit/handoff facts, separate from line outcomes and legal title.

Each attempt allocates line outcomes once; one visit may partially deliver many lines.

Dealer-accepted scope plus mandatory independent commercial approval.

Bounded accepted quantity/value and retained original promise.

One immutable group of stock movements and the associated journal effect.

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

Exact original commercial/stock scope and actual returned quantities.

Independent actual goods disposition without automatic credit or refund.

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

Exact unbilled title-transferred accepted price allocation or original credit scope.

Actual customer cash recognized once to unapplied liability before invoice allocation.

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

Local supplier debit/credit documents with matching, carrying and separate settlement.

One economic supplier disbursement with authoritative settlement/rejection/return evidence.

Actual external bank evidence, not inferred payment success.

Current source reconciliation evidence for an entity cutoff.

Authoritative human decisions independent of document lifecycle.

Entity-specific fiscal periods and guarded close.

Time- and scope-bounded coverage, never a new role.

Entity-owned bank currency balances and restricted destination data.

Entity ledger accounts, including controlled subledger accounts.

Bounded customer/supplier credit allocation with retained surplus and reservations.

Currency precision and display rules.

Versioned operational and financial rules with explicit finite limits.

Immutable typed document snapshots and source basis.

Separate legal books and stock ownership; shared masters do not consolidate balances.

Read-only effective exchange rates for this app.

Immutable dated conversion evidence; no hidden fallback.

Expiry allocation records linked to sales order lines.

Independent reviewed reversals, bank returns, write-offs and charges without editing posted history.

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

Authenticated inbound/manual evidence with idempotent economic effects.

Balanced entity-functional journals with source identity and immutable postings.

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

Protected master activation without direct Manage permission bypass.

Reviewed cutover: one full opening GL plus nonposting detailed balances.

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

Reserved bill and payment currency quantities with current-carrying settlement.

Frozen payable settlement proposals and protected beneficiary snapshots.

Due-date terms, independent of actual cash settlement.

People records linked to users.

Approved source-specific stock, production and trade posting mappings.

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

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

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

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

Restricted supplier payment destinations with independent finance confirmation.

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

Trade promotion records linked to suppliers, products and people.

Dimension and precision for stock, purchase, sale and production quantities.

Users