| 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 |