Table: dbo.Billing_Fee_Schedule
Columns
NameTypeConstraintsDescription
billing_fee_schedule_KEYint (4)NOT NULLPrimary key for this table
billing_item_KEYint (4)NOT NULLKey of the associated billing item for this table entry
unit_count_startint (4)NOT NULLUnit 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_amountdecimal (9, 2)NOT NULLAmount to be billed for items with a weekly frequency
biweekly_amountdecimal (9, 2)NOT NULLAmount to be billed for items with a bi-weekly frequency
twice_monthly_amountdecimal (9, 2)NOT NULLAmount to be billed for items with a twice monthly frequency
monthly_amountdecimal (9, 2)NOT NULLAmount to be billed for items with a monthly frequency
quarterly_amountdecimal (9, 2)NOT NULLAmount to be billed for items with a quarterly frequency
semiannually_amountdecimal (9, 2)NOT NULLAmount to be billed for items with a semi-annual frequency
annually_amountdecimal (9, 2)NOT NULLAmount to be billed for items with a annual frequency
vendor_amountdecimal (9, 2)NOT NULLAmount to be billed for vendor checks.
Primary key
NameColumnsDescription
PK_Billing_Fee_Schedulebilling_fee_schedule_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Billing_Fee_Schedule__Billing_Item__billing_item_KEYbilling_item_KEYBilling_Item (billing_item_KEY)

Schema diagram