Fixed Deal

Contains the unique fixed deal code number.

Contains the unique number representing a supplier or supplier site. It holds a value when partner_type is S (Supplier) or SS (Supplier Site).

Contains the description of the fixed deal.

Type of the fixed deal. Valid values for this field are defined in the code type FXDT.

Represents the amount of the fixed deal to be collected from the supplier. This value is in Primary currency.

Indicates the status of the fixed deal claim. Valid values are: I - Inactive, A - Active.

Indicates how the fixed deal will be collected from the Supplier. Valid values are: D - Date. M - Monthly, Q - Quarterly, A - Annually

Represents the start date that the Fixed Deal can be claimed from the Supplier. For a collect by of D, this column value would represent the date the collection should be made. For all others it represents the date that the collection period begins.

Represents the date that the Fixed Deal collection period ends.

Indicates the number of collection periods to collect from the vendor. Either the number of months, quarters, or years to collect.

Indicates a promotion number if the fixed deal is a part of a promotion.

Contains any comments associated the fixed deal.

Any given external reference number associated with the deal.

Indicates if organisational and merchandise contribution percentages will be captured. Valid values are Y for yes or N for no.

Type of the supplier or partner the deal applies to. Valid values are: S for supplier, SS for supplier site, S1 for supplier hierarchy level 1 (e.g. manufacturer), S2 for supplier hierarchy level 2 (e.g. distributor) and S3 for supplier hierarchy level 3 (e.g. wholesaler).

Level of supplier hierarchy (e.g. manufacturer, distributor or wholesaler), set up as a partner in the PARTNER table, used for assigning rebates by a level other than supplier. Rebates at this level will include all eligible supplier/item/country records assigned to this supplier hierarchy level.

Indicates if VAT rate is to be entered for the deal. Valid values are Y for yes or N for no.

This will determine if the credit notes or debit notes created should be created manually or require manual intervention and also if negative amounts should be included. Valid values are AA for Automatic All values, MA for Manual All Values, AP Automatic Positive values only, MA Manual Positive values only, NO - no invoice processing - these will be held on the codes table under a new code type of DLIP.

This will determine the bill back method. It will be required for bill back deals only. Valid values are Credit note or Debit note - these will be held on the codes table under a new code type of DLBM.

This is the non merch code for the fixed deal. It is the code for all non-merchandise lines used within invoice matching.

This is the VAT RATE captured at the time of entry of the VAT type and VAT code for the fixed deal. This is required if the VAT_IND =Y

This is the VAT CODE. This is required if the VAT_IND =Y.

This contains the unique identifier for the user.

Org Unit Id Oracle Retail target column ORG_UNIT_ID on FIXED_DEAL.

This column will contain the currency code of the deal.