DateDrivenTerms
Supports the creation, deletion, and querying of QuickBooks Date-Driven Terms for payment and invoice schedules.
Table Specific Information
Select
The following filters support server-side execution. Other filters are executed client-side.
QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available columns for DateDrivenTerms are Name, TimeModified, and IsActive. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax.
Insert
To insert DateDrivenTerms, specify the Name and DayOfMonthDue.Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier for the date-driven payment term. | |
| Name | String | False | 31 |
The name assigned to the date-driven payment term. | |
| IsActive | Boolean | False |
Indicates whether the date-driven payment term is currently active and available for use. | ||
| DayOfMonthDue | Integer | False |
Specifies the day of the month when the full payment is due without any discount. | ||
| DueNextMonthDays | Integer | False |
Defines the number of days before the due date within which, if the invoice or bill is issued, the payment deadline is extended to the following month. | ||
| DiscountDayOfMonth | Integer | False |
The day of the month by which payment must be made to qualify for a discount. | ||
| DiscountPct | Double | False |
The percentage discount applied to payments made by the specified discount day of the month. Must be between 0 and 100. | ||
| EditSequence | String | True | 16 |
An identifier used for versioning and tracking changes to this payment term. | |
| TimeCreated | Datetime | True |
The timestamp indicating when this payment term was created. | ||
| TimeModified | Datetime | True |
The timestamp indicating the last modification to this payment term. |