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

XML-Schema Name:TsfDelvHdrColDesc 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 TsfDelvHdrColDesc 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
TsfDelvHdrDesc:TsfDelvHdrDesc * 0 unbounded Collection of transfer delivery headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. TSF_DELV n/a RIB or/and RSB Fill column length. Yes The number of the transfer delivery headers

XML-Schema Name:TsfDelvHdrDesc 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 TsfDelvHdrDesc 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
delivery_id number15 1 1 Transfer delivery unique identifier. TSF_DELV ID NUMBER 15 Yes Transfer delivery unique identifier.
store_id number10 1 1 Store identifier. TSF_DELV STORE_ID NUMBER 10 Yes Store identifier.
source_type tsf_delv_source_type 1 1 The type of location that shipped the items. Valid values are WAREHOUSE, FINISHER, STORE, UNKNOWN. TSF_DELV SOURCE_TYPE NUMBER 4 Yes The Transfer delivery source type. 1- Store, 3 Warehouse, 4 - Finisher
source_name varchar2250 0 1 The name of the location that shipped the items. STORE, WAREHOUSE, PARTNER NAME VARCHAR2 150, 150, 240 Yes Name of delivery source.
status tsf_delv_status 1 1 Status of the transfer delivery. Valid values are NEW, IN_PROGRESS, RECEIVED, UNKNOWN. TSF_DELV STATUS NUMBER 4 Yes "The status of Transfer Delivery. Valid values: 0 - New, 1 - In Progress, 2 - Received.
asn varchar2128 1 1 External ASN. TSF_DELV ASN_ID VARCHAR2 128 No ASN external identifier.
expected_date xs:dateTime 0 1 The date the transfer delivery is expected to arrive. TSF_DELV EXPECTED_DATE DATE No Delivery expected date
received_date xs:dateTime 0 1 The date the transfer delivery was received. TSF_DELV RECEIVED_DATE DATE No Delivery received date
received_user varchar2128 0 1 The user who received the transfer delivery. TSF_DELV RECEIVED_USER VARCHAR2 128 No The user who received the transfer delivery.
num_of_cartons number10 1 1 Total number of containers in the transfer delivery. No Number of containers on the delivery.
total_skus number10 1 1 Total number of items in the transfer delivery. No Number of line items received on the delivery.
cartons_missing xs:boolean 1 1 Indicates if the transfer delivery holds missing containers. No Number of container in missing status.
customer_order_related xs:boolean 1 1 True indicates the transfer delivery is associated to customer order. No True if delivery contains items associated to customer order otherwise false.