CreditNotes
Retrieves list of all the Credit Notes.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- CreditnoteNumber supports the '=' comparison.
- CustomerId supports the '=' comparison.
- CustomerName supports the '=' comparison.
- Date supports the '=' comparison.
- ReferenceNumber supports the '=' comparison.
- Status supports the '=' comparison.
- Total supports the '=' comparison.
- CreditNoteFilter supports the '=' comparison.
- LineItemId supports the '=' comparison.
- TaxId supports the '=' comparison.
- ItemId supports the '=' comparison.
- ItemName supports the '=' comparison.
- ItemDescription supports the '=' comparison.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM CreditNotes WHERE CreditnoteNumber = 'CN-00006' AND ReferenceNumber = 'Ref-0075' AND CustomerName = 'AWS Stores'
SELECT * FROM CreditNotes WHERE CreditNoteFilter = 'Status.All'
Columns
| Name | Type | References | SupportedOperators | Description |
| CreditnoteId [KEY] | String | Id of credit note. | ||
| Balance | Decimal | Total amount of credit note left. | ||
| ColorCode | String | Color code of a credit note. | ||
| CreatedTime | Datetime | Time at which the credit note was created. | ||
| CreditnoteNumber | String | Number of a credit note. | ||
| CurrencyCode | String | Currency code of the customer's currency. | ||
| CurrencyId | String |
Currencies.CurrencyId | Currency Id of the customer's currency. | |
| CurrentSubStatus | String | Current sub status of a credit note. | ||
| CustomerId | String |
Contacts.ContactId | Id of the customer or vendor. | |
| CustomerName | String | Name of the customer or vendor. | ||
| Date | Date | Date of a credit note. | ||
| HasAttachment | Boolean | Check if the credit note has attachment. | ||
| ReferenceNumber | String | Reference number of credit note. | ||
| Status | String | Status of the credit note.
使用できる値は次のとおりです。open, closed, void | ||
| Total | Decimal | Total of credit notes. | ||
| AppliedInvoices | String | Invoices to which the credit note is applied. | ||
| ClientViewedTime | Datetime | Time when the credit note was viewed by the client. | ||
| CurrentSubStatusId | String | ID of the current sub-status of the credit note. | ||
| ExchangeRate | Decimal | Exchange rate for the credit note's currency. | ||
| IsViewedByClient | Boolean | Indicates if the credit note has been viewed by the client. | ||
| LastModifiedTime | Datetime | Time when the credit note was last modified. | ||
| PricePrecision | Integer | Price precision for the credit note. | ||
| SalespersonId | String | ID of the salesperson associated with the credit note. | ||
| SalespersonName | String | Name of the salesperson associated with the credit note. | ||
| TemplateId | String | ID of the template used for the credit note. | ||
| TemplateType | String | Type of the template used for the credit note. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| CreditNoteFilter | String | Filter credit notes by status.
使用できる値は次のとおりです。Status.All, Status.Open, Status.Draft, Status.Closed, Status.Void | |
| LineItemId | String | Id of a line item. | |
| TaxId | String | Id of a tax. | |
| ItemId | String | Id of an item. | |
| ItemName | String | Name of an item. | |
| ItemDescription | String | Description of an item. |