Payroll Position Setup – HR Alias (UPR40301)

azurecurveProductsHuman Resources (414)PayrollPayroll Position Setup - HR Alias (UPR40301)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR40301

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Position Setup
Physical Name: UPR40301
Technical Name: UPR_SETP_Job_Title

Group Display Name: Payroll Position Setup
Group Technical Name: Payroll Job Title Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
2DSCRIPTN SearchDescriptionStringSTR3030
3EEOCLASS_I SearchEEO ClassIntegerDDL_EEO0
4FLSASTATUS SearchFLSA StatusIntegerDDL_FLSA_Status0
5REPORTSTOPOS SearchReports To PositionStringSTR6_Payroll_Code6
6REVIEWSETUPCODE_I SearchReview Setup CodeStringSTR3030
7SKILLSETNUMBER_I SearchSkill Set NumberLong IntegerINT66
8CHANGEBY_I SearchChange ByStringSTR15_User_ID15
9CHANGEDATE_I SearchChange DateDateDT8
10NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Position Setup'].NOTEINDX AS 'Payroll Position Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR40301 AS ['Payroll Position Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Position Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
11NOTEINDX2 SearchNote Index2CurrencyDLR1414
12TXTFIELD SearchText FieldTextTX3200032000
azurecurveProductsHuman Resources (414)PayrollPayroll Position Setup - HR Alias (UPR40301)

Leave a Reply

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