Asset (Window ID-251)

From iDempiere en

Table of Contents

Window: Asset

Description: Asset used internally or by customers

Help: An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset.

Tab: Asset

Description: Asset used internally or by customers

Help: An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset.

Asset - Asset - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset.AD_Org_ID
numeric(10)
Table Direct
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).

A_Asset.Value
character varying(40)
String
Inventory No A_Asset.InventoryNo
character varying(30)
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. A_Asset.Name
character varying(60)
String
Description Optional short description of the record A description is limited to 255 characters. A_Asset.Description
character varying(255)
String
Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. A_Asset.Help
character varying(2000)
Text
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.

A_Asset.IsActive
character(1)
Yes-No
Parent Asset A_Asset.A_Parent_Asset_ID
numeric(10)
Search
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.A_Asset_Group_ID
numeric(10)
Search
Version No Version Number A_Asset.VersionNo
character varying(20)
String
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. A_Asset.M_Product_ID
numeric(10)
Search
Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. A_Asset.M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Serial No Product Serial Number The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. A_Asset.SerNo
character varying(255)
String
Manufactured Year A_Asset.ManufacturedYear
numeric(10)
Integer
Lot No Lot number (alphanumeric) The Lot Number indicates the specific lot that a product was part of. A_Asset.Lot
character varying(255)
String
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. A_Asset.AssetServiceDate
timestamp without time zone
Date
Guarantee Date Date when guarantee expires Date when the normal guarantee or availability expires A_Asset.GuaranteeDate
timestamp without time zone
Date
Create Date A_Asset.A_Asset_CreateDate
timestamp without time zone
Date
Revaluation Date A_Asset.A_Asset_RevalDate
timestamp without time zone
Date
Project Financial Project A Project allows you to track and control internal or external activities. A_Asset.C_Project_ID
numeric(10)
Search
Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing A_Asset.C_Activity_ID
numeric(10)
Table Direct
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. A_Asset.IsInPosession
character(1)
Yes-No
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson A_Asset.C_BPartner_ID
numeric(10)
Search
Partner Location Identifies the (ship to) address for this Business Partner The Partner address indicates the location of a Business Partner A_Asset.C_BPartner_Location_ID
numeric(10)
Table Direct
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 A_Asset.AD_User_ID
numeric(10)
Table Direct
Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. A_Asset.M_Locator_ID
numeric(10)
Locator (WH)
BPartner (Agent) Business Partner (Agent or Sales Rep) A_Asset.C_BPartnerSR_ID
numeric(10)
Search
Address Location or Address The Location / Address field defines the location of an entity. A_Asset.C_Location_ID
numeric(10)
Location (Address)
Location comment Additional comments or remarks concerning the location A_Asset.LocationComment
character varying(255)
String
Owned The asset is owned by the organization The asset may not be in possession, but the asset is legally owned by the organization A_Asset.IsOwned
character(1)
Yes-No
Lessor The Business Partner who rents or leases A_Asset.Lease_BPartner_ID
numeric(10)
Search
Lease Termination Lease Termination Date Last Date of Lease A_Asset.LeaseTerminationDate
timestamp without time zone
Date
Depreciate The asset will be depreciated The asset is used internally and will be depreciated A_Asset.IsDepreciated
character(1)
Yes-No
Fully depreciated The asset is fully depreciated The asset costs are fully amortized. A_Asset.IsFullyDepreciated
character(1)
Yes-No
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 A_Asset.LifeUseUnits
numeric
Integer
Use units Currently used units of the assets A_Asset.UseUnits
numeric
Integer
Last Maintenance Last Maintenance Date A_Asset.LastMaintenanceDate
timestamp without time zone
Date
Last Unit Last Maintenance Unit A_Asset.LastMaintenanceUnit
numeric(10)
Integer
Last Note Last Maintenance Note A_Asset.LastMaintenanceNote
character varying(60)
String
Next Maintenance Next Maintenance Date A_Asset.NextMaintenenceDate
timestamp without time zone
Date
Next Unit Next Maintenence Unit A_Asset.NextMaintenenceUnit
numeric(10)
Integer
Asset Status A_Asset.A_Asset_Status
character varying(2)
List
Activation Date A_Asset.AssetActivationDate
timestamp without time zone
Date
Asset Depreciation Date Date of last depreciation Date of the last deprecation, if the asset is used internally and depreciated. A_Asset.AssetDepreciationDate
timestamp without time zone
Date
Disposed The asset is disposed The asset is no longer used and disposed A_Asset.IsDisposed
character(1)
Yes-No
Asset Disposal Date Date when the asset is/was disposed A_Asset.AssetDisposalDate
timestamp without time zone
Date

