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
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. |
|
||||||
GCS-CHART-SECTION Element: Chart Section | Alpha 1 The chart section. 1 = Balance Sheet 2 = Income Statement |
|
||||||
GCS-SEQ-NUMBER Element: Sequence Number | Numeric 6 A unique number assigned to the summary account. |
|
||||||
GCS-SUMMARY-ACCT Element: Summary Account | Alpha 12 The summary account. |
|
||||||
GCS-ACCOUNT-DESC Element: Account Description | Alpha 60 (Lower Case) The account description. |
|
||||||
GCS-TOTAL-DESC Element: Total Description | Alpha 60 (Lower Case) The description that appears next to the transaction total. |
|
||||||
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 |
|
||||||
GCS-SUMRY-ACCT-ID Element: Summary Account ID | Numeric 6 The summary account. |
|
||||||
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 |
|
||||||
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 |
|
||||||
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 |
|
||||||
GCS-UNDERLINE-B4 Element: Underline Before | Alpha 1 The underline appearing before the total. S = Single D = Double N = None |
|
||||||
GCS-UNDERLINE-AFT Element: Underline After | Alpha 1 The underline appearing after the total. S = Single D = Double N = None |
|
||||||
GCS-PRINT-HEADING Element: Print Heading | Alpha 1 Indicates if the heading is printed for financial statements. Y = Yes N = No |
|
||||||
GCS-PARENT-OBJ-ID Element: Parent Object ID | Numeric 12 The ID of the parent object. |
|
||||||
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. |
|
||||||
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 |
|
||||||
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 |
|
||||||
GCS-DAILY-BALANCE Element: Daily Balance | Alpha 1 Y = Yes N = No " " |
|
||||||
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). |
|
||||||
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 |
|
||||||
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 |
|
||||||
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. |
|
||||||
GCS-OBJ-ID Element: Object Id | Numeric 12 This is the unique object identifier. |
|
||||||
GCS-LEDGER-GROUP Element: Ledger Group | Alpha 15 |
|
||||||
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 |
|
||||||
GCS-GL-ACCT-TYPE Element: Gl Acct Type | Numeric 2 01 = Asset 02 = Liability 03 = Equity 04 = Revenue 05 = Expense 06 = Statistical |
|
||||||
GCS-XBRL-TAG-ID Element: Xbrl Tag Id | Alpha 60 |
|
||||||
GCS-CREATED-BY Element: Operator | Alpha 10 |
|
||||||
GCS-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||
GCS-LAST-UPDT-TIME Element: Time | Numeric 8 |
|
||||||
GCS-LAST-UPDATE-BY Element: Operator | Alpha 10 |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Chart Of Accts | GLCHART |
Required
| |||||||||
Glchsumbod | GLCHSUMBOD |
Not Required, Delete Cascades
| |||||||||
Mxlisthdr | MXLISTHDR |
Not Required
| |||||||||
Parent | GLCHARTSUM |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Children | GLCHARTSUM |
| ||||||||||||||||||||||||
Detail Accts | GLCHARTDTL |
Delete Restricted
| ||||||||||||||||||||||||
Glacctvld Sys | GLACCTVLD |
| ||||||||||||||||||||||||
Mxlistmbr | MXLISTMBR |
|
All trademarks and registered trademarks are the property of their
respective owners.