| SchemaSpy Analysis of idempiere9.adempiereAssets | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:45 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| a_asset_acct | 9 | 50 | 0 | A_Asset_Acct_ID | |
| a_asset_addition | 2 | 6 | 52 | 0 | Asset Addition |
| a_asset_change | 1 | 8 | 79 | 0 | A_Asset_Change_ID |
| a_asset_change_amt | 2 | 13 | 0 | ||
| a_asset_class | 1 | 20 | 0 | Asset class | |
| a_asset_delivery | 3 | 25 | 0 | Delivery of Asset | |
| a_asset_disposed | 1 | 2 | 39 | 0 | Asset Disposed |
| a_asset_group | 4 | 2 | 21 | 9 | Group of Assets |
| a_asset_group_acct | 9 | 53 | 6 | Asset Group Accounting | |
| a_asset_group_trl | 3 | 14 | 9 | Group of Assets | |
| a_asset_info_fin | 1 | 22 | 0 | Asset Info Financial ID | |
| a_asset_info_ins | 17 | 0 | A_Asset_Info_Ins_ID | ||
| a_asset_info_lic | 17 | 0 | A_Asset_Info_Lic_ID | ||
| a_asset_info_oth | 26 | 0 | A_Asset_Info_Oth_ID | ||
| a_asset_info_tax | 16 | 0 | Asset Info Tax | ||
| a_asset_product | 2 | 15 | 0 | Asset Product | |
| a_asset_retirement | 1 | 1 | 13 | 0 | Internally used asset is not longer used. |
| a_asset_reval | 24 | 0 | Asset Revaluation | ||
| a_asset_reval_entry | 3 | 26 | 0 | Asset Reval. Entry | |
| a_asset_reval_index | 13 | 0 | Asset Reval Index | ||
| a_asset_split | 1 | 26 | 0 | Asset Split | |
| a_asset_spread | 1 | 25 | 2 | A_Asset_Spread_ID | |
| a_asset_transfer | 2 | 52 | 0 | A_Asset_Transfer_ID | |
| a_asset_type | 1 | 15 | 0 | Asset Type | |
| a_asset_use | 13 | 0 | A_Asset_Use_ID | ||
| a_depreciation | 4 | 15 | 11 | Depreciation | |
| a_depreciation_build | 1 | 18 | 0 | Build Depreciation | |
| a_depreciation_convention | 4 | 15 | 6 | Depreciation Convention | |
| a_depreciation_entry | 1 | 3 | 27 | 0 | Depreciation Entry |
| a_depreciation_exp | 4 | 38 | 0 | A_Depreciation_Exp_ID | |
| a_depreciation_forecast | 15 | 0 | Depreciation Forecast | ||
| a_depreciation_method | 4 | 14 | 3 | Depreciation Method | |
| a_depreciation_table_detail | 14 | 2,579 | Depreciation Table Detail | ||
| a_depreciation_table_header | 3 | 14 | 122 | A_Depreciation_Table_Header_ID | |
| a_depreciation_workfile | 2 | 45 | 0 | A_Depreciation_Workfile_ID | |
| a_fundingmode | 2 | 12 | 0 | Asset Funding Mode | |
| a_fundingmode_acct | 2 | 11 | 0 | Asset Funding Mode Accounting | |
| ad_user | 8 | 7 | 68 | 8 | User within the system - Internal or Business Partner Contact |
| c_acctschema | 10 | 2 | 35 | 2 | Rules for accounting |
| c_bpartner | 6 | 2 | 74 | 17 | Identifies a Business Partner |
| c_bpartner_location | 2 | 2 | 23 | 13 | Identifies the (ship to) address for this Business Partner |
| c_calendar | 1 | 11 | 1 | Accounting Calendar Name | |
| c_charge | 3 | 1 | 18 | 3 | Additional document charges |
| c_currency | 4 | 19 | 175 | The Currency for this record | |
| c_invoiceline | 4 | 6 | 51 | 24 | Invoice Detail Line |
| c_location | 4 | 26 | 29 | Location or Address | |
| c_period | 7 | 1 | 16 | 264 | Period of the Calendar |
| c_uom | 3 | 17 | 15 | Unit of Measure | |
| c_year | 1 | 1 | 13 | 22 | Calendar Year |
| m_inoutline | 5 | 6 | 40 | 27 | Line on Shipment or Receipt document |
| m_locator | 6 | 17 | 11 | Warehouse Locator | |
| m_movementline | 1 | 4 | 24 | 1 | Inventory Move document Line |
| m_product | 6 | 5 | 72 | 55 | Product Service Item |
| m_product_category | 2 | 2 | 19 | 14 | Category of a Product |
| m_productdownload | 1 | 1 | 12 | 1 | Product downloads |
| r_mailtext | 2 | 15 | 3 | Text templates for mailings | |
| 56 Tables | 1,494 | 3,432 | |||
| 0 Views | 0 |