| Name | Description | Type | Additional Information |
|---|---|---|---|
| VendorGUID |
Vendor Globally Unique Identifier |
globally unique identifier |
Required |
| VendorID |
Vendor ID |
string |
Required Max length: 10 |
| Location |
Agvance location assigned to vendor |
string |
Max length: 6 |
| AccountNum |
Vendor account number |
string |
Max length: 20 |
| Name |
Vendor Name |
string |
Max length: 50 |
| Addr1 |
Address - line 1 |
string |
Max length: 50 |
| Addr2 |
Address - line 2 |
string |
Max length: 50 |
| City |
City |
string |
Max length: 30 |
| State |
State |
string |
Max length: 2 |
| Zipcode |
Zipcode |
string |
Max length: 10 |
| Phone |
Phone Number |
string |
Max length: 20 |
| Phone2 |
Phone Number 2 |
string |
Max length: 20 |
| Fax |
Fax number |
string |
Max length: 20 |
| Web |
Website information |
string |
Max length: 50 |
|
Email information |
string |
Max length: 60 |
|
| Notes |
Notes |
string |
Max length: 255 |
| XRef1 |
Cross Reference 1 |
string |
Max length: 40 |
| XRef2 |
Cross Reference 2 |
string |
Max length: 40 |
| XRef3 |
Cross Reference 3 |
string |
Max length: 40 |
| XRef4 |
Cross Reference 4 |
string |
Max length: 40 |
| TermsCode |
Default Payment Term |
string |
Max length: 15 |
| InActive |
Active status |
boolean |
Must be 0, 1, True, or False |
| Country |
Country |
string |
Max length: 60 |
| CompanyName1099 |
Name for 1099 |
string |
Max length: 50 |
| HoldPaymentYN |
Hold Payment status |
boolean |
Must be 0, 1, True, or False |
| OneBillPerCheck |
Check Issued for each bill |
boolean |
Must be 0, 1, True, or False |
| Pay2BankAcctNum |
Vendor ACH Bank Number (encrypted) |
string |
Max length: 80 |
| Pay2BankAcctType |
Vendor ACH account type |
string |
Max length: 1 |
| Pay2ACHRouteNum |
Vendor ACH routing number |
string |
Max length: 9 |
| ACHEmailAddr |
Email for ACH payment notification. May return email addresses separated by a semi-colon. |
string | |
| CurrentBalance |
Current balance |
decimal number |
Max length: 10 Must be numeric |
| BeginningBalance |
Beginning year balance |
decimal number |
Max length: 10 Must be numeric |
| PrePay |
Current prepay balance |
decimal number |
Max length: 10 Must be numeric |
| BeginningPrePay |
Beginning year prepay balance |
decimal number |
Max length: 10 Must be numeric |
| Month1Balance |
End balance fiscal month 1 |
decimal number |
Max length: 10 Must be numeric |
| Month2Balance |
End balance fiscal month 2 |
decimal number |
Max length: 10 Must be numeric |
| Month3Balance |
End balance fiscal month 3 |
decimal number |
Max length: 10 Must be numeric |
| Month4Balance |
End balance fiscal month 4 |
decimal number |
Max length: 10 Must be numeric |
| Month5Balance |
End balance fiscal month 5 |
decimal number |
Max length: 10 Must be numeric |
| Month6Balance |
End balance fiscal month 6 |
decimal number |
Max length: 10 Must be numeric |
| Month7Balance |
End balance fiscal month 7 |
decimal number |
Max length: 10 Must be numeric |
| Month8Balance |
End balance fiscal month 8 |
decimal number |
Max length: 10 Must be numeric |
| Month9Balance |
End balance fiscal month 9 |
decimal number |
Max length: 10 Must be numeric |
| Month10Balance |
End balance fiscal month 10 |
decimal number |
Max length: 10 Must be numeric |
| Month11Balance |
End balance fiscal month 11 |
decimal number |
Max length: 10 Must be numeric |
| Month12Balance |
End balance fiscal month 12 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth1Balance |
Prepay Balance end fiscal month 1 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth2Balance |
Prepay Balance end fiscal month 2 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth3Balance |
Prepay Balance end fiscal month 3 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth4Balance |
Prepay Balance end fiscal month 4 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth5Balance |
Prepay Balance end fiscal month 5 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth6Balance |
Prepay Balance end fiscal month 6 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth7Balance |
Prepay Balance end fiscal month 7 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth8Balance |
Prepay Balance end fiscal month 8 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth9Balance |
Prepay Balance end fiscal month 9 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth10Balance |
Prepay Balance end fiscal month 10 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth11Balance |
Prepay Balance end fiscal month 11 |
decimal number |
Max length: 10 Must be numeric |
| PrePayMonth12Balance |
Prepay Balance end fiscal month 12 |
decimal number |
Max length: 10 Must be numeric |
| Type1099 |
1099 Type |
string |
Max length: 20 |
| TaxID |
Federal Tax ID (encrypted) |
string |
Max length: 80 |
| Paid1099 |
1099 amount year to date |
decimal number |
Max length: 10 Must be numeric |
| PaidTotal |
Total paid year to date |
decimal number |
Max length: 10 Must be numeric |
| AcctID |
Default expense acct ID for bills |
string |
Max length: 10 |
| PayBy |
Payment method (c=check, a=eft, e=ACH) |
string |
Max length: 1 |
| ACHEmail |
ACH notification by email |
boolean |
Must be 0, 1, True, or False |
| ACHType |
ACH Type: CTX, CCD or PPD |
string | |
| ACHFax |
ACH notification by fax |
boolean |
Must be 0, 1, True, or False |
| ElectronicPO |
Electronic purchase order |
boolean |
Must be 0, 1, True, or False |
| LocationName |
Location name |
string |
Max length: 50 |
| AccountDescription |
Default expense account name |
string |
Max length: 40 |
| UniqueKey |
Vendor Unique Key |
integer |
Must be numeric. |
| VendorClass |
Vendor Classifcations |
Collection of clsVendClass |
List cannot be empty |
| VendorAttribute |
Vendor Attributes |
Collection of clsVendAttributes |
List cannot be empty |