Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StrVrnHdrColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrVrnHdrColDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrVrnHdrColDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
StrVrnHdrDesc:StrVrnHdrDesc * 0 unbounded Collection of vendor return headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:StrVrnHdrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrVrnHdrDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
return_id number12 1 1 Unique identifier of the vendor return. RTV ID NUMBER 15,0 No unique identifier of a vendor return
store_id number10 1 1 Store identifier RTV STORE_ID NUMBER 10,0 Yes store identifier
external_id varchar2128 0 1 External system identifier RTV EXTERNAL_ID VARCHAR2 128 No The external identifier
supplier_id varchar2128 1 1 Supplier identifier RTV SUPPLIER_ID NUMBER 10,0 Yes supplier identifier
status rtv_status 1 1 Current status Valid values are REQUESTED, REQUEST_IN_PROGRESS, RTV_IN_PROGRESS, APPROVED, IN_SHIPPING, COMPLETED, REJECTED, CANCELED_REQUEST, CANCELED_RTV, UNKNOWN. RTV STATUS NUMBER 2,0 Yes status of the return. 1 - Requested, 2-In Progress, 3-Canceled Request, 4-Rejected,5-Approved,6-In Shipping,7-Completed,8-Canceled
authorization_number varchar212 0 1 Authorization code RTV AUTHORIZATION_NUMBER NUMBER 2,0 No The vendor authorization number for when a number is required when a return being returned to a vendor
not_after_date xs:dateTime 0 1 Date after which the return in no longer valid RTV NOT_AFTER_DATE DATE Fill column length. No The return is not allowed after this date
number_of_line_items number10 1 1 Number of line items on the vendor return. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.