Table: dbo.W2_1099_Box_Type
Lookup table of boxes available on 1099 forms
Columns
NameTypeConstraintsDescription
w2_1099_box_type_KEYint (4)NOT NULLPrimary key
w2_1099_type_KEYint (4)NOT NULLForeign key to the 1099 form the box can be found on
box_numbernvarchar (6)NOT NULLThe box number
descriptionvarchar (125)NOT NULLThe box description
is_activebit (1)NOT NULLIs 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_numberint (4)NOT NULLThe sequence number used to determine the order by w2 1099 types.
Primary key
NameColumnsDescription
PK_W2_1099_Box_Typew2_1099_box_type_KEY
Unique constraints
NameColumnsDescription
UK_W2_1099_Box_Type$w2_1099_type_KEY$sequence_numberw2_1099_type_KEY, sequence_number
Foreign keys
NameColumnsReferenced tableDescription
FK_W2_1099_Box_Type__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYW2_1099_Type (w2_1099_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_CSA_1099_Item_Map_To_W2_1099_Box_Pair__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYCSA_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_KEYsecond__w2_1099_box_type_KEYCSA_1099_Item_Map_To_W2_1099_Box_Pair
FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYSpreadsheet_Import_1099_Box_Combination
FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYSpreadsheet_Import_1099_Box_Combination
FK_Payable_Transaction_Template_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYPayable_Transaction_Template_Distribution
FK_Payable_Transaction_Template_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYPayable_Transaction_Template_Distribution
FK_Form_1099_Print_Threshold_Override__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYForm_1099_Print_Threshold_Override
FK_Form_1099_Print_Threshold_Override__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYForm_1099_Print_Threshold_Override
FK_Vendor_1099_Box_Setup__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYVendor_1099_Box_Setup
FK_Vendor_1099_Box_Setup__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYVendor_1099_Box_Setup
FK_Bank_Transaction_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYBank_Transaction_Distribution
FK_Bank_Transaction_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYBank_Transaction_Distribution
FK_Bank_Transaction_Template_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYBank_Transaction_Template_Distribution
FK_Bank_Transaction_Template_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYBank_Transaction_Template_Distribution
FK_Bank_Feeds_Retrieved_Transaction_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYBank_Feeds_Retrieved_Transaction_Distribution
FK_Bank_Feeds_Retrieved_Transaction_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYBank_Feeds_Retrieved_Transaction_Distribution
FK_Payable_Transaction_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYPayable_Transaction_Distribution
FK_Payable_Transaction_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYPayable_Transaction_Distribution

Schema diagram