Retail Integration Mappings Report Release:15.0.0

(Retail Warehouse Management System)

Application Retail Warehouse Management System Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemUDALOVRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemUDALOVRef

XML-Schema Name:ItemUDALOVRef 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 ItemUDALOVRef in RWMS application. RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description item varchar225 1 1 NA item_attributes item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. item_attributes attribute_type number 5 Yes Attribute Classification as defined by the Merchandising System uda_value varchar230 1 1 This field contains value of the user-defined attribute for the item. item_attributes attribute varchar2 30 Yes Item Attribute as defined by the Merchandising System