Retail Integration Mappings Report Release:19.0.000

Application	Store Inventory Management
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	FulfilOrdCfmCol FulfilOrdCfmDesc FulfilOrdCfmDtl

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for FulfilOrdCfmCol in SIM application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	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
collection_size	number4	1	1	Number of items in the collection.	n/a	n/a	RIB or/and RSB	n/a	Yes	Fill this description.
FulfilOrdCfmDesc:FulfilOrdCfmDesc	*	0	unbounded	It's a referenced element. For detailed description, please refer referenced element doc.	NA	NA	NA	NA	NA	NA

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for FulfilOrdCfmDesc in SIM application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	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
customer_order_no	varchar248	1	1	Holds the master customer order number from OMS.	FUL_ORD	CUST_ORDER_ID	VARCHAR2	128	No	External identifier of the customer order being fulfilled.
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.	FUL_ORD	EXTERNAL_ID	VARCHAR2	128	Yes	External identifier for the fulfillment order.
confirm_type	confirm_type	1	1	Contains the confirmation type. 'P' - Order Partially Created; 'X' - Order Could not be Created; 'C' - Order Completely Created.	n/a				No	SIM sets the value as X
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'.					No	not used in SIM
FulfilOrdCfmDtl:FulfilOrdCfmDtl	*	0	unbounded	References a collection of customer order confirmation item details.	NA	NA	NA	NA	NA	NA
fulfill_loc_id	number10	0	1	Contains the fulfillment location for the order.	NA	NA	NA	NA	NA	NA
system_cd	varchar210	0	1	The code identifying the system associated with the location.	NA	NA	NA	NA	NA	NA

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for FulfilOrdCfmDtl in SIM application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	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
item	varchar225	1	1	Indicates the item ordered by the customer.	n/a	n/a	RIB or/and RSB	n/a	Yes	Not Used by SIM
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.	n/a	n/a	RIB or/and RSB	n/a	Yes	Not Used by SIM
confirm_qty	number12_4	1	1	Indicates the quantity of the item that can be sourced or fulfilled on the order.	n/a	n/a	RIB or/and RSB	n/a	Yes	Not Used by SIM
confirm_qty_uom	varchar24	1	1	Indicates the unit of measure of the confirmation quantity.	n/a	n/a	RIB or/and RSB	n/a	Yes	Not Used by SIM
item_line_no	number10	0	1	Indicates the detail item line number on the order.	NA	NA	NA	NA	NA	NA