Kbase Home‎ > ‎Payroll‎ > ‎

SQL query to retrieve direct deposit information

This query retrieves the current (active) direct deposit information in Dynamics GP (for active employees only).

select top 100 percent DD00200.EMPLOYID, LASTNAME, FRSTNAME, DD00200.INACTIVE, DEDUCTON, DDAMTDLR, DDPCT, DDACTNUM, DDTRANUM
from DD00200 inner join UPR00100 on DD00200.EMPLOYID = UPR00100.EMPLOYID
where UPR00100.INACTIVE = 0 and DD00200.INACTIVE=0
order by LASTNAME, FRSTNAME

Comments