JournalLineItems
Retrieves list of line items of a journal.
Table Specific Information
Select
The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
Note: JournalId is required in order to query JournalLineItems.
- JournalId supports the '=' comparison.
SELECT * FROM JournalLineItems WHERE JournalId = '1894553000000085774'
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. |