Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA01200
Product: Project Accounting (258)
Series: Project
Display Name: PA_ProjectListView 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.
Physical Name: PA01200
Technical Name: PA_ProjectList_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['PA_ProjectListView'].CUSTNMBR AS 'PA_ProjectListView-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA01200 AS ['PA_ProjectListView']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA_ProjectListView'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2 PACONTNUMBER PA Contract Number STR10_LBAU String 10 3 PAprojid PA Project ID STR15_Project ID String 15 4 PAPROJNUMBER PA Project Number STR15_LBAU String 15 5 PAprojname PA Project Name STR30_PTBS Description 1 String 30 6 PAProjectType PA Project Type PA_DDL_Project_Type Integer 0 7 PAAcctgMethod PA Accounting Method PA_DDL_Accounting_Method Integer 0 8 PASTAT PA Status PA_DDL_Status Integer 0 9 PASegmentCB PA Segment CB PA_CB_Segment Boolean 0 10 PAprojmngrid PA Project Manager ID STR15_Employee_ID String 15 11 PAProject_Amount PA Project Amount DLR17_RBS0_UTR$ Currency 17 12 CUSTNAME Customer Name STR64_Customer_Name String 64 13 DEX_ROW_ID int int 10