Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. var transactionSearchObj = search.create({
  2. type: "transaction",
  3. filters: [
  4. ["name","anyof","375"],
  5. "AND",
  6. ["trandate","within","8/9/2017","8/13/2017"],
  7. "AND",
  8. ["creditamount","isnotempty",""]
  9. ],
  10. columns: [
  11. search.createColumn({
  12. name: "trandate",
  13. sort: search.Sort.ASC
  14. }),
  15. "type",
  16. "tranid",
  17. "entity",
  18. "account",
  19. "statusref",
  20. "creditamount",
  21. "total",
  22. "externalrefnumber",
  23. "otherrefnum",
  24. search.createColumn({
  25. name: "originator",
  26. join: "billingTransaction"
  27. }),
  28. "applyingtransaction",
  29. "appliedtotransaction",
  30. "internalid",
  31. "externalrefnumber",
  32. "externalid",
  33. search.createColumn({
  34. name: "appliedtotransaction",
  35. join: "applyingTransaction"
  36. }),
  37. search.createColumn({
  38. name: "appliedtotransaction",
  39. join: "appliedToTransaction"
  40. }),
  41. search.createColumn({
  42. name: "transactionnumber",
  43. join: "billingTransaction"
  44. })
  45. ]
  46. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement