The identifier (Id) of the linked transaction line item within the bill. The Id uniquely links this transaction line to its parent bill.

Bills.Id

The Id of the bill that is associated with the linked transaction line item. This Id connects the linked transaction to the correct bill.

The version number that is assigned to the bill-linked transaction object. The sync token locks the object for one application at a time, and QuickBooks Online increments it after each modification. An update or delete using an older sync token fails, ensuring that only the latest version of the object is maintained.

The date and time when the linked transaction record was originally created in QuickBooks Online. The CreateTime value provides a reference point for auditing and synchronization.

The date and time when the linked transaction record was last updated in QuickBooks Online. The LastUpdatedTime value helps track changes and identify the most recent version of the record.

The reference number that is associated with the transaction. This reference number allows users to match QuickBooks transactions to external documents such as vendor invoices.

The date that is entered by the user for when this transaction occurred. This date determines the posting date used in reports and financial statements.

A private, internal note for the transaction. The private note does not appear on printed or shared transaction records.

The Id of the transaction that is linked to this bill. This Id provides the connection between related QuickBooks transactions such as bills, credits, or payments.

The type of the transaction that is linked to this bill (for example, BillPayment or VendorCredit). The transaction type identifies how the linked transaction relates to the bill.

The Id of the line item within the linked transaction. ThisId uniquely identifies which line from the linked transaction is connected to the bill.

An XML aggregate that contains the details of all line items that are associated with the linked transaction. This column enables applications to retrieve related lines in a structured format.

Vendors.Id

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

Vendors.DisplayName

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

Accounts.Id

The Id of the accounts-payable account that is used for this linked transaction. This Id connects the transaction to the correct liability account in the chart of accounts.

Accounts.Name

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

Terms.Id

The Id of the sales-terms entity that is applied to this bill. This Id identifies the payment terms such as Net 30 or Due on Receipt.

Terms.Name

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

TaxCodes.Id

The tax code that is applied to this transaction at the transaction level. The tax code determines how QuickBooks Online calculates tax for the bill.

The total amount of tax that is calculated for the transaction, excluding any tax lines that are manually inserted into the transaction line list. This total shows the full tax impact of the transaction.

An XML aggregate containing the details of each tax line item included in this transaction. The column enables applications to retrieve related tax lines in a structured format.

The date by which the bill must be paid according to its payment terms. The due date excludes early-payment discount incentives and late-payment penalties. If the date is not supplied, QuickBooks Online uses the server's current date.

The total monetary amount of the transaction. This total includes the sum of all charges, allowances, and taxes applied to the bill.

The unpaid balance of the transaction at the time of retrieval. The balance shows the remaining amount due and becomes zero when fully paid.

Departments.Id

The Id of the department that is associated with this transaction. The department stores the location or division of the transaction as defined by using location tracking in QuickBooks Online.

Departments.Name

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

The Id of the currency that is used in this transaction. This currency reference is relevant when the multicurrency feature is enabled in the company file.

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

The exchange rate that is applied to convert one unit of the bill's currency into the home currency. The exchange rate is valid only when the multicurrency feature is enabled. In QuickBooks Online, exchange rates are recorded as the number of home currency units that are required to equal one foreign currency unit. This field is available only in the UK, AU, and CA editions.

The method that is used used to apply taxes to this transaction (for example, TaxInclusive or TaxExcluded). This field is valid only in the UK, AU, and CA editions.

The allowed values are TaxExcluded, TaxInclusive, NotApplicable.