# NetSuite Transaction Status Codes for SuiteQL and Saved Search > Source: https://netray.co/tools/netsuite-transaction-status-codes-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Status letter, search filter value and label for sales orders, invoices, purchase orders, fulfillments, bills, RMAs, transfer orders and more. ## Category netsuite ## Erp NetSuite ## Audience - NetSuite developer - NetSuite administrator - Integration engineer ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Transaction **Key:** transaction **Type:** text #### Type code **Key:** type_code **Type:** text #### Status letter (SuiteQL) **Key:** letter **Type:** text #### Search filter value **Key:** search_filter_value **Type:** text #### Label **Key:** label **Type:** text #### Meaning **Key:** meaning **Type:** text **Rows:** #### Pending Approval **Transaction:** Sales Order **Type code:** SalesOrd **Letter:** A **Search filter value:** SalesOrd:A **Meaning:** Entered, waiting for approval before fulfillment #### Pending Fulfillment **Transaction:** Sales Order **Type code:** SalesOrd **Letter:** B **Search filter value:** SalesOrd:B **Meaning:** Approved, nothing shipped yet #### Cancelled **Transaction:** Sales Order **Type code:** SalesOrd **Letter:** C **Search filter value:** SalesOrd:C **Meaning:** Cancelled before fulfillment #### Partially Fulfilled **Transaction:** Sales Order **Type code:** SalesOrd **Letter:** D **Search filter value:** SalesOrd:D **Meaning:** Some lines or quantities shipped, none billed #### Pending Billing/Partially Fulfilled **Transaction:** Sales Order **Type code:** SalesOrd **Letter:** E **Search filter value:** SalesOrd:E **Meaning:** Part shipped and the shipped part is waiting to be billed #### Pending Billing **Transaction:** Sales Order **Type code:** SalesOrd **Letter:** F **Search filter value:** SalesOrd:F **Meaning:** Fully shipped, not yet billed #### Billed **Transaction:** Sales Order **Type code:** SalesOrd **Letter:** G **Search filter value:** SalesOrd:G **Meaning:** Fully shipped and billed #### Closed **Transaction:** Sales Order **Type code:** SalesOrd **Letter:** H **Search filter value:** SalesOrd:H **Meaning:** Remaining lines closed manually #### Open **Transaction:** Invoice **Type code:** CustInvc **Letter:** A **Search filter value:** CustInvc:A **Meaning:** Amount remaining to be paid #### Paid In Full **Transaction:** Invoice **Type code:** CustInvc **Letter:** B **Search filter value:** CustInvc:B **Meaning:** Fully paid or credited #### Pending Supervisor Approval **Transaction:** Purchase Order **Type code:** PurchOrd **Letter:** A **Search filter value:** PurchOrd:A **Meaning:** Waiting for approval #### Pending Receipt **Transaction:** Purchase Order **Type code:** PurchOrd **Letter:** B **Search filter value:** PurchOrd:B **Meaning:** Approved, nothing received #### Rejected by Supervisor **Transaction:** Purchase Order **Type code:** PurchOrd **Letter:** C **Search filter value:** PurchOrd:C **Meaning:** Approval rejected #### Partially Received **Transaction:** Purchase Order **Type code:** PurchOrd **Letter:** D **Search filter value:** PurchOrd:D **Meaning:** Some quantity received, none billed #### Pending Billing/Partially Received **Transaction:** Purchase Order **Type code:** PurchOrd **Letter:** E **Search filter value:** PurchOrd:E **Meaning:** Part received and the received part waiting for a bill #### Pending Bill **Transaction:** Purchase Order **Type code:** PurchOrd **Letter:** F **Search filter value:** PurchOrd:F **Meaning:** Fully received, not yet billed #### Fully Billed **Transaction:** Purchase Order **Type code:** PurchOrd **Letter:** G **Search filter value:** PurchOrd:G **Meaning:** Received and billed #### Closed **Transaction:** Purchase Order **Type code:** PurchOrd **Letter:** H **Search filter value:** PurchOrd:H **Meaning:** Remaining lines closed #### Picked **Transaction:** Item Fulfillment **Type code:** ItemShip **Letter:** A **Search filter value:** ItemShip:A **Meaning:** Picked, not packed (pick, pack and ship enabled) #### Packed **Transaction:** Item Fulfillment **Type code:** ItemShip **Letter:** B **Search filter value:** ItemShip:B **Meaning:** Packed, not shipped #### Shipped **Transaction:** Item Fulfillment **Type code:** ItemShip **Letter:** C **Search filter value:** ItemShip:C **Meaning:** Shipped; posts COGS #### Open **Transaction:** Vendor Bill **Type code:** VendBill **Letter:** A **Search filter value:** VendBill:A **Meaning:** Amount remaining to be paid #### Paid In Full **Transaction:** Vendor Bill **Type code:** VendBill **Letter:** B **Search filter value:** VendBill:B **Meaning:** Fully paid or credited #### Cancelled **Transaction:** Vendor Bill **Type code:** VendBill **Letter:** C **Search filter value:** VendBill:C **Meaning:** Cancelled #### Pending Approval **Transaction:** Vendor Bill **Type code:** VendBill **Letter:** D **Search filter value:** VendBill:D **Meaning:** Waiting for bill approval #### Rejected **Transaction:** Vendor Bill **Type code:** VendBill **Letter:** E **Search filter value:** VendBill:E **Meaning:** Approval rejected #### Pending Approval **Transaction:** Return Authorization **Type code:** RtnAuth **Letter:** A **Search filter value:** RtnAuth:A **Meaning:** RMA waiting for approval #### Pending Receipt **Transaction:** Return Authorization **Type code:** RtnAuth **Letter:** B **Search filter value:** RtnAuth:B **Meaning:** Approved, goods not received #### Cancelled **Transaction:** Return Authorization **Type code:** RtnAuth **Letter:** C **Search filter value:** RtnAuth:C **Meaning:** Cancelled #### Partially Received **Transaction:** Return Authorization **Type code:** RtnAuth **Letter:** D **Search filter value:** RtnAuth:D **Meaning:** Some goods received #### Pending Refund/Partially Received **Transaction:** Return Authorization **Type code:** RtnAuth **Letter:** E **Search filter value:** RtnAuth:E **Meaning:** Part received and waiting for credit or refund #### Pending Refund **Transaction:** Return Authorization **Type code:** RtnAuth **Letter:** F **Search filter value:** RtnAuth:F **Meaning:** Received, credit or refund not issued #### Refunded **Transaction:** Return Authorization **Type code:** RtnAuth **Letter:** G **Search filter value:** RtnAuth:G **Meaning:** Credit memo or refund issued #### Closed **Transaction:** Return Authorization **Type code:** RtnAuth **Letter:** H **Search filter value:** RtnAuth:H **Meaning:** Closed #### Pending Approval **Transaction:** Transfer Order **Type code:** TrnfrOrd **Letter:** A **Search filter value:** TrnfrOrd:A **Meaning:** Waiting for approval #### Pending Fulfillment **Transaction:** Transfer Order **Type code:** TrnfrOrd **Letter:** B **Search filter value:** TrnfrOrd:B **Meaning:** Approved, nothing shipped from source location #### Rejected **Transaction:** Transfer Order **Type code:** TrnfrOrd **Letter:** C **Search filter value:** TrnfrOrd:C **Meaning:** Approval rejected #### Partially Fulfilled **Transaction:** Transfer Order **Type code:** TrnfrOrd **Letter:** D **Search filter value:** TrnfrOrd:D **Meaning:** Some quantity shipped #### Pending Receipt/Partially Fulfilled **Transaction:** Transfer Order **Type code:** TrnfrOrd **Letter:** E **Search filter value:** TrnfrOrd:E **Meaning:** Part shipped and in transit #### Pending Receipt **Transaction:** Transfer Order **Type code:** TrnfrOrd **Letter:** F **Search filter value:** TrnfrOrd:F **Meaning:** Fully shipped, not received at destination #### Received **Transaction:** Transfer Order **Type code:** TrnfrOrd **Letter:** G **Search filter value:** TrnfrOrd:G **Meaning:** Received at destination #### Closed **Transaction:** Transfer Order **Type code:** TrnfrOrd **Letter:** H **Search filter value:** TrnfrOrd:H **Meaning:** Closed #### Open **Transaction:** Estimate **Type code:** Estimate **Letter:** A **Search filter value:** Estimate:A **Meaning:** Quote open #### Processed **Transaction:** Estimate **Type code:** Estimate **Letter:** B **Search filter value:** Estimate:B **Meaning:** Converted to a sales order or invoice #### Closed **Transaction:** Estimate **Type code:** Estimate **Letter:** C **Search filter value:** Estimate:C **Meaning:** Closed without conversion #### Voided **Transaction:** Estimate **Type code:** Estimate **Letter:** V **Search filter value:** Estimate:V **Meaning:** Voided #### Expired **Transaction:** Estimate **Type code:** Estimate **Letter:** X **Search filter value:** Estimate:X **Meaning:** Past its expiration date #### Not Deposited **Transaction:** Customer Payment **Type code:** CustPymt **Letter:** B **Search filter value:** CustPymt:B **Meaning:** In undeposited funds #### Deposited **Transaction:** Customer Payment **Type code:** CustPymt **Letter:** C **Search filter value:** CustPymt:C **Meaning:** Included in a deposit #### Not Deposited **Transaction:** Cash Sale **Type code:** CashSale **Letter:** B **Search filter value:** CashSale:B **Meaning:** In undeposited funds #### Deposited **Transaction:** Cash Sale **Type code:** CashSale **Letter:** C **Search filter value:** CashSale:C **Meaning:** Included in a deposit #### Pending Approval **Transaction:** Journal **Type code:** Journal **Letter:** A **Search filter value:** Journal:A **Meaning:** Journal approval routing on, not yet approved #### Approved for Posting **Transaction:** Journal **Type code:** Journal **Letter:** B **Search filter value:** Journal:B **Meaning:** Approved and posted **Notes:** Work order statuses are covered in the separate NetSuite work order status reference. Labels can be renamed in some accounts and extra statuses appear with approval routing or features such as payment approval; confirm against the Status filter list in a saved search for your account. In SuiteQL, always filter status together with type. ## Content **Intro:** NetSuite stores transaction status as a single letter per transaction type, while saved searches and N/search filters use the combined form such as SalesOrd:B. This table lists both, with the label, for the transaction types integration and reporting work touches most. **Sections:** #### How to use it **Body:** Filter by transaction or type code, then copy the form you need. In SuiteQL write t.type = 'SalesOrd' AND t.status = 'B', or use the combined value with BUILTIN.CF: BUILTIN.CF(t.status) = 'SalesOrd:B'. In SuiteScript N/search, use the search filter value: ['status', 'anyof', ['SalesOrd:B', 'SalesOrd:D']]. To show labels in SuiteQL output, select BUILTIN.DF(t.status). **Bullets:** - SuiteQL raw column: one letter - N/search and saved search filters: TypeCode:Letter - Labels in SuiteQL: BUILTIN.DF(status) #### Why the letter alone is not enough **Body:** The same letter means different things on different types. B is Pending Fulfillment on a sales order, Paid In Full on an invoice, Pending Receipt on a purchase order and Packed on an item fulfillment. A query that filters status = 'B' without a type filter mixes all of them. Oracle's BUILTIN.CF documentation says to use CF for filters on composite fields like status, which returns the type and the letter together and removes that risk. #### Worked example: backlog by status **Body:** SELECT BUILTIN.DF(t.status) AS status_label, COUNT(*) AS orders, SUM(t.foreigntotal) AS value FROM transaction t WHERE t.type = 'SalesOrd' AND t.status IN ('B', 'D', 'E') GROUP BY BUILTIN.DF(t.status). That returns Pending Fulfillment, Partially Fulfilled and Pending Billing/Partially Fulfilled orders, which together form the open shipping backlog. Add F to include orders shipped but not billed, which is the unbilled revenue queue rather than the shipping queue. #### How to check the result in the system **Body:** Create a transaction saved search, add a Status filter and open its value list: each entry shows the label, and the internal value used by scripts is the TypeCode:Letter form. Compare a SuiteQL count for one letter with a saved search count for the same status and date range; they should match when you filter mainline the same way. **Cta:** If your team wants to ask which orders are stuck in which status in plain English, we can set up a private AI layer over NetSuite that answers from live data and shows the query. **Faq:** #### What is the status for CustInvc in NetSuite SuiteQL? **Answer:** Invoices use A for Open and B for Paid In Full. In SuiteQL filter t.type = 'CustInvc' AND t.status = 'A' for open invoices, or BUILTIN.CF(t.status) = 'CustInvc:A'. BUILTIN.DF(t.status) returns the label. #### What does SalesOrd:B mean? **Answer:** It is the search filter value for a sales order in Pending Fulfillment status: approved, with nothing fulfilled yet. Use it in saved search criteria and N/search filters. In SuiteQL the same status is the letter B on a row where type = 'SalesOrd'. #### What is the difference between Pending Billing and Pending Billing/Partially Fulfilled? **Answer:** Pending Billing (F) means everything has shipped and some or all of it is not billed. Pending Billing/Partially Fulfilled (E) means only part has shipped and that shipped part is waiting to be billed, so the order is still open for fulfillment too. #### Where are work order statuses? **Answer:** Work orders have their own status set covering planned, released, in process, built and closed states. They are in the separate NetSuite work order status reference, linked below, to keep this table focused on sales, purchasing and finance transactions. ## Search terms status for custinv in netsuite suiteql, netsuite sales order status list, netsuite order status codes, netsuite suiteql query, netsuite purchase order status codes, salesord:b netsuite, netsuite transaction status filter --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json