Table: dbo.W2_1099_Box_Type
Lookup table of boxes available on 1099 forms
Columns
Name | Type | Constraints | Description
w2_1099_box_type_KEY | int (4) | NOT NULL | Primary key
w2_1099_type_KEY | int (4) | NOT NULL | Foreign key to the 1099 form the box can be found on
box_number | nvarchar (6) | NOT NULL | The box number
description | varchar (125) | NOT NULL | The box description
is_active | bit (1) | NOT NULL | Is this box type is active or has it become obsolete. If it is obsolete it can no longer be used moving forward, but it can still be associated to existing data.
sequence_number | int (4) | NOT NULL | The sequence number used to determine the order by w2 1099 types.

Primary key
Name | Columns | Description
PK_W2_1099_Box_Type | w2_1099_box_type_KEY |
Unique constraints
Name | Columns | Description
UK_W2_1099_Box_Type$w2_1099_type_KEY$sequence_number | w2_1099_type_KEY, sequence_number |

Foreign keys
Name | Columns | Referenced table | Description
FK_W2_1099_Box_Type__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_CSA_1099_Item_Map_To_W2_1099_Box_Pair__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | CSA_1099_Item_Map_To_W2_1099_Box_Pair |
FK_CSA_1099_Item_Map_To_W2_1099_Box_Pair__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | CSA_1099_Item_Map_To_W2_1099_Box_Pair |
FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | Spreadsheet_Import_1099_Box_Combination |
FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | Spreadsheet_Import_1099_Box_Combination |
FK_Payable_Transaction_Template_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | Payable_Transaction_Template_Distribution |
FK_Payable_Transaction_Template_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | Payable_Transaction_Template_Distribution |
FK_Form_1099_Print_Threshold_Override__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | Form_1099_Print_Threshold_Override |
FK_Form_1099_Print_Threshold_Override__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | Form_1099_Print_Threshold_Override |
FK_Vendor_1099_Box_Setup__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | Vendor_1099_Box_Setup |
FK_Vendor_1099_Box_Setup__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | Vendor_1099_Box_Setup |
FK_Bank_Transaction_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | Bank_Transaction_Distribution |
FK_Bank_Transaction_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | Bank_Transaction_Distribution |
FK_Bank_Transaction_Template_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | Bank_Transaction_Template_Distribution |
FK_Bank_Transaction_Template_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | Bank_Transaction_Template_Distribution |
FK_Bank_Feeds_Retrieved_Transaction_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | Bank_Feeds_Retrieved_Transaction_Distribution |
FK_Bank_Feeds_Retrieved_Transaction_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | Bank_Feeds_Retrieved_Transaction_Distribution |
FK_Payable_Transaction_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | Payable_Transaction_Distribution |
FK_Payable_Transaction_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | Payable_Transaction_Distribution |