| 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 | ||