Supplier Inventory Mgmt

In Scope

Technical: SUP_INV_MGMT | ID: OR-REPL-SUP_INV_MGMT-SUPPLIER_INVENTORY_MGMT

Determines whether the stock out comparisons for Due order determination should be performed in units (standard unit of measures), cost or profit (i.e. retail - cost) in the orders currency...

See how this object fits into Replenishment

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

Field Definitions(5)

Rules & Considerations(119)

constraint

validation

Sample Load Data(4)

_scenario	SUPPLIERR	SUP_DEPT_SEQ_NORPK	DEPT	IB_IND	LOCATION	LOC_TYPE	ROUND_LVL	PICKUP_LOC	DUE_ORD_LVL	BRACKET_UOM1	BRACKET_UOM2	REVIEW_CYCLE	BRACKET_TYPE1	BRACKET_TYPE2	IB_ORDER_CTRL	MIN_CNSTR_LVL	ORD_PURGE_IND	POOL_SUPPLIER	PURCHASE_TYPE	MIN_CNSTR_CONJ	MIN_CNSTR_UOM1	MIN_CNSTR_UOM2	MIN_CNSTR_VAL1	MIN_CNSTR_VAL2	SINGLE_LOC_IND	MIN_CNSTR_CURR1	MIN_CNSTR_CURR2	MIN_CNSTR_TYPE1	MIN_CNSTR_TYPE2	REPL_ORDER_CTRL	SCALE_CNSTR_IND	SCALE_CNSTR_LVL	SCALE_CNSTR_OBJ	TRUCK_SPLIT_IND	LTL_APPROVAL_IND	MULT_VEHICLE_IND	SCALE_CNSTR_UOM1	SCALE_CNSTR_UOM2	TRUCK_CNSTR_TOL1	TRUCK_CNSTR_TOL2	TRUCK_CNSTR_UOM1	TRUCK_CNSTR_UOM2	TRUCK_CNSTR_VAL1	TRUCK_CNSTR_VAL2	QTY_VAR_THRESHOLD	ROUND_TO_CASE_PCT	SCALE_CNSTR_CURR1	SCALE_CNSTR_CURR2	SCALE_CNSTR_TYPE1	SCALE_CNSTR_TYPE2	TRUCK_CNSTR_TYPE1	TRUCK_CNSTR_TYPE2	DUE_ORD_SERV_BASIS	ROUND_TO_INNER_PCT	ROUND_TO_LAYER_PCT	TRUCK_SPLIT_METHOD	DUE_ORD_PROCESS_IND	ROUND_TO_PALLET_PCT	MAX_ORD_COST_APPROVE	SCALE_CNSTR_MAX_TOL1	SCALE_CNSTR_MAX_TOL2	SCALE_CNSTR_MAX_VAL1	SCALE_CNSTR_MAX_VAL2	SCALE_CNSTR_MIN_TOL1	SCALE_CNSTR_MIN_TOL2	SCALE_CNSTR_MIN_VAL1	SCALE_CNSTR_MIN_VAL2	NON_DUE_ORD_CREATE_IND	THRESHOLD_NEXT_BRACKET
Example values from field definitions	1	1	1	S	1	S	SAMPLE	SAMPLE	SAMPLE	SAMP	SAMP	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	1	SAMPLE	SAMPLE	SAMP	SAMP	1.0000	1.0000	S	SAM	SAM	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	S	S	S	SAMP	SAMP	1.0000	1.0000	SAMP	SAMP	1.0000	1.0000	1.0000	1.0000	SAM	SAM	SAMPLE	SAMPLE	S	S	SAMPLE	1.0000	1.0000	S	S	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	S	1.0000
default	3	4	1003	S	3	W	C	Sup Inv Mgmt-002-ALT	O	Sup	Sup	Sup In	V	V	Sup In	L	N	3	Sup In	O	Sup	Sup	12.5000	12.5000	N	Sup	Sup	M	M	Sup In	N	L	X	S	S	N	Sup	Sup	12.5000	12.5000	Sup	Sup	12.5000	12.5000	12.5000	12.5000	Sup	Sup	M	M	S	S	U	12.5000	12.5000	S	N	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	n	12.5000
default	5	6	1005	S	5	S	C	Sup Inv Mgmt-003-EDGE	ESO	Sup	Sup	Sup In	P	P	Sup In	O	Y	5	Sup In	met	Sup	Sup	14.0000	14.0000	Y	Sup	Sup	V	V	Sup In	Y	O	M	S	S	Y	Sup	Sup	14.0000	14.0000	Sup	Sup	14.0000	14.0000	14.0000	14.0000	Sup	Sup	V	V	S	S	C	14.0000	14.0000	S	Y	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	N	14.0000

Example values from field definitions

