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/ItemDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:ItemDesc 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 ItemDesc 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
ItemHdrDesc:ItemHdrDesc * 1 1 It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemSupDesc:ItemSupDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemSupCtyDesc:ItemSupCtyDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ISCDimDesc:ISCDimDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemUDALOVDesc:ItemUDALOVDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemUDAFFDesc:ItemUDAFFDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemUDADateDesc:ItemUDADateDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemImageDesc:ItemImageDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemUPCDesc:ItemUPCDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemBOMDesc:ItemBOMDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemTcktDesc:ItemTcktDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemSupCtyMfrDesc:ItemSupCtyMfrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
RelatedItemDesc:RelatedItemDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
VatItemDesc:VatItemDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemSupUomDesc:ItemSupUomDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:ItemHdrDesc 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 ItemHdrDesc 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 Unique alphanumeric value that identifies the item. item_master item varchar2 25 Yes Unique alphanumeric value that identifies the item.
item_number_type varchar26 1 1 This type can hold a number of digits count umber_type. item_master item_number_type varchar2 6 Yes Code specifying what type the item is. Valid values for this field are in the code type UPCT on the code_head and code_detail tables.
format_id varchar21 0 1 This field will hold the format ID that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. item_master format_id varchar2 1 No This field 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. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. It is the clients responsibility to download this value to their item_master prefix number 2,0 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.
item_parent varchar225 0 1 Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table. item_master item_parent varchar2 25 No Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table.
item_grandparent varchar225 0 1 Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table. item_master item_grandparent varchar2 25 No Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as 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. A pack item is a collection of items that may be either ordered or sold as a unit. Packs require details (i.e. component items and qtys, etc.) that other items do not. This field is required by the database. item_master pack_ind varchar2 1 Yes Indicates 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 Number indicating which of the three levels the item resides. The item level determines if the item stands alone or if it is part of a family of related items. The item level also determines how the item may be used throughout the system. item_master item_level number 1 Yes Number indicating 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 Number indicating which of the three levels transactions occur for the item's group. The transaction level is the level at which the item's inventory is tracked in the system. The transaction level item will be counted, transferred, shipped, etc. The transaction level may be at the current item or up to 2 levels above or below the current item. Only one level of the hierarchy of an item family may contain transaction level items. item_master tran_level number 1,0 Yes Number indicating which of the three levels transactions occur for the items group. The transaction level is the level at which the items inventory is tracked in the system. The transaction level item will be counted, transferred, shipped, etc. The transaction level may be at the current item or up to 2 levels above or below the current item. Only one level of the hierarchy of an item family may contain transaction level items.
diff_1 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Men's pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. item_master diff_1 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_1_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_type diff_type varchar2 6 Yes Contains the code used to uniquely identify a differentiator type.
diff_2 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. item_master diff_2 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_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_type diff_type varchar2 6 Yes Contains the code used to uniquely identify a differentiator type.
diff_3 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. item_master diff_3 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_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_type diff_type varchar2 6 Yes Contains the code used to uniquely identify a differentiator type.
diff_4 varchar210 0 1 Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables. item_master diff_4 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_type varchar26 0 1 This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. diff_type diff_type varchar2 6 Yes Contains the code used to uniquely identify a differentiator type.
dept number4 0 1 Number identifying the department to which the item is attached. The item's department will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the deps table. item_master dept number 4,0 Yes Number identifying the department to which the item is attached. The items department will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the deps table.
dept_name varchar2120 0 1 Contains the name of the department. deps dept_name varchar2 120 Yes Contains the name of the department.
class varchar27 0 1 Number identifying the class to which the item is attached. The item's class will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the class table. item_master class 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.
class_name varchar2120 0 1 Contains the name of the class. class class_name varchar2 120 Yes Contains the name of the class which, along with the class number, identifies the class.
subclass varchar24 0 1 Number identifying the subclass to which the item is attached. The item's subclass will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the subclass table. item_master sub_class number 4,0 Yes Number identifying the subclass to which the item is attached. The items subclass will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the subclass table.
sub_name varchar2120 0 1 Contains the name of the subclass. subclass sub_name varchar2 120 Yes Contains the name of the subclass which, along with the subclass number, uniquely identifies the subclass.
status varchar21 0 1 Status of the item. Valid values are: W = Worksheet: item setup in progress, cannot be used in system; S = Submitted: item setup complete and awaiting approval, cannot be use in system; A = Approved: item is approved and can now be used throughout the system. item_master status varchar2 1 Yes Status of the item.
item_desc varchar2250 0 1 Long description of the item. This description is used through out the system to help online users identify the item. For items that have parents, this description will default to the parents description plus any differentiators. For items without parents this description will default to null. item_master item_desc 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.
short_desc varchar2120 0 1 Shortened description of the item. This description is the default for downloading to the POS. For items that have parents, this description will default to the parent's short description. For items without parents, this description will default to null. item_master short_desc 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.
desc_up varchar2250 0 1 All upper case description of the item (same as upper(item_desc)). This field is not displayed in the on-line item maintenance dialog, but is used in item list of value search processing through out the system. item_master desc_up varchar2 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.
primary_ref_item_ind varchar21 0 1 Indicates if the sub-transation level item is designated as the primary sub-transaction level item. For transaction level items and above the value in this field will be 'N'o. item_master primary_ref_item_ind varchar2 1 Yes Indicates if the sub-transation level item is designated as the primary sub-transaction level item. For transaction level items and above the value in this field will be No.
cost_zone_group_id number4 0 1 Cost zone group associated with the item. This field is only required when elc_ind (landed cost indicator) is set to 'Y' on the system_options table. item_master cost_zone_group_id number 4,0 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 Unit of measure in which stock of the item is tracked at a corporate level. item_master standard_uom varchar 4 Yes Unit of measure in which stock of the item is tracked at a corporate level.
uom_conv_factor number20_10 0 1 Conversion factor between an "Each" and the standard_uom when the standard_uom is not in the quantity class (e.g. if standard_uom = lb and 1 lb = 10 eaches, this factor will be 10). This factor will be used to convert sales and stock data when an item is retailed in eaches but does not have eaches as its standard unit of measure. item_master uom_conv_factor 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 Retek 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.
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.
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).
store_ord_mult varchar21 0 1 Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are:C = Cases; I = Inner; E = Eaches. item_master store_ord_mult varchar2 1 Yes Merchandise shipped from the warehouses to the stores must be specified in this unit type.
forecast_ind varchar21 0 1 Indicates if this item will be interfaced to an external forecasting system (Y, N). item_master forecast_ind varchar2 1 Yes Indicates if this item will be interfaced to an external forecasting system (Y, N).
mfg_rec_retail number20_4 0 1 Manufacturer's recommended retail price for the item. Used for informational purposes only. This field is stored in the primary currency. item_master mfg_rec_retail number 20,4 No Manufacturers recommended retail price for the item. Used for informational purposes only. This field is stored in the primary currency.
retail_label_type varchar26 0 1 This field indicates any special lable type assoctiated with an item (i.e. pre-priced or cents off). This field is used for reporting purposes only. Values for this field are defined by the 'RTLT' code on code detail. item_master retail_label_type varchar2 6 No This field indicates 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_type_desc varchar240 0 1 Contains the retail label type description corresponding to the retail_label_type value in item_master. * * * * Yes Fill this description.
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 Yes This field represents the value associated with the retail label type.
handling_temp varchar26 0 1 Holds the temperature information associated with the item. Valid values for this field are in the code type 'HTMP' on the code_head and code_detail tables. item_master handling_temp varchar2 6 No 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_temp_desc varchar240 0 1 Contains the Handling temperature description corresponding to the handling_temp value in item_master. * * * * Yes Fill this description.
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.
handling_sensitivity_desc varchar240 0 1 Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. * * * * No Fill this description.
catch_weight_ind varchar21 0 1 Indiactes whether the item should be weighed when it arives at a location. Valid values for this field are 'Y' and 'N'. item_master catch_weight_ind varchar2 1 Yes Indicates whether the item should be weighed when it arrives at a location. Valid values for this field are Y and N.
waste_type varchar26 0 1 Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (i.e. fat is trimmed off at customer request). Spoilage wastage occurs during the products shelf life (i.e. evaporation causes the product to weight less after a period of time). Valid values are: SP - spoilage; and SL - Sales. item_master waste_type varchar2 6 No "Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (i.e. fat is trimmed off at customer request). Spoilage wastage occurs during the products shelf life (i.e. evaporation causes the product to weigh less after a period of time).
waste_type_desc varchar240 0 1 Contains the Waste Type description corresponding to the Waste_Type value in item_master. * * * * No Fill this description.
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.
default_waste_pct number12_4 0 1 Default daily wastage percent for spoilage type wastage items. This value will default to all item locations and represents the average amount of wastage that occurs on a daily basis. item_master default_waste_pct number 12,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.
const_dimen_ind varchar21 0 1 Indicates that the dimensions of the product are always the same, regardless of the supplier. If this field is Y, the dimensions for all suppliers will be defaulted to the primary supplier/primary country dimensions. Editing of dimensions for the item will only be allowed for the primary supplier/primiary country. item_master const_dimen_ind 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.
simple_pack_ind varchar21 0 1 Indicates if pack item is a simple pack or not. This field will only be available if the item is a pack item. A simple pack is an item whose components are all the same item (i.e. a six pack of cola, etc). Valid values are:Y = Yes, this item is a simple pack; N = No if this is not a simple pack. item_master simple_pack_ind varchar2 1 Yes "Indicates if pack item is a simple pack or not. This field will only be available if the item is a pack item. A simple pack is an item whose components are all the same item (i.e. a six pack of cola, etc).
contains_inner_ind varchar21 0 1 Indicates if pack item contains inner packs. Vendor packs will never contain inner packs and this field will be defaulted to 'N'. This field will only be available if the item is a pack item. Valid values are:Y = Yes, this pack contains inner packs; N = No, this pack does not contain inner packs. item_master contains_inner_ind 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.This field will only be available if the item is a pack item.
sellable_ind varchar21 0 1 Indicates if pack item may be sold as a unit. If it is 'Y' then the pack will have its own unique unit retail. If it is 'N' then the pack's unit retail is the sum of each individual item's total retail within the pack. This field will only be available if the item is a pack item. Value values are: Y = Yes, this pack may be sold as a unit; N = No, this pack man not be sold as a unit. item_master sellable_ind varchar2 1 Yes "Indicates if pack item may be sold as a unit. If it is Y then the pack will have its own unique unit retail. If it is N then the packs unit retail is the sum of each individual items total retail within the pack. This field will only be available if the item is a pack item.
orderable_ind varchar21 0 1 Indicates if pack item is orderable. If it is 'Y' then the suppliers of the pack must supply all components in the pack. If it is 'N' then the components may have different suppliers. This field will only be available if the item is a pack item. Valid values are: Y = Yes, this pack may be ordered, N = No, this pack may not be ordered. item_master orderable_ind varchar2 1 Yes "Indicates if pack item is orderable. If it is Y then the suppliers of the pack must supply all components in the pack. If it is N then the components may have different suppliers. This field will only be available if the item is a pack item.
pack_type varchar21 0 1 Indicates if pack item is a vendor pack or a buyer pack. A vendor pack is a pack that the vendor or supplier recognizes and sells to the retailer. If the pack item is a vendor pack, communication with the supplier will use the vendor pack number. A buyer pack is a pack that a buyer created for internal ease of use. If the pack item is a buyer pack communication with the supplier will explode the pack out to its component items. This field will only be available if the item is a pack item. If the pack item is not orderable this field must be null. Valid values are: V = Vendor; B = Buyer. item_master pack_type varchar2 1 No "Indicates if pack item is a vendor pack or a buyer pack. A vendor pack is a pack that the vendor or supplier recognizes and sells to the retailer. If the pack item is a vendor pack, communication with the supplier will use the vendor pack number. A buyer pack is a pack that a buyer has created for internal ease of use. If the pack item is a buyer pack, communication with the supplier will explode the pack out to its component items. This field will only be available if the item is a pack item. If the pack item is not orderable this field must be NULL.
order_as_type varchar21 0 1 Indicates if pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if pack item is an orderable buyer pack. This field must be NULL if the pack is sellable only or a vendor pack. This field will only be available if the item is a pack item. Valid Values are: E = Eaches (component level) P = Pack (buyer pack only). item_master order_as_type varchar2 1 No Indicates if pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if pack item is an orderable buyer pack. This field must be NULL if the pack is sellable only or a vendor pack. This field will only be available if the item is a pack item.
comments varchar22000 0 1 Holds any comments associated with the item. item_master comments varchar2 2000 No Holds any comments associated with the item.
unit_retail number20_4 0 1 This field holds the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency. item_loc unit_retail number 20,4 No Contains the unit retail price in the standard unit of measure for the item/location combination. This field is stored in the local currency.
item_service_level varchar26 0 1 Holds a value that restricts the type of shipment methods that RCOM can select for an item. item_master item_service_level varchar2 6 No Holds a value that restricts the type of shipment methods that RCOM can select for an item.
gift_wrap_ind varchar21 0 1 This field will contain a value of 'Y' if the item is eligible to be gift wrapped. item_master gift_wrap_ind varchar2 1 Yes This field 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.
vendor_style varchar215 0 1 Not used by RMS. No
std_unit_weight number20_10 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
single_price_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
preticket_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
planned_residual varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
sortable varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda1 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda2 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda3 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda4 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda5 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda6 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda7 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda8 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda9 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda10 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda11 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda12 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda13 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_master_uda14 varchar220 0 1 Not used by RMS. item_master item_number_type varchar2 6 Yes This type can hold a number of digits count umber_type.
item_master_uda15 varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
ship_alone varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
slottable varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
freight_class varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
new_item varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
brand varchar2120 0 1 This is used to associate a brand to an item. item_master brand_name varchar2 30 No This field contains the brand associated to an item
break_case_ups varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Not used by RMS.
rigid varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
fragile varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
container_type varchar26 0 1 Not used by RMS. n/a n/a RIB or/and RSB Fill column length. Yes Fill this description.
conveyable_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
hazard_matl_code varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
velocity number12_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
high_value_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
ticket_type varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
color varchar224 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
size1 varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
fit varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
shade varchar26 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
single_contain_bulk varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
unit_pick_system_code varchar212 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
roundable_flag varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
perishable_ind varchar21 0 1 Not used by RMS. item_master perishable_ind varchar2 1 Yes A grocery item attribute used to indicate whether an item is perishable or not.
division number4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
vendor_nbr varchar210 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
kitting_wip_code varchar29 0 1 Wip code used to designate the Kitting process used in item_master * * * * No Fill this description.
unit_ticket_qty number3 0 1 Item Master User Defined Attribute * * * * Yes Fill this description.
item_length number12_4 0 1 Length of an individual item item_supp_country_dim length number 12,4 No Length of dim_object measured in units specified in lwh_uom.
item_width number12_4 0 1 Width of an individual item item_supp_country_dim width number 12,4 No Width of dim_object measured in units specified in lwh_uom.
item_height number12_4 0 1 Height of an individual Item item_supp_country_dim height number 12,4 No Height of dim_object measured in units specified in lwh_uom.
item_weight number12_4 0 1 Weight of an individual item item_supp_country_dim weight number 12,4 No Weight of dim_object measured in units specified in weight_uom.
item_cube number12_4 0 1 Cubic dimension of an individual item item_supp_country_dim stat_cube number 12,4 No Statistical value of the dim_objects dimensions to be used for loading purposes.
std_unit_factor number6_2 0 1 Used for putaway by volume. The percentage of the standard number of units that will fit into a location type. * * * * Yes Fill this description.
std_unit_qty number12_4 0 1 The number of items that normally fit on/in the container type * * * * Yes Fill this description.
expiration_days number4 0 1 The number of days before inventory is deemed to be no longer distributable * * * * Yes Fill this description.
putaway_by_volume varchar26 0 1 If set to Y, putaway will be determined by cube or volume. If set to N, putaway will be determined by capacity. * * * * Yes Fill this description.
putaway_plan varchar220 0 1 Plan used for putaway * * * * Yes Fill this description.
item_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. * * * * Yes Fill this description.
sorter_group varchar26 0 1 Sorter Group identifier * * * * Yes Fill this description.
sku_optimization varchar21 0 1 Indicator for inclusion in SKU optimization * * * * Yes Fill this description.
ext_source_system varchar26 0 1 Specifies what external system the data originated from. * * * * Yes Fill this description.
item_xform_ind varchar21 0 1 Indicator shows that an item is associated with an item transformation. The item is either the sellable or the orderable item in the transformation process. 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.
inventory_ind varchar21 0 1 Inventory Indicator item_master inventory_ind varchar2 1 Yes This indicator is used to determine if an item holds inventory or not for item transformations.
order_type varchar29 0 1 Indicates the type of order and which Open To Buy bucket will be updated. item_master order_type varchar2 6 No This determines how catch weight items are ordered.
sale_type varchar26 0 1 n/a item_master sale_type varchar2 6 No This indicates the method of how catch weight items are sold in store locations.
deposit_item_type varchar26 0 1 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. 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.
container_item varchar225 0 1 This holds the container item number for a contents item. This field is only populated and required if the DEPOSIT_ITEM_TYPE = E. 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.
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. This value is only required if the DEPOSIT_ITEM_TYPE = E. Valid values are: I - Include deposit amount E - Exclude deposit amount 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. This value is only required if the DEPOSIT_ITEM_TYPE = E.
transport_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
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.
purchase_type varchar26 0 1 Indicates if an item is a normal, consignment or concession item - 'N' for normal, 'S' for consignment, 'C' for concession. 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.
product_classification varchar26 0 1 This contains item combinability codes (with code type 'PCLA') which provide a way to define 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
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
item_aggregate_ind varchar21 0 1 Indicator to aggregate inventory and sales for the item. Currently, this indiactor is used by allocation and MFP to aggregate inventory for items. For staple items this indictor should be N. item_master item_aggregate_ind varchar2 1 Yes Indicator to aggregate inventory and sales for the item. Currently, this indiactor is used by allocation and MFP to aggregate inventory for items. For staple items this indictor should be N.
diff_1_aggregate_ind varchar21 0 1 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. item_master diff_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. 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. 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. 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. 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. 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. 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.
item_desc_secondary varchar2250 0 1 Secondary descriptions of the item. This field can only be populated when system_options.secondary_desc_ind = Y. 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.
original_retail number20_4 0 1 The field indicated 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.
originalretailcurrencycode varchar23 0 1 The field indicates the currency code of the original retail price. * * * * Fill this description.
mfgretailcurrencycode varchar23 0 1 The field indicates the currency code of the Manufacturer's retail price. * * * * Fill this description.
catch_weight_type varchar21 0 1 This column will hold catch weight type for a simple pack catch weight item. The value is based on the component items order_type and sale_type: 2 - order_type = Variable Weight, sale_type = Loose Weight 4 - order_type = Variable Weight, sale_type = Variable Weight Each The column will be set only at the time of Item approval. It will be used by the ReIM Invoice Matching process. item_master catch_weight_type varchar2 1 No This column will hold catch weight type for a simple pack catch weight item.
catch_weight_uom varchar24 0 1 Indicates the UOM for Catchweight Items. item_master catch_weight_uom varchar2 4 No UOM for Catchweight Items.
brand_name varchar230 0 1 This field contains the brand associated to an item. item_master brand_name varchar2 30 No This field contains the brand associated to an item
unique_class number12 0 1 This field uniquely identify the class which the item belongs to.Class is not unique ID the merchandise hierarchy.The combination of Dept/Class is unique, but requires use of a composite key.The composite key is generally used in user interfaces.The unique ID can be used in back end processing or in systems that can not have a composite key in the merchandise hierarchy. * * * * Fill this description.
unique_subclass number12 0 1 This field uniquely identify the subclass which the item belongs to.Sublass is not unique ID the merchandise hierarchy.The combination of Dept/Class/Subclass is unique, but requires use of a composite key.The composite key is generally used in user interfaces.The unique ID can be used in back end processing or in systems that can not have a composite key in the merchandise hierarchy. * * * * Fill this description.
diff_1_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_1 is a group diff or a diff id. * * * * No Indicates whether DIFF_11 is ID or group
diff_1_description varchar2120 0 1 This field will hold the description of differentiator. diff_type diff_type_desc varchar2 120 Yes This field will hold the description of differentiator.
diff_2_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_2 is a group diff or a diff id. * * varchar2 6 No This field will contain either ID or GROUP, based on whether the diff_2 is a group diff or a diff id.
diff_2_description varchar2120 0 1 This field will hold the description of differentiator. diff_type diff_type_desc varchar2 120 Yes This field will hold the description of differentiator.
diff_3_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_3 is a group diff or a diff id. * * * * *
diff_3_description varchar2120 0 1 This field will hold the description of differentiator. diff_type diff_type_desc varchar2 120 Yes Contains the description of the differentiator type.
diff_4_level varchar26 0 1 This field will contain either ID or GROUP, based on whether the diff_4 is a group diff or a diff id. * * * * *
diff_4_description varchar2120 0 1 This field will hold the description of differentiator. diff_type diff_type_desc varchar2 120 Yes Contains the description of the differentiator type.
prod_classification_desc varchar2120 0 1 This field will hold the description of the product classification. * * * * Fill this description.
ItemHdrTlDesc:ItemHdrTlDesc * 0 unbounded References a collection of customer flexible attributes. 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. NA NA NA NA NA NA
value varchar2250 0 1 Holds the numeric or string value of the attribute. NA NA NA NA NA NA
value_date xs:dateTime 0 1 Holds the date value of the attribute. NA NA NA NA NA NA

