Table: dbo.Vendor_1099_Box_Setup
This table contains the valid 1099 box combinations available for use on bank transactions for a particular vendor.
Columns
NameTypeConstraintsDescription
vendor_1099_box_setup_KEYint (4)NOT NULLPrimary key.
vendor_KEYint (4)NOT NULLForeign key to the parent vendor.
sequence_numberint (4)NOT NULLSequence number that determines the order within the vendor 1099 form selection grid.
first__w2_1099_box_type_KEYint (4)NOT NULLThe foreign key to the first box the amount is to appear in on the 1099 form.
second__w2_1099_box_type_KEYint (4)The foreign key to the second box the amount is to appear in on the 1099 form.
is_one_1099_per_transactionbit (1)NOT NULLIndicator used to determine if a 1099 should be printed per transaction or not.
is_defaultbit (1)NOT NULLIndicator used to determine if a 1099 should be printed per transaction or not.
always_print_formbit (1)NOT NULLWhen set to true, any 1099s with this box information for this vendor will print ["BR"] regardless of any thresholds currently set at the transaction, form, or client level.
Primary key
NameColumnsDescription
PK_Vendor_1099_Box_Setupvendor_1099_box_setup_KEY
Unique constraints
NameColumnsDescription
UK_Vendor_1099_Box_Setup$vendor_KEY$first__w2_1099_box_type_KEY$second__w2_1099_box_type_KEYvendor_KEY, first__w2_1099_box_type_KEY, second__w2_1099_box_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_1099_Box_Setup__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Vendor_1099_Box_Setup__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)
FK_Vendor_1099_Box_Setup__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Vendor_Distribution__Vendor_1099_Box_Setup__vendor_1099_box_setup_KEYvendor_1099_box_setup_KEYVendor_Distribution
FK_Vendor_Amortization_Schedule__Vendor_1099_Box_Setup__interest__vendor_1099_box_setup_KEYinterest__vendor_1099_box_setup_KEYVendor_Amortization_Schedule
FK_Vendor_Amortization_Schedule__Vendor_1099_Box_Setup__principal__vendor_1099_box_setup_KEYprincipal__vendor_1099_box_setup_KEYVendor_Amortization_Schedule
FK_Bank_Feeds_Assignment_Rule_Action__Vendor_1099_Box_Setup__assigned_value__vendor_1099_box_setup_KEYassigned_value__vendor_1099_box_setup_KEYBank_Feeds_Assignment_Rule_Action
FK_Bank_Feeds_Assignment_Rule_Action_Distribution__Vendor_1099_Box_Setup__assigned_value__vendor_1099_box_setup_KEYassigned_value__vendor_1099_box_setup_KEYBank_Feeds_Assignment_Rule_Action_Distribution

Schema diagram