The tables behind Cosmetics 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.

Exclusive bounded demand claims through picking and owned transit.

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

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.

Authoritative human decisions independent of document lifecycle.

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

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.

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.

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.

Expiry Allocations for ERP for FMCG.

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

Shallow warehouse bins, staging and transit custody locations.

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.

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

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

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

Explicit stable sequence and exact order/shipment ownership.

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.

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

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

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.

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

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

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.

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

Actual external bank evidence, not inferred payment success.

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

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

Current source reconciliation evidence for an entity cutoff.

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

Entity-specific fiscal periods and guarded close.

Authoritative human decisions independent of document lifecycle.

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.

Trade Promotions for ERP for FMCG.

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.

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.

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.

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

People for ERP for FMCG.

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.

Restricted supplier payment destinations with independent finance confirmation.

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

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

Users