Vendors Resource

The Vendors Resource allows read/write access to the Sage 100 Vendor table for Vendor linked Users, read access to the other Resource Tables.

Resource Method List
ActionHTTPURIAdmin?Description
getGET/vendorsRetrieve Vendor data for the currently logged in User
listGET/vendors[?APDivisionNo=<APDivisionNo>&vendorNo=<VendorNo>]OnlyAdministrators can retrieve Vendor data from one or many Vendors
updatePOST/vendors[?APDivisionNo=<APDivisionNo>&vendorNo=<VendorNo>]YesUpdate Vendor information
createPOST/vendorsOnlyCreate a new Vendor

Resource Table List
Click on the table to view detail.

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

AP Terms Code

Element NameDescriptionTypeLength
TermsCodeTerms CodeString2
TermsCodeDescTerms Code DescriptionString30
DaysBeforeDueDays Before DueNumeric3
DueDateADayOfTheMonthDay Of The Month Due DateString1
MinimumDaysAllowedInvMinimum Days Allowed Before Invoice DueNumeric3
DaysDiscountAllowedDays Discount AllowedNumeric3
DiscountDateADayOfTheMoDay Of The Month Discount DateString1
MinimumDaysAllowedDiscMinimum Days Allowed Before Discount DueNumeric3
DiscountRateDiscount RateNumeric9.3
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

AP Vendor Primary 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

CI Inactive Reason Code

Element NameDescriptionTypeLength
InactiveReasonCodeInactive Reason CodeString5
InactiveReasonCodeDescInactive Reason Code DescriptionString30
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

PO Vendor Primary Purchase Address

Element NameDescriptionTypeLength
APDivisionNoAP Division NumberString2
VendorNoVendor NumberString7
PurchaseAddressCodePurchase Address CodeString4
PurchaseNamePurchase NameString30
PurchaseAddress1Purchase Address 1String30
PurchaseAddress2Purchase Address 2String30
PurchaseAddress3Purchase Address 3String30
PurchaseCityPurchase CityString20
PurchaseStatePurchase StateString2
PurchaseZipCodePurchase Zip CodeString10
PurchaseCountryCodePurchase Country CodeString3
BatchFaxBatch FaxString1
TelephoneNoTelephone NumberString17
TelephoneExtTelephone ExtensionString5
FaxNoFax NumberString17
ContactCodeContact CodeString10
TaxScheduleTax ScheduleString9
ExemptionNoOnFileExemption Number On FileString1
EmailAddressEmail AddressString50
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

GL Account

SY Sales Tax Schedule

Element NameDescriptionTypeLength
TaxScheduleTax ScheduleString9
TaxScheduleDescTax Schedule DescriptionString30
PrintTaxCodeOnFormsPrint Tax Code On FormsString1

SY Sales Tax Class

Element NameDescriptionTypeLength
TaxClassTax ClassString2
TaxClassDescTax Class DescriptionString30
TaxClassTypeTax Class TypeString1

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 Resource. This can include data from any of the tables associated with the resource.

List

Administrators can retrieve any Vendor data from the Vendor Resource by specifying an APDivisionNo and VendorNo in the URI. If the Administrator leaves those fields off the URI, then a list of all Vendors is returned.

Update

The Vendor table can be updated through the Vendor Resource. Users can update their own Vendor data, while Administrators can update any Vendors data.

Create

Only an Administrator can create a new Vendor. On a successful Create, the key values, Division Number and Vendor Number, are returned.