----------------------PURCHASEORDER ---PurchaseOrderId   --PartyAccountmAsterId

----------------------PURCHASEORDERDETAILS-------1,2

--------------------ITEMMASTER--------------ItemMasterId  2,3

---------------------COMPANYMASTER----------CompanyMasterId  1,4

----------------------CATEGORYMASTER--------CategorymasterId 1,5

-----------------------ACCOUNTMASTER------AccountMasterId 1,6  link

-----------------------DIVISIONMASTER---DivisionMasterId 1,7

 

--OUTPUT--

-----DOCUMENTNO,DOCUMENTDATE,ACCOUNTNAME,ITEMNAME,QUANTITY,RATE,ITEMAMOUNT,CATEGORYNAME,DIVISIONNAME

 

---SALESORDER ( Se union marna hai)

---GROUP BY karna hai

---ITEMAMOUNT>5000

---VIEW (View banana hai query ka)

---Having condition use karna hai

---RETREIVE

---Create the stored procedure for same query and put the parameter from date and to date