RecurringJournalEntryTransactions
Columns
Name
Type
ReadOnly
References
Filterable
Sortable
Description
JournalEntry_Id [KEY]
String
True
true
true
The Id of the Recurring Transaction.
JournalEntry_SyncToken
String
True
false
false
The Version number of the object.
JournalEntry_MetaData_CreateTime
Datetime
True
true
true
The time the record was created.
JournalEntry_MetaData_LastUpdatedTime
Datetime
True
true
true
The time the record was last updated.
JournalEntry_CurrencyRef
String
True
false
false
The Id of the currency used in the transaction.
JournalEntry_CurrencyRef_Name
String
True
false
false
The name of the currency used in the transaction.
JournalEntry_LineAggregate
String
False
false
false
An XML aggregate of the line items of a transaction.
JournalEntry_RecurDataRef
String
True
false
false
The Recurrence Data reference.
JournalEntry_RecurringInfo_Name
String
False
false
false
The Recurring Info name.
JournalEntry_RecurringInfo_RecurType
String
False
false
false
The Recurring Info recurring type.
JournalEntry_RecurringInfo_Active
Boolean
False
false
false
The Recurring Info is active or not.
JournalEntry_RecurringInfo_ScheduleInfo_DayOfWeek
String
False
false
false
The Recurring Info day of week.
JournalEntry_RecurringInfo_ScheduleInfo_IntervalType
String
False
false
false
The Recurring Info interval type.
JournalEntry_RecurringInfo_ScheduleInfo_WeekOfMonth
String
False
false
false
The Recurring Info week of month.
JournalEntry_RecurringInfo_ScheduleInfo_NumInterval
Integer
False
false
false
The Recurring Info num interval.
JournalEntry_RecurringInfo_ScheduleInfo_DayOfMonth
String
False
false
false
The Recurring Info day of month.
JournalEntry_RecurringInfo_ScheduleInfo_MaxOccurrences
String
False
false
false
The max number of recurring occurrences.
JournalEntry_RecurringInfo_ScheduleInfo_StartDate
Datetime
False
false
false
The Recurring Info start date.
JournalEntry_RecurringInfo_ScheduleInfo_NextDate
Datetime
False
false
false
The Recurring Info next date.
JournalEntry_RecurringInfo_ScheduleInfo_PreviousDate
Datetime
False
false
false
The Recurring Info previous date.
JournalEntry_TxnTaxDetail_TxnTaxCodeRef
String
False
TaxCodes.Id
false
false
The transaction tax code.
JournalEntry_TxnTaxDetail_TotalTax
String
False
false
false
Total tax calculated for the transaction, excluding any tax lines manually inserted into the transaction line list.
JournalEntry_TxnTaxDetail_TaxLineAggregate
String
False
false
false
An XML aggregate of tax line items.
JournalEntry_TotalAmt
Decimal
True
false
false
The total bill amount.
JournalEntry_Adjustment
Boolean
True
false
false
Is adjustment done or not.
JournalEntry_ExchangeRate
Decimal
False
false
false
The currency exchange rate. This field is only valid if the company file uses 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 in only the UK, AU, IN, and CA editions.
Last updated