Return to Vendor

In Scope

Technical: RTV | ID: OR-STO-RTV-RETURN_TO_VENDOR

Stores header level information of a vendor return.

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

Field Definitions(30)

Rules & Considerations(37)

Sample Load Data(4)

_scenario	IDRPK	STATUSR	STORE_IDRPK	CREATE_DATER	CREATE_USERR	ORIGIN_TYPER	SUPPLIER_IDRPK	UPDATE_DATER	UPDATE_USERR	EXTERNAL_LOCKEDR	IMPORT_ID	CONTEXT_ID	CLOSED_DATE	CLOSED_USER	EXTERNAL_ID	RTV_TYPE_ID	ADDRESS_CITY	COUNTRY_CODE	APPROVED_DATE	APPROVED_USER	CONTEXT_VALUE	IMPORT_RTV_ID	ADDRESS_LINE_1	ADDRESS_LINE_2	ADDRESS_LINE_3	NOT_AFTER_DATE	ADDRESS_COUNTRY	ADDRESS_POSTAL_CODE	AUTHORIZATION_NUMBER
Example values from field definitions	1	1	1	2026-01-01	SAMPLE	1	1	2026-01-01	SAMPLE	S	SAMPLE	1	2026-01-01	SAMPLE	SAMPLE	1	SAMPLE	SAM	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAM	SAMPLE	SAMPLE

Example values from field definitions

IDRPK: 1
STATUSR: 1
STORE_IDRPK: 1
CREATE_DATER: 2026-01-01
CREATE_USERR: SAMPLE
ORIGIN_TYPER: 1
SUPPLIER_IDRPK: 1
UPDATE_DATER: 2026-01-01
UPDATE_USERR: SAMPLE
EXTERNAL_LOCKEDR: S
IMPORT_ID: SAMPLE
CONTEXT_ID: 1
CLOSED_DATE: 2026-01-01
CLOSED_USER: SAMPLE
EXTERNAL_ID: SAMPLE
RTV_TYPE_ID: 1
ADDRESS_CITY: SAMPLE
COUNTRY_CODE: SAM
APPROVED_DATE: 2026-01-01
APPROVED_USER: SAMPLE
CONTEXT_VALUE: SAMPLE
IMPORT_RTV_ID: SAMPLE
ADDRESS_LINE_1: SAMPLE
ADDRESS_LINE_2: SAMPLE
ADDRESS_LINE_3: SAMPLE
NOT_AFTER_DATE: 2026-01-01
ADDRESS_COUNTRY: SAM
ADDRESS_POSTAL_CODE: SAMPLE
AUTHORIZATION_NUMBER: SAMPLE

Rule Validation Summary

Source Rule Count: 51
Governed Rule Count: 37