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

Modules:IDL Assets


Assets are everything of value that is owned by the company. Typically the assets that are purchased for continued and long-term use in earning profit in a business, are selectively depreciated.

Input file definition

Field name Type Nullable Description Accepted values Comment
TransactionalOrg String(40) No Indicates the organization to be used when processing transactional documents. [Organization search key]
SearchKey String(40) No A unique identifier for the Asset. If any asset with this search key doesn't exist, a new asset will be created with this name. If it exist, the asset will be used (not updated).
Name String(60) No The name of the asset.
Description String(255) Yes More information about the asset.
Product String(40) Yes Identifies an item which is either purchased or sold in this organization. [Product search key]
AssetCategory String(60) No* The group of assets determines default accounts. If an asset group is selected in the product category, assets are created when delivering the asset. [Asset Category name] If any asset category with this name doesn't exist, a new asset category will be created with this name. If it exist, the asset category will be used (not updated).
Quantity Number Yes Indicates the number of a specific product or item for this document.
CalculateType String(60) No* Indicates how depreciation will be calculated. [AmortizationCalcType reference list] In English: {Percentage, Time}
AmortizeSchedule String(60) Yes Refers to the periods chosen between depreciation entries (monthly, yearly...). [Amortization schedule reference list] In English: {Yearly, Monthly}
UsableLifeYears Number Yes Years of the usable life of the asset.
UsableLifeMonths Number Yes Months of the usable life of the asset.
AnnualDepreciation Number Yes Annual percentage used to depreciate this asset.
Currency String(60) No* Indicates the currency to be used when processing this document. [Currency ISO code]
PurchaseDate Date Yes Date when this good was bougth. yyyy-MM-dd format
CancellationDate Date Yes Cancellation date. yyyy-MM-dd format
DepreciationStartDate Date No Date in which this asset starts depreciating yyyy-MM-dd format
DepreciationEndDate Date Yes Date in which this asset ends depreciating. yyyy-MM-dd format
AssetValue Number Yes Book Value of the asset
ResidualAssetValue Number Yes Value of the asset once it has been totally depreciated.
DepreciationAmount Number No Accumulate depreciation amount.
PreviouslyDepreciatedAmount Number Yes. Previously depreciated amount.
DepreciatedValue Number Yes Is the value depreciated from processed amortizations.
DepreciatedPlan Number Yes Value that is planned to be depreciated.

* This fields can be NULL if they have a default value associated.

Default Value definition

Field name Type Accepted values Examples
TransactionalOrg String(40) [search_key] column from [AD_Org] table
Currency String(3) [iso_code] column from [c_currency] table EUR, USD, GBP, ...
AssetCategory String(60) [name] column from [a_asset_group] table
CalculateType String(60) [AmortizationCalcType reference list] English: {Percentage, Time}
AmortizeSchedule String(60) [Amortization schedule reference list] English: {Yearly, Monthly}
UsableLifeMonths Number
UsableLifeYears Number
DepreciationStartDate Date yyyy-MM-dd format.

Retrieved from ""

This page has been accessed 4,140 times. This page was last modified on 13 January 2016, at 09:13. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.