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

XML-Schema Name:StrVnsCtnModVo 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 StrVnsCtnModVo 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 0 1 Container unique identifier. If left empty, indicates creating new container, otherwise will attempt to modify container based on identifier. RTV_SHIP_CARTON ID NUMBER 15,0 No 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
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 Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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_mod 1 1 Restriction level of the container. Valid values are DEPT, CLASS, SUBCLASS, NONE. RTV_SHIP_CARTON RESTRICTION_LEVEL NUMBER 4,0 Yes The hierarchy restriction level for items in a container
StrVnsCtnItmMod * 0 5000 Collection of items within the container.

XML-Schema Name:StrVnsCtnItmMod 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 StrVnsCtnItmMod 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 0 1 Line item unique identifier RTV_SHIP_LINE_ITEM ID NUMBER 15,0 No 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 Shipment
item_id varchar225 1 1 SKU number RTV_SHIP_LINE_ITEM ITEM_ID VARCHAR2 25 Yes The ID of the item
reason_id number15 1 1 Return reason unique identifier. RTV_SHIP_LINE_ITEM SHIPMENT_REASON_ID NUMBER 15,0 Yes Return reason ID
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
added_uin_col varchar2128 0 1000 Unique Identifier Numbers to add to 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.
removed_uin_col varchar2128 0 1000 Unique Identifier Numbers to remove from 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 1000 Collection of extended attributes associated to the line item, either added or updated external attributes. NA NA NA NA NA NA
removed_ext_att_col varchar2128 0 1000 Contains barcodes associated to the extended attribute scan to be deleted. All occurrences will be deleted. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

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.