Table: dbo.Form_1099_Sa_Distribution_Code
Distribution codes for the 1099-Sa form, box 3
Columns
NameTypeConstraintsDescription
form_1099_sa_distribution_code_KEYint (4)NOT NULLPrimary key to the Form_1099_Sa_Distribution_Code table
tax_yearint (4)NOT NULLThe tax year that the code is avaialble in
distribution_codenvarchar (2)NOT NULLSingle character code entered into the 1099-SA form
descriptionnvarchar (256)NOT NULLDescription of the code entered into the 1099-SA form
Primary key
NameColumnsDescription
PK_Form_1099_Sa_Distribution_Codeform_1099_sa_distribution_code_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__corrected_override__form_1099_sa_distribution_code_KEYcorrected_override__form_1099_sa_distribution_code_KEYForm_1099_Sa_Option
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__form_1099_sa_distribution_code_KEYform_1099_sa_distribution_code_KEYForm_1099_Sa_Option
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__original_override__form_1099_sa_distribution_code_KEYoriginal_override__form_1099_sa_distribution_code_KEYForm_1099_Sa_Option
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__override__form_1099_sa_distribution_code_KEYoverride__form_1099_sa_distribution_code_KEYForm_1099_Sa_Option

Schema diagram