XML-Schema Name:ItemHdrTlDesc 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 ItemHdrTlDesc 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 0 1 This field will hold the language in which the translated text is maintained. NA NA NA NA NA NA
description varchar2120 0 1 This field will hold the language in which the translated text is maintained. NA NA NA NA NA NA
iso_code varchar26 0 1 This field will hold the language in which the translated text is maintained. NA NA NA NA NA NA
item_desc varchar2250 0 1 This field will hold the language in which the translated text is maintained. NA NA NA NA NA NA
item_desc_secondary varchar2250 0 1 This field will hold the translated text of the primary description of the item. NA NA NA NA NA NA
short_desc varchar2120 0 1 This field will hold the language in which the translated text is maintained. NA NA NA NA NA NA

XML-Schema Name:ItemSupDesc 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 ItemSupDesc 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 Unique identifier for the item. item_supplier item varchar2 25 Yes Alphanumeric value that identifies the item
supplier varchar210 1 1 Unique identifier for the supplier. item_supplier supplier number 10,0 Yes This field contains the number of the supplier of the item.
primary_supp_ind varchar23 1 1 This field indicates whether this supplier is the primary supplier for the item. An item can have one and only one primary supplier. item_supplier primary_supp_ind varchar2 1 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 This field contains the Vendor Product Number for the Item. item_supplier vpn varchar2 30 No This field contains the Vendor Product Number associated with this item.
supp_label varchar215 0 1 This field contains the supplier label. It will only be popluated if item is a style. item_supplier supp_label varchar2 15 No This field will hold the supplier label for an item (Parent/Child)
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_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.
pallet_name varchar26 0 1 Code referencing the name used to refer to the pallet. item_supplier pallet_name varchar2 6 Yes Code referencing the name used 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. item_supplier case_name varchar2 6 Yes Code referencing the name used by supplier 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. 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.
supp_discontinue_date xs:dateTime 0 1 Date when the supplier discontinues an item. 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 A value of 'Y'es in this field indicates that any item associated with this supplier is eligible for a direct shipment from the supplier to the customer. item_supplier direct_ship_ind varchar2 1 Yes 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.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
primary_case_size varchar26 0 1 This field indicates the primary case size for the item supplier when an orderable item is configured for informal case types. Used only if AIP is interfaced. 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. NA NA NA NA NA NA
value varchar2250 0 1 Holds the numeric or string value of the attribute. NA NA NA NA NA NA
value_date xs:dateTime 0 1 Holds the date value of the attribute. NA NA NA NA NA NA

