Billing Presentment - Query Client


Search client contacts in Billing Presentment database.

Variable Required Max Size Value Notes
publisher-name Mandatory NA Gateway account username issued to you.
publisher-password Mandatory NA Remote Client Password - This is different then the password used to login.
mode Mandatory NA query_client Value needs to be set to ‘query_client’
fuzzflg Optional 1 1 Match using partial info provided. (Assumes exact match when not specified)
email Optional 250 customer@domain.com Email address of customer (single email address only)
clientname Optional 40 Custoemr’s name to appear on invoice. [see Special Note #1]
clientcompany Optional 40 Customer’s company name to appear on invoice. [see Special Note #1]
clientaddr1 Optional 40 Customer’s address line 1 to appear on invoice. [see Special Note #1]
clientaddr2 Optional 40 Customer’s address line 2 to appear on invoice. [see Special Note #1]
clientcity Optional 40 Customer’s city to appear on invoice. [see Special Note #1]
clientstate Optional 2 Customer’s state to appear on invoice - in 2 char. state code format. [see Special Note #1]
clientzip Optional 14 Customer’s zip/postal code to appear on invoice. [see Special Note #1]
clientcountry Optional 2 Customer’s country to appear on invoice - in 2 char. format. [see Special Note #1
clientid Optional 250 Alphanumeric value generated by you Normally reserved for QuickBooks customer ID, when uploading BayState formatted invoice files.
alias Optional 24 Alphanumeric value generated by you Can be an alternative customer username/ID or what ever you wish to use to help identify/validate the client.

Notes:

Returns FinalStatus, MErrMsg, aux-msg, TranCount, resp-code, aXXXXX

aXXXXX contains email, clientcompany, clientname, clientaddr1, clientaddr2, clientstate, clientzip, clientcountry, clientid, alias