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
Name | Type | Constraints | Description
vendor_1099_box_setup_KEY | int (4) | NOT NULL | Primary key.
vendor_KEY | int (4) | NOT NULL | Foreign key to the parent vendor.
sequence_number | int (4) | NOT NULL | Sequence number that determines the order within the vendor 1099 form selection grid.
first__w2_1099_box_type_KEY | int (4) | NOT NULL | The foreign key to the first box the amount is to appear in on the 1099 form.
second__w2_1099_box_type_KEY | int (4) |  | The foreign key to the second box the amount is to appear in on the 1099 form.
is_one_1099_per_transaction | bit (1) | NOT NULL | Indicator used to determine if a 1099 should be printed per transaction or not.
is_default | bit (1) | NOT NULL | Indicator used to determine if a 1099 should be printed per transaction or not.
always_print_form | bit (1) | NOT NULL | When 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
Name | Columns | Description
PK_Vendor_1099_Box_Setup | vendor_1099_box_setup_KEY |
Unique constraints
Name | Columns | Description
UK_Vendor_1099_Box_Setup$vendor_KEY$first__w2_1099_box_type_KEY$second__w2_1099_box_type_KEY | vendor_KEY, first__w2_1099_box_type_KEY, second__w2_1099_box_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor_1099_Box_Setup__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Vendor_1099_Box_Setup__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_Vendor_1099_Box_Setup__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) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Vendor_Distribution__Vendor_1099_Box_Setup__vendor_1099_box_setup_KEY | vendor_1099_box_setup_KEY | Vendor_Distribution |
FK_Vendor_Amortization_Schedule__Vendor_1099_Box_Setup__interest__vendor_1099_box_setup_KEY | interest__vendor_1099_box_setup_KEY | Vendor_Amortization_Schedule |
FK_Vendor_Amortization_Schedule__Vendor_1099_Box_Setup__principal__vendor_1099_box_setup_KEY | principal__vendor_1099_box_setup_KEY | Vendor_Amortization_Schedule |
FK_Bank_Feeds_Assignment_Rule_Action__Vendor_1099_Box_Setup__assigned_value__vendor_1099_box_setup_KEY | assigned_value__vendor_1099_box_setup_KEY | Bank_Feeds_Assignment_Rule_Action |
FK_Bank_Feeds_Assignment_Rule_Action_Distribution__Vendor_1099_Box_Setup__assigned_value__vendor_1099_box_setup_KEY | assigned_value__vendor_1099_box_setup_KEY | Bank_Feeds_Assignment_Rule_Action_Distribution |