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/FulfilOrdColRef/v1
Version 1.0
Description This object is used to communicate customer order fulfillment cancellation requests from OMS to RMS and SIM.
XSD Structure

XML-Schema Name:FulfilOrdColRef 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 FulfilOrdColRef 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
FulfilOrdRef:FulfilOrdRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdRef 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 FulfilOrdRef 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.
source_loc_type source_loc_type 0 1 This would be either 'SU' for supplier, 'ST' for store, or 'WH' for warehouse. This would only be populated for vendor, warehouse or multi-site fulfillment orders. ordcust source_loc_type varchar2 2 No Contains the source type for the customer order. Valid values are 'SU' for supplier, 'ST' for store and 'WH' for warehouse. This would only contain a value for vendor, warehouse, or multi-site fulfilment orders.
source_loc_id number10 0 1 Indicates the supplier, store or warehouse number associated with sourcing the customer order. Only populated for vendor, warehouse or multi-site fulfillment orders. ordcust source_loc_id number 10 No Indicates the supplier, store or warehouse number the customer order is sourced from. Only populated for vendor, warehouse or multi-site fulfillment orders.
fulfill_loc_type fulfill_loc_type 1 1 This would be either 'S' (for physical store) or 'V' (for virtual store). ordcust fulfill_loc_type varchar2 1 Yes Contains the fulfillment location type of the customer order. Valid values are 'S' for physical store and 'V' for virtual store.
fulfill_loc_id number10 1 1 Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number. ordcust fulfill_loc_id number 10 Yes Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number.
FulfilOrdDtlRef:FulfilOrdDtlRef * 1 unbounded Indicates the customer order fulfillment cancellation detail. NA NA NA NA NA NA

XML-Schema Name:FulfilOrdDtlRef 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 FulfilOrdDtlRef 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 Yes 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 we don't support transfer requests for a specific reference item.
cancel_qty_suom number12_4 1 1 Indicates the quantity that should be cancelled from the order in item's standard unit of measure. ordcust_detail qty_cancelled_suom number 12 Yes Holds the total cancelled quantity for the customer order in the item's standard unit of measure.
standard_uom varchar24 1 1 Indicates item's standard unit of measure. ordcust_detail standard_uom varchar2 4 Yes Indicates the item's standard unit of measure.
transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. ordcust_detail transaction_uom varchar2 4 Yes Indicates the original transaction unit of measure the order is placed in.