Post Imported Assets (窗口 ID-53056)

来自iDempiere zh
跳到导航 跳到搜索



窗口: Post Imported Assets

描述: Import Fixed Assets

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



TAB: Import Assets Setup

描述: Review Fixed before Import


幫助 null


File:Post Imported Assets - Import Assets Setup - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Asset Asset null null I_Asset_ID
numeric(10) NOT NULL
ID
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization 机构 客户内的机构实体。 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 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 检索关键字 记录的检索关键字在格式上是必须的 -并且必须唯一 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 名称 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 描述 该记录的可选描述 描述最多为 255 个字符。 Description
character varying(510)
String
Comment/Help 注释/帮助 注释或提示 The Help field contains a hint, comment or help about the use of this item. Help
character varying(2000)
Text
Active 有效 本记录有效 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, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10)
Search
Attribute Set Instance 属性组合实例 Product Attribute Set Instance The values of the actual Product Attributes M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Version No 版本号 版本数字 null VersionNo
character varying(20)
String
Lot No 批号 The Lot Number indicates the specific lot that a product was part of. Lot
character varying(20)
String
Serial No 序列号 产品序号 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 在服务日期内 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 保证日期 保证期满日 Date when the normal guarantee or availability expires GuaranteeDate
timestamp without time zone
Date
Asset Group 资产分类 群体的资产 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 拥有 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 在所有物中 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 业务伙伴 标识业务伙伴 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 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 业务伙伴地址 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 地址 位置或地址 The Location Address field defines the location of an entity. C_Location_ID
numeric(10)
Search
Locator 货位 仓库货位 The Locator ID indicates where in a Warehouse a product is located. M_Locator_ID
numeric(10)
Table Direct
Location comment 位置意见 Additional comments or remarks concerning the location null LocationComment
character varying(255)
String
Depreciate 折旧 资产将会被折旧 The asset is used internally and will be depreciated IsDepreciated
character(1)
Yes-No
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 生活使用 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 使用单位 Currently used units of the assets null UseUnits
numeric(10)
Integer
Asset Depreciation Date 资产折旧日期 最近折旧日期 Date of the last deprecation, if the asset is used internally and depreciated. AssetDepreciationDate
timestamp without time zone
Date
Disposed 处理 资产被处理 The asset is no longer used and disposed IsDisposed
character(1)
Yes-No
Asset Disposal Date 资产处理日期 Date when the asset is was disposed null AssetDisposalDate
timestamp without time zone
Date
Processed 已处理 The document has been processed The Processed checkbox indicates that a document has been processed. Processed
character(1)
Yes-No
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 导入错误信息 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

描述: Review Fixed before Import


幫助 null


File:Post Imported Assets - Import Accounting Setup - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Asset Asset null null I_Asset_ID
numeric(10) NOT NULL
ID
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization 机构 客户内的机构实体。 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 会计模式 帐户的规则 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 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 过帐类型 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

描述: Review Fixed before Import


幫助 null


File:Post Imported Assets - Import Asset Balances - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Asset Asset null null I_Asset_ID
numeric(10) NOT NULL
ID
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization 机构 客户内的机构实体。 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 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 过帐类型 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 市场价值金额 资产的市场价格 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