Retail Integration Bus Mappings Report Release:13.2.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/RTVReqRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:RTVReqRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For RTVReqRef
Table Name Column Name API Type Column Length API Required API Description
rtv_order_no number10 1 1 Contains the number that uniquely identifies the return to vendor within the system. RETURN ID NUMBER 12,0 Yes Contains the number that uniquely identifies the return to vendor within the system.
RTVReqDtlRef * 0 unbounded Description is not available.
ExtOfRTVReqRef:ExtOfRTVReqRef * 0 1 Provide an extension hook to customize RTVReqRef. NA NA NA NA NA NA
LocOfRTVReqRef:LocOfRTVReqRef * 0 1 Provide an extension hook to localize RTVReqRef. NA NA NA NA NA NA

XML-Schema Name:RTVReqDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For RTVReqDtlRef
Table Name Column Name API Type Column Length API Required API Description
seq_no number8 1 1 This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field. RETURN_LINE_ITEM EXTERNAL_ID NUMBER 12,0 No This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field.
item varchar225 0 1 Unique identifier for the item on the RTV. RETURN_LINE_ITEM ITEM_ID varchar2 25 Yes Unique identifier for the item on the RTV.
ExtOfRTVReqRef:ExtOfRTVReqDtlRef * 0 1 Provide an extension hook to customize RTVReqDtlRef. NA NA NA NA NA NA
LocOfRTVReqRef:LocOfRTVReqDtlRef * 0 1 Provide an extension hook to localize RTVReqDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfRTVReqDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfRTVReqDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfRTVReqDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfRTVReqDtlRef
Table Name Column Name API Type Column Length API Required API Description
InRTVReqRef:InRTVReqDtlRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrRTVReqRef:BrRTVReqDtlRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfRTVReqRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfRTVReqRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfRTVReqRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfRTVReqRef
Table Name Column Name API Type Column Length API Required API Description
InRTVReqRef:InRTVReqRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrRTVReqRef:BrRTVReqRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA