Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) 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 Yes 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 ID Number 12,0 Yes Unique SIM identifier.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes not used in SIM
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes not used in SIM
fulfill_loc_type fulfill_loc_type 1 1 This would be either 'S' (for physical store) or 'V' (for virtual store). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes not used in SIM
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. FUL_ORD STORE_ID Number 10,0 Yes Store identifier at which this order is being fulfilled.
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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) 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. FUL_ORD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item identifier for this line item.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes not used in SIM
cancel_qty_suom number12_4 1 1 Indicates the quantity that should be cancelled from the order in item's standard unit of measure. FUL_ORD_LINE_ITEM QUANTITY_CANCELED Number 12,4 Yes The quantity canceled of this line item.
standard_uom varchar24 1 1 Indicates item's standard unit of measure. ITEM UNIT_OF_MEASURE VARCHAR2 4 Yes unit of measure which the stock for this item is tracked at the coporate level.
transaction_uom varchar24 1 1 Indicates the original transaction unit of measure the order is placed in. FUL_ORD_LINE_ITEM PREFERRED_UOM VARCHAR2 4 Yes Preferred unit of measure of this line item.