Sample Screen Images
MySql
select accdate,acctime,stastatn,empfirst,emplast,accddd,accraw,accmajor,accnpa,accnnx,vhccity,vhcprov,accintky,
intdesc, accimin,accomin,acccalls,accsecs,accinc$$,accitax$,accout$$,ptdfactr,accotax$,acc40001,accref from tmsacc
join (tmssta,tmsptd,dat9.tmsvhc,dat9.tmsint,tmsemp) on
(tmsacc.accstatn = tmssta.stastatn and accperid = ptdperid and ( accimin = ptdminor or accomin = ptdminor )
and (accnpa = dat9.tmsvhc.vhcnpa and accnnx = dat9.tmsvhc.vhcnnx and accintky = dat9.tmsint.intcount ) and accemplo = empemplo
Circut Table Extract
Employee Table Extract
Accounting Table
|