Tab: Product

Description:

Help:

File:Asset - Product - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Product.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Product.AD_Org_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_Product.A_Asset_ID
numeric(10)
Search
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.

A_Asset_Product.IsActive
character(1)
Yes-No
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. A_Asset_Product.M_Product_ID
numeric(10)
Search
Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. A_Asset_Product.M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Current Qty A_Asset_Product.A_QTY_Current
numeric
Quantity
Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. A_Asset_Product.M_Locator_ID
numeric(10)
Locator (WH)
Description Optional short description of the record A description is limited to 255 characters. A_Asset_Product.Description
character varying(255)
String

Tab: Asset Balances

Description: Asset Balance Report and Adjustments

Help:

Asset - Asset Balances - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Depreciation_Workfile.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Depreciation_Workfile.AD_Org_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_Depreciation_Workfile.A_Asset_ID
numeric(10)
Search
Description Optional short description of the record A description is limited to 255 characters. A_Depreciation_Workfile.Description
character varying(255)
String
Asset Cost A_Depreciation_Workfile.A_Asset_Cost
numeric
Amount
Posting Type The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. A_Depreciation_Workfile.PostingType
character(1)
List
Asset Salvage Value A_Depreciation_Workfile.A_Salvage_Value
numeric
Amount
Accumulated Depreciation A_Depreciation_Workfile.A_Accumulated_Depr
numeric
Amount
Accumulated Depreciation (fiscal) A_Depreciation_Workfile.A_Accumulated_Depr_F
numeric
Amount
Remaining Amt A_Depreciation_Workfile.A_Asset_Remaining
numeric
Amount
Remaining Amt (fiscal) A_Depreciation_Workfile.A_Asset_Remaining_F
numeric
Amount
Usable Life - Years Years of the usable life of the asset A_Depreciation_Workfile.UseLifeYears
numeric
Number
Use Life - Years (fiscal) A_Depreciation_Workfile.UseLifeYears_F
numeric
Number
Usable Life - Months Months of the usable life of the asset A_Depreciation_Workfile.UseLifeMonths
numeric(10)
Integer
Use Life - Months (fiscal) A_Depreciation_Workfile.UseLifeMonths_F
numeric(10)
Integer
Depreciate The asset will be depreciated The asset is used internally and will be depreciated A_Depreciation_Workfile.IsDepreciated
character(1)
Yes-No
Current Period A_Depreciation_Workfile.A_Current_Period
numeric(10)
Integer
Account Date Accounting Date The 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. A_Depreciation_Workfile.DateAcct
timestamp without time zone
Date
Update depreciation A_Depreciation_Workfile.Processing
character(1)
Button
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar A_Depreciation_Workfile.C_AcctSchema_ID
numeric(10)
Table Direct

Tab: Accounting Setup

Description: Enter accounting setup information

Help:

Asset - Accounting Setup - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Acct.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Acct.AD_Org_ID
numeric(10)
Table Direct
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar A_Asset_Acct.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_Acct.A_Asset_ID
numeric(10)
Search
Valid from Valid from including this date (first day) The Valid From date indicates the first day of a date range A_Asset_Acct.ValidFrom
timestamp without time zone
Date
Asset Salvage Value A_Asset_Acct.A_Salvage_Value
numeric
Amount
Posting Type The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. A_Asset_Acct.PostingType
character(1)
List
Depreciation A_Asset_Acct.A_Depreciation_ID
numeric(10)
Table
Depreciation (fiscal) A_Asset_Acct.A_Depreciation_F_ID
numeric(10)
Table
Asset Acct A_Asset_Acct.A_Asset_Acct
numeric(10)
Account
Accumulated Depreciation Account A_Asset_Acct.A_Accumdepreciation_Acct
numeric(10)
Account
Depreciation Account A_Asset_Acct.A_Depreciation_Acct
numeric(10)
Account
Disposal Revenue Acct A_Asset_Acct.A_Disposal_Revenue_Acct
numeric(10)
Account
Disposal Loss Acct A_Asset_Acct.A_Disposal_Loss_Acct
numeric(10)
Account

