GET PST/GetMaterialBasedOnBatch/{matId}/{storeId}

Request Information

URI Parameters

Name	Description	Type	Additional information
matId		integer	Required
storeId		integer	Required

Body Parameters

None.

Response Information

Resource Description

Collection of INV_MATERIAL_STOCK

Name	Type	Additional information
MATERIAL_STOCK_ID	integer	None.
FINANCIALYEAR_ID	integer	None.
STORE_ID	integer	None.
MATERIAL_ID	integer	None.
BATCH_NO	string	None.
EXP_DATE	date	None.
QOH	integer	None.
PURCHASE_RATE	decimal number	None.
STOCKTAKING_DIFFERENCE	integer	None.
SALE_QUANTITY	integer	None.
PURCHASE_QUANTITY	integer	None.
CREATED_BY	integer	None.
CREATED_DATE	date	None.
MODIFIED_BY	integer	None.
MODIFIED_DATE	date	None.
BARCODE_NUMBER	string	None.
TRANSFER_FLAG	string	None.
MRP_PRICE	decimal number	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "MATERIAL_STOCK_ID": 1,
    "FINANCIALYEAR_ID": 1,
    "STORE_ID": 1,
    "MATERIAL_ID": 1,
    "BATCH_NO": "sample string 2",
    "EXP_DATE": "2025-12-17T17:16:46.4217272+05:30",
    "QOH": 1,
    "PURCHASE_RATE": 1.0,
    "STOCKTAKING_DIFFERENCE": 1,
    "SALE_QUANTITY": 1,
    "PURCHASE_QUANTITY": 1,
    "CREATED_BY": 1,
    "CREATED_DATE": "2025-12-17T17:16:46.422729+05:30",
    "MODIFIED_BY": 1,
    "MODIFIED_DATE": "2025-12-17T17:16:46.422729+05:30",
    "BARCODE_NUMBER": "sample string 3",
    "TRANSFER_FLAG": "sample string 4",
    "MRP_PRICE": 1.0
  },
  {
    "MATERIAL_STOCK_ID": 1,
    "FINANCIALYEAR_ID": 1,
    "STORE_ID": 1,
    "MATERIAL_ID": 1,
    "BATCH_NO": "sample string 2",
    "EXP_DATE": "2025-12-17T17:16:46.4217272+05:30",
    "QOH": 1,
    "PURCHASE_RATE": 1.0,
    "STOCKTAKING_DIFFERENCE": 1,
    "SALE_QUANTITY": 1,
    "PURCHASE_QUANTITY": 1,
    "CREATED_BY": 1,
    "CREATED_DATE": "2025-12-17T17:16:46.422729+05:30",
    "MODIFIED_BY": 1,
    "MODIFIED_DATE": "2025-12-17T17:16:46.422729+05:30",
    "BARCODE_NUMBER": "sample string 3",
    "TRANSFER_FLAG": "sample string 4",
    "MRP_PRICE": 1.0
  }
]

text/html

Sample:

[{"MATERIAL_STOCK_ID":1,"FINANCIALYEAR_ID":1,"STORE_ID":1,"MATERIAL_ID":1,"BATCH_NO":"sample string 2","EXP_DATE":"2025-12-17T17:16:46.4217272+05:30","QOH":1,"PURCHASE_RATE":1.0,"STOCKTAKING_DIFFERENCE":1,"SALE_QUANTITY":1,"PURCHASE_QUANTITY":1,"CREATED_BY":1,"CREATED_DATE":"2025-12-17T17:16:46.422729+05:30","MODIFIED_BY":1,"MODIFIED_DATE":"2025-12-17T17:16:46.422729+05:30","BARCODE_NUMBER":"sample string 3","TRANSFER_FLAG":"sample string 4","MRP_PRICE":1.0},{"MATERIAL_STOCK_ID":1,"FINANCIALYEAR_ID":1,"STORE_ID":1,"MATERIAL_ID":1,"BATCH_NO":"sample string 2","EXP_DATE":"2025-12-17T17:16:46.4217272+05:30","QOH":1,"PURCHASE_RATE":1.0,"STOCKTAKING_DIFFERENCE":1,"SALE_QUANTITY":1,"PURCHASE_QUANTITY":1,"CREATED_BY":1,"CREATED_DATE":"2025-12-17T17:16:46.422729+05:30","MODIFIED_BY":1,"MODIFIED_DATE":"2025-12-17T17:16:46.422729+05:30","BARCODE_NUMBER":"sample string 3","TRANSFER_FLAG":"sample string 4","MRP_PRICE":1.0}]

application/xml, text/xml

Sample:

<ArrayOfINV_MATERIAL_STOCK xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Tm.WebAPI.Models">
  <INV_MATERIAL_STOCK>
    <BARCODE_NUMBER>sample string 3</BARCODE_NUMBER>
    <BATCH_NO>sample string 2</BATCH_NO>
    <CREATED_BY>1</CREATED_BY>
    <CREATED_DATE>2025-12-17T17:16:46.422729+05:30</CREATED_DATE>
    <EXP_DATE>2025-12-17T17:16:46.4217272+05:30</EXP_DATE>
    <FINANCIALYEAR_ID>1</FINANCIALYEAR_ID>
    <MATERIAL_ID>1</MATERIAL_ID>
    <MATERIAL_STOCK_ID>1</MATERIAL_STOCK_ID>
    <MODIFIED_BY>1</MODIFIED_BY>
    <MODIFIED_DATE>2025-12-17T17:16:46.422729+05:30</MODIFIED_DATE>
    <MRP_PRICE>1</MRP_PRICE>
    <PURCHASE_QUANTITY>1</PURCHASE_QUANTITY>
    <PURCHASE_RATE>1</PURCHASE_RATE>
    <QOH>1</QOH>
    <SALE_QUANTITY>1</SALE_QUANTITY>
    <STOCKTAKING_DIFFERENCE>1</STOCKTAKING_DIFFERENCE>
    <STORE_ID>1</STORE_ID>
    <TRANSFER_FLAG>sample string 4</TRANSFER_FLAG>
  </INV_MATERIAL_STOCK>
  <INV_MATERIAL_STOCK>
    <BARCODE_NUMBER>sample string 3</BARCODE_NUMBER>
    <BATCH_NO>sample string 2</BATCH_NO>
    <CREATED_BY>1</CREATED_BY>
    <CREATED_DATE>2025-12-17T17:16:46.422729+05:30</CREATED_DATE>
    <EXP_DATE>2025-12-17T17:16:46.4217272+05:30</EXP_DATE>
    <FINANCIALYEAR_ID>1</FINANCIALYEAR_ID>
    <MATERIAL_ID>1</MATERIAL_ID>
    <MATERIAL_STOCK_ID>1</MATERIAL_STOCK_ID>
    <MODIFIED_BY>1</MODIFIED_BY>
    <MODIFIED_DATE>2025-12-17T17:16:46.422729+05:30</MODIFIED_DATE>
    <MRP_PRICE>1</MRP_PRICE>
    <PURCHASE_QUANTITY>1</PURCHASE_QUANTITY>
    <PURCHASE_RATE>1</PURCHASE_RATE>
    <QOH>1</QOH>
    <SALE_QUANTITY>1</SALE_QUANTITY>
    <STOCKTAKING_DIFFERENCE>1</STOCKTAKING_DIFFERENCE>
    <STORE_ID>1</STORE_ID>
    <TRANSFER_FLAG>sample string 4</TRANSFER_FLAG>
  </INV_MATERIAL_STOCK>
</ArrayOfINV_MATERIAL_STOCK>