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

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

XML-Schema Name:TsfDelvFulOrdVo 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 TsfDelvFulOrdVo 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
container_id number15 1 1 Container unique identifier. TSF_DELV_CARTON ID NUMBER 15 Yes Container unique identifier.
external_id varchar2128 0 1 The container external identifier. TSF_DELV_CARTON EXTERNAL_ID VARCHAR2 128 No The container external identifier
customer_order_id varchar2128 1 1 The customer order external identifier. TSF_DELV_LINE_ITEM CUST_ORD_EXTERNAL_ID VARCHAR2 128 No The customer order external identifier.
fulfillment_order_id varchar2128 1 1 The fulfillment order external identifier. TSF_DELV_LINE_ITEM FUL_ORD_EXTERNAL_ID VARCHAR2 128 No The fulfillment order external identifier.
status ful_ord_status 1 1 Fulfillment order status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. FUL_ORD STATUS NUMBER 4 Yes "Indicates the status of the fulfillment order. Valid values are: 0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled, 4- Active"
total_items number10 1 1 Total number of items on the fulfillment order. No Number of items associated with customer order on the container.