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
ActionHTTPURIAdmin?Description
getGET/vendorContactsRetrieve Vendor data for the currently logged in User
listGET/vendorContacts[?APDivisionNo=<APDivisionNo>&vendorNo=<VendorNo>&contactCode=<contactCode>]OnlyAdministrators can retrieve Vendor data from one or many Vendors
updatePOST/vendorContacts[?APDivisionNo=<APDivisionNo>&vendorNo=<VendorNo>&contactCode=<contactCode>]YesUpdate Vendor information
createPOST/vendorsOnlyCreate a new Vendor

Resource Table List
Click on the table to view detail.

AP Vendor Contact

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
VendorNoVendor NumberString7
ContactCodeContact CodeString10
ContactNameContact NameString30
AddressLine1Contact Address Line 1String30
AddressLine2Contact Address Line 2String30
AddressLine3Contact Address Line 3String30
CityContact CityString20
StateContact StateString2
ZipCodeContact Zip CodeString10
CountryCodeContact Country CodeString3
SalutationContact SalutationString10
ContactTitleContact TitleString15
TelephoneNo1Contact Telephone Number 1String17
TelephoneExt1Contact Telephone Extension 1String5
TelephoneNo2Contact Telephone Number 2String17
TelephoneExt2Contact Telephone Extension 2String5
FaxNoFax NumberString17
EmailAddressContact Email AddressString50
ContactNotesContact NotesString256
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

AP Vendor

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
VendorNoVendor NumberString7
VendorNameVendor NameString30
AddressLine1Address Line 1String30
AddressLine2Address Line 2String30
AddressLine3Address Line 3String30
CityCityString20
StateStateString2
ZipCodeZip CodeString10
CountryCodeCountry CodeString3
PrimaryContactPrimary Contact CodeString10
TelephoneNoTelephone NumberString17
TelephoneExtTelephone ExtensionString5
FaxNoFax NumberString17
EmailAddressEmail AddressString250
URLAddressURL AddressString50
TermsCodeTerms CodeString2
ReferenceVendor Reference NumberString15
TemporaryVendorObsolete 5.00String1
VendorStatusVendor StatusString1
InactiveReasonCodeInactive Reason CodeString5
CreditCardVendorCredit Card VendorString1
HoldPaymentHold PaymentString1
ElectronicPaymentElectronic Payment VendorString1
StandardEntryClassStandard Entry Class CodeString3
ExemptionNoOnFileExemption Number On FileString1
TaxScheduleTax ScheduleString9
TaxClassTax ClassString2
AccountKeyAccount KeyString9
SeparateCheckSeparate CheckString1
CommentVendor CommentString30
SortSort FieldString10
BatchFaxBatch FaxString1
UsePOReceiptOfInvForVendorUse PO Receipt Of Inv For VendorString1
PrimaryPurchaseAddressCodePurchase Address CodeString4
VendorTypeVendor TypeString1
Form1099Default 1099 FormString1
TaxpayerIDSocialSecurityNoTaxpayer ID/Social Security NumberString9
Box1099Default 1099 BoxString3
MiscBox9Mark Misc Box 9String1
LastPurchaseDateLast Purchase DateString8
LastPaymentDateLast Payment DateString8
LastCheckNoLast AP Check NumberString10
LastCheckAmtLast Check AmountNumeric15.2
RetentionRateRetention RateNumeric7.2
AverageDaysToPayAverage Days To PayNumeric3
AverageDaysOverDueAverage Days Over DueNumeric3
BalanceDueBalance DueNumeric16.2
NumberOfInvToUseInCalcNumber Of Invoices To Use In CalculationNumeric7
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8

AP Division

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
APDivisionDescAP Division DescriptionString30
AccountsPayableAcctKeyAccounts Payable Account KeyString9
DiscountsEarnedOrTakenAcctKeyDiscounts Earned Or Taken Account KeyString9
CashAcctKeyCash Account KeyString9
DiscountsLostAcctKeyDiscounts Lost Account KeyString9
RetentionPayableAcctKeyRetention Payable Account KeyString9
FreightAcctKeyFreight Account KeyString9
SalesTaxAcctKeySales Tax Account KeyString9
NonRecoverableTaxAcctKeyNon-Recoverable Tax Account KeyString9
UseTaxAcctKeyUse Tax Account KeyString9
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

SY Country Code

Element NameDescriptionTypeLength
CountryCodeCountry CodeString3
CountryNameCountry NameString30
PhoneCodePhone Area CodeString3

SY ZipCode

Element NameDescriptionTypeLength
ZipCodeZip CodeString10
CityCityString20
StateCodeState CodeString2
CountryCodeCountry CodeString3


Get

Users can retrieve their own data from the Vendor Contacts Resource. This can include data from any of the tables associated with the resource.

List

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.

Update

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.

Create

Only an Administrator can create a new Vendor Contact.