tax_jurisdiction_KEY | int (4) | NOT NULL | Reference to parent tax jurisdiction |
withholding_id | nvarchar (40) | NOT NULL | Withholding identification number used by state |
suta_id | nvarchar (40) | NOT NULL | State unemployment tax identification number |
withholding_deposit_schedule_KEY | int (4) | | DANGER!!! Not what it seems! In some cases foreign key to the Withholding_Deposit_Schedule table, but in others, the value is actually the primary surrogate key into the Vendor_Agent_Payment_Schedule table and is a vendor_agent_payment_schedule_KEY, which works only because the former table has nearly a superset of valid keys from the latter. Here be dragons, they are hungry, and you are coated in ketchup. |
has_nexus | bit (1) | NOT NULL | Flag to indicate if the client has a business presence in the state - used by the Symetry Tax Engine |
use_whole_dollar_rounding | bit (1) | NOT NULL | Flag to indicate if amounts are rounded to whole dollars |
workers_compensation_id | nvarchar (40) | NOT NULL | State Workers Compensation ID |
business_number | nvarchar (40) | NOT NULL | Formatted number assigned by the state to identify the business. Size and format are state dependant. Only applicable to certain states. |
default__vendor_KEY | int (4) | | This is the default vendor key to use when adding a new tax item that applies to the state. This is nullable since a default vendor KEY does not need to be selected for a state. |
employer_pays_full_wbf_assessment | bit (1) | NOT NULL | Flag to indicate if the employer pays the full Workers Benefit Fund assessment. |
w2_psd_code | nvarchar (18) | NOT NULL | Political subdivison code used for Pennsylvania W-2s. |
governmental_reimbursable_employer | bit (1) | NOT NULL | Flag to indicate if the employer is a governmental reimbursable employer. |
employer_pays_full_employee_pfml_share | bit (1) | NOT NULL | Flag to indicate if the employer pays the full employee PFML share. |