ADO.NET Provider for QuickBooks Online

Build 25.0.9434

RecurringInvoiceTransactionsLineItems

Contains the line-level detail of recurring invoices, specifying products, services, amounts, and taxes that are applied each billing cycle.

Table Specific Information

RecurringInvoiceTransactions may be inserted or queried via the RecurringInvoiceTransactions or RecurringInvoiceTransactionsLineItems tables.

Select 


SELECT * FROM RecurringInvoiceTransactionsLineItems

Insert

To add a RecurringInvoiceTransactionsLineItems following fields needs to be added:

  • It must have at least one line that describes an item.
  • It must have a RecurringInfo.

INSERT INTO RecurringInvoiceTransactionsLineItems (Invoice_Id, Invoice_CustomerRef, Invoice_RecurringInfo_Name, Invoice_RecurringInfo_RecurType, Invoice_RecurringInfo_Active, Invoice_RecurringInfo_ScheduleInfo_IntervalType, Invoice_RecurringInfo_ScheduleInfo_NumInterval, Invoice_RecurringInfo_ScheduleInfo_DayOfWeek, Invoice_RecurringInfo_ScheduleInfo_WeekOfMonth, Invoice_RecurringInfo_ScheduleInfo_StartDate, Invoice_RecurringInfo_ScheduleInfo_NextDate, Invoice_RecurringInfo_ScheduleInfo_PreviousDate, Invoice_Line_DetailType, Invoice_Line_SalesItemLineDetail_ItemRef, Invoice_Line_Amount, Invoice_Line_SalesItemLineDetail_Qty, Invoice_Line_SalesItemLineDetail_DiscountAmt, Invoice_Line_SalesItemLineDetail_TaxCodeRef) VALUES (49, 2, 'TESTING155BCD11', 'Reminded', false, 'Weekly', 2, 'Tuesday', 3, '2021-12-08', '2021-12-15', '2021-09-01', 'SalesItemLineDetail', '5', 100.01, 8, 22.3, 'TAX')

Columns

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

The unique identifier (Id) of the line item within the recurring invoice transaction.

Invoice_Id [KEY] String False

RecurringInvoiceTransactions.Invoice_Id

True True

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

Invoice_SyncToken String True False False

Version number of the object that is used to lock the recurring invoice transaction 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.

Invoice_MetaData_CreateTime Datetime True True True

The date and time when the recurring invoice line item record was created in QuickBooks Online.

Invoice_MetaData_LastUpdatedTime Datetime True True True

The date and time when the recurring invoice line item record was last updated in QuickBooks Online.

Invoice_DocNumber String False True True

A reference number that is assigned to the recurring invoice transaction.

Invoice_TxnDate Date False True True

The date entered by the user when this recurring invoice transaction occurred.

Invoice_PrivateNote String False False False

A private note for the recurring invoice transaction that does not appear on transaction records.

Invoice_TxnStatus String False False False

The status of the recurring invoice transaction.

The allowed values are Accepted, Closed, Pending, Rejected.

Invoice_LinkedTxnAggregate String False False False

An XML aggregate of all transactions that are linked to this recurring invoice transaction.

Invoice_Line_LineNum String False False False

The line number identifying the position of this line item on the recurring invoice.

Invoice_Line_Description String False False False

A description of the line item as it appears in the recurring invoice transaction or printed invoice.

Invoice_Line_Amount Decimal False False False

The amount of the line item including charges or discounts but excluding taxes in the recurring invoice transaction.

Invoice_Line_DetailType String False False False

The detail type of the line item. Different detail types indicate different types of line items in the recurring invoice transaction.

Invoice_Line_SalesItemLineDetail_ItemRef String False

Items.Id

False False

The Id of the item referenced by this sales line on the recurring invoice transaction.

Invoice_Line_SalesItemLineDetail_ItemRef_Name String True

Items.Name

False False

The name of the item that is referenced by this sales line on the recurring invoice transaction.

Invoice_Line_SalesItemLineDetail_ClassRef String False

Class.Id

False False

The Id of the class that is associated with this sales line on the recurring invoice transaction.

Invoice_Line_SalesItemLineDetail_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class that is associated with this sales line on the recurring invoice transaction.

Invoice_Line_SalesItemLineDetail_UnitPrice Decimal False False False

The unit price of the item on this line of the recurring invoice transaction.

Invoice_Line_SalesItemLineDetail_Qty Double False False False

The quantity of items that is specified on this line of the recurring invoice transaction.

Invoice_Line_SalesItemLineDetail_TaxCodeRef String False

TaxCodes.Id

False False

The tax code that is applied to this item on the recurring invoice transaction.

Invoice_Line_SalesItemLineDetail_DiscountAmt Decimal False False False

The discount amount that is applied to this line item. If both the discount amount and the discount rate are supplied, the discount rate takes precedence and the discount amount is recalculated by QuickBooks Online services based on the discount-rate value.

Invoice_Line_SalesItemLineDetail_ServiceDate Date False False False

The service date for the item on this line of the recurring invoice transaction.

