Ana Sayfa Keşfet Yardım
Üye Ol Giriş Yap
GlobalCube
/
C11
3
0
Çatalla 0
Dosyalar Sorunlar 0 Değişiklik İstekleri 0 Wiki
Ağaç: 32c810b5db
Dallar Biçim İmleri
C11
/
System
/
NAVISION
/
IQD
/
OP
/
forderungen_nav_naga.iqd

forderungen_nav_naga.iqd 85 KB
Geçmiş Ham

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176 
  1. COGNOS QUERY
    2. 

  2. STRUCTURE,1,1
    3. 

  3. DATABASE,GC_Navision
    4. 

  4. DATASOURCENAME,C:\GlobalCube\System\NAVISION\IQD\op\forderungen_nav_naga.imr
    5. 

  5. TITLE,forderungen_nav_naga.imr
    6. 

  6. BEGIN SQL
    7. 

  7. select distinct T1."No_" as c1,
    8. 

  8. 	   T1."Name" as c2,
    9. 

  9. 	   T1."Search Name" as c3,
    10. 

  10. 	   T1."Name 2" as c4,
    11. 

  11. 	   T1."Address" as c5,
    12. 

  12. 	   T1."Address 2" as c6,
    13. 

  13. 	   T1."City" as c7,
    14. 

  14. 	   T1."Contact" as c8,
    15. 

  15. 	   T1."Phone No_" as c9,
    16. 

  16. 	   T1."Telex No_" as c10,
    17. 

  17. 	   T1."Our Account No_" as c11,
    18. 

  18. 	   T2."Entry No_" as c12,
    19. 

  19. 	   T2."Customer No_" as c13,
    20. 

  20. 	   T2."Posting Date" as c14,
    21. 

  21. 	   T2."Document Type" as c15,
    22. 

  22. 	   T2."Document No_" as c16,
    23. 

  23. 	   T2."Description" as c17,
    24. 

  24. 	   T2."Currency Code" as c18,
    25. 

  25. 	   T2."Sell-to Customer No_" as c19,
    26. 

  26. 	   T2."Customer Posting Group" as c20,
    27. 

  27. 	   T2."Department Code" as c21,
    28. 

  28. 	   T2."Make Code" as c22,
    29. 

  29. 	   T2."Salesperson Code" as c23,
    30. 

  30. 	   T2."User ID" as c24,
    31. 

  31. 	   T2."Source Code" as c25,
    32. 

  32. 	   T2."On Hold" as c26,
    33. 

  33. 	   T2."Applies-to Doc_ Type" as c27,
    34. 

  34. 	   T2."Applies-to Doc_ No_" as c28,
    35. 

  35. 	   T2."Open" as c29,
    36. 

  36. 	   T2."Due Date" as c30,
    37. 

  37. 	   T2."Pmt_ Discount Date" as c31,
    38. 

  38. 	   T2."Positive" as c32,
    39. 

  39. 	   T2."Closed by Entry No_" as c33,
    40. 

  40. 	   T2."Closed at Date" as c34,
    41. 

  41. 	   T2."Applies-to ID" as c35,
    42. 

  42. 	   T2."Journal Batch Name" as c36,
    43. 

  43. 	   T2."Reason Code" as c37,
    44. 

  44. 	   T2."Bal_ Account Type" as c38,
    45. 

  45. 	   T2."Bal_ Account No_" as c39,
    46. 

  46. 	   T2."Transaction No_" as c40,
    47. 

  47. 	   T2."Document Date" as c41,
    48. 

  48. 	   T2."External Document No_" as c42,
    49. 

  49. 	   T2."Calculate Interest" as c43,
    50. 

  50. 	   T2."Closing Interest Calculated" as c44,
    51. 

  51. 	   T2."No_ Series" as c45,
    52. 

  52. 	   T2."Closed by Currency Code" as c46,
    53. 

  53. 	   T2."Customer Group Code" as c47,
    54. 

  54. 	   T2."Branch Code" as c48,
    55. 

  55. 	   T2."Main Area" as c49,
    56. 

  56. 	   T2."VIN" as c50,
    57. 

  57. 	   T2."Cash Reg_ Receipt No_" as c51,
    58. 

  58. 	   T2."Comment" as c52,
    59. 

  59. 	   T2."Is Vehicle" as c53,
    60. 

  60. 	   T2."Bulk Customer No_" as c54,
    61. 

  61. 	   T2."Bulkcust_ Business" as c55,
    62. 

  62. 	   T2."Book No_" as c56,
    63. 

  63. 	   T2."No_ of Bulk Customer" as c57,
    64. 

  64. 	   T3."Code" as c58,
    65. 

  65. 	   T3."Name" as c59,
    66. 

  66. 	   T3."Consolidation Code" as c60,
    67. 

  67. 	   'Forderungen' as c61,
    68. 

  68. 	   'Kundenforderungen' as c62,
    69. 

  69. 	   T4."Code" as c63,
    70. 

  70. 	   T4."Name" as c64,
    71. 

  71. 	   CASE WHEN ((substring(T5."Department Code" from 3 for 1)) = '1') THEN ('NA') WHEN ((substring(T5."Department Code" from 3 for 1)) = '2') THEN ('GA') WHEN ((substring(T5."Department Code" from 3 for 1)) = '4') THEN ('SC') WHEN ((substring(T5."Department Code" from 3 for 1)) = '5') THEN ('T&Z') ELSE ('NA/GA') END as c65,
    72. 

  72. 	   (cast_float(T2."Remaining Amount")) as c66,
    73. 

  73. 	   CASE WHEN (((CASE WHEN ((substring(T5."Department Code" from 3 for 1)) = '1') THEN ('NA') WHEN ((substring(T5."Department Code" from 3 for 1)) = '2') THEN ('GA') WHEN ((substring(T5."Department Code" from 3 for 1)) = '4') THEN ('SC') WHEN ((substring(T5."Department Code" from 3 for 1)) = '5') THEN ('T&Z') ELSE ('NA/GA') END) = 'SC') and (T1."No_" IN ('001490','001491'))) THEN ('GWL-Forderungen') WHEN (((CASE WHEN ((substring(T5."Department Code" from 3 for 1)) = '1') THEN ('NA') WHEN ((substring(T5."Department Code" from 3 for 1)) = '2') THEN ('GA') WHEN ((substring(T5."Department Code" from 3 for 1)) = '4') THEN ('SC') WHEN ((substring(T5."Department Code" from 3 for 1)) = '5') THEN ('T&Z') ELSE ('NA/GA') END) = 'SC') and (not T1."No_" IN ('001490','001491'))) THEN ('KD-Forderungen') ELSE null END as c67,
    74. 

  74. 	   CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END as c68,
    75. 

  75. 	   T2."Due Date" as c69,
    76. 

  76. 	   CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END as c70,
    77. 

  77. 	   (CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END) as c71,
    78. 

  78. 	   (now()) as c72,
    79. 

  79. 	   (extract(DAY FROM ((now())) - T2."Due Date")) as c73,
    80. 

  80. 	   CASE WHEN (((extract(DAY FROM ((now())) - T2."Due Date"))) > 42) THEN ('älter 6 Wochen') WHEN (((extract(DAY FROM ((now())) - T2."Due Date"))) BETWEEN 29 AND 42) THEN ('4 - 6 Wochen') WHEN (((extract(DAY FROM ((now())) - T2."Due Date"))) BETWEEN 22 AND 28) THEN ('3 - 4 Wochen') WHEN (((extract(DAY FROM ((now())) - T2."Due Date"))) BETWEEN 15 AND 21) THEN ('2 - 3 Wochen') WHEN (((extract(DAY FROM ((now())) - T2."Due Date"))) BETWEEN 0 AND 14) THEN ('0 - 2 Wochen') ELSE ('noch nicht fällig') END as c74,
    81. 

  81. 	   CASE WHEN ((T2."Salesperson Code" <> '') and (T4."Code" <> '')) THEN (T2."Salesperson Code" || ' - ' || T4."Name") ELSE ('n.N.') END as c75,
    82. 

  82. 	   CASE WHEN (T1."No_" IN ('690101','690102','690103','690104','690105')) THEN (T2."Document No_" || ' - ' || T2."Description" || ' - ' || (asciiz(extract(YEAR FROM T2."Document Date"),4) || '-' || asciiz(extract(MONTH FROM T2."Document Date"),2) || '-' || asciiz(extract(DAY FROM T2."Document Date"),2)) || ' / ' || (CASE WHEN ((T2."Salesperson Code" <> '') and (T4."Code" <> '')) THEN (T2."Salesperson Code" || ' - ' || T4."Name") ELSE ('n.N.') END)) ELSE (T2."Document No_" || ' - ' || T1."Name" || ' - ' || (asciiz(extract(YEAR FROM T2."Document Date"),4) || '-' || asciiz(extract(MONTH FROM T2."Document Date"),2) || '-' || asciiz(extract(DAY FROM T2."Document Date"),2)) || ' / ' || (CASE WHEN ((T2."Salesperson Code" <> '') and (T4."Code" <> '')) THEN (T2."Salesperson Code" || ' - ' || T4."Name") ELSE ('n.N.') END)) END as c76,
    83. 

  83. 	   T5."Department Code" as c77,
    84. 

  84. 	   CASE WHEN (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G')) THEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END))) ELSE null END as c78,
    85. 

  85. 	   T2."Client_DB" as c79,
    86. 

  86. 	   CASE WHEN (T2."Client_DB" = '1') THEN ('AHR') WHEN (T2."Client_DB" = '2') THEN ('AAM') ELSE null END as c80,
    87. 

  87. 	   (CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END) as c81,
    88. 

  88. 	   CASE WHEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END)) IN ('10')) THEN ('MM') WHEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END)) IN ('30')) THEN ('KRU') WHEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END)) IN ('40')) THEN ('ULM') WHEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END)) IN ('50')) THEN ('LL') WHEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END)) IN ('55')) THEN ('GZ') WHEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END)) IN ('60')) THEN ('AAM') WHEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END)) IN ('70')) THEN ('LEH') WHEN (((CASE WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '1') THEN ('10') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '2') THEN ('20') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '3') THEN ('30') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '4') THEN ('40') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '5') THEN ('50') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '9') THEN ('55') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '6') THEN ('60') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '7') THEN ('70') WHEN ((CASE WHEN (((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (((T2."Document No_" LIKE 'VRGF%') or (T2."Document No_" LIKE 'VGGF%')) and (not T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 7 for 1))) WHEN ((((T2."Document No_" LIKE 'VRGFG%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) and (T2."No_ Series" IN ('VKGUT-FZ-G','VKRGG-FZ-G'))) THEN ((substring(T2."Document No_" from 8 for 1))) WHEN (T2."Document No_" LIKE 'VRF%') THEN ((substring(T2."Document No_" from 6 for 1))) ELSE null END) = '8') THEN ('80') ELSE null END)) IN ('80')) THEN ('WTB') ELSE null END as c82
    89. 

  89. from (((("NAVISION"."import"."Customer_Ledger_Entry" T2 left outer join "NAVISION"."import"."Customer" T1 on (T1."No_" = T2."Customer No_") and (T1."Client_DB" = T2."Client_DB")) left outer join "NAVISION"."import"."Department" T3 on (T2."Department Code" = T3."Code") and (T2."Client_DB" = T3."Client_DB")) left outer join "NAVISION"."import"."Salesperson_Purchaser" T4 on (T2."Salesperson Code" = T4."Code") and (T2."Client_DB" = T4."Client_DB")) left outer join "NAVISION"."import"."Vehicle_Ledger_Entry" T5 on (T2."Document No_" = T5."Document No_") and (T2."Client_DB" = T5."Client_DB"))
    90. 

  90. where ((((((cast_float(T2."Remaining Amount"))) <> 0) and (T2."Journal Batch Name" <> 'ERSTIMPORT')) and (not T1."No_" LIKE '600%')) and ((((((T2."Document No_" LIKE 'VRGGFZ%') or (T2."Document No_" LIKE 'VGUGFZ%')) or (T2."Document No_" LIKE 'ERGGFZ%')) or (T2."Document No_" LIKE 'VRGF%')) or (T2."Document No_" LIKE 'VRF%')) or (T2."Document No_" LIKE 'VGGF%')))
    91. 

  91. order by c14 asc
    92. 

  92. 

  93. END SQL
    94. 

  94. COLUMN,0,No
    95. 

  95. COLUMN,1,Name
    96. 

  96. COLUMN,2,Search Name
    97. 

  97. COLUMN,3,Name 2
    98. 

  98. COLUMN,4,Address
    99. 

  99. COLUMN,5,Address 2
    100. 

  100. COLUMN,6,City
    101. 

  101. COLUMN,7,Contact
    102. 

  102. COLUMN,8,Phone No
    103. 

  103. COLUMN,9,Telex No
    104. 

  104. COLUMN,10,Our Account No
    105. 

  105. COLUMN,11,Entry No
    106. 

  106. COLUMN,12,Customer No
    107. 

  107. COLUMN,13,Posting Date
    108. 

  108. COLUMN,14,Document Type
    109. 

  109. COLUMN,15,Document No
    110. 

  110. COLUMN,16,Description
    111. 

  111. COLUMN,17,Currency Code
    112. 

  112. COLUMN,18,Sell-to Customer No
    113. 

  113. COLUMN,19,Customer Posting Group
    114. 

  114. COLUMN,20,Department Code
    115. 

  115. COLUMN,21,Make Code
    116. 

  116. COLUMN,22,Salesperson Code
    117. 

  117. COLUMN,23,User Id
    118. 

  118. COLUMN,24,Source Code
    119. 

  119. COLUMN,25,On Hold
    120. 

  120. COLUMN,26,Applies-to Doc Type
    121. 

  121. COLUMN,27,Applies-to Doc No
    122. 

  122. COLUMN,28,Open
    123. 

  123. COLUMN,29,Due Date
    124. 

  124. COLUMN,30,Pmt Discount Date
    125. 

  125. COLUMN,31,Positive
    126. 

  126. COLUMN,32,Closed By Entry No
    127. 

  127. COLUMN,33,Closed At Date
    128. 

  128. COLUMN,34,Applies-to Id
    129. 

  129. COLUMN,35,Journal Batch Name
    130. 

  130. COLUMN,36,Reason Code
    131. 

  131. COLUMN,37,Bal Account Type
    132. 

  132. COLUMN,38,Bal Account No
    133. 

  133. COLUMN,39,Transaction No
    134. 

  134. COLUMN,40,Document Date
    135. 

  135. COLUMN,41,External Document No
    136. 

  136. COLUMN,42,Calculate Interest
    137. 

  137. COLUMN,43,Closing Interest Calculated
    138. 

  138. COLUMN,44,No Series
    139. 

  139. COLUMN,45,Closed By Currency Code
    140. 

  140. COLUMN,46,Customer Group Code
    141. 

  141. COLUMN,47,Branch Code
    142. 

  142. COLUMN,48,Main Area
    143. 

  143. COLUMN,49,Vin
    144. 

  144. COLUMN,50,Cash Reg Receipt No
    145. 

  145. COLUMN,51,Comment
    146. 

  146. COLUMN,52,Is Vehicle
    147. 

  147. COLUMN,53,Bulk Customer No
    148. 

  148. COLUMN,54,Bulkcust Business
    149. 

  149. COLUMN,55,Book No
    150. 

  150. COLUMN,56,No Of Bulk Customer
    151. 

  151. COLUMN,57,Code
    152. 

  152. COLUMN,58,Name
    153. 

  153. COLUMN,59,Consolidation Code
    154. 

  154. COLUMN,60,Stufe 1
    155. 

  155. COLUMN,61,Stufe 2
    156. 

  156. COLUMN,62,Code
    157. 

  157. COLUMN,63,Name
    158. 

  158. COLUMN,64,Stufe 3
    159. 

  159. COLUMN,65,Remaining_Amount
    160. 

  160. COLUMN,66,Stufe 5
    161. 

  161. COLUMN,67,Betrieb Nr
    162. 

  162. COLUMN,68,Fälligkeitsdatum
    163. 

  163. COLUMN,69,Doc_Nr_Stelle_2
    164. 

  164. COLUMN,70,Stufe 4_alt
    165. 

  165. COLUMN,71,Heute
    166. 

  166. COLUMN,72,Tage
    167. 

  167. COLUMN,73,Staffel
    168. 

  168. COLUMN,74,Verursacher
    169. 

  169. COLUMN,75,Beleg
    170. 

  170. COLUMN,76,Department Code_VEH_ledger_entry
    171. 

  171. COLUMN,77,Stufe 4
    172. 

  172. COLUMN,78,Hauptbetrieb_ID
    173. 

  173. COLUMN,79,Hauptbetrieb_Name
    174. 

  174. COLUMN,80,Standort_ID
    175. 

  175. COLUMN,81,Standort_Name
    176. 

  176.