| 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 | ||