Address

In Scope

Technical: ADDRESS | ID: OR-STO-ADDRESS-ADDRESS

this table will store different supplier addresses for a suppliers.

See how this object fits into Store Operations

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: ADDRESS

Field Definitions(5)

Rules & Considerations(30)

Sample Load Data(4)

_scenario	TYPER	ENTITY_IDR	IS_PRIMARYR	ENTITY_TYPER	ID	CITY	STATE	COUNTY	END_DATE	LAST_NAME	COUNTRY_ID	FIRST_NAME	START_DATE	CONTACT_FAX	EXTERNAL_ID	LOCATION_ID	POSTAL_CODE	COMPANY_NAME	CONTACT_NAME	CONTACT_EMAIL	CONTACT_PHONE	ADDRESS_LINE_1	ADDRESS_LINE_2	ADDRESS_LINE_3	PHONETIC_LAST_NAME	PHONETIC_FIRST_NAME
Example values from field definitions	SA	1	S	SAMP	1	SAMPLE	SAM	SAMPLE	2026-01-01	SAMPLE	SAM	SAMPLE	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE
default	Ad	1000000003	A	Addr	3	Address-002-ALT	Add	Address-002-ALT	2026-01-03	Address Secondary	ALT	Address Secondary	2026-01-03	Address-002-ALT	ALT-ADDRESS-002	ALT-ADDRESS-002	ALT-ADDRESS-002	Address Secondary	Address Secondary	Address-002-ALT	Address-002-ALT	Address-002-ALT	Address-002-ALT	Address-002-ALT	Address Secondary	Address Secondary
default	Ad	1000000005	A	Addr	5	Address-003-EDGE	Add	Address-003-EDGE	2026-01-05	Address Core	EDG	Address Core	2026-01-05	Address-003-EDGE	EDGE-ADDRESS-003	EDGE-ADDRESS-003	EDGE-ADDRESS-003	Address Core	Address Core	Address-003-EDGE	Address-003-EDGE	Address-003-EDGE	Address-003-EDGE	Address-003-EDGE	Address Core	Address Core

Example values from field definitions

TYPER: SA
ENTITY_IDR: 1
IS_PRIMARYR: S
ENTITY_TYPER: SAMP
ID: 1
CITY: SAMPLE
STATE: SAM
COUNTY: SAMPLE
END_DATE: 2026-01-01
LAST_NAME: SAMPLE
COUNTRY_ID: SAM
FIRST_NAME: SAMPLE
START_DATE: 2026-01-01
CONTACT_FAX: SAMPLE
EXTERNAL_ID: SAMPLE
LOCATION_ID: SAMPLE
POSTAL_CODE: SAMPLE
COMPANY_NAME: SAMPLE
CONTACT_NAME: SAMPLE
CONTACT_EMAIL: SAMPLE
CONTACT_PHONE: SAMPLE
ADDRESS_LINE_1: SAMPLE
ADDRESS_LINE_2: SAMPLE
ADDRESS_LINE_3: SAMPLE
PHONETIC_LAST_NAME: SAMPLE
PHONETIC_FIRST_NAME: SAMPLE

default

TYPER: Ad
ENTITY_IDR: 1000000003
IS_PRIMARYR: A
ENTITY_TYPER: Addr
ID: 3
CITY: Address-002-ALT
STATE: Add
COUNTY: Address-002-ALT
END_DATE: 2026-01-03
LAST_NAME: Address Secondary
COUNTRY_ID: ALT
FIRST_NAME: Address Secondary
START_DATE: 2026-01-03
CONTACT_FAX: Address-002-ALT
EXTERNAL_ID: ALT-ADDRESS-002
LOCATION_ID: ALT-ADDRESS-002
POSTAL_CODE: ALT-ADDRESS-002
COMPANY_NAME: Address Secondary
CONTACT_NAME: Address Secondary
CONTACT_EMAIL: Address-002-ALT
CONTACT_PHONE: Address-002-ALT
ADDRESS_LINE_1: Address-002-ALT
ADDRESS_LINE_2: Address-002-ALT
ADDRESS_LINE_3: Address-002-ALT
PHONETIC_LAST_NAME: Address Secondary
PHONETIC_FIRST_NAME: Address Secondary

default

TYPER: Ad
ENTITY_IDR: 1000000005
IS_PRIMARYR: A
ENTITY_TYPER: Addr
ID: 5
CITY: Address-003-EDGE
STATE: Add
COUNTY: Address-003-EDGE
END_DATE: 2026-01-05
LAST_NAME: Address Core
COUNTRY_ID: EDG
FIRST_NAME: Address Core
START_DATE: 2026-01-05
CONTACT_FAX: Address-003-EDGE
EXTERNAL_ID: EDGE-ADDRESS-003
LOCATION_ID: EDGE-ADDRESS-003
POSTAL_CODE: EDGE-ADDRESS-003
COMPANY_NAME: Address Core
CONTACT_NAME: Address Core
CONTACT_EMAIL: Address-003-EDGE
CONTACT_PHONE: Address-003-EDGE
ADDRESS_LINE_1: Address-003-EDGE
ADDRESS_LINE_2: Address-003-EDGE
ADDRESS_LINE_3: Address-003-EDGE
PHONETIC_LAST_NAME: Address Core
PHONETIC_FIRST_NAME: Address Core

Rule Validation Summary

Source Rule Count: 37
Governed Rule Count: 30