GLINAMES – General Ledger Interface Names

System
General Ledger Setup (IF)
Prefix
GNI
Primary key
COMPANY, ACCT-UNIT
Fields
14
Updated by
4 programs
Referenced by
1 program

GLINAMES is the General Ledger Interface Names table in Lawson General Ledger Setup (prefix GNI). It is indexed by COMPANY, ACCT-UNIT (GNISET1); alternate indexes: GNISET2. It is updated by GL161, GL61.1, GL63.1 and GL63.2 and referenced by GL261. The table has 14 fields, 2 indexes and 0 documented relations.

About GLINAMES

The General Ledger Interface Names file contains accounting unit information defined in GL61.1 (Acct Unit Interface Maint) when you are converting from a non-Lawson system to the Lawson General Ledger system.

Fields (14)

Column = COBOL field name without the GNI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GNI-COMPANY PK
COMPANY
Numeric 4The company number as defined in GL10.1 (Company).GL61.1, GL63.1, GL63.2
GNI-ACCT-UNIT PK
ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.GL61.1, GL63.1, GL63.2
GNI-LEVEL-ONE
LEVEL_ONE
Numeric 15Accounting unit level one where accounting information is transferred.GL61.1, GL63.1, GL63.2
GNI-LEVEL-TWO
LEVEL_TWO
Numeric 15Accounting unit level two where accounting information is transferred to.GL61.1, GL63.1, GL63.2
GNI-LEVEL-THREE
LEVEL_THREE
Numeric 15Accounting unit level three where accounting information is transferred to.GL61.1, GL63.1
GNI-LEVEL-FOUR
LEVEL_FOUR
Numeric 15Accounting unit level four where accounting information is transferred to.GL61.1, GL63.1
GNI-LEVEL-FIVE
LEVEL_FIVE
Numeric 15Accounting unit level five where accounting information is transferred to.GL61.1, GL63.1
GNI-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the level description.GL61.1, GL63.1, GL63.2
GNI-CHART-SECTION
CHART_SECTION
Alpha 1The chart section available to the accounting unit. Valid values are Balance Sheet or Income Statement.GL61.1, GL63.1, GL63.2
GNI-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company's base currency code as defined in CU01.1 (Currency Code).GL61.1, GL63.1
GNI-PERSON-RESP
PERSON_RESP
Alpha 15 (Lower Case)This is the name of the person responsible for this record.GL61.1, GL63.1, GL63.2
GNI-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the account. If Inactive, no posting can be done to the accounting unit.GL61.1, GL63.1
GNI-POSTING-FLAG
POSTING_FLAG
Alpha 1Indicates if posting is allowed for this account.GL61.1, GL63.1, GL63.2
GNI-EFFECTIVE-DATE
EFFECTIVE_DATE
Numeric 8 (yyyymmdd)The posting effective date.GL61.1, GL63.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GNISET1COMPANY, ACCT-UNITPrimaryGL161, GL261, GL61.1, GL63.1, GL63.2
GNISET2COMPANY, LEVEL-ONE, LEVEL-TWO, LEVEL-THREE, LEVEL-FOUR, LEVEL-FIVE, ACCT-UNITKeyChangeGL161, GL261, GL61.1, GL63.1, GL63.2, GL63.3

Programs

Updated by (4)

Referenced by (1)