Tab: Activation/Addition

Description: Activation/Addition

Help:

File:Asset - Activation-Addition - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Addition.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Addition.AD_Org_ID
numeric(10)
Table Direct
Document No Document sequence number of the document The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. 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).

A_Asset_Addition.DocumentNo
character varying(30)
String
Create Asset A_Asset_Addition.A_CreateAsset
character(1)
Yes-No
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_Addition.A_Asset_ID
numeric(10)
Search
Document Date Date of the Document The Document Date indicates the date the document was generated. It may or may not be the same as the accounting date. A_Asset_Addition.DateDoc
timestamp without time zone
Date
Account Date Accounting Date The 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. A_Asset_Addition.DateAcct
timestamp without time zone
Date
Posting Type The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. A_Asset_Addition.PostingType
character(1)
List
Capital/Expense A_Asset_Addition.A_CapvsExp
character varying(3)
List
Source Type A_Asset_Addition.A_SourceType
character varying(3)
List
Invoice Invoice Identifier The Invoice Document. A_Asset_Addition.C_Invoice_ID
numeric(10)
Search
Invoice Line Invoice Detail Line The Invoice Line uniquely identifies a single line of an Invoice. A_Asset_Addition.C_InvoiceLine_ID
numeric(10)
Search
Match Invoice Match Shipment/Receipt to Invoice A_Asset_Addition.M_MatchInv_ID
numeric(10)
Search
Shipment/Receipt Line Line on Shipment or Receipt document The Shipment/Receipt Line indicates a unique line in a Shipment/Receipt document A_Asset_Addition.M_InOutLine_ID
numeric(10)
Search
Project Financial Project A Project allows you to track and control internal or external activities. A_Asset_Addition.C_Project_ID
numeric(10)
Search
Charge Additional document charges The Charge indicates a type of Charge (Handling, Shipping, Restocking) A_Asset_Addition.C_Charge_ID
numeric(10)
Search
Imported Fixed Asset A_Asset_Addition.I_FixedAsset_ID
numeric(10)
Search
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. A_Asset_Addition.M_Product_ID
numeric(10)
Search
Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. A_Asset_Addition.M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. A_Asset_Addition.M_Locator_ID
numeric(10)
Locator (WH)
Description Optional short description of the record A description is limited to 255 characters. A_Asset_Addition.Description
character varying(510)
String
Source Amount A_Asset_Addition.AssetSourceAmt
numeric
Amount
Asset value Book Value of the asset A_Asset_Addition.AssetValueAmt
numeric
Amount
Entered Amount A_Asset_Addition.AssetAmtEntered
numeric
Amount
Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record A_Asset_Addition.C_Currency_ID
numeric(10)
Table Direct
Current Qty A_Asset_Addition.A_QTY_Current
numeric
Number
Accumulated Depreciation A_Asset_Addition.A_Accumulated_Depr
numeric
Amount
Accumulated Depreciation (fiscal) A_Asset_Addition.A_Accumulated_Depr_F
numeric
Amount
Delta Use Life Years A_Asset_Addition.DeltaUseLifeYears
numeric(10)
Integer
Delta Use Life Years (fiscal) Delta Use Life Years (fiscal) A_Asset_Addition.DeltaUseLifeYears_F
numeric(10)
Integer
Processed The document has been processed The Processed checkbox indicates that a document has been processed. A_Asset_Addition.Processed
character(1)
Yes-No
Document Status The current status of the document The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field A_Asset_Addition.DocStatus
character varying(2)
List
Asset Addition Process A_Asset_Addition.DocAction
character(2)
Button

Tab: Disposal

Description:

Help:

File:Asset - Disposal - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Disposed.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Disposed.AD_Org_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_Disposed.A_Asset_ID
numeric(10)
Search
Disposed Method A_Asset_Disposed.A_Disposed_Method
character varying(2)
List
Disposed Date A_Asset_Disposed.A_Disposed_Date
timestamp without time zone
Date
Document Date Date of the Document The Document Date indicates the date the document was generated. It may or may not be the same as the accounting date. A_Asset_Disposed.DateDoc
timestamp without time zone
Date
Account Date Accounting Date The 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. A_Asset_Disposed.DateAcct
timestamp without time zone
Date
Asset Proceeds A_Asset_Disposed.A_Proceeds
numeric
Amount
Asset Trade A_Asset_Disposed.A_Asset_Trade_ID
numeric(10)
Search
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.

