CData Python Connector for QuickBooks Online

Build 25.0.9454

RecurringDepositTransactionsLineItems

Contains line-level details of recurring deposits, such as payment sources and amounts, supporting automation of regular income deposits.

Columns

Name Type ReadOnly References Filterable Sortable Description
Deposit_LineId [KEY] String True False False

The unique identifier (Id) of the line item within the recurring deposit transaction. This identifier ties the line item back to its parent deposit record.

Deposit_DepositId [KEY] String False

Deposits.Id

True True

The Id of the parent recurring deposit transaction to which this line item belongs.

Deposit_SyncToken String True False False

The version number of the object that is used to lock the line item for use by one application at a time. As soon as an application modifies an object, its sync token is incremented. Attempts to modify an object specifying an older sync token fail. Only the latest version of the object is maintained by QuickBooks Online.

Deposit_MetaData_CreateTime Datetime True True True

The date and time when this recurring deposit line-item record was created in QuickBooks Online.

Deposit_MetaData_LastUpdatedTime Datetime True True True

The date and time when this recurring deposit line-item record was last updated in QuickBooks Online.

Deposit_TxnDate Date False True True

The date that is entered by the user when this recurring deposit line-item transaction occurred.

Deposit_PrivateNote String False False False

A private note for the recurring deposit line-item transaction that does not appear on the transaction records.

Deposit_Line_Id String False False False

The Id of the individual line item within the recurring deposit transaction.

Deposit_Line_Description String False False False

A descriptive text for the recurring deposit line item that appears in the printed or displayed record.

Deposit_Line_Amount Decimal False False False

The monetary amount of the recurring deposit line item. This amount includes charges or credits for that line, but excludes tax amounts.

Deposit_Line_DetailType String False False False

The detail type of the recurring deposit line item. Different detail types indicate different kinds of line items, such as payments, adjustments, or credits.

Deposit_Line_DepositLineDetail_PaymentMethodRef String False

PaymentMethods.Id

False False

The Id of the payment method that is associated with this line item.

Deposit_Line_DepositLineDetail_PaymentMethodRef_Name String False

PaymentMethods.Name

False False

The name of the payment method that is associated with this line item.

Deposit_Line_DepositLineDetail_AccountRef String False

Accounts.Id

False False

The Id of the account where the funds from this line item are deposited.

Deposit_Line_DepositLineDetail_AccountRef_Name String False

Accounts.Name

False False

The name of the account where the funds from this line item are deposited.

Deposit_Line_DepositLineDetail_Entity String False

Customers.Id

False False

The Id of the customer or entity from which the deposit was received for this line item.

Deposit_Line_DepositLineDetail_Entity_Name String False

Customers.DisplayName

False False

The name of the customer or entity from which the deposit was received for this line item.

Deposit_Line_DepositLineDetail_ClassRef String False

Class.Id

False False

The Id of the class that is associated with this recurring deposit line item for location or category tracking.

Deposit_Line_DepositLineDetail_ClassRef_Name String False

Class.FullyQualifiedName

False False

The name of the class that is associated with this recurring deposit line item for location or category tracking.

Deposit_Line_DepositLineDetail_CheckNum String False False False

The check number that is associated with this recurring deposit line item, if the payment was made by check.

Deposit_Line_DepositLineDetail_TxnType String False False False

The type of payment transaction for this line item. Different types indicate different kinds of line items.

Deposit_Line_DepositLineDetail_TaxCodeRef String False

TaxCodes.Id

False False

The sales or purchase tax code associated with this recurring deposit line item. This field is valid in the UK, AU, and CA editions.

Deposit_Line_DepositLineDetail_TaxApplicableOn String False False False

Indicates whether the tax applicable on this line item is sales tax or purchase tax. This field is valid in the UK, AU, and CA editions.

Deposit_Line_LinkedTxn_TxnId String True False False

The Id of the linked transaction that is connected to this recurring deposit line item.

Deposit_Line_LinkedTxn_TxnType String True False False

The type of the linked transaction that is connected to this recurring deposit line item.

Deposit_Line_LinkedTxn_TxnLineId String True False False

The Id of the specific line item within the linked transaction that is connected to this recurring deposit line item.

Deposit_TxnTaxDetail_TxnTaxCodeRef String False

TaxCodes.Id

False False

The tax code that is applied to the recurring deposit transaction. This field is valid in the UK, AU, and CA editions.

Deposit_TxnTaxDetail_TotalTax String False False False

The total tax amount that is calculated for the recurring deposit transaction, excluding any tax lines that are manually inserted into the transaction line list. This field is valid in the UK, AU, and CA editions.

Deposit_TxnTaxDetail_TaxLineAggregate String False False False

An XML aggregate that contains all tax line items associated with the recurring deposit transaction. This field is valid in the UK, AU, and CA editions.

Deposit_RecurDataRef String False False False

