Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR40502
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Posting Account Import
Physical Name: UPR40502
Technical Name: UPR_SETP_Account_ImportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DEPRTMNT 
Department String STR6_Payroll_Code 6 2 JOBTITLE Job Title String STR6_Payroll_Code 6 3 PAYROLCD Payroll Code String STR6_Payroll_Code 6 4 UPRACTYP UPR Account Type Integer DDL_UPR_Account_Type 0 5 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Payroll Posting Account Import'].ACTINDX AS 'Payroll Posting Account Import-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
UPR40502 AS ['Payroll Posting Account Import']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Payroll Posting Account Import'].ACTINDX = ['Account Index Master'].ACTINDX