SchemaSpy Analysis of idempiere11.adempiereImport Export | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:48 +0100 | |
Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
Table | Children | Parents | Columns | Rows | Comments |
---|---|---|---|---|---|
ad_column | 3 | 1 | 63 | 25.928 | 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 | 69 | 9 | 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 | 2 | 33 | 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 | 18 | Identifies a Business Partner |
c_bpartner_location | 13 | 4 | 23 | 16 | 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 | 20 | 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 | 72 | 8 | Invoice Identifier |
c_invoiceline | 3 | 16 | 51 | 24 | Invoice Detail Line |
c_invoicetax | 2 | 15 | 8 | C_InvoiceTax | |
c_location | 16 | 3 | 26 | 34 | 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 | 102 | 2 | Payment identifier |
c_paymentterm | 7 | 30 | 5 | The terms for Payment of this transaction | |
c_period | 5 | 1 | 16 | 360 | 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 | 32 | 6 | Tax identifier |
c_uom | 11 | 1 | 17 | 15 | Unit of Measure |
c_validcombination | 7 | 14 | 29 | 157 | 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 | 16 | 10 | General Ledger Category | |
gl_journal | 4 | 9 | 36 | 2 | General Ledger Journal |
gl_journalbatch | 4 | 5 | 28 | 1 | General Ledger Journal Batch |
gl_journalline | 2 | 19 | 43 | 4 | 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 | 59 | 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 | 4 | 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 | 31 | 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.844 | 28.547 | |||
0 Views | 0 |