GLCONSOL FILE General Ledger Consolidation This file contains consolidated account balances for the GLMASTER, CUAMOUNT, GLUNITS, and FBDETAIL files. Consolidated balances are kept for summary level accounting units. The purpose of this file is for reporting summary balances. This file also stores consolidated summary level account balances for the report currencies. REFERENCED BY FB195 GL141 GL195 GLSV.1 GLRV.1 GL288 FB141 UPDATED BY CA195 FB100 FB101 FB120 FB121 FB122 FB165 FB20.1 FB20.2 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL110 GL120 GL146 GL167 GL190 GL199 GL300 GL320 GL45.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY GCN-FISCAL-YEAR Numeric 4 CA195 FB100 Fiscal Year This is the current fiscal year. This FB101 FB120 field is updated by GL199 (Period FB121 FB122 Closing). FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL120 GL146 GL167 GL190 GL199 GL320 GL45.1 GLSV.1 GCN-LEVEL-DEPTH Numeric 1 CA195 FB100 Level Depth The summary level depth. FB101 FB120 "0" = Company level. FB121 FB122 "1" = Level 1. FB165 FB20.1 "2" = Level 2. FB20.3 FB20.4 "3" = Level 3. FB20.6 FB20.7 "4" = Level 4. FB21.1 FB30.1 0 = Company FB31.1 GL120 1 = Level 1 GL146 GL167 2 = Level 2 GL190 GL199 3 = Level 3 GL320 GL45.1 4 = Level 4 GLSV.1 GCN-BUDGET-NBR Numeric 3 CA195 FB100 Budget The budget number related to this FB101 FB120 record. FB121 FB122 FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL120 GL146 GL167 GL190 GL199 GL320 GL45.1 GLSV.1 GCN-TRANS-TYPE Alpha 1 CA195 FB100 Trans Type This determines if amounts or units are FB101 FB120 processed in each transaction. FB121 FB122 FB165 FB20.1 A = Amounts FB20.3 FB20.4 U = Units FB20.6 FB20.7 B = Budget Amount FB21.1 FB30.1 C = Currency FB31.1 GL120 N = Budget Unit GL146 GL167 Y = Currency One GL190 GL199 Z = Currency Two GL320 GL45.1 GLSV.1 GCN-COMPANY Numeric 4 CA195 FB100 Company The company number represents an FB101 FB120 established company and is entered on FB121 FB122 all function codes. FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL110 GL120 GL146 GL167 GL190 GL199 GL320 GL45.1 GLSV.1 GCN-VAR-LEVELS Alpha 30 CA195 FB100 Variable Levels A level that represents the location of FB101 FB120 an accounting unit in an organization's FB121 FB122 level structure. FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL120 GL146 GL167 GL190 GL199 GL320 GL45.1 GCN-ACCOUNT Numeric 6 CA195 FB100 Account This field along with the accounting FB101 FB120 unit and subaccount make up the location FB121 FB122 (account) where amounts and other FB165 FB20.1 account information is stored. FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL120 GL146 GL167 GL190 GL199 GL320 GL45.1 GLSV.1 GCN-SUB-ACCOUNT Numeric 4 CA195 FB100 Subaccount This field along with the accounting FB101 FB120 unit and account make up the location FB121 FB122 (account) where amounts and other FB165 FB20.1 account information is stored. FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL120 GL146 GL167 GL190 GL199 GL320 GL45.1 GLSV.1 GCN-CURRENCY-CODE Alpha 5 CA195 FB165 Currency Code This field contains the company base GL120 GL146 currency code established in GL10.1 GL167 GL190 (Company). GL199 GL320 GL45.1 GLSV.1 GCN-DB-BEG-BAL Currency 15.2 FB120 FB121 Debit Beginning The debit beginning balance. FB122 FB165 Balance FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL110 GL120 GL167 GL199 GL320 GLSV.1 GCN-CR-BEG-BAL Currency 15.2 FB120 FB121 Credit Beginning The credit beginning balance. FB122 FB165 Balance FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL110 GL120 GL167 GL199 GL320 GLSV.1 GCN-DB-AMOUNT Currency 15.2 Occurs 13 Times CA195 FB100 Debit Amount The budget debit amount. FB101 FB120 FB121 FB122 FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL110 GL120 GL146 GL167 GL190 GL320 GL45.1 GLSV.1 GCN-CR-AMOUNT Currency 15.2 Occurs 13 Times CA195 FB100 Credit Amount The budget credit amount. FB101 FB120 FB121 FB122 FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL110 GL120 GL146 GL167 GL190 GL320 GL45.1 GLSV.1 GCN-ACCT-ND Numeric 1 CA195 FB100 Account Number of Number of decimal positions in the FB101 FB120 Decimals account amounts FB121 FB122 FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL120 GL146 GL167 GL190 GL199 GL320 GL45.1 GCN-CHART-NAME Alpha 12 CA195 FB100 Chart Name This is the name you assigned to the FB101 FB120 chart of accounts when you defined your FB121 FB122 company structure in the General Ledger FB165 FB20.1 system. FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL146 GL167 GL190 GL199 GL320 GL45.1 GLSV.1 GCN-CPAMT-DR Derived Current Period This is the current period debit amount. Amount Debit GCN-CPAMT-CR Derived Current Period This is the current period credit Amount Credit amount. GCN-CPAMT Derived Current Period This is the total current period amount. Amount GCN-CYBAMT Derived Cybamt This is the total current year beginning balance. GCN-CUR-PD-SUM-C-D Derived Cur Pd Sum C D This is the current period summary debit amount. GCN-CUR-PD-SUM-C-C Derived Cur Pd Sum C C This is the current period summary credit amount. GCN-CUR-PD-SUM-C Derived Cur Pd Sum C This is the total current period summary amount. GCN-CYDAMT Derived Cydamt This is the current year-to-date amount. GCN-CPAMT-THOU Derived Cpamt Thou This is the current period amount divided by 1,000. GCN-CYDAMT-THOU Derived Cydamt Thou This is the current year-to-date amount divided by 1,000. GCN-CPVAR-PCT Derived Cpvar Pct This is the current period variance percent. GCN-BLANK Derived Blank This derived field is always blank. It is used in the Drill Around feature for column headings. GLCONSOL FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN GCNSET1 FISCAL-YEAR CA195 FB100 LEVEL-DEPTH FB101 FB120 BUDGET-NBR FB121 FB122 TRANS-TYPE FB165 FB195 COMPANY FB20.1 FB20.2 VAR-LEVELS FB20.3 FB20.4 ACCOUNT FB20.6 FB20.7 SUB-ACCOUNT FB21.1 FB30.1 CURRENCY-CODE FB31.1 GL110 GL120 GL141 GL146 GL167 GL190 GL195 GL199 GL45.1 GLSV.1 GLRV.1 GCNSET2 FISCAL-YEAR FB195 GL199 LEVEL-DEPTH GL288 GL320 BUDGET-NBR GLSV.1 GLRV.1 TRANS-TYPE COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS CURRENCY-CODE GCNSET3 FISCAL-YEAR GLSV.1 GLRV.1 LEVEL-DEPTH BUDGET-NBR TRANS-TYPE ACCOUNT SUB-ACCOUNT VAR-LEVELS COMPANY CURRENCY-CODE GCNSET4 FISCAL-YEAR GLSV.1 GLRV.1 LEVEL-DEPTH BUDGET-NBR TRANS-TYPE VAR-LEVELS ACCOUNT SUB-ACCOUNT COMPANY CURRENCY-CODE GCNSET5 COMPANY FB141 GL110 TRANS-TYPE GL300 BUDGET-NBR FISCAL-YEAR VAR-LEVELS ACCOUNT SUB-ACCOUNT CURRENCY-CODE LEVEL-DEPTH GLCONSOL FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Chart Detail GLCHARTDTL Required GCN-CHART-NAME -> GDT-CHART-NAME GCN-ACCOUNT -> GDT-ACCOUNT GCN-SUB-ACCOUNT -> GDT-SUB-ACCOUNT Glconsol Bud 1 GLCONSOL Not Required GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR GCN-LEVEL-DEPTH -> GCN-LEVEL-DEPTH "0" -> GCN-BUDGET-NBR "B" -> GCN-TRANS-TYPE GCN-COMPANY -> GCN-COMPANY GCN-ACCOUNT -> GCN-ACCOUNT GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT GCN-VAR-LEVELS -> GCN-VAR-LEVELS GCN-CURRENCY-CODE -> GCN-CURRENCY-CODE Glsystem GLSYSTEM Required GCN-COMPANY -> GLS-COMPANY GLCONSOL FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Cuamount3 CUAMOUNT GLS-FISCAL-YEAR -> CAM-FISCAL-YEAR GCN-COMPANY -> CAM-COMPANY 3 -> CAM-AMT-TYPE GCN-CURRENCY-CODE -> CAM-CURRENCY-CODE GCN-ACCOUNT -> CAM-ACCOUNT GCN-SUB-ACCOUNT -> CAM-SUB-ACCOUNT CAM-VAR-LEVELS CAM-ACCT-UNIT Cuamount4 CUAMOUNT GLS-FISCAL-YEAR -> CAM-FISCAL-YEAR GCN-COMPANY -> CAM-COMPANY 4 -> CAM-AMT-TYPE GCN-CURRENCY-CODE -> CAM-CURRENCY-CODE GCN-ACCOUNT -> CAM-ACCOUNT GCN-SUB-ACCOUNT -> CAM-SUB-ACCOUNT CAM-VAR-LEVELS CAM-ACCT-UNIT Glamounts Acct GLAMOUNTS GCN-COMPANY -> GAM-COMPANY GLS-FISCAL-YEAR -> GAM-FISCAL-YEAR GCN-ACCOUNT -> GAM-ACCOUNT GCN-SUB-ACCOUNT -> GAM-SUB-ACCOUNT GAM-ACCT-UNIT Glconsol 0 GLCONSOL GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR Spaces -> GCN-LEVEL-DEPTH GCN-BUDGET-NBR -> GCN-BUDGET-NBR GCN-TRANS-TYPE -> GCN-TRANS-TYPE GCN-COMPANY -> GCN-COMPANY GCN-ACCOUNT -> GCN-ACCOUNT GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT GCN-VAR-LEVELS GCN-CURRENCY-CODE Glconsol 1 GLCONSOL GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR "1" -> GCN-LEVEL-DEPTH GCN-BUDGET-NBR -> GCN-BUDGET-NBR GCN-TRANS-TYPE -> GCN-TRANS-TYPE GCN-COMPANY -> GCN-COMPANY GCN-ACCOUNT -> GCN-ACCOUNT GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT GCN-VAR-LEVELS GCN-CURRENCY-CODE Glconsol 2 GLCONSOL GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR "2" -> GCN-LEVEL-DEPTH GCN-BUDGET-NBR -> GCN-BUDGET-NBR GCN-TRANS-TYPE -> GCN-TRANS-TYPE GCN-COMPANY -> GCN-COMPANY GCN-ACCOUNT -> GCN-ACCOUNT GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT GCN-VAR-LEVELS GCN-CURRENCY-CODE Glconsol 3 GLCONSOL GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR "3" -> GCN-LEVEL-DEPTH GCN-BUDGET-NBR -> GCN-BUDGET-NBR GCN-TRANS-TYPE -> GCN-TRANS-TYPE GCN-COMPANY -> GCN-COMPANY GCN-ACCOUNT -> GCN-ACCOUNT GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT GCN-VAR-LEVELS GCN-CURRENCY-CODE Glconsol 4 GLCONSOL GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR "4" -> GCN-LEVEL-DEPTH GCN-BUDGET-NBR -> GCN-BUDGET-NBR GCN-TRANS-TYPE -> GCN-TRANS-TYPE GCN-COMPANY -> GCN-COMPANY GCN-ACCOUNT -> GCN-ACCOUNT GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT GCN-VAR-LEVELS GCN-CURRENCY-CODE Glmaster GLMASTER Required GCN-COMPANY -> GLM-COMPANY GCN-ACCOUNT -> GLM-ACCOUNT GCN-SUB-ACCOUNT -> GLM-SUB-ACCOUNT GLM-ACCT-UNIT Glnames GLNAMES Required GCN-COMPANY -> GLN-COMPANY GCN-VAR-LEVELS -> GLN-VAR-LEVELS GLN-ACCT-UNIT |