Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR41601
Product: HRM Solution Series (1911)
Series:
Display Name: APR Priority Setup Group Display Name: HRM Solution Series
Physical Name: APR41601
Technical Name: APR_SETP_Priority
Group Technical Name: APR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | INTERID  | Intercompany ID | String | STR5_IC_ID | 5 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['APR Priority Setup'].INTERID AS 'APR Priority Setup-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
APR41601 AS ['APR Priority Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['APR Priority Setup'].INTERID = ['Company Master'].INTERID | ||||||
| 2 | APR_Priority_1 | APR Priority[1] | Integer | INT4 | 4 | |
| 3 | APR_Priority_2 | APR Priority[2] | Integer | INT4 | 4 | |
| 4 | APR_Priority_3 | APR Priority[3] | Integer | INT4 | 4 | |
| 5 | APR_Priority_4 | APR Priority[4] | Integer | INT4 | 4 | |
| 6 | APR_Priority_5 | APR Priority[5] | Integer | INT4 | 4 | |
| 7 | APR_Priority_6 | APR Priority[6] | Integer | INT4 | 4 | |
| 8 | APR_Priority_7 | APR Priority[7] | Integer | INT4 | 4 | |
| 9 | APR_Priority_8 | APR Priority[8] | Integer | INT4 | 4 | |
| 10 | APR_Priority_9 | APR Priority[9] | Integer | INT4 | 4 | |
| 11 | APR_Priority_10 | APR Priority[10] | Integer | INT4 | 4 | |