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

XML-Schema Name:VdrDelvFulOrdCol 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 VdrDelvFulOrdCol 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
VdrDelvFulOrdDesc:VdrDelvFulOrdDesc * 0 unbounded Collection of vendor delivery customer orders. 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 number of vendor delivery customer orders.

XML-Schema Name:VdrDelvFulOrdDesc 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 VdrDelvFulOrdDesc 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
carton_id number12 1 1 Container identifier. DSD_CARTON ID NUMBER 12 Yes Container identifier.
external_id varchar2128 0 1 Container external identifier. DSD_CARTON EXTERNAL_ID VARCHAR2 128 No Container external identifier.
customer_order_id varchar2128 1 1 Customer order external identifier. FUL_ORD, DSD, DSD_LINE_ITEM CUST_ORDER_ID VARCHAR2 128 No The customer order external identifier.
fulfillment_order_id varchar2128 1 1 Fulfillment Order external identifier. FUL_ORD, DSD, DSD_LINE_ITEM EXTERNAL_ID, FUL_ORD_EXTERNAL_ID, FUL_ORD_EXTERNAL_ID VARCHAR2 128 No The fulfillment order external identifier.
status fulfillment_order_status 1 1 Fulfillment Order status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, NO_VALUE, 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"
number_of_line_items number10 1 1 Total number of line item in customer order. No Derived from number of line item on delivery which are associated with customer order
comments varchar22000 0 1 Fulfillment order comments. FUL_ORD COMMENTS VARCHAR2 3000 No Fulfillment order comments.