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 Desktop 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 |
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. |