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
Name | Type | Constraints | Description
csa_1099_item_map_to_w2_1099_box_pair_KEY | int (4) | NOT NULL | Primary key; associates between a CSA 1099 description and an ACS 1099 item
csa_1099_item_description | nvarchar (50) | NOT NULL | The 1099 item description in CSA
not_a_1099_item | bit (1) | NOT NULL | If true, means that the user declares this in erroneous; It should be ignored
first__w2_1099_box_type_KEY | int (4) |  | The foreign key to the first box the csa_1099_item_description is associated to
second__w2_1099_box_type_KEY | int (4) |  | The foreign key to the second box the csa_1099_item_description is associated to

Primary key
Name | Columns | Description
PK_CSA_1099_Item_Map_To_W2_1099_Box_Pair | csa_1099_item_map_to_w2_1099_box_pair_KEY |
Unique constraints
Name | Columns | Description
UK_CSA_1099_Item_Map_To_W2_1099_Box_Pair$csa_1099_item_description | csa_1099_item_description |

Foreign keys
Name | Columns | Referenced 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 | W2_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_KEY | second__w2_1099_box_type_KEY | W2_1099_Box_Type (w2_1099_box_type_KEY) |