Address

In Scope

Technical: ADDRESS | ID: OR-SIOCS-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

Target Structure

Load Approach: Table
Target Objects: ADDRESS

Field Definitions(26)

Rules & Considerations(61)

Sample Load Data(4)

_scenario	IDRPK	TYPER	ENTITY_IDR	IS_PRIMARYR	ENTITY_TYPER	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
default	1	Address-001	1000000001	Address-001	Address-001	Address-001	Address-001	Address-001	2026-01-01	Address Primary	STD-ADDRESS-001	Address Primary	2026-01-01	Address-001	STD-ADDRESS-001	STD-ADDRESS-001	STD-ADDRESS-001	Address Primary	Address Primary	Address-001	Address-001	Address-001	Address-001	Address-001	Address Primary	Address Primary

default

IDRPK: 1
TYPER: Address-001
ENTITY_IDR: 1000000001
IS_PRIMARYR: Address-001
ENTITY_TYPER: Address-001
CITY: Address-001
STATE: Address-001
COUNTY: Address-001
END_DATE: 2026-01-01
LAST_NAME: Address Primary
COUNTRY_ID: STD-ADDRESS-001
FIRST_NAME: Address Primary
START_DATE: 2026-01-01
CONTACT_FAX: Address-001
EXTERNAL_ID: STD-ADDRESS-001
LOCATION_ID: STD-ADDRESS-001
POSTAL_CODE: STD-ADDRESS-001
COMPANY_NAME: Address Primary
CONTACT_NAME: Address Primary
CONTACT_EMAIL: Address-001
CONTACT_PHONE: Address-001
ADDRESS_LINE_1: Address-001
ADDRESS_LINE_2: Address-001
ADDRESS_LINE_3: Address-001
PHONETIC_LAST_NAME: Address Primary
PHONETIC_FIRST_NAME: Address Primary