[SYSTEM21] Joining PCP62 and INP95

[Chris Payne <CPayne@xxxxxxxxxxxxxxx>]

Hello,
            I am trying to write a report to pull information out of a work
order. I need the part number, the shift, the movement quantity, and the
date. INP95 has all of these things except shift, with the date that I need
being stored in dtmv95. PCP62 has all of these things except the proper
date. So I have been trying to join PCP62 and INP95, but in order to do that
you need to use the time fields tmmv95 and reft62. When system21 updates
these files, it gets the system time, writes to INP95, gets the system time
AGAIN and writes to PCP62. So the times could be different. Has anyone else
gone after work order data, and if so what was your solution?
 
Thanks, 
Chris