GLCONSOL

General Ledger Consolidation

This file contains consolidated account balances for the GLAMOUNTS, 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
GLSV.1 GL288


UPDATED BY
CA195 FB100 FB101 FB120 FB121 FB122
FB145 FB165 FB190 FB20.1 FB20.2 FB20.3
FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1
FB40.1 FB40.2 FB40.3 FB45.1 GL110 GL146
GL148 GL167 GL190 GL197 GL199 GL300
GL320 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL44.1 GL45.1 GL500 FB195 GL141 GL195
GLRV.1 FB141

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCN-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Contains the fiscal year for the data stored on this record.
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GCN-LEVEL-DEPTH
Element: Level Depth
Numeric 1
The summary level depth. "0" = Company level. "1" = Level 1. "2" = Level 2. "3" = Level 3. "4" = Level 4.
0 = Company
1 = Level 1
2 = Level 2
3 = Level 3
4 = Level 4
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GCN-BUDGET-NBR
Element: Budget Number
Numeric 3
The budget number related to this record.
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GCN-TRANS-TYPE
Element: Trans Type
Alpha 1
This field designates the type of consolidated balance record. The values are: A = Amount U = Unit B = Budget Amount C = Currency N = Budget Unit Y = Currency One Z = Currency Two
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GCN-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL110
GL146 GL148
GL167 GL190
GL197 GL199
GL320 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GCN-VAR-LEVELS
Element: Variable Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GCN-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GCN-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GCN-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
CA195 FB165
GL146 GL148
GL167 GL190
GL197 GL199
GL320 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GLSV.1
GCN-DB-BEG-BAL
Debit Beginning
Balance
Signed 18.2
FB120 FB121
FB122 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL167
GL197 GL199
GL320 GL500
GLSV.1
GCN-CR-BEG-BAL
Credit Beginning
Balance
Signed 18.2
FB120 FB121
FB122 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL167
GL197 GL199
GL320 GL500
GLSV.1
GCN-DB-AMOUNT
Element: Debit Amount
Signed 18.2 Occurs 13 Times
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL110
GL146 GL148
GL167 GL190
GL197 GL199
GL320 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GCN-CR-AMOUNT
Element: Credit Amount
Signed 18.2 Occurs 13 Times
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL110
GL146 GL148
GL167 GL190
GL197 GL199
GL320 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GCN-ACCT-ND
Account Number of
Decimals
Numeric 1
Number of decimal positions in the account amounts
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GCN-CHART-NAME
Element: Chart Name
Alpha 12
This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GCN-CPAMT-DR
Current Period
Amount Debit
Derived
This is the current period debit amount.
GCN-CPAMT-CR
Current Period
Amount Credit
Derived
This is the current period credit amount.
GCN-CPAMT
Current Period
Amount
Derived
This is the total current period amount.
GCN-CYBAMT
Current Year
Beginning Amount
Derived
This is the total current year beginning balance.
GCN-CUR-PD-SUM-C-D
Element: Current Period
Derived
This is the current period summary debit amount.
GCN-CUR-PD-SUM-C-C
Element: Current Period
Derived
This is the current period summary credit amount.
GCN-CUR-PD-SUM-C
Element: Cur Pd Sum C
Derived
This is the total current period summary amount.
GCN-CYDAMT
Current Year to
Date Amount
Derived
This is the current year-to-date amount.
GCN-CPAMT-THOU
Current Period
Amount Thousand
Derived
This is the current period amount divided by 1,000.
GCN-CYDAMT-THOU
Curr Year to Date
Amt Thousand
Derived
This is the current year-to-date amount divided by 1,000.
GCN-CPVAR-PCT
Element: Cpvar Pct
Derived
This is the current period variance percent.
GCN-BLANK
Element: Blank
Derived
This derived field is always blank. It is used in the Drill Around feature for column headings.
GCN-CYPAMT1-DR
Current Period 1
Amount Debit
Derived
Current year period debit amount period 1.
GCN-CYPAMT1-CR
Current Period 1
Amount Credit
Derived
Current year period credit amount period 1.
GCN-CYPAMT1
Current Period 1
Amount
Derived
Current year period amount period 1.
GCN-CYPYTD1
Curr Per 1 Year to
Date Amount
Derived
Current year period year to date period 1.
GCN-CYPAMT2-DR
Current Period 2
Amount Debit
Derived
Current year period debit amount period 2.
GCN-CYPAMT2-CR
Current Period 2
Amount Credit
Derived
Current year period credit amount period 2.
GCN-CYPAMT2
Current Period 2
Amount
Derived
Current year period amount period 2.
GCN-CYPYTD2
Curr Per 2 Year To
Date Amount
Derived
Current year period year to date period 2.
GCN-CYPAMT3-DR
Element: Cypamt3 Dr
Derived
Current year period debit amount period 3.
GCN-CYPAMT3-CR
Element: Cypamt3 Cr
Derived
Current year period credit amount period 3.
GCN-CYPAMT3
Element: Cypamt3
Derived
Current year period amount period 3.
GCN-CYPYTD3
Element: Cypamt3
Derived
Current year period year to date period 3.
GCN-CYPAMT4-DR
Element: Cypamt4 Dr
Derived
Current year period debit amount period 4.
GCN-CYPAMT4-CR
Element: Cypamt4 Cr
Derived
Current year period credit amount period 4.
GCN-CYPAMT4
Element: Cypamt4
Derived
Current year period amount period 4.
GCN-CYPYTD4
Element: Cypamt4
Derived
Current year period year to date period 4.
GCN-CYPAMT5-DR
Element: Cypamt5 Dr
Derived
Current year period debit amount period 5.
GCN-CYPAMT5-CR
Element: Cypamt5 Cr
Derived
Current year period credit amount period 5.
GCN-CYPAMT5
Element: Cypamt5
Derived
Current year period amount period 5.
GCN-CYPYTD5
Element: Cypamt5
Derived
Current year period year to date period 5.
GCN-CYPAMT6-DR
Element: Cypamt6 Dr
Derived
Current year period debit amount period 6.
GCN-CYPAMT6-CR
Element: Cypamt6 Cr
Derived
Current year period credit amount period 6.
GCN-CYPAMT6
Element: Cypamt6
Derived
Current year period amount period 6.
GCN-CYPYTD6
Element: Cypamt6
Derived
Current year period year to date period 6.
GCN-CYPAMT7-DR
Element: Cypamt7 Dr
Derived
Current year period debit amount period 7.
GCN-CYPAMT7-CR
Element: Cypamt7 Cr
Derived
Current year period credit amount period 7.
GCN-CYPAMT7
Element: Cypamt7
Derived
Current year period amount period 7.
GCN-CYPYTD7
Element: Cypamt7
Derived
Current year period year to date period 7.
GCN-CYPAMT8-DR
Element: Cypamt8 Dr
Derived
Current year period debit amount period 8.
GCN-CYPAMT8-CR
Element: Cypamt8 Cr
Derived
Current year period credit amount period 8.
GCN-CYPAMT8
Element: Cypamt8
Derived
Current year period amount period 8.
GCN-CYPYTD8
Element: Cypamt8
Derived
Current year period year to date period 8.
GCN-CYPAMT9-DR
Element: Cypamt9 Dr
Derived
Current year period debit amount period 9.
GCN-CYPAMT9-CR
Element: Cypamt9 Cr
Derived
Current year period credit amount period 9.
GCN-CYPAMT9
Element: Cypamt9
Derived
Current year period amount period 9.
GCN-CYPYTD9
Element: Cypamt9
Derived
Current year period year to date period 9.
GCN-CYPAMT10-DR
Element: Cypamt10 Dr
Derived
Current year period debit amount period 10.
GCN-CYPAMT10-CR
Element: Cypamt10 Cr
Derived
Current year period credit amount period 10.
GCN-CYPAMT10
Element: Cypamt10
Derived
Current year period amount period 10.
GCN-CYPYTD10
Element: Cypamt10
Derived
Current year period year to date period 10.
GCN-CYPAMT11-DR
Element: Cypamt11 Dr
Derived
Current year period debit amount period 11.
GCN-CYPAMT11-CR
Element: Cypamt11 Cr
Derived
Current year period credit amount period 11.
GCN-CYPAMT11
Element: Cypamt11
Derived
Current year period amount period 11.
GCN-CYPYTD11
Element: Cypamt11
Derived
Current year period year to date period 11.
GCN-CYPAMT12-DR
Element: Cypamt12 Dr
Derived
Current year period debit amount period 12.
GCN-CYPAMT12-CR
Element: Cypamt12 Cr
Derived
Current year period credit amount period 12.
GCN-CYPAMT12
Element: Cypamt12
Derived
Current year period amount period 12.
GCN-CYPYTD12
Element: Cypamt12
Derived
Current year period year to date period 12.
GCN-CYPAMT13-DR
Element: Cypamt13 Dr
Derived
Current year period debit amount period 13.
GCN-CYPAMT13-CR
Element: Cypamt13 Cr
Derived
Current year period credit amount period 13.
GCN-CYPAMT13
Element: Cypamt13
Derived
Current year period amount period 13.
GCN-CYPYTD13
Element: Cypamt13
Derived
Current year period year to date period 13.
GCN-PARENT-VAR-LEV
Element: Parent Var Lev
Alpha 30
The variable level address of the parent accounting unit.
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500


