Sup 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.

Indicates whether the tolerance_value is an amount or a percent. Valid values are A for amount or P for percent. Tolerance types will be held on the codes table under the code type STTT.

Amount that the invoice and receipt (received shipment) can differ by and still be considered a match. This value can be a cost value, a quantity or a percentage, depending on the values in tolerance_level and tolerance_type. If a cost value, this field will be held in the primary currency.