JDBC Driver for FreshBooks

Build 22.0.8462

Items

Items are stored from invoice lines to make invoicing easier in the future.

Columns

Name Type ReadOnly Description
Id [KEY] Integer False

Unique identifier of the item.

AccountingSystemId String False

Unique identifier of business client exists on.

Amount Decimal False

Amount paid on invoice, to two decimal places.

Code String False

Three-letter currency code.

Description String False

Descriptive text for item.

Inventory String False

Count of inventory.

Name String False

Descriptive name of item.

Quantity String False

Number to multiply unit cost by.

Tax1 Integer False

Identifier of tax on invoice.

Tax2 Integer False

Identifier of second tax on invoice if applicable.

Updated Datetime False

Date object was last updated. (YYYY-MM-DD)

VisState Integer False

0 for active, 1 for deleted.

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