Table: dbo.Tax_Agent
Columns
Name | Type | Constraints | Description
tax_agent_KEY | int (4) | NOT NULL | Primary key for this table
tax_agent_name | nvarchar (100) | NOT NULL | Name of the tax agent
tax_agent_id | nvarchar (22) | NOT NULL | User-assigned name
payee_name | nvarchar (100) | NOT NULL | Name that appears on check when it is cut
ste_state_code_KEY | nvarchar (4) | NOT NULL | State of jurisdiction for tax agent
include_payment_coupon_with_payment | bit (1) | NOT NULL | Include payment coupon with payment for tax agent?
coupon_required_if_no_payment_is_due | bit (1) | NOT NULL | Is a payment coupon required even if no payment is due for tax agent?
consolidate_payments_for_funded_clients | bit (1) | NOT NULL | Consolidate payments for funded clients (i.e., where payments are made from impound checkbooks)?
contact_KEY | int (4) | NOT NULL |
tax_agent_id_sortable | nvarchar (96) | NOT NULL | A representation of the tax_agent_id column that sorts in natural order. A trigger keeps this field synchronized with the content of tax_agent_id.
default__vendor_payment_method_KEY | int (4) | NOT NULL | Foreign key to use as the default vendor payment method
direct_deposit_distribution_method_KEY | int (4) | NOT NULL | Direct deposit distribution method.
zero_payment_eft_accepted | bit (1) | NOT NULL | Does this tax agent accept zero payment EFTs
do_not_calculate_missouri_compensation_deduction | bit (1) | NOT NULL | Does this user want to calculate the missouri compensation deduction?
tax_agent_system_KEY | int (4) |  | For system added Tax Agents, this will be a key given to the Tax Agent by Thomson so that it can be found easily even if the tax agent name or id have changed. For non-system added tax agents, this will be null.
coupon_not_accepted_for_zero_payment | bit (1) | NOT NULL | Flag to show that the tax agent requires a zero payment but a coupon cannot be used.
system_provided_tax_agent_is_local | bit (1) | NOT NULL | A flag used to determine if a system provided tax agent is associated with local taxes or not.
include_payment_worksheet | bit (1) | NOT NULL | Flag used to determine if the payment worksheet should be included

Primary key
Name | Columns | Description
PK_Tax_Agent | tax_agent_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Agent$contact_KEY | contact_KEY |
UK_Tax_Agent$tax_agent_id$tax_agent_name | tax_agent_id, tax_agent_name |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Agent__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) |
FK_Tax_Agent__Direct_Deposit_Distribution_Method__direct_deposit_distribution_method_KEY | direct_deposit_distribution_method_KEY | Direct_Deposit_Distribution_Method (direct_deposit_distribution_method_KEY) |
FK_Tax_Agent__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Tax_Agent__Vendor_Payment_Method__default__vendor_payment_method_KEY | default__vendor_payment_method_KEY | Vendor_Payment_Method (vendor_payment_method_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Agent_Locality_Tax_Uid__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent_Locality_Tax_Uid |
FK_Tax_Agent_Payment_Address__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent_Payment_Address |
FK_Tax_Agent_Ste_Location_Code__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent_Ste_Location_Code |
FK_Tax_Agent_Direct_Deposit_Allocation__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent_Direct_Deposit_Allocation |
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent_Direct_Deposit_Tax_Payment_Information |
FK_Print_Filing_Instruction__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Print_Filing_Instruction |
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent_N_Vendor_Agent_Payment_Schedule |
FK_Tax_Agent_Form_Filing_Address__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent_Form_Filing_Address |
FK_Magnetic_Media_File_N_Tax_Agent__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Magnetic_Media_File_N_Tax_Agent |
FK_Tax_Agent_N_Vendor_Agent__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent_N_Vendor_Agent |
FK_Employee_W2_Rendered_Document__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Employee_W2_Rendered_Document |