Retail Integration Mappings Report Release:16.0.030

(Retail Merchandising System)

Application Retail Merchandising System Target Name Space http://www.oracle.com/retail/integration/base/bo/XItemDesc/v1 Version 1.3 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure XItemDesc XItemCtryDesc LocOfXItemCtryDesc XItemSupDesc XItemSupCtyDesc XItemCostDesc LocOfXItemCostDesc XISCLocDesc LocOfXISCLocDesc XISCDimDesc LocOfXISCDimDesc CustFlexAttriVo LocOfXItemSupCtyDesc XItmSupCtyMfrDesc CustFlexAttriVo LocOfXItemSupDesc LangOfXItemSupDesc XItemBOMDesc LocOfXItemBOMDesc XItemVATDesc LocOfXItemVATDesc XIZPDesc LocOfXIZPDesc XItemUDADtl LocOfXItemUDADtl XItemSeason LocOfXItemSeason XItemImage LocOfXItemImage LangOfXItemImage CustFlexAttriVo LocOfXItemDesc LangOfXItemDesc XItemHTSDesc XItemHTSAssessDesc LocOfXItmHTSAssDesc LocOfXItemHTSDesc XItemExpDesc LocOfXItemExpDesc XItemTicketDesc LocOfXItemTicketDesc

