CustomerShipAddresses

Create, update, delete, and query QuickBooks POS Customer Shipping Addresses.

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 CustomerShipAddresses WHERE FirstName LIKE '%George%' AND TimeModified >= '1/1/2014' AND TimeModified < '2/1/2014'

Insert

Insert can be used to create a new Customer record or to add a shipping address to an existing Customer record. To create a new Customer record, the LastName field is required. To add a shipping address to an existing record, the ListId column of the Customer record that the address is to be added to and the ShipAddressAddressName are required.

Create a new customer:

INSERT INTO CustomerShipAddresses (FirstName, LastName, ShipAddressAddressName, ShipAddressStreet, ShipAddressCity, ShipAddressState, ShipAddressPostalCode) 
VALUES ('Kristy', 'Abercrombie', 'Home', '123 Main Street', 'Chapel Hill', 'NC', '12345')

Add a shipping address to an existing customer:

INSERT INTO CustomerShipAddresses (ListId, ShipAddressAddressName, ShipAddressStreet, ShipAddressCity, ShipAddressState, ShipAddressPostalCode) 
VALUES ('-1234567890123456789','Office', '456 Downtown Drive', 'Raleigh', 'NC', '98765')

Update

Any field that is not read-only can be updated.

To perform an update, ListId and ShipAddressAddressName are required fields.

UPDATE CustomerShipAddresses SET ShipAddressCompanyName='MyCompany' WHERE ListId='-1234567890123456789' AND ShipAddressAddressName='Office'

Delete

Delete is used to remove a shipping address from the specified Customer record (it will not delete the Customer record itself). To perform a delete, ListId and ShipAddressAddressName are required fields.

DELETE FROM CustomerShipAddresses WHERE ListId='-1234567890123456789' AND ShipAddressAddressName='Home'

Columns

Name	Type	ReadOnly	Filter Type	Description
ListID [KEY]	String	True	Single	The unique identifier, generated by QuickBooks POS.
CustomerID	String	False	Range	The user-specified Id for the customer.
FullName	String	True		The full name of the customer.
Salutation	String	False	Range	A salutation, such as Mr., Mrs., etc.
FirstName	String	False	Range	The first name of the customer as stated in the address info.
LastName	String	False	Range	The last name of the customer as stated in the address info.
CompanyName	String	False	Range	The name of the company of the customer.
Phone	String	False	Range	The primary telephone number for the customer.
Phone2	String	False	Range	An alternate telephone or fax number for the customer.
Phone3	String	False	Range	An alternate telephone or fax number for the customer.
Email	String	False	Range	The email address for communicating with the customer.
IsOkToEMail	Boolean	False	Single	Whether or not the customer can be notified via email.
CustomerType	String	False	Range	A customer type within QuickBooks POS.
Notes	String	False	Range	Notes on this customer.
DefaultShipAddress	String	False		The default shipping address of the customer.
BillAddress_Street	String	False		Street address of the billing address of the customer.
BillAddress_Street2	String	False		The second line of the street address of the billing address of the customer.
BillAddress_City	String	False		City name for the billing address of the customer.
BillAddress_State	String	False		State name for the billing address of the customer.
BillAddress_PostalCode	String	False		Postal code for the billing address of the customer.
BillAddress_Country	String	False		Country for the billing address of the customer.
IsNoShipToBilling	Boolean	False	Single	Whether or not the billing address can be used as a shipping address.
IsAcceptingChecks	Boolean	False	Single	Indicates whether checks are being accepted from this customer. The default is True.
IsUsingChargeAccount	Boolean	False	Single	Indicates whether the customer is using a charge account.
StoreExchangeStatus	String	True	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	False	Range	The sales tax category.
CustomerDiscPercent	Double	False	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	False	Single	The customer discount type.
PriceLevelNumber	String	False	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	True	Range	The time of the last purchase made by this customer.
AmountPastDue	Decimal	True	Range	The amount past due for a transaction.
IsUsingWithQB	Boolean	False	Single	Whether or not the customer is using QuickBooks POS with QuickBooks.
AccountBalance	Decimal	True	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	True	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	False	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	False		Custom fields returned from QuickBooks POS and formatted into XML.
TimeCreated	Datetime	True	Range	When the customer was created.
TimeModified	Datetime	True	Range	When the customer was last modified.
ShipAddressAddressName# [KEY]	String	False		The name used to identify this shipping address of the customer.
ShipAddressCompanyName#	String	False		The company name of this shipping address of the customer.
ShipAddressFullName#	String	False		The full name of the recipient in this shipping address of the customer.
ShipAddressStreet#	String	False		Street address of this shipping address of the customer.
ShipAddressStreet2#	String	False		The second line of the street address of this shipping address of the customer.
ShipAddressCity#	String	False		City name for this shipping address of the customer.
ShipAddressState#	String	False		State name for this shipping address of the customer.
ShipAddressPostalCode#	String	False		Postal code for this shipping address of the customer.
ShipAddressCountry#	String	False		Country for this shipping address of the customer.