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
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
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 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
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 determines if amounts or units are FB101 FB120
processed in each transaction. FB121 FB122
FB145 FB165
A = Amounts FB190 FB20.1
U = Units 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
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 The company number represents an FB101 FB120
established company and is entered on FB121 FB122
all function codes. 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 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 Levels 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
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
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
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 GL167
currency code established in Company GL190 GL197
(GL10.1 ). GL199 GL320
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GLSV.1
GCN-DB-BEG-BAL Currency 15.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 GLSV.1
GCN-CR-BEG-BAL Currency 15.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 GLSV.1
GCN-DB-AMOUNT Currency 15.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 GL167
GL190 GL197
GL320 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GLSV.1
GCN-CR-AMOUNT Currency 15.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 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
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
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
Element: Cybamt This is the total current year
beginning balance.
GCN-CUR-PD-SUM-C-D Derived
Element: Cur Pd Sum C DThis is the current period summary
debit amount.
GCN-CUR-PD-SUM-C-C Derived
Element: Cur Pd Sum C CThis 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
Element: Cydamt This is the current year-to-date
amount.
GCN-CPAMT-THOU Derived
Element: Cpamt Thou This is the current period amount
divided by 1,000.
GCN-CYDAMT-THOU Derived
Element: Cydamt Thou This is the current year-to-date amount
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-OBJ-ID Numeric 12 GL146 GL167
Object This is the object identifier. It is a GL190 GL197
Identification unique key which facilitates drill GL199 GL320
around. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GCN-PARENT-OBJ-ID Numeric 12 GL146 GL167
Object This is the parent object identifier. GL190 GL197
Identification This unique key facilitates drill around GL199 GL320
to the parent record. 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
GL167 GL190
GL195 GL197
...
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 KeyChange
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
|