XML-Schema Name:ItemSupCtyDesc 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 ItemSupCtyDesc 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 Unique identifier for the item. item_supp_country item varchar2 25 Yes Alphanumeric value that identifies the item.
supplier varchar210 1 1 Unique identifier for the supplier. item_supp_country supplier number 10,0 Yes The unique identifier for the supplier.
origin_country_id varchar23 1 1 The country where the item was manufactured or significantly altered. item_supp_country origin_country_id varchar2 3 Yes The country where the item was manufactured or significantly altered.
primary_supp_ind varchar23 1 1 This field indicates whether this supplier is the primary supplier for the item. Each item can have one and only one primary supplier. item_supp_country primary_supp_ind varchar2 1 Yes This field indicates whether this supplier is the primary supplier for the Item. Each Item can have one and only one primary supplier. This field is stored on this table for performance purposes only. Valid values are Y or N.
primary_country_ind varchar21 1 1 This field indicates whether this country is the primary country for the item/supplier. Each item/supplier combination can have one and only one primary country. item_supp_country primary_country_ind varchar2 1 Yes This field indicates whether this country is the primary country for the item/supplier. Each item/supplier combination must have one and only one primary country. Valid values are Y or N.
unit_cost number20_4 1 1 This field contains the current corporate unit cost for the item from the supplier /origin country. This field is stored in the Supplier's currency. item_supp_country unit_cost number 20,4 Yes This field contains the current corporate unit cost for the SKU from the supplier/origin country. This field is stored in item's standard uom and in supplier currency. This value will match the cost field for the primary location on item_supp_country_loc. This field may be edited while the item is in worksheet status. If edited, the user will have the choice of changing the cost of all locations, or only the primary location. This cost is the cost that will be written to item_supp_country_loc when new locations are added to an item.
lead_time number4 0 1 This field contains the number of days that will elapse between the date an order is written and the delivery to the store or warehouse from the supplier. item_supp_country lead_time number 4,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 the time that will be taken to get the item from the supplier to the initial receiving location. item_supp_country pickup_lead_time number 4,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.
supp_pack_size number12_4 1 1 This field contains the quantity that orders must be placed in multiples of for the supplier for the item. item_supp_country supp_pack_size number 12,4 Yes This field contains the quantity that orders must be placed in multiples of for the supplier for the item.
inner_pack_size number12_4 1 1 This field contains the break pack size for this item from the supplier. item_supp_country inner_pack_size number 12,4 Yes This field contains the units of an item contained in an inner pack supplied by the supplier.
round_lvl varchar26 1 1 This column is used to determine how order quantities will be rounded to case, layer and pallet. item_supp_country round_lvl varchar2 6 Yes This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet.
min_order_qty number12_4 0 1 This field contains the minimum quantity that can be ordered at one from the supplier for the item. item_supp_country min_order_qty number 12,4 No This field contains the minimum quantity that can be ordered at one time from the supplier for the item.
max_order_qty number12_4 0 1 This field contains the maximum quantity that can be ordered at one from the supplier for the item. item_supp_country max_order_qty number 12,4 No This field contains the maximum quantity that can be ordered at one time from the supplier for the item.
packing_method varchar26 0 1 This field indicates whether the packing method for the item in the container is flat or hanging. item_supp_country packing_method varchar2 6 No This field indicates whether the packing method of the item in the container is Flat or Hanging. Values for this field are store in the PKMT code.
default_uop varchar26 0 1 Contains the default unit of purchase for the item/supplier/country. Valid values include 'C'ase and 'P'allet. item_supp_country default_uop varchar2 6 No Contains the default unit of purchase for the item/supplier/country.
ti number12_4 1 1 Number of shipping units (cases) that make up one tier of the pallet. Multiply TI x HI to get total number of units (cases) in a Pallet. item_supp_country ti 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 1 1 Number of tiers that make up a complete pallet. Multiply TI x HI to get total number of units (cases) in a Pallet. item_supp_country hi 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.
cost_uom varchar24 0 1 A cost UOM is held to allow costs to be managed in a separate UOM to the standard UOM. item_supp_country cost_uom varchar2 4 Yes 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 screen. Likewise, if the user enters or updates the unit cost via the Item Supplier Country screen, it is converted to standard UOM before being saved to the table.
tolerance_type varchar26 0 1 The unit of tolerance for catch weight simple packs. Valid values are: 'A'-actual 'P' - percent. item_supp_country tolerance_type varchar2 6 No The unit of the tolerances for catch weight simple packs.
max_tolerance number12_4 0 1 The maximum tolerance value for the catch weight simple pack. item_supp_country max_tolerance number 12,4 No The maximum tolerance value for the catch weight simple pack.
min_tolerance number12_4 0 1 The minimum tolerance value for a catch weight simple pack. item_supp_country min_tolerance number 12,4 No The minimum tolerance value for a catch weight simple pack.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
round_to_inner_pct number12_4 0 1 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. NA NA NA NA NA NA
round_to_case_pct number12_4 0 1 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. NA NA NA NA NA NA
round_to_layer_pct number12_4 0 1 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. NA NA NA NA NA NA
round_to_pallet_pct number12_4 0 1 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. NA NA NA NA NA NA
supp_hier_type_1 varchar26 0 1 This field identifies partner type of supplier hierarchy level 1.This field will always have the partner type S1 which indicates manufacturer.. NA NA NA NA NA NA
supp_hier_lvl_1 varchar210 0 1 Highest level of supplier hierarchy which is there to indicate a partner, such as a manufacturer, in the supply chain that gives rebates to the retailer. NA NA NA NA NA NA
supp_hier_type_2 varchar26 0 1 This field identifies partner type of supplier hierarchy level 2 . This field will always have the partner type S2 which indicates distributor. NA NA NA NA NA NA
supp_hier_lvl_2 varchar210 0 1 Second highest level of supplier hierarchy which is there to indicate a partner, such as a distributor in the supply chain that gives rebates to the retailer. NA NA NA NA NA NA
supp_hier_type_3 varchar26 0 1 This field identifies partner type of supplier hierarchy level 3.This field will always have the partner type S3 which indicates wholesaler. NA NA NA NA NA NA
supp_hier_lvl_3 varchar210 0 1 Third highest level of supplier hierarchy which is uder to indicate a partner, such as a wholesaler in the supply chain that gives rebates to the retailer. NA NA NA NA NA NA
negotiated_item_cost number20_4 0 1 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. NA NA NA NA NA NA
extended_base_cost number20_4 0 1 This will hold the extended base cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations extended base cost will be stored in this field. Extended base cost is the cost inclusive of all the taxes that affect the WAC. In case of GTAX , Extended Base Cost = Base Cost + Non-recoverable taxes. In case of VAT, Extended Base Cost = Base Cost. NA NA NA NA NA NA
inclusive_cost number20_4 0 1 This will hold the inclusive cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations inclusive cost will be stored in this field. This cost will have both the recoverable and non recoverable taxes included. In case of GTAX , Inclusive Cost = Base Cost + Non-recoverable taxes + Recoverable Taxes. In case of VAT, Inclusive Cost = Base Cost + VAT. NA NA NA NA NA NA
base_cost number20_4 0 1 This field will hold the tax exclusive cost of the item. NA NA NA NA NA NA
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. NA NA NA NA NA NA
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. NA NA NA NA NA NA
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. 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. NA NA NA NA NA NA
value varchar2250 0 1 Holds the numeric or string value of the attribute. NA NA NA NA NA NA
value_date xs:dateTime 0 1 Holds the date value of the attribute. NA NA NA NA NA NA

