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 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCN-FISCAL-YEAR Numeric 4 CA195 FB100
Element: Fiscal Year Contains the fiscal year for the data FB101 FB120
stored on this 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 GL500
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 GL500
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 GL500
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 GL500
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
GL500 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 GL500
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 GL500
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 GL500
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 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 GL500
GLSV.1
GCN-CR-BEG-BAL Signed 18.2 FB120 FB121
Credit Beginning 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 GL500
GLSV.1
GCN-DB-AMOUNT Signed 18.2 Occurs 13 Times CA195 FB100
Element: 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 GL500
GLSV.1
GCN-CR-AMOUNT Signed 18.2 Occurs 13 Times CA195 FB100
Element: 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 GL500
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 GL500
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 GL500
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
Element: Cypamt3 Dr Current year period debit amount
period 3.
GCN-CYPAMT3-CR Derived
Element: Cypamt3 Cr Current year period credit amount
period 3.
GCN-CYPAMT3 Derived
Element: Cypamt3 Current year period amount period 3.
GCN-CYPYTD3 Derived
Element: Cypamt3 Current year period year to date
period 3.
GCN-CYPAMT4-DR Derived
Element: Cypamt4 Dr Current year period debit amount
period 4.
GCN-CYPAMT4-CR Derived
Element: Cypamt4 Cr Current year period credit amount
period 4.
GCN-CYPAMT4 Derived
Element: Cypamt4 Current year period amount period 4.
GCN-CYPYTD4 Derived
Element: Cypamt4 Current year period year to date
period 4.
GCN-CYPAMT5-DR Derived
Element: Cypamt5 Dr Current year period debit amount
period 5.
GCN-CYPAMT5-CR Derived
Element: Cypamt5 Cr Current year period credit amount
period 5.
GCN-CYPAMT5 Derived
Element: Cypamt5 Current year period amount period 5.
GCN-CYPYTD5 Derived
Element: Cypamt5 Current year period year to date
period 5.
GCN-CYPAMT6-DR Derived
Element: Cypamt6 Dr Current year period debit amount
period 6.
GCN-CYPAMT6-CR Derived
Element: Cypamt6 Cr Current year period credit amount
period 6.
GCN-CYPAMT6 Derived
Element: Cypamt6 Current year period amount period 6.
GCN-CYPYTD6 Derived
Element: Cypamt6 Current year period year to date
period 6.
GCN-CYPAMT7-DR Derived
Element: Cypamt7 Dr Current year period debit amount
period 7.
GCN-CYPAMT7-CR Derived
Element: Cypamt7 Cr Current year period credit amount
period 7.
GCN-CYPAMT7 Derived
Element: Cypamt7 Current year period amount period 7.
GCN-CYPYTD7 Derived
Element: Cypamt7 Current year period year to date
period 7.
GCN-CYPAMT8-DR Derived
Element: Cypamt8 Dr Current year period debit amount
period 8.
GCN-CYPAMT8-CR Derived
Element: Cypamt8 Cr Current year period credit amount
period 8.
GCN-CYPAMT8 Derived
Element: Cypamt8 Current year period amount period 8.
GCN-CYPYTD8 Derived
Element: Cypamt8 Current year period year to date
period 8.
GCN-CYPAMT9-DR Derived
Element: Cypamt9 Dr Current year period debit amount
period 9.
GCN-CYPAMT9-CR Derived
Element: Cypamt9 Cr Current year period credit amount
period 9.
GCN-CYPAMT9 Derived
Element: Cypamt9 Current year period amount period 9.
GCN-CYPYTD9 Derived
Element: Cypamt9 Current year period year to date
period 9.
GCN-CYPAMT10-DR Derived
Element: Cypamt10 Dr Current year period debit amount
period 10.
GCN-CYPAMT10-CR Derived
Element: Cypamt10 Cr Current year period credit amount
period 10.
GCN-CYPAMT10 Derived
Element: Cypamt10 Current year period amount period 10.
GCN-CYPYTD10 Derived
Element: Cypamt10 Current year period year to date
period 10.
GCN-CYPAMT11-DR Derived
Element: Cypamt11 Dr Current year period debit amount
period 11.
GCN-CYPAMT11-CR Derived
Element: Cypamt11 Cr Current year period credit amount
period 11.
GCN-CYPAMT11 Derived
Element: Cypamt11 Current year period amount period 11.
GCN-CYPYTD11 Derived
Element: Cypamt11 Current year period year to date
period 11.
GCN-CYPAMT12-DR Derived
Element: Cypamt12 Dr Current year period debit amount
period 12.
GCN-CYPAMT12-CR Derived
Element: Cypamt12 Cr Current year period credit amount
period 12.
GCN-CYPAMT12 Derived
Element: Cypamt12 Current year period amount period 12.
GCN-CYPYTD12 Derived
Element: Cypamt12 Current year period year to date
period 12.
GCN-CYPAMT13-DR Derived
Element: Cypamt13 Dr Current year period debit amount
period 13.
GCN-CYPAMT13-CR Derived
Element: Cypamt13 Cr Current year period credit amount
period 13.
GCN-CYPAMT13 Derived
Element: Cypamt13 Current year period amount period 13.
GCN-CYPYTD13 Derived
Element: Cypamt13 Current year period year to date
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 GL500
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
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 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
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
|