General Ledger Support Document
Open as: PDF or Word Document
Data Dictionary
Table of Contents
GLDESC : GENERAL LEDGER DESCRIPTIONS FILE
GLMAST : GENERAL LEDGER CHART OF ACCOUNTS
GLRECV : RECEIVE FROM OTHER MODULES STUFF
GLREPO : GENERAL LEDGER REPORTS (OLD)GLCUS41
GLSECT : G/L SECTION DESCRIPTION DATABASE
GLSYST : GENERAL LEDGER SYSTEM FILE
GLTRAX : General Ledger Transaction File
GLDESC : GENERAL LEDGER DESCRIPTIONS FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 D_TABLE C 1 0 "F"UND,"D"EPT,... 2 D_CODE C 10 0 LOOKUP CODE 3 D_DESC C 25 0 DESCRIPTION 4 D_TYPE C 1 0 "T"YPE FOR THE "F"UND 5 D_DELFLAG C 1 0 '*' IF THIS RECORD IS RE-USABLE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 5 FIELDS = 38 Related Indexes GLDESC : D_DELFLAG+D_TABLE+D_CODE GLHIST : HISTORY FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 H_YEAR C 10 0 FISCAL YEAR STORED IN THIS RECORD 2 H_GLMASTD M 0 0 GLMAST DBF FILE USE LY VALUES ONLY) 3 H_GLMASTF M 0 0 GLMAST FPT FILE(TO MATCH ONE ABOVE) 4 H_GLHTRXD M 0 0 GLHTRX DBF FILE 5 H_GLHTRXF M 0 0 GLHTRX FPT FILE 6 H_LYFIX L 1 0 LAST YEAR DATA RE-ALIGNED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 6 FIELDS = 11 GLMAST : GENERAL LEDGER CHART OF ACCOUNTS No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 GLMACT C 25 0 ACCOUNT NUMBER 2 GLMGROUP C 1 0 GROUP:1ASSET2LIAB3FB4RES5BUD6REV7EXP 3 GLMDES C 25 0 ACCOUNT DESCRIPTION 4 GLMCODE C 1 0 "A"CTIVE "I"NACTIVE 5 GLMNONLPS C 1 0 "Y" = UNUSED BUDGET ROLLS INTO GLMUBUD 6 GLMCBAL N 15 2 CURRENT PERIOD BALANCE 7 GLMYBAL N 15 2 YTD BALANCE 8 GLMLYBAL N 15 2 BALANCE AT CLOSE OF LAST YEAR 9 GLMYENC N 15 2 YTD ENCUMBRANCE 10 GLMLYENC N 15 2 LYTD ENCUMBRANCES 11 GLMBUD N 15 2 ADJUSTED BUDGET 12 GLMLBUD N 15 2 LAST YEAR BUDGET 13 GLMNBUD N 15 2 NEXT YEAR BUDGET 14 GLMFBUD N 15 2 FINAL BUDGET (THIS YEAR) 15 GLMLFBUD N 15 2 FINAL BUDGET (LAST YEAR) 16 GLMUBUD N 15 2 UNUSED BUDGET 17 GLMANTIC N 15 2 ANTICIPATED REVENUES/EXPENDITURES 18 GLMBAL01 N 15 2 PD 1 BALANCE (GLMYBAL) MONTH CLOSE 19 GLMBAL02 N 15 2 PD 2 20 GLMBAL03 N 15 2 PD 3 21 GLMBAL04 N 15 2 PD 4 22 GLMBAL05 N 15 2 PD 5 23 GLMBAL06 N 15 2 PD 6 24 GLMBAL07 N 15 2 PD 7 25 GLMBAL08 N 15 2 PD 8 26 GLMBAL09 N 15 2 PD 9 27 GLMBAL10 N 15 2 PD 10 28 GLMBAL11 N 15 2 PD 11 29 GLMBAL12 N 15 2 PD 12 30 GLMLBAL01 N 15 2 PD 1 LAST YEAR BALANCE AT MONTH CLOSE 31 GLMLBAL02 N 15 2 PD 2 32 GLMLBAL03 N 15 2 PD 3 33 GLMLBAL04 N 15 2 PD 4 34 GLMLBAL05 N 15 2 PD 5 35 GLMLBAL06 N 15 2 PD 6 36 GLMLBAL07 N 15 2 PD 7 37 GLMLBAL08 N 15 2 PD 8 38 GLMLBAL09 N 15 2 PD 9 39 GLMLBAL10 N 15 2 PD 10 40 GLMLBAL11 N 15 2 PD 11 41 GLMLBAL12 N 15 2 PD 12 42 GLMENC01 N 15 2 PD 1 ENCUMBRANCES (GLMYENC) AT CLOSE 43 GLMENC02 N 15 2 PD 2 44 GLMENC03 N 15 2 PD 3 45 GLMENC04 N 15 2 PD 4 46 GLMENC05 N 15 2 PD 5 47 GLMENC06 N 15 2 PD 6 48 GLMENC07 N 15 2 PD 7 49 GLMENC08 N 15 2 PD 8 50 GLMENC09 N 15 2 PD 9 51 GLMENC10 N 15 2 PD 10 52 GLMENC11 N 15 2 PD 11 53 GLMENC12 N 15 2 PD 12 54 GLMLENC01 N 15 2 LY PD 01 ENCUMBRANCES (GLMYENC) AT CLOSE 55 GLMLENC02 N 15 2 LY PD 02 ENCUMBRANCES (GLMYENC) AT CLOSE 56 GLMLENC03 N 15 2 LY PD 03 ENCUMBRANCES (GLMYENC) AT CLOSE 57 GLMLENC04 N 15 2 LY PD 04 ENCUMBRANCES (GLMYENC) AT CLOSE 58 GLMLENC05 N 15 2 LY PD 05 ENCUMBRANCES (GLMYENC) AT CLOSE 59 GLMLENC06 N 15 2 LY PD 06 ENCUMBRANCES (GLMYENC) AT CLOSE 60 GLMLENC07 N 15 2 LY PD 07 ENCUMBRANCES (GLMYENC) AT CLOSE 61 GLMLENC08 N 15 2 LY PD 08 ENCUMBRANCES (GLMYENC) AT CLOSE 62 GLMLENC09 N 15 2 LY PD 09 ENCUMBRANCES (GLMYENC) AT CLOSE 63 GLMLENC10 N 15 2 LY PD 10 ENCUMBRANCES (GLMYENC) AT CLOSE 64 GLMLENC11 N 15 2 LY PD 11 ENCUMBRANCES (GLMYENC) AT CLOSE 65 GLMLENC12 N 15 2 LY PD 12 ENCUMBRANCES (GLMYENC) AT CLOSE 66 GLMBUD01 N 15 2 PD 01 BUDGET 67 GLMBUD02 N 15 2 PD 02 BUDGET 68 GLMBUD03 N 15 2 PD 03 BUDGET 69 GLMBUD04 N 15 2 PD 04 BUDGET 70 GLMBUD05 N 15 2 PD 05 BUDGET 71 GLMBUD06 N 15 2 PD 06 BUDGET 72 GLMBUD07 N 15 2 PD 07 BUDGET 73 GLMBUD08 N 15 2 PD 08 BUDGET 74 GLMBUD09 N 15 2 PD 09 BUDGET 75 GLMBUD10 N 15 2 PD 10 BUDGET 76 GLMBUD11 N 15 2 PD 11 BUDGET 77 GLMBUD12 N 15 2 PD 12 BUDGET 78 GLMLBUD01 N 15 2 LAST YEAR PD 01 BUDGET 79 GLMLBUD02 N 15 2 LAST YEAR PD 02 BUDGET 80 GLMLBUD03 N 15 2 LAST YEAR PD 03 BUDGET 81 GLMLBUD04 N 15 2 LAST YEAR PD 04 BUDGET 82 GLMLBUD05 N 15 2 LAST YEAR PD 05 BUDGET 83 GLMLBUD06 N 15 2 LAST YEAR PD 06 BUDGET 84 GLMLBUD07 N 15 2 LAST YEAR PD 07 BUDGET 85 GLMLBUD08 N 15 2 LAST YEAR PD 08 BUDGET 86 GLMLBUD09 N 15 2 LAST YEAR PD 09 BUDGET 87 GLMLBUD10 N 15 2 LAST YEAR PD 10 BUDGET 88 GLMLBUD11 N 15 2 LAST YEAR PD 11 BUDGET 89 GLMLBUD12 N 15 2 LAST YEAR PD 12 BUDGET 90 GLMNOTE M 0 0 NOTE TO BE KEPT ON ACCOUNT 91 GLMBUDM M 0 0 NOTE TO BE KEPT FOR BUDGET CHANGES 92 GLMSTAMP N 2 0 93 GLMDELFLG C 1 0 '*' IF THIS RECORD IS RE-USABLE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 93 FIELDS = 1316 Related Indexes GLMAST : GLMDELFLG+GLMACT GLMGRP : Glmgroup+EVAL(acct_stru[11,5])+EVAL(acct_stru[12,5])+GLMACT GLMFND : EVAL(acct_stru[11,5])+Glmgroup+EVAL(acct_stru[12,5])+GLMACT GLMCMB : Glmgroup+STUFF(GLMACT,acct_stru[11,1],acct_stru[11,2],'')+ EVAL(acct_st GLRECO : RECONCILIATION FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 R_ACCT C 25 0 RECONCILIATION ACCOUNT 2 R_LASTEND N 15 2 LAST ENDING BALANCE RECONCILED 3 R_CHECKS M 0 0 TEMPORARY SAVED RECONCILIED CHECKS 4 R_DEPOSITS M 0 0 TEMPORARY SAVED RECONCILED DEPOSITS 5 R_WITHDRAW M 0 0 TEMPORARY SAVED RECONCILED WITHDRAWS 6 R_LASTBANK N 15 2 TEMPORARY LAST BANK ENDING BALANCE 7 R_STDATE D 8 0 LAST STATEMENR DATE USED 8 R_WITHADJ N 15 2 WITHDRAW ADJUSTMENT 9 R_DEPOADJ N 15 2 DEPOSIT ADJUSTMENT 10 R_DEPOQADJ N 4 0 QTY ADJUSTMENT 11 R_WITHQADJ N 4 0 QTY ADJUSTMENT 12 R_REASONS M 0 0 ADJUSTMENT REASONS 13 R_PERIOD N 2 0 PERIOD SELECTED FOR ENDING BALANCE 14 R_YEAR N 1 0 YEAR SELECTED FOR ENDING BALANCE 1 OR 2 ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 4 FIELDS = 104 GLRECV : RECEIVE FROM OTHER MODULES STUFF No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 R_MODULE C 2 0 MODULE TO RECEIVE FROM 2 R_DATE D 8 0 DATE OF ACCEPTANCE BY GL SYSTEM 3 R_FILE C 8 0 FILE NAME THAT THE TRANSFER IS IN 4 R_DESC C 40 0 DESCRIPTION OF TRANSFER MATERIAL 5 R_DELFLAG C 1 0 DELETED ("*") 6 R_NETSTAMP N 2 0 NETWORK STAMP ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 6 FIELDS = 61 Related Indexes GLRECV : R_delflag+R_module+DTOS(R_date) GLREPO : GENERAL LEDGER REPORTS (OLD)GLCUS41 No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 RPTMODULE C 2 0 MODULE THIS REPORT APPLIES TO (EG GL) 2 RPTSELECT C 8 0 REPORT SELECT CODE 3 RPTDESC C 40 0 REPORT DESCRIPTION 4 RPTCMD C 40 0 DOS COMMAND TO EXECUTE 5 RPTFILE C 4 0 USE BY NEMGENR TO TELL WHICH FILE TO USE 6 RPTMEMO M 0 0 DATA FOR REPORT. ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 6 FIELDS = 94 GLSECT : G/L SECTION DESCRIPTION DATABASE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 S_group C 1 0 GROUP 2 S_section C 1 0 SECTION 3 S_value C 10 0 VALUE OF SECTION 4 S_descrip C 25 0 USER DESCRIPTION 5 S_memo M 0 0 MEMO FOR SECTION 6 S_delflag C 1 0 DELFLAG 7 S_netstamp N 2 0 NETSTAMP ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 7 FIELDS = 40 Related Indexes GLSECT : S_delflag+S_group+S_section+S_value GLSYST : GENERAL LEDGER SYSTEM FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 S_PERIOD N 2 0 CURRENT PERIOD 2 S_YEAR N 4 0 CURRENT YEAR 3 S_FINALBUD C 1 0 "Y" IF FINAL BUDGET HAS BEEN POSTED 4 S_LFINALBU C 1 0 "Y" IF FINAL BUDGET WAS POSTED LAST YEAR 5 S_OVERSPND C 1 0 "Y" CHECK FOR OVERSPENDING BUDGET 6 S_ASKXFER C 1 0 "Y" ASK BEFORE ACCEPTING TRANSFERS 7 S_DBLCKPD C 1 0 "Y" TO CONFIRM PERIOD BEFORE RECEIVING 8 S_USEENC C 1 0 "Y" IF USING ENCUMBRANCES 9 S_USECTRL C 1 0 "Y" IF USING CONTROL ACCOUNTS 10 S_REVCTRL C 25 0 REVENUE CONTROL ACCOUNT 11 S_EXPCTRL C 25 0 EXPENDITIURE 12 S_ENCCTRL C 25 0 ENCUMBRANCE 13 S_ERVCTRL C 25 0 EXPECTED REVENUES 14 S_APPCTRL C 25 0 APPROPRIATIONS 15 S_F05 C 30 0 FUNCTION KEY F5 16 S_F06 C 30 0 FUNCTION KEY F6 17 S_F07 C 30 0 FUNCTION KEY F7 18 S_F08 C 30 0 FUNCTION KEY F8 19 S_F09 C 30 0 FUNCTION KEY F9 20 S_F10 C 30 0 FUNCTION KEY F10 21 S_F11 C 30 0 FUNCTION KEY F11 22 S_F12 C 30 0 FUNCTION KEY F12 23 S_FNDCHK C 1 0 CHECK FOR FUND OVERSPENDING 24 S_REPOSIGN C 1 0 'P'OSITIVE SIGNS FOR EXPECTED BALANCES 25 S_AUTOENT C 1 0 'Y' IF DOING AUTOMATIC DUE TO/FROM 26 S_DUETO C 25 0 DUE TO ACCOUNT 27 S_DUEFROM C 25 0 DUE FROM ACCOUNT 28 S_FUNDBAL C 25 0 FUND BALANCE ACCOUNT 29 S_FB_ALLOW C 1 0 'Y' IF VERIFY OF FB AND BFB ACCOUNTS 30 S_BFUNDBAL C 25 0 BUDGETED FUND BALANCE ACCOUNT 31 S_ENCUMBER C 25 0 ENCUMBRANCE ACCOUNT OFFSET ACCOUNT 32 S_PENCUMBE C 25 0 PY ENCUMBRANCE ACCOUNT OFFSET ACCOUNT 33 S_ONEENC C 1 0 ALLOW ONLY ONE ENCUMBRANCE ACCOUNT 34 S_ACCTSUMM C 1 0 IF N DONT PRINT ACCT SUMM. ON DETAIL TRX 35 S_GJENTRY N 8 0 LAST GENERAL JOURNAL ENTRY MADE 36 S_TYPES C 5 0 TYPES ALLOWED IN POSTING SCREEN 37 S_JANUARY N 2 0 JAN IS WHAT PERIOD # FOR MONTH IN LEFT 38 S_VERDATE D 8 0 DATE OF LAST UPDATE 39 S_PVERSION C 4 0 PREVIOUS NEMRC EXECUTABLE 40 S_VERSION C 4 0 NEMRC EXECUTABLE THAT MATCHES THIS DATA ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 40 FIELDS = 565 GLTRAX : General Ledger Transaction File No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 TRSACT C 25 0 ACCOUNT NUMBER 2 TRSDES C 25 0 TRANSACTION DESCRIPTION 3 TRSMEMO M 0 0 TRANSACTION MEMO (ONLY ON TRSID='1') 4 TRSREF C 12 0 REFERENCE NUMBER 5 TRSDATE D 8 0 TRANSACTION DATE 6 TRSAMT N 15 2 AMOUNT 7 TRSID C 1 0 0=SPECIAL,1=POSTING,2=REFERENCE 8 TRSMODU C 2 0 MODULE THAT GENERATED THIS POSTING 9 TRSCOMPID C 2 0 COMPANY ID THAT GENERATED THIS POSTING 10 TRSTYPE C 1 0 TRANSACTION TYPE(SEE BELOW) 11 TRSPD C 2 0 G/L PERIOD OF POSTING 12 TRSRECON C 1 0 "P" IF POSTED 13 TRSSTDATE D 8 0 STATEMENT DATE TRANSCTION WAS RECONCILED 14 TRSGROUP C 1 0 GROUP AT POSTING 15 TRSYEAR C 4 0 FY IN GLSYST AT TIME OF POSTING 16 TRSYRTYPE C 1 0 P = PREVIOUS YR DURING POSITNG BLANK OTH 17 TRSDELFLG C 1 0 ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 17 FIELDS = 109 Related Indexes GLTRAX : TRSACT+DTOS(TRSDATE) GLTRDT : DTOS(TRSDATE)+IIF(TRSTYPE$'BERG',TRSTYPE,'X') GLTRLK : IF(TRSID='1' AND TRSMODU='GL',DTOS(TRSDATE)+TRSDES,SPAC(LEN(DTOS(TRSD