I need a method to download PO date by the ISSUE DATE date range in spreadsheet form. I need at least the following dat

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

I need a method to download PO date by the ISSUE DATE date range in spreadsheet form. I need at least the following dat

Post by answerhappygod »

I need a method to download PO date by the ISSUE DATE date rangein spreadsheet form. I need at least the following datareturned for each PO:
CCCTFab Delivery DaysFreightIssue DateJob IDJob NameNum LinesOU IDPO#PO SubtotalPO TotalProject Manager Emp IDProject Manager NamePurchasing Agent Emp IDPurchasing Agent NameRequester Emp IDRequester NameTaxVendor IDVendor NameWarehouse IDWO IDWO Name
You will need to join multiple tables to pull in all thedata.
po_mstr: select cc, cost_type_cd, issue_date,fab_delivery_days, freight_term_cd, job_id, ou_id, num_1, num_2,num_3, Num_4, Num_5, Num_6, purch_agent_emp_id, requester_emp_id,whse_id, ven_id from po_mstrpo_dtl: select cc, cost_type_cd, job_id, ou_id,num_1, num_2, num_3, Num_4, Num_5, Num_6, po_num, po_rcpt_calc_amt,po_rcpt_calc_units, ven_prod_idfrom po_dtl;employee: select emp_id,first_name,last_name,emp_user_id,emp_stat_cd,full_part_time_cd,ou_id,ven_idfrom employeewhere emp_stat_cd = 'A' andfull_part_time_cd ='F'vendor: select freight_term_cd, emp_id, name,ven_id from vendorjob : select cc, cost_type_cd,freight_term_cd, job_date, job_id, name, num_1, num_2, num_3,Num_4, Num_5, Num_6, ou_id, pmgr_emp_id, tax_certificate fromjob
There will be multiple joins to the employee table to get thenames. Will probably want to use Common Table Expressions,the WITH clause, to get those in nicely.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply