JDBC Driver for FreshBooks

Build 23.0.8839

Items

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

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Unique identifier of the item.

AccountingSystemId String True

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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839