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

XML-Schema Name:FopCriVo 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 FopCriVo 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
store_id number10 1 1 Include only fulfillment order picks at this store FUL_ORD_PICK STORE_ID NUMBER 10,0 Yes The store doing the pick.
from_date xs:dateTime 0 1 Include only fulfillment order picks with the create date at or after this date. FUL_ORD_PICK CREATE_DATE Date Fill column length. Yes The date this pick was created.
to_date xs:dateTime 0 1 Include only fulfillment order picks with the create date at or before this date. FUL_ORD_PICK CREATE_DATE Date Fill column length. Yes The date this pick was created.
pick_id number12 0 1 Include only fulfillment order picks with this internal identifier. FUL_ORD_PICK ID NUMBER 12,0 Yes SIM internal identifier
customer_order_id varchar2128 0 1 Include only fulfillment order picks with customer order identifier. FUL_ORD CUST_ORDER_ID VARCHAR2 128 Yes External identifier of the customer order being fulfilled.
ext_fulfillment_order_id varchar2128 0 1 Include only fulfillment order picks with this external fulfillment order identifier. FUL_ORD EXTERNAL_ID VARCHAR2 128 No External identifier for the fulfillment order.
int_fulfillment_order_id number12 0 1 Include only fulfillment order picks with this internal fulfillment order identifier. FUL_ORD_LINE_ITEM FUL_ORD_ID NUMBER 12,0 Yes Identifier of the fulfillment order this line item is associated to.
bin_id varchar2128 0 1 Include only fulfillment order picks with this BIN identifier. FUL_ORD_BIN BIN_ID VARCHAR2 128 Yes Identifier of a bin associated to the fulfillment order.
status FopCriStatus 1 1 Include only fulfillment order picks matching this status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, NO_VALUE. 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
pick_type FopCriType 1 1 Include only fulfillment order picks matching this type. Valid values are ORDER, BIN. FUL_ORD_PICK TYPE NUMBER 2,0 Yes The type of pick 0 - SIM Customer Order, 1 - Bin
user_name varchar2128 0 1 Include only fulfillment order picks created or completed by this user. FUL_ORD_PICK CREATE_USER VARCHAR2 128 Yes The user that created this pick.
item_id varchar225 0 1 Include only fulfillment orders containing this item SKU. FUL_ORD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item identifier for this line item.