Addr

In Scope

Technical: ADDR | ID: OR-MFCS-ADDR

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

Target Structure

Load Approach: Table
Target Objects: ADDR

Field Definitions(36)

Rules & Considerations(97)

Sample Load Data(4)

_scenario	CITYR	ADD_1R	MODULER	SEQ_NOR	ADDR_KEYRPK	ADDR_TYPERPK	CREATE_IDR	COUNTRY_IDRPK	KEY_VALUE_1R	PUBLISH_INDR	LAST_UPDATE_IDR	CREATE_DATETIMER	PRIMARY_ADDR_INDR	LAST_UPDATE_DATETIMER	POST	ADD_2	ADD_3	ADD_4	STATE	COUNTY	PHONE2	PHONE3	LATITUDE	LONGITUDE	CONTACT_FAX	KEY_VALUE_2	PHONE2_TYPE	PHONE3_TYPE	CONTACT_NAME	EDI_ADDR_CHG	CONTACT_EMAIL	CONTACT_PHONE	CONTACT_TELEX	EXTERNAL_REF_ID	JURISDICTION_CODE	ORACLE_VENDOR_SITE_ID
default	Addr-001	Addr-001	SUPP	0002	1	01	USERENV	STD-ADDR-001	Addr-001	N	RETAIL_CTX	2026-01-01	Addr-001	2026-01-01	Addr-001	Addr-001	Addr-001	Addr-001	Addr-001	Addr-001	Addr-001	Addr-001	11.0000	11.0000	Addr-001	Addr-001	Addr-001	Addr-001	Addr Primary	Addr-001	Addr-001	Addr-001	Addr-001	STD-ADDR-001	STD-ADDR-001	1000000001

default

CITYR: Addr-001
ADD_1R: Addr-001
MODULER: SUPP
SEQ_NOR: 0002
ADDR_KEYRPK: 1
ADDR_TYPERPK: 01
CREATE_IDR: USERENV
COUNTRY_IDRPK: STD-ADDR-001
KEY_VALUE_1R: Addr-001
PUBLISH_INDR: N
LAST_UPDATE_IDR: RETAIL_CTX
CREATE_DATETIMER: 2026-01-01
PRIMARY_ADDR_INDR: Addr-001
LAST_UPDATE_DATETIMER: 2026-01-01
POST: Addr-001
ADD_2: Addr-001
ADD_3: Addr-001
ADD_4: Addr-001
STATE: Addr-001
COUNTY: Addr-001
PHONE2: Addr-001
PHONE3: Addr-001
LATITUDE: 11.0000
LONGITUDE: 11.0000
CONTACT_FAX: Addr-001
KEY_VALUE_2: Addr-001
PHONE2_TYPE: Addr-001
PHONE3_TYPE: Addr-001
CONTACT_NAME: Addr Primary
EDI_ADDR_CHG: Addr-001
CONTACT_EMAIL: Addr-001
CONTACT_PHONE: Addr-001
CONTACT_TELEX: Addr-001
EXTERNAL_REF_ID: STD-ADDR-001
JURISDICTION_CODE: STD-ADDR-001
ORACLE_VENDOR_SITE_ID: 1000000001

All objects