Invoice_Line_GroupLineDetail_GroupItemRef String True False False

The Id of the group item object referenced by this line of the recurring invoice transaction.

Invoice_Line_GroupLineDetail_GroupItemRef_Name String True False False

The name of the group item object referenced by this line of the recurring invoice transaction.

Invoice_Line_GroupLineDetail_Quantity Integer True False False

The quantity of the group item that is specified on this line of the recurring invoice transaction.

Invoice_Line_DiscountLineDetail_ClassRef String False

Class.Id

False False

The Id of the class that is associated with this discount line on the recurring invoice transaction.

Invoice_Line_DiscountLineDetail_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class that is associated with this discount line on the recurring invoice transaction.

Invoice_Line_DiscountLineDetail_TaxCodeRef String False

TaxCodes.Id

False False

The tax code that is associated with this discount line on the recurring invoice transaction.

Invoice_Line_DiscountLineDetail_TaxCodeRef_Name String True

TaxCodes.Name

False False

The name of the tax code that is associated with this discount line on the recurring invoice transaction.

Invoice_Line_DiscountLineDetail_PercentBased Boolean False False False

Indicates whether the discount for this line is a percentage (true) or an amount (false or null).

Invoice_Line_DiscountLineDetail_DiscountAccountRef String False False False

The Id of the discount account that is associated with this line item.

Invoice_Line_DiscountLineDetail_DiscountAccountRef_Name String True False False

The name of the discount account that is associated with this line item.

Invoice_Line_DiscountLineDetail_DiscountPercent Decimal False False False

The percentage by which the amount due is reduced, from 0% to 100%. For example, to enter a discount of 8.5%, use 8.5, not 0.085.

Invoice_TxnTaxDetail_TxnTaxCodeRef String False

TaxCodes.Id

False False

The tax code that is applied to the recurring invoice transaction.

Invoice_TxnTaxDetail_TotalTax String False False False

The total tax that is calculated for the recurring invoice transaction, excluding any tax lines manually inserted into the transaction-line list.

Invoice_TxnTaxDetail_TaxLineAggregate String False False False

An XML aggregate of tax line items that is associated with the recurring invoice transaction.

Invoice_RecurDataRef String False False False

The unique Id of the recurrence data reference that identifies the recurring invoice template or schedule.

Invoice_RecurDataRef_Name String True False False

The name of the recurrence data reference that identifies the recurring invoice template or schedule.

Invoice_RecurringInfo_Name String False False False

A descriptive name of the recurring invoice schedule or template.

Invoice_RecurringInfo_RecurType String False False False

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

The allowed values are Automated, Reminded, UnScheduled.

Invoice_RecurringInfo_Active Boolean False False False

Indicates whether the recurring invoice schedule is active or inactive.

Invoice_RecurringInfo_ScheduleInfo_IntervalType String False False False

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

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

Invoice_RecurringInfo_ScheduleInfo_NumInterval Integer False False False

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

Invoice_RecurringInfo_ScheduleInfo_DayOfWeek String False False False

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

Invoice_RecurringInfo_ScheduleInfo_WeekOfMonth String False False False

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

Invoice_RecurringInfo_ScheduleInfo_MaxOccurrences String False False False

The maximum number of occurrences that are allowed for the recurring invoice schedule.

Invoice_RecurringInfo_ScheduleInfo_RemindDays String False False False

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

Invoice_RecurringInfo_ScheduleInfo_MonthOfYear String False False False

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

Invoice_RecurringInfo_ScheduleInfo_DaysBefore String False False False

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

Invoice_RecurringInfo_ScheduleInfo_DayOfMonth String False False False

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

Invoice_RecurringInfo_ScheduleInfo_StartDate Datetime False False False

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

Invoice_RecurringInfo_ScheduleInfo_NextDate Datetime False False False

The next scheduled date for the recurring invoice to occur.

Invoice_RecurringInfo_ScheduleInfo_EndDate Datetime False False False

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

Invoice_RecurringInfo_ScheduleInfo_PreviousDate Datetime False False False

The previous scheduled date on which the recurring invoice occurred.

Invoice_CustomerRef String False

Customers.Id

True False

The unique Id of the customer that is associated with the recurring invoice transaction.

Invoice_CustomerRef_Name String True

Customers.DisplayName

False False

The name of the customer that is associated with the recurring invoice transaction.

Invoice_CustomerMemo String False False False

a message to the customer that appears in the recurring invoice and the printed invoice.

Invoice_BillAddr_Id String False False False

The Id of the entity for the billing address, mainly used for modifying the address. This field is assigned by the data service.

Invoice_BillAddr_Line1 String False False False

First line of the billing address.

Invoice_BillAddr_Line2 String False False False

Second line of the billing address.

Invoice_BillAddr_Line3 String False False False

Third line of the billing address.

Invoice_BillAddr_Line4 String False False False

Fourth line of the billing address.

Invoice_BillAddr_Line5 String False False False

Fifth line of the billing address.

Invoice_BillAddr_City String False False False

City name of the billing address.

Invoice_BillAddr_Country String False False False

