SalesTaxPaymentChecks
Manages QuickBooks Sales Tax Payment Checks.
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 SalesTaxPaymentChecks 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 SalesTaxPaymentChecks WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011'
Delete
SalesTaxPaymentChecks can be deleted by specifying the Id.DELETE FROM SalesTaxPaymentChecks WHERE Id = '80000001-1234567890'
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier for the sales tax payment check transaction. | |
| EditSequence | String | True | 16 |
A versioning identifier used for optimistic locking when updating the transaction. | |
| 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. | ||
| TxnNumber | Integer | True |
A system-assigned transaction number for the sales tax payment check. | ||
| 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. | |
| Address_Addr1 | String | True | 41 |
The first line of the address. | |
| Address_Addr2 | String | True | 41 |
The second line of the address. | |
| Address_Addr3 | String | True | 41 |
The third line of the address. | |
| Address_Addr4 | String | True | 41 |
The fourth line of the address. | |
| Address_Addr5 | String | True | 41 |
The fifth line of the address. | |
| Address_City | String | True | 31 |
The city of the address. | |
| Address_State | String | True | 21 |
The state of the address. | |
| Address_PostalCode | String | True | 13 |
The postal code of the address. | |
| Address_Country | String | True | 31 |
The country of the address. | |
| Address_Note | String | True | 41 |
A note associated with the address. | |
| AddressBlock_Addr1 | String | True | 41 |
The first line of the address block. | |
| AddressBlock_Addr2 | String | True | 41 |
The second line of the address block. | |
| AddressBlock_Addr3 | String | True | 41 |
The third line of the address block. | |
| AddressBlock_Addr4 | String | True | 41 |
The fourth line of the address block. | |
| AddressBlock_Addr5 | String | True | 41 |
The fifth line of the address block. | |
| IsToBePrinted | Boolean | True |
Indicates whether this check is marked to be printed. The default value is false. | ||
| CustomFields | String | True |
Custom fields returned from QuickBooks, formatted as XML. | ||
| SalesTaxPaymentCheckLineAggregate | String | True | 5000 |
An aggregate of line item data for adding a sales tax payment check and its associated line items in a single operation. |