What are the vendor field mappings?

Field Name:

Description:

Account

Vendor Account. Enter a unique account number. (Maximum of 10 alpha-numeric characters including "-" and ".")

ACH_AccountNumber

Bank Account Number. Enter the number of the bank account from where the vendor's payment is to be withdrawn. (Maximum of 17 characters) Click here to learn more.

ACH_AccountType

Account Type. 0 = Checking, 1 = Savings

ACH_IndividualId

Individual Id. Enter the loan account number.  (Maximum of 15 characters)

ACH_IndividualName

Individual Name. Enter the vendor's name. (Maximum of 22 characters)

ACH_RoutingNumber

Routing Number. Enter the number of the bank or financial institution from where the vendor’s payment should be withdrawn. (Maximum of 9 characters)

Refer to the image below to locate the vendor's bank routing number from a sample check.

ACH_ServiceStatus

Service Status. Indicates the status of the vendor's ACH settings. Select one of the following from the list:

        0 = None

        1 = Active

        2 = Cancelled

        3 = Hold

Birthday

Birthdate. Enter the vendor's birth date.

City

City. Enter vendor's city. (Maximum of 50 characters)

Code

Vendor Code. Enter a vendor code. (Maximum of 50 characters)

Counselor

Counselor. Enter the name of the investment counselor associated with this vendor. (Maximum of 64 characters)

DeliveryOptions

Delivery Options. The available options are:

0 = None

1 = Print

2 = Email

3 = Print & Email

EmailAddress

Email Address. Enter vendor's email address. (Maximum of 255 characters)

EmailFormat

Email Format. Enter the email delivery format. Available options are 0=Plain Text, 1=HTML.

FirstName

First Name. Enter vendor's first name. (Maximum of 30 characters)

FullName

Full Name. Enter the vendor's full name. (Maximum of 30 characters)

LastName

Last Name. Enter vendor's last name. (Maximum of 30 characters)

MI

Middle Initial. Enter vendor's middle initial. (Maximum of 1 character)

Payee

Payee. Enter a payee name and address to use when printing checks, otherwise the system will use the vendor's name and mailing address.

PhoneCell

Cell Phone Number. Enter vendor's phone number. (Maximum of 20 characters)

PhoneFax

Fax Phone Number. Enter vendor's phone number. (Maximum of 20 characters)

PhoneHome

Home Phone Number. Enter vendor's phone number. (Maximum of 20 characters)

PhoneMain

Primary Phone Number: 0 = Home, 1 = Work, 2 = Cell and 3 = Fax.

PhoneWork

Work Phone Number. Enter vendor's phone number. (Maximum of 20 characters)

RolodexFlag

Rolodex Flag. The options are:

        0 = Never print rolodex cards.

        1 = Print as needed.

        2 = Data contained in the rolodex has changed.

        3 = Print and data changed

Salutation

Vendor's Salutation. Enter a salutation field. (Maximum of 50 characters)

Send1099

Tax Reporting. Enter 1 to print tax forms for this vendor; otherwise enter 0.

SendDepositNotificationFlag

Send Deposit Notification. The options are:

        0 = None

        2  = Print

        4  = Email

        6  = Print & Email

State

Vendor's State. Enter vendor's state.

Street

Vendor's Street. Enter vendor's mailing street address. (Maximum of 64 characters)

TIN

Vendor's TIN. Enter vendor's tax identification number. (Maximum of 11 characters)

TINType

TIN Type. The options codes to identify the recipient type used for tax reporting:

UsePayee

Enable Payee. Enter 1 to print payee's name and address on check; otherwise enter 0.

WPC_PIN

Web Publishing Central PIN. (The PIN can be up to 10 alpha numeric characters)

WPC_Publish

Web Publishing Central Publish. Enter 1 to publish this vendor; otherwise enter 0.

ZipCode

Vendor's Zip Code. Enter vendor's zip code. (Maximum of 10 characters)