In suiteql, is there a way to get the return tracking number

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that the tracking number is not directly stored in the NetSuite database. However, you can derive the tracking URL by using the carrier type and appending the actual tracking number at the end. Here is a sample function that was shared in the conversation:

javascript
function trackingURL(carrier) {
    var url;
    switch(carrier) {
        case "UPS":
            url = "<http://wwwapps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&InquiryNumber1=>";
            break;
        case "FEDEX":
            url = "<http://fedex.com/Tracking?ascend_header=1&clienttype=dotcom&cntry_code=us&language=english&tracknumbers=>";
            break;
        case "DHL":
            url = "<https://webtrack.dhlglobalmail.com/?trackingnumber=>";
            break;
        default:
            url = "<http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?strOrigTrackNum=>";
    }
    return url;
}

You can use this function to generate the tracking URL based on the carrier type. You might need to modify this function based on your own carriers. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******