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

XML-Schema Name:TsfDelvHdrColDesc 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 TsfDelvHdrColDesc 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
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.21 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 RSL) 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, FINISHER NAME RIB or/and RSB 150 Yes Fill this description.
status tsf_delv_status 1 1 Status of the transfer delivery. Valid values are NEW, IN_PROGRESS, RECEIVED, CANCELED, UNKNOWN. TSF_DELV STATUS NUMBER 4 Yes The status of Transfer Delivery.0 - New,1 - In Progress,2 - Received,3 - Missing,4 - Canceled,5 - Damaged.
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 7 No Delivery expected date
received_date xs:dateTime 0 1 The date the transfer delivery was received. TSF_DELV RECEIVED_DATE DATE 7 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. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
total_skus number10 1 1 Total number of items in the transfer delivery. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
cartons_missing xs:boolean 1 1 Indicates if the transfer delivery holds missing containers. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
customer_order_related xs:boolean 1 1 True indicates the transfer delivery is associated to customer order. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.