Adempiere3.1.2/en/ManPageW Asset olh
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.
Table Name : A_Asset
Name | Description | Help | Technical Data |
---|---|---|---|
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
NUMBER(10) TableDir |
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
NUMBER(10) TableDir |
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
NVARCHAR2(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
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(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. |
IsActive
CHAR(1) YesNo |
Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(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. | M_AttributeSetInstance_ID
NUMBER(10) ProductAttribute |
Version No | Version Number | VersionNo
NVARCHAR2(20) String | |
Lot No | Lot number (alphanumeric) | The Lot Number indicates the specific lot that a product was part of. | Lot
NVARCHAR2(255) String |
Serial No | Product Serial Number | The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | SerNo
NVARCHAR2(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. | AssetServiceDate
DATE Date |
Guarantee Date | Date when guarantee expires | Date when the normal guarantee or availability expires | GuaranteeDate
DATE Date |
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
NUMBER(10) TableDir |
Quantity | Quantity | The Quantity indicates the number of a specific product or item for this document. | Qty
NUMBER Quantity |
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
CHAR(1) YesNo |
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
CHAR(1) YesNo |
Lessor | The Business Partner who rents or leases | Lease_BPartner_ID
NUMBER(10) Search | |
Lease Termination | Lease Termination Date | Last Date of Lease | LeaseTerminationDate
DATE Date |
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
NUMBER(10) Search |
BPartner (Agent) | Business Partner (Agent or Sales Rep) | C_BPartnerSR_ID
NUMBER(10) Table | |
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
NUMBER(10) TableDir |
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
NUMBER(10) TableDir |
Address | Location or Address | The Location / Address field defines the location of an entity. | C_Location_ID
NUMBER(10) Search |
Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | M_Locator_ID
NUMBER(10) TableDir |
Location comment | Additional comments or remarks concerning the location | LocationComment
NVARCHAR2(255) String | |
Project | Financial Project | A Project allows you to track and control internal or external activities. | C_Project_ID
NUMBER(10) TableDir |
Depreciate | The asset will be depreciated | The asset is used internally and will be depreciated | IsDepreciated
CHAR(1) YesNo |
Fully depreciated | The asset is fully depreciated | The asset costs are fully amortized. | IsFullyDepreciated
CHAR(1) YesNo |
Usable Life - Years | Years of the usable life of the asset | UseLifeYears
NUMBER(10) Integer | |
Usable Life - Months | Months of the usable life of the asset | UseLifeMonths
NUMBER(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
NUMBER Integer |
Use units | Currently used units of the assets | UseUnits
NUMBER Integer | |
Last Maintenance | Last Maintenance Date | LastMaintenanceDate
DATE DateTime | |
Last Unit | Last Maintenance Unit | LastMaintenanceUnit
NUMBER(10) Integer | |
Last Note | Last Maintenance Note | LastMaintenanceNote
NVARCHAR2(60) String | |
Next Maintenence | Next Maintenence Date | NextMaintenenceDate
DATE DateTime | |
Next Unit | Next Maintenence Unit | NextMaintenenceUnit
NUMBER(10) Integer | |
Asset Depreciation Date | Date of last depreciation | Date of the last deprecation, if the asset is used internally and depreciated. | AssetDepreciationDate
DATE Date |
Disposed | The asset is disposed | The asset is no longer used and disposed | IsDisposed
CHAR(1) YesNo |
Asset Disposal Date | Date when the asset is/was disposed | AssetDisposalDate
DATE Date |
Tab: Delivery
Description : Delivery or availability
Help : Record of delivery or availability
Table Name : A_Asset_Delivery
Name | Description | Help | Technical Data |
---|---|---|---|
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
NUMBER(10) TableDir |
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
NUMBER(10) TableDir |
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
NUMBER(10) TableDir |
Product Download | Product downloads | Define download for a product. If the product is an asset, the user can download the data. | M_ProductDownload_ID
NUMBER(10) TableDir |
Movement Date | Date a product was moved in or out of inventory | The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement. | MovementDate
DATE DateTime |
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
NUMBER(10) Search |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Version No | Version Number | VersionNo
NVARCHAR2(20) String | |
Lot No | Lot number (alphanumeric) | The Lot Number indicates the specific lot that a product was part of. | Lot
NVARCHAR2(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. | SerNo
NVARCHAR2(40) String |
Shipment/Receipt Line | Line on Shipment or Receipt document | The Shipment/Receipt Line indicates a unique line in a Shipment/Receipt document | M_InOutLine_ID
NUMBER(10) Search |
EMail Address | Electronic Mail Address | The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). The Email Address is used to access the self service application functionality from the web. | EMail
NVARCHAR2(60) String |
Message ID | EMail Message ID | SMTP Message ID for tracking purposes | MessageID
VARCHAR2 String |
Delivery Confirmation | EMail Delivery confirmation | DeliveryConfirmation
VARCHAR2 String | |
URL | Full URL address - e.g. http://www.adempiere.org | The URL defines an fully qualified web address like http://www.adempiere.org | URL
NVARCHAR2(120) Unknown (40) |
Referrer | Referring web address | Referrer
NVARCHAR2(255) String | |
Remote Addr | Remote Address | The Remote Address indicates an alternative or external address. | Remote_Addr
NVARCHAR2(60) String |
Remote Host | Remote host Info | Remote_Host
NVARCHAR2(60) String |
Tab: Issue Project
Description : Automatic Issue Reporting
Help :
Table Name : R_IssueProject
Name | Description | Help | Technical Data |
---|---|---|---|
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
NUMBER(10) TableDir |
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
NUMBER(10) TableDir |
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
NUMBER(10) Search |
Project | Financial Project | A Project allows you to track and control internal or external activities. | C_Project_ID
NUMBER(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. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(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. |
IsActive
CHAR(1) YesNo |
System Status | Status of the system - Support priority depends on system status | System status helps to prioritize support resources | SystemStatus
CHAR(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 | StatisticsInfo
NVARCHAR2(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 | ProfileInfo
NVARCHAR2(60) String |