| SchemaSpy Analysis of idempiere11.adempiereTax | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:56 +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 |
|---|---|---|---|---|---|
| c_acctschema | 3 | 1 | 35 | 2 | Rules for accounting |
| c_allocationhdr | 2 | 2 | 25 | 2 | Payment allocation |
| c_allocationline | 1 | 4 | 24 | 2 | Allocation Line |
| c_bpartner | 6 | 1 | 74 | 18 | Identifies a Business Partner |
| c_charge | 3 | 2 | 18 | 3 | Additional document charges |
| c_country | 5 | 2 | 43 | 251 | Country |
| c_countrygroup | 2 | 15 | 0 | Group of countries that share common needs like tax agreements | |
| c_currency | 6 | 19 | 175 | The Currency for this record | |
| c_invoice | 7 | 6 | 72 | 8 | Invoice Identifier |
| c_invoiceline | 2 | 5 | 51 | 24 | Invoice Detail Line |
| c_invoicetax | 3 | 15 | 8 | C_InvoiceTax | |
| c_location | 2 | 2 | 26 | 34 | Location or Address |
| c_region | 3 | 1 | 13 | 399 | Identifies a geographical Region |
| c_tax | 7 | 9 | 32 | 6 | Tax identifier |
| c_tax_acct | 2 | 15 | 12 | C_Tax_Acct | |
| c_taxcategory | 3 | 13 | 1 | Tax Category | |
| c_taxdeclaration | 2 | 16 | 0 | Define the declaration to the tax authorities | |
| c_taxdeclarationacct | 3 | 14 | 0 | Tax Accounting Reconciliation | |
| c_taxdeclarationline | 7 | 22 | 0 | Tax Declaration Document Information | |
| c_taxpostal | 1 | 12 | 0 | Tax Postal/ZIP | |
| c_taxprovider | 2 | 1 | 16 | 0 | Tax Provider |
| c_taxprovidercfg | 1 | 13 | 0 | Tax Provider Configuration | |
| fact_acct | 1 | 7 | 47 | 0 | Accounting Fact |
| m_product | 2 | 1 | 72 | 55 | Product Service Item |
| 24 Tables | 702 | 1.000 | |||
| 0 Views | 0 |