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

XML-Schema Name:FopDesc 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 FopDesc 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
pick_id number12 1 1 SIM fulfillment order pick identifier FUL_ORD_PICK ID NUMBER 12,0 Yes SIM internal identifier
pick_type FopType 1 1 Type of the fulfillment order pick. Valid values are ORDER, BIN, UNKNOWN. FUL_ORD_PICK TYPE NUMBER 2,0 Yes The type of pick 0 - SIM Customer Order, 1 - Bin
status FopStatus 1 1 Current status Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. FUL_ORD_PICK STATUS NUMBER 4,0 Yes Indicates the status of the fulfillment order. Valid values are 0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled, 4- Active
create_date xs:dateTime 1 1 Date the delivery pick was created FUL_ORD_PICK CREATE_DATE Date Fill column length. Yes The date this pick was created.
create_user_name varchar2128 1 1 User that created this delivery pick FUL_ORD_PICK CREATE_USER VARCHAR2 128 Yes The user that created this pick.
complete_date xs:dateTime 0 1 Date the delivery pick was confirmed FUL_ORD_PICK COMPLETE_DATE Date Fill column length. No The date this pick was completed.
complete_user_name varchar2128 0 1 User that confirmed this delivery pick FUL_ORD_PICK COMPLETE_USER VARCHAR2 128 No The user that completed this pick.
FopItm * 0 unbounded Collection of fulfillment order pick line items

XML-Schema Name:FopItm 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 FopItm 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
line_id number12 1 1 Line item identifier FUL_ORD_PICK_LINE_ITEM ID NUMBER 12,0 Yes SIM Internal Identifier
item_id varchar225 1 1 SKU number FUL_ORD_PICK_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item identifier
bin_id varchar2128 0 1 Bin identifier FUL_ORD_BIN BIN_ID VARCHAR2 128 Yes Identifier of a bin associated to the fulfillment order.
fulfillment_order_id number12 1 1 Fulfillment order identifier that pick is for. FUL_ORD_PICK_LINE_ITEM FUL_ORD_ID NUMBER 12,0 Yes The SIM identifier of the fulfillment order the pick this line item is on is for.
fulfillment_order_line_id number12 1 1 Fulfillment order line item identifier that pick is for. FUL_ORD_PICK_LINE_ITEM FUL_ORD_LINE_ITEM_ID NUMBER 12,0 No The SIM identifier of the fulfillment order line item this line item is being picked for.
substitute_line_id number12 0 1 Line item identifier of the fulfillment order pick line item that this pick line item was substituted for. FUL_ORD_PICK_LINE_ITEM SUBSTITUTE_LINE_ITEM_ID NUMBER 12,0 No The SIM identifier of another pick line item for which this line item is being substituted for.
preferred_uom varchar24 0 1 Unit of measure preferred to pick quantities. FUL_ORD_PICK_LINE_ITEM PREFERRED_UOM VARCHAR2 4 No The preferred unit of measure in which to pick.
standard_uom varchar24 1 1 Unit of measure of the quantities. This may or may not be the same as preferred uom. ITEM UINT_OF_MEASURE VARCHAR2 4 Yes unit of measure which the stock for this item is tracked at the coporate level.
suggested_quantity number20_4 0 1 Quantity in units suggested to be picked. FUL_ORD_PICK_LINE_ITEM QUANTITY_SUGGESTED NUMBER 12,4 No The system suggested pick quantity for this line item.
picked_quantity number20_4 1 1 Quantity in units being picked. FUL_ORD_PICK_LINE_ITEM QUANTITY_PICKED NUMBER 12,4 No The actual quantity of what was picked.
case_size number10_2 1 1 Case size of the item. FUL_ORD_PICK_LINE_ITEM CASE_SIZE NUMBER 10,2 No The case size of this item picked.
pick_area varchar2255 1 1 Suggested area from which to pick this item. STORE_SEQUENCE_AREA DESCRIPTION VARCHAR2 255 No Description Of Store Sequence