SalesReturns

Read, Insert, Update and Delete Sales Returns.

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.
SalesorderId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM SalesReturns WHERE Id = '3350895000000089001'

SELECT * FROM SalesReturns WHERE SalesorderId = '3350895000000089001'

Insert

Insert can be executed by specifying the Name,email and UserRole 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 SalesReturns (LineItems) VALUES ('[{\"item_id\":\"3285934000000104036\",\"salesorder_item_id\":\"3285934000000113099\", \"quantity\":1,\"non_receive_quantity\":\"0\",\"warehouse_id\":\"3285934000000113095\"}]')

Update

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

UPDATE SalesReturns SET Reason = 'unspecified' AND LineItems = [{\"item_id\":\"3285934000000104036\",\"salesorder_item_id\":\"3285934000000113099\", \"quantity\":1,\"non_receive_quantity\":\"0\",\"warehouse_id\":\"3285934000000113095\"}] WHERE Id = '3285934000000136008'

Delete

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

DELETE FROM SalesReturns WHERE Id = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Unique ID generated by the server for the Sales Return.
CustomerId	Long	True		Customer ID of the customer involved in the payment.
CustomerName	String	True		Name of the customer to whom the invoice is raised.
Date	Date	False		Date on which payment is made.
Quantity	Integer	True		The quantity that can be received for the line item.
ReceiveStatus	String	True		Status whether received or not
RefundStatus	String	True		Status of refund
Reason	String	False		The reason for raising a Sales Return.
RefundedAmount	Integer	True		Amount refunded
SalesorderId	Long	True		Unique ID generated by the server for the Sales Order from which the Sales Return is created.
SalesorderNumber	String	True		Unique sales order number for each sales order.
SalesreturnNumber	String	False		Return Merchandise Authorisation (RMA) number of the Sales Return.
SalesreturnStatus	String	True		Return Merchandise Authorisation (RMA) status of the Sales Return.
LineItems	String	False		The underlying items in a Sales Return
Comments	String	False		History related to the Sales Return.
SalesReturnReceives	String	False		Sales receive of Sales Return.
CreditNotes	String	False		Credit notes of Sales Return.