Table: dbo.Tax_Agent_Direct_Deposit_Tax_Payment_Information
Table for tax agent direct deposit tax payment information.
Columns
Name | Type | Constraints | Description
tax_agent_KEY | int (4) | NOT NULL | Primary key for this table that references a tax agent
taxpayer_id_number_selection_type_KEY | int (4) | NOT NULL | Key to taxpayer ID selection to use.
taxpayer_id_number_other | nvarchar (30) | NOT NULL | Taxpayer ID to use if selection is set to Other.
optional_taxpayer_verification_code | nvarchar (30) | NOT NULL | Optional taxpayer verification string.
code_1__state_local_amount_code_type_KEY | int (4) | NOT NULL | Key to state/local amount type code #1
code_2__state_local_amount_code_type_KEY | int (4) | NOT NULL | Key to state/local amount type code #2
code_3__state_local_amount_code_type_KEY | int (4) | NOT NULL | Key to state/local amount type code #3
tax_period_frequency_KEY | int (4) | NOT NULL | Key to tax period frequency

Primary key
Name | Columns | Description
PK_Tax_Agent_Direct_Deposit_Tax_Payment_Information$tax_agent_KEY | tax_agent_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__State_Local_Amount_Code_Type__code_1__state_local_amount_code_type_KEY | code_1__state_local_amount_code_type_KEY | State_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_KEY | code_2__state_local_amount_code_type_KEY | State_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_KEY | code_3__state_local_amount_code_type_KEY | State_Local_Amount_Code_Type (state_local_amount_code_type_KEY) |
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent (tax_agent_KEY) |
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Tax_Period_Frequency__tax_period_frequency_KEY | tax_period_frequency_KEY | Tax_Period_Frequency (tax_period_frequency_KEY) |
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Taxpayer_Id_Number_Selection_Type__taxpayer_id_number_selection_type_KEY | taxpayer_id_number_selection_type_KEY | Taxpayer_Id_Number_Selection_Type (taxpayer_id_number_selection_type_KEY) |