View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.assetmgmt/A Asset

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.assetmgmt


Contents

A_Asset

This table contains the following columns:

Name Nullable Data Type Description


Acctvalueamt Yes DECIMAL Accounting value amount
IsActive No CHAR (1) 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.

Assetschedule No VARCHAR (60) Refers to the periods chosen between depreciation entries (monthly, yearly...).
Annualamortizationpercentage Yes DECIMAL Anual percentage used to depreciate this asset.
A_Asset_ID No VARCHAR (32) Any item of economic value owned by the corporation, especially that which could be converted to cash.
A_Asset_Group_ID No VARCHAR (32) The group of assets determines default accounts. If an asset group is selected in the product category, assets are created when delivering the asset.
AssetDepreciationDate Yes TIMESTAMP (7) Date of the last deprecation, if the asset is used internally and depreciated.
AssetDisposalDate Yes TIMESTAMP (7) Date when the asset is/was disposed
AssetValueAmt Yes DECIMAL Book Value of the asset
M_AttributeSetInstance_ID Yes VARCHAR (32) The values of the actual Product Attributes
C_BPartner_ID Yes VARCHAR (32) A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
Amortizationcalctype No VARCHAR (60) This field indicates how depreciation will be calculated: choosing the time or the percentage.
Datecancelled Yes TIMESTAMP (7) Cancellation date
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
C_Currency_ID Yes VARCHAR (32) Indicates the currency to be used when processing this document.
IsDepreciated No CHAR (1) The asset is used internally and will be depreciated
Depreciatedplan Yes DECIMAL Value that is planned to be depreciated.
Depreciatedvalue Yes DECIMAL Is the value depreciated from processed amortizations.
Amortizationvalueamt Yes DECIMAL Accumulate depreciation amount
Amortizationenddate Yes TIMESTAMP (7) Date in which this asset ends depreciating
Amortizationstartdate Yes TIMESTAMP (7) Date in which this asset starts depreciating
Amortizationtype No VARCHAR (60) Indicates the method used to depreciate this asset.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
IsDisposed No CHAR (1) The asset is no longer used and disposed
DocumentNo Yes NVARCHAR (30) 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).
Is30DayMonth No CHAR (1) When calculating the amortization plan every month will be considered as a 30 day month.
GuaranteeDate Yes TIMESTAMP (7) Date when the normal guarantee or availability expires
IsFullyDepreciated No CHAR (1) The asset costs are fully amortized.
Help Yes NVARCHAR (2000) The Help field contains a hint, comment or help about the use of this item.
IsInPosession No CHAR (1) Assets which are not in possession are e.g. at Customer site and may or may not be owned by the company.
AssetServiceDate Yes TIMESTAMP (7) The date when the asset was put into service - usually used as start date for depreciation.
LifeUseUnits Yes DECIMAL Life use and the actual use may be used to calculate the depreciation
C_Location_ID Yes VARCHAR (32) The Location / Address field defines the location of an entity.
LocationComment Yes NVARCHAR (255) Additional comments or remarks concerning the location
Lot Yes VARCHAR (20) The Lot Number indicates the specific lot that a product was part of.
Name No NVARCHAR (60) 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.
AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
IsOwned No CHAR (1) The asset may not be in possession, but the asset is legally owned by the organization
C_BPartner_Location_ID Yes VARCHAR (32) The Partner address indicates the location of a Business Partner
Depreciatedpreviousamt Yes DECIMAL
Processing Yes CHAR (1) When this field is set as 'Y' a process is being performed on this record.
Process_Asset No VARCHAR (60) The Processed checkbox indicates that a document has been processed.
Processed No VARCHAR (60) The Processed checkbox indicates that a document has been processed.
M_Product_ID Yes VARCHAR (32) Identifies an item which is either purchased or sold in this organization.
Profit Yes DECIMAL
C_Project_ID Yes VARCHAR (32) Identifier of a project defined within the Project & Service Management module.
Datepurchased Yes TIMESTAMP (7) Date when this good was bougth.
Qty Yes DECIMAL The Quantity indicates the number of a specific product or item for this document.
Residualassetvalueamt Yes DECIMAL Value of the asset once it has been totally depreciated.
Value No NVARCHAR (40) 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.

