Return to Vendor Shipment Line Item
In ScopeTechnical: RTV_SHIP_LINE_ITEM | ID: OR-STO-RTV_SHIP_LINE_ITEM-RETURN_TO_VENDOR_SHIPMENT_LINE_ITEM
this table will contain RTV Shipment line item records.
See how this object fits into Store Operations
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_SHIP_LINE_ITEM
Field Definitions(5)
Rules & Considerations(23)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDR | RTV_SHIP_IDR | RTV_SHIP_CARTON_IDR | QUANTITY | CASE_SIZE | EXTERNAL_ID | RTV_EXTERNAL_ID | SHIPMENT_REASON_ID |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 1.0000 | 1.00 | 1 | SAMPLE | 1 |
| default | 3 | ALT-RTV_SHIP-002 | 1000000003 | 1000000003 | 1000000003 | 12.5000 | 12.50 | — | ALT-RTV_SHIP-002 | 1000000003 |
| default | 5 | EDGE-RTV_SHIP-003 | 1000000005 | 1000000005 | 1000000005 | 14.0000 | 14.00 | — | EDGE-RTV_SHIP-003 | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- STORE_IDR
- 1
- RTV_SHIP_IDR
- 1
- RTV_SHIP_CARTON_IDR
- 1
- QUANTITY
- 1.0000
- CASE_SIZE
- 1.00
- EXTERNAL_ID
- 1
- RTV_EXTERNAL_ID
- SAMPLE
- SHIPMENT_REASON_ID
- 1
default
- IDRPK
- 3
- ITEM_IDR
- ALT-RTV_SHIP-002
- STORE_IDR
- 1000000003
- RTV_SHIP_IDR
- 1000000003
- RTV_SHIP_CARTON_IDR
- 1000000003
- QUANTITY
- 12.5000
- CASE_SIZE
- 12.50
- EXTERNAL_ID
- —
- RTV_EXTERNAL_ID
- ALT-RTV_SHIP-002
- SHIPMENT_REASON_ID
- 1000000003
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-RTV_SHIP-003
- STORE_IDR
- 1000000005
- RTV_SHIP_IDR
- 1000000005
- RTV_SHIP_CARTON_IDR
- 1000000005
- QUANTITY
- 14.0000
- CASE_SIZE
- 14.00
- EXTERNAL_ID
- —
- RTV_EXTERNAL_ID
- EDGE-RTV_SHIP-003
- SHIPMENT_REASON_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 23