Table: dbo.Form_1099_B_Form_8949_Code
Form 1099 B 8949 codes.
Columns
NameTypeConstraintsDescription
form_1099_b_form_8949_code_KEYint (4)NOT NULLPrimary key column.
form_8949_codenvarchar (2)NOT NULLForm 1099 B 8949 code.
descriptionnvarchar (600)NOT NULLForm 1099 B 8949 code description.
starting_yearint (4)NOT NULLForm 1099 B 8949 code starting year as CCYY.
ending_yearint (4)Form 1099 B 8949 code ending year as CCYY. Null indicates no ending year.
Primary key
NameColumnsDescription
PK_Form_1099_B_Form_8949_Codeform_1099_b_form_8949_code_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_1099_B_Option__Form_1099_B_Form_8949_Code__corrected_override_form_1099_b_form_8949_code_KEYcorrected_override_form_1099_b_form_8949_code_KEYForm_1099_B_Option
FK_Form_1099_B_Option__Form_1099_B_Form_8949_Code__form_1099_b_form_8949_code_KEYform_1099_b_form_8949_code_KEYForm_1099_B_Option
FK_Form_1099_B_Option__Form_1099_B_Form_8949_Code__original_override_form_1099_b_form_8949_code_KEYoriginal_override_form_1099_b_form_8949_code_KEYForm_1099_B_Option
FK_Form_1099_B_Option__Form_1099_B_Form_8949_Code__override_form_1099_b_form_8949_code_KEYoverride_form_1099_b_form_8949_code_KEYForm_1099_B_Option

Schema diagram