Used as the core source for loading the Current Asset Data into the Xchange Asset cube in Planning in order to calculate depreciation expenses for existing assets. Loading asset data is optional.
The amount value is not required; if not specified the total is what is input through the Capital Expenditures module in i-Performance Planning.
NOTE
The current implementation of the Capital Expenditures module is Single Currency.
|
Summary
Used as the core source for loading the Current Asset Data into the Xchange Asset cube in Planning in order to calculate depreciation expenses for existing assets. |
|
|
|
Four digit year. Required. |
|
Two digit fiscal period number for the period describing this asset’s depreciation amount. Required. |
|
Code of the office where this asset is located; must match a code in Office. Required. |
|
Code of the PG/Department code associated to this asset; must match a code in PG_Dept. Required. |
|
Code describing the type of asset; must match a code in Asset_Class. Required. |
|
Currency code for value in the Local_Depreciation_Amount column; must match entry in Currency; this is meant to validate the local amount. Required. |
|
Amount of depreciation expense of this asset for the given period in the local currency of the office specified byCurrency_Code. Required. |
|
Amount of depreciation expense of this asset for the given period in the base (or reporting) currency. Optional. |
|
Description of the asset; may be left blank for a default description based on the Asset_Class_Code. Optional. |
|
|
|
Data should be loaded at least for the current planning year. |
|
Records must be loaded using a consistent currency theme for either a Single-Currency Implementation or a Multi-Currency Implementation; regardless of the implementation, values are loaded into Local and if desired, converted to Base. |
|
This load file is a small sample of an Asset Data load. |
Sample CSV Load File
This load file is a small sample of an Asset Data load.
Filename: Asset_Data.csv
2007,1,01,004,E,USD,907.84,, 2007,1,01,010,F,USD,2530.90,, 2007,1,01,015,E,USD,1541.88,, 2007,1,01,028,L,USD,309.47,, 2007,1,01,030,C,USD,2098.81,, 2007,1,01,034,C,USD,3191.57,, 2007,1,01,035,E,USD,2963.63,, 2007,1,01,037,C,USD,1623.14,,
Columns
Office_Code
Office_Code varchar(
20
) NOT NULL
Code of the office where this asset is located; must match a code in Office. Required.
Field Load File Format | |
Type | Alphanumeric |
Maximum Length | 20 |
Required | Yes |
PG_Dept_Code
PG_Dept_Code varchar(
20
) NOT NULL
Code of the PG/Department code associated to this asset; must match a code in PG_Dept. Required.
Field Load File Format | |
Type | Alphanumeric |
Maximum Length | 20 |
Required | Yes |
Asset_Class_Code
Asset_Class_Code varchar(
20
) NOT NULL
Code describing the type of asset; must match a code in Asset_Class. Required.
Field Load File Format | |
Type | Alphanumeric |
Maximum Length | 20 |
Required | Yes |
Currency_Code
Currency_Code varchar(
3
) NOT NULL
Currency code for value in the Local_Depreciation_Amount column; must match entry in Currency; this is meant to validate the local amount. Required.
Field Load File Format | |
Type | Alphanumeric |
Maximum Length | 3 |
Required | Yes |
Local_Depreciation_Amount
Local_Depreciation_Amount money NOT NULL
Amount of depreciation expense of this asset for the given period in the local currency of the office specified by Currency_Code. Required.
Field Load File Format | |
Type | Money |
Required | Yes |
Item_Description
Item_Description varchar(
2000
) NULL
Description of the asset; may be left blank for a default description based on the Asset_Class_Code. Optional.
As this data is aggregated prior to adding to the fact table, this description is currently ignored.
Field Load File Format | |
Type | Alphanumeric |
Maximum Length | 2000 |
Required | No |
Currency Implementation
Records must be loaded using a consistent currency theme for either a Single-Currency Implementation or a Multi-Currency Implementation; regardless of the implementation, values are loaded into Local and if desired, converted to Base.
Single-Currency Implementation
Only a single currency may appear (and must be the same as the base currency) and all records must have that <Currency_Code>. Typically for most implementations, base currency will be USD.
If the base amount is not specified, it will be defaulted to the local amount.
Multi-Currency Implementations
The amount is specified in the local currency of the office. This amount must also be converted to the base currency. If the <Currency_Code> is the base currency, any amount not having a base value will be defaulted to the local amount.
0 Comments