XML-Schema Name:XItemDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description item varchar225 1 1 The unique identifier of the main item on the message. item_master item varchar2 25 Yes Unique alphanumeric value that identifies the item. item_parent varchar225 0 1 The item at the level above this item. This value must be predefined as an item 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 The item two levels above this item. This value must be predefined as an item 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 both 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 item. Valid values are Y (yes) and N (no). This value cannot be modified. item_master pack_ind varchar2 1 Yes 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_level number1 0 1 The level of the item. Valid values are 1 (single level or pack item), 2 (child item), and 3 (grandchild item). item_master item_level number 1 Yes 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. tran_level number1 0 1 The transaction level of the item. Valid values are 1, 2, and 3. If this is a transaction item this will equal the item level. If the item is a pack this will equal 1. This value cannot be modified. item_master tran_level number 1,0 Yes The transaction level of the item. Valid values are 1, 2, and 3. If this is a transaction item, it will equal the item level. If the item is a pack this will equal 1. This value cannot be modified. diff_1 varchar210 0 1 A differentiator id which differentiates a transaction level item from its parent item. If the item on the message is a parent this field may hold a differentiator group id. This value must be predefined on the DIFF_IDS or DIFF_GROUP_HEAD table. item_master diff_1 varchar2 10 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_2 varchar210 0 1 See description for diff_1. item_master diff_2 varchar2 10 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 varchar210 0 1 See description for diff_1. item_master diff_3 varchar2 10 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_4 varchar210 0 1 See description for diff_1. item_master diff_4 varchar2 10 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. dept number4 0 1 The number of the department to which this item belongs. This value must be predefined on the DEPS table. It cannot be modified. item_master dept number 4 Yes The number of the department to which this item belongs. This value must be predefined on the DEPS table. It cannot be modified. class number4 0 1 The number of the class to which the item belongs. This value must be predefined on the CLASS table. It cannot be modified. item_master class number 4,0 Yes Number identifying the class to which the item is attached. The items 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. subclass number4 0 1 The number of the subclass to which the item belongs. This value must be predefined on the SUBCLASS table. It cannot be modified. item_master subclass number 4,0 Yes The number of the subclass to which the item belongs. This value must be predefined in the SUBCLASS table. It cannot be modified. item_desc varchar2250 0 1 The long description of the item. item_master item_desc varchar2 250 Yes 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. iscloc_hier_level varchar22 0 1 The level of the organizational hierarchy used to create item\supplier\country\location relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), W (warehouse). * * null null No The level of the organizational hierarchy used to create item\supplier\country\location relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse). izp_hier_level varchar22 0 1 The level of the organizational hierarchy used to create item\zone\price relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse). This value should be null if the item is a non sellable pack. * * null null No The level of the organizational hierarchy used to create item\zone\price relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse). This value should be null if the item is a non sellable pack. short_desc varchar2120 0 1 The short description of the item. If this field is not populated it will default from the long description. item_master short_desc varchar2 120 Yes The short description of the item. If this field is not populated it will default from the long description. cost_zone_group_id number4 0 1 The cost zone from the cost_zone_group table to which the item belongs. This should be null if landed cost is not being used in the system or the item is an orderable buyer pack. 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 on the system_options table. standard_uom varchar24 0 1 The unit of measure at which the item is tracked at the corporate level. This will be defaulted to EA (eaches) if not populated on the message. It cannot be modified. item_master standard_uom varchar2 4 Yes The unit of measure at which the item is tracked at the corporate level. This is defaulted to EA (eaches) if not populated in the message. It cannot be modified. store_ord_mult varchar21 0 1 The unit type of merchandise shipped from the warehouse to the store for this item. Valid values are C (cases), I (inners), and E (eaches). item_master store_ord_mult varchar2 1 No The unit type of merchandise shipped from the warehouse to the store for this item. Valid values are C (cases), I (inners), and E (eaches). forecast_ind varchar21 0 1 Indicates whether the item is forecastable. Valid value are Y (yes) and N (no). This value should be N if the item is a pack. item_master forecast_ind varchar2 1 Yes Indicates if this item will be interfaced to an external forecasting system (Y, N). simple_pack_ind varchar21 0 1 Indicates if the item is a simple pack. This field is required if the item is a pack. Valid values are Y (yes) and N (no). This value cannot be modified. item_master simple_pack_ind varchar2 1 Yes Indicates whether the item is a simple pack. This field is required if the item is a pack. Valid values are Y and N. This value cannot be modified. contains_inner_ind varchar21 0 1 This should be Y (yes) if the item is a pack and at least one component item is a pack; otherwise it should be N (no). item_master contains_inner_ind varchar2 1 Yes Indicates if pack item contains inner packs. Vendor packs will never contain inner packs and this field will be defaulted to N. sellable_ind varchar21 0 1 If the item is a pack, this value indicates if the pack can be sold as a unique unit. Valid values are Y (yes) and N (no). This value cannot be modified. It should be Y for a non-pack item. item_master sellable_ind varchar2 1 Yes If the item is a pack, this value indicates if the pack can be sold as a unique unit. Valid values are Y and N. This value cannot be modified. It should be Y for a non-pack item. orderable_ind varchar21 0 1 If the item is a pack, this field indicates if it can be placed on orders. Valid values are Y (yes) and N (no). This field cannot be modified. It should be Y for a non-pack item. item_master orderable_ind varchar2 1 Yes Indicates if pack item is orderable. pack_type varchar21 0 1 If the item is a pack, this field will indicate what type of pack it is. Valid values are B (buyer) and V (vendor). This field cannot be modified. If the item is not a pack this value should be null. item_master pack_type varchar2 1 No If the item is a pack, this field indicates the type of pack. Valid values are B (buyer) and V (vendor). This field cannot be modified. If the item is not a pack, this value should be null. order_as_type varchar21 0 1 If the item is an orderable buyer pack, this indicates how it will be ordered. Valid values are E (eaches) and P (pack). This field cannot be modified. If the item is not a pack, this should be null. item_master order_as_type varchar2 1 No If the item is an orderable buyer pack, this field indicates how it will be ordered. Valid values are E (eaches) and P (pack). This field cannot be modified. If the item is not a pack, this should be null. comments varchar22000 0 1 Comments associated with the item. item_master comments varchar2 2000 Yes Holds any comments associated with the item. create_datetime xs:dateTime 0 1 Date/time stamp of when the record was created. This date/time will be used in export processing. This value should only be populated on insert - it should never be updated. item_master create_datetime date * Yes Date/time stamp from when the record was created. This date/time will be used in export processing. This value should only be initially populated. It should never be updated. XItemCtryDesc * 0 unbounded Child node. XItemSupDesc * 0 unbounded Child node. XItemBOMDesc * 0 unbounded Child node. XItemVATDesc * 0 unbounded Child node. XIZPDesc * 0 unbounded Child node. XItemUDADtl * 0 unbounded Child node that is not used. XItemSeason * 0 unbounded Child node that is not used. XItemImage * 0 unbounded Child node that is not used. status varchar21 0 1 Not used. item_master status varchar2 1 Yes 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 D = Delete Pending, cannot be used in the system. 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 number 20,10 No 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. 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 Oracle Retail Price Mangement to determine same sized and different sized items. item_master package_size number 12,4 No 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 Oracle Retail Price Mangement to determine same sized and different sized items. 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 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. 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 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. mfg_rec_retail number20_4 0 1 Manufacturers recommended retail price for the item in primary currency. Used for informational purposes only. item_master mfg_rec_retail number 20,4 No Manufacturers recommended retail price for the item. Used for informational purposes only. This field is stored in the primary currency. waste_type varchar26 0 1 Identifies the wastage type as either sales or spoilage wastage. item_master waste_type varchar2 6 No Identifies the wastage type as either sales or spoilage wastage. 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,4 No Average percent of wastage for the item over its shelf life. Used in inflating the retail price for wastage items. item_number_type varchar26 0 1 Code specifying what type the item is. Valid values for this field are in the code type UPCT on the code_head and code_detail tables. item_master item_number_type varchar2 6 Yes Code specifying what type the item is. Valid values for this field are in the code type UPCT on the code_head and code_detail tables. 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 Indiactes whether the item should be weighed when it arives at a location. Valid values for this field are Y and N. 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/primary country. item_master const_dimen_ind varchar2 1 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 will be defaulted to the primary supplier/primary country dimensions. Editing of dimensions for the item will only be allowed for the primary supplier/primary country. 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 will contain a value of 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 a value of Y if the item should be shipped to the customer is a seperate package versus being grouped together in a box. ext_source_system varchar26 0 1 Not used. n/a n/s null null No Not used by RMS. size_group1 number4 0 1 Not used. * * null null No Not used by RMS. size_group2 number4 0 1 Not used. * * null null No Not used by RMS. size1 varchar26 0 1 Not used. * * null null No Not used by RMS. size2 varchar26 0 1 Not used. * * null null No Not used by RMS. color varchar224 0 1 Not used. n/a n/a null null No Not used by RMS. system_ind varchar21 0 1 Not used. n/a n/a null null No Not used by RMS. upc_supplement number5 0 1 Not used. * * null null No Not used by RMS. upc_type varchar25 0 1 Not used. * * null null No Not used by RMS. primary_upc_ind varchar21 0 1 Not used. * * null null No Not used by RMS. primary_repl_ind varchar21 0 1 Not used. * * null null No Not used by RMS. item_aggregate_ind varchar21 0 1 Not used. * * null null No Not used by RMS. diff_1_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. item_master dif_1_aggregate_ind varchar2 1 Yes Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. diff_2_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. item_master diff_2_aggregate_ind varchar2 1 Yes Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. diff_3_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. item_master diff_3_aggregate_ind varchar2 1 Yes Indicator for the corresponding diff. Indicator to aggregate inventory and sales for a fashion item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP diff_4_aggregate_ind varchar21 0 1 Indicator for the corresponding diff. item_master diff_4_aggregate_ind varchar2 1 Yes Indicator for the corresponding diff. Indicator to aggregate inventory and sales for an item at Parent/Diff level (e.g Style/Color or Style/Size ). This indicator is currently used by allocation and MFP. perishable_ind varchar21 0 1 Indicates if an item is perishable. item_master perishable_ind varchar2 1 Yes A grocery item attribute used to indicate whether an item is perishable or not. notional_pack_ind varchar21 0 1 Indicates in SIM if a sellable simple pack needs to be broken down to its component item. item_master notional_pack_ind varchar2 1 Yes This is to indicate that the pack item should post the transaction at pack level in SIM. If this indicator is checked in RMS, SIM will track pack item at the pack level. If the indicator is not checked in RMS, SIM will store inventory at the component level. soh_inquiry_at_pack_ind varchar21 0 1 Indicates in SIM if a notional simple pack item's inventory should be displayed in packs. ITEM_MASTER soh_inquiry_at_pack_ind varchar2 1 Yes This indicates to show the stock on hand at pack level in down stream applications when it is called in POS from SIM. aip_case_type varchar26 0 1 Only used if AIP is integrated.Determines which case sizes to extract against an item in the AIP interface. Applicable only to non-pack orderable items. ITEM_MASTER aip_case_type varchar2 6 No Only used if AIP is integrated.Determines which case sizes to extract against an item in the AIP interface. Applicable only to non-pack orderable items. order_type varchar26 0 1 This determines how catch weight items are ordered: F - fixed weight, V - Variable weight. item_master order_type varchar2 6 No This determines how catch weight items are ordered. sale_type varchar26 0 1 This determines how catch weight items are sold in store locations: V - variable weight each, L - Loose weight. item_master sale_type varchar2 6 No This indicates the method of how catch weight items are sold in store locations. catch_weight_uom varchar24 0 1 Unit of measure of a catch weight item. ITEM_MASTER catch_weight_uom varchar2 4 No UOM for Catchweight Items. deposit_item_type varchar26 0 1 This is the deposit item component type: E - Contents, A - Container, Z - Crate, T - Returned Item (Empty bottle), P - Complex pack (with deposit items). ITEM_MASTER DEPOSIT_ITEM_TYPE VARCHAR2 6 No This is the deposit item component type. A NULL value in this field indicates that this item is not part of a deposit item relationship. The possible values are - E - Contents A - Container Z - Crate T - Returned Item (Empty bottle) P - Complex pack (with deposit items) The Returned item is flagged only to enable these items to be mapped to a separate GL account if required. inventory_ind varchar21 0 1 This indicates if an item holds inventory or not for item transformation. ITEM_MASTER INVENTORY_IND VARCHAR2 1 Yes This indicator is used to determine if an item holds inventory or not for item transformations. item_xform_ind varchar21 0 1 This indicates if an item is associated with an item transformation process. If yes, the item will be either the sellable item or the orderable item in the transformation process. ITEM_MASTER item_xform_ind VARCHAR2 1 Yes This indicator will show that an item is associated an item transformation. The item will be either the sellable item or orderable item in the transformation process. container_item varchar225 0 1 This holds the container item number for a content item. ITEM_MASTER container_item VARCHAR2 25 No This holds the container item number for a contents item. This field is only populated and required if the DEPOSIT_ITEM_TYPE = E. 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 Holds the unit of measure associated with the package size. This field is used for reporting purposes and by Oracle Retail Price Management to determine same sized and different sized items. format_id varchar21 0 1 This field will hold the format ID that corresponds to the items variable UPC. This value is only used for items with variable UPCs. ITEM_MASTER FORMAT_ID VARCHAR2 1 No This field will hold the format ID that corresponds to the items variable UPC. This value is only used for items with variable UPCs. prefix number2 0 1 This column holds the prefix for variable weight UPCs. item_master prefix number 2 No 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 scale systems. brand varchar2120 0 1 This is added to capture the brand information of an item. ITEM_MASTER brand_name VARCHAR2 30 No This field contains the brand associated to an item product_classification varchar26 0 1 This defines which items can be combined (packed or boxed) together. item_master product_classification varchar2 6 No Product classification is informational only in RMS, but is used by RWMS to determine how to pack customer orders item_desc_secondary varchar2250 0 1 Secondary descriptions of the item. ITEM_MASTER item_desc_secondary VARCHAR2 250 No Secondary descriptions of the item. This field can only be populated when system_options.secondary_desc_ind = Y. desc_up varchar2250 0 1 All upper case description of the item. ITEM_MASTER DESC_UP VARCHAR2 250 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, but is used in item list of value search processing through out the system. merchandise_ind varchar21 0 1 Indicates if the item is a merchandise item (Y, N). ITEM_MASTER merchandise_ind VARCHAR2 1 Yes Indicates if the item is a merchandise item (Y, N). original_retail number20_4 0 1 The original retail price of the item per unit. This field is stored in the primary currency. item_master original_retail number 20,4 No The original retail price of the item per unit. This field is stored in the primary currency. retail_label_type varchar26 0 1 This field indicates any special label type assoctiated with an item. item_master retail_label_type varchar2 6 No 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. 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,4 No This field represents the value associated with the retail label type. default_waste_pct number12_4 0 1 Default daily wastage percent for spoilage type wastage items. item_master default_waste_pct number 12,4 No 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_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 Holds a value that restricts the type of shipment methods that RCOM can select for an item. check_uda_ind varchar21 0 1 This field indicates whether the user has called the itemuda form. ITEM_MASTER check_uda_ind VARCHAR2 1 No This field indicates whether the user has called the itemuda form. Since users may delete defauted UDAs, this will prevent these from being automatically displayed whenever the user enters the itemuda form. deposit_in_price_per_uom varchar26 0 1 This field indicates if the deposit amount is included in the price per UOM calculation for a contents item ticket. ITEM_MASTER DEPOSIT_IN_PRICE_PER_UOM VARCHAR2 6 No This field indicates if the deposit amount is included in the price per UOM calculation for a contents item ticket. attempt_rms_load varchar26 0 1 This field indicates if the item will be created in RMS or the staging tables. Valid values are RMS or STG. If not defined, the default is STG. * * * * Yes Fill this description. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA LocOfXItemDesc:LocOfXItemDesc * 0 1 Provide an extension hook to localize XItemDesc. NA NA NA NA NA NA LangOfXItemDesc * 0 unbounded Child node. XItemHTSDesc * 0 unbounded Child node. XItemExpDesc * 0 unbounded Child node. XItemTicketDesc * 0 unbounded Child node.

