| Name | Description | Type | Additional 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 |
|
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 |