DC Store Address

In Scope

Technical: DC_STORE_ADDR | ID: OR-FND-DC_STORE_ADDR-DC_STORE_ADDRESS

This table is a staging table for data conversion and will hold the store address information.

See how this object fits into Foundation Data

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

Field Definitions(5)

Rules & Considerations(17)

Sample Load Data(4)

_scenario	CITY	POST	ADD_1	ADD_2	ADD_3	STATE	COUNTY	ADDR_TYPE	COUNTRY_ID	CONTACT_FAX	KEY_VALUE_1	CONTACT_NAME	CONTACT_EMAIL	CONTACT_PHONE	CONTACT_TELEX	PRIMARY_ADDR_IND	JURISDICTION_CODE
Example values from field definitions	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE	SA	SAM	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE
default	Dc Store Addr-002-ALT	Dc Store Addr-002-ALT	Dc Store Addr-002-ALT	Dc Store Addr-002-ALT	Dc Store Addr-002-ALT	Dc	Dc Store Addr-002-ALT	Dc	ALT	Dc Store Addr-002-AL	Dc Store Addr-002-AL	Dc Store Addr Secondary	Dc Store Addr-002-ALT	Dc Store Addr-002-AL	Dc Store Addr-002-AL	D	ALT-DC_STO
default	Dc Store Addr-003-EDGE	Dc Store Addr-003-EDGE	Dc Store Addr-003-EDGE	Dc Store Addr-003-EDGE	Dc Store Addr-003-EDGE	Dc	Dc Store Addr-003-EDGE	Dc	EDG	Dc Store Addr-003-ED	Dc Store Addr-003-ED	Dc Store Addr Core	Dc Store Addr-003-EDGE	Dc Store Addr-003-ED	Dc Store Addr-003-ED	D	EDGE-DC_ST

Example values from field definitions

CITY: SAMPLE
POST: SAMPLE
ADD_1: SAMPLE
ADD_2: SAMPLE
ADD_3: SAMPLE
STATE: SAM
COUNTY: SAMPLE
ADDR_TYPE: SA
COUNTRY_ID: SAM
CONTACT_FAX: SAMPLE
KEY_VALUE_1: SAMPLE
CONTACT_NAME: SAMPLE
CONTACT_EMAIL: SAMPLE
CONTACT_PHONE: SAMPLE
CONTACT_TELEX: SAMPLE
PRIMARY_ADDR_IND: S
JURISDICTION_CODE: SAMPLE

default

CITY: Dc Store Addr-002-ALT
POST: Dc Store Addr-002-ALT
ADD_1: Dc Store Addr-002-ALT
ADD_2: Dc Store Addr-002-ALT
ADD_3: Dc Store Addr-002-ALT
STATE: Dc
COUNTY: Dc Store Addr-002-ALT
ADDR_TYPE: Dc
COUNTRY_ID: ALT
CONTACT_FAX: Dc Store Addr-002-AL
KEY_VALUE_1: Dc Store Addr-002-AL
CONTACT_NAME: Dc Store Addr Secondary
CONTACT_EMAIL: Dc Store Addr-002-ALT
CONTACT_PHONE: Dc Store Addr-002-AL
CONTACT_TELEX: Dc Store Addr-002-AL
PRIMARY_ADDR_IND: D
JURISDICTION_CODE: ALT-DC_STO

default

CITY: Dc Store Addr-003-EDGE
POST: Dc Store Addr-003-EDGE
ADD_1: Dc Store Addr-003-EDGE
ADD_2: Dc Store Addr-003-EDGE
ADD_3: Dc Store Addr-003-EDGE
STATE: Dc
COUNTY: Dc Store Addr-003-EDGE
ADDR_TYPE: Dc
COUNTRY_ID: EDG
CONTACT_FAX: Dc Store Addr-003-ED
KEY_VALUE_1: Dc Store Addr-003-ED
CONTACT_NAME: Dc Store Addr Core
CONTACT_EMAIL: Dc Store Addr-003-EDGE
CONTACT_PHONE: Dc Store Addr-003-ED
CONTACT_TELEX: Dc Store Addr-003-ED
PRIMARY_ADDR_IND: D
JURISDICTION_CODE: EDGE-DC_ST

Rule Validation Summary

Source Rule Count: 20
Governed Rule Count: 17