Terms
Stores payment terms such as Net 30 or Due on Receipt, used to define invoice due dates and early payment discounts.
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 unique identifier (Id) that is assigned by QuickBooks Online to this payment term record. It is used to retrieve or reference the term programmatically and is required for updates or deletions. | |
| SyncToken | String | True | False | False |
The version control token for this payment-term record that is used to prevent conflicting updates. QuickBooks Online increments this sync token each time the record is modified, and only the latest sync token is accepted for edits. | |
| MetaData_CreateTime | Datetime | True | True | True |
The date and time stamp (Coordinated Universal Time) when QuickBooks Online created this payment term record. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
The date and time stamp (Coordinated Universal Time) when this payment-term record was last modified in QuickBooks Online. | |
| Name | String | False | True | False |
The display name of the payment term as it appears in QuickBooks Online user interfaces and reports. | |
| Active | Boolean | False | True | False |
Indicates whether this payment term record is currently enabled for use in QuickBooks Online (true) or is inactive (false). Inactive terms can be hidden from lists and cannot be used on new transactions. | |
| Type | String | False | False | False |
The type of sales term (for example, Standard, DateDriven, or CashOnDelivery) that is associated with this payment-term record. This field controls how QuickBooks Online interprets the term's due date and discount rules. | |
| DiscountPercent | Double | False | False | False |
The discount percentage that is available to the customer if payment is made within the number of days that is specified by the DiscountDays field. This discount encourages early payment. | |
| DueDays | Integer | False | False | False |
The number of days from the delivery of goods or services until the payment is due under this term. This field is used by QuickBooks Online to calculate the due date on transactions. | |
| DiscountDays | Integer | False | False | False |
The number of days after the transaction date within which the discount specified in the DiscountPercent field applies. | |
| DayOfMonthDue | Integer | False | False | False |
The calendar day of the month by which the payment must be received under this term. This day is used for date-driven terms. | |
| DueNextMonthDays | Integer | False | False | False |
The number of days before the DayOfMonthDue value that a transaction must be issued for the payment to be due in the next month. This setting allows QuickBooks Online to handle terms that roll into the next month based on issue date. | |
| DiscountDayOfMonth | Integer | False | False | False |
The calendar day of the month by which the payment must be received in order for the discount specified in the DiscountPercent field to apply. This field is used for date-driven discount terms. |