Deposits
Maintains bank-deposit records that show lump-sum deposits, associated line items, and account allocations for accurate bank reconciliation.
Table Specific Information
Select
All filterable columns support the following operators:
- =
- !=
- >=
- <=
- >
- <
- IN
- LIKE
- CONTAINS
The driver processes other filters client-side within the driver.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| Id [KEY] | String | True | True | True |
Specifies the unique identifier (Id) of the deposit transaction. | |
| SyncToken | String | True | False | False |
Specifies the version number that is used to lock the deposit transaction object for use by one application at a time. When an application modifies an object, its sync token is incremented. Attempts to modify an object with an older sync token fail. | |
| MetaData_CreateTime | Datetime | True | True | True |
Specifies the date and time when the deposit transaction record was created in the source domain. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
Specifies the date and time when the deposit transaction record was last updated in the source domain. | |
| TxnDate | Date | False | True | True |
Specifies the date entered by the user when the deposit transaction occurred. | |
| PrivateNote | String | False | False | False |
Specifies a private note that does not appear on the deposit transaction records. | |
| LineAggregate | String | False | False | False |
Specifies an XML aggregate of line items that are associated with the deposit transaction. | |
| TxnTaxDetail_TxnTaxCodeRef | String | False |
TaxCodes.Id | False | False |
Specifies the tax code for the deposit transaction. This field is valid in the UK, AU, and CA editions. |
| TxnTaxDetail_TotalTax | String | False | False | False |
Specifies the total tax calculated for the deposit transaction, excluding any tax lines manually inserted into the transaction line list. This field is valid in the UK, AU, and CA editions. | |
| TxnTaxDetail_TaxLineAggregate | String | False | False | False |
Specifies an XML aggregate of tax line items that are associated with the deposit transaction. This field is valid in the UK, AU, and CA editions. | |
| DepositToAccountRef | String | False |
Accounts.Id | False | False |
Specifies the unique Id of the asset account that is used for this deposit. |
| DepositToAccountRef_Name | String | False |
Accounts.Name | False | False |
Specifies the name of the asset account that is used for this deposit. |
| TotalAmt | Decimal | True | False | False |
Specifies the total amount of the deposit transaction, including all charges, allowances, and taxes. | |
| CashBack_AccountRef | String | True |
Accounts.Id | False | False |
Specifies the unique Id of the asset account (bank account) that is used for this cash-back transaction. |
| CashBack_AccountRef_Name | String | False |
Accounts.Name | False | False |
Specifies the name of the asset account (bank account) that is used for this cash-back transaction. |
| CashBack_Amount | Decimal | False | False | False |
Specifies the amount of the cash-back transaction. | |
| CashBack_Memo | String | True | False | False |
Specifies the memo that is associated with this cash-back transaction. | |
| DepartmentRef | String | False |
Departments.Id | False | False |
Specifies the unique Id of the department that stores the location of the deposit transaction as defined using location tracking in QuickBooks Online. |
| DepartmentRef_Name | String | True |
Departments.Name | False | False |
Specifies the name of the department that stores the location of the deposit transaction as defined using location tracking in QuickBooks Online. |
| ExchangeRate | Decimal | False | False | False |
Specifies the number of home currency units it takes to equal one unit of the currency specified by the CurrencyRef attribute. This field is applicable if multicurrency is enabled for the company. | |
| CurrencyRef | String | False | False | False |
Specifies the unique Id of the currency used in the deposit transaction. | |
| CurrencyRef_Name | String | True | False | False |
Specifies the name of the currency used in the deposit transaction. | |
| GlobalTaxCalculation | String | False | False | False |
Specifies the method in which tax is applied. This field is valid in the UK, AU, and CA editions. The allowed values are TaxExcluded, TaxInclusive, NotApplicable. | |
| TransactionLocationType | String | False | False | False |
Specifies the account location for the deposit transaction. This field is valid only in the FR edition. The allowed values are WithinFrance, FranceOverseas, OutsideFranceWithEU, OutsideEU. | |
| TxnSource | String | False | False | False |
Specifies the originating source of a credit card transaction. This field is used internally. | |
| RecurDataRef | String | True | False | False |
Specifies the unique Id of the reference to the recurring transaction template from which the deposit was created. | |
| HomeTotalAmt | Decimal | True | False | False |
Specifies the total amount of the deposit transaction in the home currency, including all charges, allowances, and taxes. | |
| DocNumber | String | False | True | True |
Specifies the reference number for the deposit transaction. |