Table idempiere9.adempiere.i_fixedasset
Imported Fixed 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_fixedasset_id numeric 10 NULL::numeric
a_asset_addition.i_fixedasset_id ifixedasset_aassetaddition R
Imported Fixed Asset
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
inventoryno varchar 30  √  NULL::character varying Inventory No
name varchar 120  √  NULL::character varying Alphanumeric identifier of the entity
a_asset_group_id numeric 10  √  NULL::numeric
a_asset_group.a_asset_group_id aassetgroup_ifixedasset R
Group of Assets
a_asset_group_value varchar 40  √  NULL::character varying Asset Group Key
a_asset_class_id numeric 10  √  NULL::numeric
a_asset_class.a_asset_class_id aassetclass_ifixedasset R
Asset class
a_asset_class_value varchar 40  √  NULL::character varying Asset Class Key
m_product_id numeric 10  √  NULL::numeric
m_product.m_product_id mproduct_ifixedasset R
Product, Service, Item
productvalue varchar 40  √  NULL::character varying Key of the Product
assetservicedate timestamp 29,6  √  null Date when Asset was put into service
a_asset_cost numeric 0 (0)::numeric Asset Cost
a_accumulated_depr numeric 0  √  null Accumulated Depreciation
a_accumulated_depr_f numeric 0  √  null Accumulated Depreciation (fiscal)
uselifemonths numeric 10  √  null Months of the usable life of the asset
uselifemonths_f numeric 10  √  null Use Life - Months (fiscal)
a_current_period numeric 10  √  NULL::numeric Current Period
dateacct timestamp 29,6  √  null Accounting Date
a_asset_id numeric 10  √  NULL::numeric
a_asset.a_asset_id aasset_ifixedasset R
Asset used internally or by customers
i_isimported bpchar 1 'N'::bpchar Has this import been processed
i_errormsg varchar 2000  √  NULL::character varying Messages generated from import process
processing bpchar 1  √  NULL::bpchar Process Now
processed bpchar 1  √  NULL::bpchar The document has been processed
a_remaining_period numeric 10 (0)::numeric Remaining Period
docaction varchar 2 'CO'::character varying The targeted status of the document
assetperioddepreciationamt numeric 0 (0)::numeric Applies to Straight Line depreciation
assetdepreciationdate timestamp 29,6  √  null Date of last depreciation
m_locator_id numeric 10  √  NULL::numeric
m_locator.m_locator_id mlocator_ifixedasset R
Warehouse Locator
locatorvalue varchar 40  √  NULL::character varying Key of the Warehouse Locator
qty numeric 0  √  (1)::numeric Quantity
uomsymbol varchar 10  √  NULL::character varying Symbol for a Unit of Measure
c_uom_id numeric 10  √  NULL::numeric
c_uom.c_uom_id cuom_ifixedasset R
Unit of Measure
description varchar 255  √  NULL::character varying Optional short description of the record
c_city_value varchar 40  √  NULL::character varying City Value
seqno numeric 10  √  (1)::numeric Method of ordering records; lowest number comes first
bpartner_value varchar 40  √  NULL::character varying The Key of the Business Partner
c_bpartnersr_id numeric 10  √  NULL::numeric
c_bpartner.c_bpartner_id cbpartnersr_ifixedasset R
Business Partner (Agent or Sales Rep)
c_city_id numeric 10  √  NULL::numeric
c_city.c_city_id ccity_ifixedasset R
City
a_asset_type_id numeric 10  √  null
a_asset_type.a_asset_type_id aassettype_ifixedasset R
Asset Type
a_asset_type_value varchar 40  √  NULL::character varying Asset Type Value
a_salvage_value numeric 0  √  null Asset Salvage Value
i_fixedasset_uu varchar 36  √  NULL::character varying I_FixedAsset_UU
iso_code varchar 3  √  NULL::character varying Three letter ISO 4217 Code of the Currency
c_currency_id numeric 10  √  NULL::numeric
c_currency.c_currency_id ccurrency_ifixedasset R
The Currency for this record
assetamtentered numeric 0 '0'::numeric Entered Amount
assetsourceamt numeric 0 '0'::numeric Source Amount
acctschemaname varchar 120  √  NULL::character varying Name of the Accounting Schema
c_acctschema_id numeric 10  √  NULL::numeric
c_acctschema.c_acctschema_id cacctschema_ifixedasset C
Rules for accounting

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

Indexes:
Column(s) Type Sort Constraint Name
i_fixedasset_id Primary key Asc i_fixedasset_key
i_fixedasset_uu Must be unique Asc i_fixedasset_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.