JDBC Driver for FreshBooks

Build 23.0.8839

BillsLineItems

Bill lines are used to determine the amount of a bill.

Columns

Name Type Description
LineId [KEY] Integer Line Id unique to this bill.
CategoryId String Id of related expense category.
BillId Integer Id of related bill.
CategoryName String Name of related expense category.
ListIndex Integer Line number on the Bill
Description String Description of line item.
Amount Decimal Amount calculated from quantity and unit_cost.
Code String Three-letter currency code.
TotalAmount Decimal Total amount calculated from quantity and unit_cost.
TotalAmountCode String Three letter currency code.
Quantity Integer Quantity of the line unit.
UnitCostAmount Decimal unit cost amount of the line item.
UnitCostCode String Three-letter currency code.
TaxName1 String Name for the first tax on the bill line.
TaxName2 String Name for the second tax on the bill line.
TaxPercent1 Integer Percentage of first tax to 2 decimal places.
TaxPercent2 Integer Percentage of second tax to 2 decimal places.
TaxAuthorityId1 String Tax Authority 1.
TaxAuthorityId2 String Tax Authority 2.
TaxAmount1Amount Decimal First tax amount, in percentage. (up to three decimal places)
TaxAmount1Code String Three letter currency code
TaxAmount2Amount Decimal Second tax amount, in percentage. (up to three decimal places)
TaxAmount2Code String Three letter currency code

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839