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 |