Welcome, Guest. Please Login.
05/18/24 at 14:35:00
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › Payroll ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
termination date for crystal report (Read 1097 times)
deburr
Senior Member
****




Posts: 487
Gender: male
termination date for crystal report
12/02/08 at 13:38:38  
Anybody know what table and field contains the payroll termination date. I can't seem to find it in BKPRMSTR.
 
Thanks,
Steve
Back to top
 
 
Thanks,

Steve Cyr
Deburring House Inc.
EVOERP
Version 2018.2
PSQL 12

Email   IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 461
Gender: female
Re: termination date for crystal report
Reply #1 - 12/02/08 at 13:57:41  
In BKPRMSTR it is TERM  (BKPR_EMP_TERM)
Back to top
 
 
Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
deburr
Senior Member
****




Posts: 487
Gender: male
Re: termination date for crystal report
Reply #2 - 12/03/08 at 10:59:53  
That was what I first thought, but BKPR_EMP_TERM is a string type field with the Y or N for the terminated question. The date is somewhere else. Still looking.
Back to top
 
 
Thanks,

Steve Cyr
Deburring House Inc.
EVOERP
Version 2018.2
PSQL 12

Email   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: termination date for crystal report
Reply #3 - 12/03/08 at 16:43:05  
Table: BKPRINFO
Field: BKPR_INFO_DATE_1
 
Link BKPRMSTR.BKPR_EMP_NUM to BKPRINFO.BKPR_INFO_NUM
 
Records may not exist in BKPRINFO for all employees.  
You may need to use a left outer join in the link type.
Back to top
 
 
Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
deburr
Senior Member
****




Posts: 487
Gender: male
Re: termination date for crystal report
Reply #4 - 12/04/08 at 10:17:47  
Kevin
 
Thanks
Back to top
 
 
Thanks,

Steve Cyr
Deburring House Inc.
EVOERP
Version 2018.2
PSQL 12

Email   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › Payroll ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge