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.