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

XML-Schema Name:StkRtnModVo Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StkRtnModVo 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 Return identifier. If left empty, indicates creating new stock return, otherwise will attempt to modify return based on identifier. RETURN ID NUMBER 12,0 Yes unique identifier of a return
store_id number10 1 1 Store identifier RETURN STORE_ID number 10,0 Yes store identifier
ship_to_entity_type StkRtnModEntityType 1 1 Destination entity type. This attribute is required on create. This value cannot be altered on update. Valid values are SUPPLIER, WAREHOUSE, FINISHER. RETURN TYPE number 4,0 Yes return source type. 1 - Supplier, 2 - Warehouse, 3 - Finisher
ship_to_entity_id varchar2128 1 1 Destination entity identifier. This value cannot be altered on update. RETURN SOURCE_ID varchar2 128 No supplier or warehouse or finisher reference identifier
authorization_code varchar212 0 1 Authorization code. This value may be required depending on system settings. RETURN AUTHORIZATION_NUMBER VARCHAR2 12 No the vendor authorization number for when a number is required when a return being returned to a vendor.
external_id varchar2128 0 1 External system identifier of the return. This value cannot be altered on update. RETURN EXTERNAL_ID VARCHAR2 128 No external identifier. ex this is external id from rms.
comments varchar22000 0 1 Comments associated to the stock return. This value will replace any comments currently associated to the stock return. RETURN COMMENTS VARCHAR2 2000 No comment or short description entered by the creator or processor of the return.
context_type_id varchar215 0 1 Context type identifier RETURN CONTEXT_TYPE_ID VARCHAR2 15 No This field hods the functional area code to which the return relates to. For example promotions. PROM - Promotion
context_value varchar225 0 1 Context value RETURN CONTEXT_VALUE VARCHAR2 25 No This field holds value relating to the context type, e.g promotion number.
use_available_inventory xs:boolean 0 1 If true, return will only allow usage of available inventory reason codes. If false, will only allow usage of unavailable inventory reason codes. RETURN_REASON USE_AVAILABLE varchar2 1 Yes Indicates if use available inventory.
StkRtnBolMod * 0 1 Information about bill of lading for the return.
StkRtnItmMod * 0 1000 Collection of return line items containing modified information.
removed_line_id_col number12 0 5000 Collections of removed line items indicated by their unique identifer Yes REMOVED LINE ITEMS

XML-Schema Name:StkRtnBolMod Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StkRtnBolMod 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
bill_of_lading_motive_id varchar2120 0 1 Bill of lading motive identifier SHIPMENT_BOL MOTIVE VARCHAR2 120 Yes this field contains the motive
bill_of_lading_tax_id varchar218 0 1 Bill of lading tax id SHIPMENT_BOL TAX_ID VARCHAR2` 18 No this field contains the tax id of the supplier
requested_pickup_date xs:dateTime 0 1 Bill of lading requested pickup date SHIPMENT_BOL REQUESTED_PICKUP_DATE DATE No the field contains the requested pickup date
carrier_role StkRtnModCarrierRole 1 1 Bill of lading carrier role Valid values are SENDER, RECEIVER, THIRD_PARTY. SHIPMENT_BOL CARRIER_ROLE VARCHAR2 12 Yes this field contains the type of carrier for the shipment
carrier_code varchar225 0 1 Bill of lading carrier code SHIPMENT_BOL Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
carrier_service_code varchar225 0 1 Bill of lading carrier service role SHIPMENT_CARRIER_SERVICE CODE VARCHAR2 6 Yes Unique identifier that represents the delivery service
carrier_name varchar2240 0 1 Bill of lading carrier name SHIPMENT_BOL THIRD_PARTY_NAME varchar2 240 No this field contains the name of the third party
carrier_address varchar22000 0 1 Bill of lading carrier address SHIPMENT_BOL THIRD_PARTY_ADDRESS VARCHAR2 2000 No this field contains the address of the third party
ship_to_address_type StkRtnModAddressType 1 1 Bill of lading destination address type Valid values are BUSINESS, POSTAL, RETURNS, ORDER, INVOICE, REMITTANCE. SHIPMENT_BOL SHIP_TO_ADDRESS_TYPE VARCHAR2 2 No The address type for the ship to address. valid values 01 - Business Address, 02 - Postal Address, 03 - Return Address, 04 - Order Address, 05 - Invoice Address, 06 - Remittance Address, 07 - Billing Address, 08 - Delivery Address
alternate_ship_to_address varchar22000 0 1 Bill of lading alternate destination address SHIPMENT_BOL ALT_DESTINATION_ADDRESS VARCHAR2 2000 No this field contains the alternate destination address
tracking_number varchar2128 0 1 Bill of lading tracking number SHIPMENT_BOL TRACKING_NUMBER VARCHAR2 128 No Holds the tracking number for the transaction.

XML-Schema Name:StkRtnItmMod Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StkRtnItmMod 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 number12 0 1 Line Item unique identifier. If left empty, indicates new line item, otherwise will attempt to modify existing line item. RETURN_LINE_ITEM ID NUMBER 12,0 Yes 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. RETURN_LINE_ITEM ITEM_ID VARCHAR2 25 Yes item identifier
reason_id number12 1 1 Return reason unique identifier. This value cannot be altered for an existing line item. RETURN_LINE_ITEM REASON_ID NUMBER 12,0 Yes REASON IDENTIFIER
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. RETURN_LINE_ITEM CASE_SIZE NUMBER 10,2 No pack size
quantity number20_4 1 1 Quantity returned. If UINs exist for the item, quantity will be overridden by UIN information. RETURN_LINE_ITEM QUANTITY NUMBER 20,4 No quantity
added_uin_col varchar2128 0 100 Universal Identifier Numbers to add to the line item. Yes ADDED SERIAL NUMBERS
removed_uin_col varchar2128 0 1000 Universal Identifier Numbers to remove from the line item. Yes removed serial numbers