This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have the following query to pull item fulfillment records along with their statuses for a given sales order. How can I get the actual “refName” of the status.

The status column returns “A”, “B”, “C” and I want “Picked” “Packed” “Shipped”

```  def self.item_fulfillment(salesorder_id:)
    &lt;&lt;~STOP
      SELECT          Transaction.id, Transaction.status
      FROM            Transaction
      JOIN            TransactionLine
        ON TransactionLine.Transaction = Transaction.id
      WHERE           Transaction.Type = 'ItemShip'
      AND             TransactionLine.CreatedFrom = '#{salesorder_id}'
    STOP
  end```
I can, of course, pull this id via SuiteQL and then pull the IF record by REST to get the decoded status but would rather pull it in query if possible.