Table: dbo.Client_Billing_Item_Schedule
Columns
Name | Type | Constraints | Description
billing_fee_frequency_KEY | int (4) |  | Foreign key; frequency at which this item is billed
billing_fee_method_KEY | int (4) |  | Foreign key; method of billing
billing_fee_month_KEY | int (4) |  | Foreign key; month that the billing should occur
billing_fee_day | int (4) |  | Day that the billing should occur
next_billing_date | smalldatetime (4) |  | Next date that a invoice fee should be created for this item.
client_billing_item_KEY | int (4) | NOT NULL | The client billing item this client billing item schedule is related to. Primary Key.
day_offset | int (4) |  | The number of days before a paydate to offset the billing date for a fee.
client_pay_schedule_KEY | int (4) |  | key of the client payroll schedule which we need to use with scheduled billing items.

Primary key
Name | Columns | Description
PK_Client_Billing_Item_Schedule$client_billing_item_KEY | client_billing_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Billing_Item_Schedule__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule (client_pay_schedule_KEY) |
FK_Client_Billing_Item_Schedule__Billing_Fee_Frequency__billing_fee_frequency_KEY | billing_fee_frequency_KEY | Billing_Fee_Frequency (billing_fee_frequency_KEY) |
FK_Client_Billing_Item_Schedule__Billing_Fee_Method__billing_fee_method_KEY | billing_fee_method_KEY | Billing_Fee_Method (billing_fee_method_KEY) |
FK_Client_Billing_Item_Schedule__Billing_Fee_Month__billing_fee_month_KEY | billing_fee_month_KEY | Billing_Fee_Month (billing_fee_month_KEY) |
FK_Client_Billing_Item_Schedule__Client_Billing_Item__client_billing_item_KEY | client_billing_item_KEY | Client_Billing_Item (client_billing_item_KEY) |