Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POA40002
Product: Cash Flow Management (1632)
Series:
Display Name: POA_User_Setup
Physical Name: POA40002
Technical Name: POA_User_SetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 APRVLUSERID 
Approval User ID String STR15_User_ID 15 2 CMPANYID Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['POA_User_Setup'].CMPANYID AS 'POA_User_Setup-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
POA40002 AS ['POA_User_Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['POA_User_Setup'].CMPANYID = ['Company Master'].CMPANYID3 POA_Approval_Type POA Approval Type Integer POA_RG_Approval_Type 0 4 POA_Approval_Authority_A POA Approval Authority Amount Currency DLR11_$S2 14 5 POA_Report_To_User_ID POA Report To User ID String STR15_User_ID 15 6 POA_Security_Type POA Security Type Integer POA_RG_Security_Type 0