ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.assetmgmt/A Asset
A_Asset
Any item of economic value owned by the corporation, especially that which could be converted to cash.
- Name:FinancialMgmtAsset
- Classname:Asset
This table contains the following columns:
Name | Nullable | Data Type | Description |
A_Asset_ID | N | VARCHAR2(32) | An item which is owned and exchangeable for cash. |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
Value | N | NVARCHAR2(40) | A fast method for finding a particular record. |
Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
Help | Y | NVARCHAR2(2000) | A comment that adds additional information to help users work with fields. |
A_Asset_Group_ID | N | VARCHAR2(32) | A classification of assets based on similar characteristics. |
M_Product_ID | Y | VARCHAR2(32) | An item produced by a process. |
SerNo | Y | VARCHAR2(20) | An attribute used as a unique identifier for a product. |
Lot | Y | VARCHAR2(20) | A group of identical or similar items organized and placed into inventory under one number. |
VersionNo | Y | VARCHAR2(20) | Version Number |
GuaranteeDate | Y | DATE | The date upon which an item is guaranteed to be of good quality. |
AssetServiceDate | Y | DATE | Date when Asset was put into service |
IsOwned | N | CHAR(1) | The asset is owned by the organization |
AssetDepreciationDate | Y | DATE | Date of last depreciation |
UseLifeYears | Y | NUMBER(10, 0) | Years of the usable life of the asset |
UseLifeMonths | Y | NUMBER(10, 0) | Months of the usable life of the asset |
LifeUseUnits | Y | NUMBER | Units of use until the asset is not usable anymore |
UseUnits | Y | NUMBER | Currently used units of the assets |
IsDisposed | N | CHAR(1) | The asset is disposed |
AssetDisposalDate | Y | DATE | Asset disposal date |
IsInPosession | N | CHAR(1) | The asset is in the possession of the organization |
LocationComment | Y | NVARCHAR2(255) | Additional comments or remarks concerning the location |
M_Locator_ID | Y | VARCHAR2(32) | A set of coordinates (x, y, z) which help locate an item in a warehouse. |
C_BPartner_ID | Y | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
C_BPartner_Location_ID | Y | VARCHAR2(32) | The location of the selected business partner. |
C_Location_ID | Y | VARCHAR2(32) | A specific place or residence. |
IsDepreciated | N | CHAR(1) | x not implemented |
IsFullyDepreciated | N | CHAR(1) | The asset is fully depreciated |
AD_User_ID | Y | VARCHAR2(32) | An acquaintance to reach for information related to the business partner. |
Amortizationenddate | Y | DATE | Depreciation end date |
Amortizationstartdate | Y | DATE | Depreciation Start Date |
Annualamortizationpercentage | Y | NUMBER | Depreciation annual % |
AssetValueAmt | Y | NUMBER | Asset value |
C_Currency_ID | Y | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
Datecancelled | Y | DATE | Cancellation date |
Datepurchased | Y | DATE | Purchase date |
M_AttributeSetInstance_ID | Y | VARCHAR2(32) | An attribute associated with a product as part of an attribute set. |
Residualassetvalueamt | Y | NUMBER | Residual asset value amount |
Acctvalueamt | Y | NUMBER | Accounting value amount |
Amortizationtype | Y | VARCHAR2(60) | Depreciation Type |
Amortizationvalueamt | Y | NUMBER | Depreciation Amount |
Assetschedule | Y | VARCHAR2(60) | Asset schedule |
DocumentNo | Y | NVARCHAR2(30) | An often automatically generated identifier for all documents. |
Processed | N | VARCHAR2(60) | A confirmation that the associated documents or requests are processed. |
Profit | Y | NUMBER | null |
Qty | Y | NUMBER | The number of a certain item. |
Amortizationcalctype | Y | VARCHAR2(60) | Calculate type |
Depreciatedplan | Y | NUMBER | Depreciated plan |
Depreciatedpreviousamt | Y | NUMBER | null |
Depreciatedvalue | Y | NUMBER | Depreciated value |
Other Info
Check constraints
These are the check constraints for this table:
- A_ASSET_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- A_ASSET_ISDISPOSED_CHK: ISDISPOSED IN ('Y', 'N')
- A_ASSET_ISINPOSESSION_CHK: ISINPOSESSION IN ('Y', 'N')
- A_ASSET_ISOWNED_CHK: ISOWNED IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- A_ASSET_KEY
Columns
Asset
Any item of economic value owned by the corporation, especially that which could be converted to cash.
- Physical column name: A_Asset_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
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 reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Search Key
A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).
Usually, company's internal identifiers for various records (products, customers, etc) are stored here.
- Physical column name: Value
- Property Name: searchKey
- Reference: String
Name
A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
Help/Comment
The Help field contains a hint, comment or help about the use of this item.
- Physical column name: Help
- Property Name: helpComment
- Reference: Text
Asset Category
- Physical column name: A_Asset_Group_ID
- Property Name: assetCategory
- Reference: TableDir
Foreign key column to A_Asset_Group table, (column: A_Asset_Group_ID)
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
Callout: SL_Asset_Product
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Asset_Product Java class.
Serial No.
The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1.
- Physical column name: SerNo
- Property Name: serialNo
- Reference: String
Lot Name
The Lot Number indicates the specific lot that a product was part of.
- Physical column name: Lot
- Property Name: lotName
- Reference: String
Version No.
Version Number
- Physical column name: VersionNo
- Property Name: versionNo
- Reference: String
Expiration Date
Date when the normal guarantee or availability expires
- Physical column name: GuaranteeDate
- Property Name: expirationDate
- Reference: Date
In Service Date
The date when the asset was put into service - usually used as start date for depreciation.
- Physical column name: AssetServiceDate
- Property Name: inServiceDate
- Reference: Date
Owned
The asset may not be in possession, but the asset is legally owned by the organization
- Physical column name: IsOwned
- Property Name: owned
- Reference: YesNo
Asset Depreciation Date
Date of the last deprecation, if the asset is used internally and depreciated.
- Physical column name: AssetDepreciationDate
- Property Name: assetDepreciationDate
- Reference: Date
Usable Life - Years
Years of the usable life of the asset
- Physical column name: UseLifeYears
- Property Name: usableLifeYears
- Reference: Integer
Usable Life - Months
Months of the usable life of the asset
- Physical column name: UseLifeMonths
- Property Name: usableLifeMonths
- Reference: Integer
Life use
Life use and the actual use may be used to calculate the depreciation
- Physical column name: LifeUseUnits
- Property Name: lifeUse
- Reference: Integer
Use units
Currently used units of the assets
- Physical column name: UseUnits
- Property Name: useUnits
- Reference: Integer
Disposed
The asset is no longer used and disposed
- Physical column name: IsDisposed
- Property Name: disposed
- Reference: YesNo
Asset Disposal Date
Date when the asset is/was disposed
- Physical column name: AssetDisposalDate
- Property Name: assetDisposalDate
- Reference: Date
In Possession
Assets which are not in possession are e.g. at Customer site and may or may not be owned by the company.
- Physical column name: IsInPosession
- Property Name: inPossession
- Reference: YesNo
Location comment
Additional comments or remarks concerning the location
- Physical column name: LocationComment
- Property Name: locationComment
- Reference: String
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: TableDir
Foreign key column to M_Locator table, (column: M_Locator_ID)
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
- This column is a child for a buisiness object (is Parent)
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Partner Address
- Physical column name: C_BPartner_Location_ID
- Property Name: partnerAddress
- Reference: TableDir
Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)
Validation Rule C_BPartner Location: null. With the following code:
C_BPartner_Location.C_BPartner_ID=@C_BPartner_ID@
Location / Address
- Physical column name: C_Location_ID
- Property Name: locationAddress
- Reference: Search
Foreign key column to C_Location table, (column: C_Location_ID)
Depreciate
The asset is used internally and will be depreciated
- Physical column name: IsDepreciated
- Property Name: depreciate
- Reference: YesNo
Fully Depreciated
The asset costs are fully amortized.
- Physical column name: IsFullyDepreciated
- Property Name: fullyDepreciated
- Reference: YesNo
- Default value: N
User/Contact
- Physical column name: AD_User_ID
- Property Name: userContact
- Reference: TableDir
Foreign key column to AD_User table, (column: AD_User_ID)
Validation Rule AD_User C_BPartner User/Contacts: null. With the following code:
AD_User.C_BPartner_ID=@C_BPartner_ID@
Depreciation End Date
Date in which this asset ends depreciating
- Physical column name: Amortizationenddate
- Property Name: depreciationEndDate
- Reference: Date
Depreciation Start Date
Date in which this asset starts depreciating
- Physical column name: Amortizationstartdate
- Property Name: depreciationStartDate
- Reference: Date
Annual Depreciation %
Anual percentage used to depreciate this asset.
- Physical column name: Annualamortizationpercentage
- Property Name: annualDepreciation
- Reference: Number
Asset Value
Book Value of the asset
- Physical column name: AssetValueAmt
- Property Name: assetValue
- Reference: Amount
Callout: SL_Assets
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Assets Java class.
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
- Default value: @C_Currency_ID@
Foreign key column to C_Currency table, (column: C_Currency_ID)
Cancellation Date
Cancellation date
- Physical column name: Datecancelled
- Property Name: cancellationDate
- Reference: Date
Purchase Date
Date when this good was bougth.
- Physical column name: Datepurchased
- Property Name: purchaseDate
- Reference: Date
Attribute Set Value
- Physical column name: M_AttributeSetInstance_ID
- Property Name: attributeSetValue
- Reference: PAttribute
Foreign key column to M_AttributeSetInstance table, (column: M_AttributeSetInstance_ID)
Residual Asset Value
Value of the asset once it has been totally depreciated.
- Physical column name: Residualassetvalueamt
- Property Name: residualAssetValue
- Reference: Amount
Callout: SL_Assets
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Assets Java class.
Acctvalueamt
Accounting value amount
- Physical column name: Acctvalueamt
- Property Name: acctvalueamt
- Reference: Number
Depreciation Type
Indicates the method used to depreciate this asset.
- Physical column name: Amortizationtype
- Property Name: depreciationType
- Reference: List
List values: Amortization type
The allowed values for this list are:
- LI (Linear)
Depreciation Amt.
Accumulate depreciation amount
- Physical column name: Amortizationvalueamt
- Property Name: depreciationAmt
- Reference: Amount
Callout: SL_Assets
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Assets Java class.
Amortize
Refers to the periods chosen between depreciation entries (monthly, yearly...).
- Physical column name: Assetschedule
- Property Name: amortize
- Reference: List
List values: Amortization schedule
The allowed values for this list are:
- MO (Monthly)
- YE (Yearly)
Document No.
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 will be empty when creating 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 "Document Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table inside the database (e.g. C_Order).
- Physical column name: DocumentNo
- Property Name: documentNo
- Reference: String
Processed
The Processed checkbox indicates that a document has been processed.
- Physical column name: Processed
- Property Name: processed
- Reference: Button
- Default value: N
Profit
- Physical column name: Profit
- Property Name: profit
- Reference: Number
Quantity
The Quantity indicates the number of a specific product or item for this document.
- Physical column name: Qty
- Property Name: quantity
- Reference: Quantity
Calculate Type
This field indicates how depreciation will be calculated: choosing the time or the percentage.
- Physical column name: Amortizationcalctype
- Property Name: calculateType
- Reference: List
List values: AmortizationCalcType
The allowed values for this list are:
- PE (Percentage)
- TI (Time)
Depreciated Plan
Value that is planned to be depreciated.
- Physical column name: Depreciatedplan
- Property Name: depreciatedPlan
- Reference: Amount
- Default value: 0
Previously Depreciated Amt.
- Physical column name: Depreciatedpreviousamt
- Property Name: previouslyDepreciatedAmt
- Reference: Amount
- Default value: 0
Depreciated Value
Is the value depreciated from processed amortizations.
- Physical column name: Depreciatedvalue
- Property Name: depreciatedValue
- Reference: Amount
- Default value: 0
Related tables
Tables that link this table:
- FinancialMgmtAccountingFact.Asset
- FinancialMgmtAmortizationLine.Asset
- FinancialMgmtAssetAccounts.Asset
- FinancialMgmtAssetAmortization.Asset