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