Table: dbo.Spreadsheet_Import_1099_Box_Combination
Table to store the mapping data information of 1099 forms for spreadsheet import.
Columns
NameTypeConstraintsDescription
spreadsheet_import_1099_box_combination_KEYint (4)NOT NULLKey which uniquely identify each row of the table.
client_KEYint (4)NOT NULLClient key for which we are importing the spreadsheet data.
descriptionnvarchar (318)NOT NULLDescription of the 1099 form provided in the spreadsheet.
is_interim_databit (1)NOT NULLWhen the user cancels the import process,the data mapped till that point has to be saved and presented to the user when he starts the import next time.For such mapping data we set the value of this column to true.
w2_1099_type_KEYint (4)1099 form key to which the 1099 form decription in the spreadsheet is mapped to,a null value indicates that it was mapped as Do not import.
first__w2_1099_box_type_KEYint (4)Box1 key assigned to the 1099 form when the user selects to mapping option to Add as is,a null value indicates that it was mapped as Do not import.
second__w2_1099_box_type_KEYint (4)Box2 key assigned to the 1099 form when the user selects to mapping option to Add as is,a null value indicates that it was mapped as Do not import.
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_1099_Box_Combinationspreadsheet_import_1099_box_combination_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_1099_Box_Combination$client_KEY$descriptionclient_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Spreadsheet_Import_1099_Box_Combination__Client__client_KEYclient_KEYClient (client_KEY)
FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)
FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)
FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYW2_1099_Type (w2_1099_type_KEY)

Schema diagram