Asset_Data

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.

Idx Field Type Maximum Length Required
1 Year Numeric 4 Yes
2 Period Numeric 2 Yes
3 Office_Code Alphanumeric 20 Yes
4 PG_Dept_Code Alphanumeric 20 Yes
5 Asset_Class_Code Alphanumeric 20 Yes
6 Currency_Code Alphanumeric 3 Yes
7 Local_Depreciation_Amount Money   Yes
8 Base_Depreciation_Amount Money   No
9 Item_Description Alphanumeric 2000 No

 

Summary

Asset_Data

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.

Columns

 

Year

Four digit year. Required.

Period

Two digit fiscal period number for the period describing this asset’s depreciation amount. Required.

Office_Code

Code of the office where this asset is located; must match a code in OfficeRequired.

PG_Dept_Code

Code of the PG/Department code associated to this asset; must match a code in PG_DeptRequired.

Asset_Class_Code

Code describing the type of asset; must match a code in Asset_ClassRequired.

Currency_Code

Currency code for value in the Local_Depreciation_Amount column; must match entry in Currency; this is meant to validate the local amount. Required.

Local_Depreciation_Amount

Amount of depreciation expense of this asset for the given period in the local currency of the office specified byCurrency_CodeRequired.

Base_Depreciation_Amount

Amount of depreciation expense of this asset for the given period in the base (or reporting) currency. Optional.

Item_Description

Description of the asset; may be left blank for a default description based on the Asset_Class_CodeOptional.

Documentation

 

What to Load

Data should be loaded at least for the current planning year.

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.

Sample CSV Load File

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

Year

Year numeric(

4

) NOT NULL

Four digit year. Required.

 

 

Field Load File Format
Type Numeric
Maximum Length 4
Required Yes

Period

Period numeric(

2

) NOT NULL

Two digit fiscal period number for the period describing this asset’s depreciation amount. Required.

 

 

Field Load File Format
Type Numeric
Maximum Length 2
Required Yes

Office_Code

Office_Code varchar(

20

) NOT NULL

Code of the office where this asset is located; must match a code in OfficeRequired.

 

 

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

 

 

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

 

 

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

 

 

Field Load File Format
Type Money
Required Yes

Base_Depreciation_Amount

Base_Depreciation_Amount money NULL

Amount of depreciation expense of this asset for the given period in the base (or reporting) currency. Optional.

 

 

Field Load File Format
Type Money
Required No

Item_Description

Item_Description varchar(

2000

) NULL

Description of the asset; may be left blank for a default description based on the Asset_Class_CodeOptional.

 

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

Documentation

What to Load

Data should be loaded at least for the current planning year.  Historical information may also be loaded for reporting purposes.

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.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk