Table: dbo.Employer_Jurisdiction_Payroll_Tax_Information | |||
Columns | |||
Name | Type | Constraints | Description |
employer_jurisdiction_payroll_tax_information_KEY | int (4) | NOT NULL | Unique primary key of Employer_Jurisdiction_Payroll_Tax_Information |
tax_jurisdiction_KEY | int (4) | NOT NULL | Foreign key to an entry in the Tax_Jurisdiction table |
fractions_of_cents_threshold | float (8) | NOT NULL | Numeric value that is used for a threshold in which the amount under the threshold is used as an adjustment on the Fed 941. |
overpayment_handling_option_KEY | int (4) | NOT NULL | Foreign key to an entry in the Overpayment_Handling_Option table that defines how tax return overpayment should be used. |
supplemental_information_xml | nvarchar (-1) | Field for storage of serialized non-standard jurisdiction data in xml format. | |
third_party_designee_signer__contact_KEY | int (4) | Foreign key to an entry in the contact table that is used to designate a contact signer for third party signer designee demographic information sections. | |
taxpayer_signer__contact_KEY | int (4) | Foreign key to an entry in the contact table that is used to designate a contact signer for taxpayer signature demographic information sections. | |
preparer_signer__contact_KEY | int (4) | Foreign key to an entry in the contact table that is used to designate a contact signer for preparer signature demographic information sections. | |
payment__contact_KEY | int (4) | Foreign key to contact table for payment. Contact that the government will contact if there is something wrong with the payment file. | |
w2_signature__contact_KEY | int (4) | Foreign key for w2 signature to contact table. Contact of person who signs w2. | |
w2_contact__contact_KEY | int (4) | Foreign key for w2 contact to contact table. Contact that the government will contact if there is something wrong with the w2. | |
signature_1099__contact_KEY | int (4) | Foreign key for signature 1099 to contact table. This is the person who signs the 1099. | |
contact_1099__contact_KEY | int (4) | Foreign key for contact 1099 to contact table. Contact that the government will contact if there is somewthing wrong with the 1099. | |
is_reporting_agent | bit (1) | NOT NULL | True if the reporting agent checkbox is marked in the client setup on the payroll taxes tab in the 94X additional information. |
taxpayer_signature__report_image_KEY | int (4) | Report image key for the tax form signature bit map image. | |
form1095c_signature__contact_KEY | int (4) | The signer of the Federal 1095-C form. | |
form1095c_contact__contact_KEY | int (4) | The contact person for the Federal 1095-C form. |
Primary key | |||
Name | Columns | Description | |
PK_Employer_Jurisdiction_Payroll_Tax_Information | employer_jurisdiction_payroll_tax_information_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Employer_Jurisdiction_Payroll_Tax_Information$tax_jurisdiction_KEY | tax_jurisdiction_KEY |