| Name | Type | ReadOnly | Filterable | Description |
|---|---|---|---|---|
| Id [KEY] | string | true | true | The Id of the Estimate. |
| SyncToken | string | false | false | The sync token. This must be specified when executing an update or delete. |
| MetaData_CreateTime | datetime | true | true | The time the record was created. |
| MetaData_LastUpdatedTime | datetime | true | true | The time the record was last updated. |
| CustomField | string | false | false | A json aggregate of custom field information. other:childtable= |
| DocNumber | string | false | true | The reference number for the transaction. |
| TxnDate | date | false | true | The date when this transaction occurred. |
| DepartmentRef | string | 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 | 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 | A private note, which will not appear on the transaction records. |
| TxnStatus | string | false | false | The status of the transaction. |
| LinkedTxn | string | false | false | A json aggregate of transactions linked to the estimate. |
| Line | string | false | false | A json aggregate of line items associated with the transaction. other:childtable= |
| TxnTaxDetail_TxnTaxCodeRef | string | false | false | The tax code for the transaction. |
| TxnTaxDetail_TxnTaxCodeRef_Name | string | true | false | The name of the tax code for the transaction. |
| TxnTaxDetail_TotalTax | string | false | false | The total tax calculated for the transaction, excluding any tax lines manually inserted into the transaction line list. |
| TxnTaxDetail_TaxLine | string | false | false | A JSON aggregate of tax line items. |
| CustomerRef | string | false | true | The Id of the customer. |
| CustomerRef_Name | string | true | false | The name of the customer. |
| CustomerMemo | string | false | false | A message to the customer, which appears in the invoice and in the printed invoice. |
| BillAddr_Id | string | 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 | First line of the billing address. |
| BillAddr_Line2 | string | false | false | Second line of the billing address. |
| BillAddr_Line3 | string | false | false | Third line of the billing address. |
| BillAddr_Line4 | string | false | false | Fourth line of the billing address. |
| BillAddr_Line5 | string | false | false | Fifth line of the billing address. |
| BillAddr_City | string | false | false | City name. |
| BillAddr_Country | string | false | false | Country name. |
| BillAddr_CountrySubDivisionCode | string | false | false | Country region. For example, the state name for the USA or the province name for Canada. |
| BillAddr_PostalCode | string | false | false | Postal code. The zip code for the USA and Canada. |
| BillAddr_Note | string | false | false | Note for the customer. |
| BillAddr_Lat | string | false | false | The latitude coordinate of the geocoded billing address. |
| BillAddr_Long | string | false | false | The longitude coordinate of the geocoded billing address. |
| ShipAddr_Id | string | 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. |
| ShipAddr_Line1 | string | false | false | First line of the shipping address. |
| ShipAddr_Line2 | string | false | false | Second line of the shipping address. |
| ShipAddr_Line3 | string | false | false | Third line of the shipping address. |
| ShipAddr_Line4 | string | false | false | Fourth line of the shipping address. |
| ShipAddr_Line5 | string | false | false | Fifth line of the shipping address. |
| ShipAddr_City | string | false | false | City name. |
| ShipAddr_Country | string | false | false | Country name. |
| ShipAddr_CountrySubDivisionCode | string | false | false | Country region. For example, the state name for the USA or the province name for Canada. |
| ShipAddr_PostalCode | string | false | false | Postal code. For example, the zip code for the USA and Canada. |
| ShipAddr_Note | string | false | false | Note for the customer. |
| ShipAddr_Lat | string | false | false | The latitude coordinate of the geocoded shipping address. |
| ShipAddr_Long | string | false | false | The longitude coordinate of the geocoded shipping address. |
| ShipFromAddr_Id | string | false | false | The Id of the entity for the address where the goods are shipped from, mainly used for modifying the address. This field is assigned by the data service. |
| ShipFromAddr_Line1 | string | false | false | First line of the address. |
| ShipFromAddr_Line2 | string | false | false | Second line of the address. |
| ShipFromAddr_Line3 | string | false | false | Third line of the address. |
| ShipFromAddr_Line4 | string | false | false | Fourth line of the address. |
| ShipFromAddr_Line5 | string | false | false | Fifth line of the address. |
| ShipFromAddr_City | string | false | false | City name. |
| ShipFromAddr_Country | string | false | false | Country name. |
| ShipFromAddr_CountrySubDivisionCode | string | false | false | Region within a country. For example, the state name for the USA or the province name for Canada. |
| ShipFromAddr_PostalCode | string | false | false | Postal code. For example, the zip code for the USA and Canada. |
| ShipFromAddr_Note | string | false | false | Note for the customer. |
| ShipFromAddr_Lat | string | false | false | The latitude coordinate of the geocoded shipping address. |
| ShipFromAddr_Long | string | false | false | The longitude coordinate of the geocoded shipping address. |
| ClassRef | string | false | true | The Id of the class associated with the transaction. |
| ClassRef_Name | string | true | false | The name of the class associated with the transaction. |
| SalesTermRef | string | false | false | The Id of the sales terms associated with the transaction. |
| SalesTermRef_Name | string | true | false | The name of the sales terms associated with the transaction. |
| DueDate | date | false | true | The due date for the invoice, 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. |
| ShipMethodRef | string | false | false | The Id of the shipping method associated with the transaction. |
| ShipMethodRef_Name | string | true | false | The name of the shipping method associated with the transaction. |
| ShipDate | date | false | false | The date for delivery of goods or services. |
| TrackingNum | string | false | false | The tracking number for the shipping provider for the delivery of the goods associated with the transaction. |
| TotalAmt | decimal | true | true | The total amount of the transaction. This includes the total of all the charges, allowances, and taxes. |
| PrintStatus | string | false | false | The print status of the invoice. |
| EmailStatus | string | false | false | The email status of the invoice. |
| BillEmail_Address | string | false | false | The email address where the invoice is sent. If the value of EmailStatus is NeedToSend, BillEmail is a required input. |
| Balance | decimal | false | true | This column sets whether the transaction is a finance charge. |
| ExpirationDate | date | false | false | The date when the estimate becomes invalid. |
| AcceptedBy | string | false | false | The name of the customer who accepted the estimate. |
| AcceptedDate | date | false | false | The date the estimate was accepted. |
| ApplyTaxAfterDiscount | boolean | false | false | This field sets whether discounts are applied before the tax is calculated. |
| CurrencyRef | string | false | false | The Id of the currency used in the transaction. |
| CurrencyRef_Name | string | true | false | The name of the currency used in the transaction. |
| ExchangeRate | decimal | false | false | The currency exchange rate. This field is valid only if the company file is set up to use 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, IN, and CA editions. |
| GlobalTaxCalculation | string | false | false | The method used to apply taxes. This field is valid in the UK, AU, IN, and CA editions. |
| HomeTotalAmt | decimal | true | false | The 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, IN, and CA editions. |
