| SchemaSpy Analysis of idempiere11.adempierePurchasing | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:54 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_org | 15 | 13 | 10 | Organizational entity within client | |
| c_activity | 6 | 14 | 0 | Business Activity | |
| c_campaign | 6 | 17 | 2 | Marketing Campaign | |
| c_elementvalue | 10 | 1 | 30 | 379 | Account Element |
| c_invoice | 4 | 11 | 72 | 8 | Invoice Identifier |
| c_invoiceline | 3 | 14 | 51 | 24 | Invoice Detail Line |
| c_order | 6 | 10 | 92 | 8 | Order |
| c_orderline | 6 | 13 | 59 | 27 | Sales Order Line |
| c_project | 6 | 4 | 48 | 2 | Financial Project |
| c_projectphase | 4 | 3 | 27 | 0 | Phase of a Project |
| c_projecttask | 3 | 2 | 20 | 0 | Actual Project Task in a Phase |
| m_inoutline | 5 | 13 | 40 | 27 | Line on Shipment or Receipt document |
| m_matchinv | 2 | 5 | 24 | 18 | Match Shipment/Receipt to Invoice |
| m_matchpo | 2 | 6 | 27 | 37 | Match Purchase Order to Shipment/Receipt and Invoice |
| m_product | 9 | 1 | 72 | 55 | Product Service Item |
| m_product_po | 2 | 32 | 29 | Product Purchasing | |
| m_requisition | 1 | 27 | 1 | Material Requisition | |
| m_requisitionline | 3 | 21 | 1 | Material Requisition Line | |
| 18 Tables | 686 | 628 | |||
| 0 Views | 0 |