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 TypeSQL DB LengthKeyable Length
1PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
2PAMCCURNCYID SearchPA MC Currency IDSTR15_Currency_IDString1615
3CURRNIDX SearchCurrency IndexINT3Integer23
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_IDString1615
5PABEXGTBLID SearchPA Baseline Exchange Table IDSTR15_Exchange_Table_IDString1615
6PABXCHGRATE SearchPA Baseline Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
7PABEXCHDATE SearchPA Baseline Exchange DateDT_DateDate46
8PABTIME1 SearchPA Baseline TimeTM6Time46
9PABRTCLCMTD SearchPA Baseline Rate Calculation MethodGBInteger20
10PABDENXRATE SearchPA Baseline Den Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
11PABMCTRXSTT SearchPA Baseline MC Transaction StateINT1Integer21
12PAFRATETPID SearchPA Forecast Rate Type IDSTR15_Rate_Type_IDString1615
13PAFEXGTBLID SearchPA Forecast Exchange Table IDSTR15_Exchange_Table_IDString1615
14PAFXCHGRATE SearchPA Forecast Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
15PAFEXCHDATE SearchPA Forecast Exchange DateDT_DateDate46
16PAFTIME1 SearchPA Forecast TimeTM6Time46
17PAFRTCLCMTD SearchPA Forecast Rate Calculation MethodGBInteger20
18PAFDENXRATE SearchPA Forecast Den Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
19PAFMCTRXSTT SearchPA Forecast MC Transaction StateINT1Integer21
20DEX_ROW_ID Searchintint1010

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 *