RecurringSalesReceiptTransactionsLineItems

Captures line-level details of recurring sales receipts, specifying items sold, quantities, and amounts for each automated sales entry.

Columns


Name	Type	ReadOnly	References	Filterable	Sortable	Description
SalesReceipt_LineId [KEY]	String	True		False	False	The Id of the line item on the recurring sales receipt. This uniquely identifies the individual line entry within the sales-receipt transaction.
SalesReceipt_SalesReceiptId [KEY]	String	False	SalesReceipts.Id	True	True	The Id of the recurring sales receipt to which this line item belongs.
SalesReceipt_SyncToken	String	True		False	False	The version number of the object that is used to lock the recurring sales receipt record for use by one application at a time. As soon as an application modifies the record, its sync token is incremented. Attempts to modify a record specifying an older sync token fail. Only the latest version of the record is maintained by QuickBooks Online.
SalesReceipt_MetaData_CreateTime	Datetime	True		True	True	The date and time when the recurring sales receipt line record was created in QuickBooks Online.
SalesReceipt_MetaData_LastUpdatedTime	Datetime	True		True	True	The date and time when the recurring sales receipt line record was last updated in QuickBooks Online.
SalesReceipt_CustomFieldAggregate	String	False		False	False	An XML aggregate containing all custom fields that are associated with the recurring sales-receipt transaction. This collection enables you to retrieve or audit all custom metadata applied to the sales-receipt template or its individual line items.
SalesReceipt_DocNumber	String	False		True	True	The reference number that is assigned to the recurring sales-receipt transaction for tracking and reconciliation purposes.
SalesReceipt_TxnDate	Date	False		True	True	The date entered by the user when this recurring sales-receipt transaction occurred. This date represents the transaction date that is used for accounting and reporting.
SalesReceipt_DepartmentRef	String	False	Departments.Id	False	False	The Id of the department that is used to store or categorize the location of the recurring sales-receipt transaction as defined by using location tracking in QuickBooks Online.
SalesReceipt_DepartmentRef_Name	String	True	Departments.Name	False	False	The name of the department that is used to store or categorize the location of the recurring sales-receipt transaction as defined by using location tracking in QuickBooks Online.
SalesReceipt_PrivateNote	String	False		False	False	A private note about the recurring sales-receipt transaction that does not appear on the transaction records by default.
SalesReceipt_TxnStatus	String	False		False	False	The status of the recurring sales-receipt transaction. Depending on the transaction type it can have different values. For sales transactions, acceptable values are defined by the PaymentStatusEnum data type. For estimates, the values accepted are defined by the QboEstimateStatusEnum data type.
SalesReceipt_LinkedTxnAggregate	String	False		False	False	An XML aggregate containing all transactions that are linked to the recurring sales-receipt line item. This collection enables tracking of related invoices, payments, or adjustments for audit and reconciliation.
SalesReceipt_Line_Id	String	False		False	False	The Id of the specific line item within the recurring sales-receipt transaction.
SalesReceipt_Line_LineNum	String	False		False	False	The number of the line item within the recurring sales-receipt transaction.
SalesReceipt_Line_Description	String	False		False	False	A description of the line item that appears in the printed or displayed recurring sales receipt record.
SalesReceipt_Line_Amount	Decimal	False		False	False	The total monetary amount of charges or discounts for the given line item. This amount includes charges and allowances but excludes tax amounts.
SalesReceipt_Line_DetailType	String	False		False	False	The detail type of the line item in the recurring sales-receipt transaction. Different detail types indicate different types of line items.
SalesReceipt_Line_SalesItemLineDetail_ItemRef	String	False	Items.Id	False	False	The Id of the item that is included in this sales receipt line. When a line item lacks an item reference, it is treated as documentation and the Line_Amount field is ignored.
SalesReceipt_Line_SalesItemLineDetail_ItemRef_Name	String	True	Items.Name	False	False	The name of the item that is included in this sales receipt line. When a line lacks an item reference, it is treated as documentation and the Line_Amount field is ignored.
SalesReceipt_Line_SalesItemLineDetail_ClassRef	String	False	Class.Id	False	False	The Id of the class entity that is linked to this sales-receipt line item.
SalesReceipt_Line_SalesItemLineDetail_ClassRef_Name	String	True	Class.FullyQualifiedName	False	False	The name of the class entity that is linked to this sales-receipt line item.
SalesReceipt_Line_SalesItemLineDetail_UnitPrice	Decimal	False		False	False	The unit price of the item that is referenced by item reference for this sales-receipt line.
SalesReceipt_Line_SalesItemLineDetail_Qty	Decimal	False		False	False	The quantity of items for this sales-receipt line.
SalesReceipt_Line_SalesItemLineDetail_TaxCodeRef	String	False	TaxCodes.Id	False	False	The tax code that is applied to this sales-receipt line item.
SalesReceipt_Line_SalesItemLineDetail_ServiceDate	Date	False		False	False	The date when the service for this sales-receipt line item is performed.
SalesReceipt_Line_GroupLineDetail_GroupItemRef	String	True		False	False	The Id of the group item object that is included in this sales-receipt line.
SalesReceipt_Line_GroupLineDetail_GroupItemRef_Name	String	True		False	False	The name of the group item object that is included in this sales receipt line.
SalesReceipt_Line_GroupLineDetail_Quantity	Integer	True		False	False	The quantity of the group item that is recorded in this sales-receipt line.
SalesReceipt_TxnTaxDetail_TxnTaxCodeRef	String	False	TaxCodes.Id	False	False	The tax code that is applied to the recurring sales-receipt transaction.
SalesReceipt_TxnTaxDetail_TotalTax	String	False		False	False	The total tax amount that is calculated for the recurring sales-receipt transaction, excluding any tax lines that are manually inserted into the transaction line list.
SalesReceipt_TxnTaxDetail_TaxLineAggregate	String	False		False	False	An XML aggregate containing all tax line items that are associated with the recurring sales-receipt transaction. This collection lists each tax component applied to the transaction for auditing and reporting purposes.
SalesReceipt_RecurDataRef	String	False		False	False	The Id of the recurrence data reference that links the recurring sales-receipt transaction to the underlying template or schedule controlling its automated creation.
SalesReceipt_RecurDataRef_Name	String	True		False	False	The name of the recurrence data reference that identifies the recurring sales-receipt template or schedule.
SalesReceipt_RecurringInfo_Name	String	False		False	False	The descriptive name of the recurring sales-receipt schedule or template. This name is the label that users assign to recognize and manage the recurring sales-receipt pattern, such as 'Monthly Membership Fees.'
SalesReceipt_RecurringInfo_RecurType	String	False		False	False	The recurring type of the sales-receipt schedule, such as scheduled, reminder, or unscheduled. The allowed values are Automated, Reminded, UnScheduled.
SalesReceipt_RecurringInfo_Active	Boolean	False		False	False	Indicates whether the recurring sales-receipt schedule is currently active or inactive.
SalesReceipt_RecurringInfo_ScheduleInfo_IntervalType	String	False		False	False	Defines how often the recurring sales-receipt transaction occurs (for example, weekly, monthly, or yearly). The allowed values are Yearly, Monthly, Weekly, Daily.
SalesReceipt_RecurringInfo_ScheduleInfo_NumInterval	Integer	False		False	False	Specifies the number of intervals that is applied to the recurring sales-receipt schedule. This value determines how frequently the transaction recurs based on the interval type.
SalesReceipt_RecurringInfo_ScheduleInfo_DayOfWeek	String	False		False	False	The day of the week on which the recurring sales-receipt transaction is scheduled to occur when the interval type is weekly.
SalesReceipt_RecurringInfo_ScheduleInfo_WeekOfMonth	String	False		False	False	The week of the month on which the recurring sales-receipt transaction is scheduled to occur when the interval type is monthly.
SalesReceipt_RecurringInfo_ScheduleInfo_MaxOccurrences	String	False		False	False	The maximum number of occurrences that is allowed for the recurring sales-receipt schedule before it automatically stops generating transactions.
SalesReceipt_RecurringInfo_ScheduleInfo_RemindDays	String	False		False	False	The number of days before the start date on which a reminder for the recurring sales receipt should be sent.
SalesReceipt_RecurringInfo_ScheduleInfo_MonthOfYear	String	False		False	False	The month of the year on which the recurring sales-receipt transaction is scheduled to occur when the interval type is yearly.
SalesReceipt_RecurringInfo_ScheduleInfo_DaysBefore	String	False		False	False	The number of days before the scheduled date on which the recurring sales receipt is processed or triggered.
SalesReceipt_RecurringInfo_ScheduleInfo_DayOfMonth	String	False		False	False	The day of the month on which the recurring sales-receipt transaction is scheduled to occur.
SalesReceipt_RecurringInfo_ScheduleInfo_StartDate	Datetime	False		False	False	The start date of the recurring sales-receipt schedule that is associated with the recurrence template.
SalesReceipt_RecurringInfo_ScheduleInfo_NextDate	Datetime	False		False	False	The next scheduled date for the recurring sales-receipt transaction to occur.
SalesReceipt_RecurringInfo_ScheduleInfo_EndDate	Datetime	False		False	False	The end date of the recurring sales-receipt schedule when no further occurrences are generated.
SalesReceipt_RecurringInfo_ScheduleInfo_PreviousDate	Datetime	False		False	False	The previous scheduled date on which the recurring sales-receipt transaction occurred.
SalesReceipt_CustomerRef	String	False	Customers.Id	True	False	The Id of the customer that is linked to the recurring sales-receipt transaction.
SalesReceipt_CustomerRef_Name	String	True	Customers.DisplayName	False	False	The name of the customer that is linked to the recurring sales-receipt transaction.
SalesReceipt_CustomerMemo	String	False		False	False	The message that is sent to the customer with the recurring sales-receipt transaction.
SalesReceipt_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.
SalesReceipt_BillAddr_Line1	String	False		False	False	The first line of the billing address.
SalesReceipt_BillAddr_Line2	String	False		False	False	The second line of the billing address.
SalesReceipt_BillAddr_Line3	String	False		False	False	The third line of the billing address.
SalesReceipt_BillAddr_Line4	String	False		False	False	The fourth line of the billing address.
SalesReceipt_BillAddr_Line5	String	False		False	False	The fifth line of the billing address.
SalesReceipt_BillAddr_City	String	False		False	False	The city name of the billing address.
SalesReceipt_BillAddr_Country	String	False		False	False	The country name of the billing address.
SalesReceipt_BillAddr_CountrySubDivisionCode	String	False		False	False	The region within a country for the billing address. For example, this value is the state name for the USA or the province name for Canada.
SalesReceipt_BillAddr_PostalCode	String	False		False	False	The postal code of the billing address. For example, this value is the ZIP code for the USA and Canada.
SalesReceipt_BillAddr_Note	String	False		False	False	A note for the customer that is stored with the billing address.
SalesReceipt_BillAddr_Lat	String	False		False	False	The latitude coordinate of the geocoded billing address.
SalesReceipt_BillAddr_Long	String	False		False	False	The longitude coordinate of the geocoded billing address.
SalesReceipt_ShipAddr_Id	String	False		False	False	The Id of the entity for the shipping address that is mainly used for modifying the address. This field is assigned by the data service.
SalesReceipt_ShipAddr_Line1	String	False		False	False	The first line of the shipping address.
SalesReceipt_ShipAddr_Line2	String	False		False	False	The second line of the shipping address.
SalesReceipt_ShipAddr_Line3	String	False		False	False	The third line of the shipping address that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipAddr_Line4	String	False		False	False	The fourth line of the shipping address that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipAddr_Line5	String	False		False	False	The fifth line of the shipping address that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipAddr_City	String	False		False	False	The city name of the shipping address that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipAddr_Country	String	False		False	False	The country name of the shipping address that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipAddr_CountrySubDivisionCode	String	False		False	False	The region within a country for the shipping address that is associated with the recurring sales-receipt transaction. For example, this value is the state name for the USA or the province name for Canada.
SalesReceipt_ShipAddr_PostalCode	String	False		False	False	The postal code of the shipping address that is associated with the recurring sales-receipt transaction. For example, this value is the ZIP code for the USA and Canada.
SalesReceipt_ShipAddr_Note	String	False		False	False	A note for the customer that is stored with the shipping address for the recurring sales-receipt transaction.
SalesReceipt_ShipAddr_Lat	String	False		False	False	The latitude coordinate of the geocoded shipping address that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipAddr_Long	String	False		False	False	The longitude coordinate of the geocoded shipping address that is associated with the recurring sales-receipt transaction.
SalesReceipt_ClassRef	String	False	Class.Id	True	False	The Id of the class that is associated with the recurring sales-receipt transaction.
SalesReceipt_ClassRef_Name	String	True	Class.FullyQualifiedName	False	False	The name of the class that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipMethodRef	String	False		False	False	The Id of the shipping method that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipMethodRef_Name	String	True		False	False	The name of the shipping method that is associated with the recurring sales-receipt transaction.
SalesReceipt_ShipDate	Date	False		False	False	The date on which the goods or services are scheduled to be delivered for the recurring sales-receipt transaction.
SalesReceipt_TrackingNum	String	False		False	False	The tracking number that is provided by the shipping provider for the delivery of goods that is associated with the recurring sales-receipt transaction.
SalesReceipt_TotalAmt	Decimal	False		True	False	The total amount of the recurring sales-receipt transaction. This amount includes the total of all charges, allowances, and taxes. By default, QuickBooks Online recalculates this amount based on the sum of sub-items and overrides any manual entry. This field is calculated by QuickBooks business logic and cannot be written to QuickBooks Online.
SalesReceipt_PrintStatus	String	False		False	False	Indicates the print status of the recurring sales-receipt transaction in QuickBooks Online. The allowed values are NotSet, NeedToPrint, PrintComplete. The default value is NotSet.
SalesReceipt_EmailStatus	String	False		False	False	Indicates the email status of the recurring sales-receipt transaction in QuickBooks Online. The allowed values are NotSet, NeedToSend, EmailSent. The default value is NotSet.
SalesReceipt_BillEmail_Address	String	False		False	False	The email address where the recurring sales-receipt transaction is sent. If the value of the EmailStatus attribute is NeedToSend, the billing email address is required.
SalesReceipt_Balance	Decimal	True		True	True	The remaining balance of the recurring sales-receipt transaction that reflects any payments made against it.
SalesReceipt_PaymentRefNum	String	False		False	False	The reference number for the payment that is applied to the recurring sales-receipt transaction.
SalesReceipt_PaymentMethodRef	String	False	PaymentMethods.Id	False	False	The Id of the payment method entity that is used for the recurring sales-receipt transaction.
SalesReceipt_PaymentMethodRef_Name	String	True	PaymentMethods.Name	False	False	The name of the payment method entity that is used for the recurring sales-receipt transaction.
SalesReceipt_DepositToAccountRef	String	False	Accounts.Id	False	False	The Id of the asset account where the payment money for the recurring sales-receipt transaction is deposited. If you do not specify this account, QuickBooks Online uses the Undeposited Funds account.
SalesReceipt_DepositToAccountRef_Name	String	True	Accounts.Name	False	False	The name of the asset account where the payment money for the recurring sales-receipt transaction is deposited. If you do not specify this account, QuickBooks Online uses the Undeposited Funds account.
SalesReceipt_ApplyTaxAfterDiscount	Boolean	False		False	False	Indicates whether any discounts are applied before taxes are calculated for the recurring sales-receipt transaction.
SalesReceipt_CurrencyRef	String	False		False	False	The Id of the currency that is used in the recurring sales-receipt transaction.
SalesReceipt_CurrencyRef_Name	String	True		False	False	The name of the currency that is used in the recurring sales-receipt transaction.
SalesReceipt_ExchangeRate	Decimal	False		False	False	The currency exchange rate for the recurring sales-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.
SalesReceipt_GlobalTaxCalculation	String	False		False	False	The method that is used to apply taxes to the recurring sales-receipt transaction. This field is valid in the UK, AU, and CA editions. The allowed values are TaxExcluded, TaxInclusive, NotApplicable.
SalesReceipt_HomeTotalAmt	Decimal	False		False	False	The total amount of the recurring sales-receipt transaction expressed 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

RecurringSalesReceiptTransactionsLineItems

Columns