This is root element of this document which contains name space definitions for the document elements.
It's a referenced element. For detailed description, please refer referenced element doc.
It's a referenced element. For detailed description, please refer referenced element doc.
Description is not available.
Indicates if the VAT rate is used for purchasing or selling. Valid values are C (cost) and R (retail).
The identifier for the VAT region. This value must be predefined on the VAT_REGION table. This node is optional, if it is included this field is required.
The identifier for the VAT code. This node is optional, if it is included in the message this field is required.
The date that the VAT rate became active for the item/VAT region combination.
Indicates if the item is subject to reverse charge VAT at the vat region. Valid values are Y and N.
Provide an extension hook to localize XItemVATDesc.
Description is not available.
The specific location id for this Item Supplier Country Loc message. Corresponds with the value used in the iscloc_hier_level field.
The unit cost for the item at the item\supplier\country\loc level in the supplier's currency. This field will be used for creating new records, not updating existing records.
This will hold the supplier negotiated item cost.
Indicates if the location is the primary location for the item\supplier\country. Valid values are Y (yes) and N (no).
Contains time it takes to get the item from the Supplier to the Initial Receiving Location. This value will be defaulted to the item_supp_country_loc pickup lead time field. The ordering dialog will reference the item/supplier/country/location pickup lead time as the value may vary by location.
This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet.
The Case Rounding Threshold value. Used to determine whether to round partial case quantities up or down.
The Layer Rounding Threshold value. Used to determine whether to round partial Layer quantities up or down.
The Pallet Rounding Threshold value. Used to determine whether to round partial Pallet quantities up or down.
The Inner Rounding Threshold value. Used to determine whether to round partial Inner quantities up or down.
Highest level of supplier hierarchy (e.g. manufacturer). This will be used forassigning rebates that come from a level in the supply chain that is higher than the supplier.
Second highest level of supplier hierarchy. Rebates at this level will include all eligible supplier/item/country/loc records assigned to this supplier hierarchy level.
Third highest level of supplier hierarchy, used for assigning rebates by a level other than supplier.
Provide an extension hook to localize XISCLocDesc.
Description is not available.
This field contains a number identifying the User-Defined Attribute.
Description is not available.
This field contains the text value of the Used Defined attribute for the item.
This field contains value of the Used Defined attribute for the item.
This field contains the text value of the Used Defined attribute for the item.
Description is not available.
Description is not available.
Description is not available.
Provide an extension hook to localize XItemUDADtl.
Description is not available.
The name of the image.
Path where the file of the image is stored.
The description associated with the image.
Date/time stamp of when the record was created.
Description is not available.
Description is not available.
Provide an extension hook to localize XItemImage.
Description is not available.
The season identifier.
The phase identifier.
This field contains a sequence number that combined with the item number will make each record unique.
This field will hold a value for group/differentiator combination records only.
Description is not available.
Holds the date time stamp of the most recent update by the last_update_id. This field is required by the database.
Holds the Oracle user-id of the user who most recently updated this record. This field is required by the database.
Description is not available.
Provide an extension hook to localize XItemSeason.
Description is not available.
The specific hierarchy id for this Item Zone Price message. Corresponds with value used in izp_hier_level field.
Not used.
The selling unit retail value in the currency and the selling UOM on the message. This field cannot be modified.
The selling unit of measure for the item's single unit retail. This field cannot be modified.
The selling unit of measure for the item's multi unit retail. This field cannot be modified.
Not used.
The code of the currency the retail value and zones are in. Item\zone\price records will only be created for stores with the same currency as the retail value on the message.
The multi units for the item\zone. This field cannot be modified.
The multi unit retail in the currency and the multi unit UOM specified on the message. This field cannot be modified.
Provide an extension hook to localize XIZPDesc.
Description is not available.
Specific object whose dimensions are specified in this record (e.g. case, pallet, each). Valid values for this field are in the code type DIMO on the code_head and code_detail tables.
Amount of weight to be subtracted for packaging materials. Used to calculate the true net weight of the dim_object.
"TARE_TYPE - Indicates if tare weight for this dim_object is wet or dry. Valid values are found on the code_detail table with the code_type TARE and include: W = Wet tare weight D = Dry tare weight"
Unit of measurement for length, width, and height (e.g. inches, centimeters, feet). Valid values for this field are contained in uom field on uom_class table where uom_class field = DIMEN.
Length of dim_object measured in units specified in lwh_uom.
Width of dim_object measured in units specified in lwh_uom.
Height of dim_object measured in units specified in lwh_uom.
Liquid volume, or capacity, of dim_object measured in units specified in volume_uom. Liquid volumes are only convertible to other liquid volumes.
Unit of measurement for liquid_volume (e.g. ounces, liters). Liquid volumes are only convertible to other liquid volumes. Valid values for this field are contained in uom field on uom_class table where uom_class field = LVOL.
Statistical value of the dim_objects dimensions to be used for loading purposes.
Unit of measurement for weight (e.g. pounds, kilograms). Valid values for this field are contained in uom field on uom_class table where uom_class field = MASS.
Weight of dim_object measured in units specified in weight_uom.
Unit of measurement for length, width, and height (e.g. inches, centimeters, feet). Valid values for this field are contained in uom field on uom_class table where uom_class field = DIMEN.
Describes the packaging (if any) being taken into consideration in the specified dimensions. Valid values for this field are in the code type PCKT on the code_head and code_detail tables.
Provide an extension hook to localize XISCDimDesc.
Description is not available.
The component item within the pack. This value must be predefined on ITEM_MASTER. It will only be populated if the item on the message is a pack item. This value cannot be modified. Only transaction level items can be pack components.
The quantity of the component item. This value cannot be modified.
Provide an extension hook to localize XItemBOMDesc.
Description is not available.
The identifier for the country where the item is sourced. This value must be predefined on the COUNTRY table.
This indicates if the country is the primary country for the item\supplier. Valid values are Y (yes) and N (no).
The current corporate unit cost for the item in the supplier's currency. This field will only be used to establish the item\supplier\country unit cost; it cannot be modified.
Child node.
Child node.
This field contains the number of days that will elapse between the date an order is written and the delivery to the store or warehouse from the supplier. This field is defaulted from the default lead time set at the supplier level.
Contains time it takes to get the item from the Supplier to the Initial Receiving Location. This value will be defaulted to the item_supp_country_loc pickup lead time field. The ordering dialog will reference the item/supplier/country/location pickup lead time as the value may vary by location.
This field contains the minimum quantity that can be ordered at one time from the supplier for the item.
This field contains the maximum quantity that can be ordered at one time from the supplier for the item.
Highest level of supplier hierarchy (e.g. manufacturer). This will be used for assigning rebates that come from a level in the supply chain that is higher than the supplier. This information is stored on item_supp_country for defaulting into item_supp_country_loc.
Second highest level of supplier hierarchy. This information is stored on item_supp_country for defaulting into item_supp_country_loc.
Third highest level of supplier hierarchy. This information is stored on item_supp_country for defaulting into item_supp_country_loc.
Contains the default unit of purchase for the item/supplier/country. Valid values include: Standard Units of Measure C for Case P for Pallet
Contains the quantity that orders must be placed in multiples of for the supplier for the item.
This field contains the break pack size for this item from the supplier.
Number of shipping units (cases) that make up one tier of a pallet. Multiply TI x HI to get total number of units (cases) for a pallet.
Number of tiers that make up a complete pallet (height). Multiply TI x HI to get total number of units (cases) for a pallet.
Child node that is not used.
Unit of measure associated with the item cost. It is held to allow costs to be managed in a separate UOM from the standard UOM.
The unit of the tolerances for catch weight simple packs: A - actual, P - percent.
The minimum tolerance value for a catch weight simple pack.
The maximum tolerance value for a catch weight simple pack.
Identifies partner type of supplier hierarchy level 1 for the foreign key to the partner table.
Identifies partner type of supplier hierarchy level 2 for the foreign key to the partner table.
Identifies partner type of supplier hierarchy level 3 for the foreign key to the partner table.
This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet.
The Inner Rounding Threshold value. Used to determine whether to round partial Inner quantities up or down.
The Case Rounding Threshold value. Used to determine whether to round partial Case quantities up or down.
The Layer Rounding Threshold value. Used to determine whether to round partial Layer quantities up or down.
The Pallet Rounding Threshold value. Used to determine whether to round partial Pallet quantities up or down.
This field indicates whether the packing method of the item in the container is Flat or Hanging. Values for this field are store in the PKMT code..
Provide an extension hook to localize XItemSupCtyDesc.
Description is not available.
The identifier of the supplier who sources the item. This value must be predefined on the SUPS table.
Indicates if the supplier is the primary supplier for the item. Valid values are Y (yes) and N (no).
The vendor product number associated with the item.
The supplier label for the item.
Child node.
This field contains the consignment rate for this item for the supplier.
Date which the supplier discontinues an item. The retailor should be aware that the supplier is able to reuse a UPC after 30 months and should work to ensure that no data exists in RMS for a UPC 30 months after it has been discontinued.
Contains a value of Yes to indicate that any item asssociated with this supplier is eligible for a direct shipment from the supplier to the customer.
Code referencing the name used to refer to the pallet. Valid codes are defined in the PALN code type. Examples are flat, pallet.
Code referencing the name used to refer to the case. Valid codes are defined in the CASN code type. Examples are pack, box, bag.
Code referencing the name used to refer to the inner. Valid codes are defined in the INRN code type. Examples are sub-case, sub-pack.
It's a referenced element. For detailed description, please refer referenced element doc.
Used only if AIP is interfaced. Indicates the primary case size for the item supplier when an orderable item is configured for informal case types.
This field contains the first supplier differentiator and/or description. This field may only contain a value for items with an item_parent.
This field contains the second supplier differentiator and/or description. This field may only contain a value for items with an item_parent.
This field contains the third supplier differentiator and/or description. This field may only contain a value for items with an item_parent.
This field contains the fourth supplier differentiator and/or description. This field may only contain a value for items with an item_parent.
The concession rate is the margin that a particular supplier receives for the sale of a concession item.
Provide an extension hook to localize XItemSupDesc.
This object contains the country associated with the item.
Id of the country associated with the item.
Provide an extension hook to localize XItemCtryDesc.
This object holds the item costing data for each item-supplier-country-delivery country.
Country where the Item will be delivered.
Indicates if the country is the primary delivery country of the item.
Indicates if the Negotiated Item Cost (NIC) is static or not. If NIC is static, then the Base Cost of the item will vary based on the location/tax region; if NIC is not static, then NIC will vary based on the location/tax region.
This will hold the tax exclusive cost of the item.
This will hold the supplier negotiated item cost.
Provide an extension hook to localize XItemCostDesc.
Description is not available.
The unique identifier of the main item on the message.
The item at the level above this item. This value must be predefined as an item on the ITEM_MASTER table.
The item two levels above this item. This value must be predefined as an item on the ITEM_MASTER table.
Indicates if the item is a pack item. Valid values are Y (yes) and N (no). This value cannot be modified.
The level of the item. Valid values are 1 (single level or pack item), 2 (child item), and 3 (grandchild item).
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.
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.
See description for diff_1.
See description for diff_1.
See description for diff_1.
The number of the department to which this item belongs. This value must be predefined on the DEPS table. It cannot be modified.
The number of the class to which the item belongs. This value must be predefined on the CLASS table. It cannot be modified.
The number of the subclass to which the item belongs. This value must be predefined on the SUBCLASS table. It cannot be modified.
The long description of the item.
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).
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.
The short description of the item. If this field is not populated it will default from the long description.
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.
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.
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).
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.
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.
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).
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.
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.
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.
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.
Comments associated with the item.
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.
Child node.
Child node.
Child node.
Child node.
Child node.
Child node that is not used.
Child node that is not used.
Child node that is not used.
Not used.
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.
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.
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.
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.
Manufacturers recommended retail price for the item in primary currency. Used for informational purposes only.
Identifies the wastage type as either sales or spoilage wastage.
Average percent of wastage for the item over its shelf life. Used in inflating the retail price for wastage items.
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.
Indiactes whether the item should be weighed when it arives at a location. Valid values for this field are Y and N.
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.
This field will contain a value of 'Y' if the item is eligible to be gift wrapped.
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.
Not used.
Not used.
Not used.
Not used.
Not used.
Not used.
Not used.
Not used.
Not used.
Not used.
Not used.
Not used.
Indicator for the corresponding diff.
Indicator for the corresponding diff.
Indicator for the corresponding diff.
Indicator for the corresponding diff.
Indicates if an item is perishable.
Indicates in SIM if a sellable simple pack needs to be broken down to its component item.
Indicates in SIM if a notional simple pack item's inventory should be displayed in packs.
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.
This determines how catch weight items are ordered: F - fixed weight, V - Variable weight.
This determines how catch weight items are sold in store locations: V - variable weight each, L - Loose weight.
Unit of measure of a catch weight item.
This is the deposit item component type: E - Contents, A - Container, Z - Crate, T - Returned Item (Empty bottle), P - Complex pack (with deposit items).
This indicates if an item holds inventory or not for item transformation.
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.
This holds the container item number for a content item.
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.
This field will hold the format ID that corresponds to the items variable UPC. This value is only used for items with variable UPCs.
This column holds the prefix for variable weight UPCs.
This is added to capture the brand information of an item.
This defines which items can be combined (packed or boxed) together.
Secondary descriptions of the item.
All upper case description of the item.
Indicates if the item is a merchandise item (Y, N).
The original retail price of the item per unit. This field is stored in the primary currency.
This field indicates any special label type assoctiated with an item.
This field represents the value associated with the retail label type.
Default daily wastage percent for spoilage type wastage items.
Holds a value that restricts the type of shipment methods that RCOM can select for an item.
This field indicates whether the user has called the itemuda form.
This field indicates if the deposit amount is included in the price per UOM calculation for a contents item ticket.
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.
Provide an extension hook to localize XItemDesc.
This type can hold a string of max length of 25 characters.
This type can hold a number of digits count 3.
This type can hold a string of max length of 10 characters.
This type can hold a number of digits count 4.
This type can hold a string of max length of 7 characters.
This type can hold a number of digits count 5.
This type can hold a number of digits count 6.
This type can hold a string of max length of 12 characters.
This type can hold a string of max length of 300 characters.
This type can hold a number of digits count 10.
This type can hold a number of digits count 1.
This type can hold a string of max length of 1 characters.
This type can hold a string of max length of 250 characters.
This type can hold a number of digits count 12.
This type can hold a number of digits count 12 and fraction digit count of 4.
This type can hold a string of max length of 2 characters.
This type can hold a string of max length of 120 characters.
This type can hold a string of max length of 20 characters.
This type can hold a string of max length of 100 characters.
This type can hold a string of max length of 255 characters.
This type can hold a string of max length of 30 characters.
This type can hold a string of max length of 3 characters.
This type can hold a string of max length of 15 characters.
This type can hold a string of max length of 6 characters.
This type can hold a string of max length of 4 characters.
This type can hold a string of max length of 2000 characters.
This type can hold a string of max length of 40 characters.
This type can hold a number of digits count 20.
This type can hold a number of digits count 20 and fraction digit count of 10.
This type can hold a number of digits count 20 and fraction digit count of 4.
This type can hold a string of max length of 24 characters.
This type can hold a string of max length of 5 characters.
This type can hold a number of digits count 2.