GLCONSOL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCNSET1 FISCAL-YEAR
LEVEL-DEPTH
BUDGET-NBR
TRANS-TYPE
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
CURRENCY-CODE
...
CA195 FB100
FB101 FB120
FB121 FB122
FB145 FB165
FB190 FB195
FB20.1 FB20.2
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL110
GL141 GL146
GL148 GL167
GL190 GL195
GCNSET2 FISCAL-YEAR
LEVEL-DEPTH
BUDGET-NBR
TRANS-TYPE
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
CURRENCY-CODE
GL141 GL195
GL199 GL288
GL320 GLSV.1
GLRV.1
GCNSET3 FISCAL-YEAR
LEVEL-DEPTH
BUDGET-NBR
TRANS-TYPE
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
CURRENCY-CODE
GLSV.1 GLRV.1
GCNSET4 FISCAL-YEAR
LEVEL-DEPTH
BUDGET-NBR
TRANS-TYPE
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
CURRENCY-CODE
GLSV.1 GLRV.1
GCNSET5 COMPANY
TRANS-TYPE
BUDGET-NBR
FISCAL-YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
CURRENCY-CODE
LEVEL-DEPTH
FB141 GL110
GL300
GCNSET8 PARENT-VAR-LEV
TRANS-TYPE
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
BUDGET-NBR
LEVEL-DEPTH
VAR-LEVELS
CURRENCY-CODE
Subset
WhereLEVEL-DEPTH >Zeroes
GCNSET9 VAR-LEVELS
TRANS-TYPE
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
BUDGET-NBR
LEVEL-DEPTH
CURRENCY-CODE


