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