Tableau Connector for QuickBooks Online

Build 24.0.9060

RecurringRefundReceiptTransactionsLineItems

Create and query QuickBooks Recurring Transactions for RefundReceiptLineItems.

Columns

Name Type ReadOnly References Filterable Sortable Description
RefundReceipt_LineId [KEY] String True True False

The Id of the line item of the invoice of the read receipt.

RefundReceipt_RefundReceiptId [KEY] String False

RefundReceipts.Id

True True

The Id of the read receipt.

RefundReceipt_SyncToken String True False False

Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.

RefundReceipt_MetaData_CreateTime Datetime True True True

The time the record was created.

RefundReceipt_MetaData_LastUpdatedTime Datetime True True True

The time the record was last updated.

RefundReceipt_CustomFieldAggregate String False False False

An XML aggregate of custom field information.

RefundReceipt_DocNumber String False True True

The reference number for the transaction.

RefundReceipt_TxnDate Date False True True

The date entered by the user when this transaction occurred.

RefundReceipt_PrivateNote String False False False

A private note that does not appear on the transaction records.

RefundReceipt_Line_Id String False False False

The Id of the line item.

RefundReceipt_Line_LineNum String False False False

The line number of the line item.

RefundReceipt_Line_Description String False False False

The description of the line item.

RefundReceipt_Line_Amount Decimal False False False

The amount of the line item.

RefundReceipt_Line_DetailType String False False False

The detail type of the line item. Different detail types indicate different types of line items.

RefundReceipt_Line_SalesItemLineDetail_ItemRef String False

Items.Id

False False

The Id of the item in the line item.

RefundReceipt_Line_SalesItemLineDetail_ItemRef_Name String True

Items.Name

False False

The name of the item in the line item.

RefundReceipt_Line_SalesItemLineDetail_ClassRef String False

Class.Id

False False

The Id of the class in the line item.

RefundReceipt_Line_SalesItemLineDetail_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class in the line item.

RefundReceipt_Line_SalesItemLineDetail_UnitPrice Decimal False False False

The unit price of the item.

RefundReceipt_Line_SalesItemLineDetail_Qty Double False False False

The number of items for the line item.

RefundReceipt_Line_SalesItemLineDetail_TaxCodeRef String False

TaxCodes.Id

False False

The tax code for the item.

RefundReceipt_Line_SalesItemLineDetail_ServiceDate Date False False False

The service date for the item.

RefundReceipt_TxnTaxDetail_TxnTaxCodeRef String False

TaxCodes.Id

False False

The tax code of the transaction.

RefundReceipt_TxnTaxDetail_TotalTax String False False False

Total tax calculated for the transaction, excluding any tax lines manually inserted into the transaction line list.

RefundReceipt_TxnTaxDetail_TaxLineAggregate String False False False

An XML aggregate of tax line items.

RefundReceipt_RecurDataRef String False False False

The Recurrence Data reference.

RefundReceipt_RecurDataRef_Name String True False False

An identifying name for the object.

RefundReceipt_RecurringInfo_Name String False False False

The Recurring Info name.

RefundReceipt_RecurringInfo_RecurType String False False False

The Recurring Info recurring type.

The allowed values are Automated, Reminded, UnScheduled.

RefundReceipt_RecurringInfo_Active Boolean False False False

The Recurring Info is active or not.

RefundReceipt_RecurringInfo_ScheduleInfo_IntervalType String False False False

The Recurring Info interval type.

The allowed values are Yearly, Monthly, Weekly, Daily.

RefundReceipt_RecurringInfo_ScheduleInfo_NumInterval Integer False False False

The Recurring Info num interval.

RefundReceipt_RecurringInfo_ScheduleInfo_DayOfWeek String False False False

The Recurring Info day of week.

RefundReceipt_RecurringInfo_ScheduleInfo_WeekOfMonth String False False False

The Recurring Info week of month.

RefundReceipt_RecurringInfo_ScheduleInfo_MaxOccurrences String False False False

The max number of recurring occurrences.

RefundReceipt_RecurringInfo_ScheduleInfo_RemindDays String False False False

The days before start date for a reminded RecurType.

RefundReceipt_RecurringInfo_ScheduleInfo_MonthOfYear String False False False

The month of the year.

