Dc Vwh

In Scope

Technical: DC_VWH | ID: OR-FND-DC_VWH-DC_VWH

This table is a staging table for data conversion and will hold the virtual warehouse 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_VWH

Field Definitions(5)

Rules & Considerations(20)

Sample Load Data(4)

Example values from field definitions

WH
1
IB_IND
S
WH_NAME
SAMPLE
REPL_IND
S
CHANNEL_ID
1
DEFAULT_WH
1
IB_WH_LINK
1
ORG_UNIT_ID
1
PHYSICAL_WH
1
FINISHER_IND
S
REPL_WH_LINK
1
AUTO_IB_CLEAR
S
PROTECTED_IND
S
TSF_ENTITY_ID
1
RESTRICTED_IND
S
FORECAST_WH_IND
S
ORG_ENTITY_TYPE
S
PRICING_LOCATION
1
WH_NAME_SECONDARY
SAMPLE
CUSTOMER_ORDER_LOC_IND
S

default

WH
9003
IB_IND
D
WH_NAME
Dc Vwh Secondary
REPL_IND
D
CHANNEL_ID
100003
DEFAULT_WH
9003
IB_WH_LINK
3
ORG_UNIT_ID
1000000003
PHYSICAL_WH
9003
FINISHER_IND
D
REPL_WH_LINK
3
AUTO_IB_CLEAR
D
PROTECTED_IND
D
TSF_ENTITY_ID
1000000003
RESTRICTED_IND
D
FORECAST_WH_IND
D
ORG_ENTITY_TYPE
D
PRICING_LOCATION
3
WH_NAME_SECONDARY
Dc Vwh-002-ALT
CUSTOMER_ORDER_LOC_IND
D

default

WH
9005
IB_IND
D
WH_NAME
Dc Vwh Core
REPL_IND
D
CHANNEL_ID
100005
DEFAULT_WH
9005
IB_WH_LINK
5
ORG_UNIT_ID
1000000005
PHYSICAL_WH
9005
FINISHER_IND
D
REPL_WH_LINK
5
AUTO_IB_CLEAR
D
PROTECTED_IND
D
TSF_ENTITY_ID
1000000005
RESTRICTED_IND
D
FORECAST_WH_IND
D
ORG_ENTITY_TYPE
D
PRICING_LOCATION
5
WH_NAME_SECONDARY
Dc Vwh-003-EDGE
CUSTOMER_ORDER_LOC_IND
D

Rule Validation Summary

Source Rule Count
23
Governed Rule Count
20