The Vendor Contacts Resource allows read/write access to the Sage 100 Vendor Contacts table for Vendor linked Users, and read access to the other Resource Tables.
Resource Method List | ||||
---|---|---|---|---|
Action | HTTP | URI | Admin? | Description |
get | GET | /vendorContacts | Retrieve Vendor data for the currently logged in User | |
list | GET | /vendorContacts[?APDivisionNo=<APDivisionNo>&vendorNo=<VendorNo>&contactCode=<contactCode>] | Only | Administrators can retrieve Vendor data from one or many Vendors |
update | POST | /vendorContacts[?APDivisionNo=<APDivisionNo>&vendorNo=<VendorNo>&contactCode=<contactCode>] | Yes | Update Vendor information |
create | POST | /vendors | Only | Create a new Vendor |
Resource Table List
Click on the table to view detail.
Element Name | Description | Type | Length |
---|---|---|---|
APDivisionNo | AP Division Number | String | 2 |
VendorNo | Vendor Number | String | 7 |
ContactCode | Contact Code | String | 10 |
ContactName | Contact Name | String | 30 |
AddressLine1 | Contact Address Line 1 | String | 30 |
AddressLine2 | Contact Address Line 2 | String | 30 |
AddressLine3 | Contact Address Line 3 | String | 30 |
City | Contact City | String | 20 |
State | Contact State | String | 2 |
ZipCode | Contact Zip Code | String | 10 |
CountryCode | Contact Country Code | String | 3 |
Salutation | Contact Salutation | String | 10 |
ContactTitle | Contact Title | String | 15 |
TelephoneNo1 | Contact Telephone Number 1 | String | 17 |
TelephoneExt1 | Contact Telephone Extension 1 | String | 5 |
TelephoneNo2 | Contact Telephone Number 2 | String | 17 |
TelephoneExt2 | Contact Telephone Extension 2 | String | 5 |
FaxNo | Fax Number | String | 17 |
EmailAddress | Contact Email Address | String | 50 |
ContactNotes | Contact Notes | String | 256 |
DateCreated | Creation Date | String | 8 |
TimeCreated | Creation Time | String | 8 |
UserCreatedKey | Creation User ID | String | 10 |
DateUpdated | Last Update Date | String | 8 |
TimeUpdated | Last Update Time | String | 8 |
UserUpdatedKey | Last Update User ID | String | 10 |
Element Name | Description | Type | Length |
---|---|---|---|
APDivisionNo | AP Division Number | String | 2 |
VendorNo | Vendor Number | String | 7 |
VendorName | Vendor Name | String | 30 |
AddressLine1 | Address Line 1 | String | 30 |
AddressLine2 | Address Line 2 | String | 30 |
AddressLine3 | Address Line 3 | String | 30 |
City | City | String | 20 |
State | State | String | 2 |
ZipCode | Zip Code | String | 10 |
CountryCode | Country Code | String | 3 |
PrimaryContact | Primary Contact Code | String | 10 |
TelephoneNo | Telephone Number | String | 17 |
TelephoneExt | Telephone Extension | String | 5 |
FaxNo | Fax Number | String | 17 |
EmailAddress | Email Address | String | 250 |
URLAddress | URL Address | String | 50 |
TermsCode | Terms Code | String | 2 |
Reference | Vendor Reference Number | String | 15 |
TemporaryVendor | Obsolete 5.00 | String | 1 |
VendorStatus | Vendor Status | String | 1 |
InactiveReasonCode | Inactive Reason Code | String | 5 |
CreditCardVendor | Credit Card Vendor | String | 1 |
HoldPayment | Hold Payment | String | 1 |
ElectronicPayment | Electronic Payment Vendor | String | 1 |
StandardEntryClass | Standard Entry Class Code | String | 3 |
ExemptionNoOnFile | Exemption Number On File | String | 1 |
TaxSchedule | Tax Schedule | String | 9 |
TaxClass | Tax Class | String | 2 |
AccountKey | Account Key | String | 9 |
SeparateCheck | Separate Check | String | 1 |
Comment | Vendor Comment | String | 30 |
Sort | Sort Field | String | 10 |
BatchFax | Batch Fax | String | 1 |
UsePOReceiptOfInvForVendor | Use PO Receipt Of Inv For Vendor | String | 1 |
PrimaryPurchaseAddressCode | Purchase Address Code | String | 4 |
VendorType | Vendor Type | String | 1 |
Form1099 | Default 1099 Form | String | 1 |
TaxpayerIDSocialSecurityNo | Taxpayer ID/Social Security Number | String | 9 |
Box1099 | Default 1099 Box | String | 3 |
MiscBox9 | Mark Misc Box 9 | String | 1 |
LastPurchaseDate | Last Purchase Date | String | 8 |
LastPaymentDate | Last Payment Date | String | 8 |
LastCheckNo | Last AP Check Number | String | 10 |
LastCheckAmt | Last Check Amount | Numeric | 15.2 |
RetentionRate | Retention Rate | Numeric | 7.2 |
AverageDaysToPay | Average Days To Pay | Numeric | 3 |
AverageDaysOverDue | Average Days Over Due | Numeric | 3 |
BalanceDue | Balance Due | Numeric | 16.2 |
NumberOfInvToUseInCalc | Number Of Invoices To Use In Calculation | Numeric | 7 |
DateCreated | Creation Date | String | 8 |
TimeCreated | Creation Time | String | 8 |
UserCreatedKey | Creation User ID | String | 10 |
DateUpdated | Last Update Date | String | 8 |
Element Name | Description | Type | Length | ||
---|---|---|---|---|---|
APDivisionNo | AP Division Number | String | 2 | ||
APDivisionDesc | AP Division Description | String | 30 | ||
AccountsPayableAcctKey | Accounts Payable Account Key | String | 9 | ||
DiscountsEarnedOrTakenAcctKey | Discounts Earned Or Taken Account Key | String | 9 | ||
CashAcctKey | Cash Account Key | String | 9 | ||
DiscountsLostAcctKey | Discounts Lost Account Key | String | 9 | ||
RetentionPayableAcctKey | Retention Payable Account Key | String | 9 | ||
FreightAcctKey | Freight Account Key | String | 9 | ||
SalesTaxAcctKey | Sales Tax Account Key | String | 9 | ||
NonRecoverableTaxAcctKey | Non-Recoverable Tax Account Key | String | 9 | ||
UseTaxAcctKey | Use Tax Account Key | String | 9 | ||
DateCreated | Creation Date | String | 8 | ||
TimeCreated | Creation Time | String | 8 | ||
UserCreatedKey | Creation User ID | String | 10 | ||
DateUpdated | Last Update Date | String | 8 | ||
TimeUpdated | Last Update Time | String | 8 | ||
UserUpdatedKey | Last Update User ID | String | 10 | ||
TimeUpdated | Last Update Time | String | 8 | ||
UserUpdatedKey | Last Update User ID | String | 10 |
Element Name | Description | Type | Length |
---|---|---|---|
CountryCode | Country Code | String | 3 |
CountryName | Country Name | String | 30 |
PhoneCode | Phone Area Code | String | 3 |
Element Name | Description | Type | Length |
---|---|---|---|
ZipCode | Zip Code | String | 10 |
City | City | String | 20 |
StateCode | State Code | String | 2 |
CountryCode | Country Code | String | 3 |
Users can retrieve their own data from the Vendor Contacts Resource. This can include data from any of the tables associated with the resource.
Administrators can retrieve any vendor contact data from the Vendor Contact Resource by specifying the APDivisonNo, VendorNo and ContactCode in the URI. If the Administrator leaves those three fields off the URI, then a list of all Vendor Contacts is returned.
Only the Vendor Contact table can be updated through the Vendor Contact Resource. Users can update their contact data, while Administrators can update any Vendor Contact data.
Only an Administrator can create a new Vendor Contact.