Modules:IDL Assets
Introduction
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. |