When timesheets post to WIP there are links back to the timesheet so you can validate the hours between the two.
The major components are
PPA_WIP.EXTERNALBATCHID = PRTIMESHEET.PRID
PPA_WIP.EXTTERNAL_ID = PRTIMEENTRY.PRID
PPA_WIP.EXTERNALTRANSNO = PPA_TRANSCONTROL.TRANSNO
Note: If a timesheet gets adjusted and hours are added to an existing row, WIP will show the new timesheetID to match to PPA_WIP.EXTERNALBATCHID however the time entries will point to the original timesheet timeentry table.
So here PPA_WIP.EXTTERNAL_ID = PRTIMEENTRY.PRID will be the timeentry lines from the original timesheet
PPA_WIP.EXTERNALBATCHID will be the new timesheet.
Release : 16.0.2
Component : Clarity Financial Management
Here are screenshots of the original timesheet
EXTERNALBATCH_ID = 5003004 which is the original timesheet.
EXTERNAL_ID are the related entries in PRTIMEENTRY table
Adjusted the timesheet and added 1 hour to each of these tasks:
EXTERNALBATCH_ID = 5006001 which is the adjustment timesheet
EXTERNAL_ID are the same (pointing to the original timesheet)
Entity Relationship Diagrams (ERD) - Go to the Transactions ERD