Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA00532
Product: Project Accounting (258)
Series:
Display Name: PA Customer MSTR COST SUM
Physical Name: PA00532
Technical Name: PA_Customer_MSTR_COST_SUMSeq 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 Customer MSTR COST SUM'].CUSTNMBR AS 'PA Customer MSTR COST SUM-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA00532 AS ['PA Customer MSTR COST SUM']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Customer MSTR COST SUM'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 PA_Aging_Period_WIP_Amt_1 PA Aging Period WIP Amount[1] Currency PA_DLR17_RBS0_STR$ 17 3 PA_Aging_Period_WIP_Amt PA Aging Period WIP Amount PA_DLR17_RBS0_STR$ Currency 17 4 PA_Aging_Period_WIP_Amt_2 PA Aging Period WIP Amount[2] Currency PA_DLR17_RBS0_STR$ 17 5 PA_Aging_Period_WIP_Amt_3 PA Aging Period WIP Amount[3] Currency PA_DLR17_RBS0_STR$ 17 6 PA_Aging_Period_WIP_Amt_4 PA Aging Period WIP Amount[4] Currency PA_DLR17_RBS0_STR$ 17 7 PA_Aging_Period_WIP_Amt_5 PA Aging Period WIP Amount[5] Currency PA_DLR17_RBS0_STR$ 17 8 PA_Aging_Period_WIP_Amt_6 PA Aging Period WIP Amount[6] Currency PA_DLR17_RBS0_STR$ 17 9 PA_Aging_Period_WIP_Amt_7 PA Aging Period WIP Amount[7] Currency PA_DLR17_RBS0_STR$ 17 10 PATOTCST PA Total Cost Currency PA_DLR17_RBS0_STR$ 17 11 LASTAGED Last Aged Date DATE 6