RecurringJournalEntryTransactionsLineItems
Captures the debit and credit line items for recurring journal entries, ensuring accurate and consistent automated accounting adjustments.
Table Specific Information
RecurringJournalEntryTransactions may be inserted or queried via the RecurringJournalEntryTransactions or RecurringJournalEntryTransactionsLineItems tables.
Select
SELECT * FROM RecurringJournalEntryTransactionsLineItems
Insert
To add a RecurringJournalEntryTransactionsLineItems following fields needs to be added:
- There must be at least one credit line and at least one debit line where the total of the debit and credit Lines are equal to each other.
- It must have a RecurringInfo.
INSERT INTO RecurringJournalEntryTransactionsLineItems (JournalEntry_Line_Id, JournalEntry_Line_Description, JournalEntry_Line_Amount, JournalEntry_Line_DetailType, JournalEntry_Line_JournalEntryLineDetail_PostingType, JournalEntry_Line_JournalEntryLineDetail_AccountRef, JournalEntry_RecurringInfo_Name, JournalEntry_RecurringInfo_RecurType, JournalEntry_RecurringInfo_Active, JournalEntry_RecurringInfo_ScheduleInfo_DayOfWeek, JournalEntry_RecurringInfo_ScheduleInfo_IntervalType, JournalEntry_RecurringInfo_ScheduleInfo_NumInterval, JournalEntry_RecurringInfo_ScheduleInfo_DayOfMonth, JournalEntry_RecurringInfo_ScheduleInfo_MaxOccurrences, JournalEntry_RecurringInfo_ScheduleInfo_StartDate, JournalEntry_RecurringInfo_ScheduleInfo_NextDate, JournalEntry_RecurringInfo_ScheduleInfo_PreviousDate) VALUES ('1', 'HELLOAPP1', 1001, 'JournalEntryLineDetail', 'Credit', '99', 'HELLOAPP3', 'Reminded', false, 'Monday', 'Weekly', 2, 'Tuesday', '100', '2021-01-23', '2021-01-23', '2021-01-23')
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| JournalEntry_Line_Id [KEY] | String | False | False | False |
The unique identifier (Id) of the recurring journal-entry line item that is included in the recurring journal entry transaction. | |
| JournalEntry_Id [KEY] | String | False |
RecurringJournalEntryTransactions.JournalEntry_Id | True | True |
The Id of the recurring journal-entry transaction to which this line item belongs. |
| JournalEntry_SyncToken | String | True | False | False |
The version number of the object that is used to lock the journal entry for use by one application at a time. As soon as an application modifies an object, its sync token is incremented. Attempts to modify an object specifying an older sync token fail. Only the latest version of the object is maintained by QuickBooks Online. | |
| JournalEntry_MetaData_CreateTime | Datetime | True | True | True |
Date and time when the recurring journal-entry line record was created in QuickBooks Online. | |
| JournalEntry_MetaData_LastUpdatedTime | Datetime | True | True | True |
Date and time when the recurring journal-entry line record was last updated in QuickBooks Online. | |
| JournalEntry_CurrencyRef | String | False | False | False |
The Id of the currency used for the amounts in this recurring journal-entry line item. | |
| JournalEntry_CurrencyRef_Name | String | True | False | False |
The name of the currency that is used for the amounts in this recurring journal-entry line item. | |
| JournalEntry_Line_Description | String | False | False | False |
Describes thejournal-entry line item as it appears on printed or exported records. | |
| JournalEntry_Line_Amount | Decimal | False | False | False |
Specifies the monetary amount of the recurring journal-entry line item. | |
| JournalEntry_Line_DetailType | String | False | False | False |
Indicates the detail type of the journal-entry line item, which determines how QuickBooks processes and classifies the line (for example, posting vs. non-posting, or other line types). | |
| JournalEntry_Line_JournalEntryLineDetail_PostingType | String | False | False | False |
Indicates the posting type (debit or credit) of the journal-entry line detail. The allowed values are Credit, Debit. | |
| JournalEntry_Line_JournalEntryLineDetail_Entity_Type | String | False | False | False |
Specifies the type of entity that is referenced by this journal-entry line (for example, Customer, Vendor, or Employee). | |
| JournalEntry_Line_JournalEntryLineDetail_Entity_EntityRef | String | False | False | False |
The Id of the entity that is referenced by this journal-entry line item. | |
| JournalEntry_Line_JournalEntryLineDetail_Entity_EntityRef_Name | String | True | False | False |
The name of the entity that is referenced by this journal-entry line item. | |
| JournalEntry_Line_JournalEntryLineDetail_AccountRef | String | False |
Accounts.Id | False | False |
The Id of the account that is associated with this journal-entry line item. |
| JournalEntry_Line_JournalEntryLineDetail_AccountRef_Name | String | True |
Accounts.Name | False | False |
The name of the account that is associated with this journal-entry line item. |
| JournalEntry_Line_JournalEntryLineDetail_ClassRef | String | False |
Class.Id | False | False |
The Id of the class that is assigned to this journal-entry line item for location or department tracking. |
| JournalEntry_Line_JournalEntryLineDetail_ClassRef_Name | String | True |
Class.FullyQualifiedName | False | False |
The name of the class that is assigned to this journal-entry line item for location or department tracking. |
| JournalEntry_Line_JournalEntryLineDetail_DepartmentRef | String | False |
Departments.Id | False | False |
The Id of the department that is associated with this journal-entry line item as defined in QuickBooks Online. |
| JournalEntry_Line_JournalEntryLineDetail_DepartmentRef_Name | String | True |
Departments.Name | False | False |
The name of the department that is associated with this journal-entry line item as defined in QuickBooks Online. |
| JournalEntry_Line_JournalEntryLineDetail_TaxCodeRef | String | False |
TaxCodes.Id | False | False |
The sales or purchase tax code that is associated with this journal-entry line item. This field is valid for non-U.S., non-Canadian companies such as the UK edition. |
| JournalEntry_Line_JournalEntryLineDetail_TaxApplicableOn | String | False | False | False |
Indicates whether the tax that is applicable to this line item is sales tax or purchase tax. This field is valid for the UK edition. | |
| JournalEntry_Line_JournalEntryLineDetail_TaxAmount | Decimal | False | False | False |
The tax amount that is applicable to this journal-entry line item. Valid for the UK and AU editions. | |
| JournalEntry_Line_JournalEntryLineDetail_BillableStatus | String | False | False | False |
Indicates the billable status of this journal-entry line item. The line can be billed to a customer if the account is an expense account and the Entity Reference specifies a customer or job. The allowed values are Billable, NotBillable, HasBeenBilled. | |
| JournalEntry_Line_JournalEntryLineDetail_JournalCodeRef | String | False | False | False |
The Id of the journal code that is referenced by thi sjournal-entry line item. | |
| JournalEntry_Line_JournalEntryLineDetail_JournalCodeRef_Name | String | True | False | False |
The name of the journal code that is referenced by this journal-entry line item. | |
| JournalEntry_RecurDataRef | String | True | False | False |
The unique Id of the recurrence data reference that identifies the recurring journal entry template or schedule. | |
| JournalEntry_RecurringInfo_Name | String | False | False | False |
The descriptive name of the recurring journal entry schedule or template. | |
| JournalEntry_RecurringInfo_RecurType | String | False | False | False |
The recurring type of the journal entry schedule, such as scheduled, reminder, or unscheduled. | |
| JournalEntry_RecurringInfo_Active | Boolean | False | False | False |
Indicates whether the recurring journal-entry schedule is active or inactive. | |
| JournalEntry_RecurringInfo_ScheduleInfo_DayOfWeek | String | False | False | False |
The day of the week on which the recurring journal entry is scheduled to occur when the interval type is weekly. | |
| JournalEntry_RecurringInfo_ScheduleInfo_IntervalType | String | False | False | False |
The interval type of the recurring journal entry schedule that defines how often the journal entry recurs (for example, weekly, monthly, or yearly). | |
| JournalEntry_RecurringInfo_ScheduleInfo_WeekOfMonth | String | False | False | False |
The week of the month on which the recurring journal entry is scheduled to occur when the interval type is monthly. | |
| JournalEntry_RecurringInfo_ScheduleInfo_NumInterval | Integer | False | False | False |
The number of intervals for the recurring journal entry schedule. This value determines how frequently the journal entry recurs based on the interval type. | |
| JournalEntry_RecurringInfo_ScheduleInfo_DayOfMonth | String | False | False | False |
The day of the month on which the recurring journal entry is scheduled to occur. | |
| JournalEntry_RecurringInfo_ScheduleInfo_MaxOccurrences | String | False | False | False |
The maximum number of occurrences allowed for the recurring journal-entry schedule. | |
| JournalEntry_RecurringInfo_ScheduleInfo_StartDate | Datetime | False | False | False |
The start date of the recurring journal-entry schedule that is associated with the recurrence template. | |
| JournalEntry_RecurringInfo_ScheduleInfo_NextDate | Datetime | False | False | False |
The next scheduled date for the recurring journal entry to occur. | |
| JournalEntry_RecurringInfo_ScheduleInfo_PreviousDate | Datetime | False | False | False |
The previous scheduled date on which the recurring journal entry occurred. | |
| JournalEntry_TxnTaxDetail_TxnTaxCodeRef | String | False |
TaxCodes.Id | False | False |
The unique Id of the tax code that is applied to the recurring journal-entry transaction. |
| JournalEntry_TxnTaxDetail_TotalTax | String | False | False | False |
The total tax amount that is calculated for the recurring journal-entry transaction, excluding any tax lines manually inserted into the transaction line list. | |
| JournalEntry_TxnTaxDetail_TaxLineAggregate | String | False | False | False |
An XML aggregate containing all tax line items that are associated with the recurring journal entry transaction. This collection details each individual tax charge or credit so that QuickBooks can calculate and report taxes accurately for that transaction. | |
| JournalEntry_TotalAmt | Decimal | True | False | False |
The total monetary amount of the recurring journal-entry transaction. | |
| JournalEntry_Adjustment | Boolean | True | False | False |
Indicates whether the recurring journal-entry transaction is an adjustment. | |
| JournalEntry_ExchangeRate | Decimal | False | False | False |
The currency exchange rate. This field is valid only when the company file is set up to use 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, and CA editions. |