Guest User

Untitled

a guest
Jan 22nd, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. +----------+-----------+-------+---------+
  2. | Customer | Territory | Date | Invoice |
  3. +----------+-----------+-------+---------+
  4. | CU1 | A3 | Date1 | I1 |
  5. | CU2 | B2 | Date2 | I2 |
  6. | CU1 | A3 | Date3 | I3 |
  7. +----------+-----------+-------+---------+
  8.  
  9. +-----------+--------+
  10. | Territory | Parent |
  11. +-----------+--------+
  12. | A1 | A1 |
  13. | A2 | A1 |
  14. | A2 | A2 |
  15. | A3 | A1 |
  16. | A3 | A2 |
  17. | A3 | A3 |
  18. +-----------+--------+
  19.  
  20. SP.Territory = View.Territory
  21.  
  22. @TerritoryParam = View.Parent
  23.  
  24. +----------+-----------+-------+---------+
  25. | Customer | Territory | Date | Invoice |
  26. +----------+-----------+-------+---------+
  27. | CU1 | A3 | Date1 | I1 |
  28. | CU1 | A3 | Date1 | I1 |
  29. | CU1 | A3 | Date1 | I1 |
  30. | CU1 | A3 | Date3 | I3 |
  31. | CU1 | A3 | Date3 | I3 |
  32. | CU1 | A3 | Date3 | I3 |
  33. +----------+-----------+-------+---------+
Add Comment
Please, Sign In to add comment