XML-Schema Name:ISCDimDesc 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 ISCDimDesc 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 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
supplier varchar210 1 1 Unique identifier for the supplier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
origin_country varchar23 1 1 The country where the item was manufactured or significantly altered. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
dim_object varchar26 1 1 Specific object whose dimensions are specified in this record. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
object_desc varchar240 0 1 Dim_object description fetched from the code_detail table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
presentation_method varchar26 0 1 Describes the packaging (if any) being taken into consideration in the specified dimensions. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
method_desc varchar240 0 1 Presentation method description fetched from the code_detail table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
length number12_4 0 1 Length of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
width number12_4 0 1 Width of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
height number12_4 0 1 Height of dim_object measured in units specified in lwh_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
lwh_uom varchar24 0 1 Unit of measurement for length, width and height. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
weight number12_4 0 1 Weight of dim_object measured in units specified in weight_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
net_weight number12_4 0 1 Net weight of the dim_object (weight without packaging) measured in units specified in weight_uom. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
weight_uom varchar24 0 1 Unit of measurement for weight. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
liquid_volume number12_4 0 1 Liquid volume, or capacity, of dim_object measured in units specified in colume_uom. Liquid volumes are only convertible to other liquid volumes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
liquid_volume_uom varchar24 0 1 Unit of measurement for liquid volume. Liquid volumes are only convertible to other liquid volumes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
stat_cube number12_4 0 1 Statistical value of the dim_object's dimensions to be used for loading purposes. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
tare_type varchar26 0 1 Indicates whether the tare weight for the dim_object is wet or dry. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemUDALOVDesc 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 ItemUDALOVDesc 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 Item ID uda_item_lov item varchar2 25 Yes This field contains unique alphanumeric identifier for the item.
uda_id number5 1 1 This field contains the unique identified of the Attribute Group being added or delete to the item list. uda_item_lov uda_id number 5,0 Yes This field contains a unique number identifying the User Defined Attribute.
uda_value varchar230 1 1 Contains the value of the Attribute Group. uda_item_lov uda_value number 5,0 Yes This field contains a unique number identifying the User Defined Attribute value for the UDA. A UDA can have multiple values. For example, Color can be a UDA and it can have different values like Green, Red, Blue, etc.
uda_desc varchar2120 0 1 This field contains a description of the User-Defined Attribute. NA NA NA NA NA NA
uda_value_desc varchar2250 0 1 This field contains a description of the UDA value. NA NA NA NA NA NA

