Retail Integration Mappings Report Release:15.0.0 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/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:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
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

XML-Schema Name:ItemHdrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemHdrDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Unique alphanumeric value that identifies the item. item_master item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
item_number_type varchar26 1 1 This type can hold a number of digits count umber_type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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 or/and RSL Fill column length. No Not used in RWMS
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 Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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_upc item_id varchar2 25 No Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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 No Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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_differentiator diff_id varchar2 10 No Differentiator Identifier
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. item_differentiator diff_type varchar2 6 Yes 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_differentiator diff_id varchar2 10 No Differentiator Identifier
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. item_differentiator diff_id varchar2 6 Yes 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_differentiator diff_id varchar2 10 No Differentiator Identifier
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. item_differentiator diff_type varchar2 6 Yes 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_differentiator diff_id varchar2 10 No Differentiator Identifier
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. item_differentiator diff_id varchar2 6 Yes 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 department number 4 No Department an item resides in.
dept_name varchar2120 0 1 Contains the name of the department. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
class varchar27 0 1 Number identifying the class to which the item is attached. The item's class will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the class table. item_master class varchar2 7 No Refers to the carrier's class to distinguish light-weight, bulky merchandise from dense merchandise, etc
class_name varchar2120 0 1 Contains the name of the class. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
subclass varchar24 0 1 Number identifying the subclass to which the item is attached. The item's subclass will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the subclass table. item_master subclass varchar2 4 No Subclass the item is associated with.
sub_name varchar2120 0 1 Contains the name of the subclass. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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 description VARCHAR2 250 No A general description field.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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_upc primary_upc_ind varchar2 1 No Indicator of the primary UPC
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
standard_uom varchar24 0 1 Unit of measure in which stock of the item is tracked at a corporate level. item_master standard_uom varchar2 4 No Standard Unit Of Measure
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 No Conversion factor from one UOM to another
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
merchandise_ind varchar21 0 1 Indicates if the item is a merchandise item (Y, N). item_master non_saleable varchar2 1 Yes Available for sale indicator. Default 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
forecast_ind varchar21 0 1 Indicates if this item will be interfaced to an external forecasting system (Y, N). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
retail_label_type_desc varchar240 0 1 Contains the retail label type description corresponding to the retail_label_type value in item_master. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
retail_label_value number20_4 0 1 This field represents the value associated with the retail label type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
handling_temp_desc varchar240 0 1 Contains the Handling temperature description corresponding to the handling_temp value in item_master. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
handling_sensitivity_desc varchar240 0 1 Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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 varchar2 1 Yes An item master attribute indicating a weight needs to be captured as part of the receive processing.. Default 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 WASTE_TYPE varchar2 6 No Identifies the wastage type as either sales or spoilage wastage
waste_type_desc varchar240 0 1 Contains the Waste Type description corresponding to the Waste_Type value in item_master. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS.
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 Default is N
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No If sellable_ind = Y and orderable_ind = N then the item is considered invalid and an error will be raised.
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. N/A N/A RIB or/and RSB or/and RSL Fill column length. No Used in the simple_pack_ind and sellable_ind to determine vendor and kitting settings
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
comments varchar22000 0 1 Holds any comments associated with the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS.
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_master retail_price number 20 Yes The retail selling price for a particular item allocated to a particular store.
item_service_level varchar26 0 1 Holds a value that restricts the type of shipment methods that RCOM can select for an item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
gift_wrap_ind varchar21 0 1 This field will contain a value of 'Y' if the item is eligible to be gift wrapped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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 varchar2 1 Yes Default is N
vendor_style varchar215 0 1 Not used by RMS. item_master vendor_style RIB or/and RSB or/and RSL 15 Yes A vendor's designation which identifies one of that vendor's products.
std_unit_weight number20_10 0 1 Not used by RMS. item_master std_unit_weight number 20 Yes The standard weight that an item will be sent in. An item master attribute.
single_price_flag varchar21 0 1 Not used by RMS. item_master single_price_flag varchar2 1 Yes Whether or not a single price will be reflected on a ticket or multiple prices. Default is N
preticket_flag varchar21 0 1 Not used by RMS. item_master preticket_flag varchar2 1 Yes An indicator that items are already ticketed
planned_residual varchar21 0 1 Not used by RMS. item_master planned_residual varchar2 1 Yes If the round up flag is set to Y during distribution and remaining items will not be sent to a store but will be placed back into reserve.
sortable varchar21 0 1 Not used by RMS. item_master sortable varchar2 1 Yes Indicates whether the item can be placed on a sorter. Default is N
item_master_uda1 varchar220 0 1 Not used by RMS. item_master item_master_uda1 varchar2 10 Yes Item Master User Defined Attribute
item_master_uda2 varchar220 0 1 Not used by RMS. item_master item_master_uda2 varchar2 10 Yes Item Master User Defined Attribute
item_master_uda3 varchar220 0 1 Not used by RMS. item_master item_master_uda3 varchar2 10 Yes Item Master User Defined Attribute
item_master_uda4 varchar220 0 1 Not used by RMS. item_master item_master_uda4 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda5 varchar220 0 1 Not used by RMS. item_master item_master_uda5 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda6 varchar220 0 1 Not used by RMS. item_master item_master_uda6 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda7 varchar220 0 1 Not used by RMS. item_master item_master_uda7 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda8 varchar220 0 1 Not used by RMS. item_master item_master_uda8 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda9 varchar220 0 1 Not used by RMS. item_master item_master_uda9 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda10 varchar220 0 1 Not used by RMS. item_master item_master_uda10 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda11 varchar220 0 1 Not used by RMS. item_master item_master_uda11 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda12 varchar220 0 1 Not used by RMS. item_master item_master_uda12 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda13 varchar220 0 1 Not used by RMS. item_master item_master_uda13 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda14 varchar220 0 1 Not used by RMS. item_master item_master_uda14 varchar2 20 Yes Item Master User Defined Attribute
item_master_uda15 varchar220 0 1 Not used by RMS. item_master item_master_uda15 varchar2 20 Yes Item Master User Defined Attribute
ship_alone varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
slottable varchar21 0 1 Not used by RMS. item_master slottable varchar2 1 Yes ndicates whether an item can be slotted (Y/N) - Default N
freight_class varchar24 0 1 Not used by RMS. item_master freight_class varchar2 4 Yes Class identifier
new_item varchar21 0 1 Not used by RMS. item_master new_item varchar2 1 Yes Indicator to mark an item as new. Default Y
brand varchar2120 0 1 This is used to associate a brand to an item. item_master brand varchar2 120 Yes Item Identifier for Brand classification
break_case_ups varchar24 0 1 Not used by RMS. item_master break_case_ups varchar2 4 Yes Unit Pick Sorter System for Break Case Operation
rigid varchar21 0 1 Not used by RMS. item_master rigid varchar2 1 Yes Indicates if one or more of the item dimensions are rigid
fragile varchar21 0 1 Not used by RMS. item_master fragile varchar2 1 Yes Fragile Item Indicator
container_type varchar26 0 1 Not used by RMS. item_master container_type varchar2 6 Yes Type of the container, used to supply default container dimensions.
conveyable_flag varchar21 0 1 Not used by RMS. item_master conveyable_flag varchar2 1 Yes A flag that indicates that merchandise can be placed on the conveyor/sortation system. { Y [ N ] Default N
hazard_matl_code varchar26 0 1 Not used by RMS. item_master hazard_matl_code varchar2 6 Yes A code that identifies an item as belonging to a class of DOT specified hazardous materials.
velocity number12_4 0 1 Not used by RMS. item_master velocity number 2 Yes Distribution rate of the product. (Not currently used).
high_value_ind varchar21 0 1 Not used by RMS. item_master high_value_ind char 1 Yes A flag that identifies an item as being high values item. Values (Y/N).
ticket_type varchar24 0 1 Not used by RMS. item_master ticket_type varchar2 4 Yes A code that indicates the merchandise ticketing format. (Values defined in customer-generated documentation).
color varchar224 0 1 Not used by RMS. item_master color varchar2 24 Yes Color of an item.
size1 varchar26 0 1 Not used by RMS. item_master size1 varchar2 6 Yes Item master attribute
fit varchar26 0 1 Not used by RMS. item_master fit varchar2 6 Yes Item master attribute
shade varchar26 0 1 Not used by RMS. item_master shade varchar2 6 Yes Item master attribute
single_contain_bulk varchar21 0 1 Not used by RMS. item_master single_contain_bulk varchar2 1 Yes Indicator that specifies if a single container is found whether to treat it as a single container pick or as a bulk pick. Default is N
unit_pick_system_code varchar212 0 1 Not used by RMS. item_master unit_pick_system_code varchar2 12 Yes Fill this description.
roundable_flag varchar21 0 1 Not used by RMS. item_master roundable_flag varchar2 1 Yes Determines whether a full case will be distributed to the unit pick system. Default N
perishable_ind varchar21 0 1 Not used by RMS. item_master perishable_ind varchar2 1 Yes Used for items that may spoil or any item with a best before date
division number4 0 1 Not used by RMS. item_master division number 4 Yes Item master attribute
vendor_nbr varchar210 0 1 Not used by RMS. item_master vendor_nbr varchar2 10 Yes An identifier that uniquely identifies a vendor.
kitting_wip_code varchar29 0 1 Wip code used to designate the Kitting process used in item_master item_master kitting_wip_code varchar2 9 Yes Fill this description.
unit_ticket_qty number3 0 1 Item Master User Defined Attribute item_master unit_ticket_qty number 3 Yes The number of price tickets per selling unit of the item that are required. Default is 1
item_length number12_4 0 1 Length of an individual item item_master item_length number 12 Yes Length of an individual item (dimensionless).
item_width number12_4 0 1 Width of an individual item item_master item_width number 12 Yes Width of an individual item (dimensionless).
item_height number12_4 0 1 Height of an individual Item item_master item_height number 12 Yes Height of an individual item (dimensionless).
item_weight number12_4 0 1 Weight of an individual item item_master item_weight number 12 Yes Weight of an individual item (dimensionless).
item_cube number12_4 0 1 Cubic dimension of an individual item item_master item_cube number 12 Yes Cubic dimension of an individual item ( dimensionless).
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. item_master std_unit_factor number 6 Yes Used for putaway by volume. The percentage of the standard number of units that will fit into a location type
std_unit_qty number12_4 0 1 The number of items that normally fit on/in the container type item_master std_unit_qty number 12 Yes Standard Unit Quantity. The number of items that normally fit on/in the container type.
expiration_days number4 0 1 The number of days before inventory is deemed to be no longer distributable item_master expiration_days number 4 Yes The number of days before inventory is deemed to be no longer distributable;
putaway_by_volume varchar26 0 1 If set to Y, putaway will be determined by cube or volume. If set to N, putaway will be determined by capacity. item_master putaway_by_volume varchar2 1 Yes If set to Y, putaway will be determined by cube or volume. If set to N putaway will be determined by capacity - Default N
putaway_plan varchar220 0 1 Plan used for putaway item_master putaway_plan varchar2 20 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. item_master item_type varchar2 4 Yes Fill this description.
sorter_group varchar26 0 1 Sorter Group identifier item_master sorter_group varchar2 6 Yes Sorter Group identifier.
sku_optimization varchar21 0 1 Indicator for inclusion in SKU optimization item_master sku_optimization varchar2 1 Yes Indicator for inclusion in SKU optimization
ext_source_system varchar26 0 1 Specifies what external system the data originated from. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
inventory_ind varchar21 0 1 Inventory Indicator Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
order_type varchar29 0 1 Indicates the type of order and which Open To Buy bucket will be updated. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
sale_type varchar26 0 1 n/a Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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 Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
transport_ind varchar21 0 1 Not used by RMS. item_master transport_ind varchar2 1 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
soh_inquiry_at_pack_ind varchar21 0 1 Indicates in SIM if a notional simple pack item's inventory should be displayed in packs. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Not used in RWMS
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_code varchar2 24 Yes Product Class Code used for Combinibility purposes

XML-Schema Name:ItemSupDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Unique identifier for the item. item_supplier item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
supplier varchar210 1 1 Unique identifier for the supplier. item_supplier vendor_nbr varchar2 10 Yes An identifier that uniquely identifies a vendor.
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 No Indicator of the primary supplier - If NULL defaults to 'N'
vpn varchar230 0 1 This field contains the Vendor Product Number for the Item. item_supplier vpn varchar2 30 No Vendor Product Number
supp_label varchar215 0 1 This field contains the supplier label. It will only be popluated if item is a style. NA NA RIB or/and RSB or/and RSL Fill column length. Yes Not used by RWMS.
consignment_rate number12_4 0 1 This field contains the consignment rate for this item for the supplier. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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. NA NA RIB or/and RSB or/and RSL Fill column length. Yes Not used by RWMS.
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. NA NA RIB or/and RSB or/and RSL Fill column length. Yes Not used by RWMS.
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. NA NA RIB or/and RSB or/and RSL Fill column length. Yes Not used by RWMS.
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. NA NA RIB or/and RSB or/and RSL Fill column length. Yes Not used by RWMS.
pallet_name varchar26 0 1 Code referencing the name used to refer to the pallet. item_supplier pallet_name varchar2 6 No Vendor description for a pallet
case_name varchar26 0 1 Code referencing the name used to refer to the case. item_supplier <case_name varchar2 6 No Vendor description for a case
inner_name varchar26 0 1 Code referencing the name used to refer to the inner. item_supplier inner_name varchar2 6 No Vendor description for an inner
supp_discontinue_date xs:dateTime 0 1 Date when the supplier discontinues an item. NA NA RIB or/and RSB or/and RSL Fill column length. Yes Not used by RWMS.
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. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.

XML-Schema Name:ItemSupCtyDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupCtyDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Unique identifier for the item. item_supp_country item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
supplier varchar210 1 1 Unique identifier for the supplier. item_supp_country vendor_nbr varchar2 10 No An identifier that uniquely identifies a vendor.
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 Identifier of the country of origin
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 No Indicator of the primary supplier. If NULL default to N, If considered a complex item it is set to Y based on unknown_vendor record.
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 RIB or/and RSB or/and RSL 1 No Indicator of the primary country - If NULL defaults to '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. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
lead_time number4 0 1 This field contains the number of days that will elapse between the date an order is written and the delivery to the store or warehouse from the supplier. item_supp_country lead_time number 4 No Amount of time needed to ship from the country of origin
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. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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 Yes Number of units in the casepack
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 No Quantity of units within an inner - If NULL default to 1
round_lvl varchar26 1 1 This column is used to determine how order quantities will be rounded to case, layer and pallet. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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 Type of packing supported
default_uop varchar26 0 1 Contains the default unit of purchase for the item/supplier/country. Valid values include 'C'ase and 'P'allet. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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 and dc_ti varchar2 1 No Hi for palletization. If NULL default to 1
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 and dc_hi number 12 No Hi for palletization. If NULL default to 1
cost_uom varchar24 0 1 A cost UOM is held to allow costs to be managed in a separate UOM to the standard UOM. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
tolerance_type varchar26 0 1 The unit of tolerance for catch weight simple packs. Valid values are: 'A'-actual 'P' - percent. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
max_tolerance number12_4 0 1 The maximum tolerance value for the catch weight simple pack. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
min_tolerance number12_4 0 1 The minimum tolerance value for a catch weight simple pack NA NA RIB or/and RSB or/and RSL Fill column length. No Fill this description.

XML-Schema Name:ISCDimDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ISCDimDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Unique identifier for the item. item_supp_country_dim item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
supplier varchar210 1 1 Unique identifier for the supplier. item_supp_country_dim vendor_nbr varchar2 10 Yes An identifier that uniquely identifies a vendor.
origin_country varchar23 1 1 The country where the item was manufactured or significantly altered. item_supp_country_dim origin_country_id varchar2 3 Yes Identifier of the country of origin
dim_object varchar26 1 1 Specific object whose dimensions are specified in this record. item_supp_country_dim dim_object varchar2 6 Yes Dimension Object Code EACH = 'EA' CASE= 'CA' PALLET = 'PA'
object_desc varchar240 0 1 Dim_object description fetched from the code_detail table. item_supp_country_dim dim_object_desc varchar2 40 No Dimension Object Description
presentation_method varchar26 0 1 Describes the packaging (if any) being taken into consideration in the specified dimensions. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
method_desc varchar240 0 1 Presentation method description fetched from the code_detail table. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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 the dimension object. . - If NULL default to 1
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 the dimension object. - If NULL default to 1
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 the dimension object. - If NULL default to 1
lwh_uom varchar24 0 1 Unit of measurement for length, width and height. item_supp_country_dim lwh_uom varchar2 4 No UOM associated to the length/width/height of the dimension
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 the dimension object. - If NULL default to 1
net_weight number12_4 0 1 Net weight of the dim_object (weight without packaging) measured in units specified in weight_uom. NA NA RIB or/and RSB or/and RSL Fill column length. No Fill this description.
weight_uom varchar24 0 1 Unit of measurement for weight. item_supp_country_dim weight_uom varchar2 4 No Unit of measurement for weight.
liquid_volume number12_4 0 1 Liquid volume, or capacity, of dim_object measured in units specified in colume_uom. Liquid volumes are only convertible to other liquid volumes. item_supp_country_dim liquid_volume number 12,4 No Liquid volume of the dimension
liquid_volume_uom varchar24 0 1 Unit of measurement for liquid volume. Liquid volumes are only convertible to other liquid volumes. item_supp_country_dim liquid_volume_uom varchar2 4 No UOM associated to the liquid volume of the dimension
stat_cube number12_4 0 1 Statistical value of the dim_object's dimensions to be used for loading purposes. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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 Empty weight of the container type (dimensionless).
tare_type varchar26 0 1 Indicates whether the tare weight for the dim_object is wet or dry. item_supp_country_dim tare_type varchar2 6 No Fill this description.

XML-Schema Name:ItemUDALOVDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDALOVDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Item ID item_attributes item_id RIB or/and RSB or/and RSL 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
uda_id number5 1 1 This field contains the unique identified of the Attribute Group being added or delete to the item list. item_attributes attribute_type RIB or/and RSB or/and RSL 5 Yes Attribute Classification as defined by the Merchandising System
uda_value varchar230 1 1 Contains the value of the Attribute Group. item_attributes attribute RIB or/and RSB or/and RSL 30 Yes Item Attribute as defined by the Merchandising System

XML-Schema Name:ItemUDAFFDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDAFFDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Unique identifier for the item. * * varchar2 25 * *
uda_id number5 1 1 This field contains a number identifying the user-defined attribute. * * number 5 * *
uda_text varchar2250 0 1 This field contains the text value of the user-defined attribute for the item. * * varchar2 250 * *

XML-Schema Name:ItemUDADateDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUDADateDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Unique identifier for the item. * * varchar2 25 * *
uda_id number5 1 1 This field contains a number identifying the user-defined attribute. * * number 5 * *
uda_date xs:dateTime 1 1 This field contains the effective date for the Uda id. * * RIBDate * * *

XML-Schema Name:ItemImageDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemImageDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Unique identifier for the item. * * varchar2 25 * *
image_name varchar2120 1 1 Name of the image. * * varchar2 64 * *
image_addr varchar2255 1 1 Path where the image file is stored. * * varchar2 255 * *
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
primary_ind varchar21 0 1 Field indicating whether the record is a primary image or not. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
display_priority number4 0 1 Field to specify the display sequence order of images associated to the item per priority. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ItemUPCDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemUPCDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item_id varchar225 1 1 Unique identifier for the item. item_upc upc varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
item_parent varchar225 0 1 Unique identifier for the item/group at the level above the item. item_upc item_id VARCHAR2 25 Yes Universal product code for a particular item.
primary_ref_item_ind varchar21 0 1 Indicates if the sub-transaction level item is designated as the primary sub-transaction level item. For transaction level items and above, the value in this field will be 'N'o. item_upc primary_upc_ind varchar2 1 No Indicator of the primary UPC. If NULL default to N
format_id varchar21 0 1 This field will hold the format id that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
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. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.
item_number_type varchar26 0 1 This type can hold a number of digits count umber_type. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used by RWMS.

XML-Schema Name:ItemBOMDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemBOMDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
pack_no varchar225 1 1 Unique identifier for the pack item. bill_of_materials master_item_id varchar2 25 Yes if item_master.deposit_item = Y then deposit_component_item.master_item_id table.column is used instead.
item varchar225 1 1 Unique identifier for the component item. bill_of_materials component_item_id varchar2 25 Yes if item_master.deposit_item = Y then deposit_component_item.component_item_id table.column is used instead.
pack_qty number12_4 1 1 Contains the quantity of each item in the pack item. bill_of_materials unit_qty number 12 Yes if item_master.deposit_item = Y then deposit_component_item.quantity table.column is used instead.

XML-Schema Name:ItemTcktDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemTcktDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Unique identifier for the item. * * varchar2 25 * *
ticket_type_id varchar24 1 1 This field uniquely identifies the ticket type which is associated with the item. * * varchar2 4 * *

XML-Schema Name:ItemSupCtyMfrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemSupCtyMfrDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 Item ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
supplier number10 1 1 Supplier ID. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
manufacturer_ctry_id varchar23 1 1 Country ID of manufacturer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
primary_manufacturer_ctry_ind varchar21 1 1 Primary country of manufacturer indicator. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:RelatedItemDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RelatedItemDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item varchar225 1 1 The main item against which the relationship is defined. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
relationship_id number15 1 1 A system generated numeric field that uniquely identifies the relationship record in related_item_head. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
relationship_name varchar2120 1 1 This is the user entered name of the relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
relationship_type varchar26 1 1 Describes the type of relationship. Valid values are in the codes table under code_type 'IREL'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
mandatory_ind mandatory_ind 1 1 Indicates whether the relationship is mandatory or not. Valid values: 'Y' (yes), 'N' (no). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
RelatedItemDtl * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc.