TDV Adapter for QuickBooks POS

Build 21.0.8137

CustomerRewards

Query QuickBooks POS Customer Rewards.

Table Specific Information

Select

QuickBooks Point of Sale allows many of the columns to be used in the WHERE clause of a SELECT query. These columns can create either Single or Range filters, as defined in the table schema.

Single Filters Single filters make direct comparisons by using the = comparison.
Range Filters Range filters can search only ranges that have an inclusive lower bound, specified by the >= operator, and an exclusive upper bound, specified by the < operator.

To apply a single bound to a string column that has the Range filter type, the = or LIKE operators are available.

To apply a single bound to a numeric or datetime column that has the Range filter type, the >, >=, <, <=, or = operators are available.


SELECT * FROM CustomerRewards WHERE FirstName LIKE '%George%' AND TimeModified >= '1/1/2014' AND TimeModified < '2/1/2014' AND AccountBalance > 100.00

Columns

Name Type Filter Type Description
ListID [KEY] String The unique identifier, generated by QuickBooks POS.
CustomerID String Range The user-specified Id for the customer.
FullName String The full name of the customer.
Salutation String Range A salutation, such as Mr., Mrs., etc.
FirstName String Range The first name of the customer as stated in the address info.
LastName String Range The last name of the customer as stated in the address info.
CompanyName String Range The name of the company of the customer.
Phone String Range The primary telephone number for the customer.
Phone2 String Range An alternate telephone or fax number for the customer.
Phone3 String Range An alternate telephone or fax number for the customer.
Email String Range The email address of the customer.
IsOkToEMail Boolean Single Whether or not the customer can be notified via email.
CustomerType String Range A customer type within QuickBooks POS.
Notes String Range Notes on this customer.
BillAddress_Street String Street address of the billing address of the customer.
BillAddress_Street2 String The second line of the street address of the billing address of the customer.
BillAddress_City String City name for the billing address of the customer.
BillAddress_State String State name for the billing address of the customer.
BillAddress_PostalCode String Postal code for the billing address of the customer.
BillAddress_Country String Country for the billing address of the customer.
IsNoShipToBilling Boolean Single Whether or not the billing address can be used as a shipping address.
IsAcceptingChecks Boolean Single Indicates whether checks are being accepted from this customer. The default is True.
IsUsingChargeAccount Boolean Single Indicates whether the customer is using a charge account.
StoreExchangeStatus String Single In multistore configurations, if the customer information has changed, this information is updated at the headquarters store. This response field indicates whether customer information was successfully updated or not. Possible values are Modified, Sent, and Acknowledged.
TaxCategory String Range The sales tax category.
CustomerDiscPercent Double Range The suggested customer discount percentage for all items listed on a sales receipt. Note that you cannot assign both a discount percentage and a price level to a customer.
CustomerDiscType String Single The customer discount type.
PriceLevelNumber String Single The suggested price level discount given to the customer. Note that you cannot assign both a discount percentage and a price level to a customer.
LastSale Datetime Range The time of the last purchase made by this customer.
AmountPastDue Decimal Range The amount past due for a transaction.
IsUsingWithQB Boolean Single Whether or not the customer is using QuickBooks POS with QuickBooks.
AccountBalance Decimal Range The balance of the account owned by this customer, including subcustomers. Available only when QuickBooks POS is being used with QuickBooks and only if UseWithQB is True.
AccountLimit Decimal Range The limit of the account owned by this customer, including subcustomers. Available only when QuickBooks POS is being used with QuickBooks and only if UseWithQB is True.
CustomFieldsOwnerID String Multi Identifies the owner of the CustomFields to be returned in the response. The default value of '0' is sent which refers to a public custom field that is exposed in the QuickBooks POS UI. All other values are GUID's that are created by the owner and are private custom fields (not exposed via the QuickBooks POS UI).
CustomFields String Custom fields returned from QuickBooks POS and formatted into XML.
TimeCreated Datetime Range When the customer was created.
TimeModified Datetime Range When the customer was last modified.
IsRewardsMember Boolean Indicates whether the customer is a rewards member.
RewardRewardAmount# String The amount of the reward earned.
RewardRewardPercent# String The percentage of the reward based on the transaction amount.
RewardEarnedDate# Datetime The date the reward was earned.
RewardMatureDate# Datetime The date the reward will mature.
RewardExpirationDate# Datetime The date the reward will expire.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137