Deal Threshold

Unique deal number, generated from a sequence.

Deal component ID number, uniquely sequenced within each deal.

Lower limit of the deal component. This is the minimum value that must be met in order to get the specified discount. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_limit_type field of this deal component.

Upper limit of the deal component. This is the maximum value for which the specified discount will apply. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_limit_type field of this deal component.

Value of the discount that will be given for meeting the specified thresholds for this deal component. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_value_type field of this deal component. For allowance deals this will have value 1 by default.

Indicates if a threshold level is the targeted purchase or sales level for a deal component. This indicator will be used for cost calculations. Valid values are Y for yes and N for no.

Date/time stamp of when the record was created. This date/time can be used for auditing purposes. This value should only be populated on insert - it should never be updated. This field is required by the database.

Holds the Oracle user-id of the user who most recently updated this record. This date/time can be used for auditing purposes. This field is required by the database.

Holds the date time stamp of the most recent update by the last_update_id. This date/time can be used for auditing purposes. This field is required by the database.

Indicates if the value for deal components for which the threshold type is amount off is amount off by unit or in total. Valid values are Y (by total) for yes and N for no (by unit).

This holds the reason for changing / adding / deleting a threshold for an approved complex deal.

This field contains the allowance component ID and is populated only in case of Allowance deals.

Holds the allowance rate for the allowance component ID. This field is defaulted from the ELC_COMP table and is populated only in case of Allowance deals. The value in this field will be a percentage if the allowance component’s Calculation Basis is V (Value) and a monetary amount in Deal’s currency if the Calculation Basis is S (Specific).

Holds a one character code indicating whether the component is calculated on a per-unit (Specific) or ad valorem (Value) basis for the allowance component ID. Valid values are Value (V) or Specific (S) and this field is populated only in case of Allowance deals.

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