Back

General Ledger (GL) - GLCOLDT

Name Type Length Decimal Relation Description
COLNUM String 8 REPORT COL DETAIL COLNUM - The column number on the financial statement
BUDGETNUM String 1 GL BUDGETNUM
START_PER String 2 GL REPORT COL DETAIL START_PER - The starting period for data in this column. Use all 9's to specify at runtime
END_PER String 2 GL REPORT COL DETAIL END_PER - The ending period for data in this column. Use all 9's to specify at runtime
START_YEAR String 4 GL REPORT COL DETAIL START_YEAR - The starting year for data in this column. Use all 9's to specify at runtime
END_YEAR String 4 GL REPORT COL DETAIL END_YEAR - The ending year for data in this column. Use all 9's to specify at runtime
USER_CALC String 20 GL REPORT COL DETAIL USER_CALC - The user defined calculations for calculated columns (type 'C'). (ie: C1+C2)
GLACCTFMT String 12 GL REPORT COL DETAIL GLACCTFMT - The department grouping specifier (ie xxxx-01 will only include department 01 in the column)
COMPCODE String 3 GL REPORT COL DETAIL COMPCODE - The code of company to use for data in the column.
COL_EXTR String 8 GL REPORT COL DETAIL COL_EXTR - The column group number to pull data from a saved report for type 'E' columns.
KEYNO String 8 GL REPORT COL DETAIL KEYNO - ** Not used **
KEYID String 12 GL REPORT COL DETAIL KEYID - Unique identifier
TP String 1 GL REPORT COL DETAIL TP - Type
DESCRIPT String 50 GL REPORT COL DETAIL DESCRIPT - Column Description
COLNO Decimal 2 0 GL REPORT COL DETAIL COLNO - Sequential column number
SDATE DateTime 8 GL SDATE
EDATE DateTime 8 GL EDATE