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.

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
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
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
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
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
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
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 5AC03.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 12AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +52 more (list truncated in source)

Indexes (7)

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

IndexKeysFlagsConditionUsed in
GDDSET1ADDR-CODEPrimaryAC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)
GDDSET2NAME, ADDR-CODE
GDDSET3ADDR1, ADDR-CODE
GDDSET4ADDR5, NAME, ADDR-CODE
GDDSET5POSTAL-CODE, NAME, ADDR-CODE
GDDSET6STATE-PROV, NAME, ADDR-CODE
GDDSET7COUNTRY-CODE, NAME, ADDR-CODEAC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
GladdressGLADDRESSGDD-ADDR-CODEGAD-ADDR-CODE, GAD-COMPANY, GAD-ACCT-UNIT

Programs

Updated by (1203)

Referenced by (7)