Table: dbo.Client_Billing_Item_Schedule
Columns
NameTypeConstraintsDescription
billing_fee_frequency_KEYint (4)Foreign key; frequency at which this item is billed
billing_fee_method_KEYint (4)Foreign key; method of billing
billing_fee_month_KEYint (4)Foreign key; month that the billing should occur
billing_fee_dayint (4)Day that the billing should occur
next_billing_datesmalldatetime (4)Next date that a invoice fee should be created for this item.
client_billing_item_KEYint (4)NOT NULLThe client billing item this client billing item schedule is related to. Primary Key.
day_offsetint (4)The number of days before a paydate to offset the billing date for a fee.
client_pay_schedule_KEYint (4)key of the client payroll schedule which we need to use with scheduled billing items.
Primary key
NameColumnsDescription
PK_Client_Billing_Item_Schedule$client_billing_item_KEYclient_billing_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Billing_Item_Schedule__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)
FK_Client_Billing_Item_Schedule__Billing_Fee_Frequency__billing_fee_frequency_KEYbilling_fee_frequency_KEYBilling_Fee_Frequency (billing_fee_frequency_KEY)
FK_Client_Billing_Item_Schedule__Billing_Fee_Method__billing_fee_method_KEYbilling_fee_method_KEYBilling_Fee_Method (billing_fee_method_KEY)
FK_Client_Billing_Item_Schedule__Billing_Fee_Month__billing_fee_month_KEYbilling_fee_month_KEYBilling_Fee_Month (billing_fee_month_KEY)
FK_Client_Billing_Item_Schedule__Client_Billing_Item__client_billing_item_KEYclient_billing_item_KEYClient_Billing_Item (client_billing_item_KEY)

Schema diagram