ADDRDATA – Address Code

System
General Ledger Setup (IF)
Prefix
GDD
Primary key
ADDR-CODE
Fields
14
Updated by
1203 programs
Referenced by
7 programs

ADDRDATA is the Address Code table in Lawson General Ledger Setup (prefix GDD). It is indexed by ADDR-CODE (GDDSET1); alternate indexes: GDDSET2, GDDSET3, GDDSET4, GDDSET5, GDDSET6 and GDDSET7. It is related 1:M to GLADDRESS. It is updated by AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 and 1195 more and referenced by AR550, GL210, GL223, GLBL.1, PD230, PO253 and RW80.1. The table has 14 fields, 7 indexes and 1 documented relation.

About ADDRDATA

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the GDD- 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
#GDD-ADDR-CODE PK
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.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-COUNTRY-CODE SET7
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-NAME SET2 SET4 SET5 SET6 SET7
NAME		Alpha 30 (Lower Case)Displays the company description.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-ADDR1 SET3
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-ADDR5 SET4
ADDR5		Alpha 18 (Lower Case)This field contains the city of the address.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-STATE-PROV SET6
STATE_PROV		Alpha 2This field contains the two-character state code of the address.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-POSTAL-CODE SET5
POSTAL_CODE		Alpha 10 (Lower Case)This field contains the postal code.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-POSTAL-DIST
POSTAL_DIST		Alpha 5—AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-COUNTY
COUNTY		Alpha 25 (Lower Case)The county for the company address.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-COUNTRY
COUNTRY		Alpha 30 (Lower Case)This field contains the country of the address, or it can be used for additional information such as an attention name.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)
#GDD-USAGE-COUNT
USAGE_COUNT		Numeric 12—AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)

Indexes (7)

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
GDDSET1
  1. ADDR-CODE
PrimaryAC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)
GDDSET2
  1. NAME
  2. ADDR-CODE
—
GDDSET3
  1. ADDR1
  2. ADDR-CODE
—
GDDSET4
  1. ADDR5
  2. NAME
  3. ADDR-CODE
—
GDDSET5
  1. POSTAL-CODE
  2. NAME
  3. ADDR-CODE
—
GDDSET6
  1. STATE-PROV
  2. NAME
  3. ADDR-CODE
—
GDDSET7
  1. COUNTRY-CODE
  2. NAME
  3. ADDR-CODE
AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
GladdressGLADDRESS
GDD-ADDR-CODE→GAD-ADDR-CODE
—→GAD-COMPANY
—→GAD-ACCT-UNIT

Programs

Updated by (1203)

Referenced by (7)