A_Asset_Disposed.IsActive
character(1)
Yes-No
Processed The document has been processed The Processed checkbox indicates that a document has been processed. A_Asset_Disposed.Processed
character(1)
Yes-No

Tab: Asset History

Description: Detail asset transaction history

Help:

Asset - Asset History - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Change.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Change.AD_Org_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_Change.A_Asset_ID
numeric(10)
Search
Details A_Asset_Change.TextDetails
character varying(60)
String
Posting Type The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. A_Asset_Change.PostingType
character varying(10)
List
Change Type A_Asset_Change.ChangeType
character varying(3)
List
Created Date this record was created The Created field indicates the date that this record was created. A_Asset_Change.Created
timestamp without time zone
Date+Time
Updated By User who updated this records The Updated By field indicates the user who updated this record. A_Asset_Change.UpdatedBy
numeric(10)
Search
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar A_Asset_Change.C_AcctSchema_ID
numeric(10)
Table Direct
A_Period_Start A_Asset_Change.A_Period_Start
numeric(10)
Integer
A_Period_End A_Asset_Change.A_Period_End
numeric(10)
Integer
A_Depreciation_Manual_Amount A_Asset_Change.A_Depreciation_Manual_Amount
numeric
Amount
A_Depreciation_Manual_Period A_Asset_Change.A_Depreciation_Manual_Period
character varying(2)
List
Variable Percent A_Asset_Change.A_Depreciation_Variable_Perc
numeric
Number
A_Depreciation_Table_Header_ID A_Asset_Change.A_Depreciation_Table_Header_ID
numeric(10)
Table
Spread Type A_Asset_Change.A_Asset_Spread_Type
character varying(10)
Table
Asset Salvage Value A_Asset_Change.A_Salvage_Value
numeric
Amount
Split Percent A_Asset_Change.A_Split_Percent
numeric
Number
Owned The asset is owned by the organization The asset may not be in possession, but the asset is legally owned by the organization A_Asset_Change.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. A_Asset_Change.IsInPosession
character(1)
Yes-No
Depreciate The asset will be depreciated The asset is used internally and will be depreciated A_Asset_Change.IsDepreciated
character(1)
Yes-No
Fully depreciated The asset is fully depreciated The asset costs are fully amortized. A_Asset_Change.IsFullyDepreciated
character(1)
Yes-No
Disposed The asset is disposed The asset is no longer used and disposed A_Asset_Change.IsDisposed
character(1)
Yes-No
A_Reval_Cal_Method A_Asset_Change.A_Reval_Cal_Method
character varying(3)
List
Change Amt A_Asset_Change.ChangeAmt
numeric
Amount
Asset value Book Value of the asset A_Asset_Change.AssetValueAmt
numeric
Amount
Asset Book Value Amt A_Asset_Change.AssetBookValueAmt
numeric
Amount
Asset Accum Depreciation Amt A_Asset_Change.AssetAccumDepreciationAmt
numeric
Amount
Market value Amount Market value of the asset For reporting, the market value of the asset A_Asset_Change.AssetMarketValueAmt
numeric
Amount
A_QTY_Original A_Asset_Change.A_QTY_Original
numeric
Number
Current Qty A_Asset_Change.A_QTY_Current
numeric
Number
Account Date Accounting Date The 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. A_Asset_Change.DateAcct
timestamp without time zone
Date
Create Date A_Asset_Change.A_Asset_CreateDate
timestamp without time zone
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. A_Asset_Change.AssetServiceDate
timestamp without time zone
Date
Asset Depreciation Date Date of last depreciation Date of the last deprecation, if the asset is used internally and depreciated. A_Asset_Change.AssetDepreciationDate
timestamp without time zone
Date
Revaluation Date A_Asset_Change.A_Asset_RevalDate
timestamp without time zone
Date
Asset Disposal Date Date when the asset is/was disposed A_Asset_Change.AssetDisposalDate
timestamp without time zone
Date
Usable Life - Years Years of the usable life of the asset A_Asset_Change.UseLifeYears
numeric
Number
Usable Life - Months Months of the usable life of the asset A_Asset_Change.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 A_Asset_Change.LifeUseUnits
numeric(10)
Integer
Use units Currently used units of the assets A_Asset_Change.UseUnits
numeric(10)
Integer
Parent Asset A_Asset_Change.A_Parent_Asset_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 A_Asset_Change.AD_User_ID
numeric(10)
Search
Address Location or Address The Location / Address field defines the location of an entity. A_Asset_Change.C_Location_ID
numeric(10)
Location (Address)
Lot No Lot number (alphanumeric) The Lot Number indicates the specific lot that a product was part of. A_Asset_Change.Lot
character varying(40)
String
Serial No Product Serial Number The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. A_Asset_Change.SerNo
character varying(40)
String
Version No Version Number A_Asset_Change.VersionNo
character varying(40)
String
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson A_Asset_Change.C_BPartner_ID
numeric(10)
Search
Partner Location Identifies the (ship to) address for this Business Partner The Partner address indicates the location of a Business Partner A_Asset_Change.C_BPartner_Location_ID
numeric(10)
Table
Asset Acct A_Asset_Change.A_Asset_Acct
numeric(10)
Account
Depreciation Account A_Asset_Change.A_Depreciation_Acct
numeric(10)
Account
Accumulated Depreciation Account A_Asset_Change.A_Accumdepreciation_Acct
numeric(10)
Account
Disposal Revenue Acct A_Asset_Change.A_Disposal_Revenue_Acct
numeric(10)
Account
Disposal Loss Acct A_Asset_Change.A_Disposal_Loss_Acct
numeric(10)
Account
Reval Cost Offset Acct A_Asset_Change.A_Reval_Cost_Offset_Acct
numeric(10)
Integer
Revaluation Cost Offset for Current Year A_Asset_Change.A_Reval_Cost_Offset
numeric(10)
Integer
Reval Cost Offset Prior Acct A_Asset_Change.A_Reval_Cost_Offset_Prior_Acct
numeric(10)
Integer
Revaluation Cost Offset for Prior Year A_Asset_Change.A_Reval_Cost_Offset_Prior
numeric(10)
Integer
Revaluation Accumulated Depreciation Offset for Current Year A_Asset_Change.A_Reval_Accumdep_Offset_Cur
numeric(10)
Integer
A_Reval_Accumdep_Offset_Cur A_Asset_Change.A_Reval_Adep_Offset_Cur_Acct
numeric(10)
Integer
A_Reval_Accumdep_Offset_Prior A_Asset_Change.A_Reval_Adep_Offset_Prior_Acct
numeric(10)
Integer
Revaluation Accumulated Depreciation Offset for Prior Year A_Asset_Change.A_Reval_Accumdep_Offset_Prior
numeric(10)
Integer
Reval Depexp Offset Acct A_Asset_Change.A_Reval_Depexp_Offset_Acct
numeric(10)
Integer
Revaluation Expense Offs A_Asset_Change.A_Reval_Depexp_Offset
numeric(10)
Integer
A_Asset_Change_ID A_Asset_Change.A_Asset_Change_ID
numeric(10)
ID