XML-Schema Name:XItemCtryDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemCtryDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description country_id varchar23 1 1 Id of the country associated with the item. item_country country_id varchar2 3 Yes This column contains the unique code that identifies the country, which is associated with the item. LocOfXItemDesc:LocOfXItemCtryDesc * 0 1 Provide an extension hook to localize XItemCtryDesc. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemCtryDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemCtryDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemCtryDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemSupDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemSupDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description supplier varchar210 1 1 The identifier of the supplier who sources the item. This value must be predefined on the SUPS table. item_supplier supplier varchar2 10,0 Yes The identifier of the supplier that sources the item. This value must be predefined in the SUPS table. primary_supp_ind varchar23 0 1 Indicates if the supplier is the primary supplier for the item. Valid values are Y (yes) and N (no). item_supplier primary_supp_ind varchar2 3 Yes This field Indicates whether this supplier is the primary supplier for the item.. Each item can have one and only one primary supplier. Valid values are Y or N. This field is meaningless for sub-transaction level items. vpn varchar230 0 1 The vendor product number associated with the item. item_supplier vpn varchar2 30 No This field contains the Vendor Product Number associated with this item. supp_label varchar215 0 1 The supplier label for the item. item_supplier supp_label varchar2 15 No This field will hold the supplier laber for an item (Parent/Child) XItemSupCtyDesc * 0 unbounded Child node. consignment_rate number12_4 0 1 This field contains the consignment rate for this item for the supplier. item_supplier consignment_rate number 12,4 No This field contains the consignment rate for this item for the supplier. supp_discontinue_date xs:dateTime 0 1 Date which the supplier discontinues an item. The retailor should be aware that the supplier is able to reuse a UPC after 30 months and should work to ensure that no data exists in RMS for a UPC 30 months after it has been discontinued. item_supplier supp_discontinue_date date * No Date which the supplier discontinues an item. The retailor should be aware that the supplier is able to reuse a UPC after 30 months and should work to ensure that no data exists in RMS for a UPC 30 months after it has been discontinued. direct_ship_ind varchar21 0 1 Contains a value of Yes to indicate that any item asssociated with this supplier is eligible for a direct shipment from the supplier to the customer. item_supplier direct_ship_ind varchar2 1 No This field will contain a value of Yes to indicate that any item asssociated with this supplier is eligible for a direct shipment from the supplier to the customer. pallet_name varchar26 0 1 Code referencing the name used to refer to the pallet. Valid codes are defined in the PALN code type. Examples are flat, pallet. item_supplier pallet_name varchar2 6 Yes Code referencing the name used by supplier to refer to the pallet. Valid codes are defined in the PALN code type. Examples are flat, pallet. case_name varchar26 0 1 Code referencing the name used to refer to the case. Valid codes are defined in the CASN code type. Examples are pack, box, bag. item_supplier case_name varchar2 6 Yes Code referencing the name used to refer to the case. Valid codes are defined in the CASN code type. Examples are pack, box, bag. inner_name varchar26 0 1 Code referencing the name used to refer to the inner. Valid codes are defined in the INRN code type. Examples are sub-case, sub-pack. item_supplier inner_name varchar2 6 Yes Code referencing the name used by supplier to refer to the inner. Valid codes are defined in the INRN code type. Examples are sub-case, sub-pack. XItmSupCtyMfrDesc:XItmSupCtyMfrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA primary_case_size varchar26 0 1 Used only if AIP is interfaced. Indicates the primary case size for the item supplier when an orderable item is configured for informal case types. item_supplier primary_case_size VARCHAR2 6 No Used only if AIP is interfaced. Indicates the primary case size for the item supplier when an orderable item is configured for informal case types. 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 120 No This field contains the first supplier differentiator and/or description. This field may only contain 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 120 No This field contains the second supplier differentiator and/or description. This field may only contain 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 120 No This field contains the third supplier differentiator and/or description. This field may only contain 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 120 No This field contains the fourth supplier differentiator and/or description. This field may only contain a value for items with an item_parent. concession_rate number12_4 0 1 The concession rate is the margin that a particular supplier receives for the sale of a concession item. item_supplier concession_rate number 12,4 No The concession rate is the margin that a particular supplier receives for the sale of a concession item. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA LocOfXItemDesc:LocOfXItemSupDesc * 0 1 Provide an extension hook to localize XItemSupDesc. NA NA NA NA NA NA LangOfXItemSupDesc * 0 unbounded Child node. default_expense_profiles varchar21 0 1 This field indicates whether expense profiles will be defaulted to new item-supplier relationship. svc_item_supplier default_expense_profiles varchar2 1 No Refer to ITEM_SUPPLIER.DEFAULT_EXPENSE_PROFILES.

