| SchemaSpy Analysis of idempiere11.adempiereOrder Management | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:52 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_user | 15 | 4 | 69 | 9 | User within the system - Internal or Business Partner Contact |
| c_bp_shippingacct | 1 | 3 | 15 | 0 | Business Partner Shipping Account |
| c_bpartner | 20 | 6 | 74 | 18 | Identifies a Business Partner |
| c_bpartner_location | 15 | 1 | 23 | 16 | Identifies the (ship to) address for this Business Partner |
| c_charge | 3 | 2 | 18 | 3 | Additional document charges |
| c_order | 9 | 23 | 92 | 8 | Order |
| c_orderline | 2 | 11 | 59 | 27 | Sales Order Line |
| c_orderpayschedule | 1 | 18 | 0 | Order Payment Schedule | |
| c_ordersource | 1 | 2 | 13 | 0 | Order Source |
| c_ordertax | 2 | 15 | 8 | Order Tax | |
| c_payment | 4 | 7 | 102 | 2 | Payment identifier |
| c_paymentterm | 4 | 30 | 5 | The terms for Payment of this transaction | |
| c_pospayment | 3 | 30 | 0 | POS Payment | |
| c_postendertype | 2 | 16 | 0 | POS Tender Type | |
| c_project | 3 | 8 | 48 | 2 | Financial Project |
| c_revenuerecognition | 1 | 15 | 2 | Method for recording revenue | |
| c_servicelevel | 1 | 1 | 16 | 0 | Product Revenue Recognition Service Level |
| c_servicelevelline | 1 | 14 | 0 | Product Revenue Recognition Service Level Line | |
| c_tax | 4 | 2 | 32 | 6 | Tax identifier |
| c_taxcategory | 3 | 13 | 1 | Tax Category | |
| m_commodityshipment | 1 | 14 | 0 | Commodity Shipment | |
| m_distributionlist | 3 | 14 | 1 | Distribution Lists allow to distribute products to a selected list of partners | |
| m_distributionlistline | 1 | 3 | 15 | 3 | Distribution List Line with Business Partner and Quantity/Percentage |
| m_distributionrun | 2 | 2 | 15 | 1 | Distribution Run create Orders to distribute products to a selected list of partners |
| m_distributionrunline | 1 | 3 | 16 | 1 | Distribution Run Lines define Distribution List, the Product and Quantiries |
| m_pricelist | 5 | 1 | 20 | 4 | Unique identifier of a Price List |
| m_pricelist_version | 4 | 2 | 16 | 6 | Identifies a unique instance of a Price List |
| m_product | 7 | 3 | 72 | 55 | Product Service Item |
| m_productprice | 2 | 14 | 114 | Product Price | |
| m_productpricevendorbreak | 3 | 16 | 0 | Product Price Break | |
| m_rmatax | 1 | 15 | 0 | Return Material Authorization Tax | |
| m_rmatype | 12 | 1 | Return Material Authorization Type | ||
| m_shipper | 6 | 3 | 14 | 3 | Method or manner of product delivery |
| m_shippercfg | 4 | 1 | 19 | 1 | Method or manner of product delivery |
| m_shipperlabels | 1 | 2 | 14 | 0 | Shipper Labels |
| m_shipperlabelscfg | 1 | 1 | 17 | 0 | Shipper Labels Configuration |
| m_shipperpackaging | 1 | 2 | 14 | 0 | Shipper Packaging |
| m_shipperpackagingcfg | 1 | 1 | 15 | 0 | Shipper Packaging Configuration |
| m_shipperpickuptypes | 1 | 2 | 13 | 0 | Shipper Pickup Types |
| m_shipperpickuptypescfg | 1 | 1 | 14 | 0 | Shipper Pickup Types Configuration |
| m_shippingprocessor | 3 | 1 | 14 | 1 | Shipping Processor |
| m_shippingprocessorcfg | 2 | 19 | 1 | Shipping Processor Configuration | |
| m_shippingtransaction | 1 | 17 | 89 | 0 | Shipping Transaction |
| m_shippingtransactionline | 1 | 23 | 0 | Shipping Transaction Line | |
| m_warehouse | 5 | 1 | 19 | 11 | Storage Warehouse and Service Point |
| t_distributionrundetail | 7 | 18 | 0 | T_DistributionRunDetail | |
| 46 Tables | 1.253 | 310 | |||
| 0 Views | 0 |