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
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary key.
form_year | int (4) | NOT NULL | The calendar year of the 1099 form that these print options apply to.
w2_1099_type_KEY | int (4) | NOT NULL | Foreign key to the type of 1099 form these print options apply to.
vendor_KEY | int (4) |  | Foreign key to the vendor this 1099 applies to. Will be null if this is for an independent contractor 1099.
bank_transaction_KEY | int (4) |  | Foreign key to the parent bank transaction (if transactional).
is_one_1099_per_transaction | bit (1) | NOT NULL | Indicator used to determine if a 1099 should be printed per transaction or not.?
employee_KEY | int (4) |  | Foreign key to the employee this 1099 applies to. Will be null if this is not for an independent contractor 1099.

Primary key
Name | Columns | Description
PK_Form_1099 | form_1099_KEY |
Unique constraints
Name | Columns | Description
UK_Form_1099$form_year$vendor_KEY$w2_1099_type_KEY$bank_transaction_KEY$employee_KEY | form_year, vendor_KEY, w2_1099_type_KEY, bank_transaction_KEY, employee_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1099__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Form_1099__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Form_1099__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Form_1099__W2_1099_Type__w2_1099_type_KEY | w2_1099_type_KEY | W2_1099_Type (w2_1099_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Form_1099_A_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_A_Option |
FK_Form_1099_R_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_R_Option |
FK_Form_1099_Div_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_Div_Option |
FK_Form_1099_B_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_B_Option |
FK_Form_1098_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1098_Option |
FK_Form_1098_E_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1098_E_Option |
FK_Form_1099_Patr_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_Patr_Option |
FK_Form_1099_Oid_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_Oid_Option |
FK_Form_1099_Original_Efile_Transmission_Information__Form_1099_form_1099_KEY | form_1099_KEY | Form_1099_Original_Efile_Transmission_Information | FOREIGN KEY constraint of form_1099_KEY for the Form_1099 table.
FK_Form_1099_Int_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_Int_Option |
FK_Form_1099_G_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_G_Option |
FK_Recipient_1099_Override__Form_1099__form_1099_KEY | form_1099_KEY | Recipient_1099_Override |
FK_Form_1098_C_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1098_C_Option |
FK_Form_5498_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_5498_Option |
FK_Form_1099_S_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_S_Option |
FK_Form_1099_Sa_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_Sa_Option |
FK_Form_1099_C_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_C_Option |
FK_Form_1099_Nec_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_Nec_Option |
FK_Print_1099_Selection__Form_1099__form_1099_KEY | form_1099_KEY | Print_1099_Selection |
FK_Form_W2G_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_W2G_Option |
FK_Form_1099_Misc_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099_Misc_Option |
FK_Form_1098_T_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1098_T_Option |
FK_Form_5498_Sa_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_5498_Sa_Option |