Warehouse Department

In Scope

Technical: WH_DEPT | ID: OR-FND-WH_DEPT-WAREHOUSE_DEPARTMENT

This table will hold data that may be associated with a single warehouse or warehouse/department combination.

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_DEPT

Field Definitions(5)

Rules & Considerations(29)

validation

constraint

Sample Load Data(4)

_scenario	WHRPK	SEQ_NORPK	DEPT	COST_MONEY	TARGET_ROI	STORAGE_TYPE	COST_WH_STORAGE	COST_OUT_STORAGE	MAX_WEEKS_SUPPLY	COST_WH_STORAGE_UOM	COST_OUT_STORAGE_UOM	COST_WH_STORAGE_MEAS	COST_OUT_STORAGE_MEAS
Example values from field definitions	1	1	1	1.0000	1.0000	SAMPLE	1.0000	1.0000	1	SAMP	SAMP	SAMPLE	SAMPLE
default	9003	4	1003	12.5000	12.5000	Wh Dep	12.5000	12.5000	3	Wh D	Wh D	Wh Dep	Wh Dep
default	9005	6	1005	14.0000	14.0000	Wh Dep	14.0000	14.0000	5	Wh D	Wh D	Wh Dep	Wh Dep

Example values from field definitions

WHRPK: 1
SEQ_NORPK: 1
DEPT: 1
COST_MONEY: 1.0000
TARGET_ROI: 1.0000
STORAGE_TYPE: SAMPLE
COST_WH_STORAGE: 1.0000
COST_OUT_STORAGE: 1.0000
MAX_WEEKS_SUPPLY: 1
COST_WH_STORAGE_UOM: SAMP
COST_OUT_STORAGE_UOM: SAMP
COST_WH_STORAGE_MEAS: SAMPLE
COST_OUT_STORAGE_MEAS: SAMPLE

default

WHRPK: 9003
SEQ_NORPK: 4
DEPT: 1003
COST_MONEY: 12.5000
TARGET_ROI: 12.5000
STORAGE_TYPE: Wh Dep
COST_WH_STORAGE: 12.5000
COST_OUT_STORAGE: 12.5000
MAX_WEEKS_SUPPLY: 3
COST_WH_STORAGE_UOM: Wh D
COST_OUT_STORAGE_UOM: Wh D
COST_WH_STORAGE_MEAS: Wh Dep
COST_OUT_STORAGE_MEAS: Wh Dep

default

WHRPK: 9005
SEQ_NORPK: 6
DEPT: 1005
COST_MONEY: 14.0000
TARGET_ROI: 14.0000
STORAGE_TYPE: Wh Dep
COST_WH_STORAGE: 14.0000
COST_OUT_STORAGE: 14.0000
MAX_WEEKS_SUPPLY: 5
COST_WH_STORAGE_UOM: Wh D
COST_OUT_STORAGE_UOM: Wh D
COST_WH_STORAGE_MEAS: Wh Dep
COST_OUT_STORAGE_MEAS: Wh Dep

Rule Validation Summary

Source Rule Count: 42
Governed Rule Count: 29