GLICHART – General Ledger Interface Chart
- System
- General Ledger Setup (IF)
- Prefix
GCI- Primary key
CHART-NAME,SEQ-NUMBER- Fields
- 27
- Updated by
- 2 programs
- Referenced by
- 1 program
GLICHART is the General Ledger Interface Chart table in Lawson General Ledger Setup (prefix GCI). It is indexed by CHART-NAME, SEQ-NUMBER (GCISET1); alternate indexes: GCISET2. It is updated by GL160 and GL60.1 and referenced by GL260. The table has 27 fields, 2 indexes and 0 documented relations.
About GLICHART
The General Ledger Chart Interface file contains the information needed to create chart, summary, and detail records in the Lawson General Ledger system when converting from a non-Lawson system defined in GL60.1 (Chart Interface Maintenance).
Fields (27)
Column = COBOL field name without the GCI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GCI-CHART-NAME PKCHART_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. | GL160, GL60.1 |
GCI-SEQ-NUMBER PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | GL160, GL60.1 |
GCI-CHART-SECTIONCHART_SECTION | Alpha 1 | The chart section where accounts are placed. Valid values are Balance Sheet or Income Statement. | GL160, GL60.1 |
GCI-SUM-DET-ACCTSUM_DET_ACCT | Alpha 12 | The number that identifies the account. | GL160, GL60.1 |
GCI-RECORD-TYPERECORD_TYPE | Alpha 1 | This field identifies the type of record defined. Valid values are:
| GL160, GL60.1 |
GCI-DEPTHDEPTH | Numeric 2 | The account depth that determines the order of account totaling. For example, each account assigned a depth of 2 totals to the previous account assigned a depth of 1. Valid values are 1 through 9. | GL160, GL60.1 |
GCI-ACCOUNT-DESCACCOUNT_DESC | Alpha 60 (Lower Case) | The account description. | GL160, GL60.1 |
GCI-SIGN-CODESIGN_CODE | Alpha 1 | Indicates if a negative sign can be used next to a positive amount. | GL160, GL60.1 |
GCI-SPACE-CODESPACE_CODE | Numeric 1 | Indicates the number of spaces you want to advance after the account appears on a report. | GL160, GL60.1 |
GCI-UNITS-CODEUNITS_CODE | Alpha 1 | Indicated whether units are allowed for the account. | GL160, GL60.1 |
GCI-ACTIVITY-REQACTIVITY_REQ | Alpha 1 | Indicates if an Activity Code is required. | GL160, GL60.1 |
GCI-ACTIVE-STATUSACTIVE_STATUS | Alpha 1 | The status of the account. If Inactive, no posting can be done to the account. | GL160, GL60.1 |
GCI-ACCT-CATEGORYACCT_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 | GL160, GL60.1 |
GCI-DAILY-BALANCEDAILY_BALANCE | Alpha 1 | — | GL160, GL60.1 |
GCI-DYNAMIC-LISTDYNAMIC_LIST | Alpha 12 | Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing objects. | GL160, GL60.1 |
GCI-POSTING-LEVELPOSTING_LEVEL | Alpha 1 | The posting level identifies where transactions are summarized for posting during conversion. You can select Summary or Detail. | GL160, GL60.1 |
GCI-SUB-ACCT-TMPLTSUB_ACCT_TMPLT | Alpha 12 | — | GL160, GL60.1 |
GCI-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | GL160, GL60.1 |
GCI-UNARY-OPERUNARY_OPER | 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. | GL160, GL60.1 |
GCI-NAT-BALANCENAT_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. | GL60.1 |
GCI-CURR-CONTROLCURR_CONTROL | Alpha 1 | This field determines whether transactions that have a different account currency are allowed. If Yes, only transactions with the same account currency code are allowed. | GL60.1 |
GCI-REVALUEREVALUE | Alpha 1 | This field indicates whether to revalue account balances to account for currency rate changes. | GL60.1 |
GCI-SL-ACCT-FLAGSL_ACCT_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. " " = Sum Acct Default
| GL60.1 |
GCI-LEDGER-GROUPLEDGER_GROUP | Alpha 15 | This is the Multi-Book Ledger Group. The ledger is established in Ledger Setup (ML10). This field indicates that the ledgers within the group are valid for the account. | GL60.1 |
GCI-GL-BUD-FLGL_BUD_FL | Alpha 1 | — | GL60.1 |
GCI-GL-ACCT-TYPEGL_ACCT_TYPE | Numeric 2 | —
| GL60.1 |
GCI-XBRL-TAG-IDXBRL_TAG_ID | Alpha 60 | — | GL60.1 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GCISET1 | CHART-NAME, SEQ-NUMBER | Primary | GL160, GL260, GL60.1 | |
GCISET2 | SUM-DET-ACCT, CHART-NAME, SEQ-NUMBER | KeyChange | GL160, GL60.1 |
Programs
Updated by (2)
Referenced by (1)
- GL260 Chart Interface Listing