Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR41101
Product: HRM Solution Series (1911)
Series:
Display Name: APR Pay Policy Detail Group Display Name: HRM Solution Series
Physical Name: APR41101
Technical Name: APR_SETP_Pay_Policy_DTL
Group Technical Name: APR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PAYRCORD  | Pay Record | String | STR6_Payroll_Code | 6 | |
| 2 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
| 3 | INTERID | Intercompany ID | String | STR5_IC_ID | 5 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['APR Pay Policy Detail'].INTERID AS 'APR Pay Policy Detail-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
APR41101 AS ['APR Pay Policy Detail']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['APR Pay Policy Detail'].INTERID = ['Company Master'].INTERID | ||||||
| 4 | DEPRTMNT | Department | String | STR6_Payroll_Code | 6 | |
| 5 | JOBTITLE | Job Title | String | STR6_Payroll_Code | 6 | |
| 6 | SHFTCODE | Shift Code | String | STR6_Payroll_Code | 6 | |
| 7 | APR_Pay_Rate_Amount | APR Pay Rate Amount | Currency | DLR11_$S2 | 14 | |