Table: dbo.Vendor_Agent
Columns
NameTypeConstraintsDescription
vendor_KEYint (4)NOT NULLPrimary key for this table that references a vendor
vendor_agent_payment_schedule_KEYint (4)Payment schedule
include_payment_coupon_when_check_is_printedbit (1)NOT NULLInclude payment coupon when check is printed for vendor?
coupon_required_if_no_payment_duebit (1)NOT NULLIs a payment coupon required even if no payment is due for vendor?
tax_agent_payment_address_type_KEYint (4)NOT NULLPayment address type to use for this vendor agent; default is Federal
state_tax_agent_authorization_numbernvarchar (34)NOT NULLAn authorization number used by various state tax vendors.
withholding_idnvarchar (40)NOT NULLThe withholding id to use for the current vendor agent.
use_whole_dollar_roundingbit (1)NOT NULLFlag to indicate if amounts are rounded to whole dollars
do_not_calculate_missouri_discountbit (1)NOT NULLDoes this user want to calculate the missouri discount?
coupon_not_accepted_for_zero_paymentbit (1)NOT NULLFlag to show that the vendor requires a zero payment but a coupon cannot be used.
do_not_create_zero_liabilitiesbit (1)NOT NULLFlag which denotes if zero liabilities should ever be created for this vendor.
deposit_due_within_KEYtinyint (1)Hold the information on whether deposit are due within three or five banking days.
promptax_participantbit (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_processingbit (1)NOT NULLExclude vendor agent from impound funding processing?
Primary key
NameColumnsDescription
PK_Vendor_Agent$vendor_KEYvendor_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_Agent__Tax_Agent_Payment_Address_Type__tax_agent_payment_address_type_KEYtax_agent_payment_address_type_KEYTax_Agent_Payment_Address_Type (tax_agent_payment_address_type_KEY)
FK_Vendor_Agent__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Vendor_Agent__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEYvendor_agent_payment_schedule_KEYVendor_Agent_Payment_Schedule (vendor_agent_payment_schedule_KEY)
FK_Vendor_Agent__Deposit_Due_Within__deposit_due_within_KEYdeposit_due_within_KEYDeposit_Due_Within (deposit_due_within_KEY)

Schema diagram