The table used to store rate adjustments related to a client billing item. |
client_billing_item_rate_adjustment_KEY | int (4) | NOT NULL | Primary key for the Client_Billing_Item_Rate_Adjustment table. |
client_billing_item_KEY | int (4) | NOT NULL | Foreign key into the Client_Billing_Item table. |
begin_date | smalldatetime (4) | | Date this rate adjustment becomes active. |
end_date | smalldatetime (4) | | Date this rate adjustment becomes inactive. |
adjustment_rate | decimal (5, 4) | NOT NULL | Adjustment rate to be applied to the client billing item during date range. Positive for a premium, negitive for a discount. |