VendorContacts Resource

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.

AP Vendor Contact

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

AP Vendor

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

AP Division

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

SY Country Code

Element Name	Description	Type	Length
CountryCode	Country Code	String	3
CountryName	Country Name	String	30
PhoneCode	Phone Area Code	String	3

SY ZipCode

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.

VendorContacts Resource

AP Vendor Contact

AP Vendor

AP Division

SY Country Code

SY ZipCode

Resource Methods

Get

List

Update

Create