XML-Schema Name:XItemSupCtyDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemSupCtyDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description origin_country_id varchar23 1 1 The identifier for the country where the item is sourced. This value must be predefined on the COUNTRY table. item_supp_country origin_country_id varchar2 3 Yes The country where the item was manufactured or significantly altered. primary_country_ind varchar21 0 1 This indicates if the country is the primary country for the item\supplier. Valid values are Y (yes) and N (no). item_supp_country primary_country_ind varchar2 1 Yes Indicates whether the country is the primary country for the item\supplier. Valid values are Y and N. unit_cost number20_4 0 1 The current corporate unit cost for the item in the supplier's currency. This field will only be used to establish the item\supplier\country unit cost; it cannot be modified. item_supp_country unit_cost number 20,4 Yes The current corporate unit cost for the item in the supplier's currency. This field is used only to establish the item\supplier\country unit cost; it cannot be modified. XItemCostDesc * 0 unbounded Child node. XISCLocDesc * 0 unbounded Child node. 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. This field is defaulted from the default lead time set at the supplier level. item_supp_country lead_time number 4,0 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. This field is defaulted from the default lead time set at the supplier level. pickup_lead_time number4 0 1 Contains time it takes to get the item from the Supplier to the Initial Receiving Location. This value will be defaulted to the item_supp_country_loc pickup lead time field. The ordering dialog will reference the item/supplier/country/location pickup lead time as the value may vary by location. item_supp_country pickup_lead_time number 4,0 No Contains time it takes to get the item from the Supplier to the Initial Receiving Location. This value will be defaulted to the item_supp_country_loc pickup lead time field. The ordering dialog will reference the item/supplier/country/location pickup lead time as the value may vary by location. min_order_qty number12_4 0 1 This field contains the minimum quantity that can be ordered at one time from the supplier for the item. item_supp_country min_order_qty number 12,4 No Not used by RMS. max_order_qty number12_4 0 1 This field contains the maximum quantity that can be ordered at one time from the supplier for the item. item_supp_country max_order_qty number 12,4 No This field contains the maximum quantity that can be ordered at one time from the supplier for the item. supp_hier_lvl_1 varchar210 0 1 Highest level of supplier hierarchy (e.g. manufacturer). This will be used for assigning rebates that come from a level in the supply chain that is higher than the supplier. This information is stored on item_supp_country for defaulting into item_supp_country_loc. item_supp_country supp_hier_lvl_1 varchar2 10 No Highest level of supplier hierarchy (e.g. manufacturer). This will be used for assigning rebates that come from a level in the supply chain that is higher than the supplier. This information is stored on item_supp_country for defaulting into item_supp_country_loc. supp_hier_lvl_2 varchar210 0 1 Second highest level of supplier hierarchy. This information is stored on item_supp_country for defaulting into item_supp_country_loc. item_supp_country supp_hier_lvl_2 varchar2 10 No Second highest level of supplier hierarchy. This information is stored on item_supp_country for defaulting into item_supp_country_loc. supp_hier_lvl_3 varchar210 0 1 Third highest level of supplier hierarchy. This information is stored on item_supp_country for defaulting into item_supp_country_loc. item_supp_country supp_hier_lvl_3 varchar2 10 No Third highest level of supplier hierarchy. This information is stored on item_supp_country for defaulting into item_supp_country_loc. default_uop varchar26 0 1 Contains the default unit of purchase for the item/supplier/country. Valid values include: Standard Units of Measure C for Case P for Pallet item_supp_country default_uop varchar2 6 No Contains the default unit of purchase for the item/supplier/country. supp_pack_size number12_4 0 1 Contains the quantity that orders must be placed in multiples of for the supplier for the item. item_supp_country supp_pack_size number 12,4 Yes Contains the quantity that orders must be placed in multiples of for the supplier for the item. inner_pack_size number12_4 0 1 This field contains the break pack size for this item from the supplier. item_supp_country inner_pack_size number 12,4 Yes This field contains the units of an item contained in an inner pack supplied by the supplier. ti number12_4 0 1 Number of shipping units (cases) that make up one tier of a pallet. Multiply TI x HI to get total number of units (cases) for a pallet. item_supp_country ti number 12,4 Yes Number of shipping units (cases) that make up one tier of a pallet. Multiply TI x HI to get total number of units (cases) for a pallet. hi number12_4 0 1 Number of tiers that make up a complete pallet (height). Multiply TI x HI to get total number of units (cases) for a pallet. item_supp_country hi number 12,4 Yes Number of tiers that make up a complete pallet (height). Multiply TI x HI to get total number of units (cases) for a pallet. XISCDimDesc * 0 unbounded Child node that is not used. cost_uom varchar24 0 1 Unit of measure associated with the item cost. It is held to allow costs to be managed in a separate UOM from the standard UOM. item_supp_country cost_uom varchar2 4 Yes Unit of measure associated with the item cost. It is held to allow costs to be managed in a separate UOM from the standard UOM. tolerance_type varchar26 0 1 The unit of the tolerances for catch weight simple packs: A - actual, P - percent. item_supp_country tolerance_type varchar2 6 No The unit of the tolerances for catch weight simple packs min_tolerance number12_4 0 1 The minimum tolerance value for a catch weight simple pack. item_supp_country min_tolerance number 12,4 No The minimum tolerance value for a catch weight simple pack. max_tolerance number12_4 0 1 The maximum tolerance value for a catch weight simple pack. item_supp_country max_tolerance number 12,4 No The maximum tolerance value for a catch weight simple pack. supp_hier_type_1 varchar26 0 1 Identifies partner type of supplier hierarchy level 1 for the foreign key to the partner table. item_supp_country supp_hier_type_1 varchar2 6 No Identifies partner type of supplier hierarchy level 1 for the foreign key to the partner table. supp_hier_type_2 varchar26 0 1 Identifies partner type of supplier hierarchy level 2 for the foreign key to the partner table. item_supp_country supp_hier_type_2 varchar2 6 No Identifies partner type of supplier hierarchy level 2 for the foreign key to the partner table. supp_hier_type_3 varchar26 0 1 Identifies partner type of supplier hierarchy level 3 for the foreign key to the partner table. item_supp_country supp_hier_type_3 varchar2 6 No Identifies partner type of supplier hierarchy level 3 for the foreign key to the partner table. round_lvl varchar26 0 1 This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet. item_supp_country round_lvl varchar2 6 Yes This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet. round_to_inner_pct number12_4 0 1 The Inner Rounding Threshold value. Used to determine whether to round partial Inner quantities up or down. item_supp_country round_to_inner_pct number 12,4 Yes The Inner Rounding Threshold value. Used to determine whether to round partial Inner quantities up or down. round_to_case_pct number12_4 0 1 The Case Rounding Threshold value. Used to determine whether to round partial Case quantities up or down. item_supp_country round_to_case_pct number 12,4 Yes The Case Rounding Threshold value. Used to determine whether to round partial Case quantities up or down. round_to_layer_pct number12_4 0 1 The Layer Rounding Threshold value. Used to determine whether to round partial Layer quantities up or down. item_supp_country round_to_layer_pct number 12,4 Yes The Layer Rounding Threshold value. Used to determine whether to round partial Layer quantities up or down. round_to_pallet_pct number12_4 0 1 The Pallet Rounding Threshold value. Used to determine whether to round partial Pallet quantities up or down. item_supp_country round_to_pallet_pct number 12,4 Yes The Pallet Rounding Threshold value. Used to determine whether to round partial Pallet quantities up or down. packing_method varchar26 0 1 This field indicates whether the packing method of the item in the container is Flat or Hanging. Values for this field are store in the PKMT code.. item_supp_country packing_method varchar2 6 No This field indicates whether the packing method of the item in the container is Flat or Hanging. Values for this field are store in the PKMT code. CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA LocOfXItemDesc:LocOfXItemSupCtyDesc * 0 1 Provide an extension hook to localize XItemSupCtyDesc. NA NA NA NA NA NA default_expense_profiles varchar21 0 1 This field indicates whether expense profiles will be defaulted to new item-supplier-country relationship. svc_item_supplier default_expense_profiles varchar2 1 No Refer to ITEM_SUPPLIER.DEFAULT_EXPENSE_PROFILES. purchase_type varchar21 0 1 This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession. item_supp_country purchase_type number 1,0 No This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession. calculation_basis varchar21 0 1 This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate. item_supp_country calculation_basis varchar2 1 No This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate. purchase_rate number12_4 0 1 This column contains the percentage of the retail price which will determnie the cost paid to the supplier for a consignment or concession item. item_supp_country purchase_rate number 12,4 No This column contains the percentage of the retail price which will determine the cost paid to the supplier for a consignment or concession item.

