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

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk