Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR50000
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: UPR_EmployeeList_View
Physical Name: UPR50000
Technical Name: UPR_EmployeeList_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID 
Employee ID String STR15_Employee_ID 15 2 LASTNAME Last Name String STR20 20 3 FRSTNAME First Name String STR15 15 4 DEPRTMNT Department String STR6_Payroll_Code 6 5 INACTIVE Inactive Boolean CB_Inactive 0 6 EMPLCLAS Employee Class String STR15_Employee_Class 15 7 SUPERVISORCODE_I Supervisor Code String STR6_U 6 8 ADDRESS1 Address 1 String STR60 60 9 CITY City String STR35 35 10 STATE State String STR30_State 29 11 ZIPCODE Zip Code String STR10 10 12 PHONE1 Phone 1 String Phone_Number 14 13 DIVISIONCODE_I Division Code String STR6_Payroll_Code 6 14 Workflow_Approval_Status Workflow Approval Status Integer DDL_WorkflowApprovalStatus 0 15 Workflow_Priority Workflow Priority Integer DDL_WorkflowPriority 0 16 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['UPR_EmployeeList_View'].USERID AS 'UPR_EmployeeList_View-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
UPR50000 AS ['UPR_EmployeeList_View']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['UPR_EmployeeList_View'].USERID = ['Users Master'].USERID