| 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 | ||