Mrt Item Location

In Scope

Technical: 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(5)

Rules & Considerations(22)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	MRT_NORPK	LOCATIONRPK	LOC_TYPER	RETURN_AVAIL_QTYR	TSF_QTY	TSF_COST	TSF_PRICE	UNIT_COST	UNIT_RETAIL	RECEIVED_QTY
Example values from field definitions	SAMPLE	1	1	S	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000
default	Mrt Item Loc-002-ALT	4	3	W	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000
default	Mrt Item Loc-003-EDGE	6	5	W	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000

Example values from field definitions

ITEMRPK: SAMPLE
MRT_NORPK: 1
LOCATIONRPK: 1
LOC_TYPER: S
RETURN_AVAIL_QTYR: 1.0000
TSF_QTY: 1.0000
TSF_COST: 1.0000
TSF_PRICE: 1.0000
UNIT_COST: 1.0000
UNIT_RETAIL: 1.0000
RECEIVED_QTY: 1.0000

default

ITEMRPK: Mrt Item Loc-002-ALT
MRT_NORPK: 4
LOCATIONRPK: 3
LOC_TYPER: W
RETURN_AVAIL_QTYR: 12.5000
TSF_QTY: 12.5000
TSF_COST: 12.5000
TSF_PRICE: 12.5000
UNIT_COST: 12.5000
UNIT_RETAIL: 12.5000
RECEIVED_QTY: 12.5000