GLCONSOL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Adconsol B ADCONSOL Required
GCN-FISCAL-YEAR->ADO-FISCAL-YEAR (ADOSET1)
GCN-LEVEL-DEPTH->ADO-LEVEL-DEPTH
"B"->ADO-RECORD-TYPE
GCN-COMPANY->ADO-COMPANY
GCN-VAR-LEVELS->ADO-VAR-LEVELS
GCN-ACCOUNT->ADO-ACCOUNT
GCN-SUB-ACCOUNT->ADO-SUB-ACCOUNT
Adconsol C ADCONSOL Required
GCN-FISCAL-YEAR->ADO-FISCAL-YEAR
GCN-LEVEL-DEPTH->ADO-LEVEL-DEPTH
"C"->ADO-RECORD-TYPE
GCN-COMPANY->ADO-COMPANY
GCN-VAR-LEVELS->ADO-VAR-LEVELS
GCN-ACCOUNT->ADO-ACCOUNT
GCN-SUB-ACCOUNT->ADO-SUB-ACCOUNT
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
1->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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Base GLCONSOL
GCN-VAR-LEVELS->GCN-VAR-LEVELS
"A"->GCN-TRANS-TYPE
GCN-COMPANY->GCN-COMPANY
GCN-ACCOUNT->GCN-ACCOUNT
GCN-SUB-ACCOUNT->GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR->GCN-FISCAL-YEAR
  GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE
Cam Children 1 CUAMOUNT
GCN-VAR-LEVELS->CAM-PARENT-VAR-LEV
3->CAM-AMT-TYPE
GCN-COMPANY->CAM-COMPANY
GCN-ACCOUNT->CAM-ACCOUNT
GCN-SUB-ACCOUNT->CAM-SUB-ACCOUNT
GCN-FISCAL-YEAR->CAM-FISCAL-YEAR
  CAM-ACCT-UNIT
  CAM-VAR-LEVELS
  CAM-CURRENCY-CODE
