Mrt
In ScopeTechnical: MRT | ID: OR-INV-MRT-MRT
This table supports the concept of a Mass Return Transfer Number and other attributes to maintain multiple transfers and Rtvs. This table will hold the header information and the details...
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
Field Definitions(5)
Rules & Considerations(32)
constraint
validation
Sample Load Data(4)
| _scenario | WHR | MRT_NORPK | MRT_DESCR | MRT_TYPER | MRT_STATUSR | SUPPLIER | CLOSE_DATE | RTV_REASON | RESTOCK_PCT | COMMENT_DESC | REF_AUTH_NUM | CURRENCY_CODE | QUANTITY_TYPE | INCLUDE_WH_INV | INVENTORY_TYPE | RTV_CREATE_DATE | TSF_CREATE_DATE | CREATE_RTV_STATUS | RTV_NOT_AFTER_DATE | TSF_NOT_AFTER_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | S | 1 | 2026-01-01 | SAMPLE | 1.0000 | SAMPLE | SAMPLE | SAM | SAMPLE | S | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | 9003 | 4 | Mrt-002-ALT | Mrt-00 | I | 3 | 2026-01-03 | Mrt-00 | 12.5000 | Mrt-002-ALT | Mrt-002-ALT | ALT | Mrt-00 | M | Mrt-00 | 2026-01-03 | 2026-01-03 | PENDIN | 2026-01-03 | 2026-01-03 |
| default | 9005 | 6 | Mrt-003-EDGE | Mrt-00 | I | 5 | 2026-01-05 | Mrt-00 | 14.0000 | Mrt-003-EDGE | Mrt-003-EDGE | EDG | Mrt-00 | M | Mrt-00 | 2026-01-05 | 2026-01-05 | ACTIVE | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- WHR
- 1
- MRT_NORPK
- 1
- MRT_DESCR
- SAMPLE
- MRT_TYPER
- SAMPLE
- MRT_STATUSR
- S
- SUPPLIER
- 1
- CLOSE_DATE
- 2026-01-01
- RTV_REASON
- SAMPLE
- RESTOCK_PCT
- 1.0000
- COMMENT_DESC
- SAMPLE
- REF_AUTH_NUM
- SAMPLE
- CURRENCY_CODE
- SAM
- QUANTITY_TYPE
- SAMPLE
- INCLUDE_WH_INV
- S
- INVENTORY_TYPE
- SAMPLE
- RTV_CREATE_DATE
- 2026-01-01
- TSF_CREATE_DATE
- 2026-01-01
- CREATE_RTV_STATUS
- SAMPLE
- RTV_NOT_AFTER_DATE
- 2026-01-01
- TSF_NOT_AFTER_DATE
- 2026-01-01
default
- WHR
- 9003
- MRT_NORPK
- 4
- MRT_DESCR
- Mrt-002-ALT
- MRT_TYPER
- Mrt-00
- MRT_STATUSR
- I
- SUPPLIER
- 3
- CLOSE_DATE
- 2026-01-03
- RTV_REASON
- Mrt-00
- RESTOCK_PCT
- 12.5000
- COMMENT_DESC
- Mrt-002-ALT
- REF_AUTH_NUM
- Mrt-002-ALT
- CURRENCY_CODE
- ALT
- QUANTITY_TYPE
- Mrt-00
- INCLUDE_WH_INV
- M
- INVENTORY_TYPE
- Mrt-00
- RTV_CREATE_DATE
- 2026-01-03
- TSF_CREATE_DATE
- 2026-01-03
- CREATE_RTV_STATUS
- PENDIN
- RTV_NOT_AFTER_DATE
- 2026-01-03
- TSF_NOT_AFTER_DATE
- 2026-01-03
default
- WHR
- 9005
- MRT_NORPK
- 6
- MRT_DESCR
- Mrt-003-EDGE
- MRT_TYPER
- Mrt-00
- MRT_STATUSR
- I
- SUPPLIER
- 5
- CLOSE_DATE
- 2026-01-05
- RTV_REASON
- Mrt-00
- RESTOCK_PCT
- 14.0000
- COMMENT_DESC
- Mrt-003-EDGE
- REF_AUTH_NUM
- Mrt-003-EDGE
- CURRENCY_CODE
- EDG
- QUANTITY_TYPE
- Mrt-00
- INCLUDE_WH_INV
- M
- INVENTORY_TYPE
- Mrt-00
- RTV_CREATE_DATE
- 2026-01-05
- TSF_CREATE_DATE
- 2026-01-05
- CREATE_RTV_STATUS
- ACTIVE
- RTV_NOT_AFTER_DATE
- 2026-01-05
- TSF_NOT_AFTER_DATE
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 32