ERP
1,473
Source rows at Day-0
97
Populated tables
132
Exported tables
Collections
Customers & Suppliers
Products & Inventory
Items6
The item master: what is bought, made, stocked and sold.
Inventory Movements43
The movement ledger inventory balances are derived from — receipts, issues, transfers, returns and adjustments.
Inventory Balances12
On-hand and reserved stock by item, warehouse, location, lot and inventory status — derived from the movement ledger, never written directly.
Sales
Sales Orders10
ERP sales orders by channel and customer. Status codes are shown as ERP stores them.
Deliveries5
Outbound deliveries against sales orders.
Customer Invoices1
Receivables ERP has raised.
Customer Receipts2
Cash received from customers, and the invoices it settled.
Credit Notes1
Credits granted to customers against an original invoice.
Sales Returns1
Goods customers returned against a sales order.
Procurement
Purchase Requisitions11
Internal requests to buy, before a purchase order.
Purchase Orders10
Orders placed with suppliers.
Goods Receipts10
Goods received against purchase orders.
Supplier Invoices12
Payables from suppliers, and how each matched its purchase order.
Supplier Payments6
Payments to suppliers, and the invoices each settled.
Manufacturing & Quality
Finance
Assets
Administration
Representative records
What these records become
Invoice ×14 · Purchase Order ×10 · Sales Order ×10 · Organization ×8 · Payment ×8 · Product ×6 · Production Order ×4 · Asset ×2
Canonical records projected from ERP source records. A source record's own page links to the canonical record it resolves or projects to.
Cross-system journeys
Technical schema — 132 exported tables in erp_src
- audit_event292
- erp_accounting_period24
- erp_accrual0
- erp_address3
- erp_ap_match8
- erp_ap_open_item7
- erp_approval_action31
- erp_approval_request28
- erp_approval_rule12
- erp_ar_open_item2
- erp_asset_category4
- erp_asset_transaction7
- erp_backorder1
- erp_bank_account1
- erp_bank_reconciliation0
- erp_bank_statement0
- erp_bank_statement_line0
- erp_bank_transaction6
- erp_bom2
- erp_bom_component4
- erp_brand1
- erp_close_calendar0
- erp_close_exception0
- erp_close_task0
- erp_cogs_detail0
- erp_cost_center3
- erp_cost_component0
- erp_cost_rollup0
- erp_currency3
- erp_customer6
- erp_customer_credit_note1
- erp_customer_credit_note_line1
- erp_customer_debit_note0
- erp_customer_invoice1
- erp_customer_invoice_line2
- erp_customer_receipt2
- erp_customer_receipt_allocation2
- erp_customer_site2
- erp_delivery5
- erp_delivery_line6
- erp_depreciation_detail0
- erp_depreciation_run0
- erp_document_sequence25
- erp_employee_ref3
- erp_exchange_rate0
- erp_fixed_asset2
- erp_franchise_ref0
- erp_gl_account34
- erp_gl_journal49
- erp_gl_journal_line115
- erp_goods_receipt10
- erp_goods_receipt_line10
- erp_inventory_adjustment1
- erp_inventory_balance12
- erp_inventory_lot3
- erp_inventory_movement43
- erp_inventory_reservation6
- erp_inventory_valuation_snapshot0
- erp_item6
- erp_item_category5
- erp_item_cost0
- erp_item_uom0
- erp_ledger1
- erp_legal_entity1
- erp_material_issue4
- erp_material_issue_line6
- erp_material_return1
- erp_material_return_line1
- erp_mrp_recommendation0
- erp_mrp_run0
- erp_operating_unit1
- erp_payment_term6
- erp_payroll_import1
- erp_planning_parameter0
- erp_plant1
- erp_posting_rule45
- erp_price_list0
- erp_price_list_line0
- erp_production_component8
- erp_production_operation11
- erp_production_order4
- erp_production_receipt2
- erp_production_receipt_line2
- erp_profit_center0
- erp_purchase_order10
- erp_purchase_order_line10
- erp_purchase_requisition11
- erp_purchase_requisition_line11
- erp_quality_disposition4
- erp_quality_hold4
- erp_quality_inspection3
- erp_quality_result4
- erp_reconciliation0
- erp_reference_code0
- erp_role20
- erp_routing2
- erp_routing_operation5
- erp_sales_discount0
- erp_sales_order10
- erp_sales_order_line11
- erp_sales_return1
- erp_sales_return_line1
- erp_seed_run0
- erp_service_category1
- erp_shipment5
- erp_simulation_run0
- erp_stock_count0
- erp_stock_count_line0
- erp_stock_transfer2
- erp_stock_transfer_line2
- erp_storage_location2
- erp_store_ref2
- erp_supplier2
- erp_supplier_credit_note0
- erp_supplier_invoice12
- erp_supplier_invoice_line13
- erp_supplier_item0
- erp_supplier_payment6
- erp_supplier_payment_allocation6
- erp_supplier_return2
- erp_supplier_return_line0
- erp_supplier_site1
- erp_system_setting6
- erp_tax_code5
- erp_trial_balance_snapshot0
- erp_uom8
- erp_user21
- erp_user_role22
- erp_warehouse2
- erp_work_center1
- idempotency_key289
- outbox_event70