Invoices
Columns
Name | Type | ReadOnly | References | Filterable | Sortable | Description |
Id [KEY] | String | True | true | true | The Id of the invoice. | |
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. | |
PrivateNote | String | False | false | false | A private note that does 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. | |
LineAggregate | String | False | false | false | An XML aggregate of line items associated with the transaction. | |
TxnTaxDetail_TxnTaxCodeRef | String | False | TaxCodes.Id | false | false | The tax code of the transaction. |
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 that appears in the invoice and in 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 | 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 | 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 | false | Region within a country. For example, the state name for the USA or the province name for Canada. | |
BillAddr_PostalCode | String | False | false | false | Postal code. For example, the zip code for the USA and Canada. | |
BillAddr_Note | String | False | false | false | Note for the customer. | |
BillAddr_Lat | String | False | false | false | The latitude coordinate of the geocoded billing address. | |
BillAddr_Long | String | False | false | false | The longitude coordinate of the geocoded billing address. | |
ShipAddr_Id | String | False | 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 |