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