TSQL Read XML

1

I'm struggling to get the information from the below xml. The data is in text format in a SQL field and although I can convert it to XML , I'm struggling to read the required data from it. I have chopped out a lot of the data fields as once I know how to get the mechanics working I can expand to the other fields

XML Data

Looking to get Status from TransferResults and ValueTotal from PaymentFile and name from OriginatingServiceUser

Desired results

complete 30446324 COMPANY 1
complete 123456 COMPANY 2

2

I am not able to see the xml data if you posted any.

3

Apologies for the long delay in responding. I thought i had posted the XML, but I have now resolved the issue

Thank you for trying to help