RecurringVendorCreditTransactionsLineItems
Contains line-level details of recurring vendor credits, specifying items, amounts, and accounts for automated vendor-credit processing.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| VendorCredit_LineId [KEY] | String | True | False | True |
The unique identifier (Id) of the line item within the vendor credit that is used to reference, update, or reconcile this specific line. | |
| VendorCredit_VendorCreditId [KEY] | String | False | True | False |
The unique Id of the parent vendor credit that this line item is linked to. This Id forms the foreign-key relationship back to the vendor-credit Id (VendorCredit_Id). | |
| VendorCredit_SyncToken | String | True | False | False |
The version control token for the parent vendor credit that is used to prevent conflicting updates. QuickBooks Online increments this token each time the vendor credit or any of its lines is modified, and only the latest token is accepted for edits. | |
| VendorCredit_MetaData_CreateTime | Datetime | True | True | True |
The date and time stamp (Coordinated Universal Time) when QuickBooks Online created the parent vendor-credit record that this line belongs to. | |
| VendorCredit_MetaData_LastUpdatedTime | Datetime | True | True | True |
The date and time stamp (Coordinated Universal Time) when the parent vendor-credit record that this line belongs to was last updated in QuickBooks Online. | |
| VendorCredit_DocNumber | String | False | True | True |
The reference number that is assigned to the parent vendor credit. If no number is provided, QuickBooks Online assigns the next number in sequence according to the company's numbering preferences. | |
| VendorCredit_TxnDate | Date | False | True | True |
The posting date of the parent vendor credit that determines the accounting period. This date can be set to a prior date to adjust prior-period financial statements when appropriate. | |
| VendorCredit_PrivateNote | String | False | False | False |
An internal note on the parent vendor credit that is intended for internal use and is not printed on vendor-facing forms by default. | |
| VendorCredit_DepartmentRef | String | False |
Departments.Id | False | False |
The unique Id of the department or location that is linked to the parent vendor credit when location tracking is enabled. Use this Id to classify line-level activity under the correct organizational segment. |
| VendorCredit_DepartmentRef_Name | String | True |
Departments.Name | False | False |
The display name of the department or location that is linked to the parent vendor credit when location tracking is enabled. |
| VendorCredit_Line_Id | String | False | False | False |
The unique Id that is assigned by QuickBooks Online to the line (corresponds to Line/Id in the API) and that is stable for addressing the specific line item during updates. | |
| VendorCredit_Line_Description | String | False | False | False |
The free-form description of the line item that is displayed on forms and reports and that is used to clarify the purpose of the credit for this line. | |
| VendorCredit_Line_Amount | Decimal | False | False | False |
The monetary amount for this line that is included in the vendor-credit total. This includes charges and allowances that apply to the line and excludes any tax amount that is calculated separately. | |
| VendorCredit_Line_DetailType | String | False | False | False |
The structural type of detail that is used by this line. For vendor credits, this type is typically either AccountBasedExpenseLineDetail or ItemBasedExpenseLineDetail, which determines the sub-elements that are required and how the amount is derived. | |
| VendorCredit_Line_AccountBasedExpenseLineDetail_CustomerRef | String | False |
Customers.Id | False | False |
The unique Id of the customer or project that is associated with this expense line when tracking by customer is enabled. |
| VendorCredit_Line_AccountBasedExpenseLineDetail_CustomerRef_Name | String | True |
Customers.DisplayName | False | False |
The display name of the customer or project that is associated with this expense line. |
| VendorCredit_Line_AccountBasedExpenseLineDetail_ClassRef | String | False |
Class.Id | False | False |
The unique Id of the class that is assigned to this expense line for class tracking and reporting. |
| VendorCredit_Line_AccountBasedExpenseLineDetail_ClassRef_Name | String | True |
Class.FullyQualifiedName | False | False |
The display name of the class that is assigned to this expense line. |
| VendorCredit_Line_AccountBasedExpenseLineDetail_AccountRef | String | False |
Accounts.Id | False | False |
The unique Id of the expense account that is associated with this line. The account must be valid and active in the chart of accounts. |
| VendorCredit_Line_AccountBasedExpenseLineDetail_AccountRef_Name | String | True |
Accounts.Name | False | False |
The display name of the expense account that is associated with this line. |
| VendorCredit_Line_AccountBasedExpenseLineDetail_BillableStatus | String | False | False | False |
The billing status that is used to indicate whether this expense line is billable to a customer (for example, Billable, NotBillable, HasBeenBilled). | |
| VendorCredit_Line_AccountBasedExpenseLineDetail_TaxCodeRef | String | False |
TaxCodes.Id | False | False |
The unique Id of the tax code that is applied to this expense line when tax tracking is enabled. |
| VendorCredit_Line_ItemBasedExpenseLineDetail_ItemRef | String | False |
Items.Id | False | False |
The unique Id of the item that is associated with this expense line. Choosing an item determines default accounts and can drive rate and tax behavior. |
| VendorCredit_Line_ItemBasedExpenseLineDetail_ItemRef_Name | String | True |
Items.Name | False | False |
The display name of the item that is associated with this expense line. |
| VendorCredit_Line_ItemBasedExpenseLineDetail_ClassRef | String | False |
Class.Id | False | False |
The unique Id of the class that is assigned to this item-based expense line for class tracking and reporting. |
| VendorCredit_Line_ItemBasedExpenseLineDetail_ClassRef_Name | String | True |
Class.FullyQualifiedName | False | False |
The display name of the class that is assigned to this item-based expense line. |
| VendorCredit_Line_ItemBasedExpenseLineDetail_UnitPrice | Decimal | False | False | False |
The unit price that is used to calculate the line amount when combined with quantity; this can be overridden per line. | |
| VendorCredit_Line_ItemBasedExpenseLineDetail_Qty | Double | False | False | False |
The quantity that, when multiplied by unit price, is used to derive the line amount for this item-based expense line. | |
| VendorCredit_Line_ItemBasedExpenseLineDetail_TaxCodeRef | String | False |
TaxCodes.Id | False | False |
The unique Id of the tax code that is applied to this item-based expense line when tax tracking is enabled. |
| VendorCredit_Line_ItemBasedExpenseLineDetail_CustomerRef | String | False |
Customers.Id | False | False |
The unique Id of the customer or project that is associated with this item-based expense line when tracking by customer is enabled. |
| VendorCredit_Line_ItemBasedExpenseLineDetail_CustomerRef_Name | String | True |
Customers.DisplayName | False | False |
The display name of the customer or project that is associated with this item-based expense line. |
| VendorCredit_Line_ItemBasedExpenseLineDetail_BillableStatus | String | False | False | False |
The billing status that is used to indicate whether this item-based expense line is billable to a customer (for example, Billable, NotBillable, HasBeenBilled). | |
| VendorCredit_VendorRef | String | False |
Vendors.Id | True | False |
The unique Id of the vendor that is linked to this transaction. This Id connects the line to the vendor's record for reporting and reconciliation. |
| VendorCredit_VendorRef_Name | String | True |
Vendors.DisplayName | False | False |
The display name of the vendor that is linked to this transaction. |
| VendorCredit_APAccountRef | String | False |
Accounts.Id | True | True |
The unique Id of the accounts-payable liability account that is credited by this vendor credit. If the company uses only one accounts-payable account, QuickBooks Online implies this account automatically. When specified, the account must be a Liability account that is of subtype Payables. |
| VendorCredit_APAccountRef_Name | String | True |
Accounts.Name | False | False |
The display name of the accounts-payable liability account that is credited by this vendor credit. If the company uses only one accounts-payable account, QuickBooks Online implies this account automatically. When specified, the account must be a Liability account that is of subtype Payables. |
| VendorCredit_TotalAmt | Decimal | False | True | True |
The total amount of the vendor credit that is determined by summing all line item amounts. This amount includes charges, allowances, taxes, and discounts applied within the transaction. | |
| VendorCredit_CurrencyRef | String | False | False | False |
The unique Id of the currency that is used in this vendor-credit transaction when multicurrency is enabled. | |
| VendorCredit_CurrencyRef_Name | String | True | False | False |
The display name of the currency that is used in this vendor-credit transaction when multicurrency is enabled. | |
| VendorCredit_ExchangeRate | Decimal | False | False | False |
The currency exchange rate that QuickBooks Online applies to convert this vendor-credit amount to the home currency. This field is valid only when multicurrency is enabled. In QuickBooks Online, exchange rates are always recorded as the number of home currency units it takes to equal one foreign currency unit. This field is available for the UK, AU, and CA editions. | |
| VendorCredit_GlobalTaxCalculation | String | False | False | False |
The method by which QuickBooks Online applies sales tax to this vendor-credit transaction. This field is valid in the UK, AU, and CA editions. 使用できる値は次のとおりです。TaxExcluded, TaxInclusive, NotApplicable | |
| VendorCredit_RecurDataRef | String | False | False | False |
The reference Id for the recurrence data record that is used by QuickBooks Online to control how this vendor credit repeats automatically. | |
| VendorCredit_RecurDataRef_Name | String | True | False | False |
The descriptive name of the recurrence data record that governs how this vendor credit repeats automatically. | |
| VendorCredit_RecurringInfo_Name | String | False | False | False |
The name that is assigned to the recurring template or schedule that generates this vendor-credit transaction. | |
| VendorCredit_RecurringInfo_RecurType | String | False | False | False |
The recurrence pattern type (such as Scheduled, Unscheduled, or Reminder) that is associated with this vendor-credit transaction template. 使用できる値は次のとおりです。Automated, Reminded, UnScheduled | |
| VendorCredit_RecurringInfo_Active | Boolean | False | False | False |
Indicates whether the recurring vendor-credit schedule is currently active (true) or inactive (false). Inactive schedules do not generate new transactions. | |
| VendorCredit_RecurringInfo_ScheduleInfo_IntervalType | String | False | False | False |
Specifies the unit of time for the recurrence interval such as Daily, Weekly, Monthly, or Yearly for this vendor-credit schedule. 使用できる値は次のとおりです。Yearly, Monthly, Weekly, Daily | |
| VendorCredit_RecurringInfo_ScheduleInfo_NumInterval | Integer | False | False | False |
The numeric interval count (for example, every 2 weeks) that determines how often the vendor credit recurs according to the specified interval type. | |
| VendorCredit_RecurringInfo_ScheduleInfo_DayOfWeek | String | False | False | False |
The day of the week (for example, Monday, Tuesday) on which the recurring vendor credit is scheduled to occur. | |
| VendorCredit_RecurringInfo_ScheduleInfo_WeekOfMonth | String | False | False | False |
The week of the month (for example, First, Second, Last) on which the recurring vendor credit is scheduled to occur. | |
| VendorCredit_RecurringInfo_ScheduleInfo_MaxOccurrences | String | False | False | False |
The maximum number of vendor-credit transactions to generate under this recurrence schedule before it stops automatically. | |
| VendorCredit_RecurringInfo_ScheduleInfo_RemindDays | String | False | False | False |
The number of days prior to the scheduled start date when QuickBooks Online should send a reminder for a recurring vendor credit of type Reminder. | |
| VendorCredit_RecurringInfo_ScheduleInfo_MonthOfYear | String | False | False | False |
The month of the year (for example, January, February) when the recurring vendor credit is scheduled if using an annual recurrence. | |
| VendorCredit_RecurringInfo_ScheduleInfo_DaysBefore | String | False | False | False |
The number of days in advance of the scheduled date to create or notify about the vendor-credit transaction. | |
| VendorCredit_RecurringInfo_ScheduleInfo_DayOfMonth | String | False | False | False |
The calendar day of the month (for example, 1, 15, 30) when the recurring vendor credit is scheduled to occur. | |
| VendorCredit_RecurringInfo_ScheduleInfo_StartDate | Datetime | False | False | False |
The start date and time stamp when the recurring vendor credit schedule becomes effective in QuickBooks Online. | |
| VendorCredit_RecurringInfo_ScheduleInfo_NextDate | Datetime | False | False | False |
The next scheduled date and time stamp on which QuickBooks Online will create or prompt for this vendor-credit transaction. | |
| VendorCredit_RecurringInfo_ScheduleInfo_EndDate | Datetime | False | False | False |
The end date and time stamp on which the recurring vendor-credit schedule ceases to create new transactions automatically. | |
| VendorCredit_RecurringInfo_ScheduleInfo_PreviousDate | Datetime | False | False | False |
The most recent date and time stamp when QuickBooks Online generated or prompted for this vendor-credit transaction under the recurrence schedule. |