| SchemaSpy Analysis of idempiere9.adempiereCommon Application | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:46 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
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 | 17 | Identifies a Business Partner |
| c_bpartner_location | 1 | 3 | 23 | 13 | 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_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 | 29 | 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 | 264 | Period of the Calendar |
| c_periodcontrol | 1 | 14 | 7,392 | 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 | 31 | 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 | 154 | Valid Account Combination | |
| c_withholding | 1 | 2 | 23 | 0 | Withholding type defined |
| c_year | 1 | 1 | 13 | 22 | Calendar Year |
| m_product | 2 | 2 | 72 | 55 | Product Service Item |
| m_warehouse | 2 | 2 | 19 | 11 | Storage Warehouse and Service Point |
| 39 Tables | 919 | 9,268 | |||
| 0 Views | 0 |