Retail Integration Bus Mappings Report Release:13.2.0

(Retail Merchandizing System)

Application Retail Merchandizing System Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. ItemDesc ItemHdrDesc ExtOfItemHdrDesc LocOfItemHdrDesc ItemSupDesc ExtOfItemSupDesc LocOfItemSupDesc ItemSupCtyDesc ExtOfItemSupCtyDesc LocOfItemSupCtyDesc ISCDimDesc ExtOfISCDimDesc LocOfISCDimDesc ItemUDALOVDesc ExtOfItemUDALOVDesc LocOfItemUDALOVDesc ItemUDAFFDesc ExtOfItemUDAFFDesc LocOfItemUDAFFDesc ItemUDADateDesc ExtOfItemUDADateDesc LocOfItemUDADateDesc ItemImageDesc ExtOfItemImageDesc LocOfItemImageDesc ItemUPCDesc ExtOfItemUPCDesc LocOfItemUPCDesc ItemBOMDesc ExtOfItemBOMDesc LocOfItemBOMDesc ItemTcktDesc ExtOfItemTcktDesc LocOfItemTcktDesc ItemSupCtyMfrDesc ExtOfItemSupCtyMfrDesc LocOfItemSupCtyMfrDesc ExtOfItemDesc LocOfItemDesc

XML-Schema Name:ItemDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemDesc Table Name Column Name API Type Column Length API Required API Description ItemHdrDesc:ItemHdrDesc * 1 1 It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemSupDesc:ItemSupDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemSupCtyDesc:ItemSupCtyDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ISCDimDesc:ISCDimDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemUDALOVDesc:ItemUDALOVDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemUDAFFDesc:ItemUDAFFDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemUDADateDesc:ItemUDADateDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemImageDesc:ItemImageDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemUPCDesc:ItemUPCDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemBOMDesc:ItemBOMDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemTcktDesc:ItemTcktDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ItemSupCtyMfrDesc:ItemSupCtyMfrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ExtOfItemDesc:ExtOfItemDesc * 0 1 Provide an extension hook to customize ItemDesc. NA NA NA NA NA NA LocOfItemDesc:LocOfItemDesc * 0 1 Provide an extension hook to localize ItemDesc. NA NA NA NA NA NA

