netsuite nlobjSearchFilter anyof noneof ,order状态列表,transaction类型-CarlZeng
var trnTypeAR = [‘Build’,’VendBill’,’InvAdjst’,’InvTrnfr’,’ItemRcpt’,’Journal’];sFilters[filterBase+2] = new nlobjSearchFilter(‘type’,null,’anyof’,trnTypeAR,null);anyof noneof 就是这么应用的. 是比较实用的功能,以及orde…
var trnTypeAR = [‘Build’,’VendBill’,’InvAdjst’,’InvTrnfr’,’ItemRcpt’,’Journal’];
sFilters[filterBase+2] = new nlobjSearchFilter(‘type’,null,’anyof’,trnTypeAR,null);
anyof noneof 就是这么应用的. 是比较实用的功能,
以及order状态列表
var dd = win.makeMultiDropdown(‘Transaction_STATUS’, 8, new Array(‘Bill:Open’, ‘VendBill:A’, ‘Bill:Paid In Full’, ‘VendBill:B’, ‘Bill Payment:Voided’, ‘VendPymt:V’, ‘Bill Payment:Online Bill Pay Pending Accounting Approval’, ‘VendPymt:Z’, ‘Cash Sale:Unapproved Payment’, ‘CashSale:A’, ‘Cash Sale:Not Deposited’, ‘CashSale:B’, ‘Cash Sale:Deposited’, ‘CashSale:C’, ‘Cheque:Voided’, ‘Check:V’, ‘Cheque: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’, ‘Customer Deposit:Not Deposited’, ‘CustDep:A’, ‘Customer Deposit:Deposited’, ‘CustDep:B’, ‘Customer Deposit:Fully Applied’, ‘CustDep:C’, ‘Customer Refund:Voided’, ‘CustRfnd:V’,
‘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’, ‘Invoice:Open’, ‘CustInvc:A’, ‘Invoice:Paid In Full’, ‘CustInvc:B’, ‘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’, ‘Opportunity:In Progress’, ‘Opprtnty:A’, ‘Opportunity:Issued Estimate’, ‘Opprtnty:B’,
‘Opportunity:Closed - Won’, ‘Opprtnty:C’, ‘Opportunity:Closed - Lost’, ‘Opprtnty:D’, ‘Paycheque:Undefined’, ‘Paycheck:A’, ‘Paycheque:Pending Tax Calculation’, ‘Paycheck:C’, ‘Paycheque:Pending Commitment’, ‘Paycheck:D’, ‘Paycheque:Committed’, ‘Paycheck:F’, ‘Paycheque:Preview’, ‘Paycheck:P’, ‘Paycheque:Reversed’, ‘Paycheck:R’, ‘Payment:Unapproved Payment’, ‘CustPymt:A’, ‘Payment:Not Deposited’, ‘CustPymt:B’, ‘Payment:Deposited’, ‘CustPymt:C’, ‘Payroll Liability Cheque:Voided’, ‘LiabPymt:V’, ‘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 Authorisation:Pending Approval’, ‘RtnAuth:A’, ‘Return Authorisation:Pending Receipt’, ‘RtnAuth:B’,
‘Return Authorisation:Cancelled’, ‘RtnAuth:C’, ‘Return Authorisation:Partially Received’, ‘RtnAuth:D’, ‘Return Authorisation:Pending Refund/Partially Received’, ‘RtnAuth:E’, ‘Return Authorisation:Pending Refund’, ‘RtnAuth:F’, ‘Return Authorisation:Refunded’, ‘RtnAuth:G’, ‘Return Authorisation: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’, ‘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’, ‘Tax Liability Cheque:Voided’, ‘TaxLiab:V’, ‘Tegata Payable:Endorsed’, ‘TegPybl:E’, ‘Tegata Payable:Issued’, ‘TegPybl:I’,
‘Tegata Payable:Paid’, ‘TegPybl:P’, ‘Tegata Receivable:Collected’, ‘TegRcvbl:C’, ‘Tegata Receivable:Discounted’, ‘TegRcvbl:D’, ‘Tegata Receivable:Endorsed’, ‘TegRcvbl:E’, ‘Tegata Receivable:Holding’, ‘TegRcvbl: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’, ‘Work Order:Pending Build’, ‘WorkOrd:B’, ‘Work Order:Cancelled’, ‘WorkOrd:C’, ‘Work Order:Partially Built’, ‘WorkOrd:D’, ‘Work Order:Built’, ‘WorkOrd:G’, ‘Work Order:Closed’, ‘WorkOrd:H’), “”,”setWindowChanged(window, true);”,document,0,null,300);
所有系统transaction 状态 如下所示，netsuite将单据的状态分类到上没有的类型。
以及 transaction类型 如 ‘Return Authorisation 那么 他的列表 比如nlobjSearchFilter 必须使用RtnAuth 表示！
在举例：’Expense Report’ 值就是 ExpRept， 其他类似递推。。
