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

XML-Schema Name:StrVnsCtnDesc 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 StrVnsCtnDesc 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 Shipment unique identifier RTV_SHIP_CARTON RTV_SHIP_ID NUMBER 15,0 Yes The unique ID of the RTV shipment the carton is associated to
container_id number15 1 1 Container unique identifier. RTV_SHIP_CARTON ID NUMBER 15,0 Yes The unique identifier for the RTV shipment carton/container
store_id number10 1 1 Store unique identifier RTV_SHIP_CARTON STORE_ID NUMBER 10,0 Yes The store id from which the RTV Shipment is created
container_label varchar2128 0 1 The identifier used to print a barcode or label for the container. RTV_SHIP_CARTON EXTERNAL_ID VARCHAR2 128 No The external identifier
status rtv_ship_carton_status 1 1 Current status of the container Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. RTV_SHIP_CARTON STATUS NUMBER 2,0 Yes The status of the RTV Shipment carton. Valid values: 1- New, 2- In progress, 3- Completed, 4- Canceled
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 Container Tracking number RTV_SHIP_CARTON TRACKING_NUMBER VARCHAR2 128 No The Tracking number for the container
package_type varchar2128 0 1 Package type of the container. RTV_SHIP_CARTON SHIPMENT_CARTON_DIM_ID NUMBER 10,0 No The shipment container dimention id
restriction_level mdse_restrict_level 1 1 Restriction level of the container. Valid values are DEPT, CLASS, SUBCLASS, NONE, UNKNOWN. RTV_SHIP_CARTON RESTRICTION_LEVEL NUMBER 4,0 Yes The hierarchy restriction level for items in a container
create_user_name varchar2128 1 1 User who created this shipment container. RTV_SHIP_CARTON CREATE_USER VARCHAR2 128 Yes The user who created the RTV Shipment carton
create_date xs:dateTime 1 1 Date on which the shipment container was created in GMT timezone. RTV_SHIP_CARTON CREATE_DATE DATE Fill column length. Yes The create date of the RTV Shipment carton
update_user_name varchar2128 0 1 User who last updated this shipment container. RTV_SHIP_CARTON UPDATE_USER VARCHAR2 128 No The user who last updated the RTV Shipment carton
update_date xs:dateTime 0 1 Date on which the shipment container was last updated in GMT timezone. RTV_SHIP_CARTON UPDATE_DATE DATE Fill column length. No The date when the RTV Shipment carton was updated
approved_user_name varchar2128 0 1 User who approved this shipment container. RTV_SHIP_CARTON APPROVAL_USER VARCHAR2 128 No The user who confirmed the RTV Shipment
approved_date xs:dateTime 0 1 Date on which the shipment container was approved in GMT timezone. RTV_SHIP_CARTON APPROVAL_DATE DATE Fill column length. No The date when the RTV Shipment was confirmed
StrVnsCtnItm * 0 5000 Collection of items within the container.

XML-Schema Name:StrVnsCtnItm 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 StrVnsCtnItm 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 1 1 Line item unique identifier RTV_SHIP_LINE_ITEM ID NUMBER 15,0 Yes The unique identifier for the line item
external_id number15 0 1 An identifier assigned by an external system when requesting SIM ship the item. RTV_SHIP_LINE_ITEM EXTERNAL_ID NUMBER 15,0 No External ID for RTV request
item_id varchar225 1 1 SKU number RTV_SHIP_LINE_ITEM ITEM_ID VARCHAR2 25 Yes The ID of the item
description varchar2400 0 1 Description of the item ITEM SHORT_DESCRIPTION VARCHAR2 255 No the textural description of the item and its characteristics.
reason_id number15 1 1 Return reason unique identifier. RTV_SHIP_LINE_ITEM SHIPMENT_REASON_ID NUMBER 15,0 Yes Return reason ID
unit_of_measure varchar240 1 1 Unit of measure of the quantities ITEM UNIT_OF_MEASURE VARCHAR2 4 Yes unit of measure which the stock for this item is tracked at the corporate level.
case_size number10_2 1 1 Case size associated with the item. RTV_SHIP_LINE_ITEM CASE_SIZE NUMBER 10,2 Yes Pack size of the item
quantity number20_4 1 1 Quantity to be shipped. RTV_SHIP_LINE_ITEM QUANTITY NUMBER 20,4 Yes Quantity to be shipped
uin_col varchar2128 0 5000 Collection of all the Unique Identification Numbers associated with the line item Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
StrInvExtAttDesc:StrInvExtAttDesc * 0 5000 Collection of extended attributes for the line item. NA NA NA NA NA NA

XML-Schema Name:StrInvExtAttDesc 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 StrInvExtAttDesc 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
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.