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

XML-Schema Name:StrVnsDesc 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 StrVnsDesc 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 1 1 Unique identifier RTV_SHIP ID NUMBER 15,0 Yes 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. RTV_SHIP SUPPLIER_ID NUMBER 10,0 Yes The supplier to which the RTV Shipment is created
status rtv_ship_status 1 1 Current status Valid values are NEW, IN_PROGRESS, SUBMITTED, SHIPPED, CANCELED, UNKNOWN. RTV_SHIP STATUS NUMBER 2,0 Yes The status of the RTV Shipment. Valid values: 1- New, 2- In progress, 3- Submitted, 4- Shipped, 5- Canceled
return_context rtv_ship_context 1 1 A context for the return. Valid values are INVALID_DELIVERY, SEASONAL, DAMAGED, NONE, UNKNOWN. RTV_SHIP CONTEXT NUMBER 15,0 Yes Unique Identifier for vendor shipment context
authorization_code varchar212 0 1 Authorization code RTV_SHIP AUTHORIZATION_CODE VARCHAR2 12 No The vendor authorization number
not_after_date xs:dateTime 0 1 Date after which the vendor shipment in no longer valid RTV NOT_AFTER_DATE DATE Fill column length. No The return is not allowed after this date
doc_internal_id number12 0 1 Vendor return document unique identifier RTV_SHIP ID NUMBER 15,0 No unique identifier of a vendor return
doc_external_id varchar2128 0 1 External system identifier of the vendor return document RTV EXTERNAL_ID VARCHAR2 128 No The external identifier
create_date xs:dateTime 1 1 Date the vendor shipment was created in GMT timezone RTV_SHIP CREATE_DATE DATE Fill column length. Yes The create date of the RTV Shipment
create_user varchar2128 1 1 Create user of the vendor shipment RTV_SHIP CREATE_USER VARCHAR2 128 Yes The user who created the RTV Shipment
update_date xs:dateTime 1 1 Update the vendor shipment was dispatched in GMT timezone RTV_SHIP UPDATE_DATE DATE Fill column length. Yes The date when the RTV Shipment was updated
update_user varchar2128 1 1 Update user of the vendor shipment RTV_SHIP UPDATE_USER VARCHAR2 128 Yes The user who last updated the RTV Shipment
submit_date xs:dateTime 0 1 Date the vendor shipment was submitted in GMT timezone RTV_SHIP SUBMIT_DATE DATE Fill column length. No The date when the RTV Shipment was submitted
submit_user varchar2128 0 1 Submit user of the vendor shipment RTV_SHIP SUBMIT_USER VARCHAR2 128 No The user who submitted the RTV Shipment
dispatch_date xs:dateTime 0 1 Date the vendor shipment was dispatched in GMT timezone RTV_SHIP DISPATCH_DATE DATE Fill column length. No The date when the RTV Shipment was dispatched
dispatch_user varchar2128 0 1 Dispatch user of the vendor shipment RTV_SHIP DISPATCH_USER VARCHAR2 128 No The user who dispatched the RTV Shipment
StrVnsBol * 0 1 Bill of lading associated to the vendor shipment.
StrVnsNote * 0 1000 Notes associated to the vendor shipment.

XML-Schema Name:StrVnsBol 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 StrVnsBol 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
bol_id number12 1 1 Bill of lading unique identifier SHIPMENT_BOL ID NUMBER 12,0 Yes this field contains the sequence-based internal identifier for the bill of lading
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_carrier_type 1 1 Type of carrier used for shipment Valid values are SENDER, RECEIVER, THIRD_PARTY, UNKNOWN. 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 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_address_type 1 1 Address type of the destination address Valid values are BUSINESS, POSTAL, RETURNS, ORDER, INVOICE, REMITTANCE, BILLING, DELIVERY, UNKNOWN. 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
StrVnsBolCtn * 0 1000 Container shipment info.

XML-Schema Name:StrVnsBolCtn 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 StrVnsBolCtn 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
container_id number15 1 1 Container identifier (shipping number). RTV_SHIP_CARTON ID NUMBER 15,0 Yes The unique identifier for the RTV shipment carton/container
container_label varchar2128 0 1 Container label (barcode). RTV_SHIP_CARTON EXTERNAL_ID VARCHAR2 128 No The external identifier
package_weight number12_4 0 1 The weight of the package measured by package weight uom. RTV_SHIP_CARTON WEIGHT NUMBER 12,4 No The weight of the container
package_weight_uom varchar24 0 1 The unit of measure of the package weight. RTV_SHIP_CARTON WEIGHT_UOM VARCHAR2 4 No The UOM of the container
tracking_number varchar2128 0 1 Tracking number assigned to the container by the carrier. SHIPMENT_BOL TRACKING_NUMBER VARCHAR2 128 No Holds the tracking number for the transaction
package_type varchar2120 0 1 Package type of the container. This defines the general size of the package. RTV_SHIP_CARTON SHIPMENT_CARTON_DIM_ID NUMBER 10,0 No The shipment container dimension id

XML-Schema Name:StrVnsNote 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 StrVnsNote 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.