Rtv

In Scope

Technical: RTV | ID: OR-SIOCS-RTV

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

Target Structure

Load Approach: Table
Target Objects: RTV

Field Definitions(28)

Rules & Considerations(73)

Sample Load Data(4)

_scenario	IDRPK	STATUSR	STORE_IDRPK	CREATE_DATER	CREATE_USERR	ORIGIN_TYPER	SUPPLIER_IDPK	UPDATE_DATER	UPDATE_USERR	EXTERNAL_LOCKEDR	IMPORT_ID	CONTEXT_ID	CLOSED_DATE	CLOSED_USER	EXTERNAL_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
default	1	1	1000000001	2026-01-01	Rtv-001	01	1000000001	2026-01-01	2026-01-01	N	STD-RTV-001	1000000001	2026-01-01	Rtv-001	STD-RTV-001	Rtv-001	STD-RTV-001	2026-01-01	Rtv-001	Rtv-001	STD-RTV-001	Rtv-001	Rtv-001	Rtv-001	2026-01-01	Rtv-001	STD-RTV-001	Rtv-001

default

IDRPK: 1
STATUSR: 1
STORE_IDRPK: 1000000001
CREATE_DATER: 2026-01-01
CREATE_USERR: Rtv-001
ORIGIN_TYPER: 01
SUPPLIER_IDPK: 1000000001
UPDATE_DATER: 2026-01-01
UPDATE_USERR: 2026-01-01
EXTERNAL_LOCKEDR: N
IMPORT_ID: STD-RTV-001
CONTEXT_ID: 1000000001
CLOSED_DATE: 2026-01-01
CLOSED_USER: Rtv-001
EXTERNAL_ID: STD-RTV-001
ADDRESS_CITY: Rtv-001
COUNTRY_CODE: STD-RTV-001
APPROVED_DATE: 2026-01-01
APPROVED_USER: Rtv-001
CONTEXT_VALUE: Rtv-001
IMPORT_RTV_ID: STD-RTV-001
ADDRESS_LINE_1: Rtv-001
ADDRESS_LINE_2: Rtv-001
ADDRESS_LINE_3: Rtv-001
NOT_AFTER_DATE: 2026-01-01
ADDRESS_COUNTRY: Rtv-001
ADDRESS_POSTAL_CODE: STD-RTV-001
AUTHORIZATION_NUMBER: Rtv-001

Rtv | undefined | Oracle Retail