i_asset

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
i_asset_id numeric 10 null
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_user_id numeric 10 √ null
a_accumdepreciation_acct numeric 10 √ null
c_validcombination.c_validcombination_id aaccumdepreciation_iasset R
a_accumulated_depr numeric 0 √ null
a_asset_acct numeric 10 √ null
c_validcombination.c_validcombination_id aasset_iasset R
a_asset_cost numeric 0 √ null
a_asset_group_id numeric 10 √ null
a_asset_group.a_asset_group_id aassetgroup_iasset R
a_asset_id numeric 10 √ null
a_asset.a_asset_id Implied Constraint R
a_asset_life_current_year numeric 10 √ null
a_asset_life_years numeric 0 √ null
a_asset_spread_type varchar 10 √ null
a_base_amount numeric 0 √ null
a_calc_accumulated_depr numeric 0 √ null
a_curr_dep_exp numeric 0 √ null
a_current_period numeric 10 √ null
a_depreciation_acct numeric 10 √ null
c_validcombination.c_validcombination_id adepreciation_iasset R
a_depreciation_calc_type varchar 10 √ null
a_depreciation_manual_amount numeric 0 √ null
a_depreciation_manual_period varchar 2 √ null
a_depreciation_table_header_id numeric 10 √ null
a_depreciation_table_header.a_depreciation_table_header_id adepreciationtableheader_iasse R
a_depreciation_variable_perc numeric 0 √ null
a_disposal_loss varchar 22 √ null
a_disposal_revenue varchar 22 √ null
a_life_period numeric 10 √ null
a_parent_asset_id numeric 10 √ (0)::numeric
a_period_end numeric 10 √ null
a_period_posted numeric 10 √ null
a_period_start numeric 10 √ null
a_prior_year_accumulated_depr numeric 0 √ null
a_qty_current numeric 10 √ null
a_qty_original numeric 10 √ null
a_reval_accumdep_offset_cur varchar 22 √ null
lifeuseunits numeric 10 √ null
isowned bpchar 1 √ null
isinposession bpchar 1 √ null
isfullydepreciated bpchar 1 √ null
isdisposed bpchar 1 √ null
isdepreciated bpchar 1 √ null
isactive bpchar 1 √ null
i_isimported bpchar 1 √ null
i_errormsg varchar 2000 √ null
versionno varchar 20 √ null
value varchar 40 √ null
useunits numeric 10 √ null
uselifeyears numeric 0 √ null
uselifemonths numeric 10 √ null
updatedby numeric 10 null
updated timestamp 29,6 statement_timestamp()
serno varchar 20 √ null
processing bpchar 1 √ null
processed bpchar 1 √ null
postingtype varchar 10 √ null
name varchar 60 √ null
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_iasset R
m_locator_id numeric 10 √ null
m_locator.m_locator_id mlocator_iasset R
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_iasset R
lot varchar 20 √ null
locationcomment varchar 255 √ null
a_reval_accumdep_offset_prior varchar 22 √ null
a_reval_cal_method varchar 3 √ null
a_reval_cost_offset varchar 22 √ null
a_reval_cost_offset_prior varchar 22 √ null
a_reval_depexp_offset varchar 22 √ null
a_salvage_value numeric 0 √ null
a_split_percent numeric 0 √ null
assetdepreciationdate timestamp 29,6 √ null
assetdisposaldate timestamp 29,6 √ null
assetmarketvalueamt numeric 0 √ null
assetservicedate timestamp 29,6 √ null
c_acctschema_id numeric 10 √ null
c_acctschema.c_acctschema_id cacctschema_iasset R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_iasset R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_iasset R
c_location_id numeric 10 √ null
c_location.c_location_id clocation_iasset R
conventiontype varchar 10 √ null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 √ null
depreciationtype varchar 10 √ null
description varchar 510 √ null
guaranteedate timestamp 29,6 √ null
help varchar 2000 √ null
i_asset_uu varchar 36 √ NULL::character varying

Indexes

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

Check Constraints

Constraint Name Constraint
i_asset_isdepreciated_check ((isdepreciated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_asset_isfullydepreciated_check ((isfullydepreciated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_asset_isowned_check ((isowned = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_asset_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_asset_isdisposed_check ((isdisposed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_asset_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_asset_i_isimported_check ((i_isimported = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_asset_isinposession_check ((isinposession = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation