NetSuite SearchFilter Transaction Internal Status List SS 2.0

From https://netsuite.custhelp.com/app/answers/detail/a_id/23874

Transaction Statuses for SuiteScript Search Filters

Published 07/23/2012 12:16 AM   |    Updated 10/30/2020 07:26 PM   |    Answer Id: 23874
Transaction statuses for SuiteScript search filters

Applies To

Product:  2020.1

Scenario

User wants to find the Script equivalent of the different Transaction search filters.

Solution

User may reference to the table below:

 

 

Transaction StatusEquivalent in SuiteScript
- B -
Bill:Open VendBill:A
Bill:Paid In Full VendBill:B
Bill:Cancelled VendBill:C
Bill:Pending Approval VendBill:D
Bill:Rejected VendBill:E
Bill:Payment In-Transit VendBill:F
Bill Payment:Pending Approval VendPymt:A
Bill Payment:In-Transit VendPymt:B
Bill Payment:Confirmed VendPymt:C
Bill Payment:Rejected VendPymt:D
Bill Payment:Declined VendPymt:E
Bill Payment:Approved VendBill:F
Bill Payment:Voided VendPymt:V
Bill Payment:Online Bill Pay Pending Accounting Approval VendPymt:Z
Blanket Purchase Order:Pending Approval BlankOrd:A
Blanket Purchase Order:Approved BlankOrd:B
Blanket Purchase Order:Closed BlankOrd:H
Blanket Purchase Order:Rejected BlankOrd:R
- C -
Cash Sale:Unapproved Payment CashSale:A
Cash Sale:Not Deposited CashSale:B
Cash Sale:Deposited CashSale:C
Check:Voided Check:V
Check:Online Bill Pay Pending Accounting Approval Check:Z
Commission:Pending Payment Commissn:A
Commission:Overpaid Commissn:O
Commission:Pending Accounting Approval Commissn:P
Commission:Rejected by Accounting Commissn:R
Commission:Paid in Full Commissn:X
Credit Memo:Open CustCred:A
Credit Memo:Fully Applied CustCred:B
Credit Memo:Voided CustCred:V
Customer Deposit:Not Deposited CustDep:A
Customer Deposit:Deposited CustDep:B
Customer Deposit:Fully Applied CustDep:C
Customer Deposit:Unapproved Payment CustDep:D
Customer Payment Authorization:Pending Processing CustAuth:A
Customer Payment Authorization:Pending Authorization Confirmation CustAuth:B
Customer Payment Authorization:Declined CustAuth:C
Customer Payment Authorization:Potential Fraud CustAuth:D
Customer Payment Authorization:Authorized CustAuth:E
Customer Payment Authorization:Aged CustAuth:F
Customer Payment Authorization:Partially Captured CustAuth:G
Customer Payment Authorization:Pending Capture Confirmation CustAuth:H
Customer Payment Authorization:Pending Void Confirmation CustAuth:I
Customer Payment Authorization: Invalid CustAuth:J
Customer Payment Authorization: Captured CustAuth:K
Customer Payment Authorization: Voided CustAuth:L
Customer Payment Authorization: Expired CustAuth:N
Customer Payment Authorization: Rejected CustAuth:M
Customer Refund: Cancelled CustRfnd: R
Customer Refund:Voided CustRfnd:V
- D -
Deprecated Custom Transaction:Voided DeprCust:V
- E -
Estimate:Open Estimate:A
Estimate:Processed Estimate:B
Estimate:Closed Estimate:C
Estimate:Voided Estimate:V
Estimate:Expired Estimate:X
Expense Report:In Progress ExpRept:A
Expense Report:Pending Supervisor Approval ExpRept:B
Expense Report:Pending Accounting Approval ExpRept:C
Expense Report:Rejected by Supervisor ExpRept:D
Expense Report:Rejected by Accounting ExpRept:E
Expense Report:Approved by Accounting ExpRept:F
Expense Report:Approved (Overridden) by Accounting ExpRept:G
Expense Report:Rejected (Overridden) by Accounting ExpRept:H
Expense Report:Paid In Full ExpRept:I
Expense Report:Payment In Transit ExpRept:J
Expense Report:Voided ExpRept:V
- F -
Fulfillment Request:New FftReq:A
Fulfillment Request:In Progress FftReq:B
Fulfillment Request:Cancelled FftReq:C
Fulfillment Request:Picked FftReq:D
Fulfillment Request:Partially Fulfilled FftReq:E
Fulfillment Request:Fulfilled FftReq:F
Fulfillment Request:Fulfilled With Exceptions FftReq:G
Fulfillment Request:Packed FftReq:I
Fulfillment Request:Rejected FftReq:R
- I -
Inventory Count:Open InvCount:A
Inventory Count:Started InvCount:B
Inventory Count:Completed/Pending Approval InvCount:C
Inventory Count:Approved InvCount:D
Invoice:Open CustInvc:A
Invoice:Paid In Full CustInvc:B
Invoice:Pending Approval CustInvc:D
Invoice:Rejected CustInvc:E
Invoice:Voided CustInvc:V
Item Fulfillment:Picked ItemShip:A
Item Fulfillment:Packed ItemShip:B
Item Fulfillment:Shipped ItemShip:C
- J -
Journal:Pending Approval Journal:A
Journal:Approved for Posting Journal:B
Journal:Rejected Journal:R
- N -
Netting Settlement: Pending Approval NettStlm:B
Netting Settlement: Approved NettStlm:A
- O -
Opportunity:In Progress Opprtnty:A
Opportunity:Issued Estimate Opprtnty:B
Opportunity:Closed - Won Opprtnty:C
Opportunity:Closed - Lost Opprtnty:D
- P -
Paycheck:Created Paycheck:A
Paycheck:Pending Tax Calculation Paycheck:C
Paycheck:Pending Commitment Paycheck:D
Paycheck:Committed Paycheck:F
Paycheck:Preview Paycheck:P
Paycheck:Reversed Paycheck:R
Paycheck:Error Paycheck:X
Payment:Unapproved Payment CustPymt:A
Payment:Not Deposited CustPymt:B
Payment:Deposited CustPymt:C
Payroll Liability Check:Voided LiabPymt:V
Period End Journal:Pending Approval PEJrnl:A
Period End Journal:Approved for Posting PEJrnl:B
Period End Journal:Rejected PEJrnl:R
Purchase Contract:Pending Approval PurchCon:A
Purchase Contract:Approved PurchCon:B
Purchase Contract:Closed PurchCon:H
Purchase Contract:Rejected PurchCon:R
Purchase Order:Pending Supervisor Approval PurchOrd:A
Purchase Order:Pending Receipt PurchOrd:B
Purchase Order:Rejected by Supervisor PurchOrd:C
Purchase Order:Partially Received PurchOrd:D
Purchase Order:Pending Billing/Partially Received PurchOrd:E
Purchase Order:Pending Bill PurchOrd:F
Purchase Order:Fully Billed PurchOrd:G
Purchase Order:Closed PurchOrd:H
Purchase Order:Planned PurchOrd:P
- R -
Request For Quote:Pending Bid Open Rfq:A
Request For Quote:Pending Rfq:B
Request For Quote:Cancelled Rfq:C
Request For Quote:Bid Open Rfq:D
Request For Quote:Bid Closed Rfq:E
Request For Quote:Partially Awarded Rfq:F
Request For Quote:Fully Awarded Rfq:G
Request For Quote:Closed Rfq:H
Requisition:Pending Approval PurchReq:A
Requisition:Pending Order PurchReq:B
Requisition:Cancelled PurchReq:C
Requisition:Partially Ordered PurchReq:D
Requisition:Fully Ordered PurchReq:E
Requisition:Partially Received PurchReq:F
Requisition:Fully Received PurchReq:G
Requisition:Closed PurchReq:H
Requisition:Rejected PurchReq:R
Return Authorization:Pending Approval RtnAuth:A
Return Authorization:Pending Receipt RtnAuth:B
Return Authorization:Cancelled RtnAuth:C
Return Authorization:Partially Received RtnAuth:D
Return Authorization:Pending Refund/Partially Received RtnAuth:E
Return Authorization:Pending Refund RtnAuth:F
Return Authorization:Refunded RtnAuth:G
Return Authorization:Closed RtnAuth:H
Revenue Arrangement:Pending Approval RevArrng:A
Revenue Arrangement:Approved RevArrng:B
Revenue Arrangement:Closed RevArrng:H
Revenue Arrangement:Rejected RevArrng:R
- S -
Sales Order:Pending Approval SalesOrd:A
Sales Order:Pending Fulfillment SalesOrd:B
Sales Order:Cancelled SalesOrd:C
Sales Order:Partially Fulfilled SalesOrd:D
Sales Order:Pending Billing/Partially Fulfilled SalesOrd:E
Sales Order:Pending Billing SalesOrd:F
Sales Order:Billed SalesOrd:G
Sales Order:Closed SalesOrd:H
Sales Tax Payment:Voided TaxPymt:V
Sales Tax Payment:Online Bill Pay Pending Accounting Approval TaxPymt:Z
Statement Charge:Open CustChrg:A
Statement Charge:Paid In Full CustChrg:B
Store Pickup Fulfillment:Picked StPickUp:A
Store Pickup Fulfillment:Picked Up StPickUp:B
Store Pickup Fulfillment:Cancelled StPickUp:C
- T -
Tax Liability Cheque:Voided TaxLiab:V
Tegata Payable:Endorsed TegPybl:E
Tegata Payable:Issued TegPybl:I
Tegata Payable:Paid TegPybl:P
Tegata Receivables:Collected TegRcvbl:C
Tegata Receivables:Discounted TegRcvbl:D
Tegata Receivables:Endorsed TegRcvbl:E
Tegata Receivables:Holding TegRcvbl:H
Tegata Receivables:Voided TegRcvbl:V
Transfer Order:Pending Approval TrnfrOrd:A
Transfer Order:Pending Fulfillment TrnfrOrd:B
Transfer Order:Rejected TrnfrOrd:C
Transfer Order:Partially Fulfilled TrnfrOrd:D
Transfer Order:Pending Receipt/Partially Fulfilled TrnfrOrd:E
Transfer Order:Pending Receipt TrnfrOrd:F
Transfer Order:Received TrnfrOrd:G
Transfer Order:Closed TrnfrOrd:H
- V -
Vendor Prepayment: Pending Approval VPrep:F
Vendor Prepayment: Paid VPrep:B
Vendor Prepayment: Partially Applied VPrep:E
Vendor Prepayment: Fully Applied VPrep:A
Vendor Prepayment: Rejected VPrep:R
Vendor Prepayment: Voided VPrep:V
Vendor Request For Quote:Pending Bid Open VendRfq:A
Vendor Request For Quote:Pending VendRfq:B
Vendor Request For Quote:Cancelled VendRfq:C
Vendor Request For Quote:Bid Open VendRfq:D
Vendor Request For Quote:Bid Closed VendRfq:E
Vendor Request For Quote:Partially Awarded VendRfq:F
Vendor Request For Quote:Fully Awarded VendRfq:G
Vendor Request For Quote:Closed VendRfq:H
Vendor Return Authorization:Pending Approval VendAuth:A
Vendor Return Authorization:Pending Return VendAuth:B
Vendor Return Authorization:Cancelled VendAuth:C
Vendor Return Authorization:Partially Returned VendAuth:D
Vendor Return Authorization:Pending Credit/Partially Returned VendAuth:E
Vendor Return Authorization:Pending Credit VendAuth:F
Vendor Return Authorization:Credited VendAuth:G
Vendor Return Authorization:Closed VendAuth:H
- W -
Wave:Pending Release Wave:A
Wave:Released Wave:B
Wave:In Progress Wave:C
Wave:Complete Wave:D
Work Order:Planned WorkOrd:A
Work Order:Released WorkOrd:B
Work Order:Cancelled WorkOrd:C
Work Order:In Process WorkOrd:D
Work Order:Built WorkOrd:G
Work Order:Closed WorkOrd:H

 

