IPTOR SQL

Search for SKU with UPC

select PJPRDC, PJUNIT, PJEANP, PGDESC, LPLCID, SRSTHQ
	 from HD3800EFPN/SROEAN
		 inner join HD3800EFPN/SROPRG
			 on PJPRDC = PGPRDC
		 inner join HD3800EFPN/WHOLOP
			 on PJPRDC = LPPRDC
		 inner join HD3800EFPN/SROSRO
			 on PJPRDC = srprdc
	 where PJUNIT = 'EA' and SROEAN.PJEANP Like '%%'

Search for SKU with SKU

select PJPRDC, PJUNIT, PJEANP, PGDESC, LPLCID, SRSTHQ
	 from HD3800EFPN/SROEAN
		 inner join HD3800EFPN/SROPRG
			 on PJPRDC = PGPRDC
		 inner join HD3800EFPN/WHOLOP
			 on PJPRDC = LPPRDC
		 inner join HD3800EFPN/SROSRO
			 on PJPRDC = srprdc
	 where SROEAN.PJUNIT = 'EA' and SROEAN.PJPRDC = ''

Customer Route

select ADNUM, ADNAME, ADDEST
	 from HD3800EFPN/SRONAD 
	 where ADAD01 = 'Y' and ADDEST <> ' ' and SRONAD.ADNUM Like '%%'

List Customers + Account Group

select NONUM, NANAME, NOAGRP, CTAGRD
	 from HD3800EFPN/SRONOI
		 inner join HD3800EFPN/SR15NAM
			 on NONUM = NANUM
	   	inner join HD3800EFPN/SRBCTLDG
	   		on NOAGRP = CTAGRN
	 where (SRONOI.NOAGRP Like '%C%')

Count Sheets

select LPLCID as "Location", LPPRDC as "SKU", PGDESC as "SKU Description", PGDSUN as "Unit", SRSTHQ as "On Hand", SRCUSQ + SRPICQ as "Reserved", '_______________' as "Count"
	 from HD3800EFPN/WHOLOP
		 inner join HD3800EFPN/SROPRG
			 on LPPRDC = PGPRDC
		 inner join HD3800EFPN/SROSRO
			 on LPPRDC = srprdc
	 where WHOLOP.LPLCID Like 'X%'
	 order by LPLCID

Find Credits

select IHCUNO as "Customer", IHORNO as "Order", IDINVN as "Invoice", IHINRL as "Reference", IAINUM as "Request", IHOREF as "PO"
	 from HD3800EFPN/SXBISH
		 left outer join HD3800EFPN/SXBHNA
			 on IHORNO = IANRNO
		join HD3800EFPN/SXBISD
              on IDORNO = IHORNO
	 where SXBISH.IHCUNO Like '%%' or SXBISH.IHORNO = '' or SXBHNA.IAINUM = '' or SXBISH.IHOREF Like '%%' or SXBISH.IHINVN = '' or SXBISH.IHINRL = ''
	 group by IHORNO, IDINVN, IHCUNO, IHINRL, IHOREF, IAINUM

Find Stuff

select IHCUNO as "Customer", IHORNO as "Order", IDPLNO as "Picking", IDINVN as "Invoice", IHOREF as "PO"
	 from HD3800EFPN/SXBISH
		 left outer join HD3800EFPN/SXBHNA
			 on IHORNO = IANRNO
		 inner join HD3800EFPN/SXBISD
			 on IDORNO = IHORNO
	 where SXBISH.IHCUNO Like '%%' or SXBISH.IHORNO = '' or SXBISD.IDPLNO = '' or SXBISH.IHINVN = '' or SXBISH.IHOREF Like '%%'
	 group by IHORNO, IHCUNO, IHOREF, IDPLNO, IDINVN