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. |