Back

General Ledger (GL) - GLSYSTEM

Name Type Length Decimal Relation Description
ACCT_FMT String 15 GL SYSTEM HEADER ACCT_FMT - The general ledger account format
FIS_CAL String 1 GL SYSTEM HEADER FIS_CAL - Y=On a calendar year
RET_EARN String 12 GL SYSTEM HEADER RET_EARN - The retained earnings account to close revenue and expense accounts at year end.
BLANK String 2 GL BLANK
CUR_PERIOD String 2 GL SYSTEM HEADER CUR_PERIOD - The current general ledger period.
JBATCH String 6 GL JBATCH
HISYRS String 2 GL SYSTEM HEADER HISYRS - The number of years to maintain history (1-99)
EXCELPATH String 100 GL SYSTEM HEADER EXCELPATH - The path to excel.exe
YEAR_END DateTime 8 GL YEAR_END
GLDATE DateTime 8 GL SYSTEM HEADER GLDATE - ** not used **
CUR_YR_END DateTime 8 GL SYSTEM HEADER CUR_YR_END - **- not used **
NO_PERIODS Decimal 2 0 GL SYSTEM HEADER NO_PERIODS - The number of accounting periods (12 or 13)
SEG_1_SIZE Decimal 2 0 GL SYSTEM HEADER SEG_1_SIZE - The number of characters in the first segment of the general ledger account number.
SEG_2_SIZE Decimal 2 0 GL SYSTEM HEADER SEG_2_SIZE - The number of characters in the second segment of the general ledger account number.
SEG_3_SIZE Decimal 2 0 GL SYSTEM HEADER SEG_3_SIZE - The number of characters in the third segment of the general ledger account number.
SEG_4_SIZE Decimal 2 0 GL SYSTEM HEADER SEG_4_SIZE - The number of characters in the fourth segment of the general ledger account number.
ACCT_SEG Decimal 1 0 GL SYSTEM HEADER ACCT_SEG - The segment of the general ledger which represents the actual account number (ie not a sub account or department)
ALLOW_CHNG Boolean 1 GL SYSTEM HEADER ALLOW_CHNG - *** Not used ***
EXCEL Boolean 1 GL SYSTEM HEADER EXCEL - Set to true to enable financial statments to create Excel worksheets.
SEG1_DESC String 25 GL SEG1_DESC
SEG2_DESC String 25 GL SEG2_DESC
SEG3_DESC String 25 GL SEG3_DESC
SEG4_DESC String 25 GL SEG4_DESC
CUR_EARN String 12 GL CUR_EARN
SEG_5_SIZE Decimal 2 0 GL SEG_5_SIZE
SEG_6_SIZE Decimal 2 0 GL SEG_6_SIZE
SEG_7_SIZE Decimal 2 0 GL SEG_7_SIZE
SEG5_DESC String 25 GL SEG5_DESC
SEG6_DESC String 25 GL SEG6_DESC
SEG7_DESC String 25 GL SEG7_DESC
CRNCYSEG Int32 4 GL CRNCYSEG