RecurringJournalEntryTransactions
Holds recurring journal entry templates, enabling automated posting of routine accounting adjustments like depreciation or accruals.
Table Specific Information
We can perform Select and Insert operations on RecurringJournalEntryTransactions table.
Select
JournalEntry_Id, JournalEntry_MetaData_CreateTime, JournalEntry_MetaData_LastUpdatedTime can be used for server side filter. The driver processes other filters client-side within the driver.
SELECT * FROM RecurringJournalEntryTransactions; SELECT * FROM RecurringJournalEntryTransactions WHERE JournalEntry_id = 25536; SELECT * FROM RecurringJournalEntryTransactions WHERE JournalEntry_MetaData_CreateTime = '2020-12-10 09:53:56'; SELECT * FROM RecurringJournalEntryTransactions WHERE JournalEntry_MetaData_LastUpdatedTime = '2020-12-10 09:53:56'; SELECT * FROM RecurringJournalEntryTransactions WHERE JournalEntry_id = 25536 AND JournalEntry_MetaData_CreateTime = '2020-12-10 09:53:56' AND JournalEntry_MetaData_LastUpdatedTime = '2020-12-10 09:53:56';
Insert
To add a RecurringJournalEntryTransactions 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. Each _ denotes hierarchy. Use <Line> at the base level. All values for each field in the aggregate should adhere to the API's specifications (e.g. for dates in format yyyy-MM-dd, for date times in format yyyy-MM-dd'T'HH:mm:sszzz). The columns that may be used in the aggregates begin with the prefix 'Line_' to indicate they are part of the line item. Use the Line_ column along with the DocNumber to indicate which lines go with which RecurringJournalEntryTransactions. For example:
- A RecurringJournalEntryTransactions object must have a RecurringInfo.
INSERT INTO RecurringJournalEntryTransactions (JournalEntry_LineAggregate, 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 ('<Line><Amount>0.02</Amount><DetailType>JournalEntryLineDetail</DetailType><JournalEntryLineDetail><PostingType>Debit</PostingType><Entity><Type>Customer</Type><EntityRef>24</EntityRef></Entity><AccountRef>33</AccountRef></JournalEntryLineDetail></Line> <Line><Amount>0.02</Amount><DetailType>JournalEntryLineDetail</DetailType><JournalEntryLineDetail><PostingType>Credit</PostingType><AccountRef>14</AccountRef></JournalEntryLineDetail></Line>', 'APPTEST1', 'Reminded', false, 'Monday', 'Weekly', 2, 'Tuesday', '100', '2021-12-01', '2021-12-01', '2021-12-01')
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| JournalEntry_Id [KEY] | String | True | True | True |
The unique identifier (Id) of the recurring journal-entry transaction. | |
| 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 |
The date and time when the recurring journal-entry transaction record was created. | |
| JournalEntry_MetaData_LastUpdatedTime | Datetime | True | True | True |
The date and time when the recurring journal-entry transaction record was last updated. | |
| JournalEntry_CurrencyRef | String | True | False | False |
The unique Id of the currency used for all monetary amounts in the recurring journal-entry transaction. | |
| JournalEntry_CurrencyRef_Name | String | True | False | False |
The name of the currency used for all monetary amounts in the recurring journal-entry transaction. | |
| JournalEntry_LineAggregate | String | False | False | False |
An XML aggregate containing all line items that are included in the recurring journal-entry transaction, such as debit and credit account references, amounts, and any associated classes or tax details. | |
| 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 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 of all tax line items that are associated with the recurring journal-entry transaction. | |
| JournalEntry_TotalAmt | Decimal | True | False | False |
The total monetary amount of the recurring journal-entry transaction, including all applicable charges, allowances, and taxes. | |
| JournalEntry_Adjustment | Boolean | True | False | False |
Indicates whether the recurring journal-entry transaction is marked as an adjustment. | |
| JournalEntry_ExchangeRate | Decimal | False | False | False |
The currency exchange rate for the recurring journal-entry transaction. This field is valid only when 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, and CA editions. |