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

XML-Schema Name:FopHdrColDesc 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 FopHdrColDesc 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
FopHdrDesc:FopHdrDesc * 0 unbounded Collection of fulfillment order pick headers NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:FopHdrDesc 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 FopHdrDesc 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 Fulfillment order pick identifier. FUL_ORD_PICK ID NUMBER 12,0 Yes SIM internal identifier
create_date xs:dateTime 1 1 Date the fulfillment order 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 fulfillment order pick. FUL_ORD_PICK CREATE_USER VARCHAR2 128 Yes The user that created this pick.
complete_date xs:dateTime 0 1 Date the fulfillment order pick was completed. 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 fulfillment order pick. FUL_ORD_PICK COMPLETE_USER VARCHAR2 128 No The user that completed this pick.
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 Status of the fulfillment order pick. 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
total_quantity number20_4 1 1 Total suggested quantity to be picked. FUL_ORD_PICK_LINE_ITEM QUANTITY_PICKED NUMBER 12,4 No The actual quantity of what was picked.
actual_quantity number20_4 1 1 Actual quantity being picked. FUL_ORD_PICK_LINE_ITEM QUANTITY_PICKED NUMBER 12,4 No The actual quantity of what was picked.