Table: dbo.W2_1099_Ordering_Worksheet_Client_Option
This table enumerates the different types of client options available when previewing the W-2 and 1099 ordering worksheets.
Columns
NameTypeConstraintsDescription
w2_1099_ordering_worksheet_client_option_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (50)NOT NULLDescription of the client option.
Primary key
NameColumnsDescription
PK_W2_1099_Ordering_Worksheet_Client_Optionw2_1099_ordering_worksheet_client_option_KEY
Unique constraints
NameColumnsDescription
UK_W2_1099_Ordering_Worksheet_Client_Option$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_W2_1099_User_Preference__W2_1099_Ordering_Worksheet_Client_Option__form_1099__w2_1099_ordering_worksheet_client_option_KEYform_1099__w2_1099_ordering_worksheet_client_option_KEYW2_1099_User_Preference
FK_W2_1099_User_Preference__W2_1099_Ordering_Worksheet_Client_Option__w2__w2_1099_ordering_worksheet_client_option_KEYw2__w2_1099_ordering_worksheet_client_option_KEYW2_1099_User_Preference

Schema diagram