APR Priority Setup (APR41601)

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

Product: HRM Solution Series (1911)
Series: Payroll

Display Name: APR Priority Setup
Physical Name: APR41601
Technical Name: APR_SETP_Priority

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1INTERID SearchIntercompany IDSTR5_IC_IDString5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['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
2APR_Priority_1 SearchAPR Priority[1]INT4Integer4
3APR_Priority_2 SearchAPR Priority[2]INT4Integer4
4APR_Priority_3 SearchAPR Priority[3]INT4Integer4
5APR_Priority_4 SearchAPR Priority[4]INT4Integer4
6APR_Priority_5 SearchAPR Priority[5]INT4Integer4
7APR_Priority_6 SearchAPR Priority[6]INT4Integer4
8APR_Priority_7 SearchAPR Priority[7]INT4Integer4
9APR_Priority_8 SearchAPR Priority[8]INT4Integer4
10APR_Priority_9 SearchAPR Priority[9]INT4Integer4
11APR_Priority_10 SearchAPR Priority[10]INT4Integer4
12DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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