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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
LEVEL_ONE		Numeric 15Accounting unit level one where accounting information is transferred.GL61.1, GL63.1, GL63.2
#GNI-LEVEL-TWO SET2
LEVEL_TWO		Numeric 15Accounting unit level two where accounting information is transferred to.GL61.1, GL63.1, GL63.2
#GNI-LEVEL-THREE SET2
LEVEL_THREE		Numeric 15Accounting unit level three where accounting information is transferred to.GL61.1, GL63.1
#GNI-LEVEL-FOUR SET2
LEVEL_FOUR		Numeric 15Accounting unit level four where accounting information is transferred to.GL61.1, GL63.1
#GNI-LEVEL-FIVE SET2
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GNISET1
  1. COMPANY
  2. ACCT-UNIT
PrimaryGL161, GL261, GL61.1, GL63.1, GL63.2
GNISET2
  1. COMPANY
  2. LEVEL-ONE
  3. LEVEL-TWO
  4. LEVEL-THREE
  5. LEVEL-FOUR
  6. LEVEL-FIVE
  7. ACCT-UNIT
KeyChangeGL161, GL261, GL61.1, GL63.1, GL63.2, GL63.3

Programs

Updated by (4)

Referenced by (1)