Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/FulfilOrdCfmCol/v1
Version 1.0
Description This object is used to communicate customer order confirmation and detail back to OMS from RMS and SIM. This object is also used by SIM to confirm that an order can be picked up for store pickup fulfillment.
XSD Structure

XML-Schema Name:FulfilOrdCfmCol Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmCol in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
collection_size number4 1 1 Number of items in the collection. n/a n/a n/a n/a Yes n/a
FulfilOrdCfmDesc:FulfilOrdCfmDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdCfmDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
customer_order_no varchar248 1 1 Holds the master customer order number from OMS. ordcust customer_order_no varchar2 48 Yes Holds the master customer order number from OMS.
fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. ordcust fulfill_order_no varchar2 48 Yes Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS.
confirm_type confirm_type 1 1 Contains the confirmation type. 'P' - Order Partially Created; 'X' - Order Could not be Created. ordcust status varchar2 1 Yes Contains the confirmation type. 'P' - Order Partially Created; 'X' - Order Could not be Created.
confirm_no number12 0 1 Contains the PO or Transfer number in RMS related to the fulfillment order line. Required if fulfillment status is 'P'. tsfhead, ordhead tsf_no, order_no number 12 No Contains the PO or Transfer number in RMS related to the fulfillment order line. Required if fulfillment status is 'P'.
FulfilOrdCfmDtl:FulfilOrdCfmDtl * 0 unbounded References a collection of customer order confirmation item details. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdCfmDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FulfilOrdCfmDtl in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
item varchar225 1 1 Indicates the item ordered by the customer. ordcust_detail item varchar2 25 No Indicates the item ordered by the customer.
ref_item varchar225 0 1 Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as we don't support transfer requests for a specific reference item. ordcust_detail ref_item varchar2 25 No Indicates the reference item ordered by the customer. Used only if a specific UPC is ordered. This is supported for vendor drop-ships orders only as transfer requests for a specific reference item are not supported.
confirm_qty number12_4 1 1 Indicates the quantity of the item that can be sourced or fulfilled on the order. tsfdetail, ordloc tsf_qty, qty_ordered number 12 No Indicates the quantity of the item that can be sourced or fulfilled on the order.
confirm_qty_uom varchar24 1 1 Indicates the unit of measure of the confirmation quantity. ordcust_detail standard_uom varchar2 4 No Indicates the unit of measure of the confirmation quantity.