XML-Schema Name:ItemUDAFFDesc 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 ItemUDAFFDesc 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 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
uda_id number5 1 1 This field contains a number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
uda_text varchar2250 0 1 This field contains the text value of the user-defined attribute for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemUDADateDesc 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 ItemUDADateDesc 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 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
uda_id number5 1 1 This field contains a number identifying the user-defined attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
uda_date xs:dateTime 1 1 This field contains the effective date for the Uda id. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemImageDesc 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 ItemImageDesc 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 Unique identifier for the item. item_image item varchar2 25 Yes This field contains the unique alphanumeric identifier for the item, the image is for.
image_name varchar2120 1 1 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 1 1 Path where the image file is stored. item_image image_addr varchar2 255 Yes This field contains the actual path where the file of the image of the item is stored.
image_type varchar26 0 1 This field contains the type of the image of the item. Valid values are defined as member of IITD code type. item_image image_type varchar2 6 Yes This field 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 will indicate whether this record is the primary image of the item or not. Valid values are Y(es) and N(o) only. Default to N value if left blank or set as NULL.
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.
image_desc varchar240 0 1 This field contains the description associated with the image of the item. NA NA NA NA NA NA

XML-Schema Name:ItemUPCDesc 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 ItemUPCDesc 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_id varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_parent varchar225 0 1 Unique identifier for the item/group at the level above the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
primary_ref_item_ind varchar21 0 1 Indicates if the sub-transaction level item is designated as the primary sub-transaction level item. For transaction level items and above, the value in this field will be 'N'o. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
format_id varchar21 0 1 This field will hold the format id that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
prefix number2 0 1 This field holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item_number_type varchar26 0 1 This type can hold a number of digits count umber_type. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemBOMDesc 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 ItemBOMDesc 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
pack_no varchar225 1 1 Unique identifier for the pack item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
item varchar225 1 1 Unique identifier for the component item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
pack_qty number12_4 1 1 Contains the quantity of each item in the pack item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemTcktDesc 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 ItemTcktDesc 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 Unique identifier for the item. item_ticket item varchar2 25 Yes Alphanumeric value that identifies the item which is associated with the ticket type.
ticket_type_id varchar24 1 1 This field uniquely identifies the ticket type which is associated with the item. item_ticket ticket_type_id varchar2 4 Yes This field contains a character string which uniquely identifies the ticket type which is associated with the item.
ticket_type_desc varchar2120 0 1 This field contains a description of the ticket or label type. NA NA NA NA NA NA
sel_ind varchar21 0 1 Indicates if the ticket type is a shelf edge label. NA NA NA NA NA NA
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. Valid values are: A and R. NA NA NA NA NA NA
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. Valid values in this field are:Y - Yes N - No. NA NA NA NA NA NA
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. 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. NA NA NA NA NA NA
TicketTypeDtl * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:ItemSupCtyMfrDesc 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 ItemSupCtyMfrDesc 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 Item ID. item_supp_manu_country item varchar2 25 Yes Alphanumeric value that identifies the item.
supplier number10 1 1 Supplier ID. item_supp_manu_country supplier number 10 Yes The unique identifier for the supplier.
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 1 1 Primary country of manufacturer indicator. item_supp_manu_country primary_manu_ctry_ind 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:RelatedItemDesc 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 RelatedItemDesc 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 main item against which the relationship is defined. related_item_head item varchar2 25 Yes The main item against which the relationship is defined.
relationship_id number15 1 1 A system generated numeric field that uniquely identifies the relationship record in related_item_head. related_item_head relationship_id number 20 Yes A system generated numeric field that uniquely identifies the relationship record in related_item_head.
relationship_name varchar2120 1 1 This is the user entered name of the relationship. related_item_head relationship_name varchar2 255 Yes This is the user entered name of the relationship.
relationship_type varchar26 1 1 Describes the type of relationship. Valid values are in the codes table under code_type 'IREL'. related_item_head relationship_type varchar2 6 Yes Describes the type of relationship. Valid values are in the codes table under code_type 'IREL'.
mandatory_ind mandatory_ind 1 1 Indicates whether the relationship is mandatory or not. Valid values: 'Y' (yes), 'N' (no). related_item_head mandatory_ind varchar2 1 Yes Indicates whether the relationship is mandatory or not. Valid values 'Y' (yes), 'N' (no).
RelatedItemDtl * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc.

