Table: dbo.Form_1099_Print_Threshold_Override
This table contains the valid 1099 box combinations available for use on bank transactions for a particular vendor.
Columns
Name | Type | Constraints | Description
form_1099_print_threshold_override_KEY | int (4) | NOT NULL | Primary key.
form_year | int (4) | NOT NULL | The calendar year of the 1099 form that this threshhold amount applies to.
vendor_KEY | int (4) | NOT NULL | Foreign key to the parent vendor.
first__w2_1099_box_type_KEY | int (4) | NOT NULL | The foreign key to the first box on the 1099 form that this threshold applies to.
second__w2_1099_box_type_KEY | int (4) |  | The foreign key to the second box on the 1099 form that this threshold applies to.
amount | decimal (9, 2) | NOT NULL | The threshold amount at which a form will be print.
bank_transaction_KEY | int (4) |  | Foreign key to the parent bank transaction (if transactional).

Primary key
Name | Columns | Description
PK_Form_1099_Print_Threshold_Override | form_1099_print_threshold_override_KEY |
Unique constraints
Name | Columns | Description
UK_Form_1099_Print_Threshold_Override$form_year$vendor_KEY$first__w2_1099_box_type_KEY$second__w2_1099_box_type_KEY$bank_transac | form_year, vendor_KEY, first__w2_1099_box_type_KEY, second__w2_1099_box_type_KEY, bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1099_Print_Threshold_Override__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Form_1099_Print_Threshold_Override__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Form_1099_Print_Threshold_Override__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | W2_1099_Box_Type (w2_1099_box_type_KEY) |
FK_Form_1099_Print_Threshold_Override__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | W2_1099_Box_Type (w2_1099_box_type_KEY) |