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

XML-Schema Name:FodModVo Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FodModVo 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
int_fulfill_order_delivery_id number12 1 1 Internal fulfillment order delivery identifier FUL_ORD_DLV ID number 12,0 Yes Unique SIM identifier
notes varchar22000 0 10 Notes to add to the delivery. NOTES TEXT VARCHAR2 2000 Yes The note's message.
FodItmMod * 0 1000 Collection of delivery line items representing modified information

XML-Schema Name:FodItmMod Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for FodItmMod 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
fulfill_order_delivery_line_id number12 1 1 Delivery line item identifier FUL_ORD_DLV_LINE_ITEM ID number 12,0 Yes Unique SIM identifier.
quantity number20_4 1 1 Quantity in units. Value is in standard unit of measure. If UINs are included, the quantity of UINs will override this value. FUL_ORD_DLV_LINE_ITEM QUANTITY number 12,4 Yes The quantity of this line item on the delivery.
added_uin_col varchar2128 0 100 Universal Identifier Numbers to add to the line item Yes Serial numbers
removed_uin_col varchar2128 0 1000 Universal Identifier Numbers to remove from the line item Yes Removed serial numbers