WS_Cust
Customer Web Service
The following operations are supported. For a formal definition, please review the Service Description.
-
AddNote
Adds a note to an existing issue and returns the ID generated for the note. the note object to save to the haul-it database company codethe id generated by the haul-it database for the note -
CheckCredit
Checks customer or site credit. companyCode user that is logged into the device customer number site numberCreditCheck object that includes the amount owing and the credit type (warning,exceeded the limit, etc) -
ColorActivities
Determine which activities have rates based on cust-site-service company code customer number site number service numbera datatable containing activity codes and if that code has a rate for the given cust/site/service CM12_CODE Activity Code BLUE 1 if the code has a rate, 0 if it doesn't
Value Description -
CreateContact
Create a contact for a customer or site Contact Object Customer Number Site number login company code [2 characters]Returns the unique contact number for the contact created -
CreateCustomerIssue
Create Customer Issue login company code [2 characters]. Customer Number. [int] Site Number. [int] Service Number. [int] Customer Name. [max 40 characters] Caller Name. [max 40 characters] Call Problem. [ntext] Call Type Code. [max 2 characters] Urgency Code. [max 2 characters] Comment. [max 40 characters] Promise Date. [smalldatetime] Telephone Number. [max 10 characters] Call Scheduled. [int]Call Number for the created customer issue -
CreateHaulCustomer
Create Customer login company code [2 characters]. Customer Name. [max 40 characters] Customer Type. [max 2 characters] Customer Address 1. [max 40 characters] Customer Address 2. [max 40 characters] Customer Address 3. [max 40 characters] Customer Address 4. [max 40 characters] Customer City. [max 40 characters] Customer State. [max 2 characters] Customer Postal Code/Zip Code. [max 9 characters] Customer Phone Number. [max 10 characters] Customer Fax Number. [max 10 characters] Customer Contact. [Contact Object] Customer Sales Representative Code. [int] Customer Contract Number. [max 20 characters] Customer Contract Start Date. [smalldatetime] Customer Contract Expiry Date. [smalldatetime] Customer Alpha Search. [max 15 characters] Customer Pay Interest Flag. [bit] Customer Closed Date. [smalldatetime] Customer Credit Warning. [decimal] Customer Credit Limit. [decimal] 2 - 4 Delivery Point Carrier. [max 7 characters] Customer Tax Jurisdiction. [max 2 characters] Suspend Reason. [max 2 characters] Suspend Date. [smalldatetime] Currency. [int] Custom Field 1. [max 50 characters] Custom Field 2. [max 50 characters] Custom Field 3. [max 50 characters] Custom Field 4. [max 50 characters] Custom Field 5. [max 50 characters] Custom Field 6. [max 50 characters] Custom Field 7. [max 50 characters] Custom Field 8. [max 50 characters] Custom Field 9. [max 50 characters] Custom Field 10. [max 50 characters] Old Trux Customer Number. [max 15 characters] Purchase Order Number. [max 40 characters] Contract Signed. [bit] Invoice Note Expiry Date. [smalldatetime] Customer Bill To. [int] Customer Email. [max 80 characters] Cash On Demand. [bit] Broker. [int] Store ID. [max 50 characters] Lost to. [max 2 characters] Exemption Reason. [bit] Invoice Note. [max 500 characters] Reinstate Date. [smalldatetime] Overdue Letter flag. [bit] Initial Term. [int] Renewal Term. [int] Cash Account. [bit] Collection Agent. [max 2 characters] Global Suspend. [bit] Address Verification. [bit] Account Type. [int] Payment Terms. [int] Company code. [2 characters] Contra Receivables Items. [bit] Intercompany Customer. [bit] Customer Change log reason. [2 characters]Returns Customer Number for the created customer -
CreateHaulCustomerSurEx
Create Customer with Surcharge Exemption login company code [2 characters]. Customer Name. [max 40 characters] Customer Type. [max 2 characters] Customer Address 1. [max 40 characters] Customer Address 2. [max 40 characters] Customer Address 3. [max 40 characters] Customer Address 4. [max 40 characters] Customer City. [max 40 characters] Customer State. [max 2 characters] Customer Postal Code/Zip Code. [max 9 characters] Customer Phone Number. [max 10 characters] Customer Fax Number. [max 10 characters] Customer Contact. [Contact Object] Customer Sales Representative Code. [int] Customer Contract Number. [max 20 characters] Customer Contract Start Date. [smalldatetime] Customer Contract Expiry Date. [smalldatetime] Customer Alpha Search. [max 15 characters] Customer Pay Interest Flag. [bit] Customer Closed Date. [smalldatetime] Customer Credit Warning. [decimal] Customer Credit Limit. [decimal] 2 - 4 Delivery Point Carrier. [max 7 characters] Customer Tax Jurisdiction. [max 2 characters] Suspend Reason. [max 2 characters] Suspend Date. [smalldatetime] Currency. [int] Custom Field 1. [max 50 characters] Custom Field 2. [max 50 characters] Custom Field 3. [max 50 characters] Custom Field 4. [max 50 characters] Custom Field 5. [max 50 characters] Custom Field 6. [max 50 characters] Custom Field 7. [max 50 characters] Custom Field 8. [max 50 characters] Custom Field 9. [max 50 characters] Custom Field 10. [max 50 characters] Old Trux Customer Number. [max 15 characters] Purchase Order Number. [max 40 characters] Contract Signed. [bit] Invoice Note Expiry Date. [smalldatetime] Customer Bill To. [int] Customer Email. [max 80 characters] Cash On Demand. [bit] Broker. [int] Store ID. [max 50 characters] Lost to. [max 2 characters] Exemption Reason. [bit] Invoice Note. [max 500 characters] Reinstate Date. [smalldatetime] Overdue Letter flag. [bit] Initial Term. [int] Renewal Term. [int] Cash Account. [bit] Collection Agent. [max 2 characters] Global Suspend. [bit] Address Verification. [bit] Account Type. [int] Payment Terms. [int] Company code. [2 characters] Contra Receivables Items. [bit] Intercompany Customer. [bit] Customer Change log reason. [2 characters] Exempted Surcharge ID(Seperated by comma). [2 characters]Returns Customer Number for the created customer -
CreateUnassignedCallFromCSIssue
Creates an unassigned call that originated from a customer service issue. returns the logid of the created call. company code user that is logged in to the device current date/time [yyyy-MM-dd hh:mm:ss] customer number site number service number number of lifts for the new call cclog stuff - pass in 0 activity code for the new call reference for the new call work order number for the new call work order text for the new call issue that generated the new calllogid of the new call -
CreditLimitEnabled
Credit Limit Enabled login company code [2 characters]. Customer Number. [int]true if credit limit can be changed for the specified customer -
DeleteContact
Deletes a contact with the specified contact number Contact Number [int] Customer Number Site number login company code [2 characters]Returns true if success -
GetAccountTypes
Get Account Types defined in Code Maintenance Returns listing of Account Types ARPREFS_CODE Account Type Code ARPREFS_DESC Account Type Description
Field Name Description -
GetActivityRatesForExtraPickup
Get Activity Rates for specified Customer Account (Does not include Historic or Future Rates) Company Code [2 characters] Customer Number [int] Site Number [int] Service Number [int] Service Date [Date]Returns Activity Rates for specified Customer Account (Does not include Historic or Future Rates) CM12_CODE Activity Code [2 characters] CM12_DESC Activity Description CM12_UNIT Billing Unit CM19_RATE Billing Rate CM12_ACTIVE Active Flag CM12_STAGED Staged Activity Flag DEFAULTUNIT_DESC Unit Description DEFAULTUNIT_TYPE 0 for S V or P unit code, otherwise 1
Field Name Description -
GetAnnouncements
Returns a datatable containing announcements login company code [2 characters] Customer Number Site numberReturns List of Web announcements ANN01_ID Identity field ANN01_SUBJECT Subject of announcement ANN01_DETAIL Detail of announcement ANN01_CDTE Timestamp the announcement was created ANN01_CUSER The user who created or modified the announcement ANN01_ADTE Timestamp of the announcement was announced. ANN01_AUSER The user who send out the announcement. ANN01_EXPDTE Expiration date of announcement which indicate it wouldn’t be shown on the web portal. If null, means no expiration date. ANN01_EMAIL Email announcement ANN01_WEB Show announcement on web portal
Field Name Description -
GetAverageDaysToPay
Get Average Days To Pay for Customer Account Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded]Returns Average Days to Pay for Customer Account -
GetBillToTypes
Get Bill To Types defined in Code Maintenance Returns listing of Bill To Types BILLTOTYPES_CODE Bill To Type Code BILLTOTYPES_DESC Bill To Type Description
Field Name Description -
GetBillingCycleComb
Get Billing Cycles defined in Code Maintenance. Company Code [2 characters]Returns listing of Billing Cycles with following fields: CD17_CODE Billing Cycle Code [2 characters] CD17_DESC Billing Cycle Description CD17_ACTIVE Active ['True' = Active, 'False' = Inactive]
Field Name Description -
GetBrokers
Get Brokers defined in Code Maintenance Company Code [2 characters]Returns listing of Brokers BK01_ID Broker ID BK01_NAME Broker name BK01_HID Header ID BK01_HNAME Header name BK01_CLASSNAME Class name BK01_ACTIVE Broker Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetChangeReasons
Get Change Reasons defined in Code Maintenance Company Code [2 characters]Returns listing of Change Reasons CD12_CODE Change Reason Code CD12_DESC Change Reason Description CD12_ACTIVE Change Reason Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetCollectionAgents
Get Collection Agents defined in Code Maintenance Company Code [2 characters]Returns listing of Collection Agents CD52_CODE Collection Agent Code CD52_DESC Collection Agent Description CD52_ACTIVE Collection Agent Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetCompetitors
Get Competitors defined in Code Maintenance Company Code [2 characters]Returns listing of Competitors CD29_CODE Competitor Code CD29_DESC Competitor Description CD29_ACTIVE Competitor Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetContacts
Returns a table of contact for the specified customer/site Customer Number Site number login company code [2 characters]Returns listing of Contacts CC01_NUM Contact Number CC01_CUST Customer Number CC01_SITE Site Number CC01_SALU Salutation CC01_FNAME First Name CC01_MNAME Middle Name CC01_LNAME Last Name CC01_TITLE Title CC01_PHON Phone Number CC01_FAX Fax Number CC01_MOBILE Mobile Number CC01_EMAIL Email Address CC01_NOTE Note CC01_PEXT Phone Extension CC01_SHARED Shared Contact CC01_NOTIFICATION EN01_INVOICE Receives Invoice Notifications EN01_STATEMENT Receives Statement Notifications EN01_OVERDUELETTER Receives Overdue Letter Notifications EN01_CUSTOMERISSUE Receives Customer Issue Notifications EN01_ONLINEPAYMENTRECEIPT Receives Online Payment Receipt Notifications EN01_DISPOSALTICKETTRANSACTION Receives Disposal Ticket Transaction Notifications EN01_DISPOSALTICKET Receives Disposal Ticket Notifications EN01_WORKORDER Receives Work Order Notifications EN01_ANNOUNCEMENT Receives Announcement Notifications EN01_PRICEINCREASE Receives Price Increase Notifications EN01_NOTLETTERS Receives Route Modeling Notifications EN01_CREDITCARDEXPIRATION Receives Credit Card Expiration Notifications EN01_BILLOFLADING Receives Bill of Lading Notifications EN01_PRICEINCREASEWEIGHIT Receives Price Increase for Weigh-It Notifications
Field Name Description -
GetCredit
Returns a datatable containing announcements login company code [2 characters] Customer Number Site numberReturns List of Web announcements ANN01_ID Identity field
Field Name Description -
GetCreditLimit
Get the credit limit for the specified customer Company Code [2 characters] Customer Number [int] Site Number [int]The credit limit -
GetCreditWarning
Get the credit warning for the specified customer Company Code [2 characters] Customer Number [int] Site Number [int]The credit warning -
GetCurrencies
Get Currencies defined in Code Maintenance Company Code [2 characters]Returns listing of Currencies CD08_CODE Currency Code CD08_DESC Currency Description CD08_ACTIVE Currency Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetCust
Get Customer Account Detail information. Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded]Returns Detail information for Customer Level if Site Number = '0' with follwing fields: CM03_CUST Customer Number [Max 10 characters] CM03_NAME Customer Name CM03_CUSTTYPE Customer Type CM03_ADD1 Address Line 1 CM03_ADD2 Address Line 2 CM03_ADD3 Address Line 3 CM03_ADD4 Address Line 4 CM03_CITY City CM03_STAT State/Province CM03_PZIP Zip/Postal Code CM03_PHON Phone Number CM03_FAX Fax Number CM03_CONT Primary Contact ID CM03_SREP Sales Representative Code [2 characters] CM03_AGRE Contract Number CM03_ADTE Contract Start Date CM03_XDTE Contract Expiration Date CM03_ALPH Alpha Sort CM03_ICHG Pay Interest ['0' = **#** , '1' =] CM03_CDTE Closed Date CM03_CRED Credit Limit CM03_WARN Credit Warning CM03_CARR Carrier (Weigh-IT only) CM03_TXJU Tax Jurisdiction [2 characters] CM03_SUSREA Suspend Reason [2 characters] CM03_SUSDATE Suspend Date CM03_CCARDTYPE Credit Card Type [2 characters] CM03_CCARDNUM Credit Card Number CM03_CCARDEXP Credit Card Expiration Date CM03_CURR Currency [Max 3 characters] CM03_INVNOTE Invoice Note CM03_INVNOTEEXPIRES Invoice Note Expiration Date CM03_FLD1 Custom Field 1 CM03_FLD2 Custom Field 2 CM03_FLD3 Custom Field 3 CM03_FLD4 Custom Field 4 CM03_FLD5 Custom Field 5 CM03_FLD6 Custom Field 6 CM03_FLD7 Custom Field 7 CM03_FLD8 Custom Field 8 CM03_FLD9 Custom Field 9 CM03_FLD10 Custom Field 10 CM03_OLDCUST Old TRUX Customer Number CM03_PCLASS Price Class ID CM03_PONUM Purchase Order Number CM03_CONTRACTSIGNED Contract Signed ['True' = Signed, 'False' = Unsigned] CM03_BILLTO Bill To Type ['0' = Consolidated, '1' = AR Customer, '2' = AR Site] CM03_EMAIL Email CM03_COD Cash On Demand ['0' = COD, '1' = Non COD] CM03_BROKE Broker [2 characters] CM03_STOREID Store ID CM03_SURCHARGEEXEMPTION Surcharge Exemption ['0' = Not Exempt, '1' = Exempt] CM03_LOST Lost To [2 characters] CM03_EREA Exemption Reason [2 characters] CM03_ODUL Overdue Letter ['0' = Does Not Receive, '1' = Receives Overdue Letter] CM03_REINSTATE Reinstate Date CM03_INVACTION Invoice Action [2 characters] CM03_SCALENOTE Scale Note (Weigh-IT Only) CM03_DEFPC Default Price Class ID CM03_NATIONAL National Account ['0' = Non-National Account, '1' = National Account] CM03_INITIALTERM Initial Term CM03_RENEWTERM Renewal Term CM03_CASHACCT Cash Account ['0' = Non-Cash Account, '1' = Cash Account] primaryContactName Primary Contact Name CC01_PHON Contact Phone CC01_MOBILE Contact Mobile CC01_EMAIL Contact Email
Field Name Description CM04_CUST Customer Number [Max 10 characters] CM04_SITE Site Number [Max 4 characters] CM04_NAME Site Name CM04_ANUM Address Number CM04_UNIT Site Unit Number CM04_SPFX Site Street Prefix CM04_ROAD Site Road Name CM04_NESW Site Direction CM04_ADD2 Address Line 2 CM04_ADD3 Address Line 3 CM04_ADD4 Address Line 4 CM04_ADD5 Address Line 5 CM04_CITY City CM04_STAT State [2 characters] CM04_PZIP Postal/Zip Code CM04_PHON Phone Number CM04_FAX Fax Number CM04_CONT Primary Contact ID CM04_BUCD Business Code [2 characters] CM04_NOT1 Note 1 CM04_PRT1 Note 1 Print ['0' = Does Not Print, '1' = Print] CM04_NOT2 Note 2 CM04_PRT2 Note 2 Print ['0' = Does Not Print, '1' = Print] CM04_MAP Map Code [Max 3 characters] CM04_MCOL Map Column Number ['1' to '26'] CM04_MROW Map Row Number ['A' to 'Z') CM04_MNAM Mailing Name CM04_MAD1 Mailing Address Line 1 CM04_MAD2 Mailing Address Line 2 CM04_MAD3 Mailing Address Line 3 CM04_MAD4 Mailing Address Line 4 CM04_MCIT Mailing City CM04_MSTA Mailing State/Province CM04_MPZI Mailing Postal/Zip Code CM04_MCAR Mailing Delivery/Carrier [Max 4 characters Delivery and 2 characters Carrier] CM04_TXJU Tax Jurisdiction [2 characters] CM04_TXE1 Tax Exempt License 1 CM04_TXE2 Tax Exempt License 2 CM04_EDTE Closed Date CM04_CRED Credit Limit CM04_WARN Credit Warning CM04_AGRE Contract Number CM04_LONG Longitude CM04_LATT Latitude CM04_SUSREA Suspend Reason [2 characters] CM04_SUSDATE Suspend Date CM04_CCARDTYPE Credit Card Type [2 characters] CM04_CCARDNUM Credit Card Number CM04_CCARDEXP Credit Card Expiration Date CM04_CURR Currency [Max 3 characters] CM04_INVNOTE Invoice Note CM04_INVNOTEEXPIRES Invoice Note Expiration Date CM04_FLD1 Custom Field 1 CM04_FLD2 Custom Field 2 CM04_FLD3 Custom Field 3 CM04_FLD4 Custom Field 4 CM04_FLD5 Custom Field 5 CM04_FLD6 Custom Field 6 CM04_FLD7 Custom Field 7 CM04_FLD8 Custom Field 8 CM04_FLD9 Custom Field 9 CM04_FLD10 Custom Field 10 CM04_PCLASS Price Class ID CM04_ADTE Contract Date CM04_XDTE Contract Expiration Date CM04_PONUM Purchase Order Number CM04_CONTRACTSIGNED Contract Signed ['0' = Not Signed, '1' = Signed] CM04_EMAIL Email CM04_STIM Service Between Start Time CM04_ETIM Service Between End Time CM04_SREP Sales Representative CM04_STOREDID Store ID CM04_WOCOPIES Number of Work Order Copies to Print CM04_COD Cash On Demand ['0' = COD, '1' = Non COD] CM04_LOST Lost To [2 characters] CM04_INITALTERM Initial Term CM04_RENEWTERM Renewal Term primaryContactName Primary Contact Name CC01_PHON Contact Phone CC01_MOBILE Contact Mobile CC01_EMAIL Contact Email
Field Name Description -
GetCustIssueDetail
Get Customer Issue Details for specified Issue Number Company Code [2 characters] Issue NumberReturns Customer Issue Details for specified Issue Number CM03_NAME Customer Name CM04_NAME Site Name siteAddress Site Address serviceDesc Service Description CD18_DESC Issue Type CD19_DESC Issue Urgency email Email RM01_FULLDESC Full Route Description USER_DESC User Name SC01_CALL Issue Number SC01_CUST Customer Number [Max 10 characters] SC01_SITE Site Number [Max 4 characters] SC01_SERV Service Number [Max 3 characters] SC01_MISC Customer Name SC01_NAME Caller Name SC01_DREC Date Received SC01_DMOD Date Modified SC01_DCLO Date Closed SC01_UREC Received By [10 character User ID] SC01_UMOD Last Modified By [10 character User ID] SC01_UCLO Closed By [10 character User ID] SC01_PROB Issue Problem SC01_TYPE Issue Type Code [2 characters] SC01_URGN Urgency Code [2 characters] SC01_CMNT Comment SC01_MESG Notification Number SC01_ROUT Route Number [4 digits] SC01_SDTE Service Date SC01_PDTE Promise Date SC01_PHON Telephone Number SC01_SCHEDULEDCALL Scheduled Call ID SC01_UAGN User Assigned [10 character User ID]
Field Name Description -
GetCustomerIssueRoutes
Get Customer Issue Routes for new customer issue. Company Code [2 characters] Customer Number [int] Site Number [int] Service Number [int] Scheduled Date [smalldatetime]Returns listing of Routes SrcTbl Source of Route information ROUTE Route Number RM01_FULLDESC Route Description
Field Name Description -
GetCustomerIssueSequenceNumbers
Get Customer Issue Sequence Numbers Company Code [2 characters] Source Table Name [string] Customer Number [int] Site Number [int] Service Number [int] Scheduled Date [smalldatetime]Returns Sequence Numbers RTE_DTE Scheduled Date SEQU Sequence / Call Number LOGID Log ID
Field Name Description -
GetCustomerTypes
Get Customer Types defined in Code Maintenance Company Code [2 characters]Returns listing of Customer Types CD11_CODE Customer Type Code CD11_DESC Customer Type Description CD11_ACTIVE Customer Type Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetDefaultPriceClasses
Get DefaultPrice Classes defined in Code Maintenance Company Code [2 characters]Returns listing of DefaultPrice Classes PC01_ID DefaultPrice Class Code PC01_NAME DefaultPrice Class Description PC01_ACTIVE DefaultPrice Class Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetDisposalTicketAverageWeightForComp
Get Average Disposal Ticket Weight based on specified parameters Company Code [2 characters] User ID [10 characters unpadded] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded] Start Date End DateReturns Average Disposal Ticket Weight based on specified parameters CUST No. Customer Number [Max 10 characters] SITE Site Number [Max 4 characters] SERV. Service Number [Max 3 characters] DISPOSAL AMT. Total Disposal Amount in Tons [E.g. 123.46TN] TOTAL TICKETS Number of Tickets AVG. WEIGHT Average Weight in Tons [E.g. 123.46TN]
Field Name Description -
GetExemptionReasons
Get Exemption Reasons defined in Code Maintenance Company Code [2 characters]Returns listing of Exemption Reasons CD31_CODE Exemption Reason Code CD31_DESC Exemption Reason Description CD31_ACTIVE Exemption Reason Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetInvoiceActions
Get Invoice Actions defined in Code Maintenance Company Code [2 characters]Returns listing of Invoice Actions CD35_CODE Invoice Action Code CD35_DESC Invoice Action Description CD35_ACTIVE Invoice Action Activity Flag ['0' = Inactive, '1' = Active] CD35_ATCHTICK Attach Disposal Tickets to Invoice ['0' = False, '1' = True]
Field Name Description -
GetIssue
Gets one customer service issue based on an existing issue number. the id of the issue to get true if images are to be included in the return object true if notes are to be included in the return object list of ids associated with images that already exist on the device for the given issue company codethe requested customer service issue object -
GetIssueList
Get all Customer Issues for specified Customer Account Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded]Returns all Customer Issues for specified Customer Account SC01_CALL Issue Number SC01_CUST Customer Number [Max 10 characters] SC01_SITE Site Number [Max 4 characters] SC01_SERV Service Number [Max 3 characters] SC01_MISC Customer Name SC01_NAME Caller Name SC01_DREC Date Received SC01_DMOD Date Modified SC01_DCLO Date Closed SC01_UREC Received By [10 character User ID] SC01_UMOD Last Modified By [10 character User ID] SC01_UCLO User Closed By [10 character User ID] SC01_PROB Problem SC01_TYPE Issue Type [2 characters] SC01_URGN Urgency Code [2 characters] SC01_CMNT Comment SC01_MESG Notification Number SC01_ROUT Route Number [4 digits] SC01_SDTE Service Date SC01_PDTE Promise Date SC01_PHON Telephone Number SC01_SCHEDULEDCALL Call Scheduled [Scheduled Call ID] SC01_UAGN User Assigned [10 character User ID] SITE Site Name URGENCY Issue Urgency TYPE Issue Type DATER Date Received DATEP Promise Date
Field Name Description -
GetIssueRouteComb
Get all Route Numbers and Descriptions Company Code [2 characters]Returns all Route Numbers and Descriptions RM01_NUM Route Number [4 digits] RM01_DESC Description RM01_FULLDESC Full Description
Field Name Description -
GetIssueType
Get Customer Issue Types defined in Code Maintenance Company Code [2 characters]Returns listing of Customer Issue Types CD18_CODE Service Call Type Code [2 characters] CD18_DESC Description CD18_ACTIVE Active ['0' = Inactive , '1' = Active ]
Field Name Description -
GetIssueUrgency
Get Issue Urgencies defined in Code Maintenance Company Code [2 characters]Returns listing of Urgency Codes CD19_CODE Urgency Code [2 characters] CD19_DESC Description CD19_ACTIVE Active ['0' = Inactive , '1' = Active ]
Field Name Description -
GetLastPaymentDate
Get Last Payment Date for Customer Account Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded]Returns Last Payment Date for Customer Account -
GetLatestIssue
Get Most Recent Customer Issue Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded]Returns Most Recent Customer Issue SC01_CALL Issue Number SC01_CUST Customer Number [Max 10 characters] SC01_SITE Site Number [Max 4 characters] SC01_SERV Service Number [Max 3 characters] SC01_MISC Customer Name SC01_NAME Caller Name SC01_DREC Date Received SC01_DMOD Date Modified SC01_DCLO Date Closed SC01_UREC Received By [10 character User ID] SC01_UMOD Last Modified By [10 character User ID] SC01_UCLO User Closed By [10 character User ID] SC01_PROB Problem SC01_TYPE Issue Type [2 characters] SC01_URGN Urgency Code [2 characters] SC01_CMNT Comment SC01_MESG Notification Number SC01_ROUT Route Number [4 digits] SC01_SDTE Service Date SC01_PDTE Promise Date SC01_PHON Telephone Number SC01_SCHEDULEDCALL Call Scheduled [Scheduled Call ID] SC01_UAGN User Assigned [10 character User ID] SITE Site Name URGENCY Issue Urgency TYPE Issue Type DATER Date Received DATEP Promise Date
Field Name Description -
GetMailGroups
Gets a list of mail groups a list of mail groups -
GetNewAnnouncementsCount
Returns the number of unread announcements login company code [2 characters] Customer Number Site numberReturns the number of unread announcements -
GetNewIssues
Gets a list of customer service issues based on user. company code code of the logged in user Number of days of resolved issues the user wants to see a list of exising issue id's and corresponding dates format issue#~resolved date true if images should be included in the return object true if notes should be included in the return objectA list of new issues for the given user -
GetNextServiceDate
Get Next Service Date for Customer Account Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded]Returns Next Service Date for Customer Account -
GetNotificationSettings
Gets list of notification settings login company code [2 characters]List of notification settings EMAILNOTIFICATION_ID Document Type ID EMAILNOTIFICATION_DOCUMENTTYPE Document Type Description EMAILNOTIFICATION_ACTIVE Notification is Enabled EMAILNOTIFICATION_ATTACHTOINVOICE Attach document to invoice EMAILNOTIFICATION_EMAILSUBJECT Email Subject EMAILNOTIFICATION_EMAILBODY Email Body EMAILNOTIFICATION_HAULIT Setting Applies to Haul-It EMAILNOTIFICATION_WEIGHIT Setting Applies to Weigh-It EMAILNOTIFICATION_MAINTAINIT Setting Applies to Maintain-It EMAILNOTIFICATION_CANATTACHTOINVOICE Document Type can be attached to invoices EMAILNOTIFICATION_CATEGORY Document Type Category [1 = billing, 2 = production] EMAILNOTIFICATION_MAILSERVER_FROMADDRESS Email From Address EMAILNOTIFICATION_MAILSERVER_USERNAME Email Username EMAILNOTIFICATION_MAILSERVER_PASSWORD Email Password [Encrypted] EMAILNOTIFICATION_MAILSERVER_PASSWORDIV Email Password IV
Field Name Description -
GetPopupMessages
Get popup messages for current issue. company code issue number to get popup messages fora list of popup messages for the given parameters -
GetRoutedCalls
Get Routed Calls for specified Customer Account Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded]Returns listing of Routed Calls for specified Customer Account SITE Site Number [Max 4 characters] SERVICE Routed [Max 3 characters] SIZE Service Size and Unit of Measure [E.g. 20 YD] TYPE Route Type FIRSTDAY Day of Week [E.g. 1 = Monday, 2 = Tuesday etc.] ROUTE Route Number and Description RM02_SEQU Sequence ACTIVITY Activity Description QUANTITY Quantity RM02_NUMB Route Number [4 digits] CALLID TRUX Internal Reference WEEKCODE_DESC Week Code Descriprion RM05_TIM2 End Time RM18_DATE Unsequence Date STATUS TRUX Internal Reference SITESERV Site Number and Service Number [E.g. 1111-222] ROUTED Routed ['0' = Not Routed, '1' = Routed] DAY Day of Week Description SEQUENCE Sequence Number [E.g. '1.0', '2.1','Unsequenced', etc.] CALLNUMB TRUX Internal Reference
Field Name Description -
GetRoutesAndSequences
Get routes based on cust-site-service-date company code customer number site number service number route date [yyyy-MM-dd]a table of routes and sequences for the given cust/site/sequence on the given day ROUTE route number RM01_DESC route description SEQUENCE sequence number~logid
Value Description -
GetSalesReps
Get Sales Reps defined in Code Maintenance Company Code [2 characters]Returns listing of Sales Reps CD07_CODE Sales Rep Code CD07_DESC Sales Rep Description CD07_ACTIVE Sales Rep Activity Flag ['0' = Inactive, '1' = Active] CD07_COMMTYPE Commission Type CD07_USERID User ID CD07_ADD1 Address 1 CD07_ADD2 Address 2 CD07_ADD3 Address 3 CD07_CITY City CD07_STAT State/Province CD07_PZIP Zip/Postal Code CD07_PHON Phone Number CD07_CELL Cell Phone Number CD07_EMAIL Email address CD07_SDTE Start Date CD07_EDTE End Date CD07_MANAGEBY Manager is
Field Name Description -
GetServTypeComb
Get Service Type defined in Code Maintenance. Company Code [2 characters]Returns listing of Service Types CD05_CODE Service Code [2 characters] CD05_DESC Description CD05_ACTIVE Active ['0' = Inactive , '1' = Active ] CD05_UOM Default Unit of Measure CD05_CPCTRATIO Compaction Ratio CD05_MATL Default Material [2 characters
Field Name Description -
GetServiceActivityRates
Get Activity Rates for specified Customer Account (Does not include Historic or Future Rates) Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded] Service Date [Date]Returns Activity Rates for specified Customer Account (Does not include Historic or Future Rates) CM19_CUST Customer Number [Max 10 characters] CM19_SITE Site Number [Max 4 characters] CM19_SERV Service Number [Max 3 characters] CM19_ACTV Activity Code [2 characters] CM19_UNIT Billing Unit CM19_RATE Billing Rate CM19_DESC Invoice Description CM19_EFFD Effective Date CM19_BILL Bill Up To Date CM19_ID Activity Rate ID
Field Name Description -
GetServiceCurrentActivityRates
Get Activity Rates for specified Customer Account (Does not include Historic or Future Rates) Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded]Returns Activity Rates for specified Customer Account (Does not include Historic or Future Rates) CM19_CUST Customer Number [Max 10 characters] CM19_SITE Site Number [Max 4 characters] CM19_SERV Service Number [Max 3 characters] CM19_ACTV Activity Code [2 characters] CM19_UNIT Billing Unit CM19_RATE Billing Rate CM19_DESC Invoice Description CM19_EFFD Effective Date CM19_BILL Bill Up To Date CM19_ID Activity Rate ID
Field Name Description -
GetServiceDetail
Get Active Service Details for specified Customer Number, Site Number and Service Number Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded]Returns Service Details for specified Customer Number, Site Number and Service Number CUST Customer Number [Max 10 characters] SITE Site Number [Max 4 characters] SERV Service Number [Max 3 characters] COMPACT Compacted Container ['0' = Non-Compacted , '1' = Compacted ] EXPIRY Service Expiration Date SUSPEND Service Suspend Date NAME Name ADDRESS Address STOPPED Service Stopped ['0' = Not Stopped , '1' = Stopped] SUSPENDED Service Suspended ['0' = Not Suspended, '1' = Suspended] QTY Quantity SIZE Size UOM Unit of Measure WEEK Week Code [2 characters] SERVTYPE Service Type [2 characters] WEEKCODE Week Code [2 characters] MAXLIFTS Maximum Lifts STOPREASON Stop Reason [2 characters] WEEKCODEDESC Week Code Description CM05_CUST Customer Number [Max 10 characters] CM05_SITE Site Number [Max 4 characters] CM05_SERV Service Number [Max 3 characters] CM05_TYPE Service Type [2 characters] CM05_SIZE Size CM05_COMP Compacted Container ['0' = Non-Compacted , '1' = Compacted ] CM05_QTY Quantity CM05_SDTE Start Date CM05_WEEK Week Code [2 characters] CM05_NOT1 Note 1 CM05_PRT1 Note 1 Print ['0' = Does Not Print, '1' = Print] CM05_NOT2 Note 2 CM05_PRT2 Note 2 Print ['0' = Does Not Print, '1' = Print] CM05_EDTE Stop Date CM05_ECOD Stop Reason Code [2 characters] CM05_MAXL Maximum Lifts per Week CM05_CYCL Billing Cycle CM05_W_O Print Work Order ['0' = Does Not Print, '1' = Print] CM05_BDTE Start Billing Date CM05_AVGT Average Call Time CM05_COWN Customer Owned ['0' = Not Owned, '1' = Owned] CM05_FLD1 Custom Field 1 CM05_FLD2 Custom Field 2 CM05_FLD3 Custom Field 3 CM05_FLD4 Custom Field 4 CM05_FLD5 Custom Field 5 CM05_FLD6 Custom Field 6 CM05_FLD7 Custom Field 7 CM05_FLD8 Custom Field 8 CM05_FLD9 Custom Field 9 CM05_FLD10 Custom Field 10 CM05_UOM Unit of Measure CM05_DRIVERNOTE Driver Note CM05_DRIVERNOTESTART Driver Note Start Date CM05_DRIVERNOTEEXPIRES Driver Note Expiration CM05_AGRE Contract Number CM05_ADTE Contract Start Date CM05_XDTE Contract Expiration Date CM05_CONTRACTSIGNED Contract Signed ['0' = Not Signed, '1' = Signed] CM05_BILLTODT Bill To Date CM05_POREQ Purchase Order Required ['0' = PO Not Required, '1' = PO Required] CM05_PONUM PO Number CM05_LATT Latitude CM05_LONG Longitude CM05_DEMDAYS Demurrage Days CM05_DEMRATE Demurrage Daily Rate CM05_GDTE Price Guarantee Date CM05_DEMDATE Demurrage Date CM05_DEMDATEO Previous Demurrage Date CM05_REINSDATE Reinstate Date CM05_LOST Lost To [2 characters CM05_INITIALTERM Initial Term CM05_RENEWTERM Renewal Term CD17_DESC Billing Cycle Description Schedule Schedule Date
Field Name Description -
GetServiceDetailWithFilter
Get Service Details for specified Customer Number, Site Number and Service Number Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded] Include suspended services flag [bool]Returns Service Details for specified Customer Number, Site Number and Service Number CUST Customer Number [Max 10 characters] SITE Site Number [Max 4 characters] SERV Service Number [Max 3 characters] COMPACT Compacted Container ['0' = Non-Compacted , '1' = Compacted ] EXPIRY Service Expiration Date SUSPEND Service Suspend Date NAME Name ADDRESS Address STOPPED Service Stopped ['0' = Not Stopped , '1' = Stopped] SUSPENDED Service Suspended ['0' = Not Suspended, '1' = Suspended] QTY Quantity SIZE Size UOM Unit of Measure WEEK Week Code [2 characters] SERVTYPE Service Type [2 characters] WEEKCODE Week Code [2 characters] MAXLIFTS Maximum Lifts STOPREASON Stop Reason [2 characters] WEEKCODEDESC Week Code Description CM05_CUST Customer Number [Max 10 characters] CM05_SITE Site Number [Max 4 characters] CM05_SERV Service Number [Max 3 characters] CM05_TYPE Service Type [2 characters] CM05_SIZE Size CM05_COMP Compacted Container ['0' = Non-Compacted , '1' = Compacted ] CM05_QTY Quantity CM05_SDTE Start Date CM05_WEEK Week Code [2 characters] CM05_NOT1 Note 1 CM05_PRT1 Note 1 Print ['0' = Does Not Print, '1' = Print] CM05_NOT2 Note 2 CM05_PRT2 Note 2 Print ['0' = Does Not Print, '1' = Print] CM05_EDTE Stop Date CM05_ECOD Stop Reason Code [2 characters] CM05_MAXL Maximum Lifts per Week CM05_CYCL Billing Cycle CM05_W_O Print Work Order ['0' = Does Not Print, '1' = Print] CM05_BDTE Start Billing Date CM05_AVGT Average Call Time CM05_COWN Customer Owned ['0' = Not Owned, '1' = Owned] CM05_FLD1 Custom Field 1 CM05_FLD2 Custom Field 2 CM05_FLD3 Custom Field 3 CM05_FLD4 Custom Field 4 CM05_FLD5 Custom Field 5 CM05_FLD6 Custom Field 6 CM05_FLD7 Custom Field 7 CM05_FLD8 Custom Field 8 CM05_FLD9 Custom Field 9 CM05_FLD10 Custom Field 10 CM05_UOM Unit of Measure CM05_DRIVERNOTE Driver Note CM05_DRIVERNOTESTART Driver Note Start Date CM05_DRIVERNOTEEXPIRES Driver Note Expiration CM05_AGRE Contract Number CM05_ADTE Contract Start Date CM05_XDTE Contract Expiration Date CM05_CONTRACTSIGNED Contract Signed ['0' = Not Signed, '1' = Signed] CM05_BILLTODT Bill To Date CM05_POREQ Purchase Order Required ['0' = PO Not Required, '1' = PO Required] CM05_PONUM PO Number CM05_LATT Latitude CM05_LONG Longitude CM05_DEMDAYS Demurrage Days CM05_DEMRATE Demurrage Daily Rate CM05_GDTE Price Guarantee Date CM05_DEMDATE Demurrage Date CM05_DEMDATEO Previous Demurrage Date CM05_REINSDATE Reinstate Date CM05_LOST Lost To [2 characters CM05_INITIALTERM Initial Term CM05_RENEWTERM Renewal Term CD17_DESC Billing Cycle Description Schedule Schedule Date
Field Name Description -
GetServiceList
Get Details for all active Services for specified Customer Number and Site Number Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded]Returns Details for all Services for specified Customer Number and Site Number CUST Customer Number [Max 10 characters] SITE Site Number [Max 4 characters] SERV Service Number [Max 3 characters] COMPACT Compacted Container ['0' = Non-Compacted , '1' = Compacted ] EXPIRY Service Expiration Date SUSPEND Service Suspend Date NAME Name ADDRESS Address STOPPED Service Stopped ['0' = Not Stopped , '1' = Stopped] SUSPENDED Service Suspended ['0' = Not Suspended, '1' = Suspended] QTY Quantity SIZE Size UOM Unit of Measure WEEK Week Code [2 characters] SERVTYPE Service Type [2 characters] WEEKCODE Week Code [2 characters] MAXLIFTS Maximum Lifts STOPREASON Stop Reason [2 characters] WEEKCODEDESC Week Code Description CM05_CUST Customer Number [Max 10 characters] CM05_SITE Site Number [Max 4 characters] CM05_SERV Service Number [Max 3 characters] CM05_TYPE Service Type [2 characters] CM05_SIZE Size CM05_COMP Compacted Container ['0' = Non-Compacted , '1' = Compacted ] CM05_QTY Quantity CM05_SDTE Start Date CM05_WEEK Week Code [2 characters] CM05_NOT1 Note 1 CM05_PRT1 Note 1 Print ['0' = Does Not Print, '1' = Print] CM05_NOT2 Note 2 CM05_PRT2 Note 2 Print ['0' = Does Not Print, '1' = Print] CM05_EDTE Stop Date CM05_ECOD Stop Reason Code [2 characters] CM05_MAXL Maximum Lifts per Week CM05_CYCL Billing Cycle CM05_W_O Print Work Order ['0' = Does Not Print, '1' = Print] CM05_BDTE Start Billing Date CM05_AVGT Average Call Time CM05_COWN Customer Owned ['0' = Not Owned, '1' = Owned] CM05_FLD1 Custom Field 1 CM05_FLD2 Custom Field 2 CM05_FLD3 Custom Field 3 CM05_FLD4 Custom Field 4 CM05_FLD5 Custom Field 5 CM05_FLD6 Custom Field 6 CM05_FLD7 Custom Field 7 CM05_FLD8 Custom Field 8 CM05_FLD9 Custom Field 9 CM05_FLD10 Custom Field 10 CM05_UOM Unit of Measure CM05_DRIVERNOTE Driver Note CM05_DRIVERNOTESTART Driver Note Start Date CM05_DRIVERNOTEEXPIRES Driver Note Expiration CM05_AGRE Contract Number CM05_ADTE Contract Start Date CM05_XDTE Contract Expiration Date CM05_CONTRACTSIGNED Contract Signed ['0' = Not Signed, '1' = Signed] CM05_BILLTODT Bill To Date CM05_POREQ Purchase Order Required ['0' = PO Not Required, '1' = PO Required] CM05_PONUM PO Number CM05_LATT Latitude CM05_LONG Longitude CM05_DEMDAYS Demurrage Days CM05_DEMRATE Demurrage Daily Rate CM05_GDTE Price Guarantee Date CM05_DEMDATE Demurrage Date CM05_DEMDATEO Previous Demurrage Date CM05_REINSDATE Reinstate Date CM05_LOST Lost To [2 characters CM05_INITIALTERM Initial Term CM05_RENEWTERM Renewal Term CD17_DESC Billing Cycle Description Schedule Schedule Date
Field Name Description -
GetServiceListWithDate
Get active Service Headers and Last and Next Service Date for specified Customer Number and Site Number. Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded]Returns Service Headers and Last and Next Service Date for specified Customer Number and Site Number. Service Service Number [Max 3 characters] Description Service Type Code [2 characters] Size Size Qty Quantity Schedule Schedule Next Pickup Date Next Pickup Date Last Activity Date Last Activity Date
Field Name Description -
GetServiceListWithDateWithFilter
Get Service Headers and Last and Next Service Date for specified Customer Number and Site Number. Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Include closed services flag [bool]Returns Service Headers and Last and Next Service Date for specified Customer Number and Site Number. Service Service Number [Max 3 characters] Description Service Type Code [2 characters] Size Size Qty Quantity Schedule Schedule Next Pickup Date Next Pickup Date Last Activity Date Last Activity Date
Field Name Description -
GetSites
Get Details for all Sites for specified Customer Number Company Code [2 characters] Customer Number [10 digits, unpadded]Returns Details for all Sites for specified Customer Number CM04_CUST Customer Number [Max 10 characters] CM04_SITE Site Number [Max 4 characters] CM04_NAME Site Name CM04_ANUM Address Number CM04_UNIT Site Unit Number CM04_SPFX Site Street Prefix CM04_ROAD Site Road Name CM04_NESW Site Direction CM04_ADD2 Address Line 2 CM04_ADD3 Address Line 3 CM04_ADD4 Address Line 4 CM04_ADD5 Address Line 5 CM04_CITY City CM04_STAT State [2 characters] CM04_PZIP Postal/Zip Code CM04_PHON Phone Number CM04_FAX Fax Number CM04_CONT Primary Contact ID CM04_BUCD Business Code [2 characters] CM04_NOT1 Note 1 CM04_PRT1 Note 1 Print ['0' = Does Not Print, '1' = Print] CM04_NOT2 Note 2 CM04_PRT2 Note 2 Print ['0' = Does Not Print, '1' = Print] CM04_MAP Map Code [Max 3 characters] CM04_MCOL Map Column Number ['1' to '26'] CM04_MROW Map Row Number ['A' to 'Z') CM04_MNAM Mailing Name CM04_MAD1 Mailing Address Line 1 CM04_MAD2 Mailing Address Line 2 CM04_MAD3 Mailing Address Line 3 CM04_MAD4 Mailing Address Line 4 CM04_MCIT Mailing City CM04_MSTA Mailing State/Province CM04_MPZI Mailing Postal/Zip Code CM04_MCAR Mailing Delivery/Carrier [Max 4 characters Delivery and 2 characters Carrier] CM04_TXJU Tax Jurisdiction [2 characters] CM04_TXE1 Tax Exempt License 1 CM04_TXE2 Tax Exempt License 2 CM04_EDTE Closed Date CM04_CRED Credit Limit CM04_WARN Credit Warning CM04_AGRE Contract Number CM04_LONG Longitude CM04_LATT Latitude CM04_SUSREA Suspend Reason [2 characters] CM04_SUSDATE Suspend Date CM04_CCARDTYPE Credit Card Type [2 characters] CM04_CCARDNUM Credit Card Number CM04_CCARDEXP Credit Card Expiration Date CM04_CURR Currency [Max 3 characters] CM04_INVNOTE Invoice Note CM04_INVNOTEEXPIRES Invoice Note Expiration Date CM04_FLD1 Custom Field 1 CM04_FLD2 Custom Field 2 CM04_FLD3 Custom Field 3 CM04_FLD4 Custom Field 4 CM04_FLD5 Custom Field 5 CM04_FLD6 Custom Field 6 CM04_FLD7 Custom Field 7 CM04_FLD8 Custom Field 8 CM04_FLD9 Custom Field 9 CM04_FLD10 Custom Field 10 CM04_PCLASS Price Class ID CM04_ADTE Contract Date CM04_XDTE Contract Expiration Date CM04_PONUM Purchase Order Number CM04_CONTRACTSIGNED Contract Signed ['0' = Not Signed, '1' = Signed] CM04_EMAIL Email CM04_STIM Service Between Start Time CM04_ETIM Service Between End Time CM04_SREP Sales Representative CM04_STOREDID Store ID CM04_WOCOPIES Number of Work Order Copies to Print CM04_COD Cash On Demand ['0' = COD, '1' = Non COD] CM04_LOST Lost To [2 characters] CM04_INITALTERM Initial Term CM04_RENEWTERM Renewal Term SITEINFO Site Address Summary (E.g. Site Number, Site Address, etc.)
Field Name Description -
GetSitesWithFilter
Get Details for all Sites for specified Customer Number Company Code [2 characters] Customer Number [10 digits, unpadded] Include closed sites flag [bool] Include suspended sites flag [bool]Returns Details for all Sites for specified Customer Number CM04_CUST Customer Number [Max 10 characters] CM04_SITE Site Number [Max 4 characters] CM04_NAME Site Name CM04_ANUM Address Number CM04_UNIT Site Unit Number CM04_SPFX Site Street Prefix CM04_ROAD Site Road Name CM04_NESW Site Direction CM04_ADD2 Address Line 2 CM04_ADD3 Address Line 3 CM04_ADD4 Address Line 4 CM04_ADD5 Address Line 5 CM04_CITY City CM04_STAT State [2 characters] CM04_PZIP Postal/Zip Code CM04_PHON Phone Number CM04_FAX Fax Number CM04_CONT Primary Contact ID CM04_BUCD Business Code [2 characters] CM04_NOT1 Note 1 CM04_PRT1 Note 1 Print ['0' = Does Not Print, '1' = Print] CM04_NOT2 Note 2 CM04_PRT2 Note 2 Print ['0' = Does Not Print, '1' = Print] CM04_MAP Map Code [Max 3 characters] CM04_MCOL Map Column Number ['1' to '26'] CM04_MROW Map Row Number ['A' to 'Z') CM04_MNAM Mailing Name CM04_MAD1 Mailing Address Line 1 CM04_MAD2 Mailing Address Line 2 CM04_MAD3 Mailing Address Line 3 CM04_MAD4 Mailing Address Line 4 CM04_MCIT Mailing City CM04_MSTA Mailing State/Province CM04_MPZI Mailing Postal/Zip Code CM04_MCAR Mailing Delivery/Carrier [Max 4 characters Delivery and 2 characters Carrier] CM04_TXJU Tax Jurisdiction [2 characters] CM04_TXE1 Tax Exempt License 1 CM04_TXE2 Tax Exempt License 2 CM04_EDTE Closed Date CM04_CRED Credit Limit CM04_WARN Credit Warning CM04_AGRE Contract Number CM04_LONG Longitude CM04_LATT Latitude CM04_SUSREA Suspend Reason [2 characters] CM04_SUSDATE Suspend Date CM04_CCARDTYPE Credit Card Type [2 characters] CM04_CCARDNUM Credit Card Number CM04_CCARDEXP Credit Card Expiration Date CM04_CURR Currency [Max 3 characters] CM04_INVNOTE Invoice Note CM04_INVNOTEEXPIRES Invoice Note Expiration Date CM04_FLD1 Custom Field 1 CM04_FLD2 Custom Field 2 CM04_FLD3 Custom Field 3 CM04_FLD4 Custom Field 4 CM04_FLD5 Custom Field 5 CM04_FLD6 Custom Field 6 CM04_FLD7 Custom Field 7 CM04_FLD8 Custom Field 8 CM04_FLD9 Custom Field 9 CM04_FLD10 Custom Field 10 CM04_PCLASS Price Class ID CM04_ADTE Contract Date CM04_XDTE Contract Expiration Date CM04_PONUM Purchase Order Number CM04_CONTRACTSIGNED Contract Signed ['0' = Not Signed, '1' = Signed] CM04_EMAIL Email CM04_STIM Service Between Start Time CM04_ETIM Service Between End Time CM04_SREP Sales Representative CM04_STOREDID Store ID CM04_WOCOPIES Number of Work Order Copies to Print CM04_COD Cash On Demand ['0' = COD, '1' = Non COD] CM04_LOST Lost To [2 characters] CM04_INITALTERM Initial Term CM04_RENEWTERM Renewal Term SITEINFO Site Address Summary (E.g. Site Number, Site Address, etc.)
Field Name Description -
GetStopReasonComb
Get Stop Reasons defined in Code Maintenance Company Code [2 characters]Returns listing of Stop Reason Codes CD03_DESC Description CD03_STOPBILL Stop Billing ['0' = Continue Billing, '1' = Stop Billing] CD03_NONPAY Non Payment Exception ['0' = No Exception, '1' = Exception] CD03_CREDIT Credit Advance Billing ['0' = Do not Credit, '1' = Credit Advanced Billing] CD03_ACTIVE Active ['0' = Inactive , '1' = Active ] CD03_REMOVE Remove from Route ['0' = Do Not Remove, '1' = Remove] CD03_LOST Lost to Competitor ['0' = Do Not Prompt, '1' = Prompt for Competitor] CD03_SEASONAL Seasonal ['0' = Non-Seasonal, '1' = Seasonal]
Field Name Description -
GetSurCharges
Get Surcharge List Company Code [2 characters]Returns listing of Surcharge SP01_ID Surcharge ID SP01_NAME Surcharge Description SP01_ACTIVE Surcharge Activity Flag ['0' = Inactive, '1' = Active] SP01_SORD Surcharge Type SP01_UOM UOM SP01_MULTIPLY Multiply by SP01_CODE Miscellaneous Transaction Surcharge SP01_DEFA Default surcharge SP01_MAXA Max Amount SP01_ZERO Charge on $0 transactions SP01_MINA Mim Amount SP01_MULTDB Multiply by Disposal QTY/Billing QTY(0 or null for Disposal QTY, 1 for Billing QTY) SP01_MATUOM Material UOMSP01_PAPER Paper Invoice SP04_CUST Customer for Surcharge Rate SP04_SITE Site for Surcharge Rate SP04_EFFD Surcharge Effective Date SP04_RATE Surcharge Rate SP04_RATETYPE Surcharge Rate Type
Field Name Description -
GetSuspendReasons
Get Suspend Reasons defined in Code Maintenance Company Code [2 characters]Returns listing of Suspend Reasons CD03_CODE Suspend Reason Code CD03_DESC Suspend Reason Description CD03_STOPBILL Stop Billing Flag ['0' = False, '1' = True] CD03_NONPAY Non Payment Exception Flag ['0' = False, '1' = True] CD03_CREDIT Credit Advance Billing Flag ['0' = False, '1' = True] CD03_ACTIVE Suspend Reason Activity Flag ['0' = Inactive, '1' = Active] CD03_REMOVE Remove from Route ['0' = False, '1' = True] CD03_LOST Lost to Competitor ['0' = False, '1' = True] CD03_SEASONAL Seasonal ['0' = False, '1' = True]
Field Name Description -
GetTaxJurisdictions
Get Tax Jurisdictions defined in Code Maintenance Company Code [2 characters]Returns listing of Tax Jurisdictions CD09_CODE Tax Jurisdiction Code CD09_DESC Tax Jurisdiction Description CD09_ACTIVE Tax Jurisdiction Activity Flag ['0' = Inactive, '1' = Active]
Field Name Description -
GetUsers
Gets a list of users that can login to the CRIssueAssist application. company codea list of users -
GetWorkOrders
Get customer work orders Company Code [2 characters] Customer Number [int] Site Number [int] Number of months to look back [int]Returns Sequence Numbers Date Scheduled Date Route# Route Number WO# Work Order Number Service Type Service Type Description QTY Number of Lifts Size Service Size Activity Activity Description Containers Assigned Containers List Reference Reference Driver Driver Name Finished Completion Status Table Scheduled Date CM05_CUST Customer CM05_SITE Site CM05_SERV Service CM05_TYPE Service Type RM03U_ACTV Activity Code driverNumber Driver ID LOGID Log ID
Field Name Description - HelloWorld
-
IsCashOnDemand
Returns true for cash on demand customer / sites, false otherwise. Company Code [2 characters] Customer Number [int] Site Number [int]True if cash on demand, false otherwise -
ResolveIssue
Resolve Issue Company Code [2 characters] Issue Number Closed By [10 character User ID] Reopen ['0' = Leave Closed, '1' = Reopen Issue]Success Flag -
SaveNewIssue
Save a new customer service issue. company code the customer service issue to savethe passed in issue with note and image ids generated from the haul-it database -
SendNotification
Notify selected users and groups of a customer service issue company code issue number that the notification is related to list of recipients for the notification subject of the notification priority of the notification Whether or not to include the customer master list notification message include system notes on the CS Issue report customer number site number service number user that sent the notificationsuccess -
UpdateContact
Update an existing contact Contact Object Customer Number Site number login company code [2 characters]Contact number for the contact updated, -1 if failure -
UpdateCreditLimit
Update Credit Limit login company code [2 characters]. Customer Number. [int] Site Number. [int] Credit Limit. [decimal]true if credit limit was updated successfully -
UpdateInvoiceEmailForComp
Update the Email Invoice To field Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Service Number [3 digits, unpadded]Success Flag -
UpdateIssue
Updates the issue that was passed in, populate issuenumber, promisedate, userAssigned, userModified, dateModified, userClosed, dateClosed, images and notes - Returns an object populated with ids for the new images and notes the issue object that will update the database company codethe issue that was passed in with updated image and note ids -
UpdateIssueByComp
Update Customer Issue by Issue Number for specified Company Company Code [2 characters] Issue Number Issue Type Urgency Code [2 characters] Caller Name Phone Promise Date Subject Detail Service Date Route Number [4 digits] Assign User [10 character User ID]Success Flag -
UpdateLocation
Update site location Company Code [2 characters] Customer Number [10 digits, unpadded] Site Number [4 digits, unpadded] Map code [2 characters] Customer Number [1 character] Customer Number [int] Latitude [double] Longitude [double] Customer Change log reason. [2 characters]Success Flag -
ValidateDomainLogin
Validates the domain login based on the trux user and domain password user code domain passwordreturns the stirng 'valid' if valid and a message if fail -
WS_GETCOMPANIES
Returns a list of companies found in SY03. A table filled with the companies requested. CODE Company Code NAME Company Name
Field Name Description -
WS_GETLIST
Returns a datatable containing data for a TRUX code table depending on the tableName parameter. Name of the table: LM01, LM04, RM04, TR01, CD18, CD22, CD04, CM12, LM05 Company the vehicle belongs to.A datatable filled with the fields from the requested table. The columns in the table vary depending on the table returned.