Asset_Class

satori-group-logo.gif

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.

Idx Field Type Maximum Length Required
1 Asset_Class_Code Alphanumeric 20 Yes
2 Asset_Class_Name Alphanumeric 50 Yes

 

Sample Asset Class Codes and Descriptions

B

Buildings

C

Computers

E

Equipment

F

Furniture

L

Leasehold Improvements

Summary

Asset_Class

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

Columns

 

Asset_Class_Code

The uniquely identifying Asset Class code. Required.

Asset_Class_Name

The description for the Asset Class code. Required.

Documentation

 

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 Format
Type Alphanumeric
Maximum Length 20
Required Yes

Asset_Class_Name

Asset_Class_Name varchar(

50

) NOT NULL

The description for the Asset Class code. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 50
Required Yes