Table: dbo.Tax_Agent_Direct_Deposit_Tax_Payment_Information
Table for tax agent direct deposit tax payment information.
Columns
NameTypeConstraintsDescription
tax_agent_KEYint (4)NOT NULLPrimary key for this table that references a tax agent
taxpayer_id_number_selection_type_KEYint (4)NOT NULLKey to taxpayer ID selection to use.
taxpayer_id_number_othernvarchar (30)NOT NULLTaxpayer ID to use if selection is set to Other.
optional_taxpayer_verification_codenvarchar (30)NOT NULLOptional taxpayer verification string.
code_1__state_local_amount_code_type_KEYint (4)NOT NULLKey to state/local amount type code #1
code_2__state_local_amount_code_type_KEYint (4)NOT NULLKey to state/local amount type code #2
code_3__state_local_amount_code_type_KEYint (4)NOT NULLKey to state/local amount type code #3
tax_period_frequency_KEYint (4)NOT NULLKey to tax period frequency
Primary key
NameColumnsDescription
PK_Tax_Agent_Direct_Deposit_Tax_Payment_Information$tax_agent_KEYtax_agent_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__State_Local_Amount_Code_Type__code_1__state_local_amount_code_type_KEYcode_1__state_local_amount_code_type_KEYState_Local_Amount_Code_Type (state_local_amount_code_type_KEY)
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__State_Local_Amount_Code_Type__code_2__state_local_amount_code_type_KEYcode_2__state_local_amount_code_type_KEYState_Local_Amount_Code_Type (state_local_amount_code_type_KEY)
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__State_Local_Amount_Code_Type__code_3__state_local_amount_code_type_KEYcode_3__state_local_amount_code_type_KEYState_Local_Amount_Code_Type (state_local_amount_code_type_KEY)
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent (tax_agent_KEY)
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Tax_Period_Frequency__tax_period_frequency_KEYtax_period_frequency_KEYTax_Period_Frequency (tax_period_frequency_KEY)
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Taxpayer_Id_Number_Selection_Type__taxpayer_id_number_selection_type_KEYtaxpayer_id_number_selection_type_KEYTaxpayer_Id_Number_Selection_Type (taxpayer_id_number_selection_type_KEY)

Schema diagram