Return to Vendor Shipment
In ScopeTechnical: RTV_SHIP | ID: OR-STO-RTV_SHIP-RETURN_TO_VENDOR_SHIPMENT
this table will contain RTV Shipment record.
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
Field Definitions(5)
Rules & Considerations(45)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | STORE_IDR | SUPPLIER_IDR | RTV_ID | STATUS | CONTEXT | IMPORT_ID | CONTEXT_ID | CREATE_DATE | CREATE_USER | SUBMIT_DATE | SUBMIT_USER | UPDATE_DATE | UPDATE_USER | COUNTRY_CODE | CONTEXT_VALUE | DISPATCH_DATE | DISPATCH_USER | DISPLAY_CARTON | NOT_AFTER_DATE | RTV_EXTERNAL_ID | SHIPMENT_BOL_ID | FISCAL_DOC_NUMBER | FISCAL_DOC_REF_ID | FISCAL_DOC_STATUS | AUTHORIZATION_CODE | FISCAL_DOC_PRINT_URL | FISCAL_DOC_REQUEST_ID | FISCAL_DOC_REJECT_REASON |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | 1 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | SAM | SAMPLE | 2026-01-01 | SAMPLE | S | 2026-01-01 | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE |
| default | 3 | 1000000003 | 1000000003 | 1000000003 | 2 | — | ALT-RTV_SHIP-002 | 1000000003 | 2026-01-03 | Rtv Ship-002-ALT | 2026-01-03 | Rtv Ship-002-ALT | 2026-01-03 | 2026-01-02-ALT | ALT | Rtv Ship-002-ALT | 2026-01-03 | Rtv Ship-002-ALT | Y | 2026-01-03 | ALT-RTV_SHIP-002 | 1000000003 | Rtv Ship-002-ALT | 1000000003 | 2 | ALT-RTV_SHIP | Rtv Ship-002-ALT | 1000000003 | Rtv Ship-002-ALT |
| default | 5 | 1000000005 | 1000000005 | 1000000005 | 3 | — | EDGE-RTV_SHIP-003 | 1000000005 | 2026-01-05 | Rtv Ship-003-EDGE | 2026-01-05 | Rtv Ship-003-EDGE | 2026-01-05 | 2026-01-03-EDGE | EDG | Rtv Ship-003-EDGE | 2026-01-05 | Rtv Ship-003-EDGE | Y | 2026-01-05 | EDGE-RTV_SHIP-003 | 1000000005 | Rtv Ship-003-EDGE | 1000000005 | 3 | EDGE-RTV_SHI | Rtv Ship-003-EDGE | 1000000005 | Rtv Ship-003-EDGE |
Example values from field definitions
- IDRPK
- 1
- STORE_IDR
- 1
- SUPPLIER_IDR
- 1
- RTV_ID
- 1
- STATUS
- 1
- CONTEXT
- 1
- IMPORT_ID
- SAMPLE
- CONTEXT_ID
- 1
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- SUBMIT_DATE
- 2026-01-01
- SUBMIT_USER
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- COUNTRY_CODE
- SAM
- CONTEXT_VALUE
- SAMPLE
- DISPATCH_DATE
- 2026-01-01
- DISPATCH_USER
- SAMPLE
- DISPLAY_CARTON
- S
- NOT_AFTER_DATE
- 2026-01-01
- RTV_EXTERNAL_ID
- SAMPLE
- SHIPMENT_BOL_ID
- 1
- FISCAL_DOC_NUMBER
- SAMPLE
- FISCAL_DOC_REF_ID
- 1
- FISCAL_DOC_STATUS
- SAMPLE
- AUTHORIZATION_CODE
- SAMPLE
- FISCAL_DOC_PRINT_URL
- SAMPLE
- FISCAL_DOC_REQUEST_ID
- 1
- FISCAL_DOC_REJECT_REASON
- SAMPLE
default
- IDRPK
- 3
- STORE_IDR
- 1000000003
- SUPPLIER_IDR
- 1000000003
- RTV_ID
- 1000000003
- STATUS
- 2
- CONTEXT
- —
- IMPORT_ID
- ALT-RTV_SHIP-002
- CONTEXT_ID
- 1000000003
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Rtv Ship-002-ALT
- SUBMIT_DATE
- 2026-01-03
- SUBMIT_USER
- Rtv Ship-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- COUNTRY_CODE
- ALT
- CONTEXT_VALUE
- Rtv Ship-002-ALT
- DISPATCH_DATE
- 2026-01-03
- DISPATCH_USER
- Rtv Ship-002-ALT
- DISPLAY_CARTON
- Y
- NOT_AFTER_DATE
- 2026-01-03
- RTV_EXTERNAL_ID
- ALT-RTV_SHIP-002
- SHIPMENT_BOL_ID
- 1000000003
- FISCAL_DOC_NUMBER
- Rtv Ship-002-ALT
- FISCAL_DOC_REF_ID
- 1000000003
- FISCAL_DOC_STATUS
- 2
- AUTHORIZATION_CODE
- ALT-RTV_SHIP
- FISCAL_DOC_PRINT_URL
- Rtv Ship-002-ALT
- FISCAL_DOC_REQUEST_ID
- 1000000003
- FISCAL_DOC_REJECT_REASON
- Rtv Ship-002-ALT
default
- IDRPK
- 5
- STORE_IDR
- 1000000005
- SUPPLIER_IDR
- 1000000005
- RTV_ID
- 1000000005
- STATUS
- 3
- CONTEXT
- —
- IMPORT_ID
- EDGE-RTV_SHIP-003
- CONTEXT_ID
- 1000000005
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Rtv Ship-003-EDGE
- SUBMIT_DATE
- 2026-01-05
- SUBMIT_USER
- Rtv Ship-003-EDGE
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- COUNTRY_CODE
- EDG
- CONTEXT_VALUE
- Rtv Ship-003-EDGE
- DISPATCH_DATE
- 2026-01-05
- DISPATCH_USER
- Rtv Ship-003-EDGE
- DISPLAY_CARTON
- Y
- NOT_AFTER_DATE
- 2026-01-05
- RTV_EXTERNAL_ID
- EDGE-RTV_SHIP-003
- SHIPMENT_BOL_ID
- 1000000005
- FISCAL_DOC_NUMBER
- Rtv Ship-003-EDGE
- FISCAL_DOC_REF_ID
- 1000000005
- FISCAL_DOC_STATUS
- 3
- AUTHORIZATION_CODE
- EDGE-RTV_SHI
- FISCAL_DOC_PRINT_URL
- Rtv Ship-003-EDGE
- FISCAL_DOC_REQUEST_ID
- 1000000005
- FISCAL_DOC_REJECT_REASON
- Rtv Ship-003-EDGE
Rule Validation Summary
- Source Rule Count
- 63
- Governed Rule Count
- 45