Retail Integration Mappings Report Release:16.0.030

(Store Inventory Management)

Application Store Inventory Management Target Name Space http://www.oracle.com/retail/integration/base/bo/StrVrnDesc/v1 Version 1.0 Description XSD Structure StrVrnDesc GeoAddrDesc StrVrnItm

XML-Schema Name:StrVrnDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrVrnDesc in SIM application. SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description return_id number15 1 1 Vendor return unique identifie.r RTV ID NUMBER 15,0 Yes unique identifier of a vendor return external_id varchar2128 0 1 External system identifier. RTV EXTERNAL_ID VARCHAR2 128 No The external identifier store_id number10 1 1 Store identifier of store that is returning the stock. RTV STORE_ID NUMBER 10,0 Yes store identifier supplier_id number10 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 number. RTV AUTHORIZATION_NUMBER VARCHAR2 12 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 No The return is not allowed after this date create_user_name varchar2128 0 1 User who created this vendor return. RTV CREATE_USER VARCHAR2 128 Yes the user who created the return create_date xs:dateTime 0 1 Date on which the vendor return was created in GMT timezone. RTV CREATE_DATE DATE Yes the date that the return was created update_user_name varchar2128 0 1 User who last updated this vendor return. RTV UPDATE_USER VARCHAR2 128 Yes The user who created the record update_date xs:dateTime 0 1 Date on which the vendor return was last updated in GMT timezone. RTV UPDATE_DATE DATE Yes The update date approved_user_name varchar2128 0 1 User who approved this vendor return. RTV APPROVED_USER VARCHAR2 128 No The user who approved the return approved_date xs:dateTime 0 1 Date on which the vendor return was approved in GMT timezone. RTV APPROVED_DATE DATE No The date the return was approved closed_user_name varchar2128 0 1 User who closed this vendor return. RTV CLOSED_USER VARCHAR2 128 No the user who closed the return closed_user_date xs:dateTime 0 1 Date on which the vendor return was closed in GMT timezone. RTV CLOSED_DATE DATE No the date the return was closed GeoAddrDesc:GeoAddrDesc * 0 1 Address fields. NA NA NA NA NA NA StrVrnItm * 0 unbounded Collection of vendor return line items.

XML-Schema Name:GeoAddrDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for GeoAddrDesc in SIM application. SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description addr_id number22 0 1 Unique identifier for this address entry. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. addr_type addr_type 0 1 The address type can be any of the enumerated values 'Home','Office','Billing','Shipping' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_alias varchar2250 0 1 Alias for this address, example 'My Event Venue' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_1 varchar2240 1 1 Contains Address Line 1. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_2 varchar2240 0 1 Contains Address Line 2. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_3 varchar2240 0 1 Contains Address Line 3. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_4 varchar2240 0 1 Contains Address Line 4. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_5 varchar2240 0 1 Contains Address Line 5. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. city varchar2120 0 1 Contains the city where the address is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 County where this address is located Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state_code varchar23 0 1 Contains the postal abbreviation for the state, province or territory in which the address is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state_name varchar2120 0 1 Indicates the state, province or territory name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_code varchar23 0 1 Contains the postal abbreviation of the country in which the address is located Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_name varchar2120 0 1 Indicates the Country name For e.g Brazil,United States Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. postal_code varchar230 0 1 Contains the postal code for the address Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_preference_code varchar2120 0 1 Indicates the type of communications being sent to this address. Sample values are order information only, promotion info only, marketing material, no contact Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. validated_addr_flag xs:boolean 0 1 If the retailer integrates with an external system that does address validation at the time of adding this record, this flag is set to true. Absence of this element should indicate "false". Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:StrVrnItm Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrVrnItm in SIM application. SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description line_id number15 1 1 Line item unique identifier RTV_LINE_ITEM ID NUMBER 15,0 Yes unique identifier of a return line item item_id varchar225 1 1 Sku number RTV_LINE_ITEM ITEM_ID VARCHAR2 25 Yes item identifier description varchar2400 0 1 Description of the item. STORE_ITEM SHORT_DESCRIPTION VARCHAR2 255 No the textural description of the item and its characteristics reason_id number15 1 1 Vendor return reason unique identifier. RTV_LINE_ITEM SHIPMENT_REASON_ID NUMBER 15,0 Yes The shipment reason id case_size number10_2 1 1 Case size associated with the item. RTV_LINE_ITEM CASE_SIZE NUMBER 10,2 Yes The pack size quantity_requested number20_4 0 1 Quantity requested to return. RTV_LINE_ITEM QUANTITY_REQUESTED NUMBER 20,4 No Requested Quantity quantity_approved number20_4 0 1 Quantity approved to return. RTV_LINE_ITEM QUANTITY_APPROVED NUMBER 20,4 No Approved quantity quantity_in_shipping number20_4 0 1 Quantity in-shipping for return. RTV_LINE_ITEM QUANTITY_SHIPPING NUMBER 20,4 No In shipping quantity quantity_shipped number20_4 0 1 Quantity shipped for return. RTV_LINE_ITEM QUANTITY_SHIPPED NUMBER 20,4 No Shipped Quantity external_sequence number15 0 1 Sequence number from external system if line item not created within SIM. RTV_LINE_ITEM EXTERNAL_ID NUMBER 15,0 No External identifier