Table: dbo.Vendor_Agent
Columns
Name | Type | Constraints | Description
vendor_KEY | int (4) | NOT NULL | Primary key for this table that references a vendor
vendor_agent_payment_schedule_KEY | int (4) |  | Payment schedule
include_payment_coupon_when_check_is_printed | bit (1) | NOT NULL | Include payment coupon when check is printed for vendor?
coupon_required_if_no_payment_due | bit (1) | NOT NULL | Is a payment coupon required even if no payment is due for vendor?
tax_agent_payment_address_type_KEY | int (4) | NOT NULL | Payment address type to use for this vendor agent; default is Federal
state_tax_agent_authorization_number | nvarchar (34) | NOT NULL | An authorization number used by various state tax vendors.
withholding_id | nvarchar (40) | NOT NULL | The withholding id to use for the current vendor agent.
use_whole_dollar_rounding | bit (1) | NOT NULL | Flag to indicate if amounts are rounded to whole dollars
do_not_calculate_missouri_discount | bit (1) | NOT NULL | Does this user want to calculate the missouri discount?
coupon_not_accepted_for_zero_payment | bit (1) | NOT NULL | Flag to show that the vendor requires a zero payment but a coupon cannot be used.
do_not_create_zero_liabilities | bit (1) | NOT NULL | Flag which denotes if zero liabilities should ever be created for this vendor.
deposit_due_within_KEY | tinyint (1) |  | Hold the information on whether deposit are due within three or five banking days.
promptax_participant | bit (1) |  | The PrompTax participant option will indicate to the program that the client is signed up and participating in PrompTax with the state
exclude_from_impound_funding_processing | bit (1) | NOT NULL | Exclude vendor agent from impound funding processing?

Primary key
Name | Columns | Description
PK_Vendor_Agent$vendor_KEY | vendor_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor_Agent__Tax_Agent_Payment_Address_Type__tax_agent_payment_address_type_KEY | tax_agent_payment_address_type_KEY | Tax_Agent_Payment_Address_Type (tax_agent_payment_address_type_KEY) |
FK_Vendor_Agent__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Vendor_Agent__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEY | vendor_agent_payment_schedule_KEY | Vendor_Agent_Payment_Schedule (vendor_agent_payment_schedule_KEY) |
FK_Vendor_Agent__Deposit_Due_Within__deposit_due_within_KEY | deposit_due_within_KEY | Deposit_Due_Within (deposit_due_within_KEY) |