Lawson Insight Technical Documentation |
|
GLCONSOL
GLCONSOL FILE
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
FB195 GL141 GL195 GLSV.1 GLRV.1 GL288
FB141
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCN-FISCAL-YEAR Numeric 4 CA195 FB100
Element: Fiscal Year This is the current fiscal year. This FB101 FB120
field is updated by Period Closing FB121 FB122
(GL199). 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 GLSV.1
GCN-LEVEL-DEPTH Numeric 1 CA195 FB100
Element: Level Depth The summary level depth. FB101 FB120
"0" = Company level. FB121 FB122
"1" = Level 1. FB145 FB165
"2" = Level 2. FB190 FB20.1
"3" = Level 3. FB20.3 FB20.4
"4" = Level 4. FB20.6 FB20.7
0 = Company FB21.1 FB30.1
1 = Level 1 FB31.1 FB40.1
2 = Level 2 FB40.2 FB40.3
3 = Level 3 FB45.1 GL146
4 = Level 4 GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GLSV.1
GCN-BUDGET-NBR Numeric 3 CA195 FB100
Element: Budget Number The budget number related to this FB101 FB120
record. 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 GLSV.1
GCN-TRANS-TYPE Alpha 1 CA195 FB100
Element: Trans Type This field designates the type of FB101 FB120
consolidated balance record. FB121 FB122
The values are: FB145 FB165
A = Amount FB190 FB20.1
U = Unit FB20.3 FB20.4
B = Budget Amount FB20.6 FB20.7
C = Currency FB21.1 FB30.1
N = Budget Unit FB31.1 FB40.1
Y = Currency One FB40.2 FB40.3
Z = Currency Two FB45.1 GL146
GL148 GL167
GL190 GL197
GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GLSV.1
GCN-COMPANY Numeric 4 CA195 FB100
Element: Company Identifies the AP company if the FB101 FB120
resource type = V. Identifies the HR FB121 FB122
company if the resource type = E. It is FB145 FB165
blank for type A, P or Q resources. 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
GLSV.1
GCN-VAR-LEVELS Alpha 30 CA195 FB100
Element: Variable LevelA level that represents the location of FB101 FB120
an accounting unit in an organization's FB121 FB122
level structure. 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
GCN-ACCOUNT Numeric 6 CA195 FB100
Element: Account This field along with the accounting FB101 FB120
unit and subaccount make up the location FB121 FB122
(account) where amounts and other FB145 FB165
account information is stored. 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 GLSV.1
GCN-SUB-ACCOUNT Numeric 4 CA195 FB100
Element: Subaccount This field along with the accounting FB101 FB120
unit and account make up the location FB121 FB122
(account) where amounts and other FB145 FB165
account information is stored. 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 GLSV.1
GCN-CURRENCY-CODE Alpha 5 CA195 FB165
Element: Currency Code This field contains the company base GL146 GL148
currency code established in Company GL167 GL190
(GL10.1 ). GL197 GL199
GL320 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GLSV.1
GCN-DB-BEG-BAL Signed 18.2 FB120 FB121
Debit Beginning The debit beginning balance. FB122 FB145
Balance 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 GLSV.1
GCN-CR-BEG-BAL Signed 18.2 FB120 FB121
Credit Beginning The credit beginning balance. FB122 FB145
Balance 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 GLSV.1
GCN-DB-AMOUNT Signed 18.2 Occurs 13 Times CA195 FB100
Element: Debit Amount The budget debit amount. 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 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GLSV.1
GCN-CR-AMOUNT Signed 18.2 Occurs 13 Times CA195 FB100
Element: Credit Amount The budget credit amount. 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 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
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
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
GCN-CHART-NAME Alpha 12 CA195 FB100
Element: 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 FB145 FB165
system. 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 GLSV.1
GCN-CPAMT-DR Derived
Current Period This is the current period debit
Amount Debit amount.
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
Current Year This is the total current year
Beginning Amount beginning balance.
GCN-CUR-PD-SUM-C-D Derived
Element: Current PeriodThis is the current period summary
debit amount.
GCN-CUR-PD-SUM-C-C Derived
Element: Current PeriodThis is the current period summary
credit amount.
GCN-CUR-PD-SUM-C Derived
Element: Cur Pd Sum C This is the total current period
summary amount.
GCN-CYDAMT Derived
Current Year to This is the current year-to-date
Date Amount amount.
GCN-CPAMT-THOU Derived
Current Period This is the current period amount
Amount Thousand divided by 1,000.
GCN-CYDAMT-THOU Derived
Curr Year to Date This is the current year-to-date amount
Amt Thousand divided by 1,000.
GCN-CPVAR-PCT Derived
Element: Cpvar Pct This is the current period variance
percent.
GCN-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
GCN-CYPAMT1-DR Derived
Current Period 1 Current year period debit amount
Amount Debit period 1.
GCN-CYPAMT1-CR Derived
Current Period 1 Current year period credit amount
Amount Credit period 1.
GCN-CYPAMT1 Derived
Current Period 1 Current year period amount period 1.
Amount
GCN-CYPYTD1 Derived
Curr Per 1 Year to Current year period year to date
Date Amount period 1.
GCN-CYPAMT2-DR Derived
Current Period 2 Current year period debit amount
Amount Debit period 2.
GCN-CYPAMT2-CR Derived
Current Period 2 Current year period credit amount
Amount Credit period 2.
GCN-CYPAMT2 Derived
Current Period 2 Current year period amount period 2.
Amount
GCN-CYPYTD2 Derived
Curr Per 2 Year To Current year period year to date
Date Amount period 2.
GCN-CYPAMT3-DR Derived
Period 3 Base Debit Current year period debit amount
Amount period 3.
GCN-CYPAMT3-CR Derived
Period 3 Base Current year period credit amount
Credit Amount period 3.
GCN-CYPAMT3 Derived
Element: Period 3 Base Current year period amount period 3.
GCN-CYPYTD3 Derived
Element: Period 3 Base Current year period year to date
period 3.
GCN-CYPAMT4-DR Derived
Period 4 Base Debit Current year period debit amount
Amount period 4.
GCN-CYPAMT4-CR Derived
Period 4 Base Current year period credit amount
Credit Amount period 4.
GCN-CYPAMT4 Derived
Element: Period 4 Base Current year period amount period 4.
GCN-CYPYTD4 Derived
Element: Period 4 Base Current year period year to date
period 4.
GCN-CYPAMT5-DR Derived
Period 5 Base Debit Current year period debit amount
Amount period 5.
GCN-CYPAMT5-CR Derived
Peirod 5 Base Current year period credit amount
Credit Amount period 5.
GCN-CYPAMT5 Derived
Element: Peirod 5 Base Current year period amount period 5.
GCN-CYPYTD5 Derived
Element: Peirod 5 Base Current year period year to date
period 5.
GCN-CYPAMT6-DR Derived
Period 6 Base Debit Current year period debit amount
Amount period 6.
GCN-CYPAMT6-CR Derived
Period 6 Base Current year period credit amount
Credit Amount period 6.
GCN-CYPAMT6 Derived
Element: Period 6 Base Current year period amount period 6.
GCN-CYPYTD6 Derived
Element: Period 6 Base Current year period year to date
period 6.
GCN-CYPAMT7-DR Derived
Period 7 Base Debit Current year period debit amount
Amount period 7.
GCN-CYPAMT7-CR Derived
Period 7 Base Current year period credit amount
Credit Amount period 7.
GCN-CYPAMT7 Derived
Element: Period 7 Base Current year period amount period 7.
GCN-CYPYTD7 Derived
Element: Period 7 Base Current year period year to date
period 7.
GCN-CYPAMT8-DR Derived
Period 8 Base Current year period debit amount
Detail Amount period 8.
GCN-CYPAMT8-CR Derived
Period 8 Base Current year period credit amount
Credit Amount period 8.
GCN-CYPAMT8 Derived
Element: Period 8 Base Current year period amount period 8.
GCN-CYPYTD8 Derived
Element: Period 8 Base Current year period year to date
period 8.
GCN-CYPAMT9-DR Derived
Period 9 Base Debit Current year period debit amount
Amount period 9.
GCN-CYPAMT9-CR Derived
Period 9 Base Current year period credit amount
Credit Amount period 9.
GCN-CYPAMT9 Derived
Element: Period 9 Base Current year period amount period 9.
GCN-CYPYTD9 Derived
Element: Period 9 Base Current year period year to date
period 9.
GCN-CYPAMT10-DR Derived
Period 10 Base Current year period debit amount
Debit Amount period 10.
GCN-CYPAMT10-CR Derived
Period 10 Base Current year period credit amount
Credit Amount period 10.
GCN-CYPAMT10 Derived
Period 10 Baes Current year period amount period 10.
Amount
GCN-CYPYTD10 Derived
Period 10 Baes Current year period year to date
Amount period 10.
GCN-CYPAMT11-DR Derived
Period 11 Base Current year period debit amount
Debit Amount period 11.
GCN-CYPAMT11-CR Derived
Period 11 Base Current year period credit amount
Credit Amount period 11.
GCN-CYPAMT11 Derived
Period 11 Base Current year period amount period 11.
Amount
GCN-CYPYTD11 Derived
Period 11 Base Current year period year to date
Amount period 11.
GCN-CYPAMT12-DR Derived
Period 12 Base Current year period debit amount
Debit Amount period 12.
GCN-CYPAMT12-CR Derived
Period 12 Base Current year period credit amount
Credit Amount period 12.
GCN-CYPAMT12 Derived
Period 12 Base Current year period amount period 12.
Amount
GCN-CYPYTD12 Derived
Period 12 Base Current year period year to date
Amount period 12.
GCN-CYPAMT13-DR Derived
Period 13 Base Current year period debit amount
Debit Amount period 13.
GCN-CYPAMT13-CR Derived
Period 13 Base Current year period credit amount
Credit Amount period 13.
GCN-CYPAMT13 Derived
Period 13 Base Current year period amount period 13.
Amount
GCN-CYPYTD13 Derived
Period 13 Base Current year period year to date
Amount period 13.
GCN-PARENT-VAR-LEV Alpha 30 CA195 FB100
Element: Parent Var LevThe variable level address of the parent FB101 FB120
accounting unit. 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
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 FB145 FB165
COMPANY FB190 FB195
VAR-LEVELS FB20.1 FB20.2
ACCOUNT FB20.3 FB20.4
SUB-ACCOUNT FB20.6 FB20.7
CURRENCY-CODE FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL110
GL141 GL146
GL148 GL167
GL190 GL195
...
GCNSET2 FISCAL-YEAR GL141 GL195
LEVEL-DEPTH GL199 GL288
BUDGET-NBR GL320 GLSV.1
TRANS-TYPE GLRV.1
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
GCNSET8 PARENT-VAR-LEVSubset
TRANS-TYPE Where LEVEL-DEPTH > Zeroes
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
BUDGET-NBR
LEVEL-DEPTH
VAR-LEVELS
CURRENCY-CODE
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 RELATED
NAME 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
"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
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
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
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
|