SalesTaxCodes

Create, update, delete, and query Reckon Sales Tax Codes.

Table Specific Information

Select

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

Reckon Accounts Hosted 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	Description
ID [KEY]	String	True		The unique identifier.
Name	String	False		The name of the sales tax code.
Description	String	False		The description of the sales tax code.
IsActive	Boolean	False		Whether or not the other name is active.
IsTaxable	Boolean	False		Whether or not the other name is taxable.
ItemPurchaseTaxRef_FullName	String	False		Refers to the purchase tax item.
ItemPurchaseTaxRef_ListId	String	False		Refers to the purchase tax item.
ItemSalesTaxRef_FullName	String	False	SalesTaxItems.Name	Refers to the sales tax item.
ItemSalesTaxRef_ListId	String	False	SalesTaxItems.ID	Refers to the sales tax item.
TimeCreated	Datetime	True		The datetime the sales tax code was made.
TimeModified	Datetime	True		The last datetime the sales tax code was modified.
EditSequence	String	True		An identifier used for versioning for this copy of the object.