SalesTaxCodes

Handles QuickBooks Sales Tax Codes, supporting creation, updates, deletion, and queries for tax categorization.

Table Specific Information

Select

The following filters support server-side execution. Other filters are executed client-side.

QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. The available columns for SalesTaxCodes are Id, Name, and TimeModified. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. For example:

SELECT * FROM SalesTaxCodes WHERE Name = 'TAX'

Insert

To insert a SalesTaxCode, specify the Name and IsTaxable fields. For example:

INSERT INTO SalesTaxCodes (Name, IsTaxable) VALUES ('TAX', true)

Update

To update a SalesTaxCode, specify the Id and the fields to update. For example:

UPDATE SalesTaxCodes SET IsActive = false WHERE ID = '80000001-1234567890'

Delete

SalesTaxCodes may be deleted using the Id. For example:

DELETE FROM SalesTaxCodes WHERE ID = '80000001-1234567890'

Columns


Name	Type	ReadOnly	References	ColumnSize	Description
ID [KEY]	String	True		255	The unique identifier for the sales tax code, used to distinguish it from other tax codes.
Name	String	False		3	The name assigned to the sales tax code, which is typically used to label transactions or items as taxable or non-taxable.
Description	String	True		31	A brief description of the sales tax code, providing additional context or details about its purpose or usage.
IsActive	Boolean	False			Indicates whether this sales tax code is currently active and available for use in QuickBooks.
IsTaxable	Boolean	False			Specifies whether the sales tax code represents taxable items or transactions.
ItemPurchaseTaxRef_FullName	String	False		1000	The full name of the purchase tax item associated with this tax code. This field is applicable in international versions of QuickBooks where purchase tax applies.
ItemPurchaseTaxRef_ListId	String	False		255	The unique identifier of the purchase tax item associated with this tax code. This field is applicable in international versions of QuickBooks.
ItemSalesTaxRef_FullName	String	False		1000	The full name of the sales tax item associated with this tax code. This field is applicable in international versions of QuickBooks.
ItemSalesTaxRef_ListId	String	False	SalesTaxItems.ID	255	The unique identifier of the sales tax item associated with this tax code. This field is applicable in international versions of QuickBooks.
TimeCreated	Datetime	True			The date and time when this sales tax code was originally created in QuickBooks.
TimeModified	Datetime	True			The date and time of the most recent modification to this sales tax code.
EditSequence	String	True		16	A versioning identifier that changes with each update to the sales tax code, ensuring accurate synchronization and tracking of changes.