Table: dbo.CSA_1099_Item_Map_To_W2_1099_Box_Pair
Table that stores the CSA 1099 description and associates that with ACS 1099 items
Columns
NameTypeConstraintsDescription
csa_1099_item_map_to_w2_1099_box_pair_KEYint (4)NOT NULLPrimary key; associates between a CSA 1099 description and an ACS 1099 item
csa_1099_item_descriptionnvarchar (50)NOT NULLThe 1099 item description in CSA
not_a_1099_itembit (1)NOT NULLIf true, means that the user declares this in erroneous; It should be ignored
first__w2_1099_box_type_KEYint (4)The foreign key to the first box the csa_1099_item_description is associated to
second__w2_1099_box_type_KEYint (4)The foreign key to the second box the csa_1099_item_description is associated to
Primary key
NameColumnsDescription
PK_CSA_1099_Item_Map_To_W2_1099_Box_Paircsa_1099_item_map_to_w2_1099_box_pair_KEY
Unique constraints
NameColumnsDescription
UK_CSA_1099_Item_Map_To_W2_1099_Box_Pair$csa_1099_item_descriptioncsa_1099_item_description
Foreign keys
NameColumnsReferenced 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_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)
FK_CSA_1099_Item_Map_To_W2_1099_Box_Pair__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)

Schema diagram