DateDrivenTerms
Supports the creation, deletion, and querying of QuickBooks Date-Driven Terms for payment and invoice schedules.
Table Specific Information
Select
By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.
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. |