PaymentMethods
Table schema for PaymentMethods. QuickBooks will allow PaymentMethods to be used in Select/Insert/Delete operations.
Columns
| Name | Type | Description | ReadOnly |
| ID [KEY] | String |
The unique identifier of the PaymentMethod. | True |
| Name | String |
The name of the PaymentMethod. | False |
| IsActive | Boolean |
Boolean determining if the PaymentMethod is active. | False |
| PaymentMethodType | String |
The payment method. Requires QBXML 7.0 or higher. The allowed values are AmericanExpress, Cash, Check, DebitCard, Discover, ECheck, GiftCard, MasterCard, Other, OtherCreditCard, Visa. | False |
| EditSequence | String |
A string indicating the revision of the PaymentMethod. | True |
| TimeCreated | Datetime |
The time the PaymentMethod was created. | True |
| TimeModified | Datetime |
The last time the PaymentMethod was modified. | True |
Pseudo-Columns
Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| StartModifiedDate | String |
Earliest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format) | |
| EndModifiedDate | String |
Latest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format). | |
| NameMatch | String |
The type of match to use if specifying the name. The allowed values are CONTAINS, EXACT, STARTSWITH, ENDSWITH. | |
| ActiveStatus | String |
The status of the customers included in the results. The allowed values are ACTIVE, INACTIVE, ALL, NA. The default value is ALL. |