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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GADSET1COMPANY, ACCT-UNITPrimaryAC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)
GADSET3ADDR-CODE, COMPANY, ACCT-UNITKeyChange—

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AddrdataADDRDATANot RequiredGAD-ADDR-CODE → GDD-ADDR-CODE (GDDSET1)
GlnamesGLNAMESRequiredWhen GAD-ACCT-UNIT != SpacesGAD-COMPANY → GLN-COMPANY, GAD-ACCT-UNIT → GLN-ACCT-UNIT
GlsystemGLSYSTEMRequiredGAD-COMPANY → GLS-COMPANY

Programs

Updated by (5)

Referenced by (1195)