GL_Type


Used as the core source for loading the GL Type dimension; commonly referred to as ‘Books’ in the accounting system.  Essentially, this differentiates the setup books and the way data is recorded.

Universal may relate to postings for both cash and accrual.   On a cash basis, which is how most firms do their primary reporting, revenues and some expenses are recorded, while an alternate recording is done under the accrual basis. Thus, cash and accrual are somewhat parallel.

IdxFieldTypeMaximum LengthRequired1GL_Type_Code2GL_Type_Name3GL_Type_Rollup_14GL_Type_Rollup_2
Alphanumeric 20 Yes
Alphanumeric 50 Yes
Alphanumeric 50 No
Alphanumeric 50 No

 

Typical GL Type codes and descriptions

A

Accrual

C

Cash

B

Budget

U

Universal

Summary

GL_Type

Columns

Rollup Columns

Documentation

Used as the core source for loading the GL Type dimension; commonly referred to as ‘Books’ in the accounting system.

 

GL_Type_Code

The uniquely identifying GL Type code. Required.

GL_Type_Name

Description of the GL Type code. Required.

 

GL_Type_Rollup_1

Top level hierarchy the GL Type rolls into for reporting purposes. Optional.

GL_Type_Rollup_2

Second level hierarchy the GL Type rolls into for reporting purposes. Optional.

 

Sample CSV Load File

This load file is a small sample of a GL Type load.

Sample CSV Load File

This load file is a small sample of a GL Type load.

Filename: GL_Type.csv

A,Accrual,, C,Cash,, B,Budget,, U,Universal,,

Columns

GL_Type_Code

GL_Type_Code varchar(

20

) NOT NULL

The uniquely identifying GL Type code. Required.

 

 

Field Load File FormatTypeMaximum LengthRequired

Alphanumeric
20
Yes

GL_Type_Name

GL_Type_Name varchar(

50

) NOT NULL

Description of the GL Type code. Required.

 

 

Field Load File FormatTypeMaximum LengthRequired

Alphanumeric
50
Yes

Rollup Columns

GL_Type_Rollup_1

GL_Type_Rollup_1 varchar(

50

) NULL

Top level hierarchy the GL Type rolls into for reporting purposes. Optional.

Records may be grouped into multiple rollups each separated by a separate rollup column.  Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level one.

GL_Type_Rollup_2

GL_Type_Rollup_2 varchar(

50

) NULL

Second level hierarchy the GL Type rolls into for reporting purposes. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level two.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk