TaxRates
Create and query QuickBooks Tax Rates.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| Id [KEY] | String | True | True | True |
The Id of the tax rate. | |
| 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 | True | True |
The time the record was created. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
The time the record was last updated. | |
| Name | String | False | True | False |
The name for the tax rate. | |
| Description | String | False | True | True |
A description for the sales tax rate. This field must not contain white space or formatting characters. | |
| Active | Boolean | False | True | False |
This field sets whether the tax rate is active. This value is false if inactive. Inactive sales tax codes may be hidden from display and are not used on financial transactions. | |
| RateValue | String | False | True | True |
The value of the tax rate. | |
| AgencyRef | String | False |
TaxAgency.Id | True | True |
The Id of the tax agency. |
| AgencyRef_Name | String | True |
TaxAgency.DisplayName | False | False |
The name of the tax agency. |
| TaxReturnLineRef | String | False | True | True |
The Id of the tax return line. | |
| TaxReturnLineRef_Name | String | True | False | False |
The name of the tax return line. | |
| SpecialTaxType | String | False | False | False |
The special tax type to handle zero-rate taxes. VAT-registered businesses who receive goods, services, or acquisitions from other EU countries will need to calculate the VAT due, but not paid, on these acquisitions. The rate of VAT that is payable is the same that would have been paid if the goods had been supplied by a UK supplier. | |
| DisplayType | String | False | False | False |
The display type of the tax rate. This field is used to configure display settings. | |
| EffectiveTaxRate | Double | False | False | False |
The effective tax rate. This field is used to know which tax rate is applicable on any date. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| TaxRateDetails | String |
The Tax Rate Details.Used only for insert. |
| TaxCode | String |
The name for the tax code.Used only for insert. |
| TaxApplicableOn | String |
The Tax rate applicability. Values can be 'Sales or 'Purchase'. Used only for Insert. |