| SchemaSpy Analysis of idempiere11.adempiereAccounting Dimensions | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:45 +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 |
|---|---|---|---|---|---|
| ad_client | 8 | 42 | 2 | Tenant for this installation. | |
| ad_org | 28 | 1 | 13 | 10 | Organizational entity within client |
| ad_orginfo | 4 | 27 | 10 | Organization Info | |
| ad_orgtype | 1 | 1 | 12 | 3 | Organization Type allows you to categorize your organizations |
| ad_printcolor | 4 | 12 | 23 | Color used for printing and display | |
| c_activity | 10 | 14 | 0 | Business Activity | |
| c_bp_group | 1 | 1 | 23 | 3 | Business Partner Group |
| c_bpartner | 13 | 5 | 74 | 18 | Identifies a Business Partner |
| c_campaign | 10 | 1 | 17 | 2 | Marketing Campaign |
| c_channel | 1 | 1 | 12 | 2 | Sales Channel |
| c_elementvalue | 23 | 2 | 30 | 379 | Account Element |
| c_location | 11 | 2 | 26 | 34 | Location or Address |
| c_project | 10 | 7 | 48 | 2 | Financial Project |
| c_projectphase | 4 | 2 | 27 | 0 | Phase of a Project |
| c_projecttask | 3 | 2 | 20 | 0 | Actual Project Task in a Phase |
| c_salesregion | 5 | 15 | 2 | Sales coverage region | |
| c_validcombination | 14 | 29 | 157 | Valid Account Combination | |
| fact_acct | 16 | 47 | 0 | Accounting Fact | |
| fact_acct_balance | 31 | view | Fact_Acct_Balance | ||
| fact_acct_summary | 14 | 34 | 0 | Accounting Fact summary | |
| gl_distribution | 1 | 14 | 48 | 1 | General Ledger Distribution |
| gl_distributionline | 15 | 39 | 2 | General Ledger Distribution Line | |
| m_inout | 2 | 12 | 78 | 9 | Material Shipment Document |
| m_inventory | 1 | 8 | 35 | 3 | Parameters for a Physical Inventory |
| m_movement | 1 | 9 | 47 | 1 | Movement of Inventory |
| m_product | 8 | 3 | 72 | 55 | Product Service Item |
| m_product_category | 2 | 2 | 19 | 14 | Category of a Product |
| m_production | 1 | 12 | 41 | 0 | Plan for producing a product |
| 27 Tables | 901 | 732 | |||
| 1 View | 31 |