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