Table: dbo.Client_Tax_Item
Columns
NameTypeConstraintsDescription
client_tax_item_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (200)NOT NULLDescription of Client_Tax_Item record.
description_overridenvarchar (200)NOT NULLDescription override
client_tax_item_type_KEYint (4)NOT NULLReference to client tax item type
tax_jurisdiction_KEYint (4)NOT NULLReference to tax jurisdiction
tax_calculation_status_KEYnvarchar (38)NOT NULLReference to tax calculation status
ste_tax_codenvarchar (70)NOT NULLIdentifier 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_KEYint (4)Reference to vendor
liability__gl_account_KEYint (4)Key to the gl_account table for liability account.
expense__gl_account_KEYint (4)Key to the gl_account table for expense account.
has_nexusbit (1)NOT NULLWhether or not the client has nexus for this tax item
vendor_agent_payment_schedule_KEYint (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_overridedecimal (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_descriptionnvarchar (20)NOT NULLThe description for the W2 Box 14 that will hold amounts for this tax item
denormalized__ste_state_code_KEYnvarchar (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_numberint (4)NOT NULLTHIS 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
NameColumnsDescription
PK_Client_Tax_Itemclient_tax_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Tax_Item__Ste_State_Code__denormalized__ste_state_code_KEYdenormalized__ste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Client_Tax_Item__Client_Tax_Item_Type__client_tax_item_type_KEYclient_tax_item_type_KEYClient_Tax_Item_Type (client_tax_item_type_KEY)
FK_Client_Tax_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_Tax_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_Tax_Item__Tax_Calculation_Status__tax_calculation_status_KEYtax_calculation_status_KEYTax_Calculation_Status (tax_calculation_status_KEY)
FK_Client_Tax_Item__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Client_Tax_Item__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Client_Tax_Item__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEYvendor_agent_payment_schedule_KEYVendor_Agent_Payment_Schedule (vendor_agent_payment_schedule_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_Employee_Data__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYImport_Template_Column_Employee_Data
FK_Employee_Political_Subdivision_Code_Override__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYEmployee_Political_Subdivision_Code_Override
FK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition
FK_Import_Template_Column_Tax_Item_Data__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYImport_Template_Column_Tax_Item_Data
FK_Quick_Books_Payroll_Item_N_Client_Tax_Item__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYQuick_Books_Payroll_Item_N_Client_Tax_Item
FK_Employee_Tax_Item__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYEmployee_Tax_Item
FK_Payroll_Check_Tax_Item__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYPayroll_Check_Tax_Item
FK_Payroll_Check_Tax_Item_Import__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYPayroll_Check_Tax_Item_Import
FK_Employee_Taxable_Wage_Adjustment_Tax_Selection__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYEmployee_Taxable_Wage_Adjustment_Tax_Selection
FK_Shortfall_Transaction_N_Client_Tax_Item__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYShortfall_Transaction_N_Client_Tax_Item
FK_Payable_Transaction__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYPayable_Transaction

Schema diagram