CData Python Connector for QuickBooks Online

Build 25.0.9454

BillLineItems

Contains detailed line-item data for vendor bills, including products or services purchased, amounts, tax details, and associated accounts for expense tracking and reporting.

Table Specific Information

Bills may be inserted, updated, or queried via the Bills or BillLineItems tables. Bills may be deleted by using the Bills table.

Select

All filterable columns support the following operators:

  • =
  • !=
  • >=
  • <=
  • >
  • <
  • IN
  • LIKE
  • CONTAINS

The driver processes other filters client-side within the driver.

Insert

To add a Bill, specify the Line_Amount, Line_DetailType, Line_AccountBasedExpenseLineDetail_AccountRef, VendorRef.For example, the following will insert a new Bill with two Line Items: 

INSERT INTO BillLineItems (Line_Amount, Line_DetailType, Line_AccountBasedExpenseLineDetail_AccountRef, VendorRef) VALUES ('4.04', 'AccountBasedExpenseLineDetail', '7', '36')

INSERT INTO BillLineItems#TEMP (Line_Amount, Line_DetailType, Line_AccountBasedExpenseLineDetail_AccountRef, VendorRef) VALUES ('4.04', 'AccountBasedExpenseLineDetail', '7', '36')
      INSERT INTO Bills ( VendorRef, Id, DocNumber, TxnDate, PrivateNote, LineAggregate) VALUES ('36', '6704', '66', '1/1/2040', 'AccountBasedExpenseLineDetail', BillLineItems#TEMP)

Columns

Name Type ReadOnly References Filterable Sortable Description
LineId [KEY] String True False False

The unique identifier (Id) that is assigned to the individual line item within the bill. This links each line item to its parent bill and allows tracking of specific expenses or items.

BillId [KEY] String False

Bills.ID

True True

The unique Id of the bill to which the line item belongs. This connects the line detail to its parent bill transaction.

SyncToken String True False False

The version number that is assigned to the bill object. QuickBooks Online increments this token each time the object is modified to prevent conflicting updates. You must supply the current SyncToken when you update or delete a bill to ensure data integrity.

MetaData_CreateTime Datetime True True True

The date and time when the bill record was originally created in QuickBooks Online. This timestamp is useful for auditing and synchronization processes.

MetaData_LastUpdatedTime Datetime True True True

The date and time when the bill record was last updated in QuickBooks Online. This timestamp helps track changes and identify the most recent version of the record.

DocNumber String False True True

The reference number that is associated with the bill transaction, such as a supplier invoice number or other identifying code.

TxnDate Date False True True

The date of the bill transaction. Typically, this value is the date that is entered by the user or the posting date that affects financial statements. If the date is omitted, QuickBooks Online uses the server's current date.

PrivateNote String False False False

A private, internal note attached to the bill transaction. By default, this note is not visible on printed or shared transaction records.

LinkedTxnAggregate String False False False

An XML aggregate that contains details of transactions that are linked to this bill, such as purchase orders or payments. This column allows you to see related documents connected to the bill.

Line_Id String False False False

The unique Id that is assigned to the line item itself, enabling differentiation of multiple lines within the same bill.

Line_Amount Decimal False False False

The total monetary amount of the line item, including charges and discounts but excluding taxes. This amount reflects the net amount before any tax is applied.

Line_Description String False False False

A descriptive text for the line item, such as the purpose of the expense or details of goods or services received.

Line_DetailType String False False False

The type of detail that is represented by the line item (for example, Account-based expense detail or Item-based expense detail). This column determines how QuickBooks Online processes and reports the line item.

Line_LineNum String False False False

The sequential number of the line item within the bill. This column helps preserve the order of multiple line entries.

Line_LinkedTxnAggregate String False False False

An XML aggregate of transactions linked to this specific line item, such as related purchase orders or vendor credits.

Line_AccountBasedExpenseLineDetail_ClassRef String False

Class.Id

False False

The Id of the class entity that is assigned to this expense line. Classes allow tracking of expenses by category or segment in the company file.

Line_AccountBasedExpenseLineDetail_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class entity that is assigned to this expense line. This name is the human-readable counterpart to the ClassRef Id.

Line_AccountBasedExpenseLineDetail_CustomerRef String False

Customers.Id

False False

The Id of the customer that is associated with this expense line. This Id supports job costing and billable expense tracking.

Line_AccountBasedExpenseLineDetail_CustomerRef_Name String True

Customers.DisplayName

False False

The name of the customer that is associated with this expense line. This name is the human-readable counterpart to the CustomerRef Id.

Line_AccountBasedExpenseLineDetail_AccountRef String False

Accounts.Id

False False

The Id of the expense account to which this line item is posted in the chart of accounts.

Line_AccountBasedExpenseLineDetail_AccountRef_Name String True

Accounts.Name

False False

The name of the expense account to which this line item is posted. This name is the human-readable counterpart to the AccountRef Id.

Line_AccountBasedExpenseLineDetail_TaxCodeRef String False

TaxCodes.Id

False False

The sales tax code that is applied to this expense line, indicating how QuickBooks Online should calculate tax for this line item.

Line_AccountBasedExpenseLineDetail_TaxAmount Decimal False False False

The amount of sales tax that is applied to this expense line. This value shows the tax portion only, separate from the line amount.

Line_AccountBasedExpenseLineDetail_TaxInclusiveAmt Decimal False False False

The total amount of the line item, including sales tax. This amount represents the gross cost of the expense line.

Line_AccountBasedExpenseLineDetail_BillableStatus String False False False

The billable status of the expense line (for example, Billable, NotBillable). This status indicates whether the cost can be passed on to a customer.

The allowed values are Billable, NotBillable, HasBeenBilled.

Line_AccountBasedExpenseLineDetail_MarkupInfo_Value Decimal True False False

The absolute markup amount added to this expense line when it is billed to a customer.

Line_AccountBasedExpenseLineDetail_MarkupInfo_Percent Double False False False

The markup rate that is applied to this expense line expressed as a percentage (for example, enter 10.0 for a 10-percent markup).

Line_AccountBasedExpenseLineDetail_MarkupInfo_PriceLevelRef String False False False

The Id of the price level entity that is used to determine markup on this expense line.

Line_ItemBasedExpenseLineDetail_ItemRef String False

Items.Id

False False

The Id of the item that is associated with this expense line. This Id links the expense to a specific inventory, non-inventory, or service item in the company file.

Line_ItemBasedExpenseLineDetail_ItemRef_Name String True

Items.Name

False False

The name of the item that is associated with this expense line. This is the human-readable counterpart to the ItemRef Id and helps identify the goods or services purchased.

Line_ItemBasedExpenseLineDetail_ClassRef String False

Class.Id

False False

The Id of the class entity that is assigned to this item-based expense line. Classes allow tracking of expenses by category or segment in the company file.

Line_ItemBasedExpenseLineDetail_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class entity that is assigned to this item-based expense line. This name is the human-readable counterpart to the ClassRef Id.

Line_ItemBasedExpenseLineDetail_UnitPrice Decimal False False False

The unit price of the item on this expense line as recorded in QuickBooks Online. This unit price represents the cost per single unit of the item.

Line_ItemBasedExpenseLineDetail_Qty Double False False False

The quantity of items that are recorded for this line. This number multiplied by the unit price forms the base amount before taxes and markups.

Line_ItemBasedExpenseLineDetail_CustomerRef String False

Customers.Id

False False

The Id of the customer that is associated with this item-based expense line. This Id supports job costing and billable expense tracking.

Line_ItemBasedExpenseLineDetail_CustomerRef_Name String True

Customers.DisplayName

False False

The name of the customer that is associated with this item-based expense line. This name is the human-readable counterpart to the CustomerRef Id.

Line_ItemBasedExpenseLineDetail_TaxCodeRef String False

TaxCodes.Id

False False

The sales tax code that is applied to this item-based expense line. This code determines how QuickBooks Online calculates tax for the line.

Line_ItemBasedExpenseLineDetail_BillableStatus String False False False

The billable status of the item-based expense line (for example, Billable, NotBillable). This status indicates whether the cost can be passed on to a customer.

The allowed values are Billable, NotBillable, HasBeenBill.

Line_ItemBasedExpenseLineDetail_MarkupInfo_Value Double True False False

The absolute markup amount that is added to this item-based expense line when it is billed to a customer.

Line_ItemBasedExpenseLineDetail_MarkupInfo_Percent Double False False False

The markup rate that is applied to this item-based expense line expressed as a percentage (for example, enter 10.0 for a 10 percent markup).

Line_ItemBasedExpenseLineDetail_MarkupInfo_PriceLevelRef String False False False

The Id of the price-level entity that is used to determine markup on this item-based expense line.

Line_ItemBasedExpenseLineDetail_MarkupInfo_PriceLevelRef_Name String True False False

The name of the price level that is associated with this markup. This name is the human-readable counterpart to the PriceLevelRef Id.

Line_ItemBasedExpenseLineDetail_TaxInclusiveAmt Decimal False False False

The total amount of the item-based expense line, including sales tax. This total represents the gross cost of the line.

Line_ItemBasedExpenseLineDetail_MarkUpInfo_MarkUpIncomeAccountRef String False False False

The Id of the income account in which markup revenue for this item-based expense line is recorded. This Id is found in the Id field of the referenced account object.

Line_ItemBasedExpenseLineDetail_PriceLevelRef String False False False

The Id of the price level that is referenced by this item-based expense line as found in the Id field of the referenced price-level object.

VendorRef String False

Vendors.Id

True True

The Id of the vendor that is associated with the bill. This Id links the bill to the supplier providing the goods or services.

VendorRef_Name String True

Vendors.DisplayName

False False

The name of the vendor that is associated with the bill. This name is the human-readable counterpart to the VendorRef Id.

APAccountRef String False

Accounts.Id

True True

The Id of the accounts payable account that is used to record this bill. This Id links the bill to the appropriate liability account in the chart of accounts.

APAccountRef_Name String True

Accounts.Name

False False

The name of the accounts-payable account that is used to record this bill. This account name is the human-readable counterpart to the APAccountRef Id.

TotalAmt Decimal False True True

The total monetary amount of the bill, calculated as the sum of all line items including taxes, discounts, and markups.

SalesTermRef String False

Terms.Id

True True

The Id of the payment terms that are applied to this bill (for example, Net 30 or Due on Receipt). This Id determines how QuickBooks Online calculates due dates and discounts.

SalesTermRef_Name String True

Terms.Name

False False

The name of the payment terms that are applied to this bill. This name is the human-readable counterpart to the SalesTermRef Id.

DueDate Date False True True

The date by which the bill must be paid according to its payment terms. This date excludes early-payment discounts or late-payment penalties.

Balance Decimal True True False

The unpaid balance of the bill at the time of retrieval. When the bill is fully paid, this value becomes zero.

DepartmentRef String False

Departments.Id

False False

The Id of the department that is associated with this bill. Departments can be used to track location or division for reporting.

DepartmentRef_Name String True

Departments.Name

False False

The name of the department that is associated with this bill. This name is the human-readable counterpart to the DepartmentRef Id.

TxnTaxDetail_TxnTaxCodeRef String False

TaxCodes.Id

False False

The tax code that is applied at the transaction level for this bill. This tax code determines the overall tax treatment for the bill.

TxnTaxDetail_TotalTax String False False False

The total amount of tax that is calculated for the bill at the transaction level. This total excludes any tax line items that are manually inserted into the transaction.

TxnTaxDetail_TaxLineAggregate String False False False

An XML aggregate that contains the details of each tax line item that is included in this bill.

CurrencyRef String False False False

The Id of the currency that is used for this bill transaction. This Id is relevant if the multicurrency feature is enabled in the company file.

CurrencyRef_Name String True False False

The name of the currency that is used for this bill transaction. This name is the human-readable counterpart to the CurrencyRef Id.

ExchangeRate Decimal False False False

The exchange rate that is applied to convert one unit of the bill's currency into the home currency. This column is available only if the multicurrency feature is enabled and only in the UK, AU, and CA editions.

GlobalTaxCalculation String False False False

The method that is used to apply taxes to this bill (for example, TaxInclusive, TaxExcluded). This column is available only in the UK, AU, and CA editions.

The allowed values are TaxExcluded, TaxInclusive, NotApplicable.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454