Mrt Item Location
In ScopeTechnical: MRT_ITEM_LOC | ID: OR-INV-MRT_ITEM_LOC-MRT_ITEM_LOCATION
This table supports the concept of a Mass Return Transfer Number and other attributes to maintain multiple transfers and Rtvs. The table will hold all the items/location combinations relating to…
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
- MRT_ITEM_LOC
Field Definitions(11)
Rules & Considerations(19)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | MRT_NORPK | TSF_QTYR | LOCATIONR | LOC_TYPER | RETURN_AVAIL_QTYR | TSF_COST | TSF_PRICE | UNIT_COST | UNIT_RETAIL | RECEIVED_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | 1 | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- MRT_NORPK
- 1
- TSF_QTYR
- 1.0000
- LOCATIONR
- 1
- LOC_TYPER
- S
- RETURN_AVAIL_QTYR
- 1.0000
- TSF_COST
- 1.0000
- TSF_PRICE
- 1.0000
- UNIT_COST
- 1.0000
- UNIT_RETAIL
- 1.0000
- RECEIVED_QTY
- 1.0000
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 19