In CustAgingReport- Need to add new contact number field and showing in output

In CustAgingReport- Need to add new contact number field and showing in output


CustTable tmpCustTable;

INSERT_RECORDSET custAgingReportTmp
(AccountNum, Name, CustAccount, Txt, Currency, CustGroup, BillingClassification, Balance, SortOrder, SalesGroup, CreditMax, CreditMaxCust, SegmentId, PaymTermId, ContactNo) 
SELECT
AccountNum, Name, AccountNum, Txt, CurrencyCode, GroupId, BillingClassification, balance
FROM tmpAccountSum
JOIN SortOrder
FROM custVendTransAging
WHERE tmpAccountSum.AccountNum == custVendTransAging.AccountNum
JOIN SalesGroup, CreditMax, CreditMaxCust, SegmentId, PaymTermId
FROM tmpCustTable
WHERE tmpCustTable.AccountNum == tmpAccountSum.AccountNum

join dirPartyTable

where tmpCustTable.Party == dirPartyTable.RecId

join Locator

from logisticsElectronicAddress

where logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactPhone;