Lawson Insight Technical Documentation |
|
GLCHARTSUM
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 AC32.1 AC37.1 AC490 ACVW.1
ATVW.1 AM180 CA10.5 CA10.1 CA10.7 CA110
FB100 FB101 FB11.1 FB111 FB160 FB20.1
FB20.6 FB20.7 FB21.1 FB211 FB296 FB60.1
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL100 GL191 GL256 GL298 GL90.6 GL94.1
GL94.2 GL94.3 GL94.4 GL94.5 GL94.6 GL94.7
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 GL16.4
GL16.1 GL16.2 GL16.3 GLAV.1 GLCV.1 GLVW.1
IFBA.1 SLVW.1 SNOA.1 SNRA.1 SNSA.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 GL200 GL22.2 GL22.1
GLAC.1 MX123 SN01.1 SN60.1 SN60.2 SNFL.1
SNGL.1 AC191 AC40.4 AC41.4 AC42.1 AP125
AP126 AP170 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP520 API1.1
API2.1 BR41.4 BR44.1 CB10.1 CB15.1 CB15.2
CB150 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 EE135
EE35.1 EE35.2 EE520 CA210 CA240 FB141
FB145 FB190 FB40.1 FB40.2 FB40.3 FB45.1
GL146 GL165 GL170 GL190 GL197 GL281
GL288 GL294 GL326 GL328 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL65.1
GL70.1 GL70.2 GL70.3 GL70.5 GL70.6 GL75.1
RW200 RW210 RW220 RW299 GL20.2 IFAC.1
MX202 MA41.1 MA41.2 MA41.4 MA41.7 MA43.2
MA61.1 MAI1.1 PO150 PO25.1 PO25.6 PO25.7
PO536 POIM.1 RQ10.1 RQ10.3 RQ11.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1 SLSE.1
SL02.2 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
Element: 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
Element: Chart Section The chart section. GL160
1 = Balance Sheet
2 = Income Statement
GCS-SEQ-NUMBER Numeric 6 GL00.1 GL03.2
Element: Sequence NumbeA unique number assigned to the summary GL160
account.
GCS-SUMMARY-ACCT Alpha 12 GL00.1 GL00.8
Element: Summary AccounThe summary account. GL03.2 GL160
GCS-ACCOUNT-DESC Alpha 60 (Lower Case) GL00.1 GL03.2
Element: Account DescriThe account description. GL160
GCS-TOTAL-DESC Alpha 60 (Lower Case) GL00.1 GL03.2
Element: Total DescriptThe description that appears next to
the transaction total.
GCS-DEPTH Numeric 2 GL00.1 GL03.2
Element: 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
Element: Summary AccounThe summary account. GL160
GCS-SPACE-CODE Numeric 1 GL00.1 GL03.2
Element: 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
Element: 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
Element: Space Code TotThe 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
Element: Underline BefoThe underline appearing before the GL160 GL281
total.
S = Single
D = Double
N = None
GCS-UNDERLINE-AFT Alpha 1 GL00.1 GL03.2
Element: Underline AfteThe underline appearing after the GL160 GL281
total.
S = Single
D = Double
N = None
GCS-PRINT-HEADING Alpha 1 GL00.1 GL03.2
Element: 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
Element: Parent Object The ID of the parent object. GL160
GCS-DYNAMIC-LIST Alpha 12 GL00.1 GL03.2
Element: 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.2
Element: Restrict SysteIndicates if system codes are validated GL03.4
every time the account is used by a
system.
N = No
Y = Yes
GCS-ACCT-CATEGORY Alpha 5 GL00.1 GL03.2
Element: Account CategoAccount 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.
Valid account category types are:
cost
revenue
accrual
pass thru
GCS-DAILY-BALANCE Alpha 1 GL00.1 GL03.2
Element: Daily Balance Y = Yes GL160
N = No
" "
GCS-RELATION Alpha 15 GL00.1 GL03.2
Element: Relation The user analysis value 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 GL03.2
Element: Unary OperatorThe mathematical operation to GL160
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 GL03.2
Element: Natural BalancThis field determines whether the GL160
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
Element: SL Account FlaThis 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
Element: Object Id This is the unique object identifier. GL03.2 GL160
GCS-LEDGER-GROUP Alpha 15 GL00.1 GL03.2
Element: Ledger Group GL160
GCS-GL-BUD-FL Alpha 1 GL00.1 GL03.2
Element: GL Budget EditThis is the Yes/No flag for budget GL160
editing.
N = No Edit
Y = Yes
GLCHARTSUM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCSSET1 CHART-NAME AC121 AC123
CHART-SECTION AC130 AC20.1
SEQ-NUMBER AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
ATVW.1 AM180
CA10.5 CA110
FB100 FB101
FB11.1 FB111
FB160 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB60.1
FB95.1 FB95.2
...
GCSSET2 CHART-NAME KeyChange AC34.1 ACVW.1
SUMMARY-ACCT ATVW.1 CA10.1
CA10.7 FB11.1
FB111 FB160
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL100
GL191 GL256
GL292 GL293
GL298 GL55.1
GL90.6 GL94.1
GL94.2 GL94.3
GL94.4 GL94.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 AC32.1
AC37.1 AC40.4
AC41.4 AC42.1
AC490 ACVW.1
ATVW.1 AM180
AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
...
GCSSET6 RELATION KeyChange SL02.2
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
AC32.1 AC37.1
AC490 ACVW.1
ATVW.1 AM180
CA10.5 CA110
FB100 FB101
FB11.1 FB111
FB160 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB60.1
FB95.1 FB95.2
...
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
|