One Row For Each Warehouse
In ScopeTechnical: WH | ID: OR-FND-WH-WAREHOUSE
Stores one row for each warehouse within the company. A warehouse can be either a physical warehouse or a virtual warehouse.
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
- WH
Field Definitions(5)
Rules & Considerations(85)
validation
constraint
Sample Load Data(4)
| _scenario | WHRPK | WH_NAMER | IB_IND | TAX_ID | DUNS_LOC | REPL_IND | VWH_TYPE | CREATE_ID | CHANNEL_ID | DEFAULT_WH | IB_WH_LINK | VAT_REGION | DUNS_NUMBER | ORG_UNIT_ID | PHYSICAL_WH | PRIMARY_VWH | FINISHER_IND | LEGAL_ENTITY | REPL_SRC_ORD | REPL_WH_LINK | ROUNDING_SEQ | AUTO_IB_CLEAR | CURRENCY_CODE | GIFT_WRAP_IND | ORG_HIER_TYPE | PROTECTED_IND | REDIST_WH_IND | TSF_ENTITY_ID | BREAK_PACK_IND | LAST_UPDATE_ID | ORG_HIER_VALUE | RESTRICTED_IND | CREATE_DATETIME | DELIVERY_POLICY | FORECAST_WH_IND | ORG_ENTITY_TYPE | PRICING_LOCATION | STOCKHOLDING_IND | WH_NAME_SECONDARY | LAST_UPDATE_DATETIME | CUSTOMER_SHIPPING_IND | INBOUND_HANDLING_DAYS | CUSTOMER_ORDER_LOC_IND | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | S | SAMPLE | SAMP | S | SAMPLE | SAMPLE | 1 | 1 | 1 | 1 | SAMPLE | 1 | 1 | 1 | S | SAMPLE | 1 | 1 | 1 | S | SAM | S | 1 | S | S | 1 | S | SAMPLE | 1 | S | 2026-01-01 | SAMPLE | S | S | 1 | S | SAMPLE | 2026-01-01 | S | 1 | S |
| default | 9003 | Wh Secondary | Wh-002-ALT | W | ALT-WH-002 | Wh-0 | W | Wh-002 | C LIENT_INFO | 100003 | 9003 | 3 | 203 | Wh-002-AL | 1000000003 | 9003 | 3 | W | Wh-002-ALT | 3 | 3 | 3 | W | ALT | N | 1 | W | N | 1000000003 | N | APP_USER_ID | 3 | W | 2026-01-03 | Wh-002 | W | M | 3 | W | Wh-002-ALT | 2026-01-03 | N | 3 | N |
| default | 9005 | Wh Core | Wh-003-EDGE | W | EDGE-WH-003 | Wh-0 | W | Wh-003 | USE RENV | 100005 | 9005 | 5 | 205 | Wh-003-ED | 1000000005 | 9005 | 5 | W | Wh-003-EDGE | 5 | 5 | 5 | W | EDG | N | 1 | W | Y | 1000000005 | Y | USERENV | 5 | W | 2026-01-05 | Wh-003 | W | X | 5 | W | Wh-003-EDGE | 2026-01-05 | N | 5 | Y |
Example values from field definitions
- WHRPK
- 1
- WH_NAMER
- SAMPLE
- SAMPLE
- IB_IND
- S
- TAX_ID
- SAMPLE
- DUNS_LOC
- SAMP
- REPL_IND
- S
- VWH_TYPE
- SAMPLE
- CREATE_ID
- SAMPLE
- CHANNEL_ID
- 1
- DEFAULT_WH
- 1
- IB_WH_LINK
- 1
- VAT_REGION
- 1
- DUNS_NUMBER
- SAMPLE
- ORG_UNIT_ID
- 1
- PHYSICAL_WH
- 1
- PRIMARY_VWH
- 1
- FINISHER_IND
- S
- LEGAL_ENTITY
- SAMPLE
- REPL_SRC_ORD
- 1
- REPL_WH_LINK
- 1
- ROUNDING_SEQ
- 1
- AUTO_IB_CLEAR
- S
- CURRENCY_CODE
- SAM
- GIFT_WRAP_IND
- S
- ORG_HIER_TYPE
- 1
- PROTECTED_IND
- S
- REDIST_WH_IND
- S
- TSF_ENTITY_ID
- 1
- BREAK_PACK_IND
- S
- LAST_UPDATE_ID
- SAMPLE
- ORG_HIER_VALUE
- 1
- RESTRICTED_IND
- S
- CREATE_DATETIME
- 2026-01-01
- DELIVERY_POLICY
- SAMPLE
- FORECAST_WH_IND
- S
- ORG_ENTITY_TYPE
- S
- PRICING_LOCATION
- 1
- STOCKHOLDING_IND
- S
- WH_NAME_SECONDARY
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
- CUSTOMER_SHIPPING_IND
- S
- INBOUND_HANDLING_DAYS
- 1
- CUSTOMER_ORDER_LOC_IND
- S
default
- WHRPK
- 9003
- WH_NAMER
- Wh Secondary
- Wh-002-ALT
- IB_IND
- W
- TAX_ID
- ALT-WH-002
- DUNS_LOC
- Wh-0
- REPL_IND
- W
- VWH_TYPE
- Wh-002
- CREATE_ID
- C LIENT_INFO
- CHANNEL_ID
- 100003
- DEFAULT_WH
- 9003
- IB_WH_LINK
- 3
- VAT_REGION
- 203
- DUNS_NUMBER
- Wh-002-AL
- ORG_UNIT_ID
- 1000000003
- PHYSICAL_WH
- 9003
- PRIMARY_VWH
- 3
- FINISHER_IND
- W
- LEGAL_ENTITY
- Wh-002-ALT
- REPL_SRC_ORD
- 3
- REPL_WH_LINK
- 3
- ROUNDING_SEQ
- 3
- AUTO_IB_CLEAR
- W
- CURRENCY_CODE
- ALT
- GIFT_WRAP_IND
- N
- ORG_HIER_TYPE
- 1
- PROTECTED_IND
- W
- REDIST_WH_IND
- N
- TSF_ENTITY_ID
- 1000000003
- BREAK_PACK_IND
- N
- LAST_UPDATE_ID
- APP_USER_ID
- ORG_HIER_VALUE
- 3
- RESTRICTED_IND
- W
- CREATE_DATETIME
- 2026-01-03
- DELIVERY_POLICY
- Wh-002
- FORECAST_WH_IND
- W
- ORG_ENTITY_TYPE
- M
- PRICING_LOCATION
- 3
- STOCKHOLDING_IND
- W
- WH_NAME_SECONDARY
- Wh-002-ALT
- LAST_UPDATE_DATETIME
- 2026-01-03
- CUSTOMER_SHIPPING_IND
- N
- INBOUND_HANDLING_DAYS
- 3
- CUSTOMER_ORDER_LOC_IND
- N
default
- WHRPK
- 9005
- WH_NAMER
- Wh Core
- Wh-003-EDGE
- IB_IND
- W
- TAX_ID
- EDGE-WH-003
- DUNS_LOC
- Wh-0
- REPL_IND
- W
- VWH_TYPE
- Wh-003
- CREATE_ID
- USE RENV
- CHANNEL_ID
- 100005
- DEFAULT_WH
- 9005
- IB_WH_LINK
- 5
- VAT_REGION
- 205
- DUNS_NUMBER
- Wh-003-ED
- ORG_UNIT_ID
- 1000000005
- PHYSICAL_WH
- 9005
- PRIMARY_VWH
- 5
- FINISHER_IND
- W
- LEGAL_ENTITY
- Wh-003-EDGE
- REPL_SRC_ORD
- 5
- REPL_WH_LINK
- 5
- ROUNDING_SEQ
- 5
- AUTO_IB_CLEAR
- W
- CURRENCY_CODE
- EDG
- GIFT_WRAP_IND
- N
- ORG_HIER_TYPE
- 1
- PROTECTED_IND
- W
- REDIST_WH_IND
- Y
- TSF_ENTITY_ID
- 1000000005
- BREAK_PACK_IND
- Y
- LAST_UPDATE_ID
- USERENV
- ORG_HIER_VALUE
- 5
- RESTRICTED_IND
- W
- CREATE_DATETIME
- 2026-01-05
- DELIVERY_POLICY
- Wh-003
- FORECAST_WH_IND
- W
- ORG_ENTITY_TYPE
- X
- PRICING_LOCATION
- 5
- STOCKHOLDING_IND
- W
- WH_NAME_SECONDARY
- Wh-003-EDGE
- LAST_UPDATE_DATETIME
- 2026-01-05
- CUSTOMER_SHIPPING_IND
- N
- INBOUND_HANDLING_DAYS
- 5
- CUSTOMER_ORDER_LOC_IND
- Y
Rule Validation Summary
- Source Rule Count
- 126
- Governed Rule Count
- 85