Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA00521
Product: Project Accounting (258)
Series:
Display Name: PA Customer MSTR SUM
Physical Name: PA00521
Technical Name: PA_Customer_MSTR_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 SUM'].CUSTNMBR AS 'PA Customer MSTR SUM-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA00521 AS ['PA Customer MSTR SUM']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Customer MSTR SUM'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 AGPERAMT_1 Aging Period Amounts[1] Currency DLR17_RBSO_STR$ 17 3 AGPERAMT Aging Period Amounts DLR17_RBSO_STR$ Currency 17 4 AGPERAMT_2 Aging Period Amounts[2] Currency DLR17_RBSO_STR$ 17 5 AGPERAMT_3 Aging Period Amounts[3] Currency DLR17_RBSO_STR$ 17 6 AGPERAMT_4 Aging Period Amounts[4] Currency DLR17_RBSO_STR$ 17 7 AGPERAMT_5 Aging Period Amounts[5] Currency DLR17_RBSO_STR$ 17 8 AGPERAMT_6 Aging Period Amounts[6] Currency DLR17_RBSO_STR$ 17 9 AGPERAMT_7 Aging Period Amounts[7] Currency DLR17_RBSO_STR$ 17 10 PA_Unpaid_Amount PA Unpaid Amount Currency DLR17_RBS0_UTR$ 17 11 LASTAGED Last Aged Date DATE 6