Supplier Tolerance

Supplier number. Oracle Retail target column SUPPLIER on SUP_TOLERANCE.

Indicator of the favor in which this tolerance should be used. Valid values are S for supplier, R for retailer. A value of S would mean this tolerance would only be used in cases where a discrepancy is in the suppliers favor. A value of R would mean this tolerance would be used in cases where a discrepancy is in the retailers favor. Tolerance favors will be held on the codes table under the code type STFV.

Indicator of the level at which this tolerance should be used. Valid values are TC for summary cost, TQ for summary quantity, LC for line item cost or LQ for line item quantity. Tolerance levels will be held on the codes table under the code type SUTL.

Lower limit of the supplier tolerance. This will be a cost value for summary or line item cost tolerances, a quantity for line item quantity tolerances. If a cost value, this field will be held in the primary currency.

Upper limit of the supplier tolerance. This will be a cost value for the summary or line item cost tolerances, a quantity for line item quantity tolerances. If a cost value, this field will be held in the primary currency.