Terms
Create, update, delete, and query QuickBooks Terms.
Table Specific Information
Select
All filterable columns support the following operators:
- =
- !=
- >=
- <=
- >
- <
- IN
- LIKE
- CONTAINS
The driver processes other filters client-side within the driver.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| Id [KEY] | String | True | True | True |
The Id of the term. | |
| 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 term. | |
| Active | Boolean | False | True | False |
This field sets whether this entity is currently enabled for use by QuickBooks. | |
| Type | String | False | False | False |
The type of the sales term. | |
| DiscountPercent | Double | False | False | False |
The discount percentage available against an amount if paid within the days specified by DiscountDays. | |
| DueDays | Integer | False | False | False |
Number of days from delivery of goods or services until the payment is due. | |
| DiscountDays | Integer | False | False | False |
The discount applies if paid within this number of days. | |
| DayOfMonthDue | Integer | False | False | False |
The payment must be received by this day of the month. | |
| DueNextMonthDays | Integer | False | False | False |
The payment is due next month if it was issued the specified number of days before the value of DayOfMonthDue. | |
| DiscountDayOfMonth | Integer | False | False | False |
The discount applies if paid before this day of month. |