Table: dbo.Tax_Agent
Columns
NameTypeConstraintsDescription
tax_agent_KEYint (4)NOT NULLPrimary key for this table
tax_agent_namenvarchar (100)NOT NULLName of the tax agent
tax_agent_idnvarchar (22)NOT NULLUser-assigned name
payee_namenvarchar (100)NOT NULLName that appears on check when it is cut
ste_state_code_KEYnvarchar (4)NOT NULLState of jurisdiction for tax agent
include_payment_coupon_with_paymentbit (1)NOT NULLInclude payment coupon with payment for tax agent?
coupon_required_if_no_payment_is_duebit (1)NOT NULLIs a payment coupon required even if no payment is due for tax agent?
consolidate_payments_for_funded_clientsbit (1)NOT NULLConsolidate payments for funded clients (i.e., where payments are made from impound checkbooks)?
contact_KEYint (4)NOT NULL
tax_agent_id_sortablenvarchar (96)NOT NULLA 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_KEYint (4)NOT NULLForeign key to use as the default vendor payment method
direct_deposit_distribution_method_KEYint (4)NOT NULLDirect deposit distribution method.
zero_payment_eft_acceptedbit (1)NOT NULLDoes this tax agent accept zero payment EFTs
do_not_calculate_missouri_compensation_deductionbit (1)NOT NULLDoes this user want to calculate the missouri compensation deduction?
tax_agent_system_KEYint (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_paymentbit (1)NOT NULLFlag to show that the tax agent requires a zero payment but a coupon cannot be used.
system_provided_tax_agent_is_localbit (1)NOT NULLA flag used to determine if a system provided tax agent is associated with local taxes or not.
include_payment_worksheetbit (1)NOT NULLFlag used to determine if the payment worksheet should be included
Primary key
NameColumnsDescription
PK_Tax_Agenttax_agent_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Agent$contact_KEYcontact_KEY
UK_Tax_Agent$tax_agent_id$tax_agent_nametax_agent_id, tax_agent_name
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Agent__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Tax_Agent__Direct_Deposit_Distribution_Method__direct_deposit_distribution_method_KEYdirect_deposit_distribution_method_KEYDirect_Deposit_Distribution_Method (direct_deposit_distribution_method_KEY)
FK_Tax_Agent__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Tax_Agent__Vendor_Payment_Method__default__vendor_payment_method_KEYdefault__vendor_payment_method_KEYVendor_Payment_Method (vendor_payment_method_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Agent_Locality_Tax_Uid__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent_Locality_Tax_Uid
FK_Tax_Agent_Ste_Location_Code__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent_Ste_Location_Code
FK_Tax_Agent_Payment_Address__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent_Payment_Address
FK_Tax_Agent_Direct_Deposit_Allocation__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent_Direct_Deposit_Allocation
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent_Direct_Deposit_Tax_Payment_Information
FK_Print_Filing_Instruction__Tax_Agent__tax_agent_KEYtax_agent_KEYPrint_Filing_Instruction
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent_N_Vendor_Agent_Payment_Schedule
FK_Tax_Agent_Form_Filing_Address__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent_Form_Filing_Address
FK_Magnetic_Media_File_N_Tax_Agent__Tax_Agent__tax_agent_KEYtax_agent_KEYMagnetic_Media_File_N_Tax_Agent
FK_Tax_Agent_N_Vendor_Agent__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent_N_Vendor_Agent
FK_Employee_W2_Rendered_Document__Tax_Agent__tax_agent_KEYtax_agent_KEYEmployee_W2_Rendered_Document

Schema diagram