| SchemaSpy Analysis of idempiere11.adempierePrinting Documents | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:53 +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_dunning_header_v | 289 | view | Dunning Letter | ||
| c_dunning_line_v | 163 | view | Dunning Letter Lines | ||
| c_dunningrun | 1 | 16 | 0 | Dunning Run | |
| c_dunningrunentry | 1 | 1 | 20 | 0 | Dunning Run Entry |
| c_dunningrunline | 2 | 23 | 0 | Dunning Run Line | |
| c_invoice | 8 | 5 | 72 | 8 | Invoice Identifier |
| c_invoice_header_v | 330 | view | Invoice Print View | ||
| c_invoice_header_vt | 330 | view | C_Invoice_Header_vt | ||
| c_invoice_linetax_v | 244 | view | Invoice Print View | ||
| c_invoice_linetax_vt | 244 | view | C_Invoice_LineTax_vt | ||
| c_invoiceline | 2 | 5 | 51 | 24 | Invoice Detail Line |
| c_invoicetax | 1 | 15 | 8 | C_InvoiceTax | |
| c_order | 9 | 4 | 92 | 8 | Order |
| c_order_header_v | 473 | view | Order Print View | ||
| c_order_header_vt | 473 | view | C_Order_Header_vt | ||
| c_order_linetax_v | 378 | view | Order Print View | ||
| c_order_linetax_vt | 378 | view | C_Order_LineTax_vt | ||
| c_orderline | 6 | 4 | 59 | 27 | Sales Order Line |
| c_ordertax | 1 | 15 | 8 | Order Tax | |
| c_payselection | 2 | 20 | 1 | Payment Selection | |
| c_payselection_check_v | 202 | view | Check Print View | ||
| c_payselection_check_vt | 202 | view | C_PaySelection_Check_vt | ||
| c_payselection_remittance_v | 79 | view | Checl/Remittance View | ||
| c_payselection_remittance_vt | 79 | view | C_PaySelection_Remittance_vt | ||
| c_payselectioncheck | 1 | 1 | 23 | 1 | Payment Selection Check |
| c_payselectionline | 3 | 23 | 1 | Payment Selection Line | |
| c_project | 10 | 48 | 2 | Financial Project | |
| c_projectline | 4 | 31 | 1 | Task or step in a project | |
| m_inout | 3 | 5 | 78 | 9 | Material Shipment Document |
| m_inout_header_v | 236 | view | Shipment Print View | ||
| m_inout_header_vt | 236 | view | M_InOut_Header_vt | ||
| m_inout_line_v | 191 | view | Shipment Print View | ||
| m_inout_line_vt | 191 | view | M_InOut_Line_vt | ||
| m_inoutline | 4 | 5 | 40 | 27 | Line on Shipment or Receipt document |
| m_inventory | 2 | 2 | 35 | 3 | Parameters for a Physical Inventory |
| m_inventoryline | 1 | 2 | 25 | 1 | Unique line in an Inventory document |
| m_production | 4 | 4 | 41 | 0 | Plan for producing a product |
| m_productionline | 2 | 21 | 0 | Document Line representing a production | |
| m_productionplan | 1 | 1 | 16 | 0 | Plan for how a product is produced |
| s_timeexpense | 1 | 21 | 1 | Time and Expense Report | |
| s_timeexpenseline | 4 | 39 | 4 | Time and Expense Report Line | |
| 23 Tables | 824 | 134 | |||
| 18 Views | 4.718 |