Return to Vendor Detail
In ScopeTechnical: RTV_DETAIL | ID: OR-ITM-RTV_DETAIL-RETURN_TO_VENDOR_DETAIL
Stores item level details for items on the RTV order.
See how this object fits into Item 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
- RTV_DETAIL
Field Definitions(5)
Rules & Considerations(35)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | SEQ_NORPK | RTV_ORDER_NORPK | REASON | SHIPMENT | CREATE_ID | UNIT_COST | INV_STATUS | PUBLISH_IND | RESTOCK_PCT | QTY_RETURNED | QTY_CANCELLED | QTY_REQUESTED | LAST_UPDATE_ID | CREATE_DATETIME | ORIGINAL_UNIT_COST | UPDATED_BY_RMS_IND | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | SAMPLE | 1 | SAMPLE | 1.0000 | 1 | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 2026-01-01 | 1.0000 | S | 2026-01-01 |
| default | Rtv Detail-002-ALT | 4 | 4 | U | 3 | APP_USER_ID | 12.5000 | 3 | N | 12.5000 | 12.5000 | 12.5000 | 12.5000 | APP_USER_ID | 2026-01-03 | 12.5000 | Y | 2026-01-03 |
| default | Rtv Detail-003-EDGE | 6 | 6 | W | 5 | USERENV | 14.0000 | 5 | N | 14.0000 | 14.0000 | 14.0000 | 14.0000 | USERENV | 2026-01-05 | 14.0000 | Y | 2026-01-05 |
Example values from field definitions
- ITEMR
- SAMPLE
- SEQ_NORPK
- 1
- RTV_ORDER_NORPK
- 1
- REASON
- SAMPLE
- SHIPMENT
- 1
- CREATE_ID
- SAMPLE
- UNIT_COST
- 1.0000
- INV_STATUS
- 1
- PUBLISH_IND
- S
- RESTOCK_PCT
- 1.0000
- QTY_RETURNED
- 1.0000
- QTY_CANCELLED
- 1.0000
- QTY_REQUESTED
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- ORIGINAL_UNIT_COST
- 1.0000
- UPDATED_BY_RMS_IND
- S
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- ITEMR
- Rtv Detail-002-ALT
- SEQ_NORPK
- 4
- RTV_ORDER_NORPK
- 4
- REASON
- U
- SHIPMENT
- 3
- CREATE_ID
- APP_USER_ID
- UNIT_COST
- 12.5000
- INV_STATUS
- 3
- PUBLISH_IND
- N
- RESTOCK_PCT
- 12.5000
- QTY_RETURNED
- 12.5000
- QTY_CANCELLED
- 12.5000
- QTY_REQUESTED
- 12.5000
- LAST_UPDATE_ID
- APP_USER_ID
- CREATE_DATETIME
- 2026-01-03
- ORIGINAL_UNIT_COST
- 12.5000
- UPDATED_BY_RMS_IND
- Y
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- ITEMR
- Rtv Detail-003-EDGE
- SEQ_NORPK
- 6
- RTV_ORDER_NORPK
- 6
- REASON
- W
- SHIPMENT
- 5
- CREATE_ID
- USERENV
- UNIT_COST
- 14.0000
- INV_STATUS
- 5
- PUBLISH_IND
- N
- RESTOCK_PCT
- 14.0000
- QTY_RETURNED
- 14.0000
- QTY_CANCELLED
- 14.0000
- QTY_REQUESTED
- 14.0000
- LAST_UPDATE_ID
- USERENV
- CREATE_DATETIME
- 2026-01-05
- ORIGINAL_UNIT_COST
- 14.0000
- UPDATED_BY_RMS_IND
- Y
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 53
- Governed Rule Count
- 35