TDV Adapter for QuickBooks POS

Build 21.0.8137

PriceAdjustmentItems

Create, update, delete, and query QuickBooks POS Price Adjustment Items.

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

Insert

Insert can be used to create a new PriceAdjustment record or to add an item to an existing PriceAdjustment record.

To create a new PriceAdjustment record, the PriceAdjustmentName field is required.

INSERT INTO PriceAdjustmentItems (PriceAdjustmentName, ItemListId, ItemNewPrice) 
VALUES ('New Adjustment', '-1000000000000000001', '10.00')

To add an item to an existing record, the TxnId column of the PriceAdjustment record that the item is to be added to and the ItemListId are required.

INSERT INTO PriceAdjustmentItems (TxnId, ItemListId, ItemNewPrice) 
VALUES ('-1234567890123456789', '-1000000000000000001', '10.00')

Update

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

Note: Update operations will count as two operations against the QuickBooks POS API. One is required to retrieve the existing record, and another to update the record with new data.

To perform an update, TxnId and ItemTxnLineId are required fields.

UPDATE PriceAdjustmentItems SET ItemNewPrice='30.00' WHERE TxnId='-1234567890123456789' AND ItemTxnLineId='1'

Delete

Delete is used to remove an item from the specified record (it will not delete the entire record itself).

Note: Deletion of an item requires that all the wanted items that currently exist in the record be sent in the request, thus deleting those that are not specified. Therefore Delete operations will count as two operations against the QuickBooks POS API. One is required to retrieve the existing record to obtain all the existing ItemTxnLineIds and another to delete the specified item.

To perform a delete, TxnId and ItemTxnLineId are required fields.

DELETE FROM PriceAdjustmentItems WHERE TxnId='-1234567890123456789' AND ItemTxnLineId='3'

Columns

Name Type ReadOnly Filter Type Description
TxnID [KEY] String True Single

The unique identifier, generated by QuickBooks POS.

Associate String False Range

The employee making the adjustment.

AppliedBy String True Range

The employee who applied the price adjustment.

Comments String False Range

Contains a description of the transaction.

DateApplied Datetime True Range

Date the price adjustment was applied.

DateRestored Datetime True Range

Date the price adjustment was restored.

ItemsCount String True Range

The number of line items in the insert that added the transaction.

PriceAdjustmentName String False Range

The name of the price adjustment.

PriceAdjustmentStatus String True Single

The status of the price adjustment.

PriceLevelNumber String False Single

The suggested price level discount given to the customer.

RestoredBy String True Range

The employee who restored the price adjustment.

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 changes to the customer information were successfully updated. Possible values are Modified, Sent, and Acknowledged.

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 transaction was created.

TimeModified Datetime True Range

When the transaction was last modified.

ItemTxnLineID# [KEY] String True

Identification number of the transaction line. (TxnLineId is supported as of version 2.0 of the SDK. With QBXML 1.0 and 1.1, TxnLineId is always returned as zero.) If you need to add a new transaction line in an update, you can do so by setting the TxnLineId to -1.

ItemListID# String False

The unique identifier for the item, generated by QuickBooks POS.

ItemNewPrice# Decimal False

The price of the item after the price adjustment.

ItemOldPrice# Decimal True

The price of the item before the price adjustment.

ItemOldCost# Decimal True

Inventory cost for this item before updating this memo.

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