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
NameTypeConstraintsDescription
form_1099_print_threshold_override_KEYint (4)NOT NULLPrimary key.
form_yearint (4)NOT NULLThe calendar year of the 1099 form that this threshhold amount applies to.
vendor_KEYint (4)NOT NULLForeign key to the parent vendor.
first__w2_1099_box_type_KEYint (4)NOT NULLThe foreign key to the first box on the 1099 form that this threshold applies to.
second__w2_1099_box_type_KEYint (4)The foreign key to the second box on the 1099 form that this threshold applies to.
amountdecimal (9, 2)NOT NULLThe threshold amount at which a form will be print.
bank_transaction_KEYint (4)Foreign key to the parent bank transaction (if transactional).
Primary key
NameColumnsDescription
PK_Form_1099_Print_Threshold_Overrideform_1099_print_threshold_override_KEY
Unique constraints
NameColumnsDescription
UK_Form_1099_Print_Threshold_Override$form_year$vendor_KEY$first__w2_1099_box_type_KEY$second__w2_1099_box_type_KEY$bank_transacform_year, vendor_KEY, first__w2_1099_box_type_KEY, second__w2_1099_box_type_KEY, bank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_Print_Threshold_Override__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Form_1099_Print_Threshold_Override__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Form_1099_Print_Threshold_Override__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)
FK_Form_1099_Print_Threshold_Override__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)

Schema diagram