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