Retail Integration Bus Mappings Report Release:13.1 (Store Inventory Management)
Application Store Inventory Management
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.

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

XML-Schema Name:ItemHdrDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemHdrDesc
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Unique alphanumeric value that identifies the item. AS_ITM ID_ITM VARCHAR2 128 No Not Yet Available
item_number_type varchar26 1 1 This type can hold a number of digits count umber_type. AS_ITM ITEM_ID_TY VARCHAR2 10 No Not Yet Available
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. null varchar2 1 null null
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 null number 2 null null
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. AS_ITM ID_PRT_ITM VARCHAR2 128 No Not Yet Available
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. null varchar2 25 null null
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. AS_ITM PACK_IND VARCHAR2 1 Yes Not Yet Available
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. AS_ITM ITEM_LEVEL NUMBER NUMBER No Not Yet Available
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. AS_ITM TRANS_LEVEL NUMBER NUMBER No Not Yet Available
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. AS_ITM DIFF_1 VARCHAR2 10 No Not Yet Available
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. null null null null null
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. AS_ITM DIFF_2 VARCHAR2 10 No Not Yet Available
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. null null null null null
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. AS_ITM DIFF_3 VARCHAR2 10 No Not Yet Available
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. null null null null null
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. AS_ITM DIFF_4 VARCHAR2 10 No Not Yet Available
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. null null null null null
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. AS_ITM ID_DPT_POS NUMBER 128 No Not Yet Available
dept_name varchar2120 0 1 Contains the name of the department. null varchar2 20 null null
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. AS_ITM ID_CLSS VARCHAR2 128 No Not Yet Available
class_name varchar2120 0 1 Contains the name of the class. null varchar2 20 null null
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. AS_ITM ID_SBCL VARCHAR2 128 No Not Yet Available
sub_name varchar2120 0 1 Contains the name of the subclass. null varchar2 20 null null
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. AS_ITM STATUS VARCHAR2 1 No Not Yet Available
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. null null null null 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. AS_ITM DE_ITM VARCHAR2 255 No Not Yet Available
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. null varchar2 100 null null
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. AS_ITM PRIMARY_REF VARCHAR2 1 No Not Yet Available
retail_zone_group_id number4 0 1 Retail pricing strategy associated with the item. AS_ITM RETAIL_ZONE_GRP_ID NUMBER 128 No Not Yet Available
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. null number 4 null null
standard_uom varchar24 0 1 Unit of measure in which stock of the item is tracked at a corporate level. AS_ITM LU_UOM_DFT VARCHAR2 40 No Not Yet Available
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. null null null null null
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. AS_ITM DFT_CASE_SIZE NUMBER 12,2 No Not Yet Available
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. AS_ITM PACKAGE_UOM VARCHAR2 4 No Not Yet Available
merchandise_ind varchar21 0 1 Indicates if the item is a merchandise item (Y, N). null varchar2 1 null null
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. null null null null null
forecast_ind varchar21 0 1 Indicates if this item will be interfaced to an external forecasting system (Y, N). null varchar2 1 null null
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. null number 20 null null
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. null varchar2 6 null null
retail_label_type_desc varchar240 0 1 Contains the retail label type description corresponding to the retail_label_type value in item_master. null varchar2 40 null null
retail_label_value number20_4 0 1 This field represents the value associated with the retail label type. null number 20 null null
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. null varchar2 6 null null
handling_temp_desc varchar240 0 1 Contains the Handling temperature description corresponding to the handling_temp value in item_master. null varchar2 40 null null
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. null varchar2 6 null null
handling_sensitivity_desc varchar240 0 1 Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. null varchar2 40 null null
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'. null varchar2 1 null null
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. null null null null null
waste_type_desc varchar240 0 1 Contains the Waste Type description corresponding to the Waste_Type value in item_master. c varchar2 40 null null
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. null number 12 null null
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. null number 12 null null
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. null null null null null
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. null null null null null
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. null null null null null
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. AS_ITM SELLABLE_IND VARCHAR2 1 Yes Not Yet Available
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. AS_ITM ORDERABLE_IND VARCHAR2 1 Yes Not Yet Available
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. null null null null 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). AS_ITM LU_CLN_ORD VARCHAR2 20 No Not Yet Available
comments varchar22000 0 1 Holds any comments associated with the item. null varchar2 2000 null null
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. null number 20 null null
item_service_level varchar26 0 1 Holds a value that restricts the type of shipment methods that RCOM can select for an item. null varchar2 6 null null
gift_wrap_ind varchar21 0 1 This field will contain a value of 'Y' if the item is eligible to be gift wrapped. null varchar2 1 null null
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. null varchar2 1 null null
vendor_style varchar215 0 1 Not used by RMS. null varchar2 15 null null
std_unit_weight number20_10 0 1 Not used by RMS. null number 20 null null
single_price_flag varchar21 0 1 Not used by RMS. null varchar2 1 null null
preticket_flag varchar21 0 1 Not used by RMS. null varchar2 1 null null
planned_residual varchar21 0 1 Not used by RMS. null varchar2 1 null null
autopackable number8 0 1 Not used by RMS. null number 8 null null
sortable varchar21 0 1 Not used by RMS. null varchar2 1 null null
item_master_uda1 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda2 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda3 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda4 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda5 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda6 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda7 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda8 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda9 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda10 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda11 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda12 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda13 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda14 varchar220 0 1 Not used by RMS. null varchar2 20 null null
item_master_uda15 varchar220 0 1 Not used by RMS. null varchar2 20 null null
ship_alone varchar21 0 1 Not used by RMS. null varchar2 1 null null
slottable varchar21 0 1 Not used by RMS. null varchar2 1 null null
freight_class varchar24 0 1 Not used by RMS. null varchar2 4 null null
new_item varchar21 0 1 Not used by RMS. null varchar2 1 null null
brand varchar210 0 1 Not used by RMS. null varchar2 10 null null
break_case_ups varchar24 0 1 Not used by RMS. null varchar2 4 null null
rigid varchar21 0 1 Not used by RMS. null varchar2 1 null null
fragile varchar21 0 1 Not used by RMS. null varchar2 1 null null
container_type varchar26 0 1 Not used by RMS. null varchar2 6 null null
conveyable_flag varchar21 0 1 Not used by RMS. null varchar2 1 null null
hazard_matl_code varchar26 0 1 Not used by RMS. null varchar2 6 null null
velocity number12_4 0 1 Not used by RMS. null number 12 null null
high_value_ind varchar21 0 1 Not used by RMS. null varchar2 1 null null
ticket_type varchar24 0 1 Not used by RMS. null varchar2 4 null null
color varchar224 0 1 Not used by RMS. null varchar2 24 null null
size1 varchar26 0 1 Not used by RMS. null varchar2 6 null null
fit varchar26 0 1 Not used by RMS. null varchar2 6 null null
shade varchar26 0 1 Not used by RMS. null varchar2 6 null null
single_contain_bulk varchar21 0 1 Not used by RMS. null varchar2 1 null null
unit_pick_system_code varchar212 0 1 Not used by RMS. null varchar2 1 null null
roundable_flag varchar21 0 1 Not used by RMS. null varchar2 1 null null
perishable_ind varchar21 0 1 Not used by RMS. null varchar2 1 null null
division number4 0 1 Not used by RMS. null number 4 null null
vendor_nbr varchar210 0 1 Not used by RMS. null varchar2 10 null null
kitting_wip_code varchar29 0 1 Wip code used to designate the Kitting process used in item_master null varchar2 6 null null
unit_ticket_qty number3 0 1 Item Master User Defined Attribute null number 3 null null
item_length number12_4 0 1 Length of an individual item null number 12 null null
item_width number12_4 0 1 Width of an individual item null number 12 null null
item_height number12_4 0 1 Height of an individual Item null number 12 null null
item_weight number12_4 0 1 Weight of an individual item null number 12 null null
item_cube number12_4 0 1 Cubic dimension of an individual item null number 12 null null
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. null number 6 null null
std_unit_qty number12_4 0 1 The number of items that normally fit on/in the container type null number 12 null null
expiration_days number4 0 1 The number of days before inventory is deemed to be no longer distributable null number 4 null null
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. null varchar2 6 null null
putaway_plan varchar220 0 1 Plan used for putaway null varchar2 6 null null
item_type varchar26 0 1 This column contains a character indicator to determine if the item being ordered is a pack or not. null varchar2 6 null null
sorter_group varchar26 0 1 Sorter Group identifier null varchar2 6 null null
sku_optimization varchar21 0 1 Indicator for inclusion in SKU optimization null varchar2 1 null null
ext_source_system varchar26 0 1 Specifies what external system the data originated from. null varchar2 6 null null
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. null varchar2 1 null null
inventory_ind varchar21 0 1 Inventory Indicator null varchar2 1 null null
order_type varchar29 0 1 Indicates the type of order and which Open To Buy bucket will be updated. null varchar2 9 null null
sale_type varchar26 0 1 n/a null varchar2 6 null null
deposit_item_type varchar26 0 1 n/a null varchar2 6 null null
container_item varchar225 0 1 n/a null varchar2 25 null null
deposit_in_price_per_uom varchar26 0 1 n/a null varchar2 6 null null
transport_ind varchar21 0 1 n/a null varchar2 1 null null
notional_pack_ind varchar21 0 1 Indicates in SIM if a sellable simple pack needs to be broken down to its component item. NA NA NA NA NA NA
soh_inquiry_at_pack_ind varchar21 0 1 Indicates in SIM if a notional simple pack item's inventory should be displayed in packs. NA NA NA NA NA NA
purchase_type varchar26 0 1 Indicates if an item is a normal, consignment or concession item - 'N' for normal, 'S' for consignment, 'C' for concession. NA NA NA NA NA NA
ExtOfItemHdrDesc:ExtOfItemHdrDesc * 0 1 Provide an extension hook to customize ItemHdrDesc. NA NA NA NA NA NA

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

