 |
Lawson Insight Technical Documentation |
|
GLCHARTSUM FILE
General Ledger Chart Summary
This file contains chart summary records including summary account
information and report options defined in GL00.1 (Chart of Accounts) and the
Summary Account Options subform.
REFERENCED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC30.2 AC30.3 AC32.1 AC490
ACVW.1 AM180 CA10.5 CA10.1 CA10.7 CA110
FB100 FB101 FB20.1 FB20.6 FB20.7 FB21.1
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL100 GL191 GL256 GL95.1 GL95.2 GL95.3
GL95.4 GL95.5 GL95.6 GL95.7 GL95.8 GL95.9
GL96.1 GL96.2 GL96.3 GL96.4 GL96.5 GL97.1
GL97.2 GL97.3 GL97.4 GL97.5 GL97.6 GL97.7
GL97.8 GL97.9 GL98.1 GL98.2 GL98.3 GL98.4
GL98.5 GL99.1 GL99.2 GL99.3 GL99.4 GL99.5
GL99.6 RW100 RW215 RW230 RW270 RW30.1
RW70.1 RW80.1 GLAV.1 GLCV.1 GLVW.1 IF720
IFBA.1 SLVW.1 AC34.1 GL292 GL293 GL55.1
RW00.1 RW10.2 RW10.3 RW10.4 RW10.6 RW10.7
RW20.5 RW20.6 RW20.1 RW20.2 RW298 RW60.1
RW60.4 GL02.1 GL02.2 GL02.3 GL02.6 GL121
GL16.1 GL16.2 GL16.3 GL200 GL22.2 GL22.1
GLAC.1 MX123 AC191 CA210 CA240 FB141
GL281 GL288 GL294 GL326 GL328 RW200
RW210 RW220 RW299 IC222 GL20.2 IFAC.1
MX202 SLSE.1 MX223
UPDATED BY
GL00.1 GL00.2 GL00.8 GL00.9 GL03.2 GL03.4
GL160
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCS-CHART-NAME Alpha 12 GL00.1 GL00.9
Chart Name This is the name you assigned to the GL03.2 GL160
chart of accounts when you defined your
company structure in the General Ledger
system.
GCS-CHART-SECTION Alpha 1 GL00.1 GL03.2
Chart Section The chart section. GL160
1 = Balance Sheet
2 = Income Statement
GCS-SEQ-NUMBER Numeric 6 GL00.1 GL03.2
Sequence Number A unique number assigned to the summary GL160
account.
GCS-SUMMARY-ACCT Alpha 12 GL00.1 GL00.8
Summary Account The summary account. GL03.2 GL160
GCS-ACCOUNT-DESC Alpha 60 (Lower Case) GL00.1 GL03.2
Account Desc The account description. GL160
GCS-TOTAL-DESC Alpha 60 (Lower Case) GL00.1 GL03.2
Total Description The description that appears next to
the transaction total.
GCS-DEPTH Numeric 2 GL00.1 GL03.2
Depth Indicates the order of account GL160
totaling. For example, each account
assigned a depth of 2, totals to the
previous account assigned a depth of 1.
01 = Depth 1
02 = Depth 2
03 = Depth 3
04 = Depth 4
05 = Depth 5
06 = Depth 6
07 = Depth 7
08 = Depth 8
09 = Depth 9
GCS-SUMRY-ACCT-ID Numeric 6 GL00.1 GL03.2
Summary Account ID The summary account. GL160
GCS-SPACE-CODE Numeric 1 GL00.1 GL03.2
Space Code Indicates the number of spaces you want GL160 GL281
to advance on a report after the
heading.
1 = Advance 1 Line
2 = Advance 2 Lines
3 = Advance 3 Lines
9 = Advance to Next Page
GCS-SIGN-CODE Alpha 1 GL00.1 GL03.2
Sign Code This field determines whether the sign GL160
following an account balance is
reversed. The default is No.
This field is for appearance only, it
does not change the amount balance.
N = No
Y = Yes
GCS-SPACE-CODE-TTL Numeric 1 GL00.1 GL03.2
Space Code Total The number of spaces appearing after GL160
the summary account total.
1 = Advance 1 Line
2 = Advance 2 Lines
3 = Advance 3 Lines
9 = Advance to Next Page
GCS-UNDERLINE-B4 Alpha 1 GL00.1 GL03.2
Underline Before The underline appearing before the GL160 GL281
total.
S = Single
D = Double
N = None
GCS-UNDERLINE-AFT Alpha 1 GL00.1 GL03.2
Underline After The underline appearing after the GL160 GL281
total.
S = Single
D = Double
N = None
GCS-PRINT-HEADING Alpha 1 GL00.1 GL03.2
Print Heading Indicates if the heading is printed for
financial statements.
Y = Yes
N = No
GCS-PARENT-OBJ-ID Numeric 12 GL00.1 GL03.2
Parent Object ID The ID of the parent object. GL160
GCS-DYNAMIC-LIST Alpha 12 GL00.1 GL03.2
Dynamic List A valid accounting unit attribute list. GL160
Detail accounts are created for the
accounting unit after transactions are
entered.
GCS-RESTRICT-SYS Alpha 1 GL00.1 GL03.4
Restrict System Indicates if system codes are validated
every time the account is used by a
system.
N = No
Y = Yes
GCS-ACCT-CATEGORY Alpha 5 GL00.1 GL03.2
Account Category Account categories are groupings of GL160
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
GCS-DAILY-BALANCE Alpha 1 GL00.1 GL03.2
Daily Balance Determines whether transactions can be GL160
viewed on a daily basis.
Y = Yes
N = No
" "
GCS-RELATION Alpha 15 GL00.1 GL03.2
User Analysis The user analysis value relation
Relation assigned to the detail or summary
account.
The relation must exist in SL02.1 (User
Analysis Value Relation).
GCS-UNARY-OPER Alpha 1 GL00.1 GL160
Unary Oper The mathematical operation to
consolidate amounts for a natural
balance. Valid values are Add,
subtract, multiply, and divide. The
default is Add.
Only used by the OLAP environment.
+ = Addition
- = Subtraction
* = Multiplication
/ = Division
% = Percentile
" " = Do Nothing
GCS-NAT-BALANCE Alpha 1 GL00.1 GL160
Nat Balance This field determines whether the
natural balance is a Debit or Credit.
This field is not required.
This is only used by the OLAP
environment.
D = Debit
C = Credit
" " = Blank
GCS-SL-ACCT-FLAG Alpha 1 GL00.1 GL03.2
Strategic Ledger This flag determines whether user GL160
analysis values can be assigned to a
specific account. You can select Yes,
No, or use the Summary Account
selection.
GCS-OBJ-ID Numeric 12 GL00.1 GL00.9
Object This is the unique object identifier. GL160
Identification
GCS-LEDGER-GROUP Alpha 15 GL00.1 GL160
Ledger Group
GLCHARTSUM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCSSET1 CHART-NAME KeyChange AC121 AC123
CHART-SECTION AC130 AC20.1
SEQ-NUMBER AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB101
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL100 GL191
...
GCSSET2 CHART-NAME KeyChange AC34.1 ACVW.1
SUMMARY-ACCT CA10.1 CA10.7
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL100 GL191
GL256 GL292
GL293 GL55.1
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
...
GCSSET3 CHART-NAME KeyChange GL00.1 GL160
CHART-SECTION
SUMMARY-ACCT
GCSSET4 CHART-NAME KeyChange
PARENT-OBJ-ID
CHART-SECTION
SEQ-NUMBER
GCSSET5 CHART-NAME AC121 AC123
SUMRY-ACCT-ID AC130 AC191
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC30.2
AC30.3 AC32.1
AC490 ACVW.1
AM180 CA10.1
CA10.5 CA10.7
CA110 CA210
CA240 FB100
FB101 FB141
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
...
GCSSET6 RELATION KeyChange
CHART-NAME
CHART-SECTION
SEQ-NUMBER
GCSSET7 OBJ-ID Subset AC121 AC123
Where OBJ-ID != Zeroes AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB101
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL256 GL95.1
...
GCSSET8 LEDGER-GROUP KeyChange, Subset
CHART-NAME Where LEDGER-GROUP != Spaces
CHART-SECTION
SEQ-NUMBER
GLCHARTSUM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Chart Of Accts GLCHART Required
GCS-CHART-NAME -> GCH-CHART-NAME (GCHSET1)
Mxlisthdr MXLISTHDR Not Required
"ACCTU" -> MLH-OBJ-TYPE
GCS-DYNAMIC-LIST -> MLH-MATRIX-LIST
Parent GLCHARTSUM Not Required
GCS-CHART-NAME -> GCS-CHART-NAME
GCS-PARENT-OBJ-ID -> GCS-SUMRY-ACCT-ID
GLCHARTSUM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Children GLCHARTSUM
GCS-CHART-NAME -> GCS-CHART-NAME
GCS-SUMRY-ACCT-ID -> GCS-PARENT-OBJ-ID
GCS-CHART-SECTION
GCS-SEQ-NUMBER
Detail Accts GLCHARTDTL Delete Restricted
GCS-CHART-NAME -> GDT-CHART-NAME
GCS-SUMRY-ACCT-ID -> GDT-SUMRY-ACCT-ID
GDT-ACCOUNT
GDT-SUB-ACCOUNT
Glacctvld Sys GLACCTVLD
"S" -> VLD-RECORD-TYPE
GCS-CHART-NAME -> VLD-CHART-NAME
GCS-SUMRY-ACCT-ID -> VLD-SUMRY-ACCT-ID
Zeroes -> VLD-ACCOUNT
Zeroes -> VLD-SUB-ACCOUNT
Zeroes -> VLD-COMPANY
Spaces -> VLD-ACCT-UNIT
VLD-SYSTEM
Mxlistmbr MXLISTMBR
"ACCTU" -> MLM-OBJ-TYPE
GCS-DYNAMIC-LIST -> MLM-MATRIX-LIST
MLM-SEQ-NUMBER
|