Table: dbo.Tax_Agent_State_Local_Tax_Type_Code
Table for tax agent direct deposit state/local tax type codes.
Columns
Name | Type | Constraints | Description
tax_agent_state_local_tax_type_code_KEY | int (4) | NOT NULL | Primary key for this table.
tax_agent_n_vendor_agent_payment_schedule_KEY | int (4) | NOT NULL | Key to tax agent/payment schedule table record containing payment schedule and tax agent for this record.
special_case_tax_code | nvarchar (100) | NOT NULL | Special case tax type strings - may be a compliation. Normally blank.
tax_type_code | nvarchar (10) | NOT NULL | State/Local code for this relation.

Primary key
Name | Columns | Description
PK_Tax_Agent_State_Local_Tax_Type_Code | tax_agent_state_local_tax_type_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Agent_State_Local_Tax_Type_Code__Tax_Agent_N_Vendor_Agent_Payment_Schedule__tax_agent_n_vendor_agent_payment_schedule_KEY | tax_agent_n_vendor_agent_payment_schedule_KEY | Tax_Agent_N_Vendor_Agent_Payment_Schedule (tax_agent_n_vendor_agent_payment_schedule_KEY) |