The following is a code snippet on how these statuses could be used as a search filter:

SuiteScript 1.0:

var filters = new Array();
filters[0] = new nlobjSearchFilter('status','applyingtransaction','noneof',['CashSale:C','CashSale:B','CustInvc:B']);
SuiteScript 2.0:
var filters = new Array();
filters.push(search.createFilter({
    name: "status",
    operator: search.Operator.ANYOF,
    values: ['CashSale:C', 'CashSale:B', 'CustInvc:B']
}));

 

Below data on @ 2017-08-29 21:07

Status SearchFilter
 Cash Sale:Unapproved Payment  CashSale:A
 Cash Sale:Not Deposited  CashSale:B
 Cash Sale:Deposited  CashSale:C
 Check:Voided  Check:V
 Check:Online Bill Pay Pending Accounting Approval  Check:Z
 Commission:Pending Payment  Commissn:A
 Commission:Overpaid  Commissn:O
 Commission:Pending Accounting Approval  Commissn:P
 Commission:Rejected by Accounting  Commissn:R
 Commission:Paid in Full  Commissn:X
 Statement Charge:Open  CustChrg:A
 Statement Charge:Paid In Full  CustChrg:B
 Credit Memo:Open  CustCred:A
 Credit Memo:Fully Applied  CustCred:B
 Customer Deposit:Not Deposited  CustDep:A
 Customer Deposit:Deposited  CustDep:B
 Customer Deposit:Fully Applied  CustDep:C
 Invoice:Open  CustInvc:A
 Invoice:Paid In Full  CustInvc:B
 Payment:Unapproved Payment  CustPymt:A
 Payment:Not Deposited  CustPymt:B
 Payment:Deposited  CustPymt:C
 Customer Refund:Voided  CustRfnd:V
 Quote:Open  Estimate:A
 Quote:Processed  Estimate:B
 Quote:Closed  Estimate:C
 Quote:Voided  Estimate:V
 Quote:Expired  Estimate:X
 Expense Report:In Progress  ExpRept:A
 Expense Report:Pending Supervisor Approval  ExpRept:B
 Expense Report:Pending Accounting Approval  ExpRept:C
 Expense Report:Rejected by Supervisor  ExpRept:D
 Expense Report:Rejected by Accounting  ExpRept:E
 Expense Report:Approved by Accounting  ExpRept:F
 Expense Report:Approved (Overridden) by Accounting  ExpRept:G
 Expense Report:Rejected (Overridden) by Accounting  ExpRept:H
 Expense Report:Paid In Full  ExpRept:I
 Inventory Count:Open  InvCount:A
 Inventory Count:Started  InvCount:B
 Inventory Count:Completed/Pending Approval  InvCount:C
 Inventory Count:Approved  InvCount:D
 Item Fulfillment:Picked  ItemShip:A
 Item Fulfillment:Packed  ItemShip:B
 Item Fulfillment:Shipped  ItemShip:C
 Journal:Pending Approval  Journal:A
 Journal:Approved for Posting  Journal:B
 Payroll Liability Check:Voided  LiabPymt:V
 Opportunity:In Progress  Opprtnty:A
 Opportunity:Issued Estimate  Opprtnty:B
 Opportunity:Closed – Won  Opprtnty:C
 Opportunity:Closed – Lost  Opprtnty:D
 Paycheck:Undefined  Paycheck:A
 Paycheck:Pending Tax Calculation  Paycheck:C
 Paycheck:Pending Commitment  Paycheck:D
 Paycheck:Committed  Paycheck:F
 Paycheck:Preview  Paycheck:P
 Paycheck:Reversed  Paycheck:R
 Purchase Order:Pending Supervisor Approval  PurchOrd:A
 Purchase Order:Pending Receipt  PurchOrd:B
 Purchase Order:Rejected by Supervisor  PurchOrd:C
 Purchase Order:Partially Received  PurchOrd:D
 Purchase Order:Pending Billing/Partially Received  PurchOrd:E
 Purchase Order:Pending Bill  PurchOrd:F
 Purchase Order:Fully Billed  PurchOrd:G
 Purchase Order:Closed  PurchOrd:H
 Return Authorization:Pending Approval  RtnAuth:A
 Return Authorization:Pending Receipt  RtnAuth:B
 Return Authorization:Cancelled  RtnAuth:C
 Return Authorization:Partially Received  RtnAuth:D
 Return Authorization:Pending Refund/Partially Received  RtnAuth:E
 Return Authorization:Pending Refund  RtnAuth:F
 Return Authorization:Refunded  RtnAuth:G
 Return Authorization:Closed  RtnAuth:H
 Sales Order:Pending Approval  SalesOrd:A
 Sales Order:Pending Fulfillment  SalesOrd:B
 Sales Order:Cancelled  SalesOrd:C
 Sales Order:Partially Fulfilled  SalesOrd:D
 Sales Order:Pending Billing/Partially Fulfilled  SalesOrd:E
 Sales Order:Pending Billing  SalesOrd:F
 Sales Order:Billed  SalesOrd:G
 Sales Order:Closed  SalesOrd:H
 Tax Liability Cheque:Voided  TaxLiab:V
 Sales Tax Payment:Voided  TaxPymt:V
 Sales Tax Payment:Online Bill Pay Pending Accounting Approval  TaxPymt:Z
 Tegata Payable:Endorsed  TegPybl:E
 Tegata Payable:Issued  TegPybl:I
 Tegata Payable:Paid  TegPybl:P
 Tegata Receivables:Collected  TegRcvbl:C
 Tegata Receivables:Discounted  TegRcvbl:D
 Tegata Receivables:Endorsed  TegRcvbl:E
 Tegata Receivables:Holding  TegRcvbl:H
 Transfer Order:Pending Approval  TrnfrOrd:A
 Transfer Order:Pending Fulfillment  TrnfrOrd:B
 Transfer Order:Rejected  TrnfrOrd:C
 Transfer Order:Partially Fulfilled  TrnfrOrd:D
 Transfer Order:Pending Receipt/Partially Fulfilled  TrnfrOrd:E
 Transfer Order:Pending Receipt  TrnfrOrd:F
 Transfer Order:Received  TrnfrOrd:G
 Transfer Order:Closed  TrnfrOrd:H
 Vendor Return Authorization:Pending Approval  VendAuth:A
 Vendor Return Authorization:Pending Return  VendAuth:B
 Vendor Return Authorization:Cancelled  VendAuth:C
 Vendor Return Authorization:Partially Returned  VendAuth:D
 Vendor Return Authorization:Pending Credit/Partially Returned  VendAuth:E
 Vendor Return Authorization:Pending Credit  VendAuth:F
 Vendor Return Authorization:Credited  VendAuth:G
 Vendor Return Authorization:Closed  VendAuth:H
 Bill:Open  VendBill:A
 Bill:Paid In Full  VendBill:B
 Bill:Cancelled  VendBill:C
 Bill:Pending Approval  VendBill:D
 Bill:Rejected  VendBill:E
 Cash Payment:Voided  VendPymt:V
 Cash Payment:Online Bill Pay Pending Accounting Approval  VendPymt:Z
 Work Order:Pending Build  WorkOrd:B
 Work Order:Cancelled  WorkOrd:C
 Work Order:In Process  WorkOrd:D
 Work Order:Built  WorkOrd:G
 Work Order:Closed  WorkOrd:H

 

 
posted @ 2017-08-29 21:07  CarlZeng  阅读(677)  评论(0)  编辑  收藏  举报