RecurringRefundReceiptTransactionsLineItems

Contains the line-level details of recurring refund receipts, including refunded products, services, amounts, and taxes for consistent automated processing.

Columns


Name	Type	ReadOnly	References	Filterable	Sortable	Description
RefundReceipt_LineId [KEY]	String	True		True	False	The identifier (Id) of the line item that is part of the recurring refund-receipt transaction. This Id uniquely identifies the individual line item within the recurring refund-receipt template.
RefundReceipt_RefundReceiptId [KEY]	String	False	RefundReceipts.Id	True	True	The Id of the recurring refund-receipt transaction to which this line item belongs.
RefundReceipt_SyncToken	String	True		False	False	The version number of the object that is used to lock the recurring refund-receipt record 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.
RefundReceipt_MetaData_CreateTime	Datetime	True		True	True	The date and time when the recurring refund-receipt line record was created in QuickBooks Online.
RefundReceipt_MetaData_LastUpdatedTime	Datetime	True		True	True	The date and time when the recurring refund-receipt line record was last updated in QuickBooks Online.
RefundReceipt_CustomFieldAggregate	String	False		False	False	An XML aggregate that contains all custom field information that is associated with the recurring refund-receipt transaction line item.
RefundReceipt_DocNumber	String	False		True	True	The reference number that is assigned to the recurring refund-receipt transaction for tracking and reconciliation purposes.
RefundReceipt_TxnDate	Date	False		True	True	The date that is entered by the user when the recurring refund-receipt transaction occurred. This represents the transaction date that is used for accounting and reporting.
RefundReceipt_PrivateNote	String	False		False	False	A private note that does not appear on the recurring refund-receipt transaction records. This field can be used for internal comments or special instructions.
RefundReceipt_Line_Id	String	False		False	False	The Id of the specific line item within the recurring refund-receipt transaction.
RefundReceipt_Line_LineNum	String	False		False	False	The sequential line number that is assigned to the line item within the recurring refund-receipt transaction.
RefundReceipt_Line_Description	String	False		False	False	The description of the line item that is displayed in the printed or on-screen record of the recurring refund-receipt transaction.
RefundReceipt_Line_Amount	Decimal	False		False	False	The total monetary amount of charges or credits for the given line item within the recurring refund-receipt transaction. This amount includes charges and allowances but excludes tax amounts.
RefundReceipt_Line_DetailType	String	False		False	False	The detail type of the line item in the recurring refund-receipt transaction. Different detail types indicate different types of line items, such as service lines or sales items.
RefundReceipt_Line_SalesItemLineDetail_ItemRef	String	False	Items.Id	False	False	The Id of the item that is referenced by this line item. When a line item lacks an item reference, it is treated as documentation and the Line_Amount attribute is ignored.
RefundReceipt_Line_SalesItemLineDetail_ItemRef_Name	String	True	Items.Name	False	False	The name of the item that is referenced by this line item. When a line item lacks an item reference, it is treated as documentation and the Line_Amount field is ignored.
RefundReceipt_Line_SalesItemLineDetail_ClassRef	String	False	Class.Id	False	False	The Id of the class that is assigned to this sales-item line for classification purposes.
RefundReceipt_Line_SalesItemLineDetail_ClassRef_Name	String	True	Class.FullyQualifiedName	False	False	The name of the class that is assigned to this sales-item line for classification purposes.
RefundReceipt_Line_SalesItemLineDetail_UnitPrice	Decimal	False		False	False	The unit price of the item that is referenced by ItemRef in this sales-item line.
RefundReceipt_Line_SalesItemLineDetail_Qty	Double	False		False	False	The quantity of items that are recorded in this sales-item line of the recurring refund-receipt transaction.
RefundReceipt_Line_SalesItemLineDetail_TaxCodeRef	String	False	TaxCodes.Id	False	False	The tax code that is applied to the item in this sales-item line.
RefundReceipt_Line_SalesItemLineDetail_ServiceDate	Date	False		False	False	The date of the service that is associated with this sales-item line.
RefundReceipt_TxnTaxDetail_TxnTaxCodeRef	String	False	TaxCodes.Id	False	False	The unique tax code that is assigned to the recurring refund-receipt transaction, which determines how taxes are calculated and reported.
RefundReceipt_TxnTaxDetail_TotalTax	String	False		False	False	The total tax amount that is calculated for the recurring refund-receipt transaction, excluding any tax lines that are manually inserted into the transaction line list.
RefundReceipt_TxnTaxDetail_TaxLineAggregate	String	False		False	False	An XML aggregate that contains a structured list of all individual tax line items that are applied to the recurring refund-receipt transaction. This collection makes it possible to audit or report on how taxes were derived for every occurrence in the schedule.
RefundReceipt_RecurDataRef	String	False		False	False	The Id of the recurrence data reference that links the recurring refund-receipt transaction to the underlying template or schedule that controls its automated creation.
RefundReceipt_RecurDataRef_Name	String	True		False	False	The name of the recurrence data reference that identifies the recurring refund-receipt template or schedule.
RefundReceipt_RecurringInfo_Name	String	False		False	False	The descriptive name of the recurring refund-receipt schedule or template. This name is the label that users assign to recognize and manage the recurring refund-receipt pattern, such as 'Monthly Refunds' or 'Quarterly Credits'.
RefundReceipt_RecurringInfo_RecurType	String	False		False	False	The recurring type of the refund receipt schedule, such as scheduled, reminder, or unscheduled. This indicates how the recurring refund-receipt transaction is created or triggered. The allowed values are Automated, Reminded, UnScheduled.
RefundReceipt_RecurringInfo_Active	Boolean	False		False	False	Indicates whether the recurring refund-receipt schedule is currently active or inactive. An active schedule automatically generates refund-receipt transactions according to its defined settings.
RefundReceipt_RecurringInfo_ScheduleInfo_IntervalType	String	False		False	False	Defines how often the recurring refund-receipt transaction occurs (for example, weekly, monthly, or yearly). This interval type determines the frequency of the automated transaction. The allowed values are Yearly, Monthly, Weekly, Daily.
RefundReceipt_RecurringInfo_ScheduleInfo_NumInterval	Integer	False		False	False	Specifies the number of intervals for the recurring refund-receipt schedule. This value determines how frequently the transaction recurs based on the interval type.
RefundReceipt_RecurringInfo_ScheduleInfo_DayOfWeek	String	False		False	False	The day of the week on which the recurring refund-receipt transaction is scheduled to occur when the interval type is weekly.
RefundReceipt_RecurringInfo_ScheduleInfo_WeekOfMonth	String	False		False	False	The week of the month on which the recurring refund-receipt transaction is scheduled to occur when the interval type is monthly.
RefundReceipt_RecurringInfo_ScheduleInfo_MaxOccurrences	String	False		False	False	The maximum number of occurrences that is allowed for the recurring refund-receipt schedule before it ends.
RefundReceipt_RecurringInfo_ScheduleInfo_RemindDays	String	False		False	False	The number of days before the start date on which a reminder for the recurring refund receipt should be sent.
RefundReceipt_RecurringInfo_ScheduleInfo_MonthOfYear	String	False		False	False	The month of the year on which the recurring refund-receipt transaction is scheduled to occur when the interval type is yearly.
RefundReceipt_RecurringInfo_ScheduleInfo_DaysBefore	String	False		False	False	The number of days before the scheduled date on which the recurring refund receipt is processed or triggered.
RefundReceipt_RecurringInfo_ScheduleInfo_DayOfMonth	String	False		False	False	The day of the month on which the recurring refund-receipt transaction is scheduled to occur.
RefundReceipt_RecurringInfo_ScheduleInfo_StartDate	Datetime	False		False	False	The start date of the recurring refund-receipt schedule that is associated with the recurrence template.
RefundReceipt_RecurringInfo_ScheduleInfo_NextDate	Datetime	False		False	False	The next scheduled date for the recurring refund-receipt transaction to occur.
RefundReceipt_RecurringInfo_ScheduleInfo_EndDate	Datetime	False		False	False	The end date of the recurring refund-receipt schedule when no further occurrences are generated.
RefundReceipt_RecurringInfo_ScheduleInfo_PreviousDate	Datetime	False		False	False	The previous scheduled date on which the recurring refund-receipt transaction occurred.
RefundReceipt_CustomerRef	String	False	Customers.Id	True	False	The Id of the customer that is linked to this recurring refund-receipt transaction.
RefundReceipt_CustomerRef_Name	String	True	Customers.DisplayName	False	False	The name of the customer that is linked to this recurring refund-receipt transaction.
RefundReceipt_CustomerMemo	String	False		False	False	The message to the customer that appears in the invoice and in the printed invoice for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_Id	String	False		False	False	The Id of the entity for the billing address that is mainly used for modifying the address. This field is assigned by the data service.
RefundReceipt_BillAddr_Line1	String	False		False	False	The first line of the billing address that is used for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_Line2	String	False		False	False	The second line of the billing address that is used for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_Line3	String	False		False	False	The third line of the billing address that is used for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_Line4	String	False		False	False	The fourth line of the billing address that is used for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_Line5	String	False		False	False	The fifth line of the billing address that is used for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_City	String	False		False	False	The city name that is used in the billing address for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_Country	String	False		False	False	The country name that is used in the billing address for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_CountrySubDivisionCode	String	False		False	False	The region within a country that is used in the billing address. For example, the state name for the USA or the province name for Canada.
RefundReceipt_BillAddr_PostalCode	String	False		False	False	The postal code that is used in the billing address. For example, the ZIP code for the USA and the postal code for Canada.
RefundReceipt_BillAddr_Note	String	False		False	False	A note for the customer that is associated with the billing address of the recurring refund-receipt transaction.
RefundReceipt_BillAddr_Lat	String	False		False	False	The latitude coordinate of the geocoded billing address that is used for the recurring refund-receipt transaction.
RefundReceipt_BillAddr_Long	String	False		False	False	The longitude coordinate of the geocoded billing address that is used for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_Id	String	False		False	False	The Id of the entity for the shipping address that is used mainly for modifying the address. This field is assigned by the data service.
RefundReceipt_ShipAddr_Line1	String	False		False	False	The first line of the shipping address that is used for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_Line2	String	False		False	False	The second line of the shipping address that is used for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_Line3	String	False		False	False	The third line of the shipping address that is used for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_Line4	String	False		False	False	The fourth line of the shipping address that is used for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_Line5	String	False		False	False	The fifth line of the shipping address that is used for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_City	String	False		False	False	The city name that is used in the shipping address for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_Country	String	False		False	False	The country name that is used in the shipping address for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_CountrySubDivisionCode	String	False		False	False	The region within a country that is used in the shipping address. For example, the state name for the USA or the province name for Canada.
RefundReceipt_ShipAddr_PostalCode	String	False		False	False	The postal code that is used in the shipping address. For example, the ZIP code for the USA and the postal code for Canada.
RefundReceipt_ShipAddr_Note	String	False		False	False	A note for the customer that is associated with the shipping address of the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_Lat	String	False		False	False	The latitude coordinate of the geocoded shipping address that is used for the recurring refund-receipt transaction.
RefundReceipt_ShipAddr_Long	String	False		False	False	The longitude coordinate of the geocoded shipping address that is used for the recurring refund-receipt transaction.
RefundReceipt_ClassRef	String	False	Class.Id	False	False	The Id of the class that is associated with this recurring refund-receipt transaction for classification or reporting purposes.
RefundReceipt_ClassRef_Name	String	True	Class.FullyQualifiedName	False	False	The name of the class that is associated with this recurring refund-receipt transaction for classification or reporting purposes.
RefundReceipt_CheckPayment_CheckNum	String	True		False	False	The check number that is printed on the check used for the refund-receipt transaction.
RefundReceipt_CheckPayment_Status	String	False		False	False	Indicates the status of the check that is recorded for the refund-receipt transaction. Values are provided by the service or business logic, such as Pending, Cleared, or Voided.
RefundReceipt_CheckPayment_NameOnAccount	String	False		False	False	The name of the person or entity that is holding the account, as printed on the check used for the refund-receipt transaction.
RefundReceipt_CheckPayment_AcctNum	String	False		False	False	The checking account number, as printed on the check used for the refund-receipt transaction.
RefundReceipt_CheckPayment_BankName	String	True		False	False	The name of the bank on which the check used for the refund-receipt transaction was drawn.
RefundReceipt_CreditCardPayment_CreditChargeInfo_Type	String	False		False	False	The type of credit card that is used to process the refund-receipt transaction.
RefundReceipt_CreditCardPayment_CreditChargeInfo_NameOnAcct	String	False		False	False	The name of the account holder, as printed on the card that is used to process the refund-receipt transaction.
RefundReceipt_CreditCardPayment_CreditChargeInfo_CcExpiryMonth	Integer	False		False	False	The expiration month of the credit card that is used to process the refund-receipt transaction.
RefundReceipt_CreditCardPayment_CreditChargeInfo_CcExpiryYear	Integer	False		False	False	The four-digit expiration year of the credit card that is used to process the refund-receipt transaction.
RefundReceipt_CreditCardPayment_CreditChargeInfo_BillAddrStreet	String	False		False	False	The street of the billing address of the credit-card holder that is used to process the refund-receipt transaction.
RefundReceipt_CreditCardPayment_CreditChargeInfo_PostalCode	String	False		False	False	The postal code of the billing address of the credit card holder that is used to process the refund-receipt transaction.
RefundReceipt_CreditCardPayment_CreditChargeInfo_Amount	Decimal	False		False	False	The monetary amount that is processed by using the credit card for the refund-receipt transaction.
RefundReceipt_CreditCardPayment_CreditChargeInfo_ProcessPayment	Boolean	False		False	False	Indicates whether to store credit-card information only (false or no value) or to store credit-card payment transaction information in the CreditChargeResponse section (true).
RefundReceipt_CreditCardPayment_CreditChargeResponse_CCTransId	String	False		False	False	The unique Id of the credit-card payment transaction that is processed for the refund receipt.
RefundReceipt_CreditCardPayment_CreditChargeResponse_AuthCode	String	False		False	False	The authorization code that is returned from the credit-card processor to indicate that the charge will be paid by the card issuer for the refund-receipt transaction.
RefundReceipt_CreditCardPayment_CreditChargeResponse_TxnAuthorizationTime	Datetime	False		False	False	The timestamp indicating the time at which the card processor authorized the transaction for the refund receipt.
RefundReceipt_CreditCardPayment_CreditChargeResponse_Status	String	False		False	False	Indicates the status of the credit card payment transaction for the refund receipt. Possible values include Completed and Unknown.
RefundReceipt_SalesTermRef	String	False	Terms.Id	False	False	The Id of the sales term that is associated with the refund-receipt transaction.
RefundReceipt_SalesTermRef_Name	String	True	Terms.Name	False	False	The name of the sales term that is associated with the refund-receipt transaction.
RefundReceipt_DueDate	Date	False		True	False	The date on which the refund receipt invoice is to be paid, not including any early payment discount incentives or late payment penalties. If the date is not supplied, the current date on the server is used.
RefundReceipt_ShipMethodRef	String	False		False	False	The Id of the shipping method that is associated with the refund-receipt transaction.
RefundReceipt_ShipMethodRef_Name	String	True		False	False	The name of the shipping method that is associated with the refund-receipt transaction.
RefundReceipt_ShipDate	Date	False		False	False	The date scheduled for delivery of goods or services that is associated with the refund-receipt transaction.
RefundReceipt_TotalAmt	Decimal	True		True	True	The total amount of the refund-receipt transaction. This amount includes the total of all charges, allowances, and taxes.
RefundReceipt_ApplyTaxAfterDiscount	Boolean	False		False	False	Sets whether any discounts are applied before the tax is calculated for the refund-receipt transaction.
RefundReceipt_DepartmentRef	String	False	Departments.Id	False	False	The Id of the department that is storing the location of the refund-receipt transaction, as defined using location tracking in QuickBooks Online.
RefundReceipt_DepartmentRef_Name	String	True	Departments.Name	False	False	The name of the department that is storing the location of the refund-receipt transaction, as defined using location tracking in QuickBooks Online.
RefundReceipt_PrintStatus	String	False		False	False	The print status of the refund receipt invoice. The allowed values are NotSet, NeedToPrint, PrintComplete.
RefundReceipt_BillEmail_Address	String	False		False	False	The email address to which the refund receipt invoice is sent. If the value of theEmailStatus attribute is NeedToSend, the billing email address is required.
RefundReceipt_Balance	Decimal	False		False	False	Indicates whether the refund-receipt transaction is a finance charge.
RefundReceipt_PaymentMethodRef	String	False	PaymentMethods.Id	False	False	The Id of the payment method that is associated with the refund-receipt transaction.
RefundReceipt_PaymentMethodRef_Name	String	True	PaymentMethods.Name	False	False	The name of the payment method that is associated with the refund-receipt transaction.
RefundReceipt_PaymentRefNum	String	False		False	False	The reference number for the payment received that is linked to the refund-receipt transaction.
RefundReceipt_PaymentType	String	False		False	False	The type of payment that is used for the refund-receipt transaction, such as cash, check, or credit card. The allowed values are Cash, Check, CreditCard, Other.
RefundReceipt_DepositToAccountRef	String	False	Accounts.Id	False	False	The Id of the asset account where the payment money for the refund-receipt transaction is deposited. If you do not specify this account, QuickBooks Online uses the Undeposited Funds account.
RefundReceipt_DepositToAccountRef_Name	String	True	Accounts.Name	False	False	The name of the asset account where the payment money for the refund-receipt transaction is deposited. If you do not specify this account, QuickBooks Online uses the Undeposited Funds account.
RefundReceipt_CurrencyRef	String	False		False	False	The Id of the currency that is used in the refund-receipt transaction. This field is valid in the UK, AU, and CA editions.
RefundReceipt_CurrencyRef_Name	String	False		False	False	The name of the currency in which all amounts on the refund-receipt transaction are expressed. This field is valid in the UK, AU, and CA editions.
RefundReceipt_ExchangeRate	Decimal	False		False	False	The currency exchange rate for the refund-receipt transaction. 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 for the UK, AU, and CA editions.
RefundReceipt_GlobalTaxCalculation	String	False		False	False	The method in which tax is applied to the refund-receipt transaction. This field is valid in the UK, AU, and CA editions. The allowed values are TaxExcluded, TaxInclusive, NotApplicable.
RefundReceipt_HomeTotalAmt	Decimal	True		False	False	The total amount of the refund-receipt transaction in the home currency. This includes the total of all charges, allowances, and taxes. This field is valid in the UK, AU, and CA editions.

CData Python Connector for QuickBooks Online

RecurringRefundReceiptTransactionsLineItems

Columns