vendor_KEY | int (4) | NOT NULL | Primary key for this table |
client_KEY | int (4) | NOT NULL | Reference to client that has this vendor |
vendor_name | nvarchar (100) | NOT NULL | Name of the vendor |
vendor_id | nvarchar (22) | NOT NULL | User-assigned name |
ein_ssn | nvarchar (22) | NOT NULL | EIN/SSN (only used in certain types of vendors) |
payee_name | nvarchar (100) | NOT NULL | Name that appears on check when it is cut |
status | nvarchar (30) | NOT NULL | Status of vendor |
exclude_from_fee_calculations | bit (1) | NOT NULL | Do not charge fees to this vendor |
contact_KEY | int (4) | NOT NULL | Reference to contact |
default_payment__checkbook_KEY | int (4) | | Key of the bank account to use as default for payment |
default__vendor_payment_method_KEY | int (4) | NOT NULL | Foreign key to use as the default vendor payment method |
print_stub | bit (1) | NOT NULL | Flag indicating that a check stub should be printed when a payment method other than check or direct deposit is selected |
auto_consolidate_for_payment | bit (1) | NOT NULL | Flag indicating that all selected payments will be combined to produce only one payment |
auto_select_for_payment_when_due | bit (1) | NOT NULL | Flag indicating that liabilities should be automatically selected for payment based on a comparison of the system date to the due date minus any lead time |
lead_days | int (4) | NOT NULL | Number of lead days to use if the lead-days flag is true when comparing dates for the automatic selection for payment when due |
is_paycard_recipient | bit (1) | NOT NULL | Is this vendor a paycard recipient? |
direct_deposit_method_KEY | nvarchar (50) | NOT NULL | Method used for Direct Deposit |
direct_deposit_amount_percent | decimal (5, 2) | NOT NULL | Percentage or amount of pay to be distrubted using direct deposit. |
direct_deposit_distribution_method_KEY | int (4) | NOT NULL | Indicates method for calculating the direct deposit allocations. See CK_Vendor__direct_deposit_base_allocation_on comments for details. |
vendor_id_sortable | nvarchar (96) | NOT NULL | A representation of the vendor_id column that sorts in natural order. A trigger keeps this field synchronized with the content of vendor_id. |
date_tin_verified | smalldatetime (4) | | The date tin for this vendor was verified. |
description | nvarchar (100) | NOT NULL | Computed field to allow filtering on Vendor: should not be used otherwise |
inactive_reason | nvarchar (60) | NOT NULL | Reason this vendor became inactive |
date_inactive | smalldatetime (4) | | Date this vendor became inactive |
vendor_account_number | nvarchar (100) | NOT NULL | The account number for the vendor. |
current__vendor_type_KEY | int (4) | NOT NULL | |
default_payment__memo | nvarchar (480) | NOT NULL | The default payment memo placed on new bank transaction payments to this vendor. |
use_same_checkbook_as_paychecks | bit (1) | NOT NULL | This value only applies to tax agents and payroll agents. If this value is true, then payments created to pay this vendor's payroll liabilities and payroll tax liabilities should be drafted against the same bank account (checkbook) that the originating payroll check run used. If this value is false, then payments created to pay this vendor's liabilities should use the default_payment__checkbook_KEY if one is defined. |
zero_liability_created_date | smalldatetime (4) | | Date of the last time a zero liability was created |
ap__gl_account_KEY | int (4) | | Foreign key. The link to a gl account. Used as a default for entering an AP transaction. May be null. Only used by AP feature. When null this signifies that no GL Account is to be used as a default for AP Transactions. |
purchase_order_number | nvarchar (32) | NOT NULL | Used as a default for entering an AP transaction. Must not begin with a decimal or zero. Only used by AP feature. |
vendor_payment_memo | nvarchar (480) | NOT NULL | Used as a default for entering an AP transaction. Only used by AP feature. |
payment_term_KEY | int (4) | | Foreign key to the related Payment Term. Used as a default for payables, may be null |
online_bill_pay_vendor_ID | int (4) | | Intercept's key value the vendor in their system. |
export__quick_books_payee_KEY | int (4) | | A foreign key to the Quick_Books_Payee table, this is the quickbooks side of the mapping during the Acs to Quickbooks export data mapping process. This will be used to map Accounting CS vendors to QuickBooks payees of type vendor. This key will be null if no export mapping has been done. |
payment_reminder_note | nvarchar (100) | NOT NULL | A per vendor payment reminder note. |
include_payment_worksheet | bit (1) | NOT NULL | Flag used to determine if the payment worksheet should be included |