Power BI Connector for QuickBooks

Build 23.0.8839

StatementCharges

Create, update, delete, and query QuickBooks Statement Charges.

Table Specific Information

To add a StatementCharge, specify the CustomerName or CustomerId and the ItemName or ItemId.

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

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 StatementCharges are Id, Date, TimeModified, ReferenceNumber, CustomerName, CustomerId, IsPaid, AccountsReceivable, and AccountsReceivableId. TimeModified and Date may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. ReferenceNumber may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:

SELECT * FROM StatementCharges WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND ReferenceNumber LIKE '%12345%'

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier.

TxnNumber Integer True

The transaction number. An identifying number for the transaction, different from the QuickBooks-generated Id.

ReferenceNumber String False

Transaction reference number.

CustomerName String False 1000

Customer name this transaction is recorded under. Either CustomerName or CustomerId must have a value when inserting.

CustomerId String False

Customers.ID

255

Customer Id this transaction is recorded under. Either CustomerName or CustomerId must have a value when inserting.

Date Date False

Transaction date.

ItemName String False

A reference to the item for the transaction.

ItemId String False

Items.ID

A reference to the item for the transaction.

Quantity Double False

Quantity in stock for this inventory item.

UnitOfMeasure String False 31

In a transaction line item, the name of the unit of measure is selected from within the item's available units. If the company file is enabled only for single unit of measure per item, this must be the base unit. Only available in QBXML Version 7.0 and above.

OverrideUnitOfMeasure String False 100

When you modify a transaction line to change the unit of measure used in that line, you use this to specify the UOM set within which you are choosing an available unit of measure. Only available in QBXML Version 7.0 and above.

OverrideUnitOfMeasureId String False

UnitOfMeasure.ID

When you modify a transaction line to change the unit of measure used in that line, you use this to specify the UOM set within which you are choosing an available unit of measure. Only available in QBXML Version 7.0 and above.

Rate Double False

The unit rate charged for this item.

Amount Decimal False

Amount of the transaction.

Balance Double True

The balance remaining on the transaction.

Description String False

A textual description of the StatementCharge.

AccountsReceivable String False 1000

A reference to the name of the accounts-receivable account where the money received from this transaction will be deposited.

AccountsReceivableId String False

Accounts.ID

A reference to the Id of the accounts-receivable account where the money received from this transaction will be deposited.

Class String False 1000

A reference to the class of the transaction.

ClassId String False

Class.ID

A reference to the class of the transaction.

BilledDate Date False

Date when the customer was billed.

DueDate Date False

Date when the payment is due.

IsPaid Boolean True

Indicates whether this statement charge has been paid.

CustomFields String False

Custom fields returned from QuickBooks and formatted into XML.

EditSequence String True 16

An identifier used for versioning for this copy of the object.

TimeModified Datetime True

When the statement charge was last modified.

TimeCreated Datetime True

When the statement charge was created.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839