Table: dbo.Vendor
Columns
NameTypeConstraintsDescription
vendor_KEYint (4)NOT NULLPrimary key for this table
client_KEYint (4)NOT NULLReference to client that has this vendor
vendor_namenvarchar (100)NOT NULLName of the vendor
vendor_idnvarchar (22)NOT NULLUser-assigned name
ein_ssnnvarchar (22)NOT NULLEIN/SSN (only used in certain types of vendors)
payee_namenvarchar (100)NOT NULLName that appears on check when it is cut
statusnvarchar (30)NOT NULLStatus of vendor
exclude_from_fee_calculationsbit (1)NOT NULLDo not charge fees to this vendor
contact_KEYint (4)NOT NULLReference to contact
default_payment__checkbook_KEYint (4)Key of the bank account to use as default for payment
default__vendor_payment_method_KEYint (4)NOT NULLForeign key to use as the default vendor payment method
print_stubbit (1)NOT NULLFlag indicating that a check stub should be printed when a payment method other than check or direct deposit is selected
auto_consolidate_for_paymentbit (1)NOT NULLFlag indicating that all selected payments will be combined to produce only one payment
auto_select_for_payment_when_duebit (1)NOT NULLFlag 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_daysint (4)NOT NULLNumber 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_recipientbit (1)NOT NULLIs this vendor a paycard recipient?
direct_deposit_method_KEYnvarchar (50)NOT NULLMethod used for Direct Deposit
direct_deposit_amount_percentdecimal (5, 2)NOT NULLPercentage or amount of pay to be distrubted using direct deposit.
direct_deposit_distribution_method_KEYint (4)NOT NULLIndicates method for calculating the direct deposit allocations. See CK_Vendor__direct_deposit_base_allocation_on comments for details.
vendor_id_sortablenvarchar (96)NOT NULLA 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_verifiedsmalldatetime (4)The date tin for this vendor was verified.
descriptionnvarchar (100)NOT NULLComputed field to allow filtering on Vendor: should not be used otherwise
inactive_reasonnvarchar (60)NOT NULLReason this vendor became inactive
date_inactivesmalldatetime (4)Date this vendor became inactive
vendor_account_numbernvarchar (100)NOT NULLThe account number for the vendor.
current__vendor_type_KEYint (4)NOT NULL
default_payment__memonvarchar (480)NOT NULLThe default payment memo placed on new bank transaction payments to this vendor.
use_same_checkbook_as_paychecksbit (1)NOT NULLThis 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_datesmalldatetime (4)Date of the last time a zero liability was created
ap__gl_account_KEYint (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_numbernvarchar (32)NOT NULLUsed as a default for entering an AP transaction. Must not begin with a decimal or zero. Only used by AP feature.
vendor_payment_memonvarchar (480)NOT NULLUsed as a default for entering an AP transaction. Only used by AP feature.
payment_term_KEYint (4)Foreign key to the related Payment Term. Used as a default for payables, may be null
online_bill_pay_vendor_IDint (4)Intercept's key value the vendor in their system.
export__quick_books_payee_KEYint (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_notenvarchar (100)NOT NULLA per vendor payment reminder note.
include_payment_worksheetbit (1)NOT NULLFlag used to determine if the payment worksheet should be included
Primary key
NameColumnsDescription
PK_Vendorvendor_KEY
Unique constraints
NameColumnsDescription
UK_Vendor$client_KEY$vendor_id$vendor_nameclient_KEY, vendor_id, vendor_name
UK_Vendor$contact_KEYcontact_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor__Checkbook__default_payment__checkbook_KEYdefault_payment__checkbook_KEYCheckbook (checkbook_KEY)
FK_Vendor__Client__client_KEYclient_KEYClient (client_KEY)
FK_Vendor__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Vendor__Direct_Deposit_Distribution_Method__direct_deposit_distribution_method_KEYdirect_deposit_distribution_method_KEYDirect_Deposit_Distribution_Method (direct_deposit_distribution_method_KEY)
FK_Vendor__Direct_Deposit_Method__direct_deposit_method_KEYdirect_deposit_method_KEYDirect_Deposit_Method (direct_deposit_method_KEY)
FK_Vendor__GL_Account__ap__gl_account_KEYap__gl_account_KEYGL_Account (gl_account_KEY)
FK_Vendor__Payment_Term__payment_term_KEYpayment_term_KEYPayment_Term (payment_term_KEY)
FK_Vendor__Quick_Books_Payee__export__quick_books_payee_KEYexport__quick_books_payee_KEYQuick_Books_Payee (quick_books_payee_KEY)
FK_Vendor__Vendor_Payment_Method__default__vendor_payment_method_KEYdefault__vendor_payment_method_KEYVendor_Payment_Method (vendor_payment_method_KEY)
FK_Vendor__Vendor_Type__current__vendor_type_KEYcurrent__vendor_type_KEYVendor_Type (vendor_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Spreadsheet_Import_Vendor__Vendor__vendor_KEYvendor_KEYSpreadsheet_Import_Vendor
FK_Tax_Jurisdiction_State_Setting__Vendor__default__vendor_KEYdefault__vendor_KEYTax_Jurisdiction_State_Setting
FK_Client_Payroll_Item__Vendor__vendor_KEYvendor_KEYClient_Payroll_Item
FK_Worker_Compensation__Vendor__vendor_KEYvendor_KEYWorker_Compensation
FK_Client_Tax_Item__Vendor__vendor_KEYvendor_KEYClient_Tax_Item
FK_Payable_Transaction_Template__Vendor__vendor_KEYvendor_KEYPayable_Transaction_Template
FK_Vendor_Agent__Vendor__vendor_KEYvendor_KEYVendor_Agent
FK_Tax_Agent_N_Vendor_Agent__Vendor__vendor_KEYvendor_KEYTax_Agent_N_Vendor_Agent
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Vendor__vendor_KEYvendor_KEYBank_Reconciliation_Recurring_Adjustment_Template
FK_Vendor_Independent_Contractor_Reported__Vendor__vendor_KEYvendor_KEYVendor_Independent_Contractor_Reported
FK_Bank_Feeds_Retrieved_Transaction__Vendor__vendor_KEYvendor_KEYBank_Feeds_Retrieved_Transaction
FK_Quick_Books_Payee_N_Vendor__Vendor__vendor_KEYvendor_KEYQuick_Books_Payee_N_Vendor
FK_Bank_Transaction_Template__Vendor__vendor_KEYvendor_KEYBank_Transaction_Template
FK_Vendor_Direct_Deposit_Allocation__Vendor__vendor_KEYvendor_KEYVendor_Direct_Deposit_Allocation
FK_Form_1099_Print_Threshold_Override__Vendor__vendor_KEYvendor_KEYForm_1099_Print_Threshold_Override
FK_Vendor_1099_Box_Setup__Vendor__vendor_KEYvendor_KEYVendor_1099_Box_Setup
FK_Custom_Value_Vendor__Vendor__vendor_KEYvendor_KEYCustom_Value_Vendor
FK_Manage_AP_Payment_Processable_Transaction__Vendor__vendor_KEYvendor_KEYManage_AP_Payment_Processable_Transaction
FK_Vendor_Agent_Effective_Date__Vendor__vendor_KEYvendor_KEYVendor_Agent_Effective_Date
FK_Vendor_Distribution__Vendor__vendor_KEYvendor_KEYVendor_Distribution
FK_Garnishment_Order__Vendor__vendor_KEYvendor_KEYGarnishment_Order
FK_Form_1099__Vendor__vendor_KEYvendor_KEYForm_1099
FK_Vendor_Amortization_Schedule__Vendor__vendor_KEYvendor_KEYVendor_Amortization_Schedule
FK_Bank_Feeds_Assignment_Rule_Action__Vendor__assigned_value__vendor_KEYassigned_value__vendor_KEYBank_Feeds_Assignment_Rule_Action
FK_Payroll_Check_Tax_Item__Vendor__vendor_KEYvendor_KEYPayroll_Check_Tax_Item
FK_Payroll_Check_Payroll_Item__Vendor__vendor_KEYvendor_KEYPayroll_Check_Payroll_Item
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Vendor__vendor_KEYvendor_KEYPayroll_Bank_Transaction_Worker_Compensation_Item
FK_Creditor_Garnishment_Order__Vendor__vendor_KEYvendor_KEYCreditor_Garnishment_Order
FK_Child_Support_Order__Vendor__vendor_KEYvendor_KEYChild_Support_Order
FK_Vendor_Bank_Transaction__Vendor__vendor_KEYvendor_KEYVendor_Bank_Transaction
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Vendor__vendor_KEYvendor_KEYPayroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail
FK_Payable_Transaction__Vendor__vendor_KEYvendor_KEYPayable_Transaction
FK_Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail__Vendor__vendor_KEYvendor_KEYPayroll_Check_Payroll_Item_Distribution_Child_Support_Detail
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Vendor__vendor_KEYvendor_KEYPayroll_Check_Payroll_Item_Distribution_Garnishment_Detail
FK_Pending_AP_Payment_Application__Vendor__vendor_KEYvendor_KEYPending_AP_Payment_Application
FK_Vendor_AP_Beginning_Balance__Vendor__vendor_KEYvendor_KEYVendor_AP_Beginning_Balance

Schema diagram