Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PP000030
Product: Revenue Expense Deferrals (1045)
Series:
Display Name: Deferral User Access
Physical Name: PP000030
Technical Name: PP_User_AccessSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PP_User_Security_Type 
PP User Security Type Integer INT 0 2 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Deferral User Access'].USERID AS 'Deferral User Access-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PP000030 AS ['Deferral User Access']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Deferral User Access'].USERID = ['Users Master'].USERID3 PP_Profile_Name PP Profile Name String STR20_Document_Number 20 4 PP_User_Access PP_User_Access Boolean PP_User_Access 0 5 PP_Edit_Profile_Original PP Edit Profile Original Account Boolean PP_Edit_Profile_Original_Account 0 6 PP_Edit_Profile_Offset_A PP Edit Profile Offset Account Boolean PP_Edit_Profile_Offset_Account 0 7 PP_Edit_Profile_Deferred PP Edit Profile Deferred BC Account Boolean PP_Edit_Profile_Deferred_BC_Account 0 8 PP_Edit_Profile_CI_Accou PP Edit Profile Recog Account Boolean PP_Edit_Profile_Rec_Account 0 9 PP_Edit_Profile_Transfer PP Edit Profile Transfer Account Boolean PP_Edit_Profile_Transfer_Account 0 10 PP_Edit_Profile_Start_Da PP Edit Profile Start Date Boolean PP_Edit_Profile_Start_Date 0 11 PP_Edit_Profile_Calculat PP Edit Profile Calculation Method Boolean PP_Edit_Profile_Calculation_Method 0 12 PP_Edit_Profile_Periods PP Edit Profile Periods Boolean PP_Edit_Profile_Periods 0 13 PP_Edit_Profile_Miscella PP Edit Profile Miscellaneous Periods Boolean PP_Edit_Profile_Miscellaneous_Period 0 14 PP_Edit_Debit_Credit PP Edit Debit Credit Boolean PP_Edit_Debit_Credit 0 15 PP_Module PP Module Integer INT3 3