SSIS Components for Zoho CRM

Build 25.0.9434

Invoices

Stores customer invoice records including itemized charges, taxes, and payment tracking. Not available in free or standard accounts.

Table-Specific Information

Select

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

Insert


INSERT INTO Invoices (Status, DueDate, Subject, ProductDetails) VALUES ('Created', '2018/06/06', 'An invoice for the purchase of products XYZ.', '[
            { 
              "product": { 
                "Product_Code": "12342321", 
                "name": "Egg", 
                "id": "3276571000000184076" 
              }, 
              "quantity": 1024, 
              "Discount": 0, 
              "total_after_discount": 1239.04, 
              "net_total": 1239.04, 
              "book": null, 
              "Tax": 0, 
              "list_price": 1.21, 
              "unit_price": 1.21, 
              "quantity_in_stock": -1024, 
              "total": 1239.04, 
              "id": "3276571000000184104", 
              "product_description": null, 
              "line_tax": [] 
            } 
          ]')

Required fields: Subject, ProductDetails.

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

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

Unique identifier for the invoice record.

InvoiceOwner_Id String False

Identifier of the user who owns the invoice.

InvoiceOwner_FirstName String True

First name of the invoice owner.

InvoiceOwner_LastName String True

Last name of the invoice owner.

InvoiceOwner_Email String True

Email address of the invoice owner.

InvoiceOwner_Name String True

Full name of the invoice owner.

InvoiceNumber String True

Unique number assigned to the invoice.

Subject String False

Subject or title of the invoice.

SalesOrder_Id String False

Identifier of the sales order linked to the invoice.

SalesOrder_Name String True

Name or reference of the associated sales order.

InvoiceDate Date False

Date the invoice was issued.

PurchaseOrder String False

Purchase order number associated with the invoice.

DueDate Date False

Date by which the invoice payment is due.

ExciseDuty Decimal False

Excise duty amount applied to the invoice.

SalesCommission Decimal False

Sales commission associated with the invoice.

Status String False

Current status of the invoice, such as paid or overdue.

AccountName_Id String False

Identifier of the account associated with the invoice.

AccountName_Name String True

Name of the account associated with the invoice.

ContactName_Id String False

Identifier of the contact linked to the invoice.

ContactName_Name String True

Name of the contact associated with the invoice.

CreatedBy_Id String False

Identifier of the user who created the invoice record.

CreatedBy_FirstName String True

First name of the user who created the invoice.

CreatedBy_LastName String True

Last name of the user who created the invoice.

CreatedBy_Email String True

Email address of the user who created the invoice.

CreatedBy_Name String True

Full name of the user who created the invoice.

ModifiedBy_Id String False

Identifier of the user who last modified the invoice.

ModifiedBy_FirstName String True

First name of the user who last modified the invoice.

ModifiedBy_LastName String True

Last name of the user who last modified the invoice.

ModifiedBy_Email String True

Email address of the user who last modified the invoice.

ModifiedBy_Name String True

Full name of the user who last modified the invoice.

CreatedTime Datetime False

Timestamp indicating when the invoice was created.

ModifiedTime Datetime False

Timestamp indicating when the invoice was last modified.

Tag String False

Comma-separated list of tags associated with the invoice.

BillingStreet String False

Street address for billing.

ShippingStreet String False

Street address for shipping.

BillingCity String False

City listed in the billing address.

ShippingCity String False

City listed in the shipping address.

BillingState String False

State or region listed in the billing address.

ShippingState String False

State or region listed in the shipping address.

BillingCode String False

Postal or ZIP code listed in the billing address.

ShippingCode String False

Postal or ZIP code listed in the shipping address.

BillingCountry String False

Country listed in the billing address.

ShippingCountry String False

Country listed in the shipping address.

ProductDetails String False

Details of products or services listed in the invoice.

SubTotal Decimal True

Subtotal amount before applying taxes or discounts.

Discount Decimal False

Discount applied to the invoice.

Tax Decimal True

Total tax applied to the invoice.

Adjustment Decimal False

Any manual adjustments applied to the invoice amount.

GrandTotal Decimal True

Final total after taxes, discounts, and adjustments.

TermsandConditions String False

Terms and conditions associated with the invoice.

Description String False

Additional notes or description related to the invoice.

DealName_Id String False

Identifier of the deal associated with the invoice.

DealName_Name String True

Name of the deal linked to the invoice.

Locked Bool True

Indicates whether the invoice is locked from editing.

LastActivityTime Datetime False

Timestamp of the most recent activity related to the invoice.

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
DuplicateCheckFields String

Field or fields used to identify duplicate records during an upsert. Multiple fields are supported in the REST API, but only one is allowed in the BULK API.

Trigger String

Specifies whether to trigger automation or workflow rules when inserting the record.

CustomViewId Long

Identifier of the custom view used to filter this record. Applies only when the useCOQL parameter is set to false.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434