Table: dbo.Vendor_1099_Sort_Type
Table used to store the ways to sort vendors on 1099s.
Columns
NameTypeConstraintsDescription
vendor_1099_sort_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLDescription of the sort type.
Primary key
NameColumnsDescription
PK_Vendor_1099_Sort_Typevendor_1099_sort_type_KEY
Unique constraints
NameColumnsDescription
UK_Vendor_1099_Sort_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_W2_1099_User_Preference__Vendor_1099_Sort_Type__vendor_1099_sort_type_KEYvendor_1099_sort_type_KEYW2_1099_User_Preference

Schema diagram