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

XML-Schema Name:TsfShipHdrColDesc 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 TsfShipHdrColDesc 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
TsfShipHdrDesc:TsfShipHdrDesc * 0 unbounded Collection of transfer shipment objects represented by the TsfShipHdrDesc payload attribute. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:TsfShipHdrDesc 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 TsfShipHdrDesc 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 The unique transfer shipment identifier. TSF_SHIP ID NUMBER 15 Yes Fill this description.
asn varchar2128 0 1 ASN external identifier. TSF_SHIP ASN VARCHAR2 128 Yes Fill this description.
status tsf_ship_status 1 1 The current status of a transfer shipment. Valid values are NEW, IN_PROGRESS, SUBMITTED, SHIPPED, CANCELED, UNKNOWN. TSF_SHIP STATUS NUMBER 4 Yes The status of the Shipment. 1-New,2-In Progress,3-Submitted,4-Shipped,5-Canceled
destination_type tsf_ship_dest_type 1 1 The destination type the transfer shipment is being shipped to. Valid values are FINISHER, STORE, WAREHOUSE, UNKNOWN. TSF_SHIP DESTINATION_TYPE NUMBER 2 Yes The shipment destination type. 1- Store, 3 Warehouse, 4 - Finisher
destination_name varchar2250 1 1 The destination the transfer shipment is being shipped to. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
last_update_date xs:dateTime 1 1 The date when the transfer shipment was last updated. TSF_SHIP UPDATE_DATE date 7 Yes Fill this description.
dispatch_date xs:dateTime 0 1 The date the transfer shipment was dispatched. TSF_SHIP DISPATCH_DATE date 7 Yes Fill this description.
num_of_containers number10 1 1 The number of containers within the shipment. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
order_related xs:boolean 1 1 Indicates if shipment(s) have any customer order. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.