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 |