Hi, can anyone point me in the right direction to obtain a list of Sales order statuses so that I can join the transaction table to it and find out the netsuite order status.
Netsuite.com returned the status as text and I have queries built around that. I have the transaction.status column returning a single letter such as B which is "Pending Fulfillment" I assume and I have an offline list of the statuses. However, I'd like to return them from a query so that I can join the transaction to the status table just in case they get changed in the future.
Order:Pending Approval | SalesOrd:A |
|---|
Order:Pending Fulfillment | SalesOrd:B |
Order:Cancelled | SalesOrd:C |
Order:Partially Fulfilled | SalesOrd:D |
Order:Pending Billing/Partially Fulfilled | SalesOrd:E |
Order:Pending Billing | SalesOrd:F |
Order:Billed | SalesOrd:G |
Order:Closed | SalesOrd:H |
I am wanting to avoid writing a case statement in MSSQL! I can't seem to find this table if it exists.