TaxCodes
Create and query QuickBooks Sales Tax Codes.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| Id [KEY] | String | True | True | True |
The Id of the sales tax code. | |
| SyncToken | String | True | False | False |
Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online. | |
| MetaData_CreateTime | Datetime | True | False | True |
The time the record was created. | |
| MetaData_LastUpdatedTime | Datetime | True | False | True |
The time the record was last updated. | |
| Name | String | False | False | True |
The name for the tax sales code. | |
| Description | String | False | False | True |
A description for the sales tax code. This field must not contain white space or formatting characters. | |
| Active | Boolean | False | False | False |
This field sets whether the sales tax code entity is active. Inactive sales tax codes may be hidden from display and are not used on financial transactions. | |
| Taxable | Boolean | False | False | False |
This field indicates that the sales tax code signifies a non-taxable entity if false or null (default) or a taxable entity if true. | |
| TaxGroup | Boolean | False | False | False |
This field indicates whether the sales tax code is for a tax group. | |
| SalesTaxRateList_TaxRateDetailAggregate | String | False | False | False |
An XML aggregate of sales tax rates. | |
| PurchaseTaxRateList_TaxRateDetailAggregate | String | False | False | False |
An XML aggregate of purchase tax rates. This field available in only the UK, AU, and CA editions. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| TaxRateDetails | String |
Aggregate of TaxRateDetails. Used only for insert. |
| TaxApplicableOn | String |
Specifies where this tax rate can be applied. Possible values are 'Sales' or 'Purchase'.Used only for insert. |
| TaxRateName | String |
Name of a new tax rate.Used only for insert. |
| TaxAgencyId | String |
The Id of the agency to whom tax is paid.Used only for insert. |
| RateValue | String |
The tax rate value.Used only for insert. |