Table: dbo.Billing_Item_Schedule
The table used to store default schedule settings associated with a global schedule.
Columns
Name | Type | Constraints | Description
billing_item_schedule_KEY | int (4) | NOT NULL | Primary key for this table; the default schedule for a billing item.
billing_item_KEY | int (4) | NOT NULL | Foreign key; billing item this schedule is associated with.
billing_fee_frequency_KEY | int (4) | NOT NULL | Foreign key; frequency at which this item is billed.
billing_fee_method_KEY | int (4) | NOT NULL | 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.
day_offset | int (4) |  | The number of days before a paydate to offset the billing date for a fee.

Primary key
Name | Columns | Description
PK_Billing_Item_Schedule | billing_item_schedule_KEY |
Unique constraints
Name | Columns | Description
UK_Billing_Item_Schedule$billing_item_KEY | billing_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Billing_Item_Schedule__Billing_Fee_Frequency__billing_fee_frequency_KEY | billing_fee_frequency_KEY | Billing_Fee_Frequency (billing_fee_frequency_KEY) |
FK_Billing_Item_Schedule__Billing_Fee_Method__billing_fee_method_KEY | billing_fee_method_KEY | Billing_Fee_Method (billing_fee_method_KEY) |
FK_Billing_Item_Schedule__Billing_Fee_Month__billing_fee_month_KEY | billing_fee_month_KEY | Billing_Fee_Month (billing_fee_month_KEY) |
FK_Billing_Item_Schedule__Billing_Item__billing_item_KEY | billing_item_KEY | Billing_Item (billing_item_KEY) |