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