Table: dbo.Vendor_1099_Recipient_Filter_Type
This table defines all of the types of filtering available for a vendor 1099 recipient.
Columns
NameTypeConstraintsDescription
vendor_1099_recipient_filter_type_KEYtinyint (1)NOT NULLPrimary Key for this table.
descriptionnvarchar (100)NOT NULLThe description of the vendor 1099 recipient filter type.
Primary key
NameColumnsDescription
PK_Vendor_1099_Recipient_Filter_Typevendor_1099_recipient_filter_type_KEY
Unique constraints
NameColumnsDescription
UK_Vendor_1099_Recipient_Filter_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_W2_1099_User_Preference__Vendor_1099_Recipient_Filter_Type__vendor_1099_recipient_filter_type_KEYvendor_1099_recipient_filter_type_KEYW2_1099_User_Preference

Schema diagram