Country name of the billing address.

Invoice_BillAddr_CountrySubDivisionCode String False False False

The region within a country for the billing address. For example, this value is the state name for the USA or the province name for Canada.

Invoice_BillAddr_PostalCode String False False False

The postal code for the billing address. For example, this value is the ZIP code for the USA and the postal code for Canada.

Invoice_BillAddr_Note String False False False

A customer note for the billing address.

Invoice_BillAddr_Lat String False False False

The latitude coordinate of the geocoded billing address.

Invoice_BillAddr_Long String False False False

The longitude coordinate of the geocoded billing address.

Invoice_ShipAddr_Id String False False False

The Id of the entity for the shipping address, mainly used for modifying the address. This field is assigned by the data service.

Invoice_ShipAddr_Line1 String False False False

The first line of the shipping address.

Invoice_ShipAddr_Line2 String False False False

The second line of the shipping address.

Invoice_ShipAddr_Line3 String False False False

The third line of the shipping address.

Invoice_ShipAddr_Line4 String False False False

The fourth line of the shipping address.

Invoice_ShipAddr_Line5 String False False False

The fifth line of the shipping address.

Invoice_ShipAddr_City String False False False

The city name of the shipping address.

Invoice_ShipAddr_Country String False False False

The country name of the shipping address.

Invoice_ShipAddr_CountrySubDivisionCode String False False False

The region within a country for the shipping address. For example, this value is the state name for the USA or the province name for Canada.

Invoice_ShipAddr_PostalCode String False False False

The postal code for the shipping address. For example, this value is the ZIP code for the USA and the postal code for Canada.

Invoice_ShipAddr_Note String False False False

A note for the customer for the shipping address.

Invoice_ShipAddr_Lat String False False False

The latitude coordinate of the geocoded shipping address.

Invoice_ShipAddr_Long String False False False

The longitude coordinate of the geocoded shipping address.

Invoice_ClassRef String False

Class.Id

True False

The unique Id of the class that is associated with the transaction.

Invoice_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class that is associated with the transaction.

Invoice_SalesTermRef String False

Terms.Id

False False

The unique Id of the sales terms that is associated with the transaction.

Invoice_SalesTermRef_Name String True

Terms.Name

False False

The name of the sales terms that is associated with the transaction.

Invoice_DueDate Date False True False

The date when the invoice is to be paid, not including any early-payment discount incentives or late-payment penalties. If the date is not supplied, the current date on the server is used.

Invoice_ShipMethodRef String False False False

The Id of the shipping method that is associated with the transaction.

Invoice_ShipMethodRef_Name String True False False

The name of the shipping method that is associated with the transaction.

Invoice_ShipDate Date False False False

The date for the delivery of goods or services.

Invoice_TrackingNum String False False False

The tracking number for the shipping provider for the delivery of the goods that is associated with the transaction.

Invoice_TotalAmt Decimal True True True

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

Invoice_PrintStatus String False False False

The print status of the invoice.

The allowed values are NotSet, NeedToPrint, PrintComplete.

The default value is NotSet.

Invoice_EmailStatus String False False False

The email status of the invoice.

The allowed values are NotSet, NeedToSend, EmailSent.

The default value is NotSet.

Invoice_BillEmail_Address String False False False

The email address where the invoice is sent. If the value of the EmailStatus attribute is NeedToSend, the billing email address is required.

Invoice_Balance Decimal True True True

Indicates whether the transaction is a finance charge.

Invoice_DepartmentRef String False

Departments.Id

False False

The Id of the department, which stores the location of the transaction as defined by using location tracking in QuickBooks Online.

Invoice_DepartmentRef_Name String True

Departments.Name

False False

Name of the department, which stores the location of the transaction as defined by using location tracking in QuickBooks Online.

Invoice_AllowOnlineCreditCardPayment Boolean False False False

Specifies whether online credit-card payments are allowed for this invoice and corresponds to the Cards online-payment checkbox in the QuickBooks UI.

Invoice_ApplyTaxAfterDiscount Boolean False False False

Sets whether discounts are applied before the tax is calculated.

Invoice_CurrencyRef String False False False

The Id of the currency that is used in the transaction.

Invoice_CurrencyRef_Name String True False False

The name of the currency that is used in the transaction.

Invoice_ExchangeRate Decimal False False False

Currency exchange rate. This field is valid only when the company file is set up to use the multicurrency feature. In QuickBooks, exchange rates are always recorded as the number of home currency units it takes to equal one foreign currency unit. This field is available only for the UK, AU, and CA editions.

Invoice_GlobalTaxCalculation String False False False

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.

Invoice_HomeTotalAmt Decimal True False False

The total amount of the transaction in the home currency. This amount includes the total of all charges, allowances, and taxes. This field is valid in the UK, AU, and CA editions.

Invoice_AllowOnlineACHPayment Boolean True False False

Indicates whether online ACH payment is allowed.

Invoice_GroupSalesItemLineAggregate String True False False

An XML aggregate of all line items that belong to grouped sales items in the recurring invoice transaction.

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