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

XML-Schema Name:StrVnsModVo 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 StrVnsModVo 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
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
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 No The not after date for the RTV Shipment
context_id number18 0 1 Context type identifier. RTV_SHIP CONTEXT_ID NUMBER 18 No The context identifier
context_value varchar225 0 1 Context type value. RTV_SHIP CONTEXT_VALUE VARCHAR2 25 No This field holds value related to the context type.
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:16.0.030 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 BDI) 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 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 2 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 Identifier representing the carrier service for the shipment.
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:16.0.030 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 BDI) 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. NOTES TEXT VARCHAR2 2000 Yes The note's text.