Transaction Types

This reference lists all NetSuite transaction types with their internal string values. Use these values in SuiteQL queries, saved searches, and SuiteScript filters.

Transaction Type Values

Use the value column when filtering transactions by type in SuiteQL or saved searches.

Value	Display Text
Build	Assembly Build
Unbuild	Assembly Unbuild
VendBill	Bill
VendCred	Bill Credit
VendPymt	Bill Payment
BlankOrd	Blanket Purchase Order
CashRfnd	Cash Refund
CashSale	Cash Sale
CardRfnd	CCard Refund
Check	Check / Cheque
Commissn	Commission
CardChrg	Credit Card
CustCred	Credit Memo
FxReval	Currency Revaluation
CustDep	Customer Deposit
CustRfnd	Customer Refund
Deposit	Deposit
DepAppl	Deposit Application
DeprCust	Deprecated Custom Transaction
ExpRept	Expense Report
FinChrg	Finance Charge
InvAdjst	Inventory Adjustment
InvCount	Inventory Count
InvDistr	Inventory Distribution
InvTrnfr	Inventory Transfer
InvWksht	Inventory Worksheet
CustInvc	Invoice
ItemShip	Item Fulfillment
ItemRcpt	Item Receipt
Journal	Journal
Opprtnty	Opportunity
CustPymt	Payment
PEJrnl	Period End Journal
PurchCon	Purchase Contract
PurchOrd	Purchase Order
Estimate	Quotation / Estimate
Rfq	Request For Quote
PurchReq	Requisition
RtnAuth	Return Authorization
SalesOrd	Sales Order
TaxPymt	Sales Tax Payment
CustChrg	Statement Charge
SysJrnl	System Journal
Transfer	Transfer
TrnfrOrd	Transfer Order
VPrep	Vendor Prepayment
VPrepApp	Vendor Prepayment Application
VendRfq	Vendor Request For Quote
VendAuth	Vendor Return Authorization
WorkOrd	Work Order
WOClose	Work Order Close
WOCompl	Work Order Completion
WOIssue	Work Order Issue

Transaction List/Record IDs

These numeric IDs are used in certain contexts like custom field sources.

ID	Transaction Type
1	Journal
2	Transfer
3	Check
4	Deposit
5	Cash Sale
7	Invoice
8	Statement Charge
9	Payment
10	Credit Memo
11	Inventory Adjustment
12	Inventory Transfer
13	Inventory Worksheet
14	Inventory Distribution
15	Purchase Order
16	Item Receipt
17	Bill
18	Bill Payment
20	Bill Credit
21	Credit Card
22	CCard Refund
23	Sales Tax Payment
28	Expense Report
29	Cash Refund
30	Customer Refund
31	Sales Order
32	Item Fulfillment
33	Return Authorization
36	Currency Revaluation
39	Tax Liability Cheque
40	Customer Deposit
41	Deposit Application
43	Vendor Return Authorization
48	Transfer Order
49	Tegata Receivable
50	Tegata Payable
52	Finance Charge
74	System Journal
75	Balancing Journal
79	Vendor Prepayment
80	Vendor Prepayment Application

Usage Examples

SuiteQL Query

-- Get all Sales Orders
SELECT id, tranid, entity, total
FROM transaction
WHERE type = 'SalesOrd'

-- Get all open invoices
SELECT id, tranid, entity, foreigntotal
FROM transaction
WHERE type = 'CustInvc'
  AND status = 'CustInvc:A'

-- Get multiple transaction types
SELECT id, type, tranid
FROM transaction
WHERE type IN ('SalesOrd', 'CustInvc', 'CustPymt')

SuiteScript Filter

var transactionSearch = search.create({
    type: search.Type.TRANSACTION,
    filters: [
        ['type', 'anyof', 'SalesOrd', 'CustInvc']
    ],
    columns: ['tranid', 'entity', 'total']
});

Saved Search Filter Expression

// Filter for Sales Orders and Invoices
[
    ['type', 'anyof', 'SalesOrd'],
    'OR',
    ['type', 'anyof', 'CustInvc']
]