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.
I need a method to download PO date by the ISSUE DATE date range in spreadsheet form. I need at least the following dat
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am