RecurringInvoiceTransactionsLineItems
Columns
Name
Type
ReadOnly
References
Filterable
Sortable
Description
Invoice_Line_Id [KEY]
String
False
false
false
The Id of the line item of the invoice.
Invoice_Id [KEY]
String
False
RecurringInvoiceTransactions.Invoice_Id
true
true
The Id of the Recurring Transaction.
Invoice_SyncToken
String
True
false
false
The Version number of the object.
Invoice_MetaData_CreateTime
Datetime
True
true
true
The time the record was created.
Invoice_MetaData_LastUpdatedTime
Datetime
True
true
true
The time the record was last updated.
Invoice_CustomFieldAggregate
String
False
false
false
Am XML aggregate of custom field information.
Invoice_DocNumber
String
False
true
true
The reference number for the transaction.
Invoice_TxnDate
Date
False
true
true
The date entered by the user when this transaction occurred.
Invoice_PrivateNote
String
False
false
false
A private note for the transaction, which does not appear on the transaction records.
Invoice_TxnStatus
String
False
false
false
The status of the transaction.
The allowed values are Accepted, Closed, Pending, Rejected.
Invoice_LinkedTxnAggregate
String
False
false
false
An XML aggregate of transactions linked to the estimate.
Invoice_Line_Id
String
False
false
false
The Id of the line item.
Invoice_Line_LineNum
String
False
false
false
The line number of the line item.
Invoice_Line_Description
String
False
false
false
The description of the line item.
Invoice_Line_Amount
Decimal
False
false
false
The amount of the line item.
Invoice_Line_DetailType
String
False
false
false
The detail type of the line item. Different detail types indicate different types of line items.
Invoice_Line_SalesItemLineDetail_ItemRef
String
False
Items.Id
false
false
The Id of the item in the line item.
Invoice_Line_SalesItemLineDetail_ItemRef_Name
String
True
Items.Name
false
false
The name of the item in the line item.
Invoice_Line_SalesItemLineDetail_ClassRef
String
False
Class.Id
false
false
The Id of the class in the line item.
Invoice_Line_SalesItemLineDetail_ClassRef_Name
String
True
Class.FullyQualifiedName
false
false
The name of the class in the line item.
Invoice_Line_SalesItemLineDetail_UnitPrice
Decimal
False
false
false
The unit price of the item.
Invoice_Line_SalesItemLineDetail_Qty
Double
False
false
false
The number of items for the line item.
Invoice_Line_SalesItemLineDetail_TaxCodeRef
String
False
TaxCodes.Id
false
false
The tax code for the item.
Invoice_Line_SalesItemLineDetail_DiscountAmt
Decimal
False
false
false
The discount rate applied to an individual line item. If both DiscountAmt and DiscountRate are supplied, DiscountRate takes precedence and DiscountAmt is recalculated by QuickBooks services based on amount of DiscountRate.
Invoice_Line_SalesItemLineDetail_ServiceDate
Date
False
false
false
The service date for the item.
Invoice_Line_GroupLineDetail_GroupItemRef
String
True
false
false
The Id of the group item object.
Invoice_Line_GroupLineDetail_GroupItemRef_Name
String
True
false
false
The name of the group item object.
Invoice_Line_GroupLineDetail_Quantity
Integer
True
false
false
The amount of the group item.
Invoice_Line_DiscountLineDetail_ClassRef
String
False
Class.Id
false
false
The Id of the class in the line item.
Invoice_Line_DiscountLineDetail_ClassRef_Name
String
True
Class.FullyQualifiedName
false
false
The name of the class in the line item.
Invoice_Line_DiscountLineDetail_TaxCodeRef
String
False
TaxCodes.Id
false
false
The tax code for the item.
Invoice_Line_DiscountLineDetail_TaxCodeRef_Name
String
True
TaxCodes.Name
false
false
The name for the tax sales code.
Invoice_Line_DiscountLineDetail_PercentBased
Boolean
False
false
false
True if the discount is a percentage; null or false if discount based on amount.
Invoice_Line_DiscountLineDetail_DiscountAccountRef
String
False
false
false
The discount code for the item.
Invoice_Line_DiscountLineDetail_DiscountAccountRef_Name
String
True
false
false
The name for the discount account.
Invoice_Line_DiscountLineDetail_DiscountPercent
Decimal
False
false
false
Percentage by which the amount due is reduced, from 0% to 100%. 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 for the transaction.
Invoice_TxnTaxDetail_TotalTax
String
False
false
false
The total tax calculated for the 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.
Invoice_RecurDataRef
String
False
false
false
The Recurrence Data reference.
Invoice_RecurDataRef_Name
String
True
false
false
An identifying name for the object.
Invoice_RecurringInfo_Name
String
False
false
false
The Recurring Info name.
Invoice_RecurringInfo_RecurType
String
False
false
false
The Recurring Info recurring type.
The allowed values are Automated, Reminded, UnScheduled.
Invoice_RecurringInfo_Active
Boolean
False
false
false
The Recurring Info is active or not.
Invoice_RecurringInfo_ScheduleInfo_IntervalType
String
False
false
false
The Recurring Info interval type.
The allowed values are Yearly, Monthly, Weekly, Daily.
Invoice_RecurringInfo_ScheduleInfo_NumInterval
Integer
False
false
false
The Recurring Info num interval.
Invoice_RecurringInfo_ScheduleInfo_DayOfWeek
String
False
false
false
The Recurring Info day of week.
Invoice_RecurringInfo_ScheduleInfo_WeekOfMonth
String
False
false
false
The Recurring Info week of month.
Invoice_RecurringInfo_ScheduleInfo_MaxOccurrences
String
False
false
false
The max number of recurring occurrences.
Invoice_RecurringInfo_ScheduleInfo_RemindDays
String
False
false
false
The days before start date for a reminded RecurType.
Invoice_RecurringInfo_ScheduleInfo_MonthOfYear
String
False
false
false
The month of the year.
Invoice_RecurringInfo_ScheduleInfo_DaysBefore
String
False
false
false
The days before the scheduled date.
Invoice_RecurringInfo_ScheduleInfo_DayOfMonth
String
False
false
false
The day of the month.
Invoice_RecurringInfo_ScheduleInfo_StartDate
Datetime
False
false
false
The Recurring Info start date.
Invoice_RecurringInfo_ScheduleInfo_NextDate
Datetime
False
false
false
The Recurring Info next date.
Invoice_RecurringInfo_ScheduleInfo_EndDate
Datetime
False
false
false
The end date for the recurring schedule.
Invoice_RecurringInfo_ScheduleInfo_PreviousDate
Datetime
False
false
false
The Recurring Info previous date.
Invoice_CustomerRef
String
False
Customers.Id
true
false
The Id of the customer.
Invoice_CustomerRef_Name
String
True
Customers.DisplayName
false
false
The name of the customer.
Invoice_CustomerMemo
String
False
false
false
The message to the customer, which appears in the 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 address.
Invoice_BillAddr_Line2
String
False
false
false
Second line of the address.
Invoice_BillAddr_Line3
String
False
false
false
Third line of the address.
Invoice_BillAddr_Line4
String
False
false
false
Fourth line of the address.
Invoice_BillAddr_Line5
String
False
false
false
Fifth line of the address.
Invoice_BillAddr_City
String
False
false
false
City name.
Invoice_BillAddr_Country
String
False
false
false
Country name.
Invoice_BillAddr_CountrySubDivisionCode
String
False
false
false
Region within a country. For example, the state name for the USA or the province name for Canada.
Invoice_BillAddr_PostalCode
String
False
false
false
Postal code. For example, the zip code for the USA and Canada.
Invoice_BillAddr_Note
String
False
false
false
Note for the customer.
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
First line of the address.
Invoice_ShipAddr_Line2
String
False
false
false
Second line of the address.
Invoice_ShipAddr_Line3
String
False
false
false
Third line of the address.
Invoice_ShipAddr_Line4
String
False
false
false
Fourth line of the address.
Invoice_ShipAddr_Line5
String
False
false
false
Fifth line of the address.
Invoice_ShipAddr_City
String
False
false
false
City name.
Invoice_ShipAddr_Country
String
False
false
false
Country name.
Invoice_ShipAddr_CountrySubDivisionCode
String
False
false
false
Region within a country. For example, the state name for the USA and the province name for Canada.
Invoice_ShipAddr_PostalCode
String
False
false
false
Postal code. For example, the zip code for the USA and Canada.
Invoice_ShipAddr_Note
String
False
false
false
Note for the customer.
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 Id of the class associated with the transaction.
Invoice_ClassRef_Name
String
True
Class.FullyQualifiedName
false
false
The name of the class associated with the transaction.
Invoice_SalesTermRef
String
False
Terms.Id
false
false
The Id of the sales terms associated with the transaction.
Invoice_SalesTermRef_Name
String
True
Terms.Name
false
false
The name of the sales terms 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 associated with the transaction.
Invoice_ShipMethodRef_Name
String
True
false
false
The name of the shipping method associated with the transaction.
Invoice_ShipDate
Date
False
false
false
The date for delivery of goods or services.
Invoice_TrackingNum
String
False
false
false
The tracking number for the shipping provider for the delivery of the goods associated with the transaction.
Invoice_TotalAmt
Decimal
True
true
true
The total amount of the transaction. This includes the total of all the 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 EmailStatus is NeedToSend, BillEmail is a required input.
Invoice_Balance
Decimal
True
true
true
This field 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 using location tracking in QuickBooks Online.
Invoice_DepartmentRef_Name
String
True
Departments.Name
false
false
The name of the department, which stores the location of the transaction as defined using location tracking in QuickBooks Online.
Invoice_AllowOnlineCreditCardPayment
Boolean
False
false
false
It specifies if online credit card payments are allowed for this invoice and corresponds to the Cards online payment check box on the QuickBooks UI.
Invoice_ApplyTaxAfterDiscount
Boolean
False
false
false
This field sets whether discounts are applied before the tax is calculated.
Invoice_CurrencyRef
String
False
false
false
The Id of the currency used in the transaction.
Invoice_CurrencyRef_Name
String
True
false
false
The name of the currency used in the transaction.
Invoice_ExchangeRate
Decimal
False
false
false
The currency exchange rate. Valid only if the company file is set up to use 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 for only the UK, AU, IN, and CA editions.
Invoice_GlobalTaxCalculation
String
False
false
false
The method in which tax is applied. This field is valid in the UK, AU, IN, 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. Includes the total of all the charges, allowances, and taxes. This field is valid in the UK, AU, IN, and CA editions.
Invoice_AllowOnlineCreditCardPayment
Boolean
True
false
false
To allow Online Credit Card Payment or not.
Invoice_AllowOnlineACHPayment
Boolean
True
false
false
To allow Online ACH Payment or not.
Last updated