The unique Id of the recurrence data reference that identifies the template or schedule driving this recurring deposit transaction line item.

Deposit_RecurDataRef_Name String True False False

The name of the recurrence data reference that identifies the template or schedule driving this recurring deposit transaction line item.

Deposit_RecurringInfo_Name String False False False

The descriptive name of the recurring deposit schedule or template.

Deposit_RecurringInfo_RecurType String False False False

The recurring type of the deposit schedule, such as scheduled, reminder, or unscheduled.

The allowed values are Automated, Reminded, UnScheduled.

Deposit_RecurringInfo_Active Boolean False False False

Indicates whether the recurring deposit schedule is active or inactive.

Deposit_RecurringInfo_ScheduleInfo_IntervalType String False False False

The interval type of the recurring deposit schedule that defines how often the deposit recurs (for example, weekly, monthly, or yearly).

The allowed values are Yearly, Monthly, Weekly, Daily.

Deposit_RecurringInfo_ScheduleInfo_NumInterval Integer False False False

The number of intervals for the recurring deposit schedule. This value determines how frequently the deposit recurs based on the interval type.

Deposit_RecurringInfo_ScheduleInfo_DayOfWeek String False False False

The day of the week on which the recurring deposit is scheduled to occur when the interval type is weekly.

Deposit_RecurringInfo_ScheduleInfo_WeekOfMonth String False False False

The week of the month on which the recurring deposit is scheduled to occur when the interval type is monthly.

Deposit_RecurringInfo_ScheduleInfo_MaxOccurrences String False False False

The maximum number of occurrences allowed for the recurring deposit schedule.

Deposit_RecurringInfo_ScheduleInfo_RemindDays String False False False

The number of days before the start date on which a reminder for the recurring deposit should be sent.

Deposit_RecurringInfo_ScheduleInfo_MonthOfYear String False False False

The month of the year on which the recurring deposit is scheduled to occur when the interval type is yearly.

Deposit_RecurringInfo_ScheduleInfo_DaysBefore String False False False

The number of days before the scheduled date on which the recurring deposit is processed or triggered.

Deposit_RecurringInfo_ScheduleInfo_DayOfMonth String False False False

The day of the month on which the recurring deposit is scheduled to occur.

Deposit_RecurringInfo_ScheduleInfo_StartDate Datetime False False False

The start date of the recurring deposit schedule that is associated with the recurrence template.

Deposit_RecurringInfo_ScheduleInfo_NextDate Datetime False False False

The next scheduled date for the recurring deposit to occur.

Deposit_RecurringInfo_ScheduleInfo_EndDate Datetime False False False

The end date of the recurring deposit schedule when no further occurrences are generated.

Deposit_RecurringInfo_ScheduleInfo_PreviousDate Datetime False False False

The previous scheduled date on which the recurring deposit occurred.

Deposit_DepositToAccountRef String False

Accounts.Id

False False

The Id of the asset account where the funds for this recurring deposit are deposited.

Deposit_DepositToAccountRef_Name String False

Accounts.Name

False False

The name of the asset account where the funds for this recurring deposit are deposited.

Deposit_ClassRef String False

Class.Id

False False

The Id of the class that is associated with this recurring deposit transaction for location or category tracking.

Deposit_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class that is associated with this recurring deposit transaction for location or category tracking.

Deposit_TotalAmt Decimal True True True

The total monetary amount of the recurring deposit transaction. This includes all charges, allowances, and taxes.

Deposit_CashBack_AccountRef String True True False

The Id of the asset account (bank account) to be used for the cash-back portion of this recurring deposit transaction.

Deposit_CashBack_AccountRef_Name String False False False

The name of the asset account (bank account) to be used for the cash-back portion of this recurring deposit transaction.

Deposit_CashBack_Amount Decimal False False False

The amount of the cash-back portion of this recurring deposit transaction.

Deposit_CashBack_Memo String True True False

The memo or descriptive text associated with the cash-back portion of this recurring deposit transaction.

Deposit_DepartmentRef String False

Departments.Id

False False

The Id of the department or location that is associated with this recurring deposit transaction as defined by using location tracking in QuickBooks Online.

Deposit_DepartmentRef_Name String True

Departments.Name

False False

The name of the department or location that is associated with this recurring deposit transaction as defined by using location tracking in QuickBooks Online.

Deposit_ApplyTaxAfterDiscount Boolean False False False

Sets whether discounts are applied before or after tax is calculated on this recurring deposit transaction.

Deposit_CurrencyRef String False False False

The Id of the currency that is used for all amounts in this recurring deposit transaction.

Deposit_CurrencyRef_Name String True False False

The name of the currency that is used for all amounts in this recurring deposit transaction.

Deposit_GlobalTaxCalculation String False False False

The method in which tax is applied to this recurring deposit transaction. This field is valid in the UK, AU, and CA editions.

The allowed values are TaxExcluded, TaxInclusive, NotApplicable.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454