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

XML-Schema Name:TsfShipCtnModVo 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 TsfShipCtnModVo 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
tsf_ship_carton_id number15 1 1 The unique transfer shipment container identifier. TSF_SHIP_CARTON ID NUMBER 15 Yes The unique identifier for the shipment carton/container
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 Yes The hierarchy restriction level for items in a container
TsfShipCtnSizeMod * 0 1 The container size.
weight number20_4 0 1 The weight of the container. TSF_SHIP_CARTON WEIGHT NUMBER 12,4 No The weight of the container
tracking_number varchar2128 0 1 The tracking number for the container. TSF_SHIP_CARTON TRACKING_NUMBER VARCHAR2 128 No The Tracking number for the container
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. TSF_SHIP_LINE_ITEM ID NUMBER 15 Yes The unique identifier for the line item
TsfShipCtnModNote * 0 1000 Collection of transfer shipment notes that will be added to the transfer shipment.

XML-Schema Name:TsfShipCtnSizeMod 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 TsfShipCtnSizeMod 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
id number15 1 1 The unique carton size identifier. SHIPMENT_CARTON_DIM ID NUMBER 12 Yes shipment carton dimension unique identifier
store_id number10 0 1 The unique store identifier. SHIPMENT_CARTON_DIM STORE_ID NUMBER 10 Yes Store identifier.
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 Yes Width of the container.
length number20_4 0 1 The length of the carton. SHIPMENT_CARTON_DIM LENGTH NUMBER 12,4 Yes length of the shipment carton
unit_of_measure varchar2128 1 1 Unit of measure for the measurements. SHIPMENT_CARTON_DIM UOM VARCHAR2 4 Yes Unit of measure.

XML-Schema Name:TsfShipCtnItmMod 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 TsfShipCtnItmMod 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
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 NUMBER 15 Yes The unique identifier for the line item
item_id varchar225 1 1 The unique identifier of the sku. TSF_SHIP_LINE_ITEM ITEM_ID NUMBER 25 Yes The item identifier
case_size number10_2 0 1 Case size of the item. QUANTITY CASE_SIZE NUMBER 12,4 No Pack size of the item
quantity number10 1 1 Quantity to be shipped. TSF_SHIP_LINE_ITEM QUANTITY NUMBER 20,4 Yes Quantity to be shipped
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 The shipment reason identifier
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. ITEM_UIN UIN VARCHAR2 128 Yes Unique Identification Number
removed_uin_col varchar2128 0 5000 Collection of unique identifier numbers to remove from the line item. ITEM_UIN UIN VARCHAR2 128 Yes Unique identification number.
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. TSF_SHIP_LINE_ITEM_ATT BARCODE VARCHAR2 128 Yes Extended attribute barcode.

XML-Schema Name:StrInvExtAttDesc 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 StrInvExtAttDesc 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
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT BARCODE VARCHAR2 128 Yes Extended attribute barcode.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT QUANTITY NUMBER 12 Yes Extended attribute quantity.
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.030 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 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 No Notes / Comments added to shipment.