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

XML-Schema Name:TsfShipCtnColDesc 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 TsfShipCtnColDesc 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
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.030 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 BDI) 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 The unique identifier for the shipment carton/container
external_id varchar2128 0 1 The external identifier. TSF_SHIP_CARTON EXTERNAL_ID VARCHAR2 128 No The external identifier
store_id number10 1 1 The unique store identifier of shipping store. TSF_SHIP_CARTON STORE_ID NUMBER 10 Yes Store identifier.
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 NUMBER 12,4 No Weight of the shipment container.
weight_uom varchar24 0 1 The unit of measure of the weight of the container. TSF_SHIP_CARTON WEIGHT_UOM VARCHAR2 4 No The UOM 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
skus number10 0 1 The number of skus within the container. No The number of skus within the container
transfer_ids number15 0 999 Collection of all the unique transfer ids associated with the container. No List of transfer document identifiers associated to the shipment.
order_related xs:boolean 1 1 True if it has order related items, false otherwise. No True if document attached to the shipment are related to a customer order other wise false.