InventoryAdjustments
Read, Insert and Delete Inventory Adjustments.
Table Specific Information
Select
The 本製品 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 本製品.
- Id supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM InventoryAdjustments WHERE Id = '3350895000000089001'
Insert
Insert can be executed by specifying the Date, Reason, AdjustmentType 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 InventoryAdjustments (Date, Reason, AdjustmentType, LineItems) VALUES ('2022-06-22', 'Damaged Goods 11', 'quantity', '[ {\"item_id\": 3285934000000104097,\"quantity_adjusted\":10 }]')
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 InventoryAdjustments SET Reason = 'poor quality' WHERE Id = '3350895000000090009'
Delete
Delete can be executed by specifying the Id in the WHERE Clause
For example:
DELETE FROM InventoryAdjustments WHERE Id = '3350895000000089001'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Unique ID generated by the server for the item adjustment. | |
AdjustmentType | String | False |
The adjustment type should be either quantity or value.Allowed values are quantity and value only. | |
Date | Date | False |
The date for the Item Adjustment. | |
Description | String | False |
Sample Description. | |
Reason | String | False |
The reason for the Item Adjustment. | |
ReasonId | Long | True |
Unique ID generated by the server for the reason. | |
ReferenceNumber | String | False |
Reference number of the Item Adjustment. | |
Total | Integer | True |
Total value of the Item Adjustment. | |
LineItems | String | False |
An item adjustment can contain multiple line items. |