XML-Schema Name:VatItemDesc 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 VatItemDesc 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 Unique identifier for the item. vat_item item varchar2 25 Yes Contains the item number in the distro
active_date xs:dateTime 1 1 This field holds the active date for record on future cost. vat_item active_date date * Yes Holds the active date for record on future cost
vat_type varchar21 1 1 This field indicates the type of vat either Retail or Cost or Both. vat_item vat_type varchar2 1 Yes Refer to VAT_ITEM.VAT_TYPE.
vat_code varchar26 1 1 This field indicates a code to uniquely identify a VAT rate. vat_item vat_code varchar2 6 Yes The VAT code.
vat_rate number20_10 1 1 This column contains vat rate associated with a given VAT code. vat_item vat_rate number 20,10 Yes This column contains the VAT rate for the item/location.
reverse_vat_ind varchar21 1 1 This field 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.
location number10 1 1 Unique location identifier. item_loc loc number 10,0 Yes Numeric identifier of the location in which the item is to be found. This field may contain a store, warehouse, or external finisher.
loc_type varchar21 1 1 This field contains Location Type.Valid Values are : S = Store , W = Warehouse. item_loc loc_type varchar2 1 Yes Type of location in the location field. Valid values are S (store), W (warehouse), and E (external finisher).

XML-Schema Name:ItemSupUomDesc 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 ItemSupUomDesc 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 Unique identifier for the item. item_supp_uom item varchar2 25 Yes Alphanumeric value that identifies the item.
supplier number10 1 1 Unique identifier for the supplier. item_supp_uom supplier number 10,0 Yes The unique identifier for the supplier of the item.
uom varchar24 1 1 The unit of measure that the item is being measured in. item_supp_uom uom varchar2 4 Yes The unit of measure that the item is being measured in.
value number20_4 1 1 This field will store the equivalent value of the Item/Suppliers shipping carton in the associated unit of measure. item_supp_uom value number 20,4 Yes This field will store the equivalent value of the Item/Suppliers shipping carton in the associated unit of measure.