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. |