Table: dbo.Form_5498_Option | |||
Detailed options for 5498 form | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table |
is_ira | bit (1) | NOT NULL | Form 1099-SA option: IRA |
is_sep | bit (1) | NOT NULL | Form 1099-SA option: SEP |
is_simple | bit (1) | NOT NULL | Form 1099-SA option: SIMPLE |
is_roth_ira | bit (1) | NOT NULL | Form 1099-SA option: Roth IRA |
is_required_minimum_distribution_for_current_year | bit (1) | NOT NULL | Form 1099-SA option: required minimum distribution for current year |
is_ira_override | bit (1) | The override for whether the recipient's amount applies to an IRA. | |
is_sep_override | bit (1) | The override for whether the recipient's amount applies to SEP. | |
is_simple_override | bit (1) | The override for whether the recipient's amount applies to SIMPLE. | |
is_roth_ira_override | bit (1) | The override for whether the recipient's amount applies to a Roth IRA. | |
is_required_minimum_distribution_for_current_year_override | bit (1) | The override for whether the recipient's amount requires the minimum distribution. | |
required_minimum_distribution_date | smalldatetime (4) | The date of the required minimum distribution, or null if there is none. | |
required_minimum_distribution_date_override | smalldatetime (4) | The override for the date of the required minimum distribution, or null if there is no override. | |
postponed_contribution_year | int (4) | The year of the postponed contribution, or null if there is none. | |
postponed_contribution_year_override | int (4) | The override for the year of the postponed contribution, or null if there is no override. | |
form_5498_repayment_code_KEY | int (4) | The key to the repayment code, or null if there is none. | |
override__form_5498_repayment_code_KEY | int (4) | The override for the key to the repayment code, or null if there is no override. | |
form_5498_other_contribution_code_KEY | int (4) | The key to the other contributions code, or null if there is none. | |
override__form_5498_other_contribution_code_KEY | int (4) | The override for the key to the other contributions code, or null if there is no override. | |
is_ira_original_override | bit (1) | Original override of whether is ira. | |
is_sep_original_override | bit (1) | Original override of whether is sep. | |
is_simple_original_override | bit (1) | Original override of whether is simple. | |
is_roth_ira_original_override | bit (1) | Original override of whether is roth ira. | |
is_required_minimum_distribution_for_current_year_original_override | bit (1) | Original override of whether is required minimum distribution for current year. | |
required_minimum_distribution_date_original_override | smalldatetime (4) | Original override of required minimum distribution date. | |
postponed_contribution_year_original_override | int (4) | Original override of postponed contribution year. | |
original_override__form_5498_repayment_code_KEY | int (4) | Original override of form 5498 repayment code. | |
original_override__form_5498_other_contribution_code_KEY | int (4) | Original override of form 5498 other contribution code. | |
is_ira_corrected_override | bit (1) | Corrected override of whether is ira. | |
is_sep_corrected_override | bit (1) | Corrected override of whether is sep. | |
is_simple_corrected_override | bit (1) | Corrected override of whether is simple. | |
is_roth_ira_corrected_override | bit (1) | Corrected override of whether is roth ira. | |
is_required_minimum_distribution_for_current_year_corrected_override | bit (1) | Corrected override of whether is required minimum distribution for current year. | |
required_minimum_distribution_date_corrected_override | smalldatetime (4) | Corrected override of required minimum distribution date. | |
postponed_contribution_year_corrected_override | int (4) | Corrected override of postponed contribution year. | |
corrected_override__form_5498_repayment_code_KEY | int (4) | Corrected override of form 5498 repayment code. | |
corrected_override__form_5498_other_contribution_code_KEY | int (4) | Corrected override of form 5498 other contribution code. | |
postponed_contribution_code | nvarchar (16) | Postponed contribution code. Null or empty string indicates no value. | |
postponed_contribution_code_override | nvarchar (16) | Override of the Postponed contribution code. Null indicates not overridden. | |
postponed_contribution_code_original_override | nvarchar (16) | Original override of the Postponed contribution code. Null indicates not overridden. | |
postponed_contribution_code_corrected_override | nvarchar (16) | Corrected override of the Postponed contribution code. Null indicates not overridden. | |
first__form_5498_fmv_code_KEY | int (4) | NOT NULL | Form 5498 first FMV code. |
second__form_5498_fmv_code_KEY | int (4) | NOT NULL | Form 5498 second FMV code. |
override_first__form_5498_fmv_code_KEY | int (4) | Form 5498 override first FMV code. Null indicates not overridden. | |
override_second__form_5498_fmv_code_KEY | int (4) | Form 5498 override second FMV code. Null indicates not overridden. | |
original_override_first__form_5498_fmv_code_KEY | int (4) | Form 5498 original override first FMV code. Null indicates not overridden. | |
original_override_second__form_5498_fmv_code_KEY | int (4) | Form 5498 original override second FMV code. Null indicates not overridden. | |
corrected_override_first__form_5498_fmv_code_KEY | int (4) | Form 5498 corrected override first FMV code. Null indicates not overridden. | |
corrected_override_second__form_5498_fmv_code_KEY | int (4) | Form 5498 corrected override second FMV code. Null indicates not overridden. |
Primary key | |||
Name | Columns | Description | |
PK_Form_5498_Option$form_1099_KEY | form_1099_KEY |