Cam Children 2 CUAMOUNT
GCN-VAR-LEVELS->CAM-PARENT-VAR-LEV
4->CAM-AMT-TYPE
GCN-COMPANY->CAM-COMPANY
GCN-ACCOUNT->CAM-ACCOUNT
GCN-SUB-ACCOUNT->CAM-SUB-ACCOUNT
GCN-FISCAL-YEAR->CAM-FISCAL-YEAR
  CAM-ACCT-UNIT
  CAM-VAR-LEVELS
  CAM-CURRENCY-CODE
Children GLCONSOL
GCN-VAR-LEVELS->GCN-PARENT-VAR-LEV
GCN-TRANS-TYPE->GCN-TRANS-TYPE
GCN-COMPANY->GCN-COMPANY
GCN-ACCOUNT->GCN-ACCOUNT
GCN-SUB-ACCOUNT->GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR->GCN-FISCAL-YEAR
  GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-VAR-LEVELS
  GCN-CURRENCY-CODE
Children Bud GLCONSOL
GCN-VAR-LEVELS->GCN-PARENT-VAR-LEV
GCN-TRANS-TYPE->GCN-TRANS-TYPE
GCN-COMPANY->GCN-COMPANY
GCN-ACCOUNT->GCN-ACCOUNT
GCN-SUB-ACCOUNT->GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR->GCN-FISCAL-YEAR
GCN-BUDGET-NBR->GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-VAR-LEVELS
  GCN-CURRENCY-CODE
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
Curr 1 GLCONSOL
GCN-VAR-LEVELS->GCN-VAR-LEVELS
"Y"->GCN-TRANS-TYPE
GCN-COMPANY->GCN-COMPANY
GCN-ACCOUNT->GCN-ACCOUNT
GCN-SUB-ACCOUNT->GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR->GCN-FISCAL-YEAR
  GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE
Curr 2 GLCONSOL
GCN-VAR-LEVELS->GCN-VAR-LEVELS
"Z"->GCN-TRANS-TYPE
GCN-COMPANY->GCN-COMPANY
GCN-ACCOUNT->GCN-ACCOUNT
GCN-SUB-ACCOUNT->GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR->GCN-FISCAL-YEAR
  GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE
Fbd Children FBDETAIL
GCN-VAR-LEVELS->FBD-PARENT-VAR-LEV
GCN-FISCAL-YEAR->FBD-FISCAL-YEAR
GCN-BUDGET-NBR->FBD-BUDGET-NBR
GCN-COMPANY->FBD-COMPANY
GCN-ACCOUNT->FBD-ACCOUNT
GCN-SUB-ACCOUNT->FBD-SUB-ACCOUNT
  FBD-ACCT-UNIT
Gam Children GLAMOUNTS
GCN-VAR-LEVELS->GAM-PARENT-VAR-LEV
GCN-COMPANY->GAM-COMPANY
GCN-ACCOUNT->GAM-ACCOUNT
GCN-SUB-ACCOUNT->GAM-SUB-ACCOUNT
GCN-FISCAL-YEAR->GAM-FISCAL-YEAR
  GAM-ACCT-UNIT
Gcn Bud Parent GLCONSOL
GCN-PARENT-VAR-LEV->GCN-VAR-LEVELS
GCN-TRANS-TYPE->GCN-TRANS-TYPE
GCN-COMPANY->GCN-COMPANY
GCN-ACCOUNT->GCN-ACCOUNT
GCN-SUB-ACCOUNT->GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR->GCN-FISCAL-YEAR
GCN-BUDGET-NBR->GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE
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
Zeroes->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
Glu Children GLUNITS
GCN-VAR-LEVELS->GLU-PARENT-VAR-LEV
GCN-COMPANY->GLU-COMPANY
GCN-ACCOUNT->GLU-ACCOUNT
GCN-SUB-ACCOUNT->GLU-SUB-ACCOUNT
GCN-FISCAL-YEAR->GLU-FISCAL-YEAR
  GLU-ACCT-UNIT
Parent GLCONSOL
GCN-PARENT-VAR-LEV->GCN-VAR-LEVELS
GCN-TRANS-TYPE->GCN-TRANS-TYPE
GCN-COMPANY->GCN-COMPANY
GCN-ACCOUNT->GCN-ACCOUNT
GCN-SUB-ACCOUNT->GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR->GCN-FISCAL-YEAR
  GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE


File created: Wed Jun 08 20:48:39 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.