JDBC Driver for QuickBooks Online

Build 22.0.8678

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8678