GLADDRESS – General Ledger Company Address

System
General Ledger Setup (IF)
Prefix
GAD
Primary key
COMPANY, ACCT-UNIT
Fields
16
Updated by
5 programs
Referenced by
1195 programs

GLADDRESS is the General Ledger Company Address table in Lawson General Ledger Setup (prefix GAD). It is indexed by COMPANY, ACCT-UNIT (GADSET1); alternate indexes: GADSET3. It is related 1:1 to ADDRDATA, GLNAMES and GLSYSTEM. It is updated by GL10.1, GL110, GL124, GL125 and GL20.1 and referenced by AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 and 1187 more. The table has 16 fields, 2 indexes and 3 documented relations.

About GLADDRESS

This file contains the name, address, and communication numbers for the company and needed accounting units defined on the Address form tab in GL10.1 (Company).

Fields (16)

Column = COBOL field name without the GAD- 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
#GAD-COMPANY PK
COMPANY		Numeric 4The company number as defined in GL00.1 (Company).GL10.1, GL110, GL124, GL125, GL20.1
#GAD-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The valid Lawson General Ledger accounting in GLNAMES.GL124, GL125, GL20.1
#GAD-ADDR-CONTACT
ADDR_CONTACT		Alpha 30 (Lower Case)This is the name of the main contact.GL10.1, GL124, GL125, GL20.1
#GAD-PHONE-COUNTRY
PHONE_COUNTRY		Alpha 6This field contains the prefix of the telephone number. For example, the country or city code.GL10.1, GL124, GL125, GL20.1
#GAD-PHONE-NUMBER
PHONE_NUMBER		Alpha 15Contains the telephone number, including area code.GL10.1, GL124, GL125, GL20.1
#GAD-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.GL10.1, GL124, GL125, GL20.1
#GAD-FAX-COUNTRY
FAX_COUNTRY		Alpha 6This field contains the prefix of the telephone number. For example, the country or city code.GL10.1, GL124, GL125, GL20.1
#GAD-FAX-NUMBER
FAX_NUMBER		Alpha 15Phone number.GL10.1, GL124, GL125, GL20.1
#GAD-FAX-EXT
FAX_EXT		Alpha 5This field contains the telephone extension number.GL10.1, GL124, GL125, GL20.1
#GAD-TELEX-NUMBER
TELEX_NUMBER		Alpha 15Phone number.GL10.1, GL124, GL20.1
#GAD-OPT-FIELD1
OPT_FIELD1		Alpha 15 (Lower Case)This field lets you enter any additional information you would like to appear on the address.GL10.1, GL124, GL125, GL20.1
#GAD-OPT-FIELD2
OPT_FIELD2		Alpha 15 (Lower Case)This field lets you enter any additional information you would like to appear on the address.GL10.1, GL124, GL125, GL20.1
#GAD-OPT-FIELD3
OPT_FIELD3		Alpha 30 (Lower Case)—GL10.1, GL124, GL125, GL20.1
#GAD-ADDR-CODE SET3
ADDR_CODE		Alpha 20This is a code representing the address for the institution or the institution location. The address is stored in the ADDRDATA file.GL10.1, GL124, GL125, GL20.1
#GAD-ADDR-EMAIL
ADDR_EMAIL		Alpha 30 (Lower Case)—GL10.1
#GAD-REG-NBR
REG_NBR		Numeric 10—GL10.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
GADSET1
  1. COMPANY
  2. ACCT-UNIT
PrimaryAC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)
GADSET3
  1. ADDR-CODE
  2. COMPANY
  3. ACCT-UNIT
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ADDRDATAGLNAMESGLSYSTEMGLADDRESS

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AddrdataADDRDATANot Required
GAD-ADDR-CODE→GDD-ADDR-CODE (GDDSET1)
GlnamesGLNAMESRequiredWhen GAD-ACCT-UNIT != Spaces
GAD-COMPANY→GLN-COMPANY
GAD-ACCT-UNIT→GLN-ACCT-UNIT
GlsystemGLSYSTEMRequired
GAD-COMPANY→GLS-COMPANY

Programs

Updated by (5)

Referenced by (1195)