Table: dbo.Billing_Item_Form_Rate
This table is used to hold the different fee amounts for each form of a form fee.
Columns
NameTypeConstraintsDescription
billing_item_form_rate_KEYint (4)NOT NULLPrimary Key
billing_item_KEYint (4)NOT NULLThe billing item that these fee amounts are related to.
billing_item_form_KEYint (4)NOT NULLThe particular form that these fee amounts are applied to.
billing_item_1099_type_KEYint (4)The selected 1099 form(s) for 1099 form type fees.
base_feedecimal (9, 2)NOT NULLThe base fee charged once per each form.
per_printed_pagedecimal (9, 2)The fee amount charged per each printed page.
per_printed_formdecimal (9, 2)The fee amount charged per each copy of the form.
per_recipientdecimal (9, 2)The fee amount charged per each recipient of the form.
Primary key
NameColumnsDescription
PK_Billing_Item_Form_Ratebilling_item_form_rate_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Billing_Item_Form_Rate__Billing_Item__billing_item_KEYbilling_item_KEYBilling_Item (billing_item_KEY)
FK_Billing_Item_Form_Rate__Billing_Item_1099_Type__billing_item_1099_type_KEYbilling_item_1099_type_KEYBilling_Item_1099_Type (billing_item_1099_type_KEY)
FK_Billing_Item_Form_Rate__Billing_Item_Form__billing_item_form_KEYbilling_item_form_KEYBilling_Item_Form (billing_item_form_KEY)

Schema diagram