XML-Schema Name:ItemSupDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemSupDesc
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Unique identifier for the item. RK_ITEM_SUPPLIER ID_ITM VARCHAR2 128 No Not Yet Available
supplier varchar210 1 1 Unique identifier for the supplier. RK_ITEM_SUPPLIER ID_SPR VARCHAR2 128 No Not Yet Available
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. RK_ITEM_SUPPLIER PRIMARY_IND VARCHAR2 1 No Not Yet Available
vpn varchar230 0 1 This field contains the Vendor Product Number for the Item. RK_ITEM_SUPPLIER VPN VARCHAR2 256 No Not Yet Available
supp_label varchar215 0 1 This field contains the supplier label. It will only be popluated if item is a style. null null null null null
consignment_rate number12_4 0 1 This field contains the consignment rate for this item for the supplier. null number 12 null null
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. null varchar2 80 null null
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. null varchar2 80 null null
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. null varchar2 80 null null
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. null varchar2 80 null null
pallet_name varchar26 0 1 Code referencing the name used to refer to the pallet. null varchar2 6 null null
case_name varchar26 0 1 Code referencing the name used to refer to the case. null varchar2 6 null null
inner_name varchar26 0 1 Code referencing the name used to refer to the inner. null varchar2 6 null null
supp_discontinue_date xs:dateTime 0 1 Date when the supplier discontinues an item. null RIBDate n/a null null
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. null varchar2 1 null null
ExtOfItemSupDesc:ExtOfItemSupDesc * 0 1 Provide an extension hook to customize ItemSupDesc. NA NA NA NA NA NA

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

