| SchemaSpy Analysis of idempiere9.adempiereAccounting Dimensions | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:44 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
XML Representation Insertion Order Deletion Order |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_client | 8 | 40 | 2 | Client/Tenant for this installation. | |
| ad_org | 28 | 1 | 13 | 10 | Organizational entity within client |
| ad_orginfo | 4 | 26 | 10 | Organization Info | |
| ad_orgtype | 1 | 1 | 12 | 3 | Organization Type allows you to categorize your organizations |
| ad_printcolor | 4 | 12 | 20 | 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 | 17 | 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 | 29 | 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 | 154 | 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 | 77 | 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 | 40 | 0 | Plan for producing a product |
| 27 Tables | 896 | 720 | |||
| 1 View | 31 |