Table: dbo.Vendor
Columns
Name | Type | Constraints | Description
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

Primary key
Name | Columns | Description
PK_Vendor | vendor_KEY |
Unique constraints
Name | Columns | Description
UK_Vendor$client_KEY$vendor_id$vendor_name | client_KEY, vendor_id, vendor_name |
UK_Vendor$contact_KEY | contact_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor__Checkbook__default_payment__checkbook_KEY | default_payment__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Vendor__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Vendor__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) |
FK_Vendor__Direct_Deposit_Distribution_Method__direct_deposit_distribution_method_KEY | direct_deposit_distribution_method_KEY | Direct_Deposit_Distribution_Method (direct_deposit_distribution_method_KEY) |
FK_Vendor__Direct_Deposit_Method__direct_deposit_method_KEY | direct_deposit_method_KEY | Direct_Deposit_Method (direct_deposit_method_KEY) |
FK_Vendor__GL_Account__ap__gl_account_KEY | ap__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Vendor__Payment_Term__payment_term_KEY | payment_term_KEY | Payment_Term (payment_term_KEY) |
FK_Vendor__Quick_Books_Payee__export__quick_books_payee_KEY | export__quick_books_payee_KEY | Quick_Books_Payee (quick_books_payee_KEY) |
FK_Vendor__Vendor_Payment_Method__default__vendor_payment_method_KEY | default__vendor_payment_method_KEY | Vendor_Payment_Method (vendor_payment_method_KEY) |
FK_Vendor__Vendor_Type__current__vendor_type_KEY | current__vendor_type_KEY | Vendor_Type (vendor_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Spreadsheet_Import_Vendor__Vendor__vendor_KEY | vendor_KEY | Spreadsheet_Import_Vendor |
FK_Tax_Jurisdiction_State_Setting__Vendor__default__vendor_KEY | default__vendor_KEY | Tax_Jurisdiction_State_Setting |
FK_Client_Payroll_Item__Vendor__vendor_KEY | vendor_KEY | Client_Payroll_Item |
FK_Worker_Compensation__Vendor__vendor_KEY | vendor_KEY | Worker_Compensation |
FK_Client_Tax_Item__Vendor__vendor_KEY | vendor_KEY | Client_Tax_Item |
FK_Payable_Transaction_Template__Vendor__vendor_KEY | vendor_KEY | Payable_Transaction_Template |
FK_Vendor_Agent__Vendor__vendor_KEY | vendor_KEY | Vendor_Agent |
FK_Tax_Agent_N_Vendor_Agent__Vendor__vendor_KEY | vendor_KEY | Tax_Agent_N_Vendor_Agent |
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Vendor__vendor_KEY | vendor_KEY | Bank_Reconciliation_Recurring_Adjustment_Template |
FK_Vendor_Independent_Contractor_Reported__Vendor__vendor_KEY | vendor_KEY | Vendor_Independent_Contractor_Reported |
FK_Bank_Feeds_Retrieved_Transaction__Vendor__vendor_KEY | vendor_KEY | Bank_Feeds_Retrieved_Transaction |
FK_Quick_Books_Payee_N_Vendor__Vendor__vendor_KEY | vendor_KEY | Quick_Books_Payee_N_Vendor |
FK_Bank_Transaction_Template__Vendor__vendor_KEY | vendor_KEY | Bank_Transaction_Template |
FK_Vendor_Direct_Deposit_Allocation__Vendor__vendor_KEY | vendor_KEY | Vendor_Direct_Deposit_Allocation |
FK_Form_1099_Print_Threshold_Override__Vendor__vendor_KEY | vendor_KEY | Form_1099_Print_Threshold_Override |
FK_Vendor_1099_Box_Setup__Vendor__vendor_KEY | vendor_KEY | Vendor_1099_Box_Setup |
FK_Custom_Value_Vendor__Vendor__vendor_KEY | vendor_KEY | Custom_Value_Vendor |
FK_Manage_AP_Payment_Processable_Transaction__Vendor__vendor_KEY | vendor_KEY | Manage_AP_Payment_Processable_Transaction |
FK_Vendor_Agent_Effective_Date__Vendor__vendor_KEY | vendor_KEY | Vendor_Agent_Effective_Date |
FK_Vendor_Distribution__Vendor__vendor_KEY | vendor_KEY | Vendor_Distribution |
FK_Garnishment_Order__Vendor__vendor_KEY | vendor_KEY | Garnishment_Order |
FK_Form_1099__Vendor__vendor_KEY | vendor_KEY | Form_1099 |
FK_Vendor_Amortization_Schedule__Vendor__vendor_KEY | vendor_KEY | Vendor_Amortization_Schedule |
FK_Bank_Feeds_Assignment_Rule_Action__Vendor__assigned_value__vendor_KEY | assigned_value__vendor_KEY | Bank_Feeds_Assignment_Rule_Action |
FK_Payroll_Check_Tax_Item__Vendor__vendor_KEY | vendor_KEY | Payroll_Check_Tax_Item |
FK_Payroll_Check_Payroll_Item__Vendor__vendor_KEY | vendor_KEY | Payroll_Check_Payroll_Item |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Vendor__vendor_KEY | vendor_KEY | Payroll_Bank_Transaction_Worker_Compensation_Item |
FK_Creditor_Garnishment_Order__Vendor__vendor_KEY | vendor_KEY | Creditor_Garnishment_Order |
FK_Child_Support_Order__Vendor__vendor_KEY | vendor_KEY | Child_Support_Order |
FK_Vendor_Bank_Transaction__Vendor__vendor_KEY | vendor_KEY | Vendor_Bank_Transaction |
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Vendor__vendor_KEY | vendor_KEY | Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail |
FK_Payable_Transaction__Vendor__vendor_KEY | vendor_KEY | Payable_Transaction |
FK_Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail__Vendor__vendor_KEY | vendor_KEY | Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail |
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Vendor__vendor_KEY | vendor_KEY | Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail |
FK_Pending_AP_Payment_Application__Vendor__vendor_KEY | vendor_KEY | Pending_AP_Payment_Application |
FK_Vendor_AP_Beginning_Balance__Vendor__vendor_KEY | vendor_KEY | Vendor_AP_Beginning_Balance |