 |
Lawson Insight Technical Documentation |
|
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
FB165 FB20.1 FB20.2 FB20.3 FB20.4 FB20.6
FB20.7 FB21.1 FB30.1 FB31.1 GL110 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 Period Closing FB121 FB122
(GL199). FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 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 GL146
1 = Level 1 GL167 GL190
2 = Level 2 GL199 GL320
3 = Level 3 GL45.1 GLSV.1
4 = Level 4
GCN-BUDGET-NBR Numeric 3 CA195 FB100
Budget Number 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 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 GL146
N = Budget Unit GL167 GL190
Y = Currency One GL199 GL320
Z = Currency Two 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
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 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 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 GL146
GL167 GL190
GL199 GL320
GL45.1 GLSV.1
GCN-CURRENCY-CODE Alpha 5 CA195 FB165
Currency Code This field contains the company base GL146 GL167
currency code established in Company GL190 GL199
(GL10.1 ). 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 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 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
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
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 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 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
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.
GCN-OBJ-ID Numeric 12 GL146 GL167
Object This is the object identifier. It is a GL190 GL199
Identification unique key which facilitates drill GL320 GL45.1
around.
GCN-PARENT-OBJ-ID Numeric 12 GL146 GL167
Parent Obj Id This is the parent object identifier. GL190 GL199
This unique key facilitates drill around GL320 GL45.1
to the parent record.
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
GL141 GL146
GL167 GL190
GL195 GL199
GL320 GL45.1
GLSV.1 GLRV.1
GCNSET2 FISCAL-YEAR FB195 GL141
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
GCNSET6 OBJ-ID
TRANS-TYPE
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
LEVEL-DEPTH
CURRENCY-CODE
BUDGET-NBR
GCNSET7 PARENT-OBJ-ID
TRANS-TYPE
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
LEVEL-DEPTH
BUDGET-NBR
CURRENCY-CODE
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 (GDTSET2)
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-OBJ-ID -> GCN-OBJ-ID
"A" -> GCN-TRANS-TYPE
GCN-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS -> GCN-VAR-LEVELS
GCN-ACCOUNT -> GCN-ACCOUNT
GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR
GCN-LEVEL-DEPTH -> GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
GCN-BUDGET-NBR
Cam Children 1 CUAMOUNT
GCN-OBJ-ID -> CAM-PARENT-OBJ-ID
3 -> CAM-AMT-TYPE
GCN-COMPANY -> CAM-COMPANY
CAM-ACCT-UNIT
CAM-ACCOUNT
CAM-SUB-ACCOUNT
CAM-VAR-LEVELS
CAM-FISCAL-YEAR
CAM-CURRENCY-CODE
Cam Children 2 CUAMOUNT
GCN-OBJ-ID -> CAM-PARENT-OBJ-ID
4 -> CAM-AMT-TYPE
GCN-COMPANY -> CAM-COMPANY
CAM-ACCT-UNIT
CAM-ACCOUNT
CAM-SUB-ACCOUNT
CAM-VAR-LEVELS
CAM-FISCAL-YEAR
CAM-CURRENCY-CODE
Children GLCONSOL
GCN-OBJ-ID -> GCN-PARENT-OBJ-ID
GCN-TRANS-TYPE -> GCN-TRANS-TYPE
GCN-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS
GCN-ACCOUNT
GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR
GCN-LEVEL-DEPTH
GCN-BUDGET-NBR
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-OBJ-ID -> GCN-OBJ-ID
"Y" -> GCN-TRANS-TYPE
GCN-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS -> GCN-VAR-LEVELS
GCN-ACCOUNT -> GCN-ACCOUNT
GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR
GCN-LEVEL-DEPTH -> GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
GCN-BUDGET-NBR
Curr 2 GLCONSOL
GCN-OBJ-ID -> GCN-OBJ-ID
"Z" -> GCN-TRANS-TYPE
GCN-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS -> GCN-VAR-LEVELS
GCN-ACCOUNT -> GCN-ACCOUNT
GCN-SUB-ACCOUNT -> GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR -> GCN-FISCAL-YEAR
GCN-LEVEL-DEPTH -> GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
GCN-BUDGET-NBR
Gam Children GLAMOUNTS
GCN-OBJ-ID -> GAM-PARENT-OBJ-ID
GCN-COMPANY -> GAM-COMPANY
GAM-ACCT-UNIT
GAM-ACCOUNT
GAM-SUB-ACCOUNT
GAM-FISCAL-YEAR
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
Parent GLCONSOL
GCN-PARENT-OBJ-ID -> GCN-OBJ-ID
GCN-TRANS-TYPE -> GCN-TRANS-TYPE
GCN-COMPANY -> GCN-COMPANY
GCN-VAR-LEVELS
GCN-ACCOUNT
GCN-SUB-ACCOUNT
GCN-FISCAL-YEAR
GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
GCN-BUDGET-NBR
|