Post Imported Assets (Window ID-53056)

From iDempiere en
Jump to: navigation, search



Window: Post Imported Assets

Description: Import Fixed Assets

Help: The Import Asset window allow the user to import assets to Adempiere



TAB: Import Assets Setup

Description: Review Fixed before Import


Help null


Post Imported Assets - Import Assets Setup - Window (iDempiere 1.0.0).png




Name Name Description Help Specifications
Asset Asset null null I_Asset_ID
numeric(10) NOT NULL
ID
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Asset Asset Asset used internally or by customers An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. A_Asset_ID
numeric(10)
ID
Asset ID Asset ID null null A_Parent_Asset_ID
numeric(10)
Integer
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40)
String
Name Name Alphanumeric identifier of the entity The 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. Name
character varying(60)
String
Description Description Optional short description of the record A description is limited to 255 characters. Description
character varying(510)
String
Comment/Help Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help
character varying(2000)
Text
Active Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1)
Yes-No
Product Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10)
Search
Attribute Set Instance Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Version No Version No Version Number null VersionNo
character varying(20)
String
Lot No Lot No Lot number (alphanumeric) The Lot Number indicates the specific lot that a product was part of. Lot
character varying(20)
String
Serial No Serial No Product Serial Number The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. SerNo
character varying(20)
String
Original Qty Original Qty null null A_QTY_Original
numeric(10)
Integer
Quantity Quantity null null A_QTY_Current
numeric(10)
Integer
In Service Date In Service Date Date when Asset was put into service The date when the asset was put into service - usually used as start date for depreciation. AssetServiceDate
timestamp without time zone
Date
Guarantee Date Guarantee Date Date when guarantee expires Date when the normal guarantee or availability expires GuaranteeDate
timestamp without time zone
Date
Asset Group Asset Group Group of Assets The group of assets determines default accounts. If an asset group is selected in the product category, assets are created when delivering the asset. A_Asset_Group_ID
numeric(10)
Table Direct
Owned Owned The asset is owned by the organization The asset may not be in possession, but the asset is legally owned by the organization IsOwned
character(1)
Yes-No
In Possession In Possession The asset is in the possession of the organization Assets which are not in possession are e.g. at Customer site and may or may not be owned by the company. IsInPosession
character(1)
Yes-No
Business Partner Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID
numeric(10)
Search
User/Contact User/Contact User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_User_ID
numeric(10)
Integer
Partner Location Partner Location Identifies the (ship to) address for this Business Partner The Partner address indicates the location of a Business Partner C_BPartner_Location_ID
numeric(10)
Table Direct
Address Address Location or Address The Location / Address field defines the location of an entity. C_Location_ID
numeric(10)
Search
Locator Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID
numeric(10)
Table Direct
Location comment Location comment Additional comments or remarks concerning the location null LocationComment
character varying(255)
String
Depreciate Depreciate The asset will be depreciated The asset is used internally and will be depreciated IsDepreciated
character(1)
Yes-No
Fully depreciated Fully depreciated The asset is fully depreciated The asset costs are fully amortized. IsFullyDepreciated
character(1)
Yes-No
Usable Life - Years Usable Life - Years Years of the usable life of the asset null UseLifeYears
numeric(10)
Integer
Usable Life - Months Usable Life - Months Months of the usable life of the asset null UseLifeMonths
numeric(10)
Integer
Life use Life use Units of use until the asset is not usable anymore Life use and the actual use may be used to calculate the depreciation LifeUseUnits
numeric(10)
Integer
Use units Use units Currently used units of the assets null UseUnits
numeric(10)
Integer
Asset Depreciation Date Asset Depreciation Date Date of last depreciation Date of the last deprecation, if the asset is used internally and depreciated. AssetDepreciationDate
timestamp without time zone
Date
Disposed Disposed The asset is disposed The asset is no longer used and disposed IsDisposed
character(1)
Yes-No
Asset Disposal Date Asset Disposal Date Date when the asset is/was disposed null AssetDisposalDate
timestamp without time zone
Date
Processed Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed
character(1)
Yes-No
Imported Imported Has this import been processed The Imported check box indicates if this import has been processed. I_IsImported
character(1)
Yes-No
Import Error Message Import Error Message Messages generated from import process The Import Error Message displays any error messages generated during the import process. I_ErrorMsg
character varying(2000)
String
Import Asset Import Asset Imports Asset from a file into the application Import Asset will bring a file of Asset in a predefined format into the application.

