JournalLineItems
Retrieves list of line items of a journal.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- JournalId supports the '=' and IN operators.
NOTE: JournalId is required to query JournalLineItems.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM JournalLineItems WHERE JournalId = '1894553000000085774'
SELECT * FROM JournalLineItems WHERE JournalId IN (SELECT JournalId FROM Journals)
SELECT * FROM JournalLineItems WHERE JournalId IN ('1894553000000085774','1894553000000085775')
Columns
| Name | Type | References | SupportedOperators | Description |
| LineId [KEY] | String | Id of line in journal. | ||
| JournalId | String |
Journals.JournalId | Id of journal. | |
| AccountId | String |
BankAccounts.AccountId | Id of the Bank Account. | |
| AccountName | String | Name of the account. | ||
| Amount | Decimal | Amount of the journal line items. | ||
| BcyAmount | Decimal | Amount of base currency. | ||
| CustomerId | String |
Contacts.ContactId | Id of the customer or vendor. | |
| CustomerName | String | Name of the customer or vendor. | ||
| DebitOrCredit | String | Indicates if line item is Credit or Debit. | ||
| Description | String | Description of the journal line item. | ||
| Tags | String | Details of tags related to journal line items. | ||
| TaxAuthorityId | String |
Taxes.TaxAuthorityId | Authority Id for tax. | |
| TaxExemptionId | String |
BankRules.TaxExemptionId | Id of exemption in tax. | |
| TaxExemptionType | String | Type of exemption in tax. | ||
| TaxId | String |
Taxes.TaxId | Id of tax. | |
| TaxName | String | Name of the tax. | ||
| TaxPercentage | Integer | Percentage applied for tax. | ||
| TaxType | String | Type of tax. |