GL_Class

Used as the core source for loading the GL Class dimension.  Used to assign proper signage (positive / negative) to accounts based on account type.

Idx	Field	Type	Maximum Length	Required
1	GL_Class_Code	Alphanumeric	20	Yes
2	GL_Class_Name	Alphanumeric	100	Yes
3	GL_Multiplier	Integer		Yes

Typical GL Class codes and descriptions

A	Asset
C	Capital
E	Expense
L	Liability
R	Revenue

Summary

GL_Class	Used as the core source for loading the GL Class dimension.
Columns
GL_Class_Code	The uniquely identifying GL Class code. Required.
GL_Class_Name	The description for the GL Class code. Required.
GL_Multiplier	1 if this is a debit account, -1 if this is a credit account. Required.
Documentation
Sample CSV Load File	This load file is commonly used to load GL Classes.

Sample CSV Load File

This load file is commonly used to load GL Classes.

Filename: GL_Class.csv

A,Asset,1
C,Capital,-1
E,Expense,1
L,Liability,-1
R,Revenue,-1

Columns

GL_Class_Code

GL_Class_Code varchar(

20

) NOT NULL

The uniquely identifying GL Class code. Required.

Field Load File Format
Type	Alphanumeric
Maximum Length	20
Required	Yes

GL_Class_Name

GL_Class_Name varchar(

100

) NOT NULL

The description for the GL Class code. Required.

Field Load File Format
Type	Alphanumeric
Maximum Length	100
Required	Yes

GL_Multiplier

GL_Multiplier int NOT NULL

1 if this is a debit account, -1 if this is a credit account. Required.

This value is multiplied to the GL journal entries calculated net amount (i.e. debit minus credit).  Net amounts assume correct signage and do not use this multiplier.

 
 

Field Load File Format
Type	Integer
Required	Yes