Payroll Employee History (UPR30700)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Employee History (UPR30700)

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: uprEmployeeHistory

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2CHANGEDATE_I SearchChange DateDateDT8
3TIME1 SearchTimeTimeTM66
4STRTDATE SearchStart DateDateDT8
5TERMINATIONDATE SearchTerminationDateDateDT8
6BENADJDATE SearchBen Adj DateDateDT8
7LASTDAYWORKED_I SearchLast Day WorkedDateDT8
8DEMPINAC SearchDate Employee InactivatedDateDT8
9CHANGEREASON_I SearchChange ReasonStringSTR30_I30
10Reason_for_Change SearchReason for ChangeStringSTR100100
11NOTEINDX SearchNote IndexCurrencyDLR1414
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
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Employee History (UPR30700)

Leave a Reply

Your email address will not be published. Required fields are marked *