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