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

XML-Schema Name:ForpDesc 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 ForpDesc 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
reverse_pick_id number12 1 1 Fulfillment order reverse pick identifier FUL_ORD_RV_PICK ID VARCHAR2 128 Yes The user that created this reverse pick.
status forp_status 1 1 Current status Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. FUL_ORD_RV_PICK STATUS VARCHAR2 128 Yes The user that created this reverse pick.
create_date xs:dateTime 1 1 Date the reverse pick was created FUL_ORD_RV_PICK CREATE_DATE Date Fill column length. Yes The date this reverse pick was created.
create_user_name varchar2128 1 1 User that created this reverse pick FUL_ORD_RV_PICK CREATE_USER VARCHAR2 128 Yes The user that created this reverse pick.
ForpItm * 0 unbounded Collection of fulfillment order reverse pick line items

XML-Schema Name:ForpItm 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 ForpItm 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_RV_PICK_LINE_ITEM ID NUMBER 12,0 Yes SIM Internal Identifier.
item_id varchar225 1 1 SKU number FUL_ORD_RV_PICK_LINE_ITEM FUL_ORD_LINE_ITEM_ID NUMBER 12,0 Yes The SIM identifier of the fulfillment order line item this line item is being reverse picked for.
fulfillment_order_line_id number12 1 1 Fulfillment order line item identifier that reverse pick is for. FUL_ORD_RV_PICK_LINE_ITEM ID NUMBER 12,0 Yes SIM Internal Identifier.
standard_uom varchar24 1 1 Unit of measure of the quantities. This may or may not be the same as preferred uom. ITEM UNIT_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 standard unit of measure suggested to be reverse picked. FUL_ORD_RV_PICK_LINE_ITEM QUANTITY_SUGGESTED NUMBER 12,4 Yes The system suggested reverse pick quantity for this line item.
unpicked_quantity number20_4 1 1 Quantity in standard unit of measure being reverse picked. FUL_ORD_RV_PICK_LINE_ITEM QUANTITY_RV_PICKED NUMBER 12,4 No The actual quantity of that was reverse picked.
case_size number10_2 1 1 Case size of the item. FUL_ORD_RV_PICK_LINE_ITEM CASE_SIZE NUMBER 10,2 No The case size of this item reverse picked.