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

XML-Schema Name:TsfDelvHdrCriVo 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 TsfDelvHdrCriVo 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 store_id number10 1 1 Include only deliveries for this store. TSF_DELV STORE_ID NUMBER 10 Yes Store identifier. expected_from_date xs:dateTime 0 1 Include only transfer deliveries with an expected date equal to or after this date. TSF_DELV EXPECTED_DATE DATE No Include only transfer deliveries with an expected date equal to or after this date. expected_to_date xs:dateTime 0 1 Include only transfer deliveries with an expected date equal to or before this date. TSF_DELV EXPECTED_DATE DATE No Include only transfer deliveries with an expected date equal to or before this date. received_from_date xs:dateTime 0 1 Include only transfer deliveries with the received date equal to or after this date. TSF_DELV RECEIVED_DATE DATE No Received date received_to_date xs:dateTime 0 1 Include only transfer deliveries with the received date equal to or before this date. TSF_DELV RECEIVED_DATE DATE No Delivery received date source_type tsf_delv_cri_source_type 1 1 Include only transfer deliveries from this source type. Valid values are WAREHOUSE, FINISHER, STORE, NO_VALUE. TSF_DELV SOURCE_TYPE NUMBER 4 Yes The Transfer delivery source type. 1- Store, 3 Warehouse, 4 - Finisher source_id number10 0 1 Include only transfer deliveries from this source. TSF_DELV TSF_DELV NUMBER 10 Yes Include only transfer deliveries from this source. delivery_id number15 0 1 The unique identifier of the transfer delivery. TSF_DELV ID NUMBER 15 Yes Transfer delivery unique identifier. asn varchar2128 0 1 Include only transfer deliveries with this ASN external identifier. TSF_DELV ASN_ID VARCHAR2 128 No ASN external identifier. external_id varchar2128 0 1 Container external identifier. TSF_DELV_CARTON EXTERNAL_ID VARCHAR2 128 No Container external identifier. item_id varchar225 0 1 Include only transfer deliveries containing this item SKU. TSF_DELV_LINE_ITEM ITEM_ID VARCHAR2 25 No Item identifier status tsf_delv_cri_status 1 1 Includes only transfer deliveries matching this status. Valid values are NEW, IN_PROGRESS, RECEIVED, NO_VALUE. TSF_DELV STATUS NUMBER 4 Yes The status of Transfer Delivery.0 - New,1 - In Progress,2 - Received. document_id number15 0 1 Include only transfer deliveries containing this document identifier. TSF_DELV DOCUMENT_ID NUMBER 15 No transfer document identifier customer_order_id varchar2128 0 1 Include only transfer deliveries for the customer order with this external identifier. TSF_DELV_LINE_ITEM CUST_ORD_EXTERNAL_ID VARCHAR2 128 No customer order external identifier fulfillment_order_id varchar2128 0 1 Include only transfer deliveries for the fulfillment order with this external identifier. TSF_DELV_LINE_ITEM FUL_ORD_EXTERNAL_ID VARCHAR2 128 Yes fulfillment order external id order_related xs:boolean 0 1 Include only transfer deliveries related to a customer order. Ignored if customer/fulfillment order external identifiers are set. No Deliveries which has line items associated to customer order. context_id number18 0 1 Include only shipments matching the supplied context. TSF CONTEXT_ID NUMBER 18 No The context identifier context_value varchar225 0 1 Include only transfer deliveries with this context value. TSF CONTEXT_VALUE VARCHAR2 25 No Include only transfer deliveries with this context value.