RefundReceipt_RecurringInfo_ScheduleInfo_DaysBefore String False False False

The days before the scheduled date.

RefundReceipt_RecurringInfo_ScheduleInfo_DayOfMonth String False False False

The day of the month.

RefundReceipt_RecurringInfo_ScheduleInfo_StartDate Datetime False False False

The Recurring Info start date.

RefundReceipt_RecurringInfo_ScheduleInfo_NextDate Datetime False False False

The Recurring Info next date.

RefundReceipt_RecurringInfo_ScheduleInfo_EndDate Datetime False False False

The end date for the recurring schedule.

RefundReceipt_RecurringInfo_ScheduleInfo_PreviousDate Datetime False False False

The Recurring Info previous date.

RefundReceipt_CustomerRef String False

Customers.Id

True False

The Id of the customer.

RefundReceipt_CustomerRef_Name String True

Customers.DisplayName

False False

The name of the customer.

RefundReceipt_CustomerMemo String False False False

The message to the customer that appears in the invoice and in the printed invoice.

RefundReceipt_BillAddr_Id String False False False

The Id of the entity for the billing address, mainly used for modifying the address. This field is assigned by the data service.

RefundReceipt_BillAddr_Line1 String False False False

First line of the address.

RefundReceipt_BillAddr_Line2 String False False False

Second line of the address.

RefundReceipt_BillAddr_Line3 String False False False

Third line of the address.

RefundReceipt_BillAddr_Line4 String False False False

Fourth line of the address.

RefundReceipt_BillAddr_Line5 String False False False

Fifth line of the address.

RefundReceipt_BillAddr_City String False False False

City name.

RefundReceipt_BillAddr_Country String False False False

Country name.

RefundReceipt_BillAddr_CountrySubDivisionCode String False False False

Region within a country. For example, the state name for the USA or the province name for Canada.

RefundReceipt_BillAddr_PostalCode String False False False

Postal code. For example, the zip code for the USA and Canada.

RefundReceipt_BillAddr_Note String False False False

Note for the customer.

RefundReceipt_BillAddr_Lat String False False False

The latitude coordinate of the geocoded billing address.

RefundReceipt_BillAddr_Long String False False False

The longitude coordinate of the geocoded billing address.

RefundReceipt_ShipAddr_Id String False False False

The Id of the entity for the shipping address, mainly used for modifying the address. This field is assigned by the data service.

RefundReceipt_ShipAddr_Line1 String False False False

First line of the address.

RefundReceipt_ShipAddr_Line2 String False False False

Second line of the address.

RefundReceipt_ShipAddr_Line3 String False False False

Third line of the address.

RefundReceipt_ShipAddr_Line4 String False False False

Fourth line of the address.

RefundReceipt_ShipAddr_Line5 String False False False

Fifth line of the address.

RefundReceipt_ShipAddr_City String False False False

City name.

RefundReceipt_ShipAddr_Country String False False False

Country name.

RefundReceipt_ShipAddr_CountrySubDivisionCode String False False False

Region within a country. For example, the state name for the USA or the province name for Canada.

RefundReceipt_ShipAddr_PostalCode String False False False

Postal code. For example, the zip code for the USA and Canada.

RefundReceipt_ShipAddr_Note String False False False

Note for the customer.

RefundReceipt_ShipAddr_Lat String False False False

The latitude coordinate of the geocoded shipping address.

RefundReceipt_ShipAddr_Long String False False False

The longitude coordinate of the geocoded shipping address.

RefundReceipt_ClassRef String False

Class.Id

False False

The Id of the class associated with the transaction.

RefundReceipt_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class associated with the transaction.

RefundReceipt_CheckPayment_CheckNum String True False False

The check number printed on the check.

RefundReceipt_CheckPayment_Status String False False False

Status of the check. Values provided by service/business logic.

RefundReceipt_CheckPayment_NameOnAccount String False False False

Name of persons or entities holding the account, as printed on the check.

RefundReceipt_CheckPayment_AcctNum String False False False

Checking account number, as printed on the check.

RefundReceipt_CheckPayment_BankName String True False False

The name of the bank on which the check was drawn.

RefundReceipt_CreditCardPayment_CreditChargeInfo_Type String False False False

The type of credit card.

