Rtv Head

In Scope

Technical: RTV_HEAD | ID: OR-MFCS-RTV_HEAD

Stores header level information for all the Return to Vendor (RTV) orders.

See how this object fits into Supplier Management

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_HEAD

Field Definitions(31)

Rules & Considerations(85)

Sample Load Data(4)

_scenario	WHR	STORER	MRT_NOPK	SUPPLIERRPK	CREATE_IDR	ORIGIN_INDR	STATUS_INDR	CREATED_DATER	RTV_ORDER_NORPK	SHIP_TO_CITYR	SHIP_TO_ADD_1R	LAST_UPDATE_IDR	SHIP_TO_COUNTRY_IDR	LAST_UPDATE_DATETIMER	DEPT	ITEM	STATE	COURIER	FREIGHT	EXT_REF_NO	RESTOCK_PCT	COMMENT_DESC	RESTOCK_COST	RET_AUTH_NUM	SHIP_TO_ADD_2	SHIP_TO_ADD_3	SHIP_TO_PCODE	COMPLETED_DATE	NOT_AFTER_DATE	TOTAL_ORDER_AMT	SHIP_TO_JURISDICTION_CODE
default	9001	1001	2	1	RETAIL_CTX	MAN	05	2026-01-01	2	Rtv Head-001	Rtv Head-001	RETAIL_CTX	STD-RTV_HEAD-001	2026-01-01	1001	Rtv Head-001	Rtv Head-001	Rtv Head-001	11.0000	Rtv Head-001	11.0000	Rtv Head-001	11.0000	Rtv Head-001	Rtv Head-001	Rtv Head-001	Rtv Head-001	2026-01-01	2026-01-01	11.0000	STD-RTV_HEAD-001

default

WHR: 9001
STORER: 1001
MRT_NOPK: 2
SUPPLIERRPK: 1
CREATE_IDR: RETAIL_CTX
ORIGIN_INDR: MAN
STATUS_INDR: 05
CREATED_DATER: 2026-01-01
RTV_ORDER_NORPK: 2
SHIP_TO_CITYR: Rtv Head-001
SHIP_TO_ADD_1R: Rtv Head-001
LAST_UPDATE_IDR: RETAIL_CTX
SHIP_TO_COUNTRY_IDR: STD-RTV_HEAD-001
LAST_UPDATE_DATETIMER: 2026-01-01
DEPT: 1001
ITEM: Rtv Head-001
STATE: Rtv Head-001
COURIER: Rtv Head-001
FREIGHT: 11.0000
EXT_REF_NO: Rtv Head-001
RESTOCK_PCT: 11.0000
COMMENT_DESC: Rtv Head-001
RESTOCK_COST: 11.0000
RET_AUTH_NUM: Rtv Head-001
SHIP_TO_ADD_2: Rtv Head-001
SHIP_TO_ADD_3: Rtv Head-001
SHIP_TO_PCODE: Rtv Head-001
COMPLETED_DATE: 2026-01-01
NOT_AFTER_DATE: 2026-01-01
TOTAL_ORDER_AMT: 11.0000
SHIP_TO_JURISDICTION_CODE: STD-RTV_HEAD-001

Rtv Head | undefined | Oracle Retail