| SchemaSpy Analysis of idempiere11.adempiereMaterial Management | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:51 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| c_charge | 4 | 18 | 3 | Additional document charges | |
| c_doctype | 10 | 4 | 42 | 52 | Document type or rules |
| c_projectissue | 4 | 5 | 27 | 0 | Project Issues (Material, Labor) |
| c_projectissuema | 2 | 11 | 0 | C_ProjectIssueMA | |
| c_uom | 5 | 17 | 15 | Unit of Measure | |
| c_uom_conversion | 3 | 14 | 1 | Unit of Measure Conversion | |
| m_attributesetinstance | 19 | 15 | 4 | Product Attribute Set Instance | |
| m_inout | 3 | 6 | 78 | 9 | Material Shipment Document |
| m_inoutline | 9 | 8 | 40 | 27 | Line on Shipment or Receipt document |
| m_inoutlinema | 2 | 13 | 0 | M_InOutLineMA | |
| m_inoutlinema_returned | 14 | view | M_InOutLineMA_Returned | ||
| m_inventory | 2 | 4 | 35 | 3 | Parameters for a Physical Inventory |
| m_inventoryline | 6 | 6 | 25 | 1 | Unique line in an Inventory document |
| m_inventorylinema | 2 | 13 | 0 | M_InventoryLineMA | |
| m_locator | 14 | 2 | 17 | 11 | Warehouse Locator |
| m_locatortype | 1 | 15 | 0 | Locator Type | |
| m_movement | 2 | 6 | 47 | 1 | Movement of Inventory |
| m_movementline | 4 | 7 | 24 | 1 | Inventory Move document Line |
| m_movementlinema | 2 | 13 | 0 | M_MovementLineMA | |
| m_parttype | 1 | 11 | 0 | Manufacturing part type | |
| m_perpetualinv | 1 | 2 | 20 | 0 | Rules for generating physical inventory |
| m_pricelist | 2 | 1 | 20 | 4 | Unique identifier of a Price List |
| m_pricelist_version | 3 | 2 | 16 | 6 | Identifies a unique instance of a Price List |
| m_product | 23 | 5 | 72 | 55 | Product Service Item |
| m_product_bom | 15 | view | BOM Line | ||
| m_product_category | 3 | 1 | 19 | 14 | Category of a Product |
| m_product_po | 2 | 32 | 29 | Product Purchasing | |
| m_product_qualitytest | 2 | 12 | 0 | Product Quality Test | |
| m_production | 3 | 5 | 41 | 0 | Plan for producing a product |
| m_productionline | 5 | 5 | 21 | 0 | Document Line representing a production |
| m_productionlinema | 2 | 12 | 0 | Production Line MA | |
| m_productionplan | 1 | 3 | 16 | 0 | Plan for how a product is produced |
| m_productprice | 2 | 14 | 114 | Product Price | |
| m_productpricevendorbreak | 2 | 16 | 0 | Product Price Break | |
| m_qualitytest | 2 | 12 | 0 | Quality Test | |
| m_qualitytestresult | 2 | 14 | 0 | Quality Test Result | |
| m_replenish | 4 | 16 | 19 | M_Replenish | |
| m_shipper | 2 | 14 | 3 | Method or manner of product delivery | |
| m_storage | 16 | view | M_Storage | ||
| m_storageonhand | 3 | 14 | 20 | M_StorageOnHand | |
| m_storagereservation | 3 | 14 | 2 | M_StorageReservation | |
| m_storagereservationlog | 4 | 21 | 0 | Log for every storage reservation quantity change | |
| m_substitute | 2 | 12 | 0 | M_Substitute | |
| m_transaction | 3 | 8 | 21 | 28 | Inventory Transaction |
| m_transactionallocation | 10 | 22 | 0 | M_TransactionAllocation | |
| m_warehouse | 13 | 2 | 19 | 11 | Storage Warehouse and Service Point |
| qm_specification | 1 | 1 | 18 | 0 | Quality Specification |
| qm_specificationline | 1 | 17 | 0 | QM Specification Line | |
| t_replenish | 4 | 21 | 0 | T_Replenish | |
| t_transaction | 9 | 29 | 0 | T_Transaction | |
| 47 Tables | 1.050 | 433 | |||
| 3 Views | 45 |