Stores local withholding conversion settings, both the source information and what it will be mapped to in SBPR. |
conversion_wizard_local_withholding_KEY | int (4) | NOT NULL | The primary key for this table. |
source_tax_description | nvarchar (50) | NOT NULL | Description of a tax currently being used by a third party or CSA that will need to be mapped. |
source_state_abbreviation | nvarchar (4) | NOT NULL | State abbreviation for the source tax information. |
source_tax_type | nvarchar (50) | NOT NULL | The tax type associated with the source information. |
city | nvarchar (60) | NOT NULL | The city to be used for the local tax. |
postal_code | nvarchar (20) | NOT NULL | The zip code to be used to generate the lcoal tax. |
county | nvarchar (50) | NOT NULL | The county to be used in local tax generation. |
school_district_description | nvarchar (100) | NOT NULL | The school district description to be used in local tax generation. |
municipality_description | nvarchar (100) | NOT NULL | The municipality description to be used in local tax generation. |
employee_tax_description | nvarchar (200) | NOT NULL | The description of the local withholding tax selected for use in SBPR. This is the tax description from the Symmetry calc engine. |
employer_tax_description | nvarchar (200) | NOT NULL | The description of the local withholding employer tax selected for use in SBPR. This is the tax description from the Symmetry calc engine. |
employee_tax_ste_tax_uid | nvarchar (60) | NOT NULL | The employee tax that the user decided to map the source information to. Stores the tax uid provided by Symmetry. |
employer_tax_ste_tax_uid | nvarchar (60) | NOT NULL | The employer tax that the user decided to map the source information to. Stores the tax uid provided by Symmetry. |