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: Project

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 NumberSTR15_LBAUString15
2PAMCCURNCYID SearchPA MC Currency IDSTR15_Currency_IDString15
3CURRNIDX SearchCurrency IndexINT3Integer3
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 IDSTR15_Rate_Type_IDString15
5PABEXGTBLID SearchPA Baseline Exchange Table IDSTR15_Exchange_Table_IDString15
6PABXCHGRATE SearchPA Baseline Exchange RateDLR14_Exchange_RateCurrency (Variable)14
7PABEXCHDATE SearchPA Baseline Exchange DateDT_DateDate6
8PABTIME1 SearchPA Baseline TimeTM6Time6
9PABRTCLCMTD SearchPA Baseline Rate Calculation MethodGBInteger0
10PABDENXRATE SearchPA Baseline Den Exchange RateDLR14_Exchange_RateCurrency (Variable)14
11PABMCTRXSTT SearchPA Baseline MC Transaction StateINT1Integer1
12PAFRATETPID SearchPA Forecast Rate Type IDSTR15_Rate_Type_IDString15
13PAFEXGTBLID SearchPA Forecast Exchange Table IDSTR15_Exchange_Table_IDString15
14PAFXCHGRATE SearchPA Forecast Exchange RateDLR14_Exchange_RateCurrency (Variable)14
15PAFEXCHDATE SearchPA Forecast Exchange DateDT_DateDate6
16PAFTIME1 SearchPA Forecast TimeTM6Time6
17PAFRTCLCMTD SearchPA Forecast Rate Calculation MethodGBInteger0
18PAFDENXRATE SearchPA Forecast Den Exchange RateDLR14_Exchange_RateCurrency (Variable)14
19PAFMCTRXSTT SearchPA Forecast MC Transaction StateINT1Integer1
20DEX_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.

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

Leave a Reply

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