SELECT O.documenttextID, OP.final_price,OP.products_quantity,OP.lineAmount,OP.tktMisc [Loose Qty],op.tktSPPercentage [Loose Rate], FSTPO.Sremarks,[RR].locationDetail [DIS DRUM],RR.ordersid,[FSTPO].fileNo,RRPO.locationDetail [PODRUM],DHPO.qty as [PODHqty],P.products_model,FSTO.sRemarks AS DISPATCHBATCHNO,O.date_purchased, DA [REF FST],FSTO.doctypeId,FSTO.filenO,OP.products_id FROM ORDERS [O]LEFT JOIN orders_products [OP] ON O.orders_id = OP.orders_idLEFT JOIN CL_METRO_FST.DBO.ORDERS AS [FSTO] ON FSTO.orders_id = ISNULL(DA,0)LEFT JOIN CL_METRO_FST.DBO.DISPENSEHISTORY [DH] ON DH.batchNo = FSTO.sRemarksLEFT JOIN CL_METRO_FST.DBO.REgisterRFID [RR] ON RR.RFID = DH.RFIDLEFT JOIN CL_METRO_FST.DBO.ORDERS AS [FSTPO] ON […]
Category: Discussion / In Progress
Franscent Meeting 4th Nov 2022
currency kay sath header mien exchange rate bhi add hoga in grid : fcrate ki file d add hogi js mien agar koi value ho tu x exrate say muptiple hokar current rate kay column ajaiey gi baqi theak hay Point 1 & 2: Point 3: Point 4: Point 5: Point 6: azkar