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 |