You are here: Reference Guide > Table Structures > General Ledger > GL_Config

GL_Config

Purpose    

Controls the configuration settings for the General Ledger - year starting, creating a new year and period names for report headings. The account for Retained Earnings for each year is also stored in this table together with the status for each period – Open, External or Global Locked

Path        

System GL Control Maintenance Setup

Name

Type

Linked To/Supplied

GLSetupID

Text (20)

 

LastSavedDateTime

Date/Time

 

YearNo

Number (Integer)

 

YearStartingDate

Date/Time

 

RetainedEarningsNo

Text (20)

 

NoOfPeriods

Number (Integer)

 

Seperator

Text (1)

 

AccountNoSegments

Number (Integer)

 

SegmentName1 through to SegmentName6

Text (20)

 

SegmentType1 through to SegmentName6

Number (Integer)

 

SegmentLength1 through to SegmentName6

Number (Integer)

 

PeriodName1 through to PeriodName12

Text (20)

 

PeriodStart1 through to Period Start12

Date/Time

 

PeriodLocked1 through to PeriodLocked12

Number (Integer)

0 = No (Open);1 = External Lock;2 = Global Lock

PeriodRolled1 through to PeriodRolled12

Yes/No

0 = No; 1 = Yes

YearRolled

Yes/No

0 = No; 1 = Yes

Copyright © 2012 Jiwa Financials. All rights reserved.