XML-Schema Name:XItemCostDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemCostDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description delivery_country_id varchar23 1 1 Country where the Item will be delivered. item_cost_head delivery_country_id varchar2 3 Yes Country where the Item will be delivered. primary_dlvy_ctry_ind varchar21 0 1 Indicates if the country is the primary delivery country of the item. item_cost_head primary_dlvy_ctry_ind varchar2 1 Yes Indicates if the country is the primary delivery country of the item. nic_static_ind varchar21 0 1 Indicates if the Negotiated Item Cost (NIC) is static or not. If NIC is static, then the Base Cost of the item will vary based on the location/tax region; if NIC is not static, then NIC will vary based on the location/tax region. item_cost_head nic_static_ind varchar2 1 Yes Indicates if the Negotiated Item Cost (NIC) is static or not. If NIC is static, then the Base Indicates if the Negotiated Item Cost (NIC) is static or not. If NIC is static then the BASE COST of the item will vary based on the location/tax region. If NIC is not static then it will vary based on the location/tax region. base_cost number20_4 0 1 This will hold the tax exclusive cost of the item. item_cost_head base_cost number 20,4 Yes This will hold the tax exclusive cost of the item. negotiated_item_cost number20_4 0 1 This will hold the supplier negotiated item cost. item_supp_country_loc negotiated_item_cost number 20,4 No This will hold the supplier negotiated item cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations negotiated item cost will be stored in this field. LocOfXItemDesc:LocOfXItemCostDesc * 0 1 Provide an extension hook to localize XItemCostDesc. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemCostDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemCostDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemCostDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XISCLocDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XISCLocDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description hier_id number10 1 1 The specific location id for this Item Supplier Country Loc message. Corresponds with the value used in the iscloc_hier_level field. item_supp_country_loc loc number 10 Yes The specific location ID for this Item Supplier Country Loc message. Corresponds to the value used in the iscloc_hier_level field. unit_cost number20_4 0 1 The unit cost for the item at the item\supplier\country\loc level in the supplier's currency. This field will be used for creating new records, not updating existing records. item_supp_country_loc unit_cost number 20,4 Yes The current unit cost of the item for the item/supplier/origin_country combination. This field is stored in the suppliers currency. negotiated_item_cost number20_4 0 1 This will hold the supplier negotiated item cost. ITEM_SUPP_COUNTRY_LOC negotiated_item_cost number 20,4 No This will hold the supplier negotiated item cost based on the location of the item. primary_loc_ind varchar21 0 1 Indicates if the location is the primary location for the item\supplier\country. Valid values are Y (yes) and N (no). item_supp_country_loc primary_loc_ind varchar2 1 Yes Indicates whether the location is the primary location for the item\supplier\country. Valid values are Y and N. pickup_lead_time number4 0 1 Contains time it takes to get the item from the Supplier to the Initial Receiving Location. This value will be defaulted to the item_supp_country_loc pickup lead time field. The ordering dialog will reference the item/supplier/country/location pickup lead time as the value may vary by location. item_supp_country_loc pickup_lead_time number 4 No Contains time it takes to get the item from the Supplier to the Initial Receiving Location. This value will be defaulted to the item_supp_country_loc pickup lead time field. The ordering dialog will reference the item/supplier/country/location pickup lead time as the value may vary by location. round_lvl varchar26 0 1 This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet. item_supp_country_loc round_lvl varchar2 6 Yes This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet. round_to_case_pct number12_4 0 1 The Case Rounding Threshold value. Used to determine whether to round partial case quantities up or down. item_supp_country_loc round_to_case_pct number 12,4 Yes This column will hold the Case Rounding Threshold value. During rounding, this value is used to determine whether to round partial Case quantities up or down. If the Case-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. For instance, with an Case size of 10 and a Threshold of 80%, Case quantities such as 18, 29 and 8 would be rounded up to 20, 30 and 10 respectively, while quantities of 12, 27 and 35 would be rounded down to 10, 20 and 30 respectively. Quantities are never rounded down to zero; a quantity of 7, in the example above, would be rounded up to 10. round_to_layer_pct number12_4 0 1 The Layer Rounding Threshold value. Used to determine whether to round partial Layer quantities up or down. item_supp_country_loc round_to_layer_pct number 12,4 Yes This column will hold the Layer Rounding Threshold value. During rounding, this value is used to determine whether to round partial Layer quantities up or down. If the Layer-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. round_to_pallet_pct number12_4 0 1 The Pallet Rounding Threshold value. Used to determine whether to round partial Pallet quantities up or down. item_supp_country_loc round_to_pallet_pct number 12,4 No This column will hold the Pallet Rounding Threshold value. During rounding, this value is used to determine whether to round partial Pallet quantities up or down. If the Pallet -fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. For instance, with an Pallet size of 10 and a Threshold of 80%, Pallet quantities such as 18, 29 and 8 would be rounded up to 20, 30 and 10 respectively, while quantities of 12, 27 and 35 would be rounded down to 10, 20 and 30 respectively. Quantities are never rounded down to zero; a quantity of 7, in the example above, would be rounded up to 10. round_to_inner_pct number12_4 0 1 The Inner Rounding Threshold value. Used to determine whether to round partial Inner quantities up or down. item_supp_country_loc round_to_inner_pct number 12,4 Yes This column will hold the Inner Rounding Threshold value. During rounding, this value is used to determine whether to round partial Inner quantities up or down. If the Inner-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. For instance, with an Inner size of 10 and a Threshold of 80%, Inner quantities such as 18, 29 and 8 would be rounded up to 20, 30 and 10 respectively, while quantities of 12, 27 and 35 would be rounded down to 10, 20 and 30 respectively. Quantities are never rounded down to zero; a quantity of 7, in the example above, would be rounded up to 10. supp_hier_lvl_1 varchar210 0 1 Highest level of supplier hierarchy (e.g. manufacturer). This will be used forassigning rebates that come from a level in the supply chain that is higher than the supplier. item_supp_country_loc supp_hier_lvl_1 varchar2 10 No Highest level of supplier hierarchy which is used to indicate a partner, such as a manufacturer, in the supply chain that gives rebates to the retailer. supp_hier_lvl_2 varchar210 0 1 Second highest level of supplier hierarchy. Rebates at this level will include all eligible supplier/item/country/loc records assigned to this supplier hierarchy level. item_supp_country_loc supp_hier_lvl_2 varchar2 10 No Second Highest level of supplier hierarchy which is used to indicate a partner, such as a distributor in the supply chain that gives rebates to the retailer. supp_hier_lvl_3 varchar210 0 1 Third highest level of supplier hierarchy, used for assigning rebates by a level other than supplier. item_supp_country_loc supp_hier_lvl_3 varchar2 10 No Third highest level of supplier hierarchy which is used to indicate a partner, such as a wholesaler in the supply chain that gives rebates to the retailer LocOfXItemDesc:LocOfXISCLocDesc * 0 1 Provide an extension hook to localize XISCLocDesc. NA NA NA NA NA NA cost_uom varchar24 0 1 Unit of measure associated with the item cost. It is held to allow costs to be managed in a separate UOM from the standard UOM. item_supp_country_loc cost_uom varchar2 4 No A cost UOM is held to allow costs to be managed in a separate UOM than the standard UOM. The unit cost stored in standard UOM is converted to cost UOM for display in the Item Supplier Country Loc screen. Likewise, if the user enters or updates the unit cost via the Item Supplier Country Loc screen, it is converted to standard UOM before being saved to the table. purchase_type varchar21 0 1 This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession. item_supp_country_loc purchase_type number 1 No This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession. calculation_basis varchar21 0 1 This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate. item_supp_country_loc calculation_basis varchar2 1 Yes This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate. purchase_rate number12_4 0 1 This column contains the percentage of the retail price which will determnie the cost paid to the supplier for a consignment or concession item. item_supp_country_loc purchase_rate number 12,4 No This column contains the percentage of the retail price which will determnie the cost paid to the supplier for a consignment or concession item.

