APR Employee Pay Policy Master (APR00401)

azurecurveProductsHRM Solution Series (1911)PayrollAPR Employee Pay Policy Master (APR00401)

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

Product: HRM Solution Series (1911)
Series:

Display Name: APR Employee Pay Policy Master
Physical Name: APR00401
Technical Name: APR_MSTR_Employee_Pay_Policy

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2PAYRCORD SearchPay RecordStringSTR6_Payroll_Code6
3INTERID SearchIntercompany IDStringSTR5_IC_ID5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['APR Employee Pay Policy Master'].INTERID AS 'APR Employee Pay Policy Master-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       APR00401 AS ['APR Employee Pay Policy Master']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['APR Employee Pay Policy Master'].INTERID = ['Company Master'].INTERID
4APR_Use_Company_AddOn SearchAPR Use Company AddOnBooleanAPR Use Company CB0
5DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
6APR_Use_Dept_AddOn SearchAPR Use Dept AddOnBooleanAPR Use Department CB0
7JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
8APR_Use_Position_AddOn SearchAPR Use Position AddOnBooleanAPR Use Position CB0
9SHFTCODE SearchShift CodeStringSTR6_Payroll_Code6
10APR_Use_Shift_AddOn SearchAPR Use Shift AddOnBooleanAPR Use Shift CB0
11APR_AddOn_Type SearchAPR AddOn TypeIntegerAPR_AddOn_Type_DDL0
12APR_AddOn_Amount SearchAPR AddOn AmountCurrencyDLR11_$S214
13APR_AddOn_Percent SearchAPR AddOn PercentCurrencyDLR5_%28
14CHANGEBY_I SearchChange ByStringSTR15_User_ID15
15CHANGEDATE_I SearchChange DateDateDT8
azurecurveProductsHRM Solution Series (1911)PayrollAPR Employee Pay Policy Master (APR00401)

Leave a Reply

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