| SchemaSpy Analysis of idempiere9.adempiereRequisition / Demand | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:55 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_user | 10 | 3 | 68 | 8 | User within the system - Internal or Business Partner Contact |
| c_bpartner | 11 | 4 | 74 | 17 | Identifies a Business Partner |
| c_calendar | 3 | 11 | 1 | Accounting Calendar Name | |
| c_cashplan | 1 | 1 | 26 | 0 | Cash Plan |
| c_cashplanline | 1 | 4 | 29 | 0 | Cash Plan Line |
| c_charge | 4 | 1 | 18 | 3 | Additional document charges |
| c_doctype | 7 | 4 | 42 | 52 | Document type or rules |
| c_order | 4 | 17 | 92 | 8 | Order |
| c_orderline | 4 | 7 | 59 | 27 | Sales Order Line |
| c_period | 2 | 1 | 16 | 264 | Period of the Calendar |
| c_year | 3 | 1 | 13 | 22 | Calendar Year |
| m_demand | 1 | 2 | 16 | 0 | Material Demand |
| m_demanddetail | 4 | 13 | 0 | Material Demand Line Source Detail | |
| m_demandline | 1 | 3 | 14 | 0 | Material Demand Line |
| m_forecast | 1 | 3 | 17 | 4 | Material Forecast |
| m_forecastline | 1 | 5 | 17 | 50 | Forecast Line |
| m_pricelist | 6 | 1 | 20 | 3 | Unique identifier of a Price List |
| m_product | 5 | 1 | 72 | 55 | Product Service Item |
| m_requisition | 1 | 4 | 27 | 1 | Material Requisition |
| m_requisitionline | 1 | 5 | 21 | 1 | Material Requisition Line |
| m_warehouse | 5 | 1 | 19 | 11 | Storage Warehouse and Service Point |
| 21 Tables | 684 | 527 | |||
| 0 Views | 0 |