Table: dbo.W2_1099_User_Preference | |||
Table used to store user preferences for W-2s and 1099s | |||
Columns | |||
Name | Type | Constraints | Description |
user_preference_KEY | int (4) | NOT NULL | |
w2_employee_sort_type_KEY | int (4) | NOT NULL | The order the employees w-2s are printed |
vendor_1099_sort_type_KEY | int (4) | NOT NULL | The order the 1099s are printed. |
form_1098_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1098 to print. |
form_1098_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099A_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099A to print. |
form_1099A_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099B_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099B to print. |
form_1099B_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099Div_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Div to print. |
form_1099Div_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099G_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099G to print. |
form_1099G_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099Int_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Int to print. |
form_1099Int_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099Misc_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Misc to print. |
form_1099Misc_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099Oid_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Oid to print. |
form_1099Oid_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099Patr_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Patr to print. |
form_1099Patr_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099R_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099R to print. |
form_1099R_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099S_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099S to print. |
form_1099S_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099Sa_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Sa to print. |
form_1099Sa_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_5498_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 5498 to print. |
form_5498_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_5498Sa_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 5498Sa to print. |
form_5498Sa_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
w2_copy_a_w3__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all W-2 Copy A/W-3 forms |
w2_employee_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all W-2 Employee copy forms |
w2__w2_1099_ordering_worksheet_client_option_KEY | int (4) | NOT NULL | This is how the client information will be displayed on the W-2 ordering worksheet. It will be one if no client detail should be displayed, two for the client list, and three for the client detail. |
form_1099__w2_1099_ordering_worksheet_client_option_KEY | int (4) | NOT NULL | This is how the client information will be displayed on the 1099 ordering worksheet. It will be one if no client detail should be displayed, two for the client list, and three for the client detail. |
w2_copy_a_client_copy_type_KEY | int (4) | NOT NULL | Key to the W2_Copy_A_Client_Copy_Type table for the client copy type to use for the W-2 Copy A. |
w3_client_copy_type_KEY | int (4) | NOT NULL | Key to the W3_Client_Copy_Type table for the client copy type to use for the W-3. |
form_W2G_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_W2G_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the W-2G for it to print. |
form_1098_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098 Copy A/1096 forms |
form_1098_recipient_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098 Recipient copy forms |
form_1099_a_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-A Copy A/1096 forms |
form_1099_b_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-B Copy A/1096 forms |
form_1099_div_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-DIV Copy A/1096 forms |
form_1099_g_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-G Copy A/1096 forms |
form_1099_int_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-INT Copy A/1096 forms |
form_1099_int_recipient_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-INT Recipient copy forms |
form_1099_misc_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-MISC Copy A/1096 forms |
form_1099_misc_recipient_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-MISC Recipient copy forms |
form_1099_oid_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-OID Copy A/1096 forms |
form_1099_patr_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-PATR Copy A/1096 forms |
form_1099_r_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-R Copy A/1096 forms |
form_1099_s_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-S Copy A/1096 forms |
form_1099_sa_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-SA Copy A/1096 forms |
form_5498_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 5498 Copy A/1096 forms |
form_5498_sa_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 5498-SA Copy A/1096 forms |
form_w2g_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all W-2G Copy A/1096 forms |
push_w2s_to_employee_self_service | bit (1) | NOT NULL | Whether or not W-2s should be pushed to ESS during the print run. |
form_1099_copy_a_client_copy_type_KEY | int (4) | NOT NULL | Key to the Form_1099_Copy_A_Client_Copy_Type table for the client copy type to use for the 1099 Copy A. |
form_1096_client_copy_type_KEY | int (4) | NOT NULL | Key to the Form_1096_Client_Copy_Type table for the client copy type to use for the 1096. |
form_1099Misc_send_to_employee_self_service | bit (1) | NOT NULL | Override flag for sending independent contractor 1099MISC forms to ESS. |
use_W3_as_separator_page | bit (1) | NOT NULL | Flag which indicates if the separator page used when printing W2s should be a W3 copy instead of the standard separator page. |
use_1096_as_separator_page | bit (1) | NOT NULL | Flag which indicates if the separator page used when printing 1099s should be a 1096 copy instead of the standard separator page. |
exclude_2D_barcode | bit (1) | NOT NULL | Flag which indicates if the 2D barcode should be excluded when printing W2s and W3s. |
w2_separator_page_watermark_indicator | bit (1) | NOT NULL | Indicator on whether a watermark should appear on the separator page default value 0 (false) |
w2_separator_page_watermark_text | nvarchar (100) | NOT NULL | Text of the watermark that will appear on the separator page |
form_1099_separator_page_watermark_indicator | bit (1) | NOT NULL | Indicator on whether a watermark should appear on the separator page default value 0 (false) |
form_1099_separator_page_watermark_text | nvarchar (100) | NOT NULL | Text of the watermark that will appear on the separator page |
hide_1099_copy_a | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy A when processing 1099s. |
hide_1099_copy_b | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy B when processing 1099s. |
hide_1099_copy_c | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy C when processing 1099s. |
hide_1099_copy_d | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy D when processing 1099s. |
hide_1099_copy_1 | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy 1 when processing 1099s. |
hide_1099_copy_2 | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy 2 when processing 1099s. |
hide_1099_copy_b_2 | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy B/2 when processing 1099s. |
hide_1099_1096 | bit (1) | NOT NULL | A bool flag to indicate whether to hide 1096 when processing 1099s. |
form_1098E_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1098E to print. |
form_1098E_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1098_E_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098-E Copy A/1096 forms. |
form_1098C_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1098C to print. |
form_1098C_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1098C_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098-C Copy A/1096 forms. |
form_1099C_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099C to print |
form_1099C_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1099_c_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-C Copy A/1096 forms. |
form_1098T_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1098-T to print |
form_1098T_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored. |
form_1098_t_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098-T Copy A/1096 forms. |
vendor_1099_recipient_filter_type_KEY | tinyint (1) | NOT NULL | The selection to use for vendor 1099 recipient type. |
push_w2s_to_workforce_hub | bit (1) | NOT NULL | Whether or not W-2s should be pushed to Workforce Hub during the print run. |
form_1099Misc_send_to_workforce_hub | bit (1) | NOT NULL | Override flag for sending independent contractor 1099MISC forms to Workforce Hub. |
form_1099Nec_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099-NEC to print |
form_1099Nec_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored |
form_1099_nec_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-NEC Copy A forms. |
form_1099_nec_recipient_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-NEC Recipient copy forms. |
form_1099Nec_send_to_employee_self_service | bit (1) | NOT NULL | Override flag for sending independent contractor 1099-NEC forms to ESS. |
form_1099Nec_send_to_workforce_hub | bit (1) | NOT NULL | Override flag for sending independent contractor 1099-NEC forms to Workforce Hub. |
Primary key | |||
Name | Columns | Description | |
PK_W2_1099_User_Preference$user_preference_KEY | user_preference_KEY |