Tab: Issue Project

Description: Automatic Issue Reporting

Help:

Asset - Issue Project - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. R_IssueProject.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. R_IssueProject.AD_Org_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. R_IssueProject.A_Asset_ID
numeric(10)
Search
Project Financial Project A Project allows you to track and control internal or external activities. R_IssueProject.C_Project_ID
numeric(10)
Search
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. R_IssueProject.Name
character varying(120)
String
Description Optional short description of the record A description is limited to 255 characters. R_IssueProject.Description
character varying(255)
String
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.

R_IssueProject.IsActive
character(1)
Yes-No
System Status Status of the system - Support priority depends on system status System status helps to prioritize support resources R_IssueProject.SystemStatus
character(1)
List
Statistics Information to help profiling the system for solving support issues Profile information do not contain sensitive information and are used to support issue detection and diagnostics as well as general anonymous statistics R_IssueProject.StatisticsInfo
character varying(60)
String
Profile Information to help profiling the system for solving support issues Profile information do not contain sensitive information and are used to support issue detection and diagnostics R_IssueProject.ProfileInfo
character varying(4000)
String

Tab: Finance Information

Description: Finace Information for the Asset

Help:

File:Asset - Finance Information - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Info_Fin.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Info_Fin.AD_Org_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_Info_Fin.A_Asset_ID
numeric(10)
Search
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.

