General Ledger Chart
The General Ledger Chart (GLCHART) file contains chart and system account information in the General Ledger system including retained earnings, undistributed retained earnings, error suspense, and gain/loss account records defined in the System Accounts subform.
REFERENCED BY
| GL00.1 | GL00.2 | GL00.7 | GL00.9 | GL160 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||
|---|---|---|---|---|---|---|---|---|
| GCH-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. |
|
||||||
| GCH-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The chart of accounts description. |
|
||||||
| GCH-SHORT-DESC Element: Short Description | Derived The chart short description. |
|
||||||
| GCH-RE-ACCOUNT Retained Earnings Account | Numeric 6 The retained earnings account number. At year end, the system uses this account to close all income statement accounts. |
|
||||||
| GCH-RE-SUB-ACCT Retained Earnings Subaccount | Numeric 4 The retained earnings subaccount. At year end, the system uses this account to close all income statement accounts. |
|
||||||
| GCH-URE-ACCOUNT Unretained Earnings Account | Numeric 6 The undistributed retained earnings account. The system stores the accumulated net income and loss in this account. |
|
||||||
| GCH-URE-SUB-ACCT Unretained Earnings Subaccount | Numeric 4 The undistributed retained earnings subaccount. The system stores the accumulated net income and loss in this account. |
|
||||||
| GCH-ES-ACCOUNT Error Suspense Account | Numeric 6 The error suspense account. The system uses the error suspense account to post any differences from subsystems, or any instances of inactive or invalid accounts and accounting units. This account makes sure that the general ledger always stays in balance. |
|
||||||
| GCH-ES-SUB-ACCT Error Suspense Subaccount | Numeric 4 The error suspense subaccount. The system uses the error suspense account to post any differences from subsystems, or any instances of inactive or invalid accounts and accounting units. This account makes sure that the general ledger stays in balance. |
|
||||||
| GCH-GAIN-ACCT Element: Gain Account | Numeric 6 This is the gain account from your General Ledger Chart of Accounts. The translation gain account stores a favorable variance if one exists during the currency translation process. |
|
||||||
| GCH-GAIN-SUB-ACCT Element: Gain Subaccount | Numeric 4 This is the gain subaccount from your general ledger chart of accounts. |
|
||||||
| GCH-LOSS-ACCT Element: Loss Account | Numeric 6 This is the loss account from your general ledger chart of accounts. The translation loss account stores an unfavorable variance if one exists during the currency translation process. |
|
||||||
| GCH-LOSS-SUB-ACCT Element: Loss Subaccount | Numeric 4 This is the loss subaccount from your general ledger chart of accounts. |
|
||||||
| GCH-RND-ACCOUNT Element: Rounding Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||||||
| GCH-RND-SUB-ACCT Element: Rounding Subaccount | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||
| GCH-LAST-SEQ-NBR Element: Last Sequence Number | Numeric 6 The last sequence number assigned. |
|
||||||
| GCH-LAST-ACCT-ID Element: Last Account ID | Numeric 6 The summary account ID. |
|
||||||
| GCH-BAL-ACCOUNT Element: Balance Account | Numeric 6 The account used to post journal autobalancing entries in company base currency if the company selected autobalancing. |
|
||||||
| GCH-BAL-SUB-ACCT Element: Balance Subaccount | Numeric 4 The subaccount used to post journal autobalancing entries. |
|
||||||
| GCH-BAL-DESC Element: Balance Description | Alpha 60 The name of the autobalancing account. |
|
||||||
| GCH-SEGMENT-GROUP Element: Segment Group | Alpha 15 A user analysis group is a combination of up to four user analysis for reports and analysis. |
|
||||||
| GCH-COMT-ACCOUNT Element: Commitment Account | Numeric 6 The Accrued Commitment Account is the account the system will use to post the total commitments for the period or year. |
|
||||||
| GCH-COMT-SUB-ACCT Commitment Subaccount | Numeric 4 The Accrued Commitment Subaccount is the subaccount the system will use to post the total commitments for the period or year. |
|
||||||
| GCH-CREATED-BY Element: Operator | Alpha 10 |
|
||||||
| GCH-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||
| GCH-LAST-UPDT-TIME Element: Time | Numeric 8 |
|
||||||
| GCH-LAST-UPDATE-BY Element: Operator | Alpha 10 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GCHSET1 |
CHART-NAME |
|
|||||||||
| GCHSET2 |
SEGMENT-GROUP CHART-NAME |
|
| ||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bal Account | GLCHARTDTL |
Not Required
| |||||||||
| Comt Account | GLCHARTDTL |
Not Required
| |||||||||
| Es Account | GLCHARTDTL |
Not Required
| |||||||||
| Gain Account | GLCHARTDTL |
Not Required
| |||||||||
| Glchartbod | GLCHARTBOD |
Not Required, Delete Cascades
| |||||||||
| Loss Account | GLCHARTDTL |
Not Required
| |||||||||
| Re Account | GLCHARTDTL |
Not Required
| |||||||||
| Rnd Account | GLCHARTDTL |
Not Required
| |||||||||
| Slgrouphdr | SLGROUPHDR |
Required
| |||||||||
| Slrelathdr | SLRELATHDR |
Required
| |||||||||
| Ure Account | GLCHARTDTL |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | GLSYSTEM |
Delete Restricted
| |||||||||
| Detail Accts | GLCHARTDTL |
Delete Cascades
| |||||||||
| Glesacct | GLESACCT |
Delete Cascades
| |||||||||
| Reports | RWREQUEST |
| |||||||||
| Summary Accts | GLCHARTSUM |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.