XML-Schema Name:ItemSupCtyDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemSupCtyDesc
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Unique identifier for the item. RK_ITEM_SUPPLIER_COUNTRY ID_ITM VARCHAR2 128 No Not Yet Available
supplier varchar210 1 1 Unique identifier for the supplier. RK_ITEM_SUPPLIER_COUNTRY ID_SPR VARCHAR2 128 No Not Yet Available
origin_country_id varchar23 1 1 The country where the item was manufactured or significantly altered. RK_ITEM_SUPPLIER_COUNTRY COUNTRY_ID VARCHAR2 VAR3 No Not Yet Available
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. null null null null null
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. TBD TBD VARCHAR2 * Not Yet Available Not Yet Available
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. null null null null null
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. null number 4 null null
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. null number 4 null null
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. RK_ITEM_SUPPLIER_COUNTRY CASE_SIZE NUMBER 12,2 No Not Yet Available
inner_pack_size number12_4 1 1 This field contains the break pack size for this item from the supplier. null null null null null
round_lvl varchar26 1 1 This column is used to determine how order quantities will be rounded to case, layer and pallet. null null null null null
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. null number 12 null null
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. null number 12 null null
packing_method varchar26 0 1 This field indicates whether the packing method for the item in the container is flat or hanging. null varchar2 6 null null
default_uop varchar26 0 1 Contains the default unit of purchase for the item/supplier/country. Valid values include 'C'ase and 'P'allet. null varchar2 6 null null
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. null null null null null
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. null null null null null
cost_uom varchar24 0 1 A cost UOM is held to allow costs to be managed in a separate UOM to the standard UOM. null null null null null
tolerance_type varchar26 0 1 The unit of tolerance for catch weight simple packs. Valid values are: 'A'-actual 'P' - percent. null varchar2 6 null null
max_tolerance number12_4 0 1 The maximum tolerance value for the catch weight simple pack. null number 12 null null
min_tolerance number12_4 0 1 The minimum tolerance value for a catch weight simple pack null number 12 null null
ExtOfItemSupCtyDesc:ExtOfItemSupCtyDesc * 0 1 Provide an extension hook to customize ItemSupCtyDesc. NA NA NA NA NA NA

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

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

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

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

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

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

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

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

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

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

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

