Invoices

Stores invoice records (such as billing address, totals, payment status, and line items) available only in paid Zoho CRM editions.

Table-Specific Information

Select

This table supports the COQL and BULK APIs for filtering, meaning that most filters comparing columns to values are submitted server-side.

Insert

INSERT INTO Invoices (Subject, AccountName_Id, InvoicedItems) VALUES ('bulk2', '1021046000000427106', '[
  {
    "Product_Name": {
      "id": "1021046000000414457"
    },
    "Quantity": 1024,
    "Discount": 12,
    "Price_Book_Name": {
      "id": "1"
    },
    "Tax": 0,
    "List_Price": 1.21,
    "Description": "test desc"
  }
]');

Required fields for REST API: Subject, InvoicedItems.

Required fields for BULK API: Subject, InvoicedItems, AccountName_Id.

Any field which is not read-only (ReadOnly = false in the table below) can be inserted.

Please note that the REST API honors only the 'id' field of the 'Product_Name' aggregate in the InvoicedItems column. The BULK API does not accept any other field in this aggregate.

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM Invoices WHERE Id = '3152079000000153079'

Update

You must specify the Id in the WHERE clause when executing an update against this table.

UPDATE Invoices SET Description = 'Updated from API' WHERE Id = '3152079000000153079'

Required fields: Id.

Any field which is not read-only (ReadOnly = false in the table below) can be updated.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	The unique identifier for the invoice.
Billing_Latitude	Double	False	Latitude coordinate of the invoice's billing address.
Billing_Longitude	Double	False	Longitude coordinate of the invoice's billing address.
Shipping_Latitude	Double	False	Latitude coordinate of the invoice's shipping address.
Shipping_Longitude	Double	False	Longitude coordinate of the invoice's shipping address.
Owner_Id	String	False	The unique identifier of the user who owns the invoice.
Owner_FirstName	String	True	The first name of the invoice owner.
Owner_LastName	String	True	The last name of the invoice owner.
Owner_Email	String	True	The email address of the invoice owner.
Invoice_Number	String	True	The reference number assigned to the invoice.
Subject	String	False	The subject or title of the invoice.
Sales_Order_Id	String	False	The unique identifier of the related sales order.
Invoice_Date	Date	False	The date when the invoice was issued.
Purchase_Order	String	False	The associated purchase order reference.
Due_Date	Date	False	The date by which the invoice payment is due.
Excise_Duty	Decimal	False	The excise duty amount applicable to the invoice.
Sales_Commission	Decimal	False	The sales commission amount related to the invoice.
Status	String	False	The current status of the invoice.
Account_Name_Id	String	False	The unique identifier of the associated account.
Contact_Name_Id	String	False	The unique identifier of the contact associated with the invoice.
Created_By_Id	String	False	The unique identifier of the user who created the invoice.
Modified_By_Id	String	False	The unique identifier of the user who last modified the invoice.
Modified_By_FirstName	String	True	The first name of the user who last modified the invoice.
Modified_By_LastName	String	True	The last name of the user who last modified the invoice.
Modified_By_Email	String	True	The email address of the user who last modified the invoice.
Created_Time	Datetime	False	The date and time when the invoice was created.
Modified_Time	Datetime	False	The date and time when the invoice was last modified.
Tag	String	False	Any tags associated with the invoice.
Sub_Total	String	True	The subtotal amount before discount and tax.
Discount	Decimal	False	The discount amount applied to the invoice.
Tax	Decimal	False	The tax amount applied to the invoice.
Adjustment	Decimal	False	Any manual adjustment to the total invoice amount.
Grand_Total	String	True	The final amount after applying discount, tax, and adjustments.
Terms_and_Conditions	String	False	The terms and conditions applicable to the invoice.
Description	String	False	Additional details or description for the invoice.
Id_CustomModule	Long	True	The record identifier used internally.
Deal_Name__s_Id	String	False	The unique identifier of the related deal.
Locked__s	Bool	True	Indicates whether the invoice is locked for editing.
Last_Activity_Time	Datetime	False	The date and time of the last activity related to the invoice.
Billing_Country	String	False	The billing country for the invoice.
Billing_Flat_House_No_Building_Apartment_Name	String	False	Flat/house number, building, or apartment name portion of the billing address.
Billing_Street	String	False	The billing street address for the invoice.
Billing_City	String	False	The billing city for the invoice.
Billing_State	String	False	The billing state for the invoice.
Billing_Code	String	False	The billing postal code for the invoice.
Shipping_Country	String	False	The shipping country for the invoice.
Shipping_Flat_House_No_Building_Apartment_Name	String	False	Flat/house number, building, or apartment name portion of the shipping address.
Shipping_Street	String	False	The shipping street address for the invoice.
Shipping_City	String	False	The shipping city for the invoice.
Shipping_State	String	False	The shipping state for the invoice.
Shipping_Code	String	False	The shipping postal code for the invoice.

Pseudo-Columns

Pseudo column 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
Invoiced_Items	String	The list of items included in the invoice.
DuplicateCheckFields	String	The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field.
Trigger	String	To trigger the rule while inserting record into CRM account.

ADO.NET Provider for Zoho CRM