Bills
Read, Insert, Update and Delete Bills.
Table Specific Information
Select
The driver 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 driver.
- 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. |