Table: dbo.Form_Processing_Run_Form_Count
This table holds the data needed for recreating, modifying, and creating new fees based on historical data.
Columns
NameTypeConstraintsDescription
form_processing_run_form_count_KEYint (4)NOT NULLPrimary Key
form_processing_run_KEYint (4)NOT NULLThe form processing run this form count is related to.
billing_item_form_KEYint (4)NOT NULLThe actual form this form count is related to.
billing_item_1099_type_KEYint (4)The selected 1099 form type.
printed_page_countint (4)NOT NULLThe number of pages that were printed.
printed_form_countint (4)NOT NULLThe number of forms that were printed.
recipient_countint (4)NOT NULLThe number of recipients this form is for.
Primary key
NameColumnsDescription
PK_Form_Processing_Run_Form_Countform_processing_run_form_count_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_Processing_Run_Form_Count__Billing_Item_1099_Type__billing_item_1099_type_KEYbilling_item_1099_type_KEYBilling_Item_1099_Type (billing_item_1099_type_KEY)
FK_Form_Processing_Run_Form_Count__Billing_Item_Form__billing_item_form_KEYbilling_item_form_KEYBilling_Item_Form (billing_item_form_KEY)
FK_Form_Processing_Run_Form_Count__Form_Processing_Run__form_processing_run_KEYform_processing_run_KEYForm_Processing_Run (form_processing_run_KEY)

Schema diagram