Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA01202
Product: Project Accounting (258)
Series:
Display Name: PA MC Project Master File
Physical Name: PA01202
Technical Name: PA_MC_Project_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PAPROJNUMBER 
PA Project Number String STR15_LBAU 15 2 PAMCCURNCYID PA MC Currency ID String STR15_Currency_ID 15 3 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PA MC Project Master File'].CURRNIDX AS 'PA MC Project Master File-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PA01202 AS ['PA MC Project Master File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA MC Project Master File'].CURRNIDX = ['Currency Setup'].CURRNIDX4 PABRATETPID PA Baseline Rate Type ID String STR15_Rate_Type_ID 15 5 PABEXGTBLID PA Baseline Exchange Table ID String STR15_Exchange_Table_ID 15 6 PABXCHGRATE PA Baseline Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 7 PABEXCHDATE PA Baseline Exchange Date Date DT_Date 6 8 PABTIME1 PA Baseline Time Time TM6 6 9 PABRTCLCMTD PA Baseline Rate Calculation Method Integer GB 0 10 PABDENXRATE PA Baseline Den Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 11 PABMCTRXSTT PA Baseline MC Transaction State Integer INT1 1 12 PAFRATETPID PA Forecast Rate Type ID String STR15_Rate_Type_ID 15 13 PAFEXGTBLID PA Forecast Exchange Table ID String STR15_Exchange_Table_ID 15 14 PAFXCHGRATE PA Forecast Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 15 PAFEXCHDATE PA Forecast Exchange Date Date DT_Date 6 16 PAFTIME1 PA Forecast Time Time TM6 6 17 PAFRTCLCMTD PA Forecast Rate Calculation Method Integer GB 0 18 PAFDENXRATE PA Forecast Den Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 19 PAFMCTRXSTT PA Forecast MC Transaction State Integer INT1 1