The Parameters are default values for null import record values they do not overwrite any data.

Processing
character(1)
Button




TAB: Import Accounting Setup

Description: Review Fixed before Import


Help null


Post Imported Assets - Import Accounting Setup - Window (iDempiere 1.0.0).png




Name Name Description Help Specifications
Asset Asset null null I_Asset_ID
numeric(10) NOT NULL
ID
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Accounting Schema Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID
numeric(10)
Table Direct
Asset Asset Asset used internally or by customers An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. A_Asset_ID
numeric(10)
ID
PostingType PostingType The type of amount that this journal updated The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated. PostingType
character varying(10)
List
Period Start Period Start null null A_Period_Start
numeric(10)
Integer
Period End Period End null null A_Period_End
numeric(10)
Integer
DepreciationType DepreciationType null null DepreciationType
character varying(10)
Table
Depreciation Manual Amount Depreciation Manual Amount null null A_Depreciation_Manual_Amount
numeric
Amount
Depreciation Table Header Depreciation Table Header null null A_Depreciation_Table_Header_ID
numeric(10)
Table
Depreciation Manual Period Depreciation Manual Period null null A_Depreciation_Manual_Period
character varying(2)
List
Depreciation Variable Perc. Depreciation Variable Perc. null null A_Depreciation_Variable_Perc
numeric
Number
Asset Spread Type Asset Spread Type null null A_Asset_Spread_Type
character varying(10)
Table
Depreciation Calculation Type Depreciation Calculation Type null null A_Depreciation_Calc_Type
character varying(10)
Table
ConventionType ConventionType null null ConventionType
character varying(10)
Table
Salvage Value Salvage Value null null A_Salvage_Value
numeric
Amount
Split Percentage Split Percentage null null A_Split_Percent
numeric
Number
Asset Cost Account Asset Cost Account null null A_Asset_Acct
numeric(10)
Account
Accumulated Depreciation Accumulated Depreciation null null A_Accumdepreciation_Acct
numeric(10)
Account
Depreciation Expense Account Depreciation Expense Account null null A_Depreciation_Acct
numeric(10)
Account
Disposal Revenue Disposal Revenue null null A_Disposal_Revenue
character varying(22)
Account
Loss on Disposal Loss on Disposal null null A_Disposal_Loss
character varying(22)
Account
Revaluation Calculation Method Revaluation Calculation Method null null A_Reval_Cal_Method
character varying(3)
List
Revaluation Cost Offset for Current Year Revaluation Cost Offset for Current Year null null A_Reval_Cost_Offset
character varying(22)
Account
Revaluation Cost Offset for Prior Year Revaluation Cost Offset for Prior Year null null A_Reval_Cost_Offset_Prior
character varying(22)
Account
Revaluation Accumulated Depreciation Offset for Current Year Revaluation Accumulated Depreciation Offset for Current Year null null A_Reval_Accumdep_Offset_Cur
character varying(22)
Account
Revaluation Accumulated Depreciation Offset for Prior Year Revaluation Accumulated Depreciation Offset for Prior Year null null A_Reval_Accumdep_Offset_Prior
character varying(22)
Account
Revaluation Expense Offs Revaluation Expense Offs null null A_Reval_Depexp_Offset
character varying(22)
Account




TAB: Import Asset Balances

Description: Review Fixed before Import


Help null


Post Imported Assets - Import Asset Balances - Window (iDempiere 1.0.0).png




Name Name Description Help Specifications
Asset Asset null null I_Asset_ID
numeric(10) NOT NULL
ID
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Asset Asset Asset used internally or by customers An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. A_Asset_ID
numeric(10)
ID
PostingType PostingType The type of amount that this journal updated The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated. PostingType
character varying(10)
List
Asset Cost Asset Cost null null A_Asset_Cost
numeric
Amount
Accumulated Depreciation Accumulated Depreciation null null A_Accumulated_Depr
numeric
Amount
Market value Amount Market value Amount Market value of the asset For reporting, the market value of the asset AssetMarketValueAmt
numeric
Amount
Period Posted Period Posted null null A_Period_Posted
numeric(10)
Integer
A_Life_Period A_Life_Period null null A_Life_Period
numeric(10)
Integer


==Contributions / Posts==