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 |