XML-Schema Name:ItemUPCDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemUPCDesc
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 1 1 Unique identifier for the item. AS_ITM ID_ITM VARCHAR2 128 No Not Yet Available
item_parent varchar225 0 1 Unique identifier for the item/group at the level above the item. AS_ITM ID_PRT_ITM VARCHAR2 128 No Not Yet Available
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. AS_ITM PRIMARY_REF VARCHAR2 1 No Not Yet Available
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. null varchar2 1 null null
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. null number 2 null null
item_number_type varchar26 0 1 This type can hold a number of digits count umber_type. AS_ITM ITEM_ID_TY VARCHAR2 10 No Not Yet Available
ExtOfItemUPCDesc:ExtOfItemUPCDesc * 0 1 Provide an extension hook to customize ItemUPCDesc. NA NA NA NA NA NA

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

XML-Schema Name:ItemBOMDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemBOMDesc
Table Name Column Name API Type Column Length API Required API Description
pack_no varchar225 1 1 Unique identifier for the pack item. CO_CLN_ITM ID_ITM_CLN VARCHAR2 128 Yes Not Yet Available
item varchar225 1 1 Unique identifier for the component item. CO_CLN_ITM ID_ITM_MBR VARCHAR2 128 Yes Not Yet Available
pack_qty number12_4 1 1 Contains the quantity of each item in the pack item. CO_CLN_ITM QU_ITM_PR_ASMB NUMBER 9,2 Yes Not Yet Available
ExtOfItemBOMDesc:ExtOfItemBOMDesc * 0 1 Provide an extension hook to customize ItemBOMDesc. NA NA NA NA NA NA

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

XML-Schema Name:ItemTcktDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemTcktDesc
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Unique identifier for the item. AS_ITM ID_ITM VARCHAR2 128 No Not Yet Available
ticket_type_id varchar24 1 1 This field uniquely identifies the ticket type which is associated with the item. AS_ITM SGGSTD_TICKET_TY_CDE VARCHAR2 6 No Not Yet Available
ExtOfItemTcktDesc:ExtOfItemTcktDesc * 0 1 Provide an extension hook to customize ItemTcktDesc. NA NA NA NA NA NA

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

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

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

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