CustomerContacts Resource

The Customer Contacts Resource allows read/write access to the Sage 100 Customer Contacts table for Customer linked Users, and read access to the other Resource Tables.

Resource Method List
ActionHTTPURIAdmin?Description
getGET/customerContactsRetrieve Customer Contact data for the currently logged in user
listGET/customerContacts[?ARDivisionNo=<ARDivisionNo>&vendorNo=<CustomerNo>&contactCode=<contactCode>]OnlyAdministrators can retrieve data from one or many Customer Contacts
updatePOST/customerContacts[?ARDivisionNo=<ARDivisionNo>&customerNo =<CustomerNo>&contactCode=<contactCode>]YesUpdate Customer Contact information
createPOST/customerContactsOnlyCreate a new Customer Contact

Resource Table List
Click on the table to view detail.

AR Customer Contact

Element NameDescriptionTypeLength
ARDivisionNoAR Division NumberString2
CustomerNoCustomer NumberString20
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
EBMUserIDeBusiness Manager User IDString15
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

AR Customer

Element NameDescriptionTypeLength
ARDivisionNoAR Division NumberString2
CustomerNoCustomer NumberString20
CustomerNameCustomer NameString30
AddressLine1Address Line 1String30
AddressLine2Address Line 2String30
AddressLine3Address Line 3String30
CityCityString20
StateStateString2
ZipCodeZip CodeString10
CountryCodeCountry CodeString3
TelephoneNoTelephone NumberString17
TelephoneExtTelephone ExtensionString5
FaxNoFax NumberString17
EmailAddressEmail AddressString250
URLAddressURL AddressString50
EBMEnabledeBusiness Manager EnabledString1
EBMConsumerUserIDeBusiness Manager Consumer User IDString15
BatchFaxBatch FaxString1
DefaultCreditCardPmtTypeDefault Credit Card Payment TypeString5
ContactCodeContact CodeString10
ShipMethodShip MethodString15
TaxScheduleTax ScheduleString9
TaxExemptNoTax Exempt NumberString15
TermsCodeTerms CodeString2
SalespersonDivisionNoSalesperson Division NumberString2
SalespersonNoSalesperson NumberString4
SalespersonDivisionNo2Salesperson Division Number 2String2
SalespersonNo2Salesperson Number 2String4
SalespersonDivisionNo3Salesperson Division Number 3String2
SalespersonNo3Salesperson Number 3String4
SalespersonDivisionNo4Salesperson Division Number 4String2
SalespersonNo4Salesperson Number 4String4
SalespersonDivisionNo5Salesperson Division Number 5String2
SalespersonNo5Salesperson Number 5String4
CommentCustomer CommentString30
SortFieldSort FieldString10
TemporaryCustomerObsolete 5.00String1
CustomerStatusCustomer StatusString1
InactiveReasonCodeInactive Reason CodeString5
OpenItemCustomerOpen Item CustomerString1
ResidentialAddressResidential AddressString1
StatementCycleStatement CycleString1
PrintDunningMessagePrint Dunning Message On StatementString1
CustomerTypeCustomer TypeString4
PriceLevelPrice LevelString1
DateLastActivityDate Of Last ActivityString8
DateLastPaymentDate Of Last PaymentString8
DateLastStatementDate Of Last StatementString8
DateLastFinanceChrgDate Of Last Finance ChargeString8
DateLastAgingDate Of Last AgingString8
DefaultItemCodeDefault Item CodeString30
DefaultCostCodeDefault Cost CodeString9
DefaultCostTypeDefault Cost TypeString1
CreditHoldCustomer On Credit HoldString1
PrimaryShipToCodePrimary Ship To CodeString4
DateEstablishedDate EstablishedString8
CreditCardGUIDSage Exchange vault credit card identifierString32
DefaultPaymentTypeDefault Payment TypeString5
EmailStatementsObsolete 4.30String1
NumberOfInvToUseInCalcNumber Of Invoices To Use In Days CalcNumeric2
AvgDaysPaymentInvoiceAvg Days For Payment From Invoice DateNumeric3
AvgDaysOverDueAvg Days Overdue (Pay Date - Due Date)Numeric3
CustomerDiscountRateCustomer Discount RateNumeric13.3
ServiceChargeRateService Charge RateNumeric13.3
CreditLimitCredit LimitNumeric14.2
LastPaymentAmtLast Payment AmountNumeric14.2
HighestStmntBalanceHighest Statement BalanceNumeric14.2
UnpaidServiceChrgUnpaid Service ChargeNumeric14.2
BalanceForwardBalance ForwardNumeric14.2
CurrentBalanceCurrent BalanceNumeric14.2
AgingCategory1Aging Category 1Numeric14.2
AgingCategory2Aging Category 2Numeric14.2
AgingCategory3Aging Category 3Numeric14.2
AgingCategory4Aging Category 4Numeric14.2
OpenOrderAmtOpen Order AmountNumeric14.2
RetentionCurrentRetention CurrentNumeric14.2
RetentionAging1Retention Aging 1Numeric14.2
RetentionAging2Retention Aging 2Numeric14.2
RetentionAging3Retention Aging 3Numeric14.2
RetentionAging4Retention Aging 4Numeric14.2
SplitCommRate2Split Commission Rate 2Numeric9.3
SplitCommRate3Split Commission Rate 3Numeric9.3
SplitCommRate4Split Commission Rate 4Numeric9.3
SplitCommRate5Split Commission Rate 5Numeric9.3
DateCreatedCreation DateString8
TimeCreatedCreation TimeString8
UserCreatedKeyCreation User IDString10
DateUpdatedLast Update DateString8
TimeUpdatedLast Update TimeString8
UserUpdatedKeyLast Update User IDString10

AR Division

Element NameDescriptionTypeLength
TermsCodeAR Terms CodeString2
TermsCodeDescTerms Code DescriptionString30
DueDateADayOfTheMonthDue Date a Day of The MonthString1
DiscountDateADayOfTheMoDiscount Date a Day of The MonthString1
DiscountCalculationMethodDiscount Calculation MethodString1
DaysBeforeDueDays Before DueNumeric3
MinimumDaysAllowedInvMinimum Days Allowed Before Invoice is DueNumeric3
DaysBeforeDiscountDueDays Before Discount DueNumeric3
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

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

List

Administrators can retrieve any customer contact data from the Customer Contact Resource by specifying the ARDivisonNo, CustomerNo and ContactCode in the URI. If the Administrator leaves those three fields off the URI, then a list of all Customer Contacts is returned.

Update

The Customer Contact table can be updated through the Customer Contact Resource. Users can update their contact data, while Administrators can update any Customer Contact data.

Create

Only an Administrator can create a new Customer Contact.