ManPageW Asset

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



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.

Table Name  : A_Asset

Fields

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

Fields

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

Fields

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

Contributions

Personal tools