Tableau Connector for QuickBooks Online

Build 24.0.9062

RecurringCreditMemoTransactionsLineItems

Create and query QuickBooks Recurring Transactions for Credit Memo Line Items.

Columns

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

The Id of the line item of the credit memo.

CreditMemo_CreditMemoId [KEY] String False

CreditMemos.Id

True True

The Id of the credit memo.

CreditMemo_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.

CreditMemo_MetaData_CreateTime Datetime True True True

The time the record was created.

CreditMemo_MetaData_LastUpdatedTime Datetime True True True

The time the record was last updated.

CreditMemo_CustomFieldAggregate String False False False

An XML aggregate of custom fields for the credit memo.

CreditMemo_DocNumber String False True True

The reference number for the transaction.

CreditMemo_TxnDate Date False True True

The date when the transaction occurred.

CreditMemo_PrivateNote String False False False

A private note about the transaction. By default, this field will not appear on transaction records.

CreditMemo_LinkedTxnAggregate String False False False

An XML aggregate of linked transactions on the credit memo.

CreditMemo_Line_Id String False False False

The Id of the line item.

CreditMemo_Line_Description String False False False

The description of the line item that appears in the printed record.

CreditMemo_Line_Amount Decimal False False False

The total amount of the charges or discounts for the given line. This includes the charges and allowances but excludes the tax amount.

CreditMemo_Line_DetailType String False False False

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

CreditMemo_Line_SalesItemLineDetail_ItemRef String False

Items.Id

False False

The Id of the item. When a line item lacks an ItemRef it is treated as documentation and the Line_Amount attribute is ignored.

CreditMemo_Line_SalesItemLineDetail_ItemRef_Name String True

Items.Name

False False

The name of the item. When a line item lacks an ItemRef it is treated as documentation and the Line_Amount attribute is ignored.

CreditMemo_Line_SalesItemLineDetail_ClassRef String False

Class.Id

False False

The Id of the class entity of the line item.

CreditMemo_Line_SalesItemLineDetail_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class entity of the line item.

CreditMemo_Line_SalesItemLineDetail_UnitPrice Decimal False False False

The unit price of the item.

CreditMemo_Line_SalesItemLineDetail_Qty Double False False False

The number of items in the line item.

CreditMemo_Line_SalesItemLineDetail_TaxCodeRef String False

TaxCodes.Id

False False

The tax code for this item.

CreditMemo_Line_SalesItemLineDetail_ServiceDate Date False False False

The date when the service was performed.

CreditMemo_Line_GroupLineDetail_GroupItemRef String True False False

The Id of the group item object.

CreditMemo_Line_GroupLineDetail_GroupItemRef_Name String True False False

The name of the group item object.

CreditMemo_Line_GroupLineDetail_Quantity Integer True False False

The amount of the group item.

CreditMemo_TxnTaxDetail_TxnTaxCodeRef String False

TaxCodes.Id

False False

The tax code for the transaction.

CreditMemo_TxnTaxDetail_TotalTax String False False False

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

CreditMemo_TxnTaxDetail_TaxLineAggregate String False False False

An XML aggregate of tax line items.

CreditMemo_RecurDataRef String False False False

The Recurrence Data reference.

CreditMemo_RecurDataRef_Name String True False False

An identifying name for the object.

CreditMemo_RecurringInfo_Name String False False False

The Recurring Info name.

CreditMemo_RecurringInfo_RecurType String False False False

The Recurring Info recurring type.

使用できる値は次のとおりです。Automated, Reminded, UnScheduled

CreditMemo_RecurringInfo_Active Boolean False False False

The Recurring Info is active or not.

CreditMemo_RecurringInfo_ScheduleInfo_IntervalType String False False False

The Recurring Info interval type.

使用できる値は次のとおりです。Yearly, Monthly, Weekly, Daily

CreditMemo_RecurringInfo_ScheduleInfo_NumInterval Integer False False False

The Recurring Info num interval.

CreditMemo_RecurringInfo_ScheduleInfo_DayOfWeek String False False False

The Recurring Info day of week.

CreditMemo_RecurringInfo_ScheduleInfo_WeekOfMonth String False False False

The Recurring Info week of month.

CreditMemo_RecurringInfo_ScheduleInfo_MaxOccurrences String False False False

The max number of recurring occurrences.

CreditMemo_RecurringInfo_ScheduleInfo_RemindDays String False False False

The days before start date for a reminded RecurType.

CreditMemo_RecurringInfo_ScheduleInfo_MonthOfYear String False False False

The month of the year.

CreditMemo_RecurringInfo_ScheduleInfo_DaysBefore String False False False

The days before the scheduled date.

CreditMemo_RecurringInfo_ScheduleInfo_DayOfMonth String False False False

The day of the month.

CreditMemo_RecurringInfo_ScheduleInfo_StartDate Datetime False False False

