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 AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACBO.1 ACVW.1 CA10.5 CA10.1 CA10.8 CA110 FB100 FB101 FB20.1 FB20.6 FB20.7 FB20.3 FB20.4 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 GLCV.1 GLOB.1 GLVW.1 GL292 GL293 GL55.1 GL950 JB240 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 GL121 GL200 AC191 CA210 CA240 FB121 FB141 FB165 FB230 FB231 FB30.1 FB31.1 FB65.1 GL170 GL230 GL270 GL281 GL288 GL294 GL326 GL328 RW200 RW210 RW220 RW299 IC222 GL20.2 IFAC.1 RQ10.1 SLSE.1 SL02.2 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-DESCRIPTION Alpha 30 (Lower Case) GL00.1 GL03.2 Description The summary account description. GL160 GCS-TOTAL-DESC Alpha 30 (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 total. GL160 GL281 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-SNGL-ACCT-TYPE Alpha 1 Account Type Indicates if an account must be either all credits or all debits. 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 Consolidation 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. GCS-NAT-BALANCE Alpha 1 GL00.1 GL160 Natural 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. 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. GLCHARTSUM FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN GCSSET1 CHART-NAME KeyChange AC121 AC123 CHART-SECTION AC127 AC130 SEQ-NUMBER AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACBO.1 ACVW.1 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 AC20.1 AC20.2 SUMMARY-ACCT AC20.3 AC20.4 AC30.2 AC30.3 CA10.1 CA10.8 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 GL950 ... GCSSET3 CHART-NAME KeyChange GL00.1 CHART-SECTION SUMMARY-ACCT GCSSET4 CHART-NAME KeyChange PARENT-OBJ-ID CHART-SECTION SEQ-NUMBER GCSSET5 CHART-NAME AC121 AC123 SUMRY-ACCT-ID AC127 AC130 AC191 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACVW.1 CA10.1 CA10.5 CA10.8 CA110 CA210 CA240 FB100 FB101 FB121 FB141 FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 ... GCSSET6 RELATION KeyChange SL02.2 CHART-NAME 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 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 |