Address

In Scope

Technical: ADDR | ID: OR-SUP-ADDR-ADDRESS

The ADDR table stores the address of the store, ware house, supplier, and partner. Seq_no is required as multiple addresses can exist for each address type.

See how this object fits into Supplier Management

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ADDR

Field Definitions(5)

Rules & Considerations(54)

validation

constraint

Sample Load Data(4)

_scenario	MODULER	SEQ_NOR	ADDR_KEYRPK	KEY_VALUE_1R	CITY	POST	ADD_1	ADD_2	ADD_3	ADD_4	STATE	COUNTY	PHONE2	PHONE3	LATITUDE	ADDR_TYPE	CREATE_ID	LONGITUDE	COUNTRY_ID	CONTACT_FAX	KEY_VALUE_2	PHONE2_TYPE	PHONE3_TYPE	PUBLISH_IND	CONTACT_NAME	EDI_ADDR_CHG	CONTACT_EMAIL	CONTACT_PHONE	CONTACT_TELEX	LAST_UPDATE_ID	CREATE_DATETIME	EXTERNAL_REF_ID	PRIMARY_ADDR_IND	JURISDICTION_CODE	LAST_UPDATE_DATETIME	ORACLE_VENDOR_SITE_ID
Example values from field definitions	SAMP	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE	SAMPLE	SAMPLE	1.000000	SA	SAMPLE	1.000000	SAM	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAMPLE	S	SAMPLE	2026-01-01	1
default	PTNR	4	3	Addr-002-ALT	Addr-002-ALT	Addr-002-ALT	Addr-002-ALT	Addr-002-ALT	Addr-002-ALT	Addr-002-ALT	Add	Addr-002-ALT	Addr-002-ALT	Addr-002-ALT	12.500000	02	C LIENT_INFO	12.500000	ALT	Addr-002-ALT	Addr-002-ALT	Addr-0	Addr-0	N	Addr Secondary	A	Addr-002-ALT	Addr-002-ALT	Addr-002-ALT	APP_USER_ID	2026-01-03	ALT-ADDR-002	A	ALT-ADDR-0	2026-01-03	1000000003
default	SUPP	6	5	Addr-003-EDGE	Addr-003-EDGE	Addr-003-EDGE	Addr-003-EDGE	Addr-003-EDGE	Addr-003-EDGE	Addr-003-EDGE	Add	Addr-003-EDGE	Addr-003-EDGE	Addr-003-EDGE	14.000000	03	USE RENV	14.000000	EDG	Addr-003-EDGE	Addr-003-EDGE	Addr-0	Addr-0	N	Addr Core	A	Addr-003-EDGE	Addr-003-EDGE	Addr-003-EDGE	USERENV	2026-01-05	EDGE-ADDR-003	A	EDGE-ADDR-	2026-01-05	1000000005

Example values from field definitions

MODULER: SAMP
SEQ_NOR: 1
ADDR_KEYRPK: 1
KEY_VALUE_1R: SAMPLE
CITY: SAMPLE
POST: SAMPLE
ADD_1: SAMPLE
ADD_2: SAMPLE
ADD_3: SAMPLE
ADD_4: SAMPLE
STATE: SAM
COUNTY: SAMPLE
PHONE2: SAMPLE
PHONE3: SAMPLE
LATITUDE: 1.000000
ADDR_TYPE: SA
CREATE_ID: SAMPLE
LONGITUDE: 1.000000
COUNTRY_ID: SAM
CONTACT_FAX: SAMPLE
KEY_VALUE_2: SAMPLE
PHONE2_TYPE: SAMPLE
PHONE3_TYPE: SAMPLE
PUBLISH_IND: S
CONTACT_NAME: SAMPLE
EDI_ADDR_CHG: S
CONTACT_EMAIL: SAMPLE
CONTACT_PHONE: SAMPLE
CONTACT_TELEX: SAMPLE
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
EXTERNAL_REF_ID: SAMPLE
PRIMARY_ADDR_IND: S
JURISDICTION_CODE: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
ORACLE_VENDOR_SITE_ID: 1

default

MODULER: PTNR
SEQ_NOR: 4
ADDR_KEYRPK: 3
KEY_VALUE_1R: Addr-002-ALT
CITY: Addr-002-ALT
POST: Addr-002-ALT
ADD_1: Addr-002-ALT
ADD_2: Addr-002-ALT
ADD_3: Addr-002-ALT
ADD_4: Addr-002-ALT
STATE: Add
COUNTY: Addr-002-ALT
PHONE2: Addr-002-ALT
PHONE3: Addr-002-ALT
LATITUDE: 12.500000
ADDR_TYPE: 02
CREATE_ID: C LIENT_INFO
LONGITUDE: 12.500000
COUNTRY_ID: ALT
CONTACT_FAX: Addr-002-ALT
KEY_VALUE_2: Addr-002-ALT
PHONE2_TYPE: Addr-0
PHONE3_TYPE: Addr-0
PUBLISH_IND: N
CONTACT_NAME: Addr Secondary
EDI_ADDR_CHG: A
CONTACT_EMAIL: Addr-002-ALT
CONTACT_PHONE: Addr-002-ALT
CONTACT_TELEX: Addr-002-ALT
LAST_UPDATE_ID: APP_USER_ID
CREATE_DATETIME: 2026-01-03
EXTERNAL_REF_ID: ALT-ADDR-002
PRIMARY_ADDR_IND: A
JURISDICTION_CODE: ALT-ADDR-0
LAST_UPDATE_DATETIME: 2026-01-03
ORACLE_VENDOR_SITE_ID: 1000000003