Asset_Class

Used as the core source for loading the Asset Class dimension to support loading of current assets.  These asset classes are used to calculate depreciation expenses in the Capital Expenditure module.  Loading asset data is optional.  This dimension is variable depending on how assets are to be categorized.

IdxFieldTypeMaximum LengthRequired1Asset_Class_Code2Asset_Class_Name
Alphanumeric 20 Yes
Alphanumeric 50 Yes

 

Sample Asset Class Codes and Descriptions

B

Buildings

C

Computers

E

Equipment

F

Furniture

L

Leasehold Improvements

Summary

Asset_Class

Columns

Documentation

Used as the core source for loading the Asset Class dimension to support loading of current assets.

 

Asset_Class_Code

The uniquely identifying Asset Class code. Required.

Asset_Class_Name

The description for the Asset Class code. Required.

 

Sample CSV Load File

This load file is a small sample of an Asset Class load.

Sample CSV Load File

This load file is a small sample of an Asset Class load.

Filename: Asset_Class.csv

C,Computers B,Buildings E,Equipment F,Furniture L,Leasehold Improvement

Columns

Asset_Class_Code

Asset_Class_Code varchar(

20

) NOT NULL

The uniquely identifying Asset Class code. Required.

 

 

Field Load File FormatTypeMaximum LengthRequired

Alphanumeric
20
Yes

Asset_Class_Name

Asset_Class_Name varchar(

50

) NOT NULL

The description for the Asset Class code. Required.

 

 

Field Load File FormatTypeMaximum LengthRequired

Alphanumeric
50
Yes

 

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk