RecurringInvoiceTransactions

Columns

Name	Type	ReadOnly	References	Filterable	Sortable	Description
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_LineAggregate	String	False		false	false	An XML aggregate of the line items of a transaction.
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.