| SchemaSpy Analysis of idempiere9.adempiereCosting | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:46 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
XML Representation Insertion Order Deletion Order |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| c_acctschema | 6 | 1 | 35 | 2 | Rules for accounting |
| c_allocationline | 2 | 23 | 3 | Allocation Line | |
| c_invoice | 6 | 4 | 71 | 8 | Invoice Identifier |
| c_invoiceline | 6 | 6 | 51 | 24 | Invoice Detail Line |
| c_landedcost | 5 | 16 | 0 | Landed Cost | |
| c_landedcostallocation | 5 | 16 | 0 | Landed Cost Allocation | |
| c_order | 8 | 4 | 92 | 8 | Order |
| c_orderlandedcost | 1 | 2 | 15 | 0 | Estimated Landed Cost for Purchase Order |
| c_orderlandedcostallocation | 2 | 15 | 0 | Estimate landed cost allocation for order line | |
| c_orderline | 7 | 6 | 59 | 27 | Sales Order Line |
| c_projectissue | 4 | 5 | 27 | 0 | Project Issues (Material, Labor) |
| c_projectissuema | 2 | 11 | 0 | C_ProjectIssueMA | |
| m_attributesetinstance | 23 | 15 | 4 | Product Attribute Set Instance | |
| m_cost | 5 | 23 | 267 | Product Cost | |
| m_costdetail | 1 | 12 | 33 | 0 | Cost Detail Information |
| m_costelement | 8 | 14 | 9 | Cost Element | |
| m_costhistory | 4 | 21 | 0 | Movement history for M_Cost | |
| m_costmovement_v | 35 | view | Cost movement for M_Cost | ||
| m_costqueue | 5 | 16 | 0 | FiFo/LiFo Cost Queue | |
| m_costtype | 4 | 12 | 1 | Type of Cost | |
| m_inout | 4 | 5 | 77 | 9 | Material Shipment Document |
| m_inoutline | 11 | 7 | 40 | 27 | Line on Shipment or Receipt document |
| m_inoutlinema | 2 | 13 | 0 | M_InOutLineMA | |
| m_inventoryline | 4 | 4 | 25 | 1 | Unique line in an Inventory document |
| m_inventorylinema | 2 | 13 | 0 | M_InventoryLineMA | |
| m_locator | 9 | 1 | 17 | 11 | Warehouse Locator |
| m_matchinv | 3 | 6 | 24 | 18 | Match Shipment/Receipt to Invoice |
| m_matchpo | 2 | 7 | 27 | 37 | Match Purchase Order to Shipment/Receipt and Invoice |
| m_movementline | 4 | 6 | 24 | 1 | Inventory Move document Line |
| m_movementlinema | 2 | 13 | 0 | M_MovementLineMA | |
| m_product | 18 | 4 | 72 | 55 | Product Service Item |
| m_product_acct | 2 | 34 | 110 | Product Acct | |
| m_product_category | 3 | 1 | 19 | 14 | Category of a Product |
| m_product_category_acct | 2 | 37 | 28 | Product Category Acct | |
| m_product_po | 1 | 32 | 29 | Product Purchasing | |
| m_productionline | 3 | 3 | 21 | 0 | Document Line representing a production |
| m_productionlinema | 2 | 12 | 0 | Production Line MA | |
| m_transaction | 8 | 21 | 28 | Inventory Transaction | |
| m_warehouse | 8 | 2 | 19 | 11 | Storage Warehouse and Service Point |
| m_warehouse_acct | 2 | 14 | 22 | M_Warehouse_Acct | |
| s_resource | 1 | 1 | 24 | 11 | Resource |
| t_inventoryvalue | 4 | 24 | 0 | T_InventoryValue | |
| 41 Tables | 1,167 | 765 | |||
| 1 View | 35 |