SUPPLIERR: 1
SUP_DEPT_SEQ_NORPK: 1
DEPT: 1
IB_IND: S
LOCATION: 1
LOC_TYPE: S
ROUND_LVL: SAMPLE
PICKUP_LOC: SAMPLE
DUE_ORD_LVL: SAMPLE
BRACKET_UOM1: SAMP
BRACKET_UOM2: SAMP
REVIEW_CYCLE: SAMPLE
BRACKET_TYPE1: SAMPLE
BRACKET_TYPE2: SAMPLE
IB_ORDER_CTRL: SAMPLE
MIN_CNSTR_LVL: SAMPLE
ORD_PURGE_IND: S
POOL_SUPPLIER: 1
PURCHASE_TYPE: SAMPLE
MIN_CNSTR_CONJ: SAMPLE
MIN_CNSTR_UOM1: SAMP
MIN_CNSTR_UOM2: SAMP
MIN_CNSTR_VAL1: 1.0000
MIN_CNSTR_VAL2: 1.0000
SINGLE_LOC_IND: S
MIN_CNSTR_CURR1: SAM
MIN_CNSTR_CURR2: SAM
MIN_CNSTR_TYPE1: SAMPLE
MIN_CNSTR_TYPE2: SAMPLE
REPL_ORDER_CTRL: SAMPLE
SCALE_CNSTR_IND: S
SCALE_CNSTR_LVL: SAMPLE
SCALE_CNSTR_OBJ: SAMPLE
TRUCK_SPLIT_IND: S
LTL_APPROVAL_IND: S
MULT_VEHICLE_IND: S
SCALE_CNSTR_UOM1: SAMP
SCALE_CNSTR_UOM2: SAMP
TRUCK_CNSTR_TOL1: 1.0000
TRUCK_CNSTR_TOL2: 1.0000
TRUCK_CNSTR_UOM1: SAMP
TRUCK_CNSTR_UOM2: SAMP
TRUCK_CNSTR_VAL1: 1.0000
TRUCK_CNSTR_VAL2: 1.0000
QTY_VAR_THRESHOLD: 1.0000
ROUND_TO_CASE_PCT: 1.0000
SCALE_CNSTR_CURR1: SAM
SCALE_CNSTR_CURR2: SAM
SCALE_CNSTR_TYPE1: SAMPLE
SCALE_CNSTR_TYPE2: SAMPLE
TRUCK_CNSTR_TYPE1: S
TRUCK_CNSTR_TYPE2: S
DUE_ORD_SERV_BASIS: SAMPLE
ROUND_TO_INNER_PCT: 1.0000
ROUND_TO_LAYER_PCT: 1.0000
TRUCK_SPLIT_METHOD: S
DUE_ORD_PROCESS_IND: S
ROUND_TO_PALLET_PCT: 1.0000
MAX_ORD_COST_APPROVE: 1.0000
SCALE_CNSTR_MAX_TOL1: 1.0000
SCALE_CNSTR_MAX_TOL2: 1.0000
SCALE_CNSTR_MAX_VAL1: 1.0000
SCALE_CNSTR_MAX_VAL2: 1.0000
SCALE_CNSTR_MIN_TOL1: 1.0000
SCALE_CNSTR_MIN_TOL2: 1.0000
SCALE_CNSTR_MIN_VAL1: 1.0000
SCALE_CNSTR_MIN_VAL2: 1.0000
NON_DUE_ORD_CREATE_IND: S
THRESHOLD_NEXT_BRACKET: 1.0000

default

SUPPLIERR: 3
SUP_DEPT_SEQ_NORPK: 4
DEPT: 1003
IB_IND: S
LOCATION: 3
LOC_TYPE: W
ROUND_LVL: C
PICKUP_LOC: Sup Inv Mgmt-002-ALT
DUE_ORD_LVL: O
BRACKET_UOM1: Sup
BRACKET_UOM2: Sup
REVIEW_CYCLE: Sup In
BRACKET_TYPE1: V
BRACKET_TYPE2: V
IB_ORDER_CTRL: Sup In
MIN_CNSTR_LVL: L
ORD_PURGE_IND: N
POOL_SUPPLIER: 3
PURCHASE_TYPE: Sup In
MIN_CNSTR_CONJ: O
MIN_CNSTR_UOM1: Sup
MIN_CNSTR_UOM2: Sup
MIN_CNSTR_VAL1: 12.5000
MIN_CNSTR_VAL2: 12.5000
SINGLE_LOC_IND: N
MIN_CNSTR_CURR1: Sup
MIN_CNSTR_CURR2: Sup
MIN_CNSTR_TYPE1: M
MIN_CNSTR_TYPE2: M
REPL_ORDER_CTRL: Sup In
SCALE_CNSTR_IND: N
SCALE_CNSTR_LVL: L
SCALE_CNSTR_OBJ: X
TRUCK_SPLIT_IND: S
LTL_APPROVAL_IND: S
MULT_VEHICLE_IND: N
SCALE_CNSTR_UOM1: Sup
SCALE_CNSTR_UOM2: Sup
TRUCK_CNSTR_TOL1: 12.5000
TRUCK_CNSTR_TOL2: 12.5000
TRUCK_CNSTR_UOM1: Sup
TRUCK_CNSTR_UOM2: Sup
TRUCK_CNSTR_VAL1: 12.5000
TRUCK_CNSTR_VAL2: 12.5000
QTY_VAR_THRESHOLD: 12.5000
ROUND_TO_CASE_PCT: 12.5000
SCALE_CNSTR_CURR1: Sup
SCALE_CNSTR_CURR2: Sup
SCALE_CNSTR_TYPE1: M
SCALE_CNSTR_TYPE2: M
TRUCK_CNSTR_TYPE1: S
TRUCK_CNSTR_TYPE2: S
DUE_ORD_SERV_BASIS: U
ROUND_TO_INNER_PCT: 12.5000
ROUND_TO_LAYER_PCT: 12.5000
TRUCK_SPLIT_METHOD: S
DUE_ORD_PROCESS_IND: N
ROUND_TO_PALLET_PCT: 12.5000
MAX_ORD_COST_APPROVE: 12.5000
SCALE_CNSTR_MAX_TOL1: 12.5000
SCALE_CNSTR_MAX_TOL2: 12.5000
SCALE_CNSTR_MAX_VAL1: 12.5000
SCALE_CNSTR_MAX_VAL2: 12.5000
SCALE_CNSTR_MIN_TOL1: 12.5000
SCALE_CNSTR_MIN_TOL2: 12.5000
SCALE_CNSTR_MIN_VAL1: 12.5000
SCALE_CNSTR_MIN_VAL2: 12.5000
NON_DUE_ORD_CREATE_IND: n
THRESHOLD_NEXT_BRACKET: 12.5000