SerNo Yes VARCHAR (20) The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1.
IsStatic No CHAR (1) Prevents from moving the record into the tree
M_Locator_ID Yes VARCHAR (32) The Locator ID indicates where in a Warehouse a product is located.
Issummary No CHAR (1) A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
UseLifeMonths Yes DECIMAL (10,0) Months of the usable life of the asset
UseLifeYears Yes DECIMAL (10,0) Years of the usable life of the asset
UseUnits Yes DECIMAL Currently used units of the assets
AD_User_ID Yes VARCHAR (32) The User identifies a unique user in the system. This could be an internal user or a business partner contact
VersionNo Yes VARCHAR (20) Version Number

Columns

Acctvalueamt



top


Active



top


Amortize



List values: Amortization schedule

The allowed values for this list are:

top


Annual Depreciation %



top


Asset



top


Asset Category


Foreign key column to A_Asset_Group table, (column: A_Asset_Group_ID)

Callout: SL_Depreciate

This column has a callout associated.

It is implemented by [1] Java Class.

top


Asset Depreciation Date



top


Asset Disposal Date



top


Asset Value



Callout: SL_Assets

This column has a callout associated.

It is implemented by [2] Java Class.

top


Attribute Set Value


Foreign key column to M_AttributeSetInstance table, (column: M_AttributeSetInstance_ID)

top


Business Partner


Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top


Calculate Type



List values: AmortizationCalcType

The allowed values for this list are:

top


Cancellation Date



top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID)

top


Created By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Creation Date



top


Currency


Foreign key column to C_Currency table, (column: C_Currency_ID)

top


Depreciate



top


Depreciated Plan



top


Depreciated Value



top


Depreciation Amt.



Callout: SL_Assets

This column has a callout associated.

It is implemented by [3] Java Class.

top


Depreciation End Date



top


Depreciation Start Date



top


Depreciation Type



List values: Amortization type

The allowed values for this list are:

top


Description



top


Disposed



top


Document No.



top


Every Month is 30 Days



top


Expiration Date



top


Fully Depreciated



top


Help/Comment



top


In Possession



top


In Service Date



top


Life use



top


Location / Address


Foreign key column to C_Location table, (column: C_Location_ID)

top


Location comment



top


Lot Name



top


Name


top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

top


Owned



top


Partner Address


Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID) It has a validation "C_BPartner Location", with the following code

C_BPartner_Location.C_BPartner_ID=@C_BPartner_ID@

top


Previously Depreciated Amt.



top


Process Now



top


Process_Asset


List values: Create/recalculate amortization

The allowed values for this list are:

top


Processed


List values: Create/recalculate amortization

The allowed values for this list are:

top


Product


Foreign key column to M_Product table, (column: M_Product_ID)

Callout: SL_Asset_Product

This column has a callout associated.

It is implemented by [4] Java Class.

top


Profit



top


Project


Foreign key column to C_Project table, (column: C_Project_ID)

top


Purchase Date



top


Quantity



top


Residual Asset Value



Callout: SL_Assets

This column has a callout associated.

It is implemented by [5] Java Class.

top


Search Key



top


Serial No.



top


Static



top


Storage Bin


Foreign key column to M_Locator table, (column: M_Locator_ID)

top


Summary Level



top


Updated



top


Updated By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Usable Life - Months



top


Usable Life - Years



top


Use units



top


User/Contact


Foreign key column to AD_User table, (column: AD_User_ID) It has a validation "AD_User C_BPartner User/Contacts", with the following code

AD_User.C_BPartner_ID=@C_BPartner_ID@

top


Version No.



top


Other Info

Indices

These are the indices for this table (for each index there is a list of all the columns included within it):

top

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.financialmgmt.assetmgmt

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.assetmgmt/A_Asset"

This page has been accessed 6,406 times. This page was last modified on 4 September 2023, at 01:58. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.