DepositLineItems
Contains individual line items of bank deposits, detailing the source payments, amounts, and linked transactions that are consolidated into each deposit.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| LineId [KEY] | String | True | False | False |
Specifies the unique identifier (Id) of the deposit line item. | |
| DepositId [KEY] | String | False |
Deposits.Id | True | True |
Specifies the unique Id of the deposit. |
| SyncToken | String | True | False | False |
Specifies the version number that is used to lock the deposit line-item 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 line item record was created in the source domain. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
Specifies the date and time when the deposit line item 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. | |
| Line_Id | String | False | False | False |
Specifies the unique Id of the line item within the deposit. | |
| Line_Description | String | False | False | False |
Specifies the description of the deposit line item. | |
| Line_Amount | Decimal | False | False | False |
Specifies the amount of the deposit line item. | |
| Line_DetailType | String | False | False | False |
Specifies the detail type of the deposit line item. Different detail types indicate different types of line items. | |
| Line_DepositLineDetail_PaymentMethodRef | String | False | False | False |
Specifies the unique Id of the payment method that is used for the deposit line item. | |
| Line_DepositLineDetail_PaymentMethodRef_Name | String | False |
PaymentMethods.Name | False | False |
Specifies the name of the payment method that is used for the deposit line item. |
| Line_DepositLineDetail_AccountRef | String | False |
Accounts.Id | False | False |
Specifies the unique Id of the account where the funds are deposited. |
| Line_DepositLineDetail_AccountRef_Name | String | False |
Accounts.Name | False | False |
Specifies the name of the account where the funds are deposited. |
| Line_DepositLineDetail_Entity | String | False |
Customers.Id | False | False |
Specifies the unique Id of the customer from which the deposit was received. |
| Line_DepositLineDetail_Entity_Name | String | False |
Customers.DisplayName | False | False |
Specifies the name of the customer from which the deposit was received. |
| Line_DepositLineDetail_ClassRef | String | False |
Class.Id | False | False |
Specifies the unique Id of the class that is associated with the deposit transaction. |
| Line_DepositLineDetail_ClassRef_Name | String | False |
Class.FullyQualifiedName | False | False |
Specifies the name of the class that is associated with the deposit transaction. |
| Line_DepositLineDetail_CheckNum | String | False | False | False |
Specifies the check number for the deposit. | |
| Line_DepositLineDetail_TxnType | String | False | False | False |
Specifies the type of the payment transaction. Different types indicate different types of line items. | |
| Line_DepositLineDetail_TaxCodeRef | String | False |
TaxCodes.Id | False | False |
Specifies the sales or purchase tax code that is associated with the deposit line item. This field is valid in the UK, AU, and CA editions. |
| Line_DepositLineDetail_TaxApplicableOn | String | False | False | False |
Indicates whether the tax that is applicable on the deposit line item is sales or purchase. This field is valid in the UK, AU, and CA editions. | |
| Line_LinkedTxn_TxnId | String | True | False | False |
Specifies the unique Id of the linked transaction. | |
| Line_LinkedTxn_TxnType | String | True | False | False |
Specifies the type of the linked transaction. Different types indicate different types of line items. | |
| Line_LinkedTxn_TxnLineId | String | True | False | False |
Specifies the unique Id of the linked transaction line item. | |
| 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 | 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 | 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. |
| 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. | |
| DocNumber | String | False | True | True |
Specifies the reference number for the deposit transaction. |