InvoicesBillCredited
Get bills credited related to invoices
Table-Specific Information
Select
The add-in uses the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- InvoiceId supports the '=' comparison.
- CreditNoteId supports the '=' comparison.
- CreditNotesInvoiceId supports the '=' comparison.
For example, the following queries are processed server-side:
SELECT * FROM InvoicesBillCredited WHERE InvoiceId = '3350895000000089001'
Insert
To insert into this table, specify the InvoiceId and ApplyCreditNotes columns. Non-read-only columns can be inserted optionally. For example:
INSERT INTO InvoicesBillCredited(InvoiceId,ApplyCreditNotes) VALUES (3782369000000100118,'[{"creditnote_id":3782369000000100206,"amount_applied":2}]');
Delete
To delete from this table, specify the CreditNotesInvoiceId and InvoiceId in the WHERE clause. For example:
DELETE FROM InvoicesBillCredited WHERE CreditNotesInvoiceId = '3782369000000110015' AND InvoiceId = '3782369000000100118';
Columns
| Name | Type | ReadOnly | References | Description |
| AmountApplied | Double | True |
Amount Applied | |
| CreditedDate | Date | True |
Credited Date | |
| CreditNoteId | Long | True |
CreditNotes.Id |
Credit Note Id |
| InvoiceId [KEY] | Long | False |
Invoices.Id |
Invoice Id |
| CreditNotesInvoiceId [KEY] | String | True |
CreditNotes Invoice Id | |
| CreditNotesNumber | String | True |
CreditNotes Number |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| InvoicePayments | String |
Invoice payment list. This contains payment_id and amount_applied. |
| ApplyCreditNotes | String |
Apply existing credit note of a customer against the invoice. This contains creditnote_id and amount_applied. |