JournalEntries
Columns
Name | Type | ReadOnly | References | Filterable | Sortable | Description |
Id [KEY] | String | True | true | true | The Id of the journal entry. | |
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. | |
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 about the transaction. This note will not appear on the transaction records by default. | |
Adjustment | Boolean | False | false | false | The total amount of the transaction. This includes the total of all the charges, allowances, and taxes. | |
LineAggregate | String | False | false | false | An XML aggregate of the line items of a transaction. | |
TxnTaxDetail_TxnTaxCodeRef | String | False | TaxCodes.Id | false | false | The transaction tax code. |
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. | |
TotalAmt | Decimal | True | false | true | The total amount of the transaction. Calculated by QuickBooks business logic; any value you supply is over-written by QuickBooks. | |
CurrencyRef | String | False | false | false | The Id of the currency used in the transaction. | |
CurrencyRef_Name | String | True | false | false | The name of the currency used in the transaction. | |
ExchangeRate | Decimal | False | false | false | The currency exchange rate. This field is only valid if the company file uses 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 in only the UK, AU, IN, and CA editions. |
Last updated