| SchemaSpy Analysis of idempiere11.adempiereInvoice 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 | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_org | 19 | 13 | 10 | Organizational entity within client | |
| c_activity | 7 | 14 | 0 | Business Activity | |
| c_bpartner | 11 | 8 | 74 | 18 | Identifies a Business Partner |
| c_bpartner_location | 6 | 2 | 23 | 16 | Identifies the (ship to) address for this Business Partner |
| c_campaign | 6 | 17 | 2 | Marketing Campaign | |
| c_charge | 6 | 2 | 18 | 3 | Additional document charges |
| c_chargetype | 2 | 13 | 0 | Charge Type | |
| c_chargetype_doctype | 1 | 12 | 0 | Configuration table for charges to be used by document type | |
| c_invoice | 9 | 14 | 72 | 8 | Invoice Identifier |
| c_invoicebatch | 1 | 20 | 0 | Expense Invoice Batch Header | |
| c_invoicebatchline | 11 | 35 | 0 | Expense Invoice Batch Line | |
| c_invoiceline | 5 | 11 | 51 | 24 | Invoice Detail Line |
| c_invoicepayschedule | 2 | 18 | 2 | Invoice Payment Schedule | |
| c_invoiceschedule | 1 | 20 | 1 | Schedule for generating Invoices | |
| c_invoicetax | 2 | 15 | 8 | C_InvoiceTax | |
| c_landedcost | 4 | 16 | 0 | Landed Cost | |
| c_landedcostallocation | 3 | 16 | 0 | Landed Cost Allocation | |
| c_payment | 3 | 10 | 102 | 2 | Payment identifier |
| c_paymentterm | 5 | 30 | 5 | The terms for Payment of this transaction | |
| c_payschedule | 1 | 1 | 17 | 2 | Payment Schedule Template |
| c_project | 6 | 8 | 48 | 2 | Financial Project |
| c_revenuerecog_service | 1 | 2 | 13 | 0 | Plan for recognizing or recording revenue based on service |
| c_revenuerecognition | 3 | 15 | 2 | Method for recording revenue | |
| c_revenuerecognition_plan | 2 | 2 | 17 | 0 | Plan for recognizing or recording revenue |
| c_revenuerecognition_run | 2 | 14 | 0 | Revenue Recognition Run or Process | |
| c_servicelevel | 1 | 2 | 16 | 0 | Product Revenue Recognition Service Level |
| c_servicelevelline | 1 | 14 | 0 | Product Revenue Recognition Service Level Line | |
| c_tax | 4 | 1 | 32 | 6 | Tax identifier |
| m_inout | 4 | 15 | 78 | 9 | Material Shipment Document |
| m_inoutline | 5 | 10 | 40 | 27 | Line on Shipment or Receipt document |
| m_pricelist | 4 | 1 | 20 | 4 | Unique identifier of a Price List |
| m_product | 5 | 2 | 72 | 55 | Product Service Item |
| 32 Tables | 975 | 206 | |||
| 0 Views | 0 |