SalesReceiptLineItems
Columns
Name
Type
ReadOnly
References
Filterable
Sortable
Description
LineId [KEY]
String
True
false
false
The Id of the line item on the sales receipt.
SalesReceiptId [KEY]
String
False
SalesReceipts.Id
true
true
The Id of the sales receipt.
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.
MetaData_CreateTime
Datetime
True
true
true
The time the record was created.
MetaData_LastUpdatedTime
Datetime
True
true
true
The time the record was last updated.
CustomFieldAggregate
String
False
false
false
An XML aggregate of custom fields associated with the transaction.
DocNumber
String
False
true
true
The reference number for the transaction.
TxnDate
Date
False
true
true
The date when this transaction occurred.
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.
DepartmentRef_Name
String
True
Departments.Name
false
false
The name of the department, which stores the location of the transaction as defined using location tracking in QuickBooks Online.
PrivateNote
String
False
false
false
A private note about the transaction. This note will not appear on the transaction records by default.
TxnStatus
String
False
false
false
The status of the transaction. Depending on the transaction type it may have different values. For sales transactions acceptable values are defined in PaymentStatusEnum. For estimates, the values accepted are defined in QboEstimateStatusEnum.
LinkedTxnAggregate
String
False
false
false
An XML aggregate of the transactions linked to the line item.
Line_Id
String
False
false
false
The Id of the line item.
Line_LineNum
String
False
false
false
The number of the line item.
Line_Description
String
False
false
false
A description of the line item that appears in the printed record.
Line_Amount
Decimal
False
false
false
Total amount of the charges or discounts for the given line. Includes the charges and allowances, but it excludes the tax amount.
Line_DetailType
String
False
false
false
The line detail type. Different detail types indicate different types of line items.
Line_SalesItemLineDetail_ItemRef
String
False
Items.Id
false
false
The Id of an item in the line item. When a line item lacks an ItemRef it is treated as documentation and the Line_Amount field is ignored.
Line_SalesItemLineDetail_ItemRef_Name
String
True
Items.Name
false
false
The name of the item. When a line lacks an ItemRef it is treated as documentation and the Line_Amount field is ignored.
Line_SalesItemLineDetail_ClassRef
String
False
Class.Id
false
false
The Id of the entity for the class for the line item.
Line_SalesItemLineDetail_ClassRef_Name
String
True
Class.FullyQualifiedName
false
false
The name of the class for the line item.
Line_SalesItemLineDetail_UnitPrice
Decimal
False
false
false
The unit price of the item referenced by ItemRef.
Line_SalesItemLineDetail_Qty
Decimal
False
false
false
The number of items for the line.
Line_SalesItemLineDetail_TaxCodeRef
String
False
TaxCodes.Id
false
false
The tax code for this item.
Line_SalesItemLineDetail_ServiceDate
Date
False
false
false
The date when the service is performed.
Line_GroupLineDetail_GroupItemRef
String
True
false
false
The Id of the group item object.
Line_GroupLineDetail_GroupItemRef_Name
String
True
false
false
The name of the group item object.
Line_GroupLineDetail_Quantity
Integer
True
false
false
The amount of the group item.
TxnTaxDetail_TxnTaxCodeRef
String
False
TaxCodes.Id
false
false
The transaction tax code.
TxnTaxDetail_TotalTax
String
False
false
false
Total tax calculated for the transaction, excluding any tax lines manually inserted into the transaction line list.
TxnTaxDetail_TaxLineAggregate
String
False
false
false
An XML aggregate of tax line items.
CustomerRef
String
False
Customers.Id
true
false
The Id of the customer.
CustomerRef_Name
String
True
Customers.DisplayName
false
false
The name of the customer.
CustomerMemo
String
False
false
false
The message to the customer.
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.
BillAddr_Line1
String
False
false
false
First line of the address.
BillAddr_Line2
String
False
false
false
Second line of the address.
BillAddr_Line3
String
False
false
false
Third line of the address.
BillAddr_Line4
String
False
false
false
Fourth line of the address.
BillAddr_Line5
String
False
false
false