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 Group Display Name: HRM Solution Series
Physical Name: APR00401
Technical Name: APR_MSTR_Employee_Pay_Policy
Group Technical Name: APR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | EMPLOYID  | Employee ID | String | STR15_Employee_ID | 15 | |
| 2 | PAYRCORD | Pay Record | String | STR6_Payroll_Code | 6 | |
| 3 | INTERID | Intercompany ID | String | STR5_IC_ID | 5 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['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 | ||||||
| 4 | APR_Use_Company_AddOn | APR Use Company AddOn | Boolean | APR Use Company CB | 0 | |
| 5 | DEPRTMNT | Department | String | STR6_Payroll_Code | 6 | |
| 6 | APR_Use_Dept_AddOn | APR Use Dept AddOn | Boolean | APR Use Department CB | 0 | |
| 7 | JOBTITLE | Job Title | String | STR6_Payroll_Code | 6 | |
| 8 | APR_Use_Position_AddOn | APR Use Position AddOn | Boolean | APR Use Position CB | 0 | |
| 9 | SHFTCODE | Shift Code | String | STR6_Payroll_Code | 6 | |
| 10 | APR_Use_Shift_AddOn | APR Use Shift AddOn | Boolean | APR Use Shift CB | 0 | |
| 11 | APR_AddOn_Type | APR AddOn Type | Integer | APR_AddOn_Type_DDL | 0 | |
| 12 | APR_AddOn_Amount | APR AddOn Amount | Currency | DLR11_$S2 | 14 | |
| 13 | APR_AddOn_Percent | APR AddOn Percent | Currency | DLR5_%2 | 8 | |
| 14 | CHANGEBY_I | Change By | String | STR15_User_ID | 15 | |
| 15 | CHANGEDATE_I | Change Date | Date | DT | 8 | |