View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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


AssetServiceDate Yes TIMESTAMP (7) The date when the asset was put into service - usually used as start date for depreciation.
UseLifeMonths Yes DECIMAL (10,0) Months of the usable life of the asset
GuaranteeDate Yes TIMESTAMP (7) Date when the normal guarantee or availability expires
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.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
Help Yes NVARCHAR (2000) The Help field contains a hint, comment or help about the use of this item.
LocationComment Yes NVARCHAR (255) Additional comments or remarks concerning the location
Description Yes NVARCHAR (255) A description is limited to 255 characters.
IsOwned No CHAR (1) The asset may not be in possession, but the asset is legally owned by the organization
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.

VersionNo Yes VARCHAR (20) Version Number
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
C_Location_ID Yes VARCHAR (32) The Location / Address field defines the location of an entity.
AssetDisposalDate Yes TIMESTAMP (7) Date when the asset is/was disposed
UseLifeYears Yes DECIMAL (10,0) Years of the usable life of the asset
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
AssetDepreciationDate Yes TIMESTAMP (7) Date of the last deprecation, if the asset is used internally and depreciated.
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.

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.
M_Locator_ID Yes VARCHAR (32) The Locator ID indicates where in a Warehouse a product is located.
IsDisposed No CHAR (1) The asset is no longer used and disposed
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
Lot Yes VARCHAR (20) The Lot Number indicates the specific lot that a product was part of.
IsDepreciated No CHAR (1) The asset is used internally and will be depreciated
IsFullyDepreciated No CHAR (1) The asset costs are fully amortized.
LifeUseUnits Yes DECIMAL Life use and the actual use may be used to calculate the depreciation
Processing Yes CHAR (1) When this field is set as 'Y' a process is being performed on this record.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
C_BPartner_Location_ID Yes VARCHAR (32) The Partner address indicates the location of a Business Partner
SerNo Yes VARCHAR (20) The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1.
A_Asset_ID No VARCHAR (32) Any item of economic value owned by the corporation, especially that which could be converted to cash.
UseUnits Yes DECIMAL Currently used units of the assets
Datepurchased Yes TIMESTAMP (7) Date when this good was bougth.
Datecancelled Yes TIMESTAMP (7) Cancellation date
Amortizationstartdate Yes TIMESTAMP (7) Date in which this asset starts depreciating
Amortizationenddate Yes TIMESTAMP (7) Date in which this asset ends depreciating
Annualamortizationpercentage Yes DECIMAL Anual percentage used to depreciate this asset.
C_Currency_ID Yes VARCHAR (32) Indicates the currency to be used when processing this document.
AssetValueAmt Yes DECIMAL Book Value of the asset
Residualassetvalueamt Yes DECIMAL Value of the asset once it has been totally depreciated.
M_AttributeSetInstance_ID Yes VARCHAR (32) The values of the actual Product Attributes
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.
Acctvalueamt Yes DECIMAL Accounting value amount
Amortizationtype No VARCHAR (60) Indicates the method used to depreciate this asset.
Amortizationvalueamt Yes DECIMAL Accumulate depreciation amount
Assetschedule No VARCHAR (60) Refers to the periods chosen between depreciation entries (monthly, yearly...).
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).
Processed No VARCHAR (60) The Processed checkbox indicates that a document has been processed.
Profit Yes DECIMAL
Qty Yes DECIMAL The Quantity indicates the number of a specific product or item for this document.
Depreciatedvalue Yes DECIMAL Is the value depreciated from processed amortizations.
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.
Depreciatedplan Yes DECIMAL Value that is planned to be depreciated.
Depreciatedpreviousamt Yes DECIMAL
M_Product_ID Yes VARCHAR (32) Identifies an item which is either purchased or sold in this organization.
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.
Amortizationcalctype No VARCHAR (60) This field indicates how depreciation will be calculated: choosing the time or the percentage.
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.
C_Project_ID Yes VARCHAR (32) Identifier of a project defined within the Project & Service Management module.
IsStatic No CHAR (1) Prevents from moving the record into the tree
Is30DayMonth No CHAR (1) When calculating the amortization plan every month will be considered as a 30 day month.
Process_Asset No VARCHAR (60) The Processed checkbox indicates that a document has been processed.

Columns

In Service Date



top


Usable Life - Months



top


Expiration Date



top


Business Partner


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

top


Client


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

top


Updated By


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

top


Help/Comment



top


Location comment



top


Description



top


Owned



top


Search Key



top


Version No.



top


Creation Date



top


Location / Address


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

top


Asset Disposal Date



top


Usable Life - Years



top


Created By


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

top


Asset Depreciation Date



top


Active



top


In Possession



top


Storage Bin


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

top


Disposed



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


Lot Name



top


Depreciate



top


Fully Depreciated



top


Life use



top


Process Now



top


Updated



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


Serial No.



top


Asset



top


Use units



top


Purchase Date



top


Cancellation Date



top


Depreciation Start Date



top


Depreciation End Date



top


Annual Depreciation %



top


Currency


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

top


Asset Value



Callout: SL_Assets

This column has a callout associated.

It is implemented by [1] Java Class.

top


Residual 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


Organization


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

top


Acctvalueamt



top


Depreciation Type



List values: Amortization type

The allowed values for this list are:

top


Depreciation Amt.



Callout: SL_Assets

This column has a callout associated.

It is implemented by [3] Java Class.

top


Amortize



List values: Amortization schedule

The allowed values for this list are:

top


Document No.



top


Processed


List values: Create/recalculate amortization

The allowed values for this list are:

top


Profit



top


Quantity



top


Depreciated Value



top


Name


top


Depreciated Plan



top


Previously Depreciated Amt.



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


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 [5] Java Class.

top


Calculate Type



List values: AmortizationCalcType

The allowed values for this list are:

top


Summary Level



top


Project


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

top


Static



top


Every Month is 30 Days



top


Process_Asset


List values: Create/recalculate amortization

The allowed values for this list are:

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 1,534 times. This page was last modified on 1 September 2016, at 02:29. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.