PA MC Project Master File (PA01202)

azurecurveProductsProject Accounting (258)ProjectPA MC Project Master File (PA01202)

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_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
2PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
3CURRNIDX SearchCurrency IndexIntegerINT33
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'].CURRNIDX
4PABRATETPID SearchPA Baseline Rate Type IDStringSTR15_Rate_Type_ID15
5PABEXGTBLID SearchPA Baseline Exchange Table IDStringSTR15_Exchange_Table_ID15
6PABXCHGRATE SearchPA Baseline Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
7PABEXCHDATE SearchPA Baseline Exchange DateDateDT_Date6
8PABTIME1 SearchPA Baseline TimeTimeTM66
9PABRTCLCMTD SearchPA Baseline Rate Calculation MethodIntegerGB0
10PABDENXRATE SearchPA Baseline Den Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
11PABMCTRXSTT SearchPA Baseline MC Transaction StateIntegerINT11
12PAFRATETPID SearchPA Forecast Rate Type IDStringSTR15_Rate_Type_ID15
13PAFEXGTBLID SearchPA Forecast Exchange Table IDStringSTR15_Exchange_Table_ID15
14PAFXCHGRATE SearchPA Forecast Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
15PAFEXCHDATE SearchPA Forecast Exchange DateDateDT_Date6
16PAFTIME1 SearchPA Forecast TimeTimeTM66
17PAFRTCLCMTD SearchPA Forecast Rate Calculation MethodIntegerGB0
18PAFDENXRATE SearchPA Forecast Den Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
19PAFMCTRXSTT SearchPA Forecast MC Transaction StateIntegerINT11
azurecurveProductsProject Accounting (258)ProjectPA MC Project Master File (PA01202)

Leave a Reply

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