Order Inventory Mgmt
In ScopeTechnical: ORD_INV_MGMT | ID: OR-REPL-ORD_INV_MGMT-ORDER_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
- ORD_INV_MGMT
Field Definitions(5)
Rules & Considerations(89)
validation
constraint
Sample Load Data(4)
| _scenario | ORDER_NORPK | SCALE_CNSTR_INDR | FILE_ID | LTL_IND | DUE_ORD_IND | DUE_ORD_LVL | NO_VEHICLES | SCALE_ISSUES | MIN_CNSTR_LVL | ORD_PURGE_IND | POOL_SUPPLIER | 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 | ORD_APPROVE_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 | SCALE_CNSTR_CURR1 | SCALE_CNSTR_CURR2 | SCALE_CNSTR_TYPE1 | SCALE_CNSTR_TYPE2 | TRUCK_CNSTR_TYPE1 | TRUCK_CNSTR_TYPE2 | DUE_ORD_SERV_BASIS | TRUCK_SPLIT_ISSUES | TRUCK_SPLIT_METHOD | DUE_ORD_PROCESS_IND | SCALE_CNSTR_CHG_IND | 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 | MAX_SCALING_ITERATIONS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | S | SAMPLE | S | S | SAMPLE | 1.0000 | SAMPLE | SAMPLE | S | 1 | SAMPLE | SAMP | SAMP | 1.0000 | 1.0000 | S | SAM | SAM | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | S | S | S | SAMP | SAMP | 1.0000 | 1.0000 | SAMP | SAMP | 1.0000 | 1.0000 | SAM | SAM | SAMPLE | SAMPLE | S | S | SAMPLE | SAMPLE | S | S | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1 |
| default | 4 | N | ALT-ORD_INV-002 | O | N | O | 12.5000 | Ord Inv Mgmt-002-ALT | L | N | 3 | O | Ord | Ord | 12.5000 | 12.5000 | N | Ord | Ord | M | M | O | L | X | O | O | N | Ord | Ord | 12.5000 | 12.5000 | Ord | Ord | 12.5000 | 12.5000 | Ord | Ord | M | M | O | O | U | Ord Inv Mgmt-002-ALT | O | N | N | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 3 |
| default | 6 | Y | EDGE-ORD_INV-003 | O | Y | ESO | 14.0000 | Ord Inv Mgmt-003-EDGE | O | Y | 5 | met | Ord | Ord | 14.0000 | 14.0000 | Y | Ord | Ord | V | V | O | O | M | O | O | Y | Ord | Ord | 14.0000 | 14.0000 | Ord | Ord | 14.0000 | 14.0000 | Ord | Ord | V | V | O | O | C | Ord Inv Mgmt-003-EDGE | O | Y | Y | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 5 |
Example values from field definitions
- ORDER_NORPK
- 1
- SCALE_CNSTR_INDR
- S
- FILE_ID
- SAMPLE
- LTL_IND
- S
- DUE_ORD_IND
- S
- DUE_ORD_LVL
- SAMPLE
- NO_VEHICLES
- 1.0000
- SCALE_ISSUES
- SAMPLE
- MIN_CNSTR_LVL
- SAMPLE
- ORD_PURGE_IND
- S
- POOL_SUPPLIER
- 1
- 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
- ORD_APPROVE_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
- 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
- TRUCK_SPLIT_ISSUES
- SAMPLE
- TRUCK_SPLIT_METHOD
- S
- DUE_ORD_PROCESS_IND
- S
- SCALE_CNSTR_CHG_IND
- S
- 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
- MAX_SCALING_ITERATIONS
- 1
default
- ORDER_NORPK
- 4
- SCALE_CNSTR_INDR
- N
- FILE_ID
- ALT-ORD_INV-002
- LTL_IND
- O
- DUE_ORD_IND
- N
- DUE_ORD_LVL
- O
- NO_VEHICLES
- 12.5000
- SCALE_ISSUES
- Ord Inv Mgmt-002-ALT
- MIN_CNSTR_LVL
- L
- ORD_PURGE_IND
- N
- POOL_SUPPLIER
- 3
- MIN_CNSTR_CONJ
- O
- MIN_CNSTR_UOM1
- Ord
- MIN_CNSTR_UOM2
- Ord
- MIN_CNSTR_VAL1
- 12.5000
- MIN_CNSTR_VAL2
- 12.5000
- SINGLE_LOC_IND
- N
- MIN_CNSTR_CURR1
- Ord
- MIN_CNSTR_CURR2
- Ord
- MIN_CNSTR_TYPE1
- M
- MIN_CNSTR_TYPE2
- M
- ORD_APPROVE_IND
- O
- SCALE_CNSTR_LVL
- L
- SCALE_CNSTR_OBJ
- X
- TRUCK_SPLIT_IND
- O
- LTL_APPROVAL_IND
- O
- MULT_VEHICLE_IND
- N
- SCALE_CNSTR_UOM1
- Ord
- SCALE_CNSTR_UOM2
- Ord
- TRUCK_CNSTR_TOL1
- 12.5000
- TRUCK_CNSTR_TOL2
- 12.5000
- TRUCK_CNSTR_UOM1
- Ord
- TRUCK_CNSTR_UOM2
- Ord
- TRUCK_CNSTR_VAL1
- 12.5000
- TRUCK_CNSTR_VAL2
- 12.5000
- SCALE_CNSTR_CURR1
- Ord
- SCALE_CNSTR_CURR2
- Ord
- SCALE_CNSTR_TYPE1
- M
- SCALE_CNSTR_TYPE2
- M
- TRUCK_CNSTR_TYPE1
- O
- TRUCK_CNSTR_TYPE2
- O
- DUE_ORD_SERV_BASIS
- U
- TRUCK_SPLIT_ISSUES
- Ord Inv Mgmt-002-ALT
- TRUCK_SPLIT_METHOD
- O
- DUE_ORD_PROCESS_IND
- N
- SCALE_CNSTR_CHG_IND
- N
- 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
- MAX_SCALING_ITERATIONS
- 3
default
- ORDER_NORPK
- 6
- SCALE_CNSTR_INDR
- Y
- FILE_ID
- EDGE-ORD_INV-003
- LTL_IND
- O
- DUE_ORD_IND
- Y
- DUE_ORD_LVL
- ESO
- NO_VEHICLES
- 14.0000
- SCALE_ISSUES
- Ord Inv Mgmt-003-EDGE
- MIN_CNSTR_LVL
- O
- ORD_PURGE_IND
- Y
- POOL_SUPPLIER
- 5
- MIN_CNSTR_CONJ
- met
- MIN_CNSTR_UOM1
- Ord
- MIN_CNSTR_UOM2
- Ord
- MIN_CNSTR_VAL1
- 14.0000
- MIN_CNSTR_VAL2
- 14.0000
- SINGLE_LOC_IND
- Y
- MIN_CNSTR_CURR1
- Ord
- MIN_CNSTR_CURR2
- Ord
- MIN_CNSTR_TYPE1
- V
- MIN_CNSTR_TYPE2
- V
- ORD_APPROVE_IND
- O
- SCALE_CNSTR_LVL
- O
- SCALE_CNSTR_OBJ
- M
- TRUCK_SPLIT_IND
- O
- LTL_APPROVAL_IND
- O
- MULT_VEHICLE_IND
- Y
- SCALE_CNSTR_UOM1
- Ord
- SCALE_CNSTR_UOM2
- Ord
- TRUCK_CNSTR_TOL1
- 14.0000
- TRUCK_CNSTR_TOL2
- 14.0000
- TRUCK_CNSTR_UOM1
- Ord
- TRUCK_CNSTR_UOM2
- Ord
- TRUCK_CNSTR_VAL1
- 14.0000
- TRUCK_CNSTR_VAL2
- 14.0000
- SCALE_CNSTR_CURR1
- Ord
- SCALE_CNSTR_CURR2
- Ord
- SCALE_CNSTR_TYPE1
- V
- SCALE_CNSTR_TYPE2
- V
- TRUCK_CNSTR_TYPE1
- O
- TRUCK_CNSTR_TYPE2
- O
- DUE_ORD_SERV_BASIS
- C
- TRUCK_SPLIT_ISSUES
- Ord Inv Mgmt-003-EDGE
- TRUCK_SPLIT_METHOD
- O
- DUE_ORD_PROCESS_IND
- Y
- SCALE_CNSTR_CHG_IND
- Y
- SCALE_CNSTR_MAX_TOL1
- 14.0000
- SCALE_CNSTR_MAX_TOL2
- 14.0000
- SCALE_CNSTR_MAX_VAL1
- 14.0000
- SCALE_CNSTR_MAX_VAL2
- 14.0000
- SCALE_CNSTR_MIN_TOL1
- 14.0000
- SCALE_CNSTR_MIN_TOL2
- 14.0000
- SCALE_CNSTR_MIN_VAL1
- 14.0000
- SCALE_CNSTR_MIN_VAL2
- 14.0000
- MAX_SCALING_ITERATIONS
- 5
Rule Validation Summary
- Source Rule Count
- 129
- Governed Rule Count
- 89