NameDescriptionTypeAdditional Information
VendorID

Vendor ID as assigned by retailer. Unique within an Agvance Database.

string

Required

Max length: 10

Location

Retailer location ID that buys from this vendor. A list of Location IDs can be obtained via the GetLocation Method.

string

Required

Max length: 6

AccountNum

Retailers account number assigned by this vendor

string

Max length: 20

Name

Vendor Name

string

Max length: 50

Addr1

Vendor Address - line 1

string

Max length: 50

Addr2

Vendor Address - line 2

string

Max length: 50

City

Vendor City

string

Max length: 30

State

Vendor State

string

Max length: 2

Zipcode

Vendor Zipcode

string

Max length: 10

Phone

Vendor Phone Number

string

Max length: 20

Phone2

Vendor Phone Number 2

string

Max length: 20

Fax

Vendor Fax number

string

Max length: 20

Web

Vendor Website URL

string

Max length: 50

Email

Vendor Email address

string

Max length: 60

Notes

User entered Notes

string

Max length: 255

XRef1

Cross Reference 1. User defined but usually this Vendor’s unique identifier in some other software system.

string

Max length: 40

XRef2

Cross Reference 2. User defined but usually this Vendor’s unique identifier in some other software system.

string

Max length: 40

XRef3

Cross Reference 3. User defined but usually this Vendor’s unique identifier in some other software system.

string

Max length: 40

XRef4

Cross Reference 4. User defined but usually this Vendor’s unique identifier in some other software system.

string

Max length: 40

TermsCode

Typical Payment Term offered to the retailer by this vendor. A list of Terms Codes can be obtained via the GetTermsCode Method.

string

Max length: 15

InActive

Active status – ‘true’ or ‘false’

boolean

Must be 0, 1, True, or False

Country

Country

string

Max length: 60

Type1099

Vendor 1099 Type. Valid options are: "None", "Misc", "Interest", "Rent", "Patronage", "Dividend", "Gross", "NEC"

string

Max length: 20

AcctID

Default expense acct ID for bills.

string

Max length: 10

TaxID

Vendor Federal Tax ID

string

Max length: 20

CompanyName1099

Vendor Name that prints on the 1099 form

string

Max length: 50

PayBy

Payment method (C=Check, A=EFT, E=ACH)

string

Max length: 1

HoldPaymentYN

Hold Payment status. ‘true’ or ‘false’

boolean

Must be 0, 1, True, or False

OneBillPerCheck

Check Issued for each single bill. ‘true’ or ‘false’

boolean

Must be 0, 1, True, or False

Pay2ACHRouteNum

Vendor ACH routing number

string

Max length: 9

Pay2BankAcctNum

Vendor ACH Bank Number

string

Max length: 17

Pay2BankAcctType

Vendor ACH account type (C = Checking or S = Savings)

string

Max length: 1

ACHEmailAddr

Vendor Email address for ACH payment notification. Email addresses must be concatenated (separated) with a semi-colon (;).

string
ACHEmail

ACH notification to vendor by email

boolean

Must be 0, 1, True, or False

ACHType

ACH Type: CTX, CCD or PPD

string
ACHFax

ACH notification to vendor by fax

boolean

Must be 0, 1, True, or False

ElectronicPO

‘true’ or ‘false’ – Does this vendor accept digital P.O.s

boolean

Must be 0, 1, True, or False

VendorClassAdd

Vendor Classifcations. User defined classifications (categories) that this vendor belongs to. A list of valid Vendor Classifications can be obtained via the GetVendorClassifications Method.

Collection of clsVendClassAdd
VendorAttributeAdd

Vendor Attributes. Values of one more user defined vendor attributes. A list of valid Vendor Attribute names can be obtained via the GetVendorAttributes Method.

Collection of clsVendAttributesAdd