Tableau Connector for QuickBooks Online

Build 25.0.9434

BillPayments

Maintains records of vendor bill payments, including payment methods, amounts, dates, and vendor details, to manage cash outflows and reconcile accounts payable.

Table Specific Information

BillPayments may be inserted or queried via the BillPayments or BillPaymentLineItems tables. They may be deleted by using the BillPayments 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 BillPayment, specify the Vendor, PayType, TxnDate, and TotalAmt columns, as well as at least one Line Item and either CreditCardPayment or CheckPayment. You must enter an amount for each Line Item up to but not exceeding the total amount remaining to be paid for each Bill. The LineAggregate column may be used to specify an XML aggregate of Line Item data. Each _ denotes hierarchy. Use <Line> at the base level. The contents of LineAggregate will be sent to the API as is. All values for each field in the aggregate should adhere to the API's specifications (e.g. for dates in format yyyy-MM-dd, for date times in format yyyy-MM-dd'T'HH:mm:sszzz).The columns that may be used in the aggregates begin with the prefix 'Line_' to indicate they are part of the line item. Use the Line_ column along with the DocNumber to indicate which lines go with which BillPayments. For example: 

INSERT INTO BillPayments (VendorRef, PayType, TxnDate, CheckPayment_BankAccountRef, CheckPayment_PrintStatus, TotalAmt, LineAggregate) 
VALUES ('21', 'Check', '1/1/2011', '41', 'NotSet', 0.03 '
<Line><Amount>Repairs</Amount><LinkedTxn><TxnId>312</TxnId><TxnType>Bill</TxnType></LinkedTxn></Line>
<Line><Amount>Removal</Amount><LinkedTxn><TxnId>313</TxnId><TxnType>Bill</TxnType></LinkedTxn></LinkedTxn></Line>
')

Columns

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

The identifier (Id) of the bill payment. This Id uniquely identifies the bill payment record within QuickBooks Online.

SyncToken String True False False

The version number that is assigned to the bill payment 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.

MetaData_CreateTime Datetime True True True

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

MetaData_LastUpdatedTime Datetime True True True

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

DocNumber String False True True

The document number that is associated with this transaction. If the document number is not provided during a create operation, QuickBooks business logic assigns the next sequential number automatically.

TxnDate Date False True True

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

PrivateNote String False False False

A private, internal note about the transaction. This private note does not appear on printed or shared transaction records by default.

DepartmentRef String False

Departments.Id

False False

The Id of the department entity 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.

DepartmentRef_Name String True

Departments.Name

False False

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

LineAggregate String False False False

An XML aggregate that contains the line items that are associated with the bill payment. This column enables applications to retrieve related lines in a structured format.

VendorRef String False

Vendors.Id

True True

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

VendorRef_Name String True

Vendors.DisplayName

False False

The name of the vendor that is associated with this bill payment. 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 to which the vendor credit is credited. This Id must point to a Liability account whose subtype is Payables. If the company uses a single accounts-payable account, this account is implied.

APAccountRef_Name String True

Accounts.Name

False False

The name of the accounts-payable account to which the vendor credit is credited. This name is the human-readable counterpart to the APAccountRef Id and must be a Liability account whose subtype is Payables.

PayType String False False False

The payment type that is used for this bill payment. The payment type identifies whether the payment was made by check, credit card, or another method.

The allowed values are Check, CreditCard.

CheckPayment_BankAccountRef String False

Accounts.Id

False False

The Id of the bank account that is used to issue the check. This Id links the bill payment to the source bank account.

CheckPayment_BankAccountRef_Name String True

Accounts.Name

False False

The name of the bank account that is used to issue the check. This name is the human-readable counterpart to the CheckPayment_BankAccountRef Id.

CheckPayment_PrintStatus String False False False

The print status of the check payment. The print status applies only to checks and is ignored for credit card charges and refunds.

The allowed values are NotSet, NeedToPrint, PrintComplete.

The default value is NeedToPrint.

CreditCardPayment_CCAccountRef String False

Accounts.Id

True True

The Id of the credit-card account that is used for this bill payment. This Id links the payment to the credit-card account on file.

CreditCardPayment_CCAccountRef_Name String True

Accounts.Name

False False

The name of the credit-card account that is used for this bill payment. This name is the human-readable counterpart to the CreditCardPayment_CCAccountRef Id.

TotalAmt Decimal False True True

The total monetary amount of the bill payment. This total is determined by summing all payments from the line items of the bill payment.

ProcessBillPayment Boolean False False False

Indicates whether the payment is processed by the merchant account service. The ProcessBillPayment flag is valid only for QuickBooks Online companies with credit-card processing enabled.

CurrencyRef String False False False

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.

CurrencyRef_Name String True False False

The name of the currency that is used in this 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 payment'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.

TransactionLocationType String False False False

The account location type that is used in this transaction. This field is valid only in the FR editions.

The allowed values are WithinFrance, FranceOverseas, OutsideFranceWithEU, OutsideEU.

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