Bills

Read, Insert, Update and Delete Bills.

Table Specific Information

Select

The connector will use 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 connector.

Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Bills WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the VendorId, BillNumber, Date, DueDate and LineItems column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Bills (VendorId, BillNumber, Date, DueDate, LineItems) VALUES (3249056000000160028, 33, '2022-06-30', '2022-07-30', '[{\"name\": \"Chips\",\"warehouse_id\": 3249056000000138013,\"account_id\": 3249056000000000388, \"account_name\": \"Inventory Asset\", \"rate\": 900,\"quantity\": 2,\"reverse_charge_tax_id\":3249056000000158097 }]')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Bills SET VendorId = '3249056000000160028', BillNumber = '77', Date = '2022-06-30', DueDate = '2022-06-30', LineItems = '[{\"name\": \"Machines\",\"warehouse_id\": 3249056000000138013,\"account_id\": 3249056000000000388, \"account_name\": \"Inventory Asset\", \"rate\": 50000,\"quantity\": 2,\"reverse_charge_tax_id\":3249056000000158097 }]' WHERE Id = 3249056000000195059

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM Bills WHERE Id = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Unique ID generated by the server.
AttachmentName	String	True		Name of the attached file.
Balance	Integer	True		Remaining balance of the Bill.
Status	String	False		Status of the Bill.
BillNumber	String	False		Bill number of Purchase Order.
CreatedTime	Datetime	True		Time at which the Bill details were last created..
CurrencyCode	String	True		Currency code.
CurrencyId	Long	False		Unique ID generated by the server for the currency.
CurrencySymbol	String	True		The symbol for the selected currency.
Documents	String	False		Documents attached to bill.
Date	Date	False		Date of the Bill.
DueByDays	Integer	True		Number of days by which the Bill is due.
DueDate	Date	False		Due date for the Bill.
DueDays	String	True		Number of days by which the Bill is due.
EntityType	String	True		Entity Type.
ExchangeRate	Integer	False		Exchange rate of the currency, with respect to the base currency.
HasAttachment	Boolean	True		Checks whether the bill has attachment or not.
IsItemLevelTaxCalc	Boolean	False		Checks whether item level tax is calculated or not.
LastModifiedTime	Datetime	True		Time at which the bill details were last Modified.
LineItems	String	False		The line items for a Bill.
Notes	String	False		Notes for the Bill.
OpenPurchaseordersCount	Integer	True		Number of Purchase Orders that are associated with this Bill and open.
Payments	String	True		Payment details for the Bill.
PricePrecision	Integer	True		The precision level for the price decimal point in a Bill.
PurchaseorderId	Long	False		Unique ID generated by the server for the Purchase Order.
ReferenceId	Long	True		Unique ID generated by the server for the reference.
ReferenceNumber	String	False		Reference number for the Bill.
SubTotal	Integer	True		Sub Total of the Bill.
TaxTotal	Integer	True		The total of the Tax.
Taxes	String	True		Number of taxes applied on the Purchase Order.
Terms	String	False		Terms and conditions..
UnusedCreditsPayableAmount	Integer	True		Unused credit payable amount.
VendorCredits	String	True		The available Vendor Credits.
VendorCreditsApplied	Integer	True		Vendor credits applied to the Bill.
VendorId	Long	False		Unique ID generated by the server for the vendor.
VendorName	String	True		Name of the vendor.
BillingAddressAddress	String	False		Name of the street of the customers billing address.
BillingAddressCity	String	False		Name of the city of the customers billing address.
BillingAddressCountry	String	False		Name of the country of the customers billing address.
BillingAddressFax	String	False		Fax number of the customers billing address.
BillingAddressState	String	False		Name of the state of the customer billing address.