Retail Integration Mappings Report Release:19.0.000 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/FopModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:FopModVo Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FopModVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
pick_id number12 1 1 Fulfillment order pick identifier Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
FopItmMod * 0 1000 Collection of pick line items representing modified information
StrCustAttModVo:StrCustAttModVo * 0 50 Collection of custom attributes to be updated for the fulfillment order pick. NA NA NA NA NA NA

XML-Schema Name:FopItmMod Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FopItmMod in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
line_id number12 1 1 Pick line item identifier FUL_ORD_PICK_LINE_ITEM ID number 12,0. Yes SIM Internal Identifier
quantity number20_4 1 1 Quantity in standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
FopSubMod * 0 100 Collection of pick substitute line items representing modified information

XML-Schema Name:FopSubMod Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FopSubMod in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
item_id varchar225 1 1 SKU number Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
quantity number20_4 1 1 Quantity in standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:StrCustAttModVo Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrCustAttModVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
admin_id number12 0 1 The unique identifier for the admin record defining this attribute. NA NA NA NA NA NA
attribute_name varchar2128 0 1 Contains an identifying name of the attribute. Required if admin_id is not included. NA NA NA NA NA NA
value_text varchar2128 0 1 Holds the string value of the attribute. NA NA NA NA NA NA
value_date xs:dateTime 0 1 Holds the date value of the attribute. NA NA NA NA NA NA
value_decimal number18_4 0 1 Holds the decimal value of the attribute. NA NA NA NA NA NA
value_long number18 0 1 Holds the long value of the attribute. NA NA NA NA NA NA