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/StrVnsModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrVnsModVo 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 StrVnsModVo 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
shipment_id number15 0 1 Vendor shipment identifier. If left empty, indicates creating new vendor shipment, otherwise will attempt to modify shipment based on identifier. RTV_SHIP ID NUMBER 15,0 No The unique identifier for the RTV Shipment
store_id number10 1 1 Store identifier of store that is returning the stock. RTV_SHIP STORE_ID NUMBER 10,0 Yes The store id the RTV Shipment is created from
supplier_id number10 1 1 Supplier identifier of the supplier being returned to. RTV_SHIP SUPPLIER_ID NUMBER 10,0 Yes The supplier to which the RTV Shipment is created
return_context rtv_ship_context_mod 1 1 A context for the return. Valid values are INVALID_DELIVERY, SEASONAL, DAMAGED, NONE. RTV_SHIP CONTEXT NUMBER 15,0 Yes Unique Identifier for vendor shipment context
authorization_code varchar212 0 1 Authorization code. This value may be required depending on system settings. RTV_SHIP AUTHORIZATION_CODE VARCHAR2 12 No The vendor authorization number
not_after_date xs:dateTime 0 1 Date after which the vendor shipment is no longer valid. RTV_SHIP NOT_AFTER_DATE DATE Fill column length. No The not after date for the RTV Shipment
StrVnsModBol * 0 1 Information about bill of lading for the vendor shipment.
StrVnsModNote * 0 1000 Collection of vendor shipment notes that will be added to the vendor shipment.

XML-Schema Name:StrVnsModBol 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 StrVnsModBol 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 Motive identifier SHIPMENT_BOL MOTIVE VARCHAR2 120 No this field contains the motive
bill_of_lading_tax_id varchar218 0 1 Tax identifier SHIPMENT_BOL TAX_ID VARCHAR2 18 No this field contains the tax id of the supplier
requested_pickup_date xs:dateTime 0 1 Date pickup is requested SHIPMENT_BOL REQUESTED_PICKUP_DATE DATE Fill column length. No the field contains the requested pickup date
carrier_type rtv_ship_mod_carrier_type 1 1 Type of carrier used for shipment 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 varchar24 0 1 Carrier code of carrier responsible for shipment SHIPMENT_CARRIER CODE VARCHAR2 4 No unique code identifier for a carrier
carrier_service_code varchar26 0 1 Service code of shipment service being used SHIPMENT_BOL SHIP_CARRIER_SERVICE_ID NUMBER 10,0 No Fill this description.
carrier_name varchar2128 0 1 Name of the carrier SHIPMENT_BOL THIRD_PARTY_NAME VARCHAR2 240 No this field contains the name of the third party
carrier_address varchar22000 0 1 Address of the carrier SHIPMENT_BOL THIRD_PARTY_ADDRESS VARCHAR2 2000 No this field contains the address of the third party
ship_to_address_type rtv_ship_mod_address_type 1 1 Address type of the destination address Valid values are BUSINESS, POSTAL, RETURNS, ORDER, INVOICE, REMITTANCE, BILLING, DELIVERY. SHIPMENT_BOL SHIP_TO_ADDRESS_TYPE VARCHAR2 2 Yes "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 Alternate ship to address if substituted for normal address SHIPMENT_BOL ALT_DESTINATION_ADDRESS VARCHAR2 2000 No this field contains the alternate destination address

XML-Schema Name:StrVnsModNote 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 StrVnsModNote 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
note varchar22000 0 1 Note associated to the vendor shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.