Table: dbo.Billing_Fee_Schedule
Columns
Name | Type | Constraints | Description
billing_fee_schedule_KEY | int (4) | NOT NULL | Primary key for this table
billing_item_KEY | int (4) | NOT NULL | Key of the associated billing item for this table entry
unit_count_start | int (4) | NOT NULL | Unit count which define the start of when this table entry is used, end is defined by the unit_count_start of next table entry
weekly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a weekly frequency
biweekly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a bi-weekly frequency
twice_monthly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a twice monthly frequency
monthly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a monthly frequency
quarterly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a quarterly frequency
semiannually_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a semi-annual frequency
annually_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a annual frequency
vendor_amount | decimal (9, 2) | NOT NULL | Amount to be billed for vendor checks.

Primary key
Name | Columns | Description
PK_Billing_Fee_Schedule | billing_fee_schedule_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Billing_Fee_Schedule__Billing_Item__billing_item_KEY | billing_item_KEY | Billing_Item (billing_item_KEY) |