Purchase Request details

Purchase Request details




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 "Shipping_details",
       pr.Comments "Comments",
       cri.FIRST_NAME "Created By",
       aau.FIRST_NAME "Requester",
       ti.FIRST_NAME "Technician",
       pd.PRIORITYNAME "Priority",
       std.statusname "Status",
       pxt.QUANTITYORDERED "Quantity of Items",
       cd.COMPONENTNAME "Product" FROM purchaserequest pr
LEFT JOIN SDUser sdu ON pr.Requestedby=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN SDUser crd ON pr.Createdby=crd.USERID
LEFT JOIN AaaUser cri ON crd.USERID=cri.USER_ID
LEFT JOIN SDUser td ON pr.Technicianid=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN PriorityDefinition pd ON pr.PRIORITYID=pd.PRIORITYID
LEFT JOIN POStatus std ON pr.statusid=std.statusid
LEFT JOIN PRPOAssociation prpo ON pr.requestid=prpo.requestid
LEFT JOIN Purchaseorderext pxt ON prpo.PURCHASEORDERID=pxt.PURCHASEORDERID
LEFT JOIN ComponentDefinition cd ON pxt.COMPONENTID=cd.COMPONENTID



      New to ADSelfService Plus?

        Resources

            • 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 ...
            • Requester details

              This report is used to find the Requester complete details.  SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...