Retail Integration Mappings Report Release:16.0.21 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/TsfShipCtnModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:TsfShipCtnModVo Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfShipCtnModVo 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
tsf_ship_carton_id number15 1 1 The unique transfer shipment container identifier. TSF_SHIP_CARTON ID NUMBER 15 Yes Fill this description.
external_id varchar2128 0 1 The external identifier. TSF_SHIP_CARTON EXTERNAL_ID VARCHAR2 128 No Fill this description.
hierarchy_level tsf_hierarchy_level 1 1 The container restricted hierarchy level. Valid values are NONE, DEPT, CLASS, SUBCLASS. TSF_SHIP_CARTON RESTRICTION_LEVEL NUMBER 4 No Fill this description.
TsfShipCtnSizeMod * 0 1 The container size.
weight number20_4 0 1 The weight of the container. TSF_SHIP_CARTON WEIGHT NUMBER 12,4 No Fill this description.
tracking_number varchar2128 0 1 The tracking number for the container. TSF_SHIP_CARTON TRACKING_NUMBER VARCHAR2 128 No Fill this description.
use_available xs:boolean 1 1 True if container uses only available inventory, false otherwise. TSF_SHIP_CARTON USE_AVAILABLE VARCHAR2 1 Yes value of Y indicates carton will use only available inventory, N means carton will use unavailable inventory
TsfShipCtnItmMod * 0 1000 Collection of line items.
removed_line_id_col number12 0 1000 Collection of carton item identifiers to remove from the carton. n/a Fill table column name. RIB or/and RSB Fill column length. No Fill this description.
TsfShipCtnModNote * 0 1000 Collection of transfer shipment notes that will be added to the transfer shipment.

XML-Schema Name:TsfShipCtnSizeMod Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfShipCtnSizeMod 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
id number15 1 1 The unique carton size identifier. SHIPMENT_CARTON_DIM ID NUMBER 12 No Fill this description.
store_id number10 0 1 The unique store identifier. SHIPMENT_CARTON_DIM STORE_ID NUMBER 10 Yes Fill this description.
description varchar2128 0 1 The description of the dimensions. SHIPMENT_CARTON_DIM DESCRIPTION VARCHAR2 120 Yes The carton dimensions description
height number20_4 0 1 The height of the carton. SHIPMENT_CARTON_DIM HEIGHT NUMBER 12,4 Yes The height of the carton.
width number20_4 0 1 The width of the carton. SHIPMENT_CARTON_DIM WIDTH NUMBER 12,4 No Fill this description.
length number20_4 0 1 The length of the carton. SHIPMENT_CARTON_DIM Fill table column name. NUMBER 12,4 No length of the shipment carton
unit_of_measure varchar2128 1 1 Unit of measure for the measurements. SHIPMENT_CARTON_DIM UOM VARCHAR2 4 No Fill this description.

XML-Schema Name:TsfShipCtnItmMod Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfShipCtnItmMod 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_item_id number15 0 1 The unique line item identifier. If not included, means attempt to add a new line item, otherwise this will replace a current existing line item. TSF_SHIP_LINE_ITEM ID 15 NUMBER Yes Fill this description.
item_id varchar225 1 1 The unique identifier of the sku. TSF_SHIP_LINE_ITEM ITEM_ID NUMBER 25 Yes Fill this description.
case_size number10_2 0 1 Case size of the item. QUANTITY CASE_SIZE NUMBER 12,4 No Fill this description.
quantity number10 1 1 Quantity to be shipped. TSF_SHIP_LINE_ITEM QUANTITY NUMBER 20,4 Yes Fill this description.
shipment_reason_id number15 0 1 The identifier of the reason for the item shipment. TSF_SHIP_LINE_ITEM SHIPMENT_REASON_ID NUMBER 15 No Fill this description.
transfer_id number12 0 1 The document id associated with this item and quantity. If this is empty, the item will be added to the adhoc document. TSF ID NUMBER 15 No Fill this description.
uin_col varchar2128 0 5000 Collection of all the unique identifiers/serial numbers associated with the line item. n/a Fill table column name. RIB or/and RSB Fill column length. No Fill this description.
removed_uin_col varchar2128 0 5000 Collection of unique identifier numbers to remove from the line item. n/a Fill table column name. RIB or/and RSB Fill column length. No Fill this description.
StrInvExtAttDesc:StrInvExtAttDesc * 0 5000 Collection of extended attributes associated with the line item. NA NA NA NA NA NA
removed_ext_att_col varchar2128 0 5000 Collection of extended attributes associated with the line item to be removed. n/a Fill table column name. RIB or/and RSB Fill column length. No Fill this description.

XML-Schema Name:StrInvExtAttDesc Version:16.0.21 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. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. n/a (multiple tables) Fill table column name. RIB or/and RSB 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.

XML-Schema Name:TsfShipCtnModNote Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfShipCtnModNote 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. NOTES. TEXT VARCHAR2 2000 No Fill this description.