Data that can be followed end to end.
A conceptual map of the records the ERP may need. Exact keys, fields, retention, ownership and database technology remain subject to architecture and client approval.
Stock and finance source-of-truth choices, tenant boundaries and data-retention rules must be approved before detailed design.
Core entity groups
Master data describes the business; transaction data records what happened.
◈ Business structure
Entity ownership and location scopes that constrain records and user access.
◎ Shared masters
Controlled reference records used consistently across purchasing, production and sales.
↗ Supplier-to-stock
Commercial order and actual receipt remain separate, linked records.
⚙ Formula-to-batch
Versioned instructions connect production orders to actual material lots and outputs.
✓ Custody & disposition
Stock quantity and quality status are separately recorded and auditable.
▣ Outbound records
Invoices, payments and accounting records preserve source references and correction history.
Full database relationship diagrams
All proposed tables are grouped into seven diagrams. Each table shows its primary key, foreign keys and core columns; select a domain to explore its relationships.
Entity names, fields, keys, cardinalities and optional tables require architecture and client approval. Common audit fields and detailed entity notes are in the data dictionary. This page does not create or change a database.
Ayurvedic batch traceability path
Proposed lineage from supply origin to the customer destination, where identifiable.
From a finished batch to the production order, exact formula version, consumed raw-material lots, supplier, receipt and inspection records.
From an input lot to affected output batches, warehouse balances, transfers, invoices and recorded customers where customer identity exists.
Integrity rules in the proposal
Historical transactions should remain explainable.
Balance summaries are derived or reconcilable to posted quantity movements; reservations remain distinct from physical stock.
Correct through linked reversals or controlled amendments, never silent edits to posted stock or financial activity.
A production order references the approved formula version used at the time, even after a later formula is created.
Proposed logical relationships
Illustrative only; cardinality and physical implementation require review.