Fixed Deal Dates

Contains the unique fixed deal code number.

Contains each date that the Fixed Deal should be claimed from the Suppplier. For a collect by of D, there would be only one column containing the single collect date. For all other collect by methods there will be a column for each collection period after the start date.

Represents the amount of the fixed deal to be collected from the Supplier.

This column will indicate whether the fixed deal invoice information has been extracted for a the given date in specified on the fixed_deal_dates table collect_date column. The default value of extracted_ind will be is N and after extraction it will be updated to Y. If the fixed deal is set to inactive, this column will be set to I to avoid duplicate billings.

This column will contain the currency code of the deal.