API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 21st, 2019
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.78 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. if substring(pt_mstr.pt_part,1,4) = "0805"
  3. and substring(pt_mstr.pt_part,15,3) <> "048"
  4. and pt_mstr.pt__dec01 >= 2
  5. and xptk_mstr.xptk_dec02 >= 600
  6. and string(xptk_mstr.xptk_tariff) = "7208400010"
  7. then all_txt = "OK".
  8. if substring(pt_mstr.pt_part,1,4) = "0805"
  9. and substring(pt_mstr.pt_part,15,3) <> "048"
  10. and pt_mstr.pt__dec01 < 2
  11. and xptk_mstr.xptk_dec02 >= 600
  12. and string(xptk_mstr.xptk_tariff) = "7208400090"
  13. then all_txt = "OK".
  14.  
  15. if substring(pt_mstr.pt_part,1,4) = "0806"
  16. and substring(pt_mstr.pt_part,15,3) <> "048"
  17. and pt_mstr.pt__dec01 >= 2
  18. and xptk_mstr.xptk_dec02 >= 600
  19. and string(xptk_mstr.xptk_tariff) = "7208400010"
  20. then all_txt = "OK".
  21. if substring(pt_mstr.pt_part,1,4) = "0806"
  22. and substring(pt_mstr.pt_part,15,3) <> "048"
  23. and pt_mstr.pt__dec01 < 2
  24. and xptk_mstr.xptk_dec02 >= 600
  25. and string(xptk_mstr.xptk_tariff) = "7208400090"
  26. then all_txt = "OK".
  27.  
  28. if substring(pt_mstr.pt_part,1,4) = "0807"
  29. and substring(pt_mstr.pt_part,15,3) <> "048"
  30. and pt_mstr.pt__dec01 >= 2
  31. and xptk_mstr.xptk_dec02 >= 600
  32. and string(xptk_mstr.xptk_tariff) = "7208400010"
  33. then all_txt = "OK".
  34. if substring(pt_mstr.pt_part,1,4) = "0807"
  35. and substring(pt_mstr.pt_part,15,3) <> "048"
  36. and pt_mstr.pt__dec01 < 2
  37. and xptk_mstr.xptk_dec02 >= 600
  38. and string(xptk_mstr.xptk_tariff) = "7208400090"
  39. then all_txt = "OK".
  40.  
  41. if substring(pt_mstr.pt_part,1,4) = "0900"
  42. and substring(pt_mstr.pt_part,15,3) <> "048"
  43. and substring(pt_mstr.pt_part,15,3) <> "051"
  44. and pt_mstr.pt__dec01 < 3
  45. and xptk_mstr.xptk_dec02 >= 600
  46. and string(xptk_mstr.xptk_tariff) = "7208540000"
  47. then all_txt = "OK".
  48. if substring(pt_mstr.pt_part,1,4) = "0900"
  49. and substring(pt_mstr.pt_part,15,3) <> "048"
  50. and substring(pt_mstr.pt_part,15,3) <> "051"
  51. and pt_mstr.pt__dec01 >= 3
  52. and pt_mstr.pt__dec01 < 4.75
  53. and xptk_mstr.xptk_dec02 >= 600
  54. and string(xptk_mstr.xptk_tariff) = "7208539000"
  55. then all_txt = "OK".
  56. if substring(pt_mstr.pt_part,1,4) = "0900"
  57. and substring(pt_mstr.pt_part,15,3) <> "048"
  58. and substring(pt_mstr.pt_part,15,3) <> "051"
  59. and pt_mstr.pt__dec01 >= 4.75
  60. and pt_mstr.pt__dec01 <= 10
  61. and xptk_mstr.xptk_dec02 >= 2050
  62. and string(xptk_mstr.xptk_tariff) = "7208529110"
  63. then all_txt = "OK".
  64. if substring(pt_mstr.pt_part,1,4) = "0900"
  65. and substring(pt_mstr.pt_part,15,3) <> "048"
  66. and substring(pt_mstr.pt_part,15,3) <> "051"
  67. and pt_mstr.pt__dec01 >= 4.75
  68. and pt_mstr.pt__dec01 <= 10
  69. and xptk_mstr.xptk_dec02 >= 600
  70. and xptk_mstr.xptk_dec02 < 2050
  71. and string(xptk_mstr.xptk_tariff) = "7208529900"
  72. then all_txt = "OK".
  73. if substring(pt_mstr.pt_part,1,4) = "0900"
  74. and substring(pt_mstr.pt_part,15,3) <> "048"
  75. and substring(pt_mstr.pt_part,15,3) <> "051"
  76. and pt_mstr.pt__dec01 > 10
  77. and pt_mstr.pt__dec01 <= 15
  78. and xptk_mstr.xptk_dec02 >= 2050
  79. and string(xptk_mstr.xptk_tariff) = "7208519110"
  80. then all_txt = "OK".
  81. if substring(pt_mstr.pt_part,1,4) = "0900"
  82. and substring(pt_mstr.pt_part,15,3) <> "048"
  83. and substring(pt_mstr.pt_part,15,3) <> "051"
  84. and pt_mstr.pt__dec01 > 10
  85. and pt_mstr.pt__dec01 <= 15
  86. and xptk_mstr.xptk_dec02 >= 600
  87. and xptk_mstr.xptk_dec02 < 2050
  88. and string(xptk_mstr.xptk_tariff) = "7208519810"
  89. then all_txt = "OK".
  90. if substring(pt_mstr.pt_part,1,4) = "0900"
  91. and substring(pt_mstr.pt_part,15,3) <> "048"
  92. and substring(pt_mstr.pt_part,15,3) <> "051"
  93. and pt_mstr.pt__dec01 > 15
  94. and xptk_mstr.xptk_dec02 >= 600
  95. and string(xptk_mstr.xptk_tariff) = "7208512010"
  96. then all_txt = "OK".
  97.  
  98. if substring(pt_mstr.pt_part,1,4) = "0900"
  99. and substring(pt_mstr.pt_part,15,3) <> "048"
  100. and substring(pt_mstr.pt_part,15,3) <> "051"
  101. and pt_mstr.pt__dec01 >= 4.75
  102. and xptk_mstr.xptk_dec02 > 500
  103. and string(xptk_mstr.xptk_tariff) = "7211140010"
  104. then all_txt = "OK".
  105. if substring(pt_mstr.pt_part,1,4) = "0900"
  106. and substring(pt_mstr.pt_part,15,3) <> "048"
  107. and substring(pt_mstr.pt_part,15,3) <> "051"
  108. and pt_mstr.pt__dec01 >= 4.75
  109. and xptk_mstr.xptk_dec02 <= 500
  110. and string(xptk_mstr.xptk_tariff) = "7211140090"
  111. then all_txt = "OK".
  112. if substring(pt_mstr.pt_part,1,4) = "0900"
  113. and substring(pt_mstr.pt_part,15,3) <> "048"
  114. and substring(pt_mstr.pt_part,15,3) <> "051"
  115. and pt_mstr.pt__dec01 < 4.75
  116. and xptk_mstr.xptk_dec02 > 500
  117. and string(xptk_mstr.xptk_tariff) = "7211190010"
  118. then all_txt = "OK".
  119. if substring(pt_mstr.pt_part,1,4) = "0900"
  120. and substring(pt_mstr.pt_part,15,3) <> "048"
  121. and substring(pt_mstr.pt_part,15,3) <> "051"
  122. and pt_mstr.pt__dec01 < 4.75
  123. and xptk_mstr.xptk_dec02 <= 500
  124. and string(xptk_mstr.xptk_tariff) = "7211190090"
  125. then all_txt = "OK".
  126.  
  127. if substring(pt_mstr.pt_part,1,4) = "0A00"
  128. and substring(pt_mstr.pt_part,15,3) <> "048"
  129. and substring(pt_mstr.pt_part,15,3) <> "051"
  130. and pt_mstr.pt__dec01 < 0.5
  131. and xptk_mstr.xptk_dec02 >= 600
  132. and string(xptk_mstr.xptk_tariff) = "7209289000"
  133. then all_txt = "OK".
  134. if substring(pt_mstr.pt_part,1,4) = "0A00"
  135. and substring(pt_mstr.pt_part,15,3) <> "048"
  136. and substring(pt_mstr.pt_part,15,3) <> "051"
  137. and pt_mstr.pt__dec01 >= 0.5
  138. and pt_mstr.pt__dec01 <= 1
  139. and xptk_mstr.xptk_dec02 >= 600
  140. and string(xptk_mstr.xptk_tariff) = "7209279000"
  141. then all_txt = "OK".
  142. if substring(pt_mstr.pt_part,1,4) = "0A00"
  143. and substring(pt_mstr.pt_part,15,3) <> "048"
  144. and substring(pt_mstr.pt_part,15,3) <> "051"
  145. and pt_mstr.pt__dec01 > 1
  146. and pt_mstr.pt__dec01 < 3
  147. and xptk_mstr.xptk_dec02 >= 600
  148. and string(xptk_mstr.xptk_tariff) = "7209269000"
  149. then all_txt = "OK".
  150. if substring(pt_mstr.pt_part,1,4) = "0A00"
  151. and substring(pt_mstr.pt_part,15,3) <> "048"
  152. and substring(pt_mstr.pt_part,15,3) <> "051"
  153. and pt_mstr.pt__dec01 >= 3
  154. and xptk_mstr.xptk_dec02 >= 600
  155. and string(xptk_mstr.xptk_tariff) = "7209250090"
  156. then all_txt = "OK".
  157.  
  158. if substring(pt_mstr.pt_part,1,4) = "0A00"
  159. and substring(pt_mstr.pt_part,15,3) <> "048"
  160. and substring(pt_mstr.pt_part,15,3) <> "051"
  161. and pt_mstr.pt__dec01 >= 0.35
  162. and xptk_mstr.xptk_dec02 < 600
  163. and xptk_mstr.xptk_dec02 > 500
  164. and string(xptk_mstr.xptk_tariff) = "7211233010"
  165. then all_txt = "OK".
  166. if substring(pt_mstr.pt_part,1,4) = "0A00"
  167. and substring(pt_mstr.pt_part,15,3) <> "048"
  168. and substring(pt_mstr.pt_part,15,3) <> "051"
  169. and pt_mstr.pt__dec01 >= 0.35
  170. and xptk_mstr.xptk_dec02 < 600
  171. and xptk_mstr.xptk_dec02 <= 500
  172. and string(xptk_mstr.xptk_tariff) = "7211233099"
  173. then all_txt = "OK".
  174. if substring(pt_mstr.pt_part,1,4) = "0A00"
  175. and substring(pt_mstr.pt_part,15,3) <> "048"
  176. and substring(pt_mstr.pt_part,15,3) <> "051"
  177. and pt_mstr.pt__dec01 < 0.35
  178. and xptk_mstr.xptk_dec02 < 600
  179. and xptk_mstr.xptk_dec02 > 500
  180. and string(xptk_mstr.xptk_tariff) = "7211238011"
  181. then all_txt = "OK".
  182. if substring(pt_mstr.pt_part,1,4) = "0A00"
  183. and substring(pt_mstr.pt_part,15,3) <> "048"
  184. and substring(pt_mstr.pt_part,15,3) <> "051"
  185. and pt_mstr.pt__dec01 < 0.35
  186. and xptk_mstr.xptk_dec02 < 600
  187. and xptk_mstr.xptk_dec02 <= 500
  188. and string(xptk_mstr.xptk_tariff) = "7211238099"
  189. then all_txt = "OK".
  190.  
  191. if substring(pt_mstr.pt_part,1,4) = "0A00"
  192. and substring(pt_mstr.pt_part,15,3) = "051"
  193. and xptk_mstr.xptk_dec02 > 600
  194. and string(xptk_mstr.xptk_tariff) = "7225508000"
  195. then all_txt = "OK".*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!