Table idempiere9.adempiere.i_asset
Asset

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
i_asset_id numeric 10 Asset
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
a_accumdepreciation_acct numeric 10  √  null
c_validcombination.c_validcombination_id aaccumdepreciation_iasset R
Accumulated Depreciation Account
a_accumulated_depr numeric 0  √  null Accumulated Depreciation
a_asset_acct numeric 10  √  null
c_validcombination.c_validcombination_id aasset_iasset R
Asset Acct
a_asset_cost numeric 0  √  null Asset Cost
a_asset_group_id numeric 10  √  null
a_asset_group.a_asset_group_id aassetgroup_iasset R
Group of Assets
a_asset_id numeric 10  √  null Asset used internally or by customers
a_asset_life_current_year numeric 10  √  null A_Asset_Life_Current_Year
a_asset_life_years numeric 10  √  null Life Years
a_asset_spread_type varchar 10  √  null Spread Type
a_base_amount numeric 0  √  null A_Base_Amount
a_calc_accumulated_depr numeric 0  √  null A_Calc_Accumulated_Depr
a_curr_dep_exp numeric 0  √  null A_Curr_Dep_Exp
a_current_period numeric 10  √  null Current Period
a_depreciation_acct numeric 10  √  null
c_validcombination.c_validcombination_id adepreciation_iasset R
Depreciation Account
a_depreciation_calc_type varchar 10  √  null Calculation Type
a_depreciation_manual_amount numeric 0  √  null A_Depreciation_Manual_Amount
a_depreciation_manual_period varchar 2  √  null A_Depreciation_Manual_Period
a_depreciation_table_header_id numeric 10  √  null
a_depreciation_table_header.a_depreciation_table_header_id adepreciationtableheader_iasse R
A_Depreciation_Table_Header_ID
a_depreciation_variable_perc numeric 0  √  null Variable Percent
a_disposal_loss varchar 22  √  null Loss on Disposal
a_disposal_revenue varchar 22  √  null Disposal Revenue
a_life_period numeric 10  √  null Life Periods
a_parent_asset_id numeric 10  √  (0)::numeric Parent Asset
a_period_end numeric 10  √  null A_Period_End
a_period_posted numeric 10  √  null A_Period_Posted
a_period_start numeric 10  √  null A_Period_Start
a_prior_year_accumulated_depr numeric 0  √  null A_Prior_Year_Accumulated_Depr
a_qty_current numeric 10  √  null Current Qty
a_qty_original numeric 10  √  null A_QTY_Original
a_reval_accumdep_offset_cur varchar 22  √  null Revaluation Accumulated Depreciation Offset for Current Year
lifeuseunits numeric 10  √  null Units of use until the asset is not usable anymore
isowned bpchar 1  √  null The asset is owned by the organization
isinposession bpchar 1  √  null The asset is in the possession of the organization
isfullydepreciated bpchar 1  √  null The asset is fully depreciated
isdisposed bpchar 1  √  null The asset is disposed
isdepreciated bpchar 1  √  null The asset will be depreciated
isactive bpchar 1  √  null The record is active in the system
i_isimported bpchar 1  √  null Has this import been processed
i_errormsg varchar 2000  √  null Messages generated from import process
versionno varchar 20  √  null Version Number
value varchar 40  √  null Search key for the record in the format required - must be unique
useunits numeric 10  √  null Currently used units of the assets
uselifeyears numeric 10  √  null Years of the usable life of the asset
uselifemonths numeric 10  √  null Months of the usable life of the asset
updatedby numeric 10 User who updated this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
serno varchar 20  √  null Product Serial Number
processing bpchar 1  √  null Process Now
processed bpchar 1  √  null The document has been processed
postingtype varchar 10  √  null The type of posted amount for the transaction
name varchar 60  √  null Alphanumeric identifier of the entity
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_iasset R
Product, Service, Item
m_locator_id numeric 10  √  null
m_locator.m_locator_id mlocator_iasset R
Warehouse Locator
m_attributesetinstance_id numeric 10  √  null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_iasset R
Product Attribute Set Instance
lot varchar 20  √  null Lot number (alphanumeric)
locationcomment varchar 255  √  null Additional comments or remarks concerning the location
a_reval_accumdep_offset_prior varchar 22  √  null Revaluation Accumulated Depreciation Offset for Prior Year
a_reval_cal_method varchar 3  √  null A_Reval_Cal_Method
a_reval_cost_offset varchar 22  √  null Revaluation Cost Offset for Current Year
a_reval_cost_offset_prior varchar 22  √  null Revaluation Cost Offset for Prior Year
a_reval_depexp_offset varchar 22  √  null Revaluation Expense Offs
a_salvage_value numeric 0  √  null Asset Salvage Value
a_split_percent numeric 0  √  null Split Percent
assetdepreciationdate timestamp 29,6  √  null Date of last depreciation
assetdisposaldate timestamp 29,6  √  null Date when the asset is/was disposed
assetmarketvalueamt numeric 0  √  null Market value of the asset
assetservicedate timestamp 29,6  √  null Date when Asset was put into service
c_acctschema_id numeric 10  √  null
c_acctschema.c_acctschema_id cacctschema_iasset R
Rules for accounting
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_iasset R
Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_iasset R
Identifies the (ship to) address for this Business Partner
c_location_id numeric 10  √  null
c_location.c_location_id clocation_iasset R
Location or Address
conventiontype varchar 10  √  null ConventionType
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10  √  null User who created this records
depreciationtype varchar 10  √  null DepreciationType
description varchar 510  √  null Optional short description of the record
guaranteedate timestamp 29,6  √  null Date when guarantee expires
help varchar 2000  √  null Comment or Hint
i_asset_uu varchar 36  √  NULL::character varying I_Asset_UU

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
i_asset_id Primary key Asc i_asset_key
i_asset_uu Must be unique Asc i_asset_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.