Dc Warehouse Address

In Scope

Technical: DC_WH_ADDR | ID: OR-FND-DC_WH_ADDR-DC_WAREHOUSE_ADDRESS

This table is a staging table for data conversion and will hold the warehouse 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_WH_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 Wh Addr-002-ALT	Dc Wh Addr-002-ALT	Dc Wh Addr-002-ALT	Dc Wh Addr-002-ALT	Dc Wh Addr-002-ALT	Dc	Dc Wh Addr-002-ALT	Dc	ALT	Dc Wh Addr-002-ALT	Dc Wh Addr-002-ALT	Dc Wh Addr Secondary	Dc Wh Addr-002-ALT	Dc Wh Addr-002-ALT	Dc Wh Addr-002-ALT	D	ALT-DC_WH-
default	Dc Wh Addr-003-EDGE	Dc Wh Addr-003-EDGE	Dc Wh Addr-003-EDGE	Dc Wh Addr-003-EDGE	Dc Wh Addr-003-EDGE	Dc	Dc Wh Addr-003-EDGE	Dc	EDG	Dc Wh Addr-003-EDGE	Dc Wh Addr-003-EDGE	Dc Wh Addr Core	Dc Wh Addr-003-EDGE	Dc Wh Addr-003-EDGE	Dc Wh Addr-003-EDGE	D	EDGE-DC_WH

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 Wh Addr-002-ALT
POST: Dc Wh Addr-002-ALT
ADD_1: Dc Wh Addr-002-ALT
ADD_2: Dc Wh Addr-002-ALT
ADD_3: Dc Wh Addr-002-ALT
STATE: Dc
COUNTY: Dc Wh Addr-002-ALT
ADDR_TYPE: Dc
COUNTRY_ID: ALT
CONTACT_FAX: Dc Wh Addr-002-ALT
KEY_VALUE_1: Dc Wh Addr-002-ALT
CONTACT_NAME: Dc Wh Addr Secondary
CONTACT_EMAIL: Dc Wh Addr-002-ALT
CONTACT_PHONE: Dc Wh Addr-002-ALT
CONTACT_TELEX: Dc Wh Addr-002-ALT
PRIMARY_ADDR_IND: D
JURISDICTION_CODE: ALT-DC_WH-

default

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

Rule Validation Summary

Source Rule Count: 20
Governed Rule Count: 17