Shipitem Inventory Flow
In ScopeTechnical: SHIPITEM_INV_FLOW | ID: OR-INV-SHIPITEM_INV_FLOW-SHIPITEM_INVENTORY_FLOW
This table will hold the details of how the shipment line item flows (i.e. maps) between the from location and the to location of the shipment.
See how this object fits into Inventory Management
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
- SHIPITEM_INV_FLOW
Field Definitions(5)
Rules & Considerations(31)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | SEQ_NORPK | TO_LOCRPK | FROM_LOCRPK | SHIPMENTRPK | TSF_NO | TSF_QTY | DIST_PCT | TSF_SEQ_NO | TO_LOC_TYPE | RECEIVED_QTY | FROM_LOC_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | 1 | 1 | 1.0000 | 1.0000 | 1 | S | 1.0000 | S |
| default | Shipitem Inv Flow-002-ALT | 4 | 3 | 3 | 3 | 4 | 12.5000 | 12.5000 | 4 | S | 12.5000 | S |
| default | Shipitem Inv Flow-003-EDG | 6 | 5 | 5 | 5 | 6 | 14.0000 | 14.0000 | 6 | S | 14.0000 | S |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SEQ_NORPK
- 1
- TO_LOCRPK
- 1
- FROM_LOCRPK
- 1
- SHIPMENTRPK
- 1
- TSF_NO
- 1
- TSF_QTY
- 1.0000
- DIST_PCT
- 1.0000
- TSF_SEQ_NO
- 1
- TO_LOC_TYPE
- S
- RECEIVED_QTY
- 1.0000
- FROM_LOC_TYPE
- S
default
- ITEMRPK
- Shipitem Inv Flow-002-ALT
- SEQ_NORPK
- 4
- TO_LOCRPK
- 3
- FROM_LOCRPK
- 3
- SHIPMENTRPK
- 3
- TSF_NO
- 4
- TSF_QTY
- 12.5000
- DIST_PCT
- 12.5000
- TSF_SEQ_NO
- 4
- TO_LOC_TYPE
- S
- RECEIVED_QTY
- 12.5000
- FROM_LOC_TYPE
- S
default
- ITEMRPK
- Shipitem Inv Flow-003-EDG
- SEQ_NORPK
- 6
- TO_LOCRPK
- 5
- FROM_LOCRPK
- 5
- SHIPMENTRPK
- 5
- TSF_NO
- 6
- TSF_QTY
- 14.0000
- DIST_PCT
- 14.0000
- TSF_SEQ_NO
- 6
- TO_LOC_TYPE
- S
- RECEIVED_QTY
- 14.0000
- FROM_LOC_TYPE
- S
Rule Validation Summary
- Source Rule Count
- 43
- Governed Rule Count
- 31