SalesTaxPaymentCheckLineItems
Supports querying of individual line items within QuickBooks Sales Tax Payment Check transactions.
Table Specific Information
Select
The following filters support server-side execution. Other filters are executed client-side.
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 the SalesTaxPaymentCheckLineItems table are ID, TxnDate, TimeModified, and RefNumber. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. RefNumber may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:
SELECT * FROM SalesTaxPaymentCheckLineItems WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011'
To query line items for a specific sales tax payment check, filter by the SalesTaxPaymentCheckId.
SELECT * FROM SalesTaxPaymentCheckLineItems WHERE SalesTaxPaymentCheckId = '80000001-1234567890'
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier for this sales tax payment check line item. | |
| SalesTaxPaymentCheckId | String | True | 255 |
The unique identifier of the sales tax payment check transaction associated with this line item. | |
| TxnNumber | Integer | True |
A system-assigned transaction number for identifying this sales tax payment check transaction separately from the QuickBooks generated ID. | ||
| PayeeEntityRef_FullName | String | True | 209 |
The full name of the tax agency receiving the payment. | |
| PayeeEntityRef_ListID | String | True |
Vendors.ID | 255 |
The unique identifier of the tax agency receiving the payment. |
| TxnDate | Date | True |
The date of the sales tax payment check. | ||
| BankAccountRef_FullName | String | True | 159 |
The full name of the bank account used for this payment. | |
| BankAccountRef_ListID | String | True |
Accounts.ID | 255 |
The unique identifier of the bank account used for this payment. |
| Amount | Decimal | True |
The total amount of the sales tax payment check. | ||
| RefNumber | String | True | 11 |
The check reference number. | |
| Memo | String | True | 4095 |
A memo or note associated with this sales tax payment check. | |
| IsToBePrinted | Boolean | True |
Indicates whether this check is marked to be printed. | ||
| SalesTaxPaymentCheckLineRet_TxnLineID | String | True | 255 |
The unique identifier for this line item within the sales tax payment check. | |
| SalesTaxPaymentCheckLineRet_ItemSalesTaxRef_ListID | String | True | 255 |
The unique identifier of the sales tax item associated with this line. | |
| SalesTaxPaymentCheckLineRet_ItemSalesTaxRef_FullName | String | True | 255 |
The full name of the sales tax item associated with this line. | |
| SalesTaxPaymentCheckLineRet_Amount | Decimal | True |
The amount of this individual line item. | ||
| TimeCreated | Datetime | True |
The date and time when this sales tax payment check was created. | ||
| TimeModified | Datetime | True |
The date and time when this sales tax payment check was last modified. | ||
| EditSequence | String | True | 16 |
A versioning identifier used for optimistic locking when updating the transaction. |