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
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 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 GL293 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 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 IFBD.2 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 GL292
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
ML292 ML293 SN01.1 SN60.1 SN60.2 SNFL.1
SNGL.1 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
AP510 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 CA210
CA240 FB141 FB145 FB190 FB40.1 FB40.2
FB40.3 FB45.1 GL122 GL146 GL165 GL170
GL190 GL197 GL199 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 GL76.1 RW200
RW210 RW220 RW299 DR100 IC12.1 IC140
IC141 IC142 IC145 IC222 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 CU01.1
CU01.2 CU02.1 CU02.2 CU03.1 CU10.1 CU10.2
CU20.1 CU20.3 EX545 GL10.1 GL20.1 GL20.2
GL20.4 IFAC.1 IFEB.1 MX202 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 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 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 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 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1 SLSE.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 SL02.2
MX223 ML11.1


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
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
GCS-GL-ACCT-TYPE
Element: Gl Acct Type
Numeric 2

01 = Asset
02 = Liability
03 = Equity
04 = Revenue
05 = Expense
06 = Statistical
GL00.1 GL160
GCS-XBRL-TAG-ID
Element: Xbrl Tag Id
Alpha 60
GL00.1 GL160
GCS-CREATED-BY
Element: Operator
Alpha 10
GL00.1 GL00.9
GL03.2 GL160
GCS-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
GL00.1 GL00.8
GL00.9 GL03.2
GL03.4 GL160
GCS-LAST-UPDT-TIME
Element: Time
Numeric 8
GL00.1 GL00.8
GL00.9 GL03.2
GL03.4 GL160
GCS-LAST-UPDATE-BY
Element: Operator
Alpha 10
GL00.1 GL00.8
GL00.9 GL03.2
GL03.4 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
Glchsumbod GLCHSUMBOD Not Required, Delete Cascades
GCS-CHART-NAME->YBV-CHART-NAME
GCS-CHART-SECTION->YBV-CHART-SECTION
GCS-SEQ-NUMBER->YBV-SEQ-NUMBER
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 02:20:36 2016

Home
Contact Us



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