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(5)

Rules & Considerations(39)

Sample Load Data(4)

_scenario	IDRPK	STORE_IDR	EXTERNAL_LOCKEDR	STATUS	IMPORT_ID	CONTEXT_ID	CLOSED_DATE	CLOSED_USER	CREATE_DATE	CREATE_USER	EXTERNAL_ID	ORIGIN_TYPE	RTV_TYPE_ID	SUPPLIER_ID	UPDATE_DATE	UPDATE_USER	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	S	1	SAMPLE	1	2026-01-01	SAMPLE	2026-01-01	SAMPLE	SAMPLE	1	1	1	2026-01-01	SAMPLE	SAMPLE	SAM	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAM	SAMPLE	SAMPLE
default	3	1000000003	N	2	ALT-RTV-002	1000000003	2026-01-03	Rtv-002-ALT	2026-01-03	Rtv-002-ALT	ALT-RTV-002	3	—	1000000003	2026-01-03	2026-01-02-ALT	Rtv-002-ALT	ALT	2026-01-03	Rtv-002-ALT	Rtv-002-ALT	ALT-RTV-002	Rtv-002-ALT	Rtv-002-ALT	Rtv-002-ALT	2026-01-03	Rtv	ALT-RTV-002	Rtv-002-ALT
default	5	1000000005	N	3	EDGE-RTV-003	1000000005	2026-01-05	Rtv-003-EDGE	2026-01-05	Rtv-003-EDGE	EDGE-RTV-003	5	—	1000000005	2026-01-05	2026-01-03-EDGE	Rtv-003-EDGE	EDG	2026-01-05	Rtv-003-EDGE	Rtv-003-EDGE	EDGE-RTV-003	Rtv-003-EDGE	Rtv-003-EDGE	Rtv-003-EDGE	2026-01-05	Rtv	EDGE-RTV-003	Rtv-003-EDGE

Example values from field definitions

IDRPK: 1
STORE_IDR: 1
EXTERNAL_LOCKEDR: S
STATUS: 1
IMPORT_ID: SAMPLE
CONTEXT_ID: 1
CLOSED_DATE: 2026-01-01
CLOSED_USER: SAMPLE
CREATE_DATE: 2026-01-01
CREATE_USER: SAMPLE
EXTERNAL_ID: SAMPLE
ORIGIN_TYPE: 1
RTV_TYPE_ID: 1
SUPPLIER_ID: 1
UPDATE_DATE: 2026-01-01
UPDATE_USER: SAMPLE
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

default

IDRPK: 3
STORE_IDR: 1000000003
EXTERNAL_LOCKEDR: N
STATUS: 2
IMPORT_ID: ALT-RTV-002
CONTEXT_ID: 1000000003
CLOSED_DATE: 2026-01-03
CLOSED_USER: Rtv-002-ALT
CREATE_DATE: 2026-01-03
CREATE_USER: Rtv-002-ALT
EXTERNAL_ID: ALT-RTV-002
ORIGIN_TYPE: 3
RTV_TYPE_ID: —
SUPPLIER_ID: 1000000003
UPDATE_DATE: 2026-01-03
UPDATE_USER: 2026-01-02-ALT
ADDRESS_CITY: Rtv-002-ALT
COUNTRY_CODE: ALT
APPROVED_DATE: 2026-01-03
APPROVED_USER: Rtv-002-ALT
CONTEXT_VALUE: Rtv-002-ALT
IMPORT_RTV_ID: ALT-RTV-002
ADDRESS_LINE_1: Rtv-002-ALT
ADDRESS_LINE_2: Rtv-002-ALT
ADDRESS_LINE_3: Rtv-002-ALT
NOT_AFTER_DATE: 2026-01-03
ADDRESS_COUNTRY: Rtv
ADDRESS_POSTAL_CODE: ALT-RTV-002
AUTHORIZATION_NUMBER: Rtv-002-ALT

default

IDRPK: 5
STORE_IDR: 1000000005
EXTERNAL_LOCKEDR: N
STATUS: 3
IMPORT_ID: EDGE-RTV-003
CONTEXT_ID: 1000000005
CLOSED_DATE: 2026-01-05
CLOSED_USER: Rtv-003-EDGE
CREATE_DATE: 2026-01-05
CREATE_USER: Rtv-003-EDGE
EXTERNAL_ID: EDGE-RTV-003
ORIGIN_TYPE: 5
RTV_TYPE_ID: —
SUPPLIER_ID: 1000000005
UPDATE_DATE: 2026-01-05
UPDATE_USER: 2026-01-03-EDGE
ADDRESS_CITY: Rtv-003-EDGE
COUNTRY_CODE: EDG
APPROVED_DATE: 2026-01-05
APPROVED_USER: Rtv-003-EDGE
CONTEXT_VALUE: Rtv-003-EDGE
IMPORT_RTV_ID: EDGE-RTV-003
ADDRESS_LINE_1: Rtv-003-EDGE
ADDRESS_LINE_2: Rtv-003-EDGE
ADDRESS_LINE_3: Rtv-003-EDGE
NOT_AFTER_DATE: 2026-01-05
ADDRESS_COUNTRY: Rtv
ADDRESS_POSTAL_CODE: EDGE-RTV-003
AUTHORIZATION_NUMBER: Rtv-003-EDGE

Rule Validation Summary

Source Rule Count: 53
Governed Rule Count: 39