RecurringJournalEntryTransactionsLineItems

Columns

Name

Type

ReadOnly

References

Filterable

Sortable

Description

JournalEntry_Line_Id [KEY]

String

False

false

false

The Id of the recurring transaction line item for the journal entry.

JournalEntry_Id [KEY]

String

False

RecurringJournalEntryTransactions.JournalEntry_Id

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

False

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_Line_Id

String

False

false

false

The Id of the line item.

JournalEntry_Line_Description

String

False

false

false

A description of the line item that appears in the printed record.

JournalEntry_Line_Amount

Decimal

False

false

false

The amount of the line item.

JournalEntry_Line_DetailType

String

False

false

false

The detail type of the line item. Different detail types indicate different types of line items.

JournalEntry_Line_JournalEntryLineDetail_PostingType

String

False

false

false

This field indicates the posting type of the line item of the journal entry detail.

The allowed values are Credit, Debit.

JournalEntry_Line_JournalEntryLineDetail_Entity_Type

String

False

false

false

The type of the entity to be referenced.

JournalEntry_Line_JournalEntryLineDetail_Entity_EntityRef

String

False

false

false

The Id of the entity to be referenced.

JournalEntry_Line_JournalEntryLineDetail_Entity_EntityRef_Name

String

True

false

false

The name of the entity to be referenced.

JournalEntry_Line_JournalEntryLineDetail_AccountRef

String

False

Accounts.Id

false

false

The Id of the account associated with the journal entry line item.

JournalEntry_Line_JournalEntryLineDetail_AccountRef_Name

String

True

Accounts.Name

false

false

The name of the account associated with the journal entry line item.

JournalEntry_Line_JournalEntryLineDetail_ClassRef

String

False

Class.Id

false

false

The Id of the class associated with the journal entry line item.

JournalEntry_Line_JournalEntryLineDetail_ClassRef_Name

String

True

Class.FullyQualifiedName

false

false

The name of the class associated with the journal entry line.

JournalEntry_Line_JournalEntryLineDetail_DepartmentRef

String

False

Departments.Id

false

false

The Id of the department associated with the journal entry line.

JournalEntry_Line_JournalEntryLineDetail_DepartmentRef_Name

String

True

Departments.Name

false

false

The name of the department associated with the journal entry line.

JournalEntry_Line_JournalEntryLineDetail_TaxCodeRef

String

False

TaxCodes.Id

false

false

The sales or purchase tax code associated with the journal entry line. This field is used for non-U.S., non-Canadian companies. This field is valid for the UK and IN editions.

JournalEntry_Line_JournalEntryLineDetail_TaxApplicableOn

String

False

false

false

This field indicates whether the tax applicable to the line item is sales or purchase tax. This field is valid for the UK and IN editions.

JournalEntry_Line_JournalEntryLineDetail_TaxAmount

Decimal

False

false

false

The tax applicable for this line item. This field is valid for the UK, AU, and IN editions.

JournalEntry_Line_JournalEntryLineDetail_BillableStatus

String

False

false

false

The billable status of the journal entry line. The line is to be billed to a customer if the account is an expense account and the Entity Reference specifies a Customer or a Job.

The allowed values are Billable, NotBillable, HasBeenBilled.

JournalEntry_Line_JournalEntryLineDetail_JournalCodeRef

String

False

false

false

The Id of the journal code to be referenced.

JournalEntry_Line_JournalEntryLineDetail_JournalCodeRef_Name

String

True

false

false

The name of the journal code to be referenced.

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