Mrt
In ScopeTechnical: MRT | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- MRT
Field Definitions(20)
Rules & Considerations(58)
Sample Load Data(4)
| _scenario | WHRPK | MRT_NORPK | MRT_DESCR | MRT_TYPER | SUPPLIERPK | MRT_STATUSR | CURRENCY_CODERPK | QUANTITY_TYPER | INVENTORY_TYPER | TSF_NOT_AFTER_DATER | CLOSE_DATE | RTV_REASON | RESTOCK_PCT | COMMENT_DESC | REF_AUTH_NUM | INCLUDE_WH_INV | RTV_CREATE_DATE | TSF_CREATE_DATE | CREATE_RTV_STATUS | RTV_NOT_AFTER_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 9001 | 2 | Mrt-001 | Mrt-001 | 1 | I | STD-MRT-001 | Mrt-001 | Mrt-001 | 2026-01-01 | 2026-01-01 | Mrt-001 | 11.0000 | Mrt-001 | Mrt-001 | Mrt-001 | 2026-01-01 | 2026-01-01 | ACTIVE | 2026-01-01 |
default
- WHRPK
- 9001
- MRT_NORPK
- 2
- MRT_DESCR
- Mrt-001
- MRT_TYPER
- Mrt-001
- SUPPLIERPK
- 1
- MRT_STATUSR
- I
- CURRENCY_CODERPK
- STD-MRT-001
- QUANTITY_TYPER
- Mrt-001
- INVENTORY_TYPER
- Mrt-001
- TSF_NOT_AFTER_DATER
- 2026-01-01
- CLOSE_DATE
- 2026-01-01
- RTV_REASON
- Mrt-001
- RESTOCK_PCT
- 11.0000
- COMMENT_DESC
- Mrt-001
- REF_AUTH_NUM
- Mrt-001
- INCLUDE_WH_INV
- Mrt-001
- RTV_CREATE_DATE
- 2026-01-01
- TSF_CREATE_DATE
- 2026-01-01
- CREATE_RTV_STATUS
- ACTIVE
- RTV_NOT_AFTER_DATE
- 2026-01-01