XML-Schema Name:LocOfXISCLocDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXISCLocDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXISCLocDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XISCDimDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XISCDimDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description dim_object varchar26 1 1 Specific object whose dimensions are specified in this record (e.g. case, pallet, each). Valid values for this field are in the code type DIMO on the code_head and code_detail tables. item_supp_country_dim dim_object varchar2 6 Yes Specific object whose dimensions are specified in this record (e.g. case, pallet, each). Valid values for this field are in the code type DIMO on the code_head and code_detail tables. 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,4 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 "TARE_TYPE - Indicates if tare weight for this dim_object is wet or dry. Valid values are found on the code_detail table with the code_type TARE and include: W = Wet tare weight D = Dry tare weight" item_supp_country_dim tare_type varchar2 6 No TARE_TYPE - Indicates if tare weight for this dim_object is wet or dry. lwh_uom varchar24 0 1 Unit of measurement for length, width, and height (e.g. inches, centimeters, feet). Valid values for this field are contained in uom field on uom_class table where uom_class field = DIMEN. item_supp_country_dim lwh_uom varchar2 4 No Unit of measurement for length, width, and height (e.g. inches, centimeters, feet). Valid values for this field are contained in uom field on uom_class table where uom_class field = DIMEN. length number12_4 0 1 Length of dim_object measured in units specified in lwh_uom. item_supp_country_dim length number 12,4 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,4 No Width of dim_object measured in units specified in lwh_uom. dim_height number12_4 0 1 Height of dim_object measured in units specified in lwh_uom. item_supp_country_dim height number 12,4 No Height of dim_object measured in units specified in lwh_uom. liquid_volume number12_4 0 1 Liquid volume, or capacity, of dim_object measured in units specified in volume_uom. Liquid volumes are only convertible to other liquid volumes. item_supp_country_dim liquid_volume number 12,4 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 (e.g. ounces, liters). Liquid volumes are only convertible to other liquid volumes. Valid values for this field are contained in uom field on uom_class table where uom_class field = LVOL. item_supp_country_dim liquid_volume_uom varchar2 4 No Unit of measurement for liquid_volume (e.g. ounces, liters). Liquid volumes are only convertible to other liquid volumes. Valid values for this field are contained in uom field on uom_class table where uom_class field = LVOL. stat_cube varchar212 0 1 Statistical value of the dim_objects dimensions to be used for loading purposes. item_supp_country_dim stat_cube number 12,4 No Statistical value of the dim_objects dimensions to be used for loading purposes. weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms). Valid values for this field are contained in uom field on uom_class table where uom_class field = MASS. item_supp_country_dim weight_uom varchar2 4 No Unit of measurement for weight (e.g. pounds, kilograms). Valid values for this field are contained in uom field on uom_class table where uom_class field = MASS. weight number12_4 0 1 Weight of dim_object measured in units specified in weight_uom. item_supp_country_dim weight number 12,4 No Weight of dim_object measured in units specified in weight_uom. net_weight varchar212 0 1 Unit of measurement for length, width, and height (e.g. inches, centimeters, feet). Valid values for this field are contained in uom field on uom_class table where uom_class field = DIMEN. item_supp_country_dim net_weight number 12,4 No Net weight of the dim_object (weight without packaging) measured in units specified in weight_uom. presentation_method varchar26 0 1 Describes the packaging (if any) being taken into consideration in the specified dimensions. Valid values for this field are in the code type PCKT on the code_head and code_detail tables. item_supp_country_dim presentation_method varchar2 6 No Describes the packaging (if any) being taken into consideration in the specified dimensions. Valid values for this field are in the code type PCKT on the code_head and code_detail tables. LocOfXItemDesc:LocOfXISCDimDesc * 0 1 Provide an extension hook to localize XISCDimDesc. NA NA NA NA NA NA

XML-Schema Name:LocOfXISCDimDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXISCDimDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXISCDimDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:LocOfXItemSupCtyDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemSupCtyDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemSupCtyDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItmSupCtyMfrDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItmSupCtyMfrDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description manufacturer_ctry_id varchar23 1 1 Country ID of manufacturer. item_supp_manu_country manu_country_id varchar2 3 Yes The country where the item was manufactured. primary_manufacturer_ctry_ind varchar21 0 1 Indicates if it's the primary country of manufacturer. item_supp_manu_country primary_manu_ctry_id varchar2 1 Yes This field indicates whether this country is the primary country of manufacture for the item/supplier. Each item/supplier combination must have one and only one primary country of manufacture.

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:LocOfXItemSupDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemSupDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemSupDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:LangOfXItemSupDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LangOfXItemSupDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description lang number6 1 1 This is the language ID. item_supplier_tl lang number 6 Yes This is the language ID. 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 120 No This field contains the first supplier differentiator and/or description. This field may only contain 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 120 No This field contains the second supplier differentiator and/or description. This field may only contain 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 120 No This field contains the third supplier differentiator and/or description. This field may only contain 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 120 No This field contains the fourth supplier differentiator and/or description. This field may only contain a value for items with an item_parent. supp_label varchar215 0 1 The supplier label for the item. item_supplier supp_label varchar2 15 No This field will hold the supplier label for an item (Parent/Child)

XML-Schema Name:XItemBOMDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemBOMDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description component_item varchar225 1 1 The component item within the pack. This value must be predefined on ITEM_MASTER. It will only be populated if the item on the message is a pack item. This value cannot be modified. Only transaction level items can be pack components. packitem item varchar2 25 No Alphanumeric value that identifies the component item within the pack. If pack item is created using pack template then the component items are stored in the PACKITEM_BREAKOUT table and this field is null. pack_qty number12_4 1 1 The quantity of the component item. This value cannot be modified. packitem pack_qty number 12,4 Yes Contains the quantity of component items within the pack. If the pack item is created using a pack template then the quantity specified here is 1 and the actual component item quantities in the pack are stored in PACKITEM_BREAKOUT table. LocOfXItemDesc:LocOfXItemBOMDesc * 0 1 Provide an extension hook to localize XItemBOMDesc. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemBOMDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemBOMDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemBOMDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemVATDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemVATDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description vat_type varchar21 1 1 Indicates if the VAT rate is used for purchasing or selling. Valid values are C (cost) and R (retail). vat_item vat_type varchar2 1 Yes Refer to VAT_ITEM.VAT_TYPE. vat_region number6 1 1 The identifier for the VAT region. This value must be predefined on the VAT_REGION table. This node is optional, if it is included this field is required. vat_item vat_region number 4,0 Yes Contains the number of the Value Added Tax region in which this store is contained. vat_code varchar26 1 1 The identifier for the VAT code. This node is optional, if it is included in the message this field is required. vat_item vat_code varchar2 6 Yes The VAT code. active_date xs:dateTime 1 1 The date that the VAT rate became active for the item/VAT region combination. vat_item active_date date * Yes Holds the active date for record on future cost reverse_vat_ind varchar21 0 1 Indicates if the item is subject to reverse charge VAT at the vat region. Valid values are Y and N. vat_item reverse_vat_ind varchar2 1 Yes Indicates if the item is subject to reverse charge VAT at the vat region. Valid values are Y and N. LocOfXItemDesc:LocOfXItemVATDesc * 0 1 Provide an extension hook to localize XItemVATDesc. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemVATDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemVATDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemVATDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XIZPDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XIZPDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description hier_id number10 1 1 The specific hierarchy id for this Item Zone Price message. Corresponds with value used in izp_hier_level field. * * null null Yes The specific hierarchy ID for this Item Zone Price message. Corresponds with the value used in the izp_hier_level field. base_retail_ind varchar21 0 1 Not used. * * null null No Not used by RMS. selling_unit_retail number20_4 0 1 The selling unit retail value in the currency and the selling UOM on the message. This field cannot be modified. rpm_item_zone_price selling_retail number 20,4 Yes the zone level retail in terms of the item/zone?s selling unit of measure. selling_uom varchar24 0 1 The selling unit of measure for the item's single unit retail. This field cannot be modified. rpm_item_zone_price selling_uom varchar2 4 No this field holds the unit of measure for the items selling retail. multi_selling_uom varchar24 0 1 The selling unit of measure for the item's multi unit retail. This field cannot be modified. rpm_item_zone_price multi_selling_uom varchar2 4 No this field holds the selling unit of measure for an item?s multi-unit retail country_id varchar23 0 1 Not used. * * null null No Not used by RMS. currency_code varchar23 0 1 The code of the currency the retail value and zones are in. Item\zone\price records will only be created for stores with the same currency as the retail value on the message. cost_zone currency_code varchar2 3 Yes The code for retail value and zone currency. Item\zone\price records are created for stores with the same currency as the retail value in the message. multi_units number12_4 0 1 The multi units for the item\zone. This field cannot be modified. rpm_item_zone_price multi_units number 12,4 No this field contains the number of units associated with the multi-unit retail for the item/zone combination. multi_unit_retail number20_4 0 1 The multi unit retail in the currency and the multi unit UOM specified on the message. This field cannot be modified. rpm_item_zone_price multi_unit_retail number 20,4 No this field holds the multi-unit retail in terms of the multi-unit selling unit of measure for the item/zone combination. LocOfXItemDesc:LocOfXIZPDesc * 0 1 Provide an extension hook to localize XIZPDesc. NA NA NA NA NA NA

