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