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

XML-Schema Name:ForpHdrColDesc 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 ForpHdrColDesc 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
ForpHdrDesc:ForpHdrDesc * 0 unbounded Collection of fulfillment order reverse 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:ForpHdrDesc 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 ForpHdrDesc 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 NUMBER 12,0 Yes Unique SIM identifier.
status forp_status 1 1 Current status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. FUL_ORD_RV_PICK STATUS NUMBER 4,0 Yes The current status of the reverse pick 0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled
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.
create_date xs:dateTime 1 1 Date the reverse pick was created. FUL_ORD_RV_PICK ID NUMBER 12,0 Yes Unique SIM identifier.