A_Asset_Info_Fin.IsActive
character(1)
Yes-No
Asset Finance Method A_Asset_Info_Fin.A_Finance_Meth
character varying(2)
List
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson A_Asset_Info_Fin.C_BPartner_ID
numeric(10)
Search
Contract Date A_Asset_Info_Fin.A_Contract_Date
timestamp without time zone
Date
Asset Expired Date A_Asset_Info_Fin.A_Expired_Date
timestamp without time zone
Date
Asset Monthly Payment A_Asset_Info_Fin.A_Monthly_Payment
numeric
Amount
Asset Due On A_Asset_Info_Fin.A_Due_On
character varying(22)
List
Purchase Option A_Asset_Info_Fin.A_Purchase_Option
character(1)
Yes-No
Purchase Price A_Asset_Info_Fin.A_Purchase_Price
numeric
Amount
Purchase Option Credit A_Asset_Info_Fin.A_Purchase_Option_Credit
numeric(10)
Integer
Purchase Option Credit % A_Asset_Info_Fin.A_Purchase_Option_Credit_Per
numeric
Number
Text Message Text Message A_Asset_Info_Fin.TextMsg
character varying(510)
Text

Tab: License Information

Description: License Information for Asset

Help:

File:Asset - License Information - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Info_Lic.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Info_Lic.AD_Org_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_Info_Lic.A_Asset_ID
numeric(10)
Search
Description A_Asset_Info_Lic.Text
character varying(510)
String
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.

A_Asset_Info_Lic.IsActive
character(1)
Yes-No
Account State State of the Credit Card or Account holder The State of the Credit Card or Account holder A_Asset_Info_Lic.A_State
character varying(60)
String
Issuing Agency A_Asset_Info_Lic.A_Issuing_Agency
character varying(22)
String
Asset License No A_Asset_Info_Lic.A_License_No
character varying(120)
String
Asset License Fee A_Asset_Info_Lic.A_License_Fee
numeric
Amount
Asset Renewal Date A_Asset_Info_Lic.A_Renewal_Date
timestamp without time zone
Date

Tab: Insurance Information

Description: Insurance Information for asset

Help:

File:Asset - Insurance Information - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Info_Ins.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Info_Ins.AD_Org_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_Info_Ins.A_Asset_ID
numeric(10)
ID
Insurance Company A_Asset_Info_Ins.A_Insurance_Co
character varying(22)
String
Asset Policy No A_Asset_Info_Ins.A_Policy_No
character varying(100)
String
Asset Renewal Date A_Asset_Info_Ins.A_Renewal_Date
timestamp without time zone
Date
Asset Insurance Premium A_Asset_Info_Ins.A_Ins_Premium
numeric
Amount
Asset Replace Cost A_Asset_Info_Ins.A_Replace_Cost
numeric
Amount
Asset Insurance Value A_Asset_Info_Ins.A_Ins_Value
numeric
Amount
Description A_Asset_Info_Ins.Text
character varying(510)
String

Tab: Tax Information

Description: Tax information for asset

Help:

File:Asset - Tax Information - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Info_Tax.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Info_Tax.AD_Org_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_Info_Tax.A_Asset_ID
numeric(10)
ID
Asset Tax Entity A_Asset_Info_Tax.A_Tax_Entity
character varying(22)
String
Account State State of the Credit Card or Account holder The State of the Credit Card or Account holder A_Asset_Info_Tax.A_State
character varying(60)
String
Asset New Used A_Asset_Info_Tax.A_New_Used
character(1)
Yes-No
Asset Finance Method A_Asset_Info_Tax.A_Finance_Meth
character varying(2)
List
Asset Investment CR A_Asset_Info_Tax.A_Investment_CR
numeric(10)
Integer
Text Message Text Message A_Asset_Info_Tax.TextMsg
character varying(510)
String

Tab: Other Information

Description: Other information associated with asset

Help:

