| SchemaSpy Analysis of idempiere11.adempiereCommon Application | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:47 +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 | 1 | 2 | 35 | 2 | Rules for accounting |
| c_activity | 2 | 14 | 0 | Business Activity | |
| c_bank | 2 | 1 | 15 | 2 | Bank |
| c_bankaccount | 1 | 2 | 22 | 3 | Account at the Bank |
| c_bp_bankaccount | 2 | 36 | 1 | Bank Account of the Business Partner | |
| c_bp_withholding | 2 | 13 | 0 | C_BP_Withholding | |
| c_bpartner | 8 | 4 | 74 | 18 | Identifies a Business Partner |
| c_bpartner_location | 1 | 3 | 23 | 16 | Identifies the (ship to) address for this Business Partner |
| c_calendar | 2 | 11 | 1 | Accounting Calendar Name | |
| c_campaign | 2 | 1 | 17 | 2 | Marketing Campaign |
| c_channel | 1 | 12 | 2 | Sales Channel | |
| c_city | 1 | 2 | 16 | 1 | City |
| c_conversion_rate | 2 | 16 | 4 | Rate used for converting currencies | |
| c_country | 8 | 2 | 43 | 251 | Country |
| c_countrygroup | 3 | 15 | 0 | Group of countries that share common needs like tax agreements | |
| c_countrygroupcountry | 2 | 13 | 0 | Country on Country Group | |
| c_currency | 7 | 19 | 175 | The Currency for this record | |
| c_docbasegroup | 1 | 12 | 0 | Group of Document Base Type for Period Control | |
| c_docbasegroupline | 1 | 11 | 0 | Line Items of a Document Base Type Group | |
| c_doctype | 6 | 4 | 42 | 52 | Document type or rules |
| c_doctypecounter | 2 | 17 | 1 | Counter Document Relationship | |
| c_dunning | 1 | 14 | 2 | Dunning Rules for overdue invoices | |
| c_element | 1 | 16 | 1 | Accounting Element | |
| c_elementvalue | 3 | 3 | 30 | 379 | Account Element |
| c_location | 5 | 3 | 26 | 34 | Location or Address |
| c_nonbusinessday | 2 | 13 | 1 | Day on which business is not transacted | |
| c_paymentterm | 4 | 30 | 5 | The terms for Payment of this transaction | |
| c_period | 2 | 1 | 16 | 360 | Period of the Calendar |
| c_periodcontrol | 1 | 14 | 10.464 | Period Control | |
| c_project | 1 | 8 | 48 | 2 | Financial Project |
| c_region | 4 | 1 | 13 | 399 | Identifies a geographical Region |
| c_salesregion | 2 | 15 | 2 | Sales coverage region | |
| c_tax | 1 | 8 | 32 | 6 | Tax identifier |
| c_taxcategory | 2 | 13 | 1 | Tax Category | |
| c_uom | 3 | 17 | 15 | Unit of Measure | |
| c_uom_conversion | 3 | 14 | 1 | Unit of Measure Conversion | |
| c_validcombination | 12 | 29 | 157 | Valid Account Combination | |
| c_withholding | 1 | 2 | 23 | 0 | Withholding type defined |
| c_year | 1 | 1 | 13 | 30 | Calendar Year |
| m_product | 2 | 2 | 72 | 55 | Product Service Item |
| m_warehouse | 2 | 2 | 19 | 11 | Storage Warehouse and Service Point |
| 41 Tables | 943 | 12.456 | |||
| 0 Views | 0 |