GLCHARTSUM

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
AC191 AC40.4 AC41.4 AC42.1 AP125 AP126
AP131 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 AP30.4 AP520
API1.1 API2.1 BR41.4 BR44.1 CB10.1 CB15.1
CB15.2 CB150 CB191 CB20.1 CB222 CB30.1
CB45.1 CB46.1 CB500 CB543 CB544 CB55.1
CB554 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 EE135
EE35.1 EE35.2 EE520 FB145 FB190 FB40.1
FB40.2 FB40.3 FB45.1 GL146 GL165 GL170
GL190 GL197 GL199 GL292 GL293 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 GL76.1 RW10.2 RW10.3 RW10.4 RW10.6
RW10.7 DR100 IC140 IC141 IC142 IC222
IC66.1 IC83.1 CU01.1 CU01.2 CU02.1 CU02.2
CU03.1 CU10.1 CU10.2 EX545 GL10.1 GL20.1
GL20.2 GL20.4 GL200 IFAC.1 IFEB.1 MX202
MX223 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 ML165 ML65.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.5 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 POIK.1 POIM.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIB.1 RQIF.1 RQIJ.1 SLSE.1 WA01.1
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130
ACVW.1 ATVW.1 AD191 FB100 FB101 FB20.1
FB20.6 FB20.7 FB21.1 GL191 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
ML191 ML94.1 ML94.2 ML94.3 ML94.4 ML95.1
ML95.2 ML95.3 ML95.4 ML95.5 ML95.6 ML95.7
ML95.8 ML95.9 ML96.1 ML96.2 ML96.3 ML96.4
ML96.5 ML97.1 ML97.2 ML97.3 ML97.4 ML97.5
ML97.6 ML97.7 ML97.8 ML97.9 ML98.1 ML98.2
ML98.3 ML98.4 ML98.5 ML99.1 ML99.2 ML99.3
ML99.4 ML99.5 ML99.6 SLVW.1 SNOA.1 SNRA.1
SNSA.1 AC34.1 AD290 AD50.1 AD95.1 AD96.1
AD97.1 AD97.2 AD97.3 AD98.1 AD98.2 AD98.3
GL55.1 RW00.1 RW20.5 RW20.6 RW20.1 RW20.2
RW298 RW60.1 RW60.4 GL121 GL22.2 GL22.1
ML292 ML293 SN01.1 SN60.1 SN60.2 SNFL.1
SNGL.1 CA210 CA240 FB141 GL281 GL288
GL294 GL326 GL328 RW200 RW210 RW220
RW299 SL02.2 ML11.1


UPDATED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC32.1 AC37.1 AC490 AM180
CA10.5 CA110 FB11.1 FB111 FB160 FB211
FB296 FB60.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 GL100 GL256 GL298 GL299
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 GL00.1 GL00.2 GL00.3 GL00.8 GL00.9
GL02.1 GL02.2 GL02.3 GL03.2 GL03.4 GL160
GLAC.1 MX123 WAOP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCS-CHART-NAME
Element: Chart Name
Alpha 12
This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.
GL00.1 GL00.9
GL03.2 GL160
GCS-CHART-SECTION
Element: Chart Section
Alpha 1
The chart section.
1 = Balance Sheet
2 = Income Statement
GL00.1 GL03.2
GL160
GCS-SEQ-NUMBER
Element: Sequence Number
Numeric 6
A unique number assigned to the summary account.
GL00.1 GL03.2
GL160
GCS-SUMMARY-ACCT
Element: Summary Account
Alpha 12
The summary account.
GL00.1 GL00.8
GL03.2 GL160
GCS-ACCOUNT-DESC
Element: Account Description
Alpha 60 (Lower Case)
The account description.
GL00.1 GL03.2
GL160
GCS-TOTAL-DESC
Element: Total Description
Alpha 60 (Lower Case)
The description that appears next to the transaction total.
GL00.1 GL03.2
GCS-DEPTH
Element: Depth
Numeric 2
Indicates the order of account 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
GL00.1 GL03.2
GL160
GCS-SUMRY-ACCT-ID
Element: Summary Account ID
Numeric 6
The summary account.
GL00.1 GL03.2
GL160
GCS-SPACE-CODE
Element: Space Code
Numeric 1
Indicates the number of spaces you want 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
GL00.1 GL03.2
GL160 GL281
GCS-SIGN-CODE
Element: Sign Code
Alpha 1
This field determines whether the sign 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
GL00.1 GL03.2
GL160
GCS-SPACE-CODE-TTL
Element: Space Code Total
Numeric 1
The number of spaces appearing after the summary account total.
1 = Advance 1 Line
2 = Advance 2 Lines
3 = Advance 3 Lines
9 = Advance to Next Page
GL00.1 GL03.2
GL160
GCS-UNDERLINE-B4
Element: Underline Before
Alpha 1
The underline appearing before the total.
S = Single
D = Double
N = None
GL00.1 GL03.2
GL160 GL281
GCS-UNDERLINE-AFT
Element: Underline After
Alpha 1
The underline appearing after the total.
S = Single
D = Double
N = None
GL00.1 GL03.2
GL160 GL281
GCS-PRINT-HEADING
Element: Print Heading
Alpha 1
Indicates if the heading is printed for financial statements.
Y = Yes
N = No
GL00.1 GL03.2
GCS-PARENT-OBJ-ID
Element: Parent Object ID
Numeric 12
The ID of the parent object.
GL00.1 GL03.2
GL160
GCS-DYNAMIC-LIST
Element: Dynamic List
Alpha 12
A valid accounting unit attribute list. Detail accounts are created for the accounting unit after transactions are entered.
GL00.1 GL03.2
GL160
GCS-RESTRICT-SYS
Element: Restrict System
Alpha 1
Indicates if system codes are validated every time the account is used by a system.
N = No
Y = Yes
GL00.1 GL03.2
GL03.4
GCS-ACCT-CATEGORY
Element: Account Category
Alpha 5
Account categories are groupings of 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
GL00.1 GL03.2
GL160
GCS-DAILY-BALANCE
Element: Daily Balance
Alpha 1

