BillPaymentCreditCards

Create, Query, Update, and Delete QuickBooks BillPayments. You can add BillPayments via the BillPaymentsApplied table.

Table Specific Information

BillPaymentCreditCards may be inserted, queried, or updated via the BillPaymentCreditCards or BillPaymentCreditCardsAppliedTo table. BillPaymentCreditCards may be deleted by using the BillPaymentCreditCards table.

This table has a Custom Fields column. See the Custom Fields page for more information.

Select

QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or '=' comparison. The available columns for BillPaymentCreditCards are Id, ReferenceNumber, PayeeName, PayeeId, AccountsPayable, and AccountsPayableId. In addition, the pseudo-columns StartModifiedDate, EndModifiedDate, StartTxnDate, and EndTxnDate may also be specified.

Insert

Note: There are two ways to insert a BillPaymentCreditCard. See BillPaymentCreditCardsAppliedTo for another example of how to insert a BillPaymentCreditCard.

In order to add a BillPaymentCreditCard, a Payee and CreditCard must be specified. The Payee must match the Vendor associated with the Bill you are adding a payment for. The AppliedToAggregate column may be used to specify an XML aggregate of AppliedTo data. The columns that may be used in these aggregates are defined in the BillPaymentCreditCardsAppliedTo table as # columns. For example, the following will insert a new BillPaymentCreditCard with two AppliedTo entries:

INSERT INTO BillPaymentCreditCard (PayeeName, CreditCardName, AppliedToAggregate) 
VALUES ('Vu Contracting', 'CalOil Credit Card', 
'<BillPaymentCreditCardsAppliedTo>
<Row><AppliedToRefId>178C1-1450221347</AppliedToRefId><AppliedToAmount>20.00</AppliedToAmount></Row>
<Row><AppliedToRefId>881-933371709</AppliedToRefId><AppliedToAmount>51.25</AppliedToAmount></Row>
</BillPaymentCreditCardsAppliedTo>')

Please note that the AppliedToRefId is a reference to a Bill Id, which can be found in Bills, BillLineItems, or BillExpenseItems.

QuickBooks Online

The QuickBooks Online SDK does not support BillPaymentCreditCards.

Columns

Name	Type	Description	ReadOnly
ID [KEY]	String	The unique identifier for the transaction.	True
PayeeId	String	A reference to entity merchandise was purchased from. Either PayeeId or PayeeName is required.	False
PayeeName	String	A reference to entity merchandise was purchased from. Either PayeeId or PayeeName is required.	False
ReferenceNumber	String	The transaction reference number. This may be set to refnumber*, *refnumber, and *refnumber* in the WHERE clause of a SELECT statement to search by StartsWith, EndsWith, and Contains. Refnum1:refnum2, refnum1:, and :refnum1 may also be used to denote a range.	False
Date	Date	The date of the transaction. If it is set in the WHERE clause of a SELECT query, the pseudo-columns StartDate and EndDate are overwritten with the value.	False
Amount	Double	Amount of the transaction. This is calculated by QuickBooks based on the Line Items or Expense Line Items.	True
AccountsPayable	String	Reference to the Accounts Payable account.	False
AccountsPayableId	String	Reference to the Accounts Payable account id.	False
BankAccountId	String	Refers to the account funds are being drawn from for this bill payment. This property is only applicable to the Check PaymentMethod.	False
BankAccountName	String	Refers to the account funds are being drawn from for this bill payment. This property is only applicable to the Check PaymentMethod.	False
CreditCardId	String	Refers to the credit card account this payment is being charged to. This property is only applicable to the CreditCard PaymentMethod.	False
CreditCardName	String	Refers to the credit card account this payment is being charged to. This property is only applicable to the CreditCard PaymentMethod.	False
IsToBePrinted	Boolean	Indicates whether or not the transaction is to be printed. If set to true, the 'To Be Printed' box in the QuickBooks user interface will be checked.	False
Memo	String	A memo to appear on internal reports.	False
AppliedToAggregate	String	An aggregate of the AppliedTo data which can be used for adding a BillPaymentCreditCard and its AppliedTo data.	False
CustomFields	String	Custom fields returned from QuickBooks formatted into XML.	False
TimeModified	Datetime	When the BillPayment was last modified.	True
TimeCreated	Datetime	When the BillPayment was created.	True

Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
AppliedTo*	String	All AppliedTo specific columns may be used in insertions.
StartTxnDate	String	Earliest transaction date to search for.
EndTxnDate	String	Latest transaction date to search for.
StartModifiedDate	String	Earliest modified date to search for.
EndModifiedDate	String	Latest modified date to search for.
IncludeLineItems	String	Whether or not to include line items in the response for a SELECT. The allowed values are True, False.