Useful Join Map
traders.id + traders.tradertype -> orders/invoices/shipments traderid + tradertype
Customers and suppliers both live in traders. C = customer, S = supplier.
traders -> tradersaddresses
Addresses are keyed by traderid, tradertype and addressid with invoice/delivery/main flags.
traderscontacts -> contactcommunications
Email and phone values are stored as communication method rows, not fixed columns.
allpartmaster.partnum -> bom/bom_viewtouse bomparent and bomchild
Part master to BOM parent/child relationships.
allpartmaster.partnum -> routingoperations.partid
Part master to routing operations.
orders_composite.id + ordertype -> orderitems_composite.orderid + ordertype
Order headers to order lines.
invoices.id + invoicetype -> invoiceitems.invoiceid + invoicetype
Invoice headers to invoice lines.
shipments.id + shipmenttype -> shipmentitems.shipmentid + shipmenttype
Shipment headers to shipment lines.