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

XML-Schema Name:TsfShipCtnColDesc 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 TsfShipCtnColDesc 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
TsfShipCtnHdrDesc:TsfShipCtnHdrDesc * 0 unbounded Collection of transfer shipment containers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. TSF_SHIP_CARTON n/a RIB or/and RSB Fill column length. Yes number of transfer ship carton records

XML-Schema Name:TsfShipCtnHdrDesc 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 TsfShipCtnHdrDesc 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
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.
store_id number10 1 1 The unique store identifier of shipping store. TSF_SHIP_CARTON STORE_ID NUMBER 10 Yes Fill this description.
status tsf_ship_ctn_status 1 1 The current status of the container. Valid values are NEW, IN_PROGRESS, COMPLETED, SHIPPED, CANCELED, UNKNOWN, NO_VALUE. TSF_SHIP_CARTON STATUS NUMBER 4 Yes The status of theShipment carton. Valid values: 1- New, 2- In progress, 3- Completed, 4- Canceled
TsfShipHdrCtnSize * 0 1 The container size.
weight number12_4 0 1 The weight of the container. TSF_SHIP_CARTON WEIGHT_UOM VARCHAR2 4 No Fill this description.
weight_uom varchar24 0 1 The unit of measure of the weight of the container. TSF_SHIP_CARTON WEIGHT_UOM VARCHAR2 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.
skus number10 0 1 The number of skus within the container. TSF_SHIP_LINE_ITEM n/a RIB or/and RSB Fill column length. Yes The number of skus within the container
transfer_ids number15 0 999 Collection of all the unique transfer ids associated with the container. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
order_related xs:boolean 1 1 True if it has order related items, false otherwise. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.