Asset_Data – 9Dots Management Corp, LLC

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 Office. Required.
PG_Dept_Code	Code of the PG/Department code associated to this asset; must match a code in PG_Dept. Required.
Asset_Class_Code	Code describing the type of asset; must match a code in Asset_Class. Required.
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_Code. Required.
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_Code. Optional.
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 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

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

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.