RecurringBillTransactions
Displays recurring bill templates that automate vendor billing, ensuring that repeat expenses are entered on a scheduled basis.
Table Specific Information
We can perform Select operation on RecurringBillTransactions table.
Select
Bill_Id, Bill_MetaData_CreateTime, Bill_MetaData_LastUpdatedTime can be used for server side filter. The driver processes other filters client-side within the driver.
SELECT * FROM RecurringBillTransactions; SELECT * FROM RecurringBillTransactions WHERE bill_id = 25544 SELECT * FROM RecurringBillTransactions WHERE bill_MetaData_CreateTime = '2020-12-28 23:07:26' SELECT * FROM RecurringBillTransactions WHERE bill_MetaData_LastUpdatedTime = '2020-12-30 14:47:54' SELECT * FROM RecurringBillTransactions WHERE bill_id = 25538 AND bill_MetaData_CreateTime = '2020-12-28 23:07:26' AND bill_MetaData_LastUpdatedTime = '2020-12-30 14:47:54'
Columns
| Name | Type | References | Description |
| Bill_Id [KEY] | String | The unique identifier (Id) that is assigned by QuickBooks Online to the recurring bill transaction. This Id is required to retrieve, update, or reference the recurring bill programmatically. | |
| Bill_SyncToken | String | The version control token for the recurring bill transaction that is used to prevent conflicting updates. QuickBooks Online increments this sync token each time the record is modified, and only the latest sync token can be used when making changes. | |
| Bill_MetaData_CreateTime | Datetime | The date and time stamp (in Coordinated Universal Time) when QuickBooks Online created the recurring bill transaction record. This timestamp provides an immutable audit trail of the creation event. | |
| Bill_MetaData_LastUpdatedTime | Datetime | The date and time stamp (in Coordinated Universal Time) when the recurring bill transaction was last updated. This timestamp is important for synchronization and detecting recent changes. | |
| Bill_CurrencyRef | String | The unique Id of the currency in which the recurring bill is recorded. This field is relevant only when multicurrency is enabled. | |
| Bill_CurrencyRef_Name | String | The display name of the currency in which the recurring bill is recorded. This field is relevant only when multicurrency is enabled. | |
| Bill_TotalAmt | Decimal | The total monetary amount of the recurring bill transaction. This amount includes all charges, allowances, taxes, and discounts. | |
| Bill_APAccountRef_Name | String | The display name of the accounts-payable liability account that is associated with this recurring bill transaction. | |
| Bill_APAccountRef | String | The unique Id of the accounts-payable liability account that is associated with this recurring bill transaction. When specified, the account must be a Liability account with a subtype of Payables. | |
| Bill_Sparse | Boolean | Indicates whether the recurring bill transaction is sparse. A sparse record contains only those fields that are changed, rather than the full set of fields, to reduce update payload size. | |
| Bill_VendorRef_Name | String | The display name of the vendor who issued this recurring bill. | |
| Bill_VendorRef | String | The unique Id of the vendor who issued this recurring bill. | |
| Bill_SalesTermRef_Name | String | The display name of the payment terms (for example, Net 30) that are associated with this recurring bill transaction. | |
| Bill_SalesTermRef | String | The unique Id of the payment terms that are associated with this recurring bill transaction. | |
| Bill_Balance | Decimal | The remaining balance amount on the recurring bill transaction after applying credits or payments. | |
| Bill_LineAggregate | String | An XML aggregate that is serialized into a single string representing all line items on the recurring bill transaction. Each line item typically includes elements such as Line/Id, Line/Description, Line/Amount, and detail substructures (for example, AccountBasedExpenseLineDetail or ItemBasedExpenseLineDetail) that define the specific account, class, customer, tax code, and billable status that are linked to the line. | |
| Bill_RecurringInfo_Name | String | The descriptive name of the recurring template or schedule that governs the creation of this recurring bill transaction. | |
| Bill_RecurDataRef | String | The unique Id of the recurrence data record that links this recurring bill transaction to its underlying schedule definition. | |
| Bill_RecurringInfo_RecurType | String | The recurrence pattern type that is associated with this recurring bill transaction, such as Scheduled, Unscheduled, or Reminder. | |
| Bill_RecurringInfo_Active | Boolean | Indicates whether the recurring bill schedule is currently active (true) or inactive (false). Inactive schedules do not generate new transactions. | |
| Bill_RecurringInfo_ScheduleInfo_IntervalType | String | The unit of time that defines the recurrence interval, such as Daily, Weekly, Monthly, or Yearly. | |
| Bill_RecurringInfo_ScheduleInfo_NumInterval | Integer | The numeric interval that specifies how often the recurring bill occurs, based on the interval type. For example, every 2 weeks. | |
| Bill_RecurringInfo_ScheduleInfo_DayOfWeek | String | The day of the week on which the recurring bill is scheduled to occur. For example, Monday or Friday. | |
| Bill_RecurringInfo_ScheduleInfo_DayOfMonth | String | The calendar day of the month on which the recurring bill is scheduled to occur. For example, 1, 15, or 30. | |
| Bill_RecurringInfo_ScheduleInfo_WeekOfMonth | String | The week of the month on which the recurring bill is scheduled to occur. For example, First, Second, or Last. | |
| Bill_RecurringInfo_ScheduleInfo_StartDate | Datetime | The date and timestamp when the recurring bill schedule becomes effective in QuickBooks Online. | |
| Bill_RecurringInfo_ScheduleInfo_NextDate | Datetime | The date and time stamp of the next scheduled occurrence of this recurring bill. | |
| Bill_RecurringInfo_ScheduleInfo_PreviousDate | Datetime | The date and time stamp of the most recent occurrence of this recurring bill under the recurrence schedule. | |
| Bill_RecurringInfo_ScheduleInfo_MaxOccurrences | String | The maximum number of recurring bill transactions that are generated under this schedule before it stops automatically. | |
| Bill_RecurringInfo_ScheduleInfo_RemindDays | String | The number of days in advance of the scheduled start date when QuickBooks Online should send a reminder for recurring bills of type Reminder. | |
| Bill_RecurringInfo_ScheduleInfo_MonthOfYear | String | The month of the year in which the recurring bill is scheduled to occur, if the recurrence is annual. For example, January or July. | |
| Bill_RecurringInfo_ScheduleInfo_DaysBefore | String | The number of days before the scheduled date that QuickBooks Online should create or notify about the recurring bill transaction. | |
| Bill_RecurringInfo_ScheduleInfo_EndDate | Datetime | The date and time stamp when the recurring bill schedule ends and no further transactions are generated. |