Table: dbo.Form_1099_B_Box_1F_Code
Form 1099 B Box 1F codes.
Columns
NameTypeConstraintsDescription
form_1099_b_box_1f_code_KEYint (4)NOT NULLPrimary key column.
box_1f_codenvarchar (2)NOT NULLForm 1099 B Box 1F code.
descriptionnvarchar (50)NOT NULLForm 1099 B Box 1F code description.
starting_yearint (4)NOT NULLForm 1099 B Box 1F code starting year as CCYY.
ending_yearint (4)Form 1099 B Box 1F code ending year as CCYY. Null indicates no ending year.
Primary key
NameColumnsDescription
PK_Form_1099_B_Box_1F_Codeform_1099_b_box_1f_code_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__corrected_override_form_1099_b_box_1f_code_KEYcorrected_override_form_1099_b_box_1f_code_KEYForm_1099_B_Option
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__form_1099_b_box_1f_code_KEYform_1099_b_box_1f_code_KEYForm_1099_B_Option
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__original_override_form_1099_b_box_1f_code_KEYoriginal_override_form_1099_b_box_1f_code_KEYForm_1099_B_Option
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__override_form_1099_b_box_1f_code_KEYoverride_form_1099_b_box_1f_code_KEYForm_1099_B_Option

Schema diagram