XML-Schema Name:LocOfXIZPDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXIZPDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXIZPDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemUDADtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemUDADtl in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description uda_id number5 1 1 This field contains a number identifying the User-Defined Attribute. uda_item_lov,uda_item_ff, uda_item_date uda_id number 5,0 Yes This field contains a number uniquely identifying the User-Defined Attribute. display_type varchar22 1 1 Description is not available. uda display_type varchar2 2 Yes This field is used to store the display type (how the UDA values will be displayed to the user) for the given UDA. The valid values are DT-Date, FF - Free From, LV - List of values uda_date xs:dateTime 0 1 This field contains the text value of the Used Defined attribute for the item. uda_item_date uda_date date * Yes This field contains the date of the Used Defined attribute for the item. uda_value varchar230 0 1 This field contains value of the Used Defined attribute for the item. uda_item_lov uda_value number 5,0 Yes This field contains value of the Used Defined attribute for the item. uda_text varchar2250 0 1 This field contains the text value of the Used Defined attribute for the item. uda_item_ff uda_text varchar2 250 Yes This field contains the text value of the Used Defined attribute for the item. new_uda_date xs:dateTime 0 1 This field contains the value for modification the uda_date of the Used Defined attribute for the item. svc_uda_item_date new_uda_date date * No Placeholder for new UDA_DATE during update new_uda_value varchar230 0 1 This field contains the value for modification the uda_value of the Used Defined attribute for the item. * * * * new_uda_text varchar2250 0 1 This field contains the value for modification the uda_date of the Used Defined attribute for the item. * * * * create_datetime xs:dateTime 0 1 Description is not available. uda_item_lov create_datetime date * No This field contains the Date/time stamp of when the record was created. This date/time will be used in export processing. This value should only be populated on insert and should never be updated. last_update_datetime xs:dateTime 0 1 Description is not available. uda_item_lov, uda_item_date last_update_datetime date * Yes This field holds the date time stamp of the most recent update by an Oracle user (last_update_id). This field is required by the database. last_update_id varchar230 0 1 Description is not available. uda_item_lov last_update_id varchar2 30 Yes This field holds the Oracle user-id of the user who most recently updated this record. This field is required by the database. LocOfXItemDesc:LocOfXItemUDADtl * 0 1 Provide an extension hook to localize XItemUDADtl. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemUDADtl Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemUDADtl in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemUDADtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemSeason Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemSeason in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description season_id number3 1 1 The season identifier. item_seasons season_id number 3,0 Yes The season identifier. phase_id number3 1 1 The phase identifier. item_seasons phase_id number 3,0 Yes The phase identifier. item_season_seq_no number4 0 1 This field contains a sequence number that combined with the item number will make each record unique. item_seasons item_season_seq_no number 4,0 Yes This field contains a sequence number that combined with the item number will make each record unique. diff_id varchar210 0 1 This field will hold a value for group/differentiator combination records only. item_seasons diff_id varchar2 10 No This field will hold a value for group/differentiator combination records only. create_datetime xs:dateTime 0 1 Description is not available. item_seasons create_datetime date * Yes Date/time stamp of when the record was created. This date/time will be used in export processing. This value should only be populated on insert - it should never be updated. last_update_datetime xs:dateTime 0 1 Holds the date time stamp of the most recent update by the last_update_id. This field is required by the database. item_image last_update_datetime date * Yes Holds the date time stamp of the most recent update by the last_update_id. This field is required by the database. last_update_id varchar230 0 1 Holds the Oracle user-id of the user who most recently updated this record. This field is required by the database. item_image last_update_id varchar2 30 Yes Holds the Oracle user-id of the user who most recently updated this record. This field is required by the database. color number4 0 1 Description is not available. * * * * Yes LocOfXItemDesc:LocOfXItemSeason * 0 1 Provide an extension hook to localize XItemSeason. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemSeason Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemSeason in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemSeason * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemImage Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemImage in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description image_name varchar2120 1 1 The name of the image. item_image image_name varchar2 120 Yes This field contains the name of the image of the item. image_addr varchar2255 0 1 Path where the file of the image is stored. item_image image_addr varchar2 255 Yes Path where the file of the image is stored. image_desc varchar240 0 1 The description associated with the image. item_image image_desc varchar2 40 Yes This field contains the description associated with the image of the item. create_datetime xs:dateTime 0 1 Date/time stamp of when the record was created. item_image create_datetime date * Yes This field contains date/time stamp of when the record was created. This value is only to be populated on insert and never be updated. last_update_datetime xs:dateTime 0 1 Description is not available. item_image last_update_datetime date * Yes This field holds the date time stamp of the most recent update by the last_update_id. This field is required by the database. last_update_id varchar230 0 1 Description is not available. item_image last_update_id varchar2 30 Yes This field holds the Oracle user-id of the user who most recently updated this record. This field is required by the database. LocOfXItemDesc:LocOfXItemImage * 0 1 Provide an extension hook to localize XItemImage. NA NA NA NA NA NA image_type varchar26 0 1 Field indicating the type of the image of the item. Can be H(igh), M(edium), L(ow) and T(humbnail). item_image image_type varchar2 6 Yes Contains the type of the image of the item. Valid values are defined as member of IITD code type. primary_ind varchar21 0 1 Field indicating whether the record is a primary image or not. item_image primary_ind varchar2 1 Yes This field indicates whether this record is the primary image of the item or not. Valid values are Y(es) and N(o) only. display_priority number4 0 1 Field to specify the display sequence order of images associated to the item per priority. item_image display_priority number 4,0 Yes This field will specify the display sequence order of images associated to the item per priority. LangOfXItemImage * 0 unbounded Child node.

XML-Schema Name:LocOfXItemImage Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemImage in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemImage * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:LangOfXItemImage Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LangOfXItemImage in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description lang number6 1 1 This is the language ID. item_image_tl lang number 6 Yes This is the language ID. image_desc varchar240 1 1 The description associated with the image. item_image image_desc varchar2 40 Yes This field contains the description associated with the image of the item.

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:LocOfXItemDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:LangOfXItemDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LangOfXItemDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description lang number6 1 1 This is the language ID. item_master_tl lang NUMBER 6 Yes This field contains the language in which the translated text is maintained. short_desc varchar2120 0 1 The short description of the item. If this field is not populated it will default from the long description. item_master short_desc varchar2 120 Yes 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 parents short description. For items without parents, this description will default to null. item_desc varchar2250 1 1 The long description of the item. item_master item_desc varchar2 250 Yes 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_desc_secondary varchar2250 0 1 Secondary description of the item. item_master item_desc_secondary varchar2 250 No Secondary descriptions of the item. This field can only be populated when system_options.secondary_desc_ind = Y.

XML-Schema Name:XItemHTSDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemHTSDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description hts varchar225 1 1 The unique identifier for the Harmonized Tariff Schedule code. item_hts hts varchar2 25 Yes The unique identifier for the Harmonized Tariff Schedule code. import_country_id varchar23 1 1 The unique identifier for the country that the item will be imported into. item_hts import_country_id varchar2 3 Yes The unique identifier for the country that the item will be imported into. origin_country_id varchar23 1 1 The country where the item was manufactured or significantly altered. item_hts origin_country_id varchar2 3 Yes The country where the item was manufactured or significantly altered. effect_from xs:dateTime 1 1 The date from which the Item/HTS relationship is valid. This field is used to maintain historical information related to the Item/HTS relationship. item_hts effect_from date * Yes The date from which the Item/HTS relationship is valid. This field is used to maintain historical information related to the Item/HTS relationship. effect_to xs:dateTime 1 1 The date until when the Item/HTS relationship is valid. This field is used to maintain historical information related to the item/HTS relationship. item_hts effect_to date * Yes The date until when the Item/HTS relationship is valid. This field is used to maintain historical information related to the item/HTS relationship. clearing_zone_id varchar25 0 1 The concept of 'clearing zone' represents a country's zone-level point of entry of goods. This field holds the Clearing Zone ID for the effective HTS code. Clearing zones are defined by import country. item_hts clearing_zone_id varchar2 5 No The concept of 'clearing zone' represents a country's zone-level point of entry of goods. This field holds the Clearing Zone ID for the effective HTS code. Clearing zones are defined by import country. status varchar21 0 1 Used to indicate the status of the Item/HTS relationship. Valid values are (W)orksheet and (A)pproved. item_hts status varchar2 1 Yes Used to indicate the status of the Item/HTS relationship. Valid values are (W)orksheet and (A)pproved. XItemHTSAssessDesc * 0 unbounded Child node LocOfXItemDesc:LocOfXItemHTSDesc * 0 1 Provide an extension hook to localize XItemHTS. NA NA NA NA NA NA

