Skip to main content

Window: Imported Fixed Asset

[Created: 20/06/2010 - Updated: 20/06/2010 ]
Description:
Help:

Tab: Fixed Asset

[Created: 20/06/2010 - Updated: 12/03/2013 ]
Description:
Help:
Tab Level: 0

Table 10: Fixed Asset - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
ImportedHas this import been processedThe Imported check box indicates if this import has been processed.i_fixedasset.I_IsImported character(1)
Yes-No
Import Error MessageMessages generated from import processThe Import Error Message displays any error messages generated during the import process.i_fixedasset.I_ErrorMsg character varying(2000)
String
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.i_fixedasset.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.i_fixedasset.AD_Org_ID numeric(10)
Table Direct
AssetAsset used internally or by customersAn asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset.i_fixedasset.A_Asset_ID numeric(10)
Search
Inventory Noi_fixedasset.InventoryNo character varying(30)
String
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.i_fixedasset.Name character varying(120)
String
In Service DateDate when Asset was put into serviceThe date when the asset was put into service - usually used as start date for depreciation.i_fixedasset.AssetServiceDate timestamp without time zone
Date
Account DateAccounting DateThe Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion.i_fixedasset.DateAcct timestamp without time zone
Date
Asset Depreciation DateDate of last depreciationDate of the last deprecation, if the asset is used internally and depreciated.i_fixedasset.AssetDepreciationDate timestamp without time zone
Date
Asset GroupGroup of AssetsThe group of assets determines default accounts. If an asset group is selected in the product category, assets are created when delivering the asset.i_fixedasset.A_Asset_Group_ID numeric(10)
Table Direct
Asset Group Keyi_fixedasset.A_Asset_Group_Value character varying(40)
String
BPartner (Agent)Business Partner (Agent or Sales Rep)i_fixedasset.C_BPartnerSR_ID numeric(10)
Search
Business Partner KeyThe Key of the Business Partneri_fixedasset.BPartner_Value character varying(40)
String
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.i_fixedasset.M_Product_ID numeric(10)
Search
Product KeyKey of the Producti_fixedasset.ProductValue character varying(40)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.i_fixedasset.Description character varying(255)
String
UOMUnit of MeasureThe UOM defines a unique non monetary Unit of Measurei_fixedasset.C_UOM_ID numeric(10)
Search
SymbolSymbol for a Unit of MeasureThe Symbol identifies the Symbol to be displayed and printed for a Unit of Measurei_fixedasset.UOMSymbol character varying(10)
String
LocatorWarehouse LocatorThe Locator indicates where in a Warehouse a product is located.i_fixedasset.M_Locator_ID numeric(10)
Table Direct
Locator KeyKey of the Warehouse Locatori_fixedasset.LocatorValue character varying(40)
String
QuantityQuantityThe Quantity indicates the number of a specific product or item for this document.i_fixedasset.Qty numeric
Quantity
Asset Costi_fixedasset.A_Asset_Cost numeric
Amount
Asset Salvage Valuei_fixedasset.A_Salvage_Value numeric
Number
Usable Life - MonthsMonths of the usable life of the asseti_fixedasset.UseLifeMonths numeric(10)
Integer
Use Life - Months (fiscal)i_fixedasset.UseLifeMonths_F numeric(10)
Integer
Current Periodi_fixedasset.A_Current_Period numeric(10)
Integer
Accumulated Depreciationi_fixedasset.A_Accumulated_Depr numeric
Amount
Accumulated Depreciation (fiscal)i_fixedasset.A_Accumulated_Depr_F numeric
Amount
CurrencyThe Currency for this recordIndicates the Currency to be used when processing or reporting on this recordi_fixedasset.C_Currency_ID numeric(10)
Table Direct
ISO Currency CodeThree letter ISO 4217 Code of the CurrencyFor details - http://www.unece.org/trade/rec/rec09en.htmi_fixedasset.ISO_Code character varying(3)
String
Entered Amounti_fixedasset.AssetAmtEntered numeric
Amount
Source Amounti_fixedasset.AssetSourceAmt numeric
Amount
Accounting SchemaRules for accountingAn Accounting Schema defines the rules used in accounting such as costing method, currency and calendari_fixedasset.C_AcctSchema_ID numeric(10)
Table Direct
Account Schema NameName of the Accounting Schemai_fixedasset.AcctSchemaName character varying(120)
String
Document ActionThe targeted status of the documentYou find the current status in the Document Status field. The options are listed in a popupi_fixedasset.DocAction character varying(2)
List
Import Fixed Asseti_fixedasset.Processing character(1)
Button