Item Supp Country

Alphanumeric value that identifies the item.

The unique identifier for the supplier.

The country where the item was manufactured or significantly altered.

This field contains the current corporate unit cost for the SKU from the supplier/origin country. This field is stored in item's standard uom and in supplier currency. This value will match the cost field for the primary location on item_supp_country_loc. This field may be edited while the item is in worksheet status. If edited, the user will have the choice of changing the cost of all locations, or only the primary location. This cost is the cost that will be written to item_supp_country_loc when new locations are added to an item.

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 quantity that orders must be placed in multiples of for the supplier for the item.

This field contains the units of an item contained in an inner pack supplied by the supplier.

This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet.

This column will hold the Inner Rounding Threshold value. During rounding, this value is used to determine whether to round partial Inner quantities up or down. If the Inner-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. For instance, with an Inner size of 10 and a Threshold of 80%, Inner quantities such as 18, 29 and 8 would be rounded up to 20, 30 and 10 respectively, while quantities of 12, 27 and 35 would be rounded down to 10, 20 and 30 respectively. Quantities are never rounded down to zero; a quantity of 7, in the example above, would be rounded up to 10. This column will be maintained simply for the purpose of defaulting to the Item/Supplier/Country/Location level.

This column will hold the Case Rounding Threshold value. During rounding, this value is used to determine whether to round partial Case quantities up or down. If the Case-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. For instance, with an Case size of 10 and a Threshold of 80%, Case quantities such as 18, 29 and 8 would be rounded up to 20, 30 and 10 respectively, while quantities of 12, 27 and 35 would be rounded down to 10, 20 and 30 respectively. Quantities are never rounded down to zero; a quantity of 7, in the example above, would be rounded up to 10. This column will be maintained simply for the purpose of defaulting to the Item/Supplier/Country/Location level

This column will hold the Layer Rounding Threshold value. During rounding, this value is used to determine whether to round partial Layer quantities up or down. If the Layer-fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up.

This column will hold the Pallet Rounding Threshold value. During rounding, this value is used to determine whether to round partial Pallet quantities up or down. If the Pallet -fraction in question is less than the Threshold proportion, it is rounded down; if not, it is rounded up. For instance, with an Pallet size of 10 and a Threshold of 80%, Pallet quantities such as 18, 29 and 8 would be rounded up to 20, 30 and 10 respectively, while quantities of 12, 27 and 35 would be rounded down to 10, 20 and 30 respectively. Quantities are never rounded down to zero; a quantity of 7, in the example above, would be rounded up to 10. This column will be maintained simply for the purpose of defaulting to the Item/Supplier/Country/Location level.

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.

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.

This field indicates whether this supplier is the primary supplier for the Item. Each Item can have one and only one primary supplier. This field is stored on this table for performance purposes only. Valid values are Y or N.

This field indicates whether this country is the primary country for the item/supplier. Each item/supplier combination must have one and only one primary country. Valid values are Y or N.

Contains the default unit of purchase for the item/supplier/country. Valid values include: Standard Units of Measure C for Case P for Pallet

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.

Identifies partner type of supplier hierarchy level 1.This field will always have the partner type S1 which indicates manufacturer.

Highest level of supplier hierarchy which is uder to indicate a partner, such as a manufacturer, in the supply chain that gives rebates to the retailer. This information is stored on item_supp_country for defaulting into item_supp_country_loc.

Identifies partner type of supplier hierarchy level 2 . This field will always have the partner type S2 which indicates distributor.

Second highest level of supplier hierarchy which is uder to indicate a partner, such as a distributor in the supply chain that gives rebates to the retailer. This information is stored on item_supp_country for defaulting into item_supp_country_loc.

Identifies partner type of supplier hierarchy level 3. This field will always have the partner type S3 which indicates wholesaler.

Third highest level of supplier hierarchy which is uder to indicate a partner, such as a wholesaler in the supply chain that gives rebates to the retailer. This information is stored on item_supp_country for defaulting into item_supp_country_loc.

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.

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.

A cost UOM is held to allow costs to be managed in a separate UOM than the standard UOM. The unit cost stored in standard UOM is converted to cost UOM for display in the Item Supplier Country screen. Likewise, if the user enters or updates the unit cost via the Item Supplier Country screen, it is converted to standard UOM before being saved to the table.

The unit of the tolerances for catch weight simple packs. Valid values are: A - actual P - percent

The maximum tolerance value for the catch weight simple pack.

The minimum tolerance value for a catch weight simple pack.

This will hold the supplier negotiated item cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations negotiated item cost will be stored in this field.

This will hold the extended base cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations extended base cost will be stored in this field. Extended base cost is the cost inclusive of all the taxes that affect the WAC. In case of GTAX , Extended Base Cost = Base Cost + Non-recoverable taxes. In case of VAT, Extended Base Cost = Base Cost.

This will hold the inclusive cost for the primary delivery country of the item. Once a location is associated with the item, the primary locations inclusive cost will be stored in this field. This cost will have both the recoverable and non recoverable taxes included. In case of GTAX , Inclusive Cost = Base Cost + Non-recoverable taxes + Recoverable Taxes. In case of VAT, Inclusive Cost = Base Cost + VAT. In case of SVAT, Inclusive Cost = Base Cost + VAT. Not applicable for GTS.

This field will hold the tax exclusive cost of the item.

This column holds the User id of the user who created the record.

This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession.

This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate.

This column contains the percentage of the retail price which will determine the cost paid to the supplier for a consignment or concession item.

This indicates whether the price for the consignment/concession item will be managed by supplier or by retailer.When the supplier manages pricing for Consignment/Concession item, this must be set to Supplier(S).No value is required for Owned items and for consignment/concession items for which pricing is managed by the retailer.