Pesquisando por Status no NetSuite

Introdução

Ao usar uma atividade de pesquisa do NetSuite para pesquisar objetos NetSuite com base em um status específico, será necessário especificar o valor correto do filtro de pesquisa que corresponde ao status desejado. Você pode determinar o valor do filtro de pesquisa correspondente conforme fornecido no Status da transação do NetSuite tabela abaixo.

Exemplo

Por exemplo, se você deseja que os critérios de pesquisa limitem o ItemFulfillment registros para apenas aqueles onde o Ship Status = Shipped, em vez de usar a enumeração para Enviado (_shipped), você realmente precisaria usar o valor a de ItemShip:C conforme tabela abaixo.

Esta captura de tela mostra como isso seria configurado usando uma atividade de pesquisa do NetSuite:

anexo

Traduções semelhantes se aplicam a uma variedade de objetos NetSuite.

Status da Transação NetSuite

Estado	Valor da pesquisa
`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`

Fonte: NetSuite SearchFilter Transaction Internal Status List