XML-Schema Name:ItemHdrDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemHdrDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Unique alphanumeric value that identifies the item. item_master item varchar2 25 Yes Unique alphanumeric value that identifies the item. item_number_type varchar26 1 1 This type can hold a number of digits count umber_type. item_master item_number_type varchar2 6 Yes Code specifying item type. Valid values are in the code type UPCT in the code_head and code_detail tables. format_id varchar21 0 1 This field will hold the format ID that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. item_master format_id varchar2 1 No This field contains the format ID that corresponds to the item's variable UPC. This value is used only for items with variable UPCs. prefix number2 0 1 This column holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. It is the clients responsibility to download this value to their item_master prefix number 2 No This column contains the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and is used to decode variable weight UPCs that are uploaded from the POS. It is the retailer's responsibility to download this value. item_parent varchar225 0 1 Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table. item_master item_parent varchar2 25 No Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table. item_grandparent varchar225 0 1 Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table. item_master item_grandparent varchar2 25 No Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as an item and an item parent in another row on the item_master table. pack_ind varchar21 0 1 Indicates if the item is a pack. A pack item is a collection of items that may be either ordered or sold as a unit. Packs require details (i.e. component items and qtys, etc.) that other items do not. This field is required by the database. item_master pack_ind varchar2 1 Yes Indicates whether the item is a pack. A pack item is a collection of items that may be ordered or sold as a unit. Packs require details (such as. component items and quantities) that other items do not. This field is required by the database. item_level number1 0 1 Number indicating which of the three levels the item resides. The item level determines if the item stands alone or if it is part of a family of related items. The item level also determines how the item may be used throughout the system. item_master item_level number 1 Yes Number indicating on which of the three levels the item resides. The item level determines if the item stands alone or is part of a family of related items. The item level also determines how the item may be used throughout the system. tran_level number1 0 1 Number indicating which of the three levels transactions occur for the item's group. The transaction level is the level at which the item's inventory is tracked in the system. The transaction level item will be counted, transferred, shipped, etc. The transaction level may be at the current item or up to 2 levels above or below the current item. Only one level of the hierarchy of an item family may contain transaction level items. item_master tran_level null null Yes Number indicating at which of the three levels transactions occur for the item's group. The transaction level is the level at which the item's inventory is tracked in the system. The transaction level item is counted, transferred, and shipped. The transaction level may be at the current item or up to two levels above or below the current item. Only one level of the hierarchy of an item family can contain transaction level items. diff_1 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Men's pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. item_master diff_1 null null No Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (such as men's pant sizes) or a value (such as 6 ounces). For an item that is not a parent, this field may contain a value (such as 34X34 or red). Valid values are found on the diff_group and diff_id tables. diff_1_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_ids diff_type null null No This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_2 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. item_master diff_2 null null No Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (such as men's pant sizes) or a value (such as 6 ounces). For an item that is not a parent, this field may contain a value (such as 34X34 or red). Valid values are found on the diff_group and diff_id tables. diff_2_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_ids diff_type null null No This field contains a value of all possible differential types. (for example, S for size, C for color, F for flavor, E for scent, and P for pattern). Valid values are stored on the code_detail table with the code_type DIFF and in the diff_type table. diff_3 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. item_master diff_3 null null No Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. diff_3_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_ids diff_type null null No This field contains a value of all possible differential types (for example, S for size, C for color, F for flavor, E for scent, and P for pattern). Valid values are stored in the code_detail table (with the code_type DIFF) and in the diff_type table. diff_4 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. item_master diff_4 null null No Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (such as men's pant sizes) or a value (such as 6 ounces). For an item that is not a parent, this field may contain a value (such as 34X34 or red). Valid values are found on the diff_group and diff_id tables. diff_4_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_ids diff_type null null No This field will hold a value of all possible differential types (for example, S for size, C for color, F for flavor, E for scent, and P for pattern). Valid values are stored in the code_detail table (with the code_type DIFF) and in the diff_type table. dept number4 0 1 Number identifying the department to which the item is attached. The item's department will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the deps table. item_master dept number 4 No Number to identify the department to which the item belongs. The item and its parent (and its grandparent) will share the same department. Valid values for this field are in the deps table. dept_name varchar2120 0 1 Contains the name of the department. deps dept_name varchar2 20 Yes Contains the name of the department. class varchar27 0 1 Number identifying the class to which the item is attached. The item's class will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the class table. item_master class varchar2 7 Yes Number to identify the class to which the item is attached. The item and its parent (and grandparent) will share the same class. Valid values are in the class table. class_name varchar2120 0 1 Contains the name of the class. class class_name varchar2 20 Yes Contains the name of the class. subclass varchar24 0 1 Number identifying the subclass to which the item is attached. The item's subclass will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the subclass table. item_master subclass varchar2 4 Yes Number identifying the subclass to which the item is attached. The item and its parent (and grandparent) share the same subclass Valid values are located in the subclass table. sub_name varchar2120 0 1 Contains the name of the subclass. subclass sub_name varchar2 20 Yes Contains the name of the subclass. status varchar21 0 1 Status of the item. Valid values are: W = Worksheet: item setup in progress, cannot be used in system; S = Submitted: item setup complete and awaiting approval, cannot be use in system; A = Approved: item is approved and can now be used throughout the system. item_master status null Yes Status of the item. Valid value is W (worksheet). item_desc varchar2250 0 1 Long description of the item. This description is used through out the system to help online users identify the item. For items that have parents, this description will default to the parents description plus any differentiators. For items without parents this description will default to null. item_master item_desc null null Yes Long description of the item. This description is used throughout the system to help users identify the item. For items with parents, this description will default to the parent description plus any differentiators. For items without parents, the description defaults to null. short_desc varchar2120 0 1 Shortened description of the item. This description is the default for downloading to the POS. For items that have parents, this description will default to the parent's short description. For items without parents, this description will default to null. item_master short_desc null null Yes Shortened description of the item. This description is the default for downloading to the POS. For items that have parents, this description defaults to the parent's short description. For items without parents, this description defaults to null. desc_up varchar2250 0 1 All upper case description of the item (same as upper(item_desc)). This field is not displayed in the on-line item maintenance dialog, but is used in item list of value search processing through out the system. item_master desc_up varchar2 100 Yes All upper case description of the item (same as upper(item_desc)). This field is not displayed in the on-line item maintenance dialog. It is used in Item list of value search processing throughout the system. primary_ref_item_ind varchar21 0 1 Indicates if the sub-transation level item is designated as the primary sub-transaction level item. For transaction level items and above the value in this field will be 'N'o. item_master primary_ref_item_ind varchar2 1 No Indicates whether the sub-transation level item is designated as the primary sub-transaction level item. For items at transaction level and higher, the value is N. retail_zone_group_id number4 0 1 Retail pricing strategy associated with the item. item_master retail_zone_group_id number 4 No Retail pricing strategy associated with the item. cost_zone_group_id number4 0 1 Cost zone group associated with the item. This field is only required when elc_ind (landed cost indicator) is set to 'Y' on the system_options table. item_master cost_zone_group_id number 4 No Cost zone group associated with the item. This field is only required when elc_ind (landed cost indicator) is set to Y in the system_options table. standard_uom varchar24 0 1 Unit of measure in which stock of the item is tracked at a corporate level. item_master standard_uom varchar2 4 Yes Unit of measure in which stock of the item is tracked at a corporate level. uom_conv_factor number20_10 0 1 Conversion factor between an "Each" and the standard_uom when the standard_uom is not in the quantity class (e.g. if standard_uom = lb and 1 lb = 10 eaches, this factor will be 10). This factor will be used to convert sales and stock data when an item is retailed in eaches but does not have eaches as its standard unit of measure. item_master uom_conv_factor null null No Conversion factor between an Each and the standard_uom when the standard_uom is not in the quantity class. (For example, if standard_uom = lb and 1 lb = 10 eaches, this factor is 10.) This factor is used to convert sales and stock data when an item is retailed in eaches but does not have eaches as its standard unit of measure. package_size number12_4 0 1 Holds the size of the product printed on any packaging (i.e. 24 ounces). This field is used for reporting purposes, as well as by Retek Price Mangement to determine same sized and different sized items. item_master package_size number 12 No Contains the size of the product printed on packaging (such as 24 ounces). This field is used for reporting purposes and by RPM to determine same sized and different sized items. package_uom varchar24 0 1 Holds the unit of measure associated with the package size. This field is used for reporting purposes and by Retek Price Management to determine same sized and different sized items. item_master package_uom varchar2 4 No Contains the unit of measure associated with the package size. This field is used for reporting purposes and by RPM to determine same sized and different sized items. merchandise_ind varchar21 0 1 Indicates if the item is a merchandise item (Y, N). item_master merchandise_ind varchar2 1 Yes Indicates whether the item is a merchandise item. Valid values are Y and N. store_ord_mult varchar21 0 1 Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are:C = Cases; I = Inner; E = Eaches. item_master store_ord_mult null Yes Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are C (cases), I (inner), and E (eaches). forecast_ind varchar21 0 1 Indicates if this item will be interfaced to an external forecasting system (Y, N). item_master forecast_ind varchar2 1 Yes Indicates whether the item will be interfaced to an external forecasting system. Valid values are Y and N. mfg_rec_retail number20_4 0 1 Manufacturer's recommended retail price for the item. Used for informational purposes only. This field is stored in the primary currency. item_master mfg_rec_retail number 20 No Manufacturer's recommended retail price for the item, used for informational purposes only. This field is stored in the primary currency. retail_label_type varchar26 0 1 This field indicates any special lable type assoctiated with an item (i.e. pre-priced or cents off). This field is used for reporting purposes only. Values for this field are defined by the 'RTLT' code on code detail. item_master retail_label_type varchar2 6 No This field indicates the special lable type associated with an item (such as pre-priced or cents off). This field is used for reporting purposes only. Valid values are defined by the RTLT code in code detail. retail_label_type_desc varchar240 0 1 Contains the retail label type description corresponding to the retail_label_type value in item_master. code_detail code_desc varchar2 40 No Contains the retail label type description corresponding to the retail_label_type value in item_master. retail_label_value number20_4 0 1 This field represents the value associated with the retail label type. item_master retail_label_value number 20 No This field represents the value associated with the retail label type. handling_temp varchar26 0 1 Holds the temperature information associated with the item. Valid values for this field are in the code type 'HTMP' on the code_head and code_detail tables. item_master handling_temp varchar2 6 No This field contains the temperature information associated with the item. Valid values for this field are in the code type HTMP on the code_head and code_detail tables. handling_temp_desc varchar240 0 1 Contains the Handling temperature description corresponding to the handling_temp value in item_master. code_detail code_desc varchar2 40 No Contains the Handling temperature description corresponding to the handling_temp value in item_master. handling_sensitivity varchar26 0 1 Holds the sensitivity information associated with the item. Valid values for this field are in the code type 'HSEN' on the code_head and code_detail tables. item_master handling_sensitivity varchar2 6 No This field contains the sensitivity information associated with the item. Valid values for this field are in the code type HSEN in the code_head and code_detail tables. handling_sensitivity_desc varchar240 0 1 Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. code_detail code_desc varchar2 40 No Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. catch_weight_ind varchar21 0 1 Indiactes whether the item should be weighed when it arives at a location. Valid values for this field are 'Y' and 'N'. item_master catch_weight_ind varchar2 1 Yes Indicates whether the item should be weighed when it arrives at a location. Valid values are Y and N. waste_type varchar26 0 1 Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (i.e. fat is trimmed off at customer request). Spoilage wastage occurs during the products shelf life (i.e. evaporation causes the product to weight less after a period of time). Valid values are: SP - spoilage; and SL - Sales. item_master waste_type null No Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (for example, fat is trimmed off at customer request). Spoilage wastage occurs during the product's shelf life (for example, evaporation causes the product to weigh less after a period of time). Valid values are SP (spoilage) and SL (sales). waste_type_desc varchar240 0 1 Contains the Waste Type description corresponding to the Waste_Type value in item_master. code_detail code_desc varchar2 40 No Contains the Waste Type description corresponding to the Waste_Type value in item_master. waste_pct number12_4 0 1 Average percent of wastage for the item over its shelf life. Used in inflating the retail price for wastage items. item_master waste_pct number 12 No Average percent of wastage for the item throughout its shelf life. Used in inflating the retail price for wastage items. default_waste_pct number12_4 0 1 Default daily wastage percent for spoilage type wastage items. This value will default to all item locations and represents the average amount of wastage that occurs on a daily basis. item_master default_waste_pct number 12 No Default daily wastage percent for spoilage type wastage items. This value defaults to all item locations and represents the average amount of wastage that occurs on a daily basis. const_dimen_ind varchar21 0 1 Indicates that the dimensions of the product are always the same, regardless of the supplier. If this field is Y, the dimensions for all suppliers will be defaulted to the primary supplier/primary country dimensions. Editing of dimensions for the item will only be allowed for the primary supplier/primiary country. item_master const_dimen_ind null null Yes Indicates that the dimensions of the product are always the same, regardless of the supplier. If this field is Y, the dimensions for all suppliers default to the primary supplier/primary country dimensions. Editing of dimensions for the item will be allowed only for the primary supplier/primiary country. simple_pack_ind varchar21 0 1 Indicates if pack item is a simple pack or not. This field will only be available if the item is a pack item. A simple pack is an item whose components are all the same item (i.e. a six pack of cola, etc). Valid values are:Y = Yes, this item is a simple pack; N = No if this is not a simple pack. item_master simple_pack_ind null Yes Indicates whether the pack item is a simple pack. This field is available only if the item is a pack item. A simple pack is an item for which the components are all the same item (such as a six pack of cola). Valid values are Y (this item is a simple pack) and N (this is not a simple pack). contains_inner_ind varchar21 0 1 Indicates if pack item contains inner packs. Vendor packs will never contain inner packs and this field will be defaulted to 'N'. This field will only be available if the item is a pack item. Valid values are:Y = Yes, this pack contains inner packs; N = No, this pack does not contain inner packs. item_master contains_inner_ind null Yes Indicates if pack item contains inner packs. This field will only be available if the item is a pack item. Valid values are Y (this pack contains inner packs) and N (this pack does not contain inner packs). Vendor packs will never contain inner packs, and this field will default to N. sellable_ind varchar21 0 1 Indicates if pack item may be sold as a unit. If it is 'Y' then the pack will have its own unique unit retail. If it is 'N' then the pack's unit retail is the sum of each individual item's total retail within the pack. This field will only be available if the item is a pack item. Value values are: Y = Yes, this pack may be sold as a unit; N = No, this pack man not be sold as a unit. item_master sellable_ind null Yes Indicates whether the pack item may be sold as a unit. This field is available only if the item is a pack item. Value values are Y (this pack may be sold as a unit) and N (this pack may not be sold as a unit). If Y, the pack will have its own unique unit retail. If N, the pack's unit retail is the sum of each individual item's total retail within the pack. orderable_ind varchar21 0 1 Indicates if pack item is orderable. If it is 'Y' then the suppliers of the pack must supply all components in the pack. If it is 'N' then the components may have different suppliers. This field will only be available if the item is a pack item. Valid values are: Y = Yes, this pack may be ordered, N = No, this pack may not be ordered. item_master orderable_ind null Yes Indicates whether the pack item is orderable. This field will only be available if the item is a pack item. Valid values are Y (this pack may be ordered) abd N (this pack may not be ordered). If Y, the suppliers of the pack must supply all components in the pack. If N, then the components may have different suppliers. pack_type varchar21 0 1 Indicates if pack item is a vendor pack or a buyer pack. A vendor pack is a pack that the vendor or supplier recognizes and sells to the retailer. If the pack item is a vendor pack, communication with the supplier will use the vendor pack number. A buyer pack is a pack that a buyer created for internal ease of use. If the pack item is a buyer pack communication with the supplier will explode the pack out to its component items. This field will only be available if the item is a pack item. If the pack item is not orderable this field must be null. Valid values are: V = Vendor; B = Buyer. item_master pack_type null No Indicates whether pack item is a vendor pack or a buyer pack. A vendor pack is a pack that the vendor or supplier recognizes and sells to the retailer. If the pack item is a vendor pack, communication with the supplier will include the vendor pack number. A buyer pack is a pack that a buyer created for internal ease of use. If the pack item is a buyer pack, communication with the supplier will explode the pack out to its component items. This field will be available only if the item is a pack item. If the pack item is not orderable, this field must be null. Valid values are V (vendor) and B (buyer). order_as_type varchar21 0 1 Indicates if pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if pack item is an orderable buyer pack. This field must be NULL if the pack is sellable only or a vendor pack. This field will only be available if the item is a pack item. Valid Values are: E = Eaches (component level) P = Pack (buyer pack only). item_master order_as_type null No Indicates whether the pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if the pack item is an orderable buyer pack.This field must be NULL if the pack is sellable only or a vendor pack. This field will only be available if the item is a pack item. Valid values are E = Eaches (component level) and P = Pack (buyer pack only). comments varchar22000 0 1 Holds any comments associated with the item. item_master comments varchar2 2000 No Contains comments associated with the item. unit_retail number20_4 0 1 This field holds the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency. item_zone_price unit_retail number 20 No This field contains the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency. item_service_level varchar26 0 1 Holds a value that restricts the type of shipment methods that RCOM can select for an item. item_master item_service_level varchar2 6 No Contains a value that restricts the type of shipment methods that RCOM can select for an item. gift_wrap_ind varchar21 0 1 This field will contain a value of 'Y' if the item is eligible to be gift wrapped. item_master gift_wrap_ind varchar2 1 Yes This field contains Y if the item is eligible to be gift wrapped. ship_alone_ind varchar21 0 1 This field will contain a value of 'Y' if the item should be shipped to the customer is a seperate package versus being grouped together in a box. item_master ship_alone_ind varchar2 1 Yes This field will contain Y if the item should be shipped to the customer in a separate package (instead of being grouped together in a box). vendor_style varchar215 0 1 Not used by RMS. N/A N/A varchar2 15 No Not used by RMS. std_unit_weight number20_10 0 1 Not used by RMS. N/A N/A number 20 No Not used by RMS. single_price_flag varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. preticket_flag varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. planned_residual varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. autopackable number8 0 1 Not used by RMS. n/a n/a number 8 No Not used by RMS. sortable varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. item_master_uda1 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda2 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda3 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda4 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda5 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda6 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda7 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda8 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda9 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda10 varchar220 0 1 Not used by RMS. n/a n/a varchar2 20 No Not used by RMS. item_master_uda11 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda12 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda13 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda14 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. item_master_uda15 varchar220 0 1 Not used by RMS. N/A N/A varchar2 20 No Not used by RMS. ship_alone varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. slottable varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. freight_class varchar24 0 1 Not used by RMS. N/A N/A varchar2 4 No Not used by RMS. new_item varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. brand varchar210 0 1 Not used by RMS. n/a n/a varchar2 10 No Not used by RMS. break_case_ups varchar24 0 1 Not used by RMS. n/a n/a varchar2 4 No Not used by RMS. rigid varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. fragile varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. container_type varchar26 0 1 Not used by RMS. N/A N/A varchar2 6 No Not used by RMS. conveyable_flag varchar21 0 1 Not used by RMS. n/a n/a varchar2 1 No Not used by RMS. hazard_matl_code varchar26 0 1 Not used by RMS. N/A N/A varchar2 6 No Not used by RMS. velocity number12_4 0 1 Not used by RMS. N/A N/A number 12 No Not used by RMS. high_value_ind varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. ticket_type varchar24 0 1 Not used by RMS. N/A N/A varchar2 4 No Not used by RMS. color varchar224 0 1 Not used by RMS. n/a n/a varchar2 24 No Not used by RMS. size1 varchar26 0 1 Not used by RMS. N/A N/A varchar2 6 No Not used by RMS. fit varchar26 0 1 Not used by RMS. N/A N/A varchar2 6 No Not used by RMS. shade varchar26 0 1 Not used by RMS. N/A N/A varchar2 6 No Not used by RMS. single_contain_bulk varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. unit_pick_system_code varchar212 0 1 Not used by RMS. N/A N/A varchar2 4 No Not used by RMS. roundable_flag varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. perishable_ind varchar21 0 1 Not used by RMS. N/A N/A varchar2 1 No Not used by RMS. division number4 0 1 Not used by RMS. n/a n/a number 4 No Not used by RMS. vendor_nbr varchar210 0 1 Not used by RMS. N/A N/A varchar2 10 No Not used by RMS. kitting_wip_code varchar29 0 1 Wip code used to designate the Kitting process used in item_master N/A N/A varchar2 6 No WIP code used to designate the kitting process used in item_master unit_ticket_qty number3 0 1 Item Master User Defined Attribute N/A N/A number 3 No Item Master user defined attribute. item_length number12_4 0 1 Length of an individual item n/a n/a number 12 No Length of an individual item. item_width number12_4 0 1 Width of an individual item N/A N/A number 12 No Width of an individual item. item_height number12_4 0 1 Height of an individual Item n/a n/a number 12 No Height of an individual Item item_weight number12_4 0 1 Weight of an individual item N/A N/A number 12 No Weight of an individual item item_cube number12_4 0 1 Cubic dimension of an individual item n/a n/a number 12 No Cubic dimension of an individual item. std_unit_factor number6_2 0 1 Used for putaway by volume. The percentage of the standard number of units that will fit into a location type. N/A N/A number 6 No Used for putaway by volume. The percentage of the standard number of units that will fit into a location type. std_unit_qty number12_4 0 1 The number of items that normally fit on/in the container type N/A N/A number 12 No The number of items that normally fits in the container type. expiration_days number4 0 1 The number of days before inventory is deemed to be no longer distributable n/a n/a number 4 No The number of days before inventory no longer distributable. putaway_by_volume varchar26 0 1 If set to Y, putaway will be determined by cube or volume. If set to N, putaway will be determined by capacity. N/A N/A varchar2 6 No If set to Y, putaway is determined by cube or volume. If set to N, putaway is determined by capacity. putaway_plan varchar220 0 1 Plan used for putaway N/A N/A varchar2 6 No Plan used for putaway. item_type varchar26 0 1 This column contains a character indicator to determine if the item being ordered is a pack or not. N/A N/A varchar2 6 No This column contains a character to determine if the item being ordered is a pack. sorter_group varchar26 0 1 Sorter Group identifier N/A N/A varchar2 6 No Sorter Group identifier. sku_optimization varchar21 0 1 Indicator for inclusion in SKU optimization N/A N/A varchar2 1 No Indicator for inclusion in SKU optimization. ext_source_system varchar26 0 1 Specifies what external system the data originated from. N/A N/A varchar2 6 No Specifies the external system from which the data originated. item_xform_ind varchar21 0 1 Indicator shows that an item is associated with an item transformation. The item is either the sellable or the orderable item in the transformation process. N/A N/A varchar2 1 No Indicates that an item is associated with an item transformation. The item is either the sellable or the orderable item in the transformation process. inventory_ind varchar21 0 1 Inventory Indicator N/A N/A varchar2 1 No Inventory indicator. order_type varchar29 0 1 Indicates the type of order and which Open To Buy bucket will be updated. N/A N/A varchar2 9 No Indicates the type of order and which Open To Buy bucket will be updated. sale_type varchar26 0 1 n/a N/A N/A varchar2 6 No N/A deposit_item_type varchar26 0 1 n/a N/A N/A varchar2 6 No N/A container_item varchar225 0 1 n/a N/A N/A varchar2 25 No N/A deposit_in_price_per_uom varchar26 0 1 n/a N/A N/A varchar2 6 No N/A transport_ind varchar21 0 1 n/a N/A N/A varchar2 1 No N/A notional_pack_ind varchar21 0 1 Indicates in SIM if a sellable simple pack needs to be broken down to its component item. NA NA NA NA NA NA soh_inquiry_at_pack_ind varchar21 0 1 Indicates in SIM if a notional simple pack item's inventory should be displayed in packs. NA NA NA NA NA NA purchase_type varchar26 0 1 Indicates if an item is a normal, consignment or concession item - 'N' for normal, 'S' for consignment, 'C' for concession. NA NA NA NA NA NA ExtOfItemHdrDesc:ExtOfItemHdrDesc * 0 1 Provide an extension hook to customize ItemHdrDesc. NA NA NA NA NA NA LocOfItemHdrDesc:LocOfItemHdrDesc * 0 1 Provide an extension hook to localize ItemHdrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemHdrDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemHdrDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemHdrDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemHdrDesc Table Name Column Name API Type Column Length API Required API Description InItemHdrDesc:InItemHdrDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemHdrDesc:BrItemHdrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemSupDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemSupDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Unique identifier for the item. item_supplier item varchar2 25 Yes Unique identifier for the item. supplier varchar210 1 1 Unique identifier for the supplier. item_supplier supplier varchar2 10 Yes Unique identifier for the supplier. primary_supp_ind varchar23 1 1 This field indicates whether this supplier is the primary supplier for the item. An item can have one and only one primary supplier. item_supplier primary_supp_ind varchar2 3 Yes This field indicates whether this supplier is the primary supplier for the item. An item can have only one primary supplier. vpn varchar230 0 1 This field contains the Vendor Product Number for the Item. item_supplier vpn null null No This field contains the Vendor Product Number for the Item. supp_label varchar215 0 1 This field contains the supplier label. It will only be popluated if item is a style. item_supplier supp_label null null No This field contains the supplier label. It is populated only if item is a style. consignment_rate number12_4 0 1 This field contains the consignment rate for this item for the supplier. item_supplier consignment_rate number 12 No This field contains the consignment rate for this item for the supplier. supp_diff_1 varchar2120 0 1 This field contains the first supplier differentiator and/or description. This field may only contain a value for items with an item_parent. item_supplier supp_diff_1 varchar2 80 No This field contains the first supplier differentiator and/or description. This field may contain only a value for items with an item_parent. supp_diff_2 varchar2120 0 1 This field contains the second supplier differentiator and/or description. This field may only contain a value for items with an item_parent. item_supplier supp_diff_2 varchar2 80 No This field contains the second supplier differentiator and/or description. This field may contain only a value for items with an item_parent. supp_diff_3 varchar2120 0 1 This field contains the third supplier differentiator and/or description. This field may only contain a value for items with an item_parent. item_supplier supp_diff_3 varchar2 80 No This field contains the third supplier differentiator and/or description. This field may contain only a value for items with an item_parent. supp_diff_4 varchar2120 0 1 This field contains the fourth supplier differentiator and/or description. This field may only contain a value for items with an item_parent. item_supplier supp_diff_4 varchar2 80 No This field contains the fourth supplier differentiator and/or description. This field may contain only a value for items with an item_parent. pallet_name varchar26 0 1 Code referencing the name used to refer to the pallet. item_supplier pallet_name varchar2 6 Yes Code referencing the name used to refer to the pallet. case_name varchar26 0 1 Code referencing the name used to refer to the case. item_supplier case_name varchar2 6 Yes Code referencing the name used to refer to the case. inner_name varchar26 0 1 Code referencing the name used to refer to the inner. item_supplier inner_name varchar2 6 Yes Code referencing the name used to refer to the inner. supp_discontinue_date xs:dateTime 0 1 Date when the supplier discontinues an item. item_supplier supp_discontinue_date RIBDate n/a No Date on which the supplier discontinues an item. direct_ship_ind varchar21 0 1 A value of 'Y'es in this field indicates that any item associated with this supplier is eligible for a direct shipment from the supplier to the customer. item_supplier direct_ship_ind varchar2 1 Yes A "Y" in this field indicates that any item associated with this supplier is eligible for a direct shipment from the supplier to the customer. ExtOfItemSupDesc:ExtOfItemSupDesc * 0 1 Provide an extension hook to customize ItemSupDesc. NA NA NA NA NA NA LocOfItemSupDesc:LocOfItemSupDesc * 0 1 Provide an extension hook to localize ItemSupDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemSupDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemSupDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemSupDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemSupDesc Table Name Column Name API Type Column Length API Required API Description InItemSupDesc:InItemSupDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemSupDesc:BrItemSupDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemSupCtyDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemSupCtyDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Unique identifier for the item. item_supp_country item varchar2 25 Yes Unique identifier for the item. supplier varchar210 1 1 Unique identifier for the supplier. item_supp_country supplier varchar2 10 Yes Unique identifier for the supplier. origin_country_id varchar23 1 1 The country where the item was manufactured or significantly altered. item_supp_country origin_country_id varchar2 3 Yes The country in which the item was manufactured or significantly altered. primary_supp_ind varchar23 1 1 This field indicates whether this supplier is the primary supplier for the item. Each item can have one and only one primary supplier. item_supp_country primary_supp_ind null null Yes This field indicates whether this supplier is the primary supplier for the item. Each item can have only one primary supplier. primary_country_ind varchar21 1 1 This field indicates whether this country is the primary country for the item/supplier. Each item/supplier combination can have one and only one primary country. item_supp_country primary_country_ind null null Yes This field indicates whether this country is the primary country for the item/supplier. Each item/supplier combination can have only one primary country. unit_cost number20_4 1 1 This field contains the current corporate unit cost for the item from the supplier /origin country. This field is stored in the Supplier's currency. item_supp_country unit_cost null null Yes This field contains the current corporate unit cost for the item from the supplier /origin country. This field is stored in the Supplier's currency. lead_time number4 0 1 This field contains the number of days that will elapse between the date an order is written and the delivery to the store or warehouse from the supplier. item_supp_country lead_time number 4 No This field contains the number of days that will elapse between the date an order is written and the delivery to the store or warehouse from the supplier. pickup_lead_time number4 0 1 Contains the time that will be taken to get the item from the supplier to the initial receiving location. item_supp_country pickup_lead_time number 4 No Contains the time required to get the item from the supplier to the initial receiving location. supp_pack_size number12_4 1 1 This field contains the quantity that orders must be placed in multiples of for the supplier for the item. item_supp_country supp_pack_size null null Yes When orders are place in multiples, this field contains the multiple quantity for the supplier of the item. inner_pack_size number12_4 1 1 This field contains the break pack size for this item from the supplier. item_supp_country inner_pack_size null null Yes This field contains the break pack size for this item from the supplier. round_lvl varchar26 1 1 This column is used to determine how order quantities will be rounded to case, layer and pallet. item_supp_country round_lvl null null Yes This column is used to determine how order quantities are rounded to case, layer and pallet. min_order_qty number12_4 0 1 This field contains the minimum quantity that can be ordered at one from the supplier for the item. item_supp_country min_order_qty number 12 No This field contains the minimum quantity that can be ordered at one from the supplier for the item. max_order_qty number12_4 0 1 This field contains the maximum quantity that can be ordered at one from the supplier for the item. item_supp_country max_order_qty number 12 No This field contains the maximum quantity that can be ordered at one from the supplier for the item. packing_method varchar26 0 1 This field indicates whether the packing method for the item in the container is flat or hanging. item_supp_country packing_method varchar2 6 No This field indicates whether the packing method for the item in the container is flat or hanging. default_uop varchar26 0 1 Contains the default unit of purchase for the item/supplier/country. Valid values include 'C'ase and 'P'allet. item_supp_country default_uop varchar2 6 No Contains the default unit of purchase for the item/supplier/country. Valid values are C (case) and P (pallet). ti number12_4 1 1 Number of shipping units (cases) that make up one tier of the pallet. Multiply TI x HI to get total number of units (cases) in a Pallet. item_supp_country ti null null Yes Number of shipping units (cases) that make up one tier of the pallet. Multiply TI by HI to get total number of units (cases) in a pallet. hi number12_4 1 1 Number of tiers that make up a complete pallet. Multiply TI x HI to get total number of units (cases) in a Pallet. item_supp_country hi null null Yes Number of tiers that make up a complete pallet. Multiply TI by HI for the total number of units (cases) in a pallet. cost_uom varchar24 0 1 A cost UOM is held to allow costs to be managed in a separate UOM to the standard UOM. item_supp_country cost_uom null null Yes A cost UOM allows costs to be managed in a UOM separate from the standard UOM. tolerance_type varchar26 0 1 The unit of tolerance for catch weight simple packs. Valid values are: 'A'-actual 'P' - percent. item_supp_country tolerance_type varchar2 No The unit of tolerance for catch weight simple packs. Valid values are A (actual) and P (percent). max_tolerance number12_4 0 1 The maximum tolerance value for the catch weight simple pack. item_supp_country max_tolerance number 12 No The maximum tolerance value for the catch weight simple pack. min_tolerance number12_4 0 1 The minimum tolerance value for a catch weight simple pack item_supp_country min_tolerance number 12 No The minimum tolerance value for a catch weight simple pack ExtOfItemSupCtyDesc:ExtOfItemSupCtyDesc * 0 1 Provide an extension hook to customize ItemSupCtyDesc. NA NA NA NA NA NA LocOfItemSupCtyDesc:LocOfItemSupCtyDesc * 0 1 Provide an extension hook to localize ItemSupCtyDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemSupCtyDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemSupCtyDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemSupCtyDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemSupCtyDesc Table Name Column Name API Type Column Length API Required API Description InItemSupCtyDesc:InItemSupCtyDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemSupCtyDesc:BrItemSupCtyDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ISCDimDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ISCDimDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Unique identifier for the item. item_supp_country_dim item varchar2 25 Yes Unique identifier for the item. supplier varchar210 1 1 Unique identifier for the supplier. item_supp_country_dim supplier varchar2 10 Yes Unique identifier for the supplier. origin_country varchar23 1 1 The country where the item was manufactured or significantly altered. item_supp_country_dim origin_country varchar2 3 Yes The country where the item was manufactured or significantly altered. dim_object varchar26 1 1 Specific object whose dimensions are specified in this record. item_supp_country_dim dim_object varchar2 6 Yes Specific object for which dimensions are specified in this record. object_desc varchar240 0 1 Dim_object description fetched from the code_detail table. code_detail code_desc/object_desc varchar2 40 No Dim_object description from the code_detail table. presentation_method varchar26 0 1 Describes the packaging (if any) being taken into consideration in the specified dimensions. item_supp_country_dim presentation_method varchar2 6 No Describes the packaging (if any) being taken into consideration in the specified dimensions. method_desc varchar240 0 1 Presentation method description fetched from the code_detail table. code_detail code_desc/method_desc varchar2 40 No Presentation method description from the code_detail table. length number12_4 0 1 Length of dim_object measured in units specified in lwh_uom. item_supp_country_dim length number 12 No Length of dim_object measured in units specified in lwh_uom. width number12_4 0 1 Width of dim_object measured in units specified in lwh_uom. item_supp_country_dim width number 12 No Width of dim_object measured in units specified in lwh_uom. height number12_4 0 1 Height of dim_object measured in units specified in lwh_uom. item_supp_country_dim height number 6 No Height of dim_object measured in units specified in lwh_uom. lwh_uom varchar24 0 1 Unit of measurement for length, width and height. item_supp_country_dim lwh_uom varchar2 4 No Unit of measurement for length, width, and height. weight number12_4 0 1 Weight of dim_object measured in units specified in weight_uom. item_supp_country_dim weight number 12 No Weight of dim_object measured in units specified in weight_uom. net_weight number12_4 0 1 Net weight of the dim_object (weight without packaging) measured in units specified in weight_uom. item_supp_country_dim net_weight varchar2 12 No Net weight of the dim_object (weight without packaging) measured in units specified in weight_uom. weight_uom varchar24 0 1 Unit of measurement for weight. item_supp_country_dim weight_uom varchar2 4 No Unit of measurement for weight. liquid_volume number12_4 0 1 Liquid volume, or capacity, of dim_object measured in units specified in colume_uom. Liquid volumes are only convertible to other liquid volumes. item_supp_country_dim liquid_volume number 12 No Liquid volume, or capacity, of dim_object measured in units specified in volume_uom. Liquid volumes are only convertible to other liquid volumes. liquid_volume_uom varchar24 0 1 Unit of measurement for liquid volume. Liquid volumes are only convertible to other liquid volumes. item_supp_country_dim liquid_volume_uom varchar2 4 No Unit of measurement for liquid volume. Liquid volumes are only convertible to other liquid volumes. stat_cube number12_4 0 1 Statistical value of the dim_object's dimensions to be used for loading purposes. item_supp_country_dim stat_cube varchar2 12 No Statistical value of the dim_object's dimensions to be used for loading purposes. tare_weight number12_4 0 1 Amount of weight to be subtracted for packaging materials. Used to calculate the true net weight of the dim_object. item_supp_country_dim tare_weight number 12 No Amount of weight to be subtracted for packaging materials. Used to calculate the true net weight of the dim_object. tare_type varchar26 0 1 Indicates whether the tare weight for the dim_object is wet or dry. item_supp_country_dim tare_type varchar2 6 No Indicates whether the tare weight for the dim_object is wet or dry. ExtOfISCDimDesc:ExtOfISCDimDesc * 0 1 Provide an extension hook to customize ISCDimDesc. NA NA NA NA NA NA LocOfISCDimDesc:LocOfISCDimDesc * 0 1 Provide an extension hook to localize ISCDimDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfISCDimDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfISCDimDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfISCDimDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfISCDimDesc Table Name Column Name API Type Column Length API Required API Description InISCDimDesc:InISCDimDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrISCDimDesc:BrISCDimDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemUDALOVDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemUDALOVDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Item ID uda_item_lov item varchar2 25 Yes Item ID uda_id number5 1 1 This field contains the unique identified of the Attribute Group being added or delete to the item list. uda_item_lov uda_id number 5 Yes This field contains the unique identified of the Attribute Group being added or delete to the item list. uda_value varchar230 1 1 Contains the value of the Attribute Group. uda_item_lov uda_value varchar2 30 Yes Contains the value of the Attribute Group. ExtOfItemUDALOVDesc:ExtOfItemUDALOVDesc * 0 1 Provide an extension hook to customize ItemUDALOVDesc. NA NA NA NA NA NA LocOfItemUDALOVDesc:LocOfItemUDALOVDesc * 0 1 Provide an extension hook to localize ItemUDALOVDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemUDALOVDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemUDALOVDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemUDALOVDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemUDALOVDesc Table Name Column Name API Type Column Length API Required API Description InItemUDALOVDesc:InItemUDALOVDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemUDALOVDesc:BrItemUDALOVDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemUDAFFDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemUDAFFDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Unique identifier for the item. uda_item_ff item varchar2 25 Yes Unique identifier for the item. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. uda_item_ff uda_id number 5 Yes This field contains a number to identify the user defined attribute. uda_text varchar2250 0 1 This field contains the text value of the user-defined attribute for the item. uda_item_ff uda_text varchar2 250 No This field contains the text value of the user defined attribute for the item. ExtOfItemUDAFFDesc:ExtOfItemUDAFFDesc * 0 1 Provide an extension hook to customize ItemUDAFFDesc. NA NA NA NA NA NA LocOfItemUDAFFDesc:LocOfItemUDAFFDesc * 0 1 Provide an extension hook to localize ItemUDAFFDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemUDAFFDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemUDAFFDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemUDAFFDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemUDAFFDesc Table Name Column Name API Type Column Length API Required API Description InItemUDAFFDesc:InItemUDAFFDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemUDAFFDesc:BrItemUDAFFDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemUDADateDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemUDADateDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Unique identifier for the item. uda_item_date item varchar2 25 Yes Unique identifier for the item. uda_id number5 1 1 This field contains a number identifying the user-defined attribute. uda_item_date uda_id number 5 Yes This field contains a number to identify the user-defined attribute. uda_date xs:dateTime 1 1 This field contains the effective date for the Uda id. uda_item_date uda_date RIBDate N/A Yes This field contains the effective date for the UDA ID. ExtOfItemUDADateDesc:ExtOfItemUDADateDesc * 0 1 Provide an extension hook to customize ItemUDADateDesc. NA NA NA NA NA NA LocOfItemUDADateDesc:LocOfItemUDADateDesc * 0 1 Provide an extension hook to localize ItemUDADateDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemUDADateDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemUDADateDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemUDADateDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemUDADateDesc Table Name Column Name API Type Column Length API Required API Description InItemUDADateDesc:InItemUDADateDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemUDADateDesc:BrItemUDADateDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemImageDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemImageDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Unique identifier for the item. item_image item varchar2 25 Yes Unique identifier for the item. image_name varchar2120 1 1 Name of the image. item_image image_name varchar2 64 Yes Name of the image. image_addr varchar2255 1 1 Path where the image file is stored. item_image image_addr varchar2 255 Yes Path where the image file is stored. ExtOfItemImageDesc:ExtOfItemImageDesc * 0 1 Provide an extension hook to customize ItemImageDesc. NA NA NA NA NA NA LocOfItemImageDesc:LocOfItemImageDesc * 0 1 Provide an extension hook to localize ItemImageDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemImageDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemImageDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemImageDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemImageDesc Table Name Column Name API Type Column Length API Required API Description InItemImageDesc:InItemImageDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemImageDesc:BrItemImageDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemUPCDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemUPCDesc Table Name Column Name API Type Column Length API Required API Description item_id varchar225 1 1 Unique identifier for the item. item_master item_id varchar2 25 Yes Unique identifier for the item. item_parent varchar225 0 1 Unique identifier for the item/group at the level above the item. item_master item_parent varchar2 25 No Unique identifier for the item/group at the level above the item. primary_ref_item_ind varchar21 0 1 Indicates if the sub-transaction level item is designated as the primary sub-transaction level item. For transaction level items and above, the value in this field will be 'N'o. item_master primary_ref_item_ind varchar2 1 No Indicates if the sub-transaction level item is designated as the primary sub-transaction level item. For transaction level items and above, the value is N. format_id varchar21 0 1 This field will hold the format id that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. item_master format_id varchar2 1 No This field contains the format ID that corresponds to the item's variable UPC. This value is used only for items with variable UPCs. prefix number2 0 1 This field holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. item_master prefix number 2 No This field contains the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and is used to decode variable weight UPCs that are uploaded from the POS. item_number_type varchar26 0 1 This type can hold a number of digits count umber_type. item_master item_number_type varchar2 6 No Code specifying item type. ExtOfItemUPCDesc:ExtOfItemUPCDesc * 0 1 Provide an extension hook to customize ItemUPCDesc. NA NA NA NA NA NA LocOfItemUPCDesc:LocOfItemUPCDesc * 0 1 Provide an extension hook to localize ItemUPCDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemUPCDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemUPCDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemUPCDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemUPCDesc Table Name Column Name API Type Column Length API Required API Description InItemUPCDesc:InItemUPCDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemUPCDesc:BrItemUPCDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemBOMDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemBOMDesc Table Name Column Name API Type Column Length API Required API Description pack_no varchar225 1 1 Unique identifier for the pack item. packitem_breakout pack_no varchar2 25 Yes Unique identifier for the pack item. item varchar225 1 1 Unique identifier for the component item. packitem_breakout item varchar2 25 Yes Unique identifier for the component item. pack_qty number12_4 1 1 Contains the quantity of each item in the pack item. packitem_breakout pack_item_qty number 12 Yes Contains the quantity of each item in the pack item. ExtOfItemBOMDesc:ExtOfItemBOMDesc * 0 1 Provide an extension hook to customize ItemBOMDesc. NA NA NA NA NA NA LocOfItemBOMDesc:LocOfItemBOMDesc * 0 1 Provide an extension hook to localize ItemBOMDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemBOMDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemBOMDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemBOMDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemBOMDesc Table Name Column Name API Type Column Length API Required API Description InItemBOMDesc:InItemBOMDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemBOMDesc:BrItemBOMDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemTcktDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemTcktDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Unique identifier for the item. item_ticket item varchar2 25 Yes Unique identifier for the item. ticket_type_id varchar24 1 1 This field uniquely identifies the ticket type which is associated with the item. item_ticket ticket_type_id varchar2 4 Yes This field uniquely identifies the ticket type associated with the item. ExtOfItemTcktDesc:ExtOfItemTcktDesc * 0 1 Provide an extension hook to customize ItemTcktDesc. NA NA NA NA NA NA LocOfItemTcktDesc:LocOfItemTcktDesc * 0 1 Provide an extension hook to localize ItemTcktDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemTcktDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemTcktDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemTcktDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemTcktDesc Table Name Column Name API Type Column Length API Required API Description InItemTcktDesc:InItemTcktDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemTcktDesc:BrItemTcktDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemSupCtyMfrDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ItemSupCtyMfrDesc Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Item ID. NA NA NA NA NA NA supplier number10 1 1 Supplier ID. NA NA NA NA NA NA manufacturer_ctry_id varchar23 1 1 Country ID of manufacturer. NA NA NA NA NA NA primary_manufacturer_ctry_ind varchar21 1 1 Primary country of manufacturer indicator. NA NA NA NA NA NA ExtOfItemSupCtyMfrDesc:ExtOfItemSupCtyMfrDesc * 0 1 Provide an extension hook to customize ItemSupCtyMfrDesc. NA NA NA NA NA NA LocOfItemSupCtyMfrDesc:LocOfItemSupCtyMfrDesc * 0 1 Provide an extension hook to localize ItemSupCtyMfrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemSupCtyMfrDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemSupCtyMfrDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemSupCtyMfrDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemSupCtyMfrDesc Table Name Column Name API Type Column Length API Required API Description InItemSupCtyMfrDesc:InItemSupCtyMfrDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemSupCtyMfrDesc:BrItemSupCtyMfrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfItemDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfItemDesc Table Name Column Name API Type Column Length API Required API Description InItemDesc:InItemDesc * 0 unbounded India Localization. NA NA NA NA NA NA BrItemDesc:BrItemDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA