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/StrVrnModVo/v1 Version 1.0 Description XSD Structure StrVrnModVo GeoAddrDesc StrVrnItmMod

XML-Schema Name:StrVrnModVo 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 StrVrnModVo 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 0 1 Vendor Return identifier. If left empty, indicates creating new vendor return, otherwise will attempt to modify vendor return based on identifier. 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 of the return. This value cannot be altered on update. RTV EXTERNAL_ID VARCHAR2 128 No The external identifier supplier_id number10 1 1 Supplier identifier. RTV SUPPLIER_ID NUMBER 10,0 Yes supplier identifier 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 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. context rtv_context 1 1 Current status Valid values are INVALID_DELIVERY, SEASONAL, DAMAGED, NONE, UNKNOWN. RTV RTV_TYPE_ID NUMBER 15,0 Yes unique identifier of a vendor return type GeoAddrDesc:GeoAddrDesc * 0 1 Address fields. NA NA NA NA NA NA removed_line_id_col number12 0 5000 Collections of removed line items indicated by their unique identifier. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description. StrVrnItmMod * 0 1000 Collection of vendor return line items containing modified information.

XML-Schema Name:GeoAddrDesc 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 GeoAddrDesc 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 address_alias varchar2120 0 1 Contains the alias for this address Fill application table name. Fill table column name. RIB or/and RSB or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL 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 or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:StrVrnItmMod 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 StrVrnItmMod 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 line_id number15 0 1 Line Item unique identifier. If left empty, indicates new line item, otherwise will attempt to modify existing line item. RTV_LINE_ITEM ID NUMBER 15,0 No unique identifier of a return line item item_id varchar225 1 1 Sku number of the item. This value cannot be altered for an existing line item. RTV_LINE_ITEM ITEM_ID VARCHAR2 25 Yes item identifier reason_id number15 1 1 Vendor return reason unique identifier. This value cannot be altered for an existing line item. RTV_LINE_ITEM SHIPMENT_REASON_ID NUMBER 15,0 Yes The shipment reason id case_size number10_2 0 1 Case size associated with the item on this line item. The value will be defaulted by the service if a value is not supplied. RTV_LINE_ITEM CASE_SIZE NUMBER 10,2 No The pack size quantity_approved number20_4 1 1 Quantity approved to return. RTV_LINE_ITEM QUANTITY_APPROVED NUMBER 20,4 Yes Approved Quantity external_sequence number15 0 1 Sequence number from external system. RTV_LINE_ITEM EXTERNAL_ID NUMBER 15,0 No External identifier