RefundReceipt_CreditCardPayment_CreditChargeInfo_NameOnAcct String False False False

The name of the account holder, as printed on the card.

RefundReceipt_CreditCardPayment_CreditChargeInfo_CcExpiryMonth Integer False False False

The expiration month of the card.

RefundReceipt_CreditCardPayment_CreditChargeInfo_CcExpiryYear Integer False False False

The four-digit expiration year of the card.

RefundReceipt_CreditCardPayment_CreditChargeInfo_BillAddrStreet String False False False

The street of the billing address of the credit card holder.

RefundReceipt_CreditCardPayment_CreditChargeInfo_PostalCode String False False False

The postal code.

RefundReceipt_CreditCardPayment_CreditChargeInfo_Amount Decimal False False False

The amount processed using the credit card

RefundReceipt_CreditCardPayment_CreditChargeInfo_ProcessPayment Boolean False False False

False or no value-Store credit card information only.True-Store credit card payment transaction information in CreditChargeResponse below.

RefundReceipt_CreditCardPayment_CreditChargeResponse_CCTransId String False False False

Unique identifier of the payment transaction.

RefundReceipt_CreditCardPayment_CreditChargeResponse_AuthCode String False False False

Code returned from the credit card processor to indicate that the charge will be paid by the card issuer.

RefundReceipt_CreditCardPayment_CreditChargeResponse_TxnAuthorizationTime Datetime False False False

Timestamp indicating the time in which the card processor authorized the transaction.

RefundReceipt_CreditCardPayment_CreditChargeResponse_Status String False False False

Indicates the status of the payment transaction. Possible values include Completed, Unknown.

RefundReceipt_SalesTermRef String False

Terms.Id

False False

The Id of the sales term associated with the transaction.

RefundReceipt_SalesTermRef_Name String True

Terms.Name

False False

The name of the sales term associated with the transaction.

RefundReceipt_DueDate Date False True False

The date when the 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 associated with the transaction.

RefundReceipt_ShipMethodRef_Name String True False False

The name of the shipping method associated with the transaction.

RefundReceipt_ShipDate Date False False False

The date for delivery of goods or services.

RefundReceipt_TotalAmt Decimal True True True

This field indicates the total amount of the transaction. This includes the total of all the charges, allowances, and taxes.

RefundReceipt_ApplyTaxAfterDiscount Boolean False False False

This field sets whether discounts are applied before the tax is calculated.

RefundReceipt_DepartmentRef String False

Departments.Id

False False

The Id of the department, which stores the location of the transaction as defined using location tracking in QuickBooks Online.

RefundReceipt_DepartmentRef_Name String True

Departments.Name

False False

The name of the department, which store the location of the transaction as defined using location tracking in QuickBooks Online.

RefundReceipt_PrintStatus String False False False

The print status of the invoice.

The allowed values are NotSet, NeedToPrint, PrintComplete.

RefundReceipt_BillEmail_Address String False False False

This field identifies the email address where the invoice is sent. If the value of EmailStatus is NeedToSend, BillEmail is a required input.

RefundReceipt_Balance Decimal False False False

This field indicates whether the transaction is a finance charge.

RefundReceipt_PaymentMethodRef String False

PaymentMethods.Id

False False

The Id of the payment method associated with the transaction.

RefundReceipt_PaymentMethodRef_Name String True

PaymentMethods.Name

False False

The name of the payment method associated with the transaction.

RefundReceipt_PaymentRefNum String False False False

The reference number for the payment received.

RefundReceipt_PaymentType String False False False

The type of payment used for the transaction.

The allowed values are Cash, Check, CreditCard, Other.

RefundReceipt_DepositToAccountRef String False

Accounts.Id

False False

The asset account where the payment money 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 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 used in the 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 associated transaction are expressed. This field is valid in the UK, AU, and CA editions.

RefundReceipt_ExchangeRate Decimal False False False

The currency exchange rate. This field is valid only if 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. This field is valid in the UK, AU, and CA editions.

The allowed values are TaxExcluded, TaxInclusive, NotApplicable.

RefundReceipt_HomeTotalAmt Decimal True False False

Total amount of the transaction in the home currency. Includes the total of all the charges, allowances, and taxes. This field is valid in the UK, AU, and CA editions.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060