The Recurring Info start date.

CreditMemo_RecurringInfo_ScheduleInfo_NextDate Datetime False False False

The Recurring Info next date.

CreditMemo_RecurringInfo_ScheduleInfo_EndDate Datetime False False False

The end date for the recurring schedule.

CreditMemo_RecurringInfo_ScheduleInfo_PreviousDate Datetime False False False

The Recurring Info previous date.

CreditMemo_CustomerRef String False

Customers.Id

True True

The Id of the customer.

CreditMemo_CustomerRef_Name String True

Customers.DisplayName

False False

A name that identifies the customer.

CreditMemo_CustomerMemo String False False False

A message to the customer, visible on the transaction.

CreditMemo_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.

CreditMemo_BillAddr_Line1 String False False False

The first line of the address.

CreditMemo_BillAddr_Line2 String False False False

The second line of the address.

CreditMemo_BillAddr_Line3 String False False False

The third line of the address.

CreditMemo_BillAddr_Line4 String False False False

The fourth line of the address.

CreditMemo_BillAddr_Line5 String False False False

The fifth line of the address.

CreditMemo_BillAddr_City String False False False

The city name.

CreditMemo_BillAddr_Country String False False False

The country name.

CreditMemo_BillAddr_CountrySubDivisionCode String False False False

The country region. The state name for the USA or the province name for Canada.

CreditMemo_BillAddr_PostalCode String False False False

The postal code. The zip code for the USA and Canada.

CreditMemo_BillAddr_Note String False False False

The note for the customer.

CreditMemo_BillAddr_Lat String False False False

The latitude coordinate of the geocoded address.

CreditMemo_BillAddr_Long String False False False

The longitude coordinate of the geocoded address.

CreditMemo_ShipAddr_Line1 String False False False

The first line of the shipping address.

CreditMemo_ShipAddr_Line2 String False False False

The second line of the shipping address.

CreditMemo_ShipAddr_Line3 String False False False

The third line of the shipping address.

CreditMemo_ShipAddr_Line4 String False False False

The fourth line of the shipping address.

CreditMemo_ShipAddr_Line5 String False False False

The fifth line of the shipping address.

CreditMemo_ShipAddr_City String False False False

The city name

CreditMemo_ShipAddr_Country String False False False

The country name

CreditMemo_ShipAddr_CountrySubDivisionCode String False False False

The region within a country.

CreditMemo_ShipAddr_PostalCode String False False False

The postal code.

CreditMemo_ShipAddr_Lat String False False False

The latitude coordinate of the geocoded shipping address.

CreditMemo_ShipAddr_Long String False False False

The longitude coordinate of the geocoded shipping address.

CreditMemo_ClassRef String False

Class.Id

True False

The Id of the class.

CreditMemo_ClassRef_Name String True

Class.FullyQualifiedName

False False

The name of the class.

CreditMemo_SalesTermRef String False

Terms.Id

True False

The Id of the sales term associated with the transaction.

CreditMemo_SalesTermRef_Name String True

Terms.Name

False False

A name that identifies the sales term associated with the transaction.

CreditMemo_TotalAmt Decimal False True True

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

CreditMemo_PrintStatus String False False False

The print status of the credit memo.

使用できる値は次のとおりです。NotSet, NeedToPrint, PrintComplete

デフォルト値はNotSetです。

CreditMemo_EmailStatus String False False False

The email status of the invoice.

使用できる値は次のとおりです。NotSent, NeedToSend, EmailSent

デフォルト値はNotSetです。

CreditMemo_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.

CreditMemo_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.

CreditMemo_RemainingCredit Decimal False False False

The total credit amount still available to apply towards the payment.

CreditMemo_DepartmentRef String False

Departments.Id

False False

The Id of the department, which stores the location of the transaction.

CreditMemo_DepartmentRef_Name String True

Departments.Name

False False

The name of the department, which stores location of the transaction.

CreditMemo_BillEmail_Address String False False False

The email address where the invoice is sent. If the value of EmailStatus is NeedToSend, this field is a required input.

CreditMemo_ApplyTaxAfterDiscount Boolean False False False

This field sets whether the discount is applied before or after taxes are calculated.

CreditMemo_CurrencyRef String False False False

The Id of the currency used for all amounts of the transaction. This field is available in only the UK, AU, and CA editions.

CreditMemo_CurrencyRef_Name String True False False

The name of the currency used for all amounts of the transaction. This field is available in only the UK, AU, and CA editions.

CreditMemo_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 only the UK, AU, and CA editions.

CreditMemo_GlobalTaxCalculation String False False False

The method in which tax is applied. This field is valid in only the UK, AU, and CA editions.

使用できる値は次のとおりです。TaxExcluded, TaxInclusive, NotApplicable

CreditMemo_HomeTotalAmt Decimal True False False

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

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