Purchase Request details

Purchase Request details

Select pr.REQUESTID AS "Request Id", pr.SUBJECT AS "PR Subject", pr.DESCRIPTION AS "Description", LONGTODATE(pr.REQUESTEDDATE) AS "Requested Date", LONGTODATE(pr.DATEREQUIRED) AS "Date Required", LONGTODATE(pr.CREATEDDATE) AS "Created Date", pr.SHIPPING_DETAILS AS "Shipping Details", au.FIRST_NAME AS "Created By", req_au.FIRST_NAME AS "Requested By", tec_au.FIRST_NAME AS "Technician", prp.NAME AS "Priority", pos.STATUSNAME AS "Status", pri.ITEMNAME AS "Product", pri.QUANTITY AS "Quantity Of Items" FROM PurchaseRequest pr LEFT JOIN SDUser sdu ON pr.CREATEDBY = sdu.USERID LEFT JOIN AAAUser au ON sdu.USERID = au.USER_ID LEFT JOIN SDUser req_sdu ON pr.REQUESTEDBY = req_sdu.USERID LEFT JOIN AAAUser req_au ON req_sdu.USERID = req_au.USER_ID LEFT JOIN SDUser tec_sdu ON pr.TECHNICIANID = tec_sdu.USERID LEFT JOIN AAAUser tec_au ON req_sdu.USERID = tec_au.USER_ID LEFT JOIN PRPriority prp ON pr.PRIORITYID = prp.PRIORITYID LEFT JOIN POStatus pos ON pr.STATUSID = pos.STATUSID LEFT JOIN PRRequestedItems pri ON pr.REQUESTID = pri.REQUESTID

                    New to ADSelfService Plus?

                      • Related Articles

                      • Purchase details

                        SELECT po.POCUSTOMID "PO Number", max(po.PONAME) "PO Name", max(po.TERMS) "PO Terms", LONGTODATE(max(po.DATEORDERED)) "Ordered Date", max(pos.STATUSNAME) "PO Status", max(poa.FIRST_NAME) "Purchase Requester", max(po.SHIPTO) "Ship To", max(paao.NAME) ...
                      • Purchase Request Approval

                        SELECT pr.Requestid "Requestid", pr.Subject "Subject", pr.Description "Description", longtodate(pr.Requesteddate) "Requesteddate", longtodate(pr.Daterequired) "Daterequired", longtodate(pr.createddate) "createddate", pr.Shipping_details ...
                      • Purchase order approval details

                        SELECT po.POCUSTOMID AS "PO Number", max(po.PONAME) AS "PO Name", max(poa.FIRST_NAME) AS "Purchase Requester", longtodate(max(po.DATEORDERED)) AS "Ordered Date", longtodate(max(po.DATEREQUIRED)) AS "Required Date", max(pos.STATUSNAME) AS "PO Status", ...
                      • How to populate request details on associated tasks.

                        This sample script is used to update request field values into tasks associated with request templates The Request details are stored as a JSON Object in a file and its path is provided as input to the Script. This can be used in the application ...
                      • Request Approval Details

                        This report is used to view the historical details of Approved and Denied approval processes and their individual steps. We can also use this report to display all details for which an approval decision is pending. To make any changes to a query, ...