Table: dbo.Tax_Agent_State_Local_Tax_Type_Code
Table for tax agent direct deposit state/local tax type codes.
Columns
NameTypeConstraintsDescription
tax_agent_state_local_tax_type_code_KEYint (4)NOT NULLPrimary key for this table.
tax_agent_n_vendor_agent_payment_schedule_KEYint (4)NOT NULLKey to tax agent/payment schedule table record containing payment schedule and tax agent for this record.
special_case_tax_codenvarchar (100)NOT NULLSpecial case tax type strings - may be a compliation. Normally blank.
tax_type_codenvarchar (10)NOT NULLState/Local code for this relation.
Primary key
NameColumnsDescription
PK_Tax_Agent_State_Local_Tax_Type_Codetax_agent_state_local_tax_type_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Agent_State_Local_Tax_Type_Code__Tax_Agent_N_Vendor_Agent_Payment_Schedule__tax_agent_n_vendor_agent_payment_schedule_KEYtax_agent_n_vendor_agent_payment_schedule_KEYTax_Agent_N_Vendor_Agent_Payment_Schedule (tax_agent_n_vendor_agent_payment_schedule_KEY)

Schema diagram