XML-Schema Name:XItemHTSAssessDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemHTSAssessDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description comp_id varchar210 1 1 The code representing the specific assessment component. item_hts_assess comp_id varchar2 10 Yes The code representing the specific assessment component. cvb_code varchar210 0 1 The Computation Value Base representing the base value for calculating the assessment. item_hts_assess cvb_code varchar2 10 No The Computation Value Base representing the base value for calculating the assessment. comp_rate number20_4 0 1 The rate to be charged against the calculation base. This field will hold a percentage value if the Calculation basis of the Component is Value or a monetary amount if the Calculation Basis is Specific. item_hts_assess comp_rate number 20,4 Yes The rate to be charged against the calculation base. This field will hold a percentage value if the Calculation basis of the Component is Value or a monetary amount if the Calculation Basis is Specific. per_count number12_4 0 1 A count indicating the amount of the Per Count Unit of Measure to which the rate applies. This column is only used for specific (per-unit) assessments. item_hts_assess per_count number 12,4 No A count indicating the amount of the Per Count Unit of Measure to which the rate applies. This column is only used for specific (per-unit) assessments. per_count_uom varchar24 0 1 The unit of measure in which the Per Count is specified. This column is only used from specific (per-unit) assessments. item_hts_assess per_count_uom varchar2 4 Yes The unit of measure in which the Per Count is specified. This column is only used from specific (per-unit) assessments. est_assess_value number26_10 0 1 Contains the calculated value of the component. item_hts_assess est_assess_value number 26,10 Yes Contains the calculated value of the component. nom_flag_1 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_hts_assess nom_flag_1 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. nom_flag_2 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_hts_assess nom_flag_2 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. nom_flag_3 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_hts_assess nom_flag_3 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. nom_flag_4 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_hts_assess nom_flag_4 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. nom_flag_5 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_hts_assess nom_flag_5 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. LocOfXItemDesc:LocOfXItmHTSAssDesc * 0 1 Provide an extension hook to localize XItemHTSAssess. NA NA NA NA NA NA

XML-Schema Name:LocOfXItmHTSAssDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItmHTSAssDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemHTSAssessDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemHTSDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemHTSDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemHTSDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemExpDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemExpDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description supplier number10 1 1 The unique identifier for the supplier. item_exp_detail supplier varchar2 10 Yes The identifier of the supplier that sources the item. This value must be predefined in the SUPS table. comp_id varchar210 1 1 The code representing the specific expense component. item_exp_detail comp_id varchar2 10 Yes The code representing the specific expense component. discharge_port varchar25 1 1 The port where the item will enter the importing country. item_exp_head discharge_port varchar2 5 Yes The port where the item will enter the importing country. origin_country_id varchar23 0 1 The country where the item was manufactured or significantly altered. item_exp_head origin_country_id varchar2 3 No The country where the item was manufactured or significantly altered. lading_port varchar25 0 1 The final destination lading port of the item if the Expense Type is Country. item_exp_head lading_port varchar2 5 No The final destination lading port of the item if the Expense Type is Country. zone_id number10 0 1 The final destination zone of the item if the Expense Type is Zone. item_exp_head zone_id number 10,0 No The final destination zone of the item if the Expense Type is Zone. zone_group_id number4 0 1 This field holds the items Zone Group, it is stored here for performance reasons. item_exp_head zone_group_id number 4,0 No This field holds the items Zone Group, it is stored here for performance reasons. base_exp_ind varchar21 0 1 Indicates whether or not this Set of Expenses is also the base Set of Expenses. item_exp_head base_exp_ind varchar2 1 Yes Indicates whether or not this Set of Expenses is also the base Set of Expenses. cvb_code varchar210 0 1 The Computation Value Base representing the base value for calculating the expense. item_exp_detail cvb_code varchar2 10 No The Computation Value Base representing the base value for calculating the expense. comp_rate number20_4 0 1 The rate to be charged against the calculation base. This field will hold a percentage value if the Calculation basis of the Component is Value or a monetary amount if the Calculation Basis is Specific. item_exp_detail comp_rate number 20,4 Yes The rate to be charged against the calculation base. This field will hold a percentage value if the Calculation basis of the Component is Value or a monetary amount if the Calculation Basis is Specific. per_count number12_4 0 1 A count indicating the amount of the Per Count Unit of Measure to which the rate applies. This column is only used for specific (per-unit) expenses. item_exp_detail per_count number 12,4 No A count indicating the amount of the Per Count Unit of Measure to which the rate applies. This column is only used for specific (per-unit) expenses. per_count_uom varchar24 0 1 The unit of measure in which the Per Count is specified. This column is only used from specific (per-unit) expenses. item_exp_detail per_count_uom varchar2 4 No The unit of measure in which the Per Count is specified. This column is only used from specific (per-unit) expenses. comp_currency varchar23 0 1 Contains the currency the expense is to be entered in. If the Calculation Basis is V (Value), then the comp_currency will be NULL. item_exp_detail comp_currency varchar2 3 Yes Contains the currency the expense is to be entered in. If the Calculation Basis is V (Value), then the comp_currency will be NULL. update_orders varchar21 0 1 Indicates that new changes will be reflected to associated order-location expense record. SVC_ITEM_EXPENSES update_orders varchar2 1 Yes Indicates that new changes will be reflected to associated order-location expense record. nom_flag_1 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_exp_detail nom_flag_1 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. nom_flag_2 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_exp_detail nom_flag_2 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. nom_flag_3 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_exp_detail nom_flag_3 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. nom_flag_4 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_exp_detail nom_flag_4 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. nom_flag_5 varchar21 0 1 Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. item_exp_detail nom_flag_5 varchar2 1 Yes Contains a flag that is used to indicate the status of this particular nomination flag for a given expense. Valid values are N, +, and -. LocOfXItemDesc:LocOfXItemExpDesc * 0 1 Provide an extension hook to localize XItemExp. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemExpDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemExpDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemExpDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemTicketDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XItemTicketDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description ticket_type_id varchar24 1 1 This unique identifier for the ticket type which is associated with the item. item_ticket ticket_type_id varchar2 4 Yes This field contains a character string which uniquely identifies the ticket type which is associated with the item. po_print_type varchar21 0 1 This field indicates when the ticket type for the given item should be printed by default, upon the approval or receipt of the purchase order. item_ticket po_print_type varchar2 1 No This field indicates when the ticket type for the given item should be printed by default, upon the approval or receipt of the purchase order. print_on_pc_ind varchar21 0 1 This field indicates whether or not this type of ticket should be printed for this item when a permanent price change goes into effect. item_ticket print_on_pc_ind varchar2 1 Yes This field indicates whether or not this type of ticket should be printed for this item when a permanent price change goes into effect. ticket_over_pct number12_4 0 1 This field contains a percent which indicates the amount of tickets which should be printed for a given event. item_ticket ticket_over_pct number 12,4 No This field contains a percent which indicates the amount of tickets which should be printed for a given event. If the event causing tickets to be printed is approving or receiving a purchase order, then this field indicates the quantity of tickets which should be printed greater than the quantity of the purchase order. If the event causing the tickets to be printed is a permanent price change, this field would indicate the quantity of tickets which should be printed greater than the stock on hand. LocOfXItemDesc:LocOfXItemTicketDesc * 0 1 Provide an extension hook to localize XItemTicket. NA NA NA NA NA NA

XML-Schema Name:LocOfXItemTicketDesc Version:16.0.030 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfXItemTicketDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description BrXItemDesc:BrXItemTicketDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA