Table: dbo.State_Definition | |||
Columns | |||
Name | Type | Constraints | Description |
state_definition_KEY | int (4) | NOT NULL | Primary key for this table |
ste_state_code_KEY | nvarchar (4) | NOT NULL | Symmetry state code |
has_withholding | bit (1) | NOT NULL | Flag to indicate if the state has tax withholding |
uses_seasonal | bit (1) | NOT NULL | Flag to indicate if the associated state uses a seasonal flag |
uses_nexus | bit (1) | NOT NULL | Flag to indicate if the associated state uses a nexus flag |
default_use_whole_dollar_rounding | bit (1) | NOT NULL | Default for the Tax_Jurisdiction_State_Setting use_whole_dollar_rounding field when a new row is created |
is_whole_dollar_rounding_editable | bit (1) | NOT NULL | Flag to indicate if the user can change the whole_dollar_rounding flag for the state |
uses_workers_compensation_id | bit (1) | NOT NULL | Flag to indicate if the associated state uses a workers_compensation_id |
uses_business_number | bit (1) | NOT NULL | Flag to indicate if the associated state uses a business_number |
uses_governmental_reimbursable_employer | bit (1) | NOT NULL | Flag to indicate if the state needs the governmental reimbursable employer checkbox displayed. |
Primary key | |||
Name | Columns | Description | |
PK_State_Definition | state_definition_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_State_Definition__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |