Table: dbo.Form_1099_R_Distribution_Code_Map | |||
Ties first distribution codes to the potential options for second distribution code | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_r_distribution_code_map_KEY | int (4) | NOT NULL | Primary key to the Form_1099_R_Distribution_Sub_Code table |
primary__form_1099_r_distribution_code_KEY | int (4) | NOT NULL | The code selected as first distribution code |
secondary__form_1099_r_distribution_code_KEY | int (4) | NOT NULL | The code available as an option for second distribution code |
Primary key | |||
Name | Columns | Description | |
PK_Form_1099_R_Distribution_Code_Map | form_1099_r_distribution_code_map_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Form_1099_R_Distribution_Code_Map$primary__form_1099_r_distribution_code_KEY$secondary__form_1099_r_distribution_code_KEY | primary__form_1099_r_distribution_code_KEY, secondary__form_1099_r_distribution_code_KEY |