Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR30700
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Employee History
Physical Name: UPR30700
Technical Name: uprEmployeeHistorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID 
Employee ID String STR15_Employee_ID 15 2 CHANGEDATE_I Change Date Date DT 8 3 TIME1 Time Time TM6 6 4 STRTDATE Start Date Date DT 8 5 TERMINATIONDATE TerminationDate Date DT 8 6 BENADJDATE Ben Adj Date Date DT 8 7 LASTDAYWORKED_I Last Day Worked Date DT 8 8 DEMPINAC Date Employee Inactivated Date DT 8 9 CHANGEREASON_I Change Reason String STR30_I 30 10 Reason_for_Change Reason for Change String STR100 100 11 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Payroll Employee History'].NOTEINDX AS 'Payroll Employee History-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
UPR30700 AS ['Payroll Employee History']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Payroll Employee History'].NOTEINDX = ['Record Notes Master'].NOTEINDX