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 IDCUNO as "Cust Code", IDINVN as "Invoice", IAINUM as "Request", IDORNO as "Order", IHOREF as "PO"
	 from HD3800EFPN/SXBISD
		 inner join HD3800EFPN/SXBHNA
			 on IDORNO = IANRNO
		 inner join HD3800EFPN/SXBISH
			 on IDORNO = IHORNO
	 where SXBISD.IDPLNO = '' or SXBISD.IDORNO = '' or SXBISD.IDINVN = '' or SXBISH.IHOREF Like '%%' or SXBHNA.IAINUM = ''