i_fixedasset

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
i_fixedasset_id numeric 10 NULL::numeric
a_asset_addition.i_fixedasset_id ifixedasset_aassetaddition R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
inventoryno varchar 30 √ NULL::character varying
name varchar 120 √ NULL::character varying
a_asset_group_id numeric 10 √ NULL::numeric
a_asset_group.a_asset_group_id aassetgroup_ifixedasset R
a_asset_group_value varchar 40 √ NULL::character varying
a_asset_class_id numeric 10 √ NULL::numeric
a_asset_class.a_asset_class_id aassetclass_ifixedasset R
a_asset_class_value varchar 40 √ NULL::character varying
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_ifixedasset R
productvalue varchar 40 √ NULL::character varying
assetservicedate timestamp 29,6 √ null
a_asset_cost numeric 0 (0)::numeric
a_accumulated_depr numeric 0 √ null
a_accumulated_depr_f numeric 0 √ null
uselifemonths numeric 10 √ null
uselifemonths_f numeric 10 √ null
a_current_period numeric 10 √ NULL::numeric
dateacct timestamp 29,6 √ null
a_asset_id numeric 10 √ NULL::numeric
a_asset.a_asset_id aasset_ifixedasset R
i_isimported bpchar 1 'N'::bpchar
i_errormsg varchar 2000 √ NULL::character varying
processing bpchar 1 √ NULL::bpchar
processed bpchar 1 √ NULL::bpchar
a_remaining_period numeric 10 (0)::numeric
docaction varchar 2 'CO'::character varying
assetperioddepreciationamt numeric 0 (0)::numeric
assetdepreciationdate timestamp 29,6 √ null
m_locator_id numeric 10 √ NULL::numeric
m_locator.m_locator_id mlocator_ifixedasset R
locatorvalue varchar 40 √ NULL::character varying
qty numeric 0 √ (1)::numeric
uomsymbol varchar 10 √ NULL::character varying
c_uom_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuom_ifixedasset R
description varchar 255 √ NULL::character varying
c_city_value varchar 40 √ NULL::character varying
seqno numeric 10 √ (1)::numeric
bpartner_value varchar 40 √ NULL::character varying
c_bpartnersr_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartnersr_ifixedasset R
c_city_id numeric 10 √ NULL::numeric
c_city.c_city_id ccity_ifixedasset R
a_asset_type_id numeric 10 √ null
a_asset_type.a_asset_type_id aassettype_ifixedasset R
a_asset_type_value varchar 40 √ NULL::character varying
a_salvage_value numeric 0 √ null
i_fixedasset_uu varchar 36 √ NULL::character varying
iso_code varchar 3 √ NULL::character varying
c_currency_id numeric 10 √ NULL::numeric
c_currency.c_currency_id ccurrency_ifixedasset R
assetamtentered numeric 0 '0'::numeric
assetsourceamt numeric 0 '0'::numeric
acctschemaname varchar 120 √ NULL::character varying
c_acctschema_id numeric 10 √ NULL::numeric
c_acctschema.c_acctschema_id cacctschema_ifixedasset C

Indexes

Constraint Name Type Sort Column(s)
i_fixedasset_key Primary key Asc i_fixedasset_id
i_fixedasset_uu_idx Must be unique Asc i_fixedasset_uu

Check Constraints

Constraint Name Constraint
i_fixedasset_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_fixedasset_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation