JournalEntryLineItems
Columns
Name | Type | ReadOnly | References | Filterable | Sortable | Description |
LineId [KEY] | String | False | false | false | The Id of the line item of the journal entry. | |
JournalEntryId [KEY] | String | False | JournalEntries.Id | 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 | 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. | |
Line_Id | String | False | false | false | The Id 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 | The amount of the line item. | |
Line_DetailType | String | False | false | false | The detail type of the line item. Different detail types indicate different types of line items. | |
Line_JournalEntryLineDetail_PostingType | String | False | false | false | This field indicates the posting type of the line item of the journal entry detail. The allowed values are Credit, Debit. | |
Line_JournalEntryLineDetail_Entity_Type | String | False | false | false | The type of the entity to be referenced. | |
Line_JournalEntryLineDetail_Entity_EntityRef | String | False | false | false | The Id of the entity to be referenced. | |
Line_JournalEntryLineDetail_Entity_EntityRef_Name | String | True | false | false | The name of the entity to be referenced. | |
Line_JournalEntryLineDetail_AccountRef | String | False | Accounts.Id | false | false | The Id of the account associated with the journal entry line item. |
Line_JournalEntryLineDetail_AccountRef_Name | String | True | Accounts.Name | false | false | The name of the account associated with the journal entry line item. |
Line_JournalEntryLineDetail_ClassRef | String | False | Class.Id | false | false | The Id of the class associated with the journal entry line item. |
Line_JournalEntryLineDetail_ClassRef_Name | String | True | Class.FullyQualifiedName | false | false | The name of the class associated with the journal entry line. |
Line_JournalEntryLineDetail_DepartmentRef | String | False | Departments.Id | false | false | The Id of the department associated with the journal entry line. |
Line_JournalEntryLineDetail_DepartmentRef_Name | String | True | Departments.Name | false | false | The name of the department associated with the journal entry line. |
Line_JournalEntryLineDetail_TaxCodeRef | String | False | TaxCodes.Id | false | false | The sales or purchase tax code associated with the journal entry line. This field is used for non-U.S., non-Canadian companies. This field is valid for the UK and IN editions. |
Line_JournalEntryLineDetail_TaxApplicableOn | String | False | false | false | This field indicates whether the tax applicable to the line item is sales or purchase tax. This field is valid for the UK and IN editions. | |
Line_JournalEntryLineDetail_TaxAmount | Decimal | False | false | false | The tax applicable for this line item. This field is valid for the UK, AU, and IN editions. | |
Line_JournalEntryLineDetail_BillableStatus | String | False | false | false | The billable status of the journal entry line. The line is to be billed to a customer if the account is an expense account and the Entity Reference specifies a Customer or a Job. The allowed values are Billable, NotBillable, HasBeenBilled. | |
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. | |
TotalAmt | Decimal | True | true |