File:Asset - Other Information - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. A_Asset_Info_Oth.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. A_Asset_Info_Oth.AD_Org_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_Info_Oth.A_Asset_ID
numeric(10)
ID
A_User1 A_Asset_Info_Oth.A_User1
character varying(3)
String
A_User10 A_Asset_Info_Oth.A_User10
character varying(3)
String
A_User2 A_Asset_Info_Oth.A_User2
character varying(3)
String
A_User11 A_Asset_Info_Oth.A_User11
character varying(10)
String
A_User3 A_Asset_Info_Oth.A_User3
character varying(3)
String
A_User12 A_Asset_Info_Oth.A_User12
character varying(10)
String
A_User4 A_Asset_Info_Oth.A_User4
character varying(3)
String
A_User13 A_Asset_Info_Oth.A_User13
character varying(10)
String
A_User5 A_Asset_Info_Oth.A_User5
character varying(3)
String
A_User14 A_Asset_Info_Oth.A_User14
character varying(10)
String
A_User6 A_Asset_Info_Oth.A_User6
character varying(3)
String
A_User15 A_Asset_Info_Oth.A_User15
character varying(10)
String
A_User7 A_Asset_Info_Oth.A_User7
character varying(3)
String
A_User8 A_Asset_Info_Oth.A_User8
character varying(3)
String
A_User9 A_Asset_Info_Oth.A_User9
character varying(3)
String
Description A_Asset_Info_Oth.Text
character varying(510)
Memo

Tab: Expense

Description:

Help:

File:Asset - Expense - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Entry Type A_Depreciation_Exp.A_Entry_Type
character varying(3)
List
Description Optional short description of the record A description is limited to 255 characters. A_Depreciation_Exp.Description
character varying(255)
String
Expense A_Depreciation_Exp.Expense
numeric
Amount
Expense (fiscal) A_Depreciation_Exp.Expense_F
numeric
Amount
Account (debit) Account used The (natural) account used A_Depreciation_Exp.DR_Account_ID
numeric(10)
Account
Account (credit) Account used The (natural) account used A_Depreciation_Exp.CR_Account_ID
numeric(10)
Account
Asset Period A_Depreciation_Exp.A_Period
numeric(10)
Integer
Account Date Accounting Date The 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. A_Depreciation_Exp.DateAcct
timestamp without time zone
Date
Posting Type The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. A_Depreciation_Exp.PostingType
character(1)
List
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_Depreciation_Exp.A_Asset_ID
numeric(10)
Search
Processed The document has been processed The Processed checkbox indicates that a document has been processed. A_Depreciation_Exp.Processed
character(1)
Yes-No
Process Depreciation Expense A_Depreciation_Exp.Processing
character(1)
Button
Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. A_Depreciation_Exp.Help
character varying(2000)
Text
Asset Cost A_Depreciation_Exp.A_Asset_Cost
numeric
Amount
Delta Asset Cost A_Depreciation_Exp.A_Asset_Cost_Delta
numeric
Amount
Accumulated Depreciation A_Depreciation_Exp.A_Accumulated_Depr
numeric
Amount
Accumulated Depreciation (delta) A_Depreciation_Exp.A_Accumulated_Depr_Delta
numeric
Amount
Accumulated Depreciation (fiscal) A_Depreciation_Exp.A_Accumulated_Depr_F
numeric
Amount
Accumulated Depreciation - fiscal (delta) A_Depreciation_Exp.A_Accumulated_Depr_F_Delta
numeric
Amount
Remaining Amt A_Depreciation_Exp.A_Asset_Remaining
numeric
Amount
Remaining Amt (fiscal) A_Depreciation_Exp.A_Asset_Remaining_F
numeric
Amount
Usable Life - Months Months of the usable life of the asset A_Depreciation_Exp.UseLifeMonths
numeric(10)
Integer
Use Life - Months (fiscal) A_Depreciation_Exp.UseLifeMonths_F
numeric(10)
Integer
Asset Addition A_Depreciation_Exp.A_Asset_Addition_ID
numeric(10)
Search
Asset Disposed A_Depreciation_Exp.A_Asset_Disposed_ID
numeric(10)
Search
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar A_Depreciation_Exp.C_AcctSchema_ID
numeric(10)
Table Direct


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.