Table: dbo.Client_Tax_Item
Columns
Name | Type | Constraints | Description
client_tax_item_KEY | int (4) | NOT NULL | Primary key for this table
description | nvarchar (200) | NOT NULL | Description of Client_Tax_Item record.
description_override | nvarchar (200) | NOT NULL | Description override
client_tax_item_type_KEY | int (4) | NOT NULL | Reference to client tax item type
tax_jurisdiction_KEY | int (4) | NOT NULL | Reference to tax jurisdiction
tax_calculation_status_KEY | nvarchar (38) | NOT NULL | Reference to tax calculation status
ste_tax_code | nvarchar (70) | NOT NULL | Identifier generated by the Symmetry Tax Engine; used by the tax engine when calculating this tax item. If this needs updating please check Contact_Address_Payroll_Information.school_district_code and Contact_Address_Payroll_Information.municipality_code for similar changes.
vendor_KEY | int (4) |  | Reference to vendor
liability__gl_account_KEY | int (4) |  | Key to the gl_account table for liability account.
expense__gl_account_KEY | int (4) |  | Key to the gl_account table for expense account.
has_nexus | bit (1) | NOT NULL | Whether or not the client has nexus for this tax item
vendor_agent_payment_schedule_KEY | int (4) |  | The deposit frequency of a tax item. If this is null, then we will just use the deposit frequency of the tax item's associated vendor agent.
tax_rate_override | decimal (5, 4) |  | The rate to use for the given client tax item rather than using Symmetry's rate.["BR"] This will be null if Symmetry's rate should be used.
w2_box_14_description | nvarchar (20) | NOT NULL | The description for the W2 Box 14 that will hold amounts for this tax item
denormalized__ste_state_code_KEY | nvarchar (4) |  | First two characters of ste_tax_code. Foreign key to Ste_State_Code ste_state_code_KEY column. Needed so we can efficiently join Client_Tax_Item with Ste_State_Code. Using Substring on ste_tax_code in order to join to Ste_State_Code confuses the optimizer. Prefixing with denormalized so if someo
sequence_number | int (4) | NOT NULL | THIS FIELD IS A COMPUTED COLUMN. The sequence number is computed based on the tax type, and it defines the order which the tax item should be presented. Its correctness relies on the symmetry tax codes consisting of multiple fields separated by hyphens where only one of the fields contains alphabetic values. This cannot be marked as persisted since that causes an exception when the script is run. It was last updated in 3004.65 for deferred social security.

Primary key
Name | Columns | Description
PK_Client_Tax_Item | client_tax_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Tax_Item__Ste_State_Code__denormalized__ste_state_code_KEY | denormalized__ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Client_Tax_Item__Client_Tax_Item_Type__client_tax_item_type_KEY | client_tax_item_type_KEY | Client_Tax_Item_Type (client_tax_item_type_KEY) |
FK_Client_Tax_Item__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_Tax_Item__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_Tax_Item__Tax_Calculation_Status__tax_calculation_status_KEY | tax_calculation_status_KEY | Tax_Calculation_Status (tax_calculation_status_KEY) |
FK_Client_Tax_Item__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Client_Tax_Item__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Client_Tax_Item__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEY | vendor_agent_payment_schedule_KEY | Vendor_Agent_Payment_Schedule (vendor_agent_payment_schedule_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Import_Template_Column_Employee_Data__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Import_Template_Column_Employee_Data |
FK_Employee_Political_Subdivision_Code_Override__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Employee_Political_Subdivision_Code_Override |
FK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition |
FK_Import_Template_Column_Tax_Item_Data__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Import_Template_Column_Tax_Item_Data |
FK_Quick_Books_Payroll_Item_N_Client_Tax_Item__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Quick_Books_Payroll_Item_N_Client_Tax_Item |
FK_Employee_Tax_Item__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Employee_Tax_Item |
FK_Payroll_Check_Tax_Item__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Payroll_Check_Tax_Item |
FK_Payroll_Check_Tax_Item_Import__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Payroll_Check_Tax_Item_Import |
FK_Employee_Taxable_Wage_Adjustment_Tax_Selection__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Employee_Taxable_Wage_Adjustment_Tax_Selection |
FK_Shortfall_Transaction_N_Client_Tax_Item__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Shortfall_Transaction_N_Client_Tax_Item |
FK_Payable_Transaction__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Payable_Transaction |