SchemaSpy Analysis of idempiere9.adempiereImport Export Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:48 +0100
Database Type: PostgreSQL - 9.6.24

XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Rows Comments
ad_column 3 1 56 25,432 Column in the table
ad_impformat 1 15 15 Import Format
ad_impformat_row 2 23 163 Format Field
ad_importtemplate 3 16 0 Import Template
ad_org 52 13 10 Organizational entity within client
ad_user 21 10 68 8 User within the system - Internal or Business Partner Contact
c_acctschema 6 4 35 2 Rules for accounting
c_activity 14 14 0 Business Activity
c_bankaccount 5 1 22 3 Account at the Bank
c_bankstatement 2 1 31 2 Bank Statement of account
c_bankstatementline 1 6 42 2 Line on a statement from this Bank
c_bp_group 2 2 23 3 Business Partner Group
c_bpartner 31 10 74 17 Identifies a Business Partner
c_bpartner_location 13 4 23 13 Identifies the (ship to) address for this Business Partner
c_campaign 16 17 2 Marketing Campaign
c_charge 12 1 18 3 Additional document charges
c_conversion_rate 1 4 16 4 Rate used for converting currencies
c_conversiontype 9 13 4 Currency Conversion Rate Type
c_country 8 3 43 251 Country
c_currency 29 1 19 175 The Currency for this record
c_doctype 19 5 42 52 Document type or rules
c_element 2 1 16 1 Accounting Element
c_elementvalue 28 4 30 379 Account Element
c_greeting 3 13 1 Greeting to print on correspondence
c_invoice 10 23 71 8 Invoice Identifier
c_invoiceline 3 16 51 24 Invoice Detail Line
c_invoicetax 2 15 8 C_InvoiceTax
c_location 16 3 26 29 Location or Address
c_order 8 32 92 8 Order
c_orderline 4 21 59 27 Sales Order Line
c_ordertax 2 15 8 Order Tax
c_payment 7 17 101 2 Payment identifier
c_paymentterm 7 30 5 The terms for Payment of this transaction
c_period 5 1 16 264 Period of the Calendar
c_project 14 12 48 2 Financial Project
c_region 6 2 13 399 Identifies a geographical Region
c_salesregion 6 1 15 2 Sales coverage region
c_tax 7 5 31 6 Tax identifier
c_uom 11 1 17 15 Unit of Measure
c_validcombination 7 14 29 154 Valid Account Combination
exp_format 2 19 10 Export Format
exp_formatline 3 21 43 Format Line
exp_processor_type 14 2 Export Processor Type
exp_processorparameter 15 7 Processor Parameter
gl_budget 4 13 1 General Ledger Budget
gl_category 5 14 10 General Ledger Category
gl_journal 4 9 36 1 General Ledger Journal
gl_journalbatch 4 5 28 1 General Ledger Journal Batch
gl_journalline 2 19 43 2 General Ledger Journal Line
i_asset 10 83 0 Asset
i_bankstatement 8 60 0 Import of the Bank Statement
i_bpartner 8 51 0 Import Business Partner
i_conversion_rate 4 25 2 Import Currency Conversion Rate
i_elementvalue 4 31 0 Import Account Value
i_fajournal 24 72 0 FA Journal
i_fixedasset 6 54 0 Imported Fixed Asset
i_gljournal 26 70 0 Import General Ledger Journal
i_inoutlineconfirm 1 19 0 Material Shipment or Receipt Confirmation Import Line
i_inventory 8 38 0 Import Inventory Transactions
i_invoice 21 64 0 Import Invoice
i_movement 10 44 0 I_Movement_ID
i_order 25 68 0 Import Orders
i_payment 7 71 0 Import Payment
i_pricelist 5 34 0 Import Price List and Versions
i_product 5 58 0 Import Item or Service
i_reportline 4 30 0 Import Report Line Set values
imp_processor_type 14 2 Import Processor Type
imp_processorlog 17 0 Import Processor Log
imp_processorparameter 15 6 Import Processor Parameter
m_attributesetinstance 5 15 4 Product Attribute Set Instance
m_inoutlineconfirm 1 2 20 1 Material Shipment or Receipt Confirmation Line
m_inventory 3 12 35 3 Parameters for a Physical Inventory
m_inventoryline 4 6 25 1 Unique line in an Inventory document
m_locator 8 2 17 11 Warehouse Locator
m_pricelist 10 2 20 3 Unique identifier of a Price List
m_product 17 6 72 55 Product Service Item
m_product_category 3 1 19 14 Category of a Product
m_product_po 5 32 29 Product Purchasing
m_shipper 4 1 14 3 Method or manner of product delivery
m_warehouse 8 4 19 11 Storage Warehouse and Service Point
pa_reportline 5 5 29 113 Report Line
pa_reportlineset 2 12 3 Report Line Set
pa_reportsource 1 11 36 93 Restriction of what will be shown in Report Line
r_interestarea 1 13 2 Interest Area or Topic
s_resourceassignment 2 16 2 Resource Assignment
           
85 Tables     2,826 27,938  
0 Views     0