Table: dbo.Form_1099
The parent table for the print options of all the myriad 1099 forms. Each of the forms have a unique set of options so this parent table provides a common foreign key that all schema referencing 1099 print options can use.
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key.
form_yearint (4)NOT NULLThe calendar year of the 1099 form that these print options apply to.
w2_1099_type_KEYint (4)NOT NULLForeign key to the type of 1099 form these print options apply to.
vendor_KEYint (4)Foreign key to the vendor this 1099 applies to. Will be null if this is for an independent contractor 1099.
bank_transaction_KEYint (4)Foreign key to the parent bank transaction (if transactional).
is_one_1099_per_transactionbit (1)NOT NULLIndicator used to determine if a 1099 should be printed per transaction or not.?
employee_KEYint (4)Foreign key to the employee this 1099 applies to. Will be null if this is not for an independent contractor 1099.
Primary key
NameColumnsDescription
PK_Form_1099form_1099_KEY
Unique constraints
NameColumnsDescription
UK_Form_1099$form_year$vendor_KEY$w2_1099_type_KEY$bank_transaction_KEY$employee_KEYform_year, vendor_KEY, w2_1099_type_KEY, bank_transaction_KEY, employee_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Form_1099__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Form_1099__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Form_1099__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYW2_1099_Type (w2_1099_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_1099_A_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_A_Option
FK_Form_1099_R_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_R_Option
FK_Form_1099_Div_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_Div_Option
FK_Form_1099_B_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_B_Option
FK_Form_1098_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1098_Option
FK_Form_1098_E_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1098_E_Option
FK_Form_1099_Patr_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_Patr_Option
FK_Form_1099_Oid_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_Oid_Option
FK_Form_1099_Original_Efile_Transmission_Information__Form_1099_form_1099_KEYform_1099_KEYForm_1099_Original_Efile_Transmission_InformationFOREIGN KEY constraint of form_1099_KEY for the Form_1099 table.
FK_Form_1099_Int_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_Int_Option
FK_Form_1099_G_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_G_Option
FK_Recipient_1099_Override__Form_1099__form_1099_KEYform_1099_KEYRecipient_1099_Override
FK_Form_1098_C_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1098_C_Option
FK_Form_5498_Option__Form_1099__form_1099_KEYform_1099_KEYForm_5498_Option
FK_Form_1099_S_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_S_Option
FK_Form_1099_Sa_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_Sa_Option
FK_Form_1099_C_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_C_Option
FK_Form_1099_Nec_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_Nec_Option
FK_Print_1099_Selection__Form_1099__form_1099_KEYform_1099_KEYPrint_1099_Selection
FK_Form_W2G_Option__Form_1099__form_1099_KEYform_1099_KEYForm_W2G_Option
FK_Form_1099_Misc_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099_Misc_Option
FK_Form_1098_T_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1098_T_Option
FK_Form_5498_Sa_Option__Form_1099__form_1099_KEYform_1099_KEYForm_5498_Sa_Option

Schema diagram