EstimateLineItems
Columns
Name | Type | ReadOnly | References | Filterable | Sortable | Description |
LineId [KEY] | String | False | false | false | The Id of the line item of the estimate. | |
EstimateId [KEY] | String | False | Estimates.Id | true | true | The Id of the estimate. |
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 field information. | |
DocNumber | String | False | true | true | The reference number for the transaction. | |
TxnDate | Date | False | true | true | The date entered by the user 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, which will not appear on the transaction records. | |
TxnStatus | String | False | false | false | The status of the transaction. The allowed values are Accepted, Closed, Pending, Rejected. | |
LinkedTxnAggregate | String | False | false | false | An XML aggregate of transactions linked to the estimate. | |
Line_Id | String | False | false | false | The Id of the line item. | |
Line_LineNum | String | False | false | false | The line number. | |
Line_Description | String | False | false | false | The line description. | |
Line_Amount | Decimal | False | false | false | The line 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 the item in the line item. |
Line_SalesItemLineDetail_ItemRef_Name | String | True | Items.Name | false | false | The name of the item in the line item. |
Line_SalesItemLineDetail_ClassRef | String | False | Class.Id | false | false | The Id of the class in the line item. |
Line_SalesItemLineDetail_ClassRef_Name | String | True | Class.FullyQualifiedName | false | false | The name of the class in the line item. |
Line_SalesItemLineDetail_UnitPrice | Decimal | False | false | false | The unit price of the item. | |
Line_SalesItemLineDetail_Qty | Double | False | false | false | The number of items for the line item. | |
Line_SalesItemLineDetail_TaxCodeRef | String | False | TaxCodes.Id | false | false | The tax code for the item. |
Line_SalesItemLineDetail_ServiceDate | Date | False | false | false | The service date for the item. | |
Line_SalesItemLineDetail_DiscountAmt | Decimal | False | false | false | The discount amount applied to this line. | |
Line_SalesItemLineDetail_DiscountRate | Decimal | False | false | false | TThe discount rate applied to this line. | |
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 tax code for the transaction. |
TxnTaxDetail_TotalTax | String | False | false | false | The 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, which appears in the invoice and the printed invoice. | |
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 | The first line of the billing address. | |
BillAddr_Line2 | String | False | false | false | The second line of the billing address. | |
BillAddr_Line3 | String | False | false | false | The third line of the billing address. | |
BillAddr_Line4 | String | False | false | false | The fourth line of the billing address. | |
BillAddr_Line5 | String | False | false | false | The fifth line of the address. | |
BillAddr_City | String | False | false | false | City name. | |
BillAddr_Country | String | False | false | false | Country name. | |
BillAddr_CountrySubDivisionCode | String | False | false |