Y = Yes
N = No
" "
GL00.1 GL03.2
GL160
GCS-RELATION
Element: Relation
Alpha 15
The user analysis value relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation).
GL00.1 GL03.2
GCS-UNARY-OPER
Element: Unary Operator
Alpha 1
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
GL00.1 GL03.2
GL160
GCS-NAT-BALANCE
Element: Natural Balance
Alpha 1
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
GL00.1 GL03.2
GL160
GCS-SL-ACCT-FLAG
Element: SL Account Flag
Alpha 1
This flag determines whether user analysis values can be assigned to a specific account. You can select Yes, No, or use the Summary Account selection.
GL00.1 GL03.2
GL160
GCS-OBJ-ID
Element: Object Id
Numeric 12
This is the unique object identifier.
GL00.1 GL00.9
GL03.2 GL160
GCS-LEDGER-GROUP
Element: Ledger Group
Alpha 15
GL00.1 GL03.2
GL160
GCS-GL-BUD-FL
Element: GL Budget Edit Flag
Alpha 1
This is the Yes/No flag for budget editing.
N = No Edit
Y = Yes
GL00.1 GL03.2
GL160


GLCHARTSUM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCSSET1 CHART-NAME
CHART-SECTION
SEQ-NUMBER
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
ATVW.1 AD191
AM180 CA10.5
CA110 FB100
FB101 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
GCSSET2 CHART-NAME
SUMMARY-ACCT
KeyChange
...
AC34.1 ACVW.1
ATVW.1 AD290
AD50.1 AD95.1
AD96.1 AD97.1
AD97.2 AD97.3
AD98.1 AD98.2
AD98.3 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
GCSSET3 CHART-NAME
CHART-SECTION
SUMMARY-ACCT
KeyChange
GL00.1 GL160
GCSSET4 CHART-NAME
PARENT-OBJ-ID
CHART-SECTION
SEQ-NUMBER
KeyChange
GCSSET5 CHART-NAME
SUMRY-ACCT-ID
...
AC121 AC123
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 AD191
AD290 AD50.1
AD95.1 AD96.1
AD97.1 AD97.2
AD97.3 AD98.1
AD98.2 AD98.3
AM180 AP125
GCSSET6 RELATION
CHART-NAME
CHART-SECTION
SEQ-NUMBER
KeyChange
SL02.2
GCSSET7 OBJ-ID
Subset
WhereOBJ-ID !=Zeroes
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
ATVW.1 AD191
AM180 CA10.5
CA110 FB100
FB101 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
GCSSET8 LEDGER-GROUP
CHART-NAME
CHART-SECTION
SEQ-NUMBER
KeyChange, Subset
WhereLEDGER-GROUP !=Spaces
ML11.1


GLCHARTSUM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Chart Of Accts GLCHART Required
GCS-CHART-NAME->GCH-CHART-NAME
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
NAME
RELATED 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


File created: Thu Jun 09 11:18:32 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.