QuickBooksV2 (On-Premise) Connector Guide > Filter Fields

Filter Fields

The following table provides information on various filter fields available for objects.

Object	Filters	Operators
Accounts	ID	=
	Name	=,startswith, endswith, contains
	Type	=
	IsActive	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
BillExpenseItems, BillLineItems, Bills, BillLinkedTransactions	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	VendorName	=
	VendorId	=,>, >=, <, <=
	AccountsPayable	=
	AccountsPayableId	=
	IsPaid	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
BillPaymentChecks, BillPaymentChecksAppliedTo, BillPaymentCreditCards, BillPaymentCreditCardsAppliedTo	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	PayeeName	=
	PayeeId	=
	AccountsPayable	=
	AccountsPayableId	=
	IsPaid	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
CheckExpenseItems, CheckLineItems, Checks	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	PayeeName	=
	PayeeId	=
	Account	=
	AccountId	=
	IsPaid	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
Class	ID	=
	Name	=,startswith, endswith, contains
	IsActive	=

Object	Filters	Operators
CreditCardChargeExpenseItems, CreditCardChargeLineItems, CreditCardCharges, CreditCardCreditExpenseItems, CreditCardCreditLineItems, CreditCardCredits	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	Account	=
	AccountId	=
	TimeModified	=,>, >=, <, <=

See Also: Suggested QBXML Versions for Few Objects.

Object	Filters	Operators
CreditMemoLineItems, CreditMemos	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	CsutomerName	=
	CustomerId	=
	AccountRecieveable	=
	AccountsReceivableId	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
Customers	ID	=
	Date	=,>, >=, <, <=
	IsActive	=,startswith, endswith, contains
	Balance	=,>, >=, <, <=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
DateDrivenTerms	Name	=,startswith, endswith, contains
	IsActive	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
DepositLineItems, Deposits	ID	=
	Date	=,>, >=, <, <=
	DepositToAccount	=
	DepositToAccountId	=
	TimeModified	=,>, >=, <, <=

See Also: Suggested QBXML Versions for Few Objects.

Object	Filters	Operators
EmployeeEarnings, Employees,	ID	=
	Name	=,startswith, endswith, contains
	IsActive	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
EstimateLineItems, Estimates	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	CustomerName	=
	CustomerId	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
InventoryAdjustmentLineItems, InventoryAdjustments,	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	CustomerName	=
	CustomerId	=
	Account	=
	AccountId	=
	TimeModified	=,>, >=, <, <=

See Also: Suggested QBXML Versions for Few Objects.

Object	Filters	Operators
InvoiceLineItems, Invoices	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	CustomerName	=
	CustomerId	=
	Account	=
	AccountId	=
	IsPaid	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
ItemLineItems, Items,	ID	=
	Name	=,startswith, endswith, contains
	Type	=
	IsActive	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
ItemReceiptExpenseItems, ItemReceiptLineItems, ItemReceipts,	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	VendorName	=
	VendorId	=
	Payee	=
	PayeeId	=
	Account	=
	AccountId	=
	IsPaid	=
	TimeModified	=,>, >=, <, <=

See Also: Suggested QBXML Versions for Few Objects.

Object	Filters	Operators
JournalEntries, JournalEntryLines,	ID	=
	Date	=,>, >=, <, <=
	TimeCreated	=
	VendorName	=
	VendorId	=
	LineEntityName	=
	LineEntityId	=
	LineAccount	=
	LineAccountId	=
	IsPaid	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
PurchaseOrderLineItems, purchaseOrders	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	VendorName	=
	VendorId	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
ReceivePayments, ReceivePaymentsAppliedTo, SalesReceiptLineItems, SalesReceipts,	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	CustomerName	=
	CustomerId	=
	DepositToAccountName	=
	DepositToAccountId	=
	TimeModified	=,>, >=, <, <=

See Also: Suggested QBXML Versions for Few Objects.

Object	Filters	Operators
SalesOrderLineItems, SalesOrders,	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	CustomerName	=
	CustomerId	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
SalesReps, ShippingMethods, StandardTerms	ID	=
	Name	=,startswith, endswith, contains
	IsActive	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
TimeTracking	ID	=
	Date	=,startswith, endswith, contains
	EmployeeName	=
	EmployeeId	=
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
Transfer Inventory, TransferInventoryLineItems	ID	=
	TXNDate (TXN: Transaction)	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
VehicleMileage,Vendors	ID	=
	Name	=,startswith, endswith, contains
	TimeModified	=,>, >=, <, <=

Object	Filters	Operators
VendorCreditExpenseItems, VendorCreditLineItems, VendorCredits,	ID	=
	Date	=,>, >=, <, <=
	ReferenceNumber	=,startswith, endswith, contains
	VendorName	=
	VendorId	=
	AccountsPayableId	=
	AccountsPayableName	=
	TimeModified	=,>, >=, <, <=

See Also: Suggested QBXML Versions for Few Objects.