API tools faq
paste
Guest User

Untitled

a guest
Jan 14th, 2018
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 61.21 KB | None | 0 0
raw download clone embed print report
  1. select t.RuleId,t.DocumentId,RDocuments.id from
  2. (
  3. SELECT 2 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_001_6_01_1) +  dbo.GetDecimal(RGA1_02_002_6_01_2) + dbo.GetDecimal(RGA1_02_003_6_01_3) = dbo.GetDecimal(RGA1_02_004_6_01_4))
  4. UNION ALL
  5. SELECT 3 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_004_6_01_4) >= dbo.GetDecimal(RGA1_02_005_6_01_5))
  6. UNION ALL
  7. SELECT 6 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_006_6_02_1) + dbo.GetDecimal(RGA1_02_007_6_02_2) + dbo.GetDecimal(RGA1_02_008_6_02_3) = dbo.GetDecimal(RGA1_02_009_6_02_4))
  8. UNION ALL
  9. SELECT 7 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_009_6_02_4) >=  dbo.GetDecimal(RGA1_02_010_6_02_5))
  10. UNION ALL
  11. SELECT 8 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_014_6_03_4) >=   dbo.GetDecimal(RGA1_02_015_6_03_5))
  12. UNION ALL
  13. SELECT 9 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_016_6_04_1) +  dbo.GetDecimal(RGA1_02_017_6_04_2) + dbo.GetDecimal(RGA1_02_018_6_04_3) = dbo.GetDecimal(RGA1_02_019_6_04_4))
  14. UNION ALL
  15. SELECT 10 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_011_6_03_1) + dbo.GetDecimal(RGA1_02_012_6_03_2) + dbo.GetDecimal(RGA1_02_013_6_03_3) = dbo.GetDecimal(RGA1_02_014_6_03_4))
  16. UNION ALL
  17. SELECT 11 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_021_6_05_1) +  dbo.GetDecimal(RGA1_02_022_6_05_2) + dbo.GetDecimal(RGA1_02_023_6_05_3) = dbo.GetDecimal(RGA1_02_024_6_05_4))
  18. UNION ALL
  19. SELECT 12 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_019_6_04_4) >=   dbo.GetDecimal(RGA1_02_020_6_04_5))
  20. UNION ALL
  21. SELECT 13 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_024_6_05_4) >=   dbo.GetDecimal(RGA1_02_025_6_05_5))
  22. UNION ALL
  23. SELECT 14 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_001_6_01_1) + dbo.GetDecimal(RGA1_02_006_6_02_1) + dbo.GetDecimal(RGA1_02_011_6_03_1)= dbo.GetDecimal(RGA1_02_016_6_04_1))
  24. UNION ALL
  25. SELECT 15 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_002_6_01_2) + dbo.GetDecimal(RGA1_02_007_6_02_2) + dbo.GetDecimal(RGA1_02_012_6_03_2)= dbo.GetDecimal(RGA1_02_017_6_04_2))
  26. UNION ALL
  27. SELECT 16 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_003_6_01_3) + dbo.GetDecimal(RGA1_02_008_6_02_3) + dbo.GetDecimal(RGA1_02_013_6_03_3)= dbo.GetDecimal(RGA1_02_018_6_04_3))
  28. UNION ALL
  29. SELECT 17 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_004_6_01_4) + dbo.GetDecimal(RGA1_02_009_6_02_4) + dbo.GetDecimal(RGA1_02_014_6_03_4)= dbo.GetDecimal(RGA1_02_019_6_04_4))
  30. UNION ALL
  31. SELECT 18 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_005_6_01_5) + dbo.GetDecimal(RGA1_02_010_6_02_5) + dbo.GetDecimal(RGA1_02_015_6_03_5)= dbo.GetDecimal(RGA1_02_020_6_04_5))
  32. UNION ALL
  33. SELECT 19 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_06_006_12_77_2)/100  + dbo.GetDecimal(RGA1_06_005_12_77_1) =dbo.GetDecimal(RGA1_02_019_6_04_4))
  34. UNION ALL
  35. SELECT 20 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_039_11_67_2)/100 + dbo.GetDecimal(RGA1_05_037_10_66_2)/100 +  dbo.GetDecimal(RGA1_05_036_10_66_1) +      dbo.GetDecimal(RGA1_05_038_11_67_1) =dbo.GetDecimal(RGA1_02_019_6_04_4))
  36. UNION ALL
  37. SELECT 21 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_037_10_66_2)/100 +  dbo.GetDecimal(RGA1_05_036_10_66_1) =dbo.GetDecimal(RGA1_02_020_6_04_5))
  38. UNION ALL
  39. SELECT 22 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_04_009_7_40_1) + dbo.GetDecimal(RGA1_04_010_7_40_2)/100 + dbo.GetDecimal(RGA1_04_011_8_41_1)  + dbo.GetDecimal(RGA1_05_033_9_65_1) + dbo.GetDecimal(RGA1_05_035_9_65_5)/100 = dbo.GetDecimal(RGA1_02_020_6_04_5))
  40. UNION ALL
  41. SELECT 23 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_019_6_04_4) - (dbo.GetDecimal(RGA1_05_039_11_67_2)/100 + dbo.GetDecimal(RGA1_05_038_11_67_1)) =dbo.GetDecimal(RGA1_02_020_6_04_5))
  42. UNION ALL
  43. SELECT 24 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_03_038_7_31_1) = dbo.GetDecimal(RGA1_02_026_7_01_1) + dbo.GetDecimal(RGA1_02_028_7_02_1) + dbo.GetDecimal(RGA1_02_030_7_03_1) + dbo.GetDecimal(RGA1_02_032_7_04_1) + dbo.GetDecimal(RGA1_02_034_7_05_1) + dbo.GetDecimal(RGA1_02_036_7_06_1) + dbo.GetDecimal(RGA1_02_038_7_07_1) + dbo.GetDecimal(RGA1_02_040_7_08_1) + dbo.GetDecimal(RGA1_02_042_7_09_1) + dbo.GetDecimal(RGA1_02_044_7_10_1) + dbo.GetDecimal(RGA1_02_046_7_11_1) + dbo.GetDecimal(RGA1_02_048_7_12_1) + dbo.GetDecimal(RGA1_03_002_7_13_1) + dbo.GetDecimal(RGA1_03_004_7_14_1) + dbo.GetDecimal(RGA1_03_006_7_15_1) + dbo.GetDecimal(RGA1_03_008_7_16_1) + dbo.GetDecimal(RGA1_03_010_7_17_1) + dbo.GetDecimal(RGA1_03_012_7_18_1) + dbo.GetDecimal(RGA1_03_014_7_19_1) + dbo.GetDecimal(RGA1_03_016_7_20_1) + dbo.GetDecimal(RGA1_03_018_7_21_1) + dbo.GetDecimal(RGA1_03_020_7_22_1) + dbo.GetDecimal(RGA1_03_022_7_23_1) + dbo.GetDecimal(RGA1_03_024_7_24_1) + dbo.GetDecimal(RGA1_03_026_7_25_1) + dbo.GetDecimal(RGA1_03_028_7_26_1) + dbo.GetDecimal(RGA1_03_030_7_27_1) + dbo.GetDecimal(RGA1_03_032_7_28_1) + dbo.GetDecimal(RGA1_03_034_7_29_1) + dbo.GetDecimal(RGA1_03_036_7_30_1))
  44. UNION ALL
  45. SELECT 25 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_03_039_7_31_2) = dbo.GetDecimal(RGA1_02_027_7_01_2) + dbo.GetDecimal(RGA1_02_029_7_02_2) + dbo.GetDecimal(RGA1_02_031_7_03_2) + dbo.GetDecimal(RGA1_02_033_7_04_2) + dbo.GetDecimal(RGA1_02_035_7_05_2) + dbo.GetDecimal(RGA1_02_037_7_06_2) + dbo.GetDecimal(RGA1_02_039_7_07_2) + dbo.GetDecimal(RGA1_02_041_7_08_2) + dbo.GetDecimal(RGA1_02_043_7_09_2) + dbo.GetDecimal(RGA1_02_045_7_10_2) + dbo.GetDecimal(RGA1_02_047_7_11_2) + dbo.GetDecimal(RGA1_02_049_7_12_2) + dbo.GetDecimal(RGA1_03_003_7_13_2) + dbo.GetDecimal(RGA1_03_005_7_14_2) + dbo.GetDecimal(RGA1_03_007_7_15_2) + dbo.GetDecimal(RGA1_03_009_7_16_2) + dbo.GetDecimal(RGA1_03_011_7_17_2) + dbo.GetDecimal(RGA1_03_013_7_18_2) + dbo.GetDecimal(RGA1_03_015_7_19_2) + dbo.GetDecimal(RGA1_03_017_7_20_2) + dbo.GetDecimal(RGA1_03_019_7_21_2) + dbo.GetDecimal(RGA1_03_021_7_22_2) + dbo.GetDecimal(RGA1_03_023_7_23_2) + dbo.GetDecimal(RGA1_03_025_7_24_2) + dbo.GetDecimal(RGA1_03_027_7_25_2) + dbo.GetDecimal(RGA1_03_029_7_26_2) + dbo.GetDecimal(RGA1_03_031_7_27_2) + dbo.GetDecimal(RGA1_03_033_7_28_2) + dbo.GetDecimal(RGA1_03_035_7_29_2) + dbo.GetDecimal(RGA1_03_037_7_30_2))
  46. UNION ALL
  47. SELECT 26 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_03_040_7_32_1) <=  dbo.GetDecimal(RGA1_05_033_9_65_1) )
  48. UNION ALL
  49. SELECT 27 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_03_041_7_32_2) <=  dbo.GetDecimal(RGA1_05_035_9_65_5) )
  50. UNION ALL
  51. SELECT 28 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_03_044_7_34_1) =  dbo.GetDecimal(RGA1_03_046_7_35_1) +  dbo.GetDecimal(RGA1_04_001_7_36_1) +  dbo.GetDecimal(RGA1_04_003_7_37_1) +  dbo.GetDecimal(RGA1_04_005_7_38_1) )
  52. UNION ALL
  53. SELECT 29 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_03_045_7_34_2) =  dbo.GetDecimal(RGA1_03_047_7_35_2) +  dbo.GetDecimal(RGA1_04_002_7_36_2) +  dbo.GetDecimal(RGA1_04_004_7_37_2) +  dbo.GetDecimal(RGA1_04_006_7_38_2))
  54. UNION ALL
  55. SELECT 30 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_04_009_7_40_1) =  dbo.GetDecimal(RGA1_03_038_7_31_1) +  dbo.GetDecimal(RGA1_03_042_7_33_1) + dbo.GetDecimal(RGA1_03_044_7_34_1) + dbo.GetDecimal(RGA1_04_007_7_39_1) -  dbo.GetDecimal(RGA1_03_040_7_32_1) )
  56. UNION ALL
  57. SELECT 31 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_010_7_40_2) =  dbo.GetDecimal(RGA1_03_039_7_31_2) +  dbo.GetDecimal(RGA1_03_043_7_33_2) + dbo.GetDecimal(RGA1_03_045_7_34_2)  + dbo.GetDecimal(RGA1_04_008_7_39_2) -  dbo.GetDecimal(RGA1_03_041_7_32_2))
  58. UNION ALL
  59. SELECT 32 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_04_012_9_42_1) =  dbo.GetDecimal(RGA1_04_017_9_43_1) + dbo.GetDecimal(RGA1_04_021_9_44_1) + dbo.GetDecimal(RGA1_04_025_9_45_1) + dbo.GetDecimal(RGA1_04_029_9_46_1) + dbo.GetDecimal(RGA1_04_033_9_47_1) + dbo.GetDecimal(RGA1_04_037_9_48_1) + dbo.GetDecimal(RGA1_04_041_9_49_1) )
  60. UNION ALL
  61. SELECT 33 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_013_9_42_2) =  dbo.GetDecimal(RGA1_04_018_9_43_2) + dbo.GetDecimal(RGA1_04_022_9_44_2) + dbo.GetDecimal(RGA1_04_026_9_45_2) + dbo.GetDecimal(RGA1_04_030_9_46_2) + dbo.GetDecimal(RGA1_04_034_9_47_2) + dbo.GetDecimal(RGA1_04_038_9_48_2) + dbo.GetDecimal(RGA1_04_042_9_49_2))
  62. UNION ALL
  63. SELECT 34 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_014_9_42_3) =  dbo.GetDecimal(RGA1_04_019_9_43_3) + dbo.GetDecimal(RGA1_04_023_9_44_3) + dbo.GetDecimal(RGA1_04_027_9_45_3) + dbo.GetDecimal(RGA1_04_031_9_46_3) + dbo.GetDecimal(RGA1_04_035_9_47_3) + dbo.GetDecimal(RGA1_04_039_9_48_3) + dbo.GetDecimal(RGA1_04_043_9_49_3))
  64. UNION ALL
  65. SELECT 35 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_015_9_42_4) =  dbo.GetDecimal(RGA1_04_020_9_43_4) + dbo.GetDecimal(RGA1_04_024_9_44_4) + dbo.GetDecimal(RGA1_04_028_9_45_4) + dbo.GetDecimal(RGA1_04_032_9_46_4) + dbo.GetDecimal(RGA1_04_036_9_47_4) + dbo.GetDecimal(RGA1_04_040_9_48_4) + dbo.GetDecimal(RGA1_04_044_9_49_4))
  66. UNION ALL
  67. SELECT 36 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_04_056_9_53_1) = dbo.GetDecimal(RGA1_04_061_9_54_1) + dbo.GetDecimal(RGA1_05_002_9_55_1) + dbo.GetDecimal(RGA1_05_014_9_58_1) + dbo.GetDecimal(RGA1_05_018_9_59_1) + dbo.GetDecimal(RGA1_05_022_9_60_1))
  68. UNION ALL
  69. SELECT 37 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_057_9_53_2) = dbo.GetDecimal(RGA1_04_062_9_54_2) + dbo.GetDecimal(RGA1_05_003_9_55_2) + dbo.GetDecimal(RGA1_05_015_9_58_2) + dbo.GetDecimal(RGA1_05_019_9_59_2) + dbo.GetDecimal(RGA1_05_023_9_60_2))
  70. UNION ALL
  71. SELECT 38 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_058_9_53_3) = dbo.GetDecimal(RGA1_04_063_9_54_3) + dbo.GetDecimal(RGA1_05_004_9_55_3) + dbo.GetDecimal(RGA1_05_016_9_58_3) + dbo.GetDecimal(RGA1_05_020_9_59_3) + dbo.GetDecimal(RGA1_05_024_9_60_3))
  72. UNION ALL
  73. SELECT 39 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_059_9_53_4) = dbo.GetDecimal(RGA1_04_064_9_54_4) + dbo.GetDecimal(RGA1_05_005_9_55_4) + dbo.GetDecimal(RGA1_05_017_9_58_4) + dbo.GetDecimal(RGA1_05_021_9_59_4) + dbo.GetDecimal(RGA1_05_025_9_60_4))
  74. UNION ALL
  75. SELECT 40 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_002_9_55_1) = dbo.GetDecimal(RGA1_05_006_9_56_1) + dbo.GetDecimal(RGA1_05_010_9_57_1) )
  76. UNION ALL
  77. SELECT 41 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_003_9_55_2) = dbo.GetDecimal(RGA1_05_007_9_56_2) + dbo.GetDecimal(RGA1_05_011_9_57_2))
  78. UNION ALL
  79. SELECT 42 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_004_9_55_3) = dbo.GetDecimal(RGA1_05_008_9_56_3) + dbo.GetDecimal(RGA1_05_012_9_57_3))
  80. UNION ALL
  81. SELECT 43 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_005_9_55_4) = dbo.GetDecimal(RGA1_05_009_9_56_4) + dbo.GetDecimal(RGA1_05_013_9_57_4))
  82. UNION ALL
  83. SELECT 44 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_026_9_61_1) = dbo.GetDecimal(RGA1_05_028_9_62_1) + dbo.GetDecimal(RGA1_05_029_9_63_1) )
  84. UNION ALL
  85. SELECT 45 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_033_9_65_1) = dbo.GetDecimal(RGA1_04_012_9_42_1) + dbo.GetDecimal(RGA1_04_045_9_50_1) + dbo.GetDecimal(RGA1_04_050_9_51_1) + dbo.GetDecimal(RGA1_04_053_9_52_1) + dbo.GetDecimal(RGA1_04_056_9_53_1) + dbo.GetDecimal(RGA1_05_026_9_61_1) + dbo.GetDecimal(RGA1_05_030_9_64_1) )
  86. UNION ALL
  87. SELECT 46 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_034_9_65_2) = dbo.GetDecimal(RGA1_04_013_9_42_2) + dbo.GetDecimal(RGA1_04_046_9_50_2) + dbo.GetDecimal(RGA1_04_051_9_51_2) + dbo.GetDecimal(RGA1_04_054_9_52_2) + dbo.GetDecimal(RGA1_04_057_9_53_2) )
  88. UNION ALL
  89. SELECT 47 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_035_9_65_5) = dbo.GetDecimal(RGA1_04_016_9_42_5) + dbo.GetDecimal(RGA1_04_049_9_50_5) + dbo.GetDecimal(RGA1_04_052_9_51_5) + dbo.GetDecimal(RGA1_04_055_9_52_5) + dbo.GetDecimal(RGA1_04_060_9_53_5) + dbo.GetDecimal(RGA1_05_027_9_61_5) + dbo.GetDecimal(RGA1_05_032_9_64_5))
  90. UNION ALL
  91. SELECT 48 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_036_10_66_1) =  dbo.GetDecimal(RGA1_04_009_7_40_1) + dbo.GetDecimal(RGA1_04_011_8_41_1) + dbo.GetDecimal(RGA1_05_033_9_65_1) )
  92. UNION ALL
  93. SELECT 49 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_037_10_66_2) =  dbo.GetDecimal(RGA1_04_010_7_40_2) + dbo.GetDecimal(RGA1_05_035_9_65_5))
  94. UNION ALL
  95. SELECT 50 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_038_11_67_1) = dbo.GetDecimal(RGA1_05_040_11_68_1) + dbo.GetDecimal(RGA1_05_052_11_74_1) + dbo.GetDecimal(RGA1_06_001_11_75_1) + dbo.GetDecimal(RGA1_06_003_11_76_1) )
  96. UNION ALL
  97. SELECT 51 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_039_11_67_2) = dbo.GetDecimal(RGA1_05_041_11_68_2) + dbo.GetDecimal(RGA1_05_053_11_74_2) + dbo.GetDecimal(RGA1_06_002_11_75_2) + dbo.GetDecimal(RGA1_06_004_11_76_2))
  98. UNION ALL
  99. SELECT 52 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_040_11_68_1) = dbo.GetDecimal(RGA1_05_042_11_69_1) + dbo.GetDecimal(RGA1_05_044_11_70_1) )
  100. UNION ALL
  101. SELECT 53 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_041_11_68_2) = dbo.GetDecimal(RGA1_05_043_11_69_2) + dbo.GetDecimal(RGA1_05_045_11_70_2))
  102. UNION ALL
  103. SELECT 54 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_044_11_70_1) = dbo.GetDecimal(RGA1_05_046_11_71_1) + dbo.GetDecimal(RGA1_05_048_11_72_1) + dbo.GetDecimal(RGA1_05_050_11_73_1) )
  104. UNION ALL
  105. SELECT 55 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_045_11_70_2) = dbo.GetDecimal(RGA1_05_047_11_71_2) + dbo.GetDecimal(RGA1_05_049_11_72_2) + dbo.GetDecimal(RGA1_05_051_11_73_2))
  106. UNION ALL
  107. SELECT 56 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_06_005_12_77_1) =  dbo.GetDecimal(RGA1_05_036_10_66_1) +dbo.GetDecimal(RGA1_05_038_11_67_1) )
  108. UNION ALL
  109. SELECT 57 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_006_12_77_2) =  dbo.GetDecimal(RGA1_05_037_10_66_2) +dbo.GetDecimal(RGA1_05_039_11_67_2))
  110. UNION ALL
  111. SELECT 58 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_04_009_7_40_1) <= dbo.GetDecimal(RGA1_06_011_15_80_1) + dbo.GetDecimal(RGA1_06_013_15_81_1) + dbo.GetDecimal(RGA1_06_015_15_82_1) )
  112. UNION ALL
  113. SELECT 59 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_06_017_16_01_1) =  dbo.GetDecimal(RGA1_06_019_16_02_1) + dbo.GetDecimal(RGA1_06_025_16_05_1) + dbo.GetDecimal(RGA1_06_031_16_08_1))
  114. UNION ALL
  115. SELECT 60 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_018_16_01_2) =  dbo.GetDecimal(RGA1_06_020_16_02_2) + dbo.GetDecimal(RGA1_06_026_16_05_2) + dbo.GetDecimal(RGA1_06_032_16_08_2))
  116. UNION ALL
  117. SELECT 61 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_019_16_02_1) =dbo.GetDecimal(RGA1_06_021_16_03_1) +dbo.GetDecimal(RGA1_06_023_16_04_1))
  118. UNION ALL
  119. SELECT 62 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_020_16_02_2) =dbo.GetDecimal(RGA1_06_022_16_03_2) +dbo.GetDecimal(RGA1_06_024_16_04_2) )
  120. UNION ALL
  121. SELECT 63 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_025_16_05_1) =dbo.GetDecimal(RGA1_06_027_16_06_1) +dbo.GetDecimal(RGA1_06_029_16_07_1) )
  122. UNION ALL
  123. SELECT 64 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_026_16_05_2) =dbo.GetDecimal(RGA1_06_028_16_06_2) +dbo.GetDecimal(RGA1_06_030_16_07_2))
  124. UNION ALL
  125. SELECT 65 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_06_031_16_08_1) = dbo.GetDecimal(RGA1_06_033_16_09_1) + dbo.GetDecimal(RGA1_06_035_16_10_1) )
  126. UNION ALL
  127. SELECT 66 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_032_16_08_2) = dbo.GetDecimal(RGA1_06_034_16_09_2) + dbo.GetDecimal(RGA1_06_036_16_10_2))
  128. UNION ALL
  129. SELECT 67 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_06_035_16_10_1) = dbo.GetDecimal(RGA1_06_037_16_11_1) + dbo.GetDecimal(RGA1_06_039_16_12_1) + dbo.GetDecimal(RGA1_06_041_16_13_1) )
  130. UNION ALL
  131. SELECT 68 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_036_16_10_2) = dbo.GetDecimal(RGA1_06_038_16_11_2) + dbo.GetDecimal(RGA1_06_040_16_12_2) + dbo.GetDecimal(RGA1_06_042_16_13_2))
  132. UNION ALL
  133. SELECT 69 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_06_043_17_14_1) = dbo.GetDecimal(RGA1_07_002_17_15_1) + dbo.GetDecimal(RGA1_07_004_17_16_1) + dbo.GetDecimal(RGA1_07_006_17_17_1) )
  134. UNION ALL
  135. SELECT 70 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_044_17_14_2) = dbo.GetDecimal(RGA1_07_003_17_15_2) + dbo.GetDecimal(RGA1_07_005_17_16_2) + dbo.GetDecimal(RGA1_07_007_17_17_2))
  136. UNION ALL
  137. SELECT 71 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_07_008_18_18_1) = dbo.GetDecimal(RGA1_07_010_18_19_1) + dbo.GetDecimal(RGA1_07_012_18_20_1) )
  138. UNION ALL
  139. SELECT 72 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_07_009_18_18_2) = dbo.GetDecimal(RGA1_07_011_18_19_2) + dbo.GetDecimal(RGA1_07_013_18_20_2))
  140. UNION ALL
  141. SELECT 73 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_07_014_19_21_1) = dbo.GetDecimal(RGA1_07_016_19_22_1) + dbo.GetDecimal(RGA1_07_018_19_23_1) )
  142. UNION ALL
  143. SELECT 74 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_07_015_19_21_2) = dbo.GetDecimal(RGA1_07_017_19_22_2) + dbo.GetDecimal(RGA1_07_019_19_23_2))
  144. UNION ALL
  145. SELECT 75 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_07_020_20_24_1) = dbo.GetDecimal(RGA1_07_022_20_25_1) + dbo.GetDecimal(RGA1_07_024_20_26_1) )
  146. UNION ALL
  147. SELECT 76 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_07_021_20_24_2) = dbo.GetDecimal(RGA1_07_023_20_25_2) + dbo.GetDecimal(RGA1_07_025_20_26_2))
  148. UNION ALL
  149. SELECT 77 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_07_026_21_27_1) = dbo.GetDecimal(RGA1_07_028_21_28_1) + dbo.GetDecimal(RGA1_07_030_21_29_1) + dbo.GetDecimal(RGA1_07_032_21_30_1) + dbo.GetDecimal(RGA1_07_034_21_31_1) + dbo.GetDecimal(RGA1_07_036_21_32_1) + dbo.GetDecimal(RGA1_07_038_21_33_1) )
  150. UNION ALL
  151. SELECT 78 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_07_027_21_27_2) = dbo.GetDecimal(RGA1_07_029_21_28_2) + dbo.GetDecimal(RGA1_07_031_21_29_2) + dbo.GetDecimal(RGA1_07_033_21_30_2) + dbo.GetDecimal(RGA1_07_035_21_31_2) + dbo.GetDecimal(RGA1_07_037_21_32_2) + dbo.GetDecimal(RGA1_07_039_21_33_2))
  152. UNION ALL
  153. SELECT 79 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_07_040_22_34_1) = dbo.GetDecimal(RGA1_07_042_22_35_1) + dbo.GetDecimal(RGA1_07_044_22_36_1) )
  154. UNION ALL
  155. SELECT 80 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_07_041_22_34_2) = dbo.GetDecimal(RGA1_07_043_22_35_2) + dbo.GetDecimal(RGA1_07_045_22_36_2))
  156. UNION ALL
  157. SELECT 81 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_07_048_24_38_1) = dbo.GetDecimal(RGA1_07_050_24_39_1) + dbo.GetDecimal(RGA1_07_052_24_40_1) )
  158. UNION ALL
  159. SELECT 82 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_07_049_24_38_2) = dbo.GetDecimal(RGA1_07_051_24_39_2) + dbo.GetDecimal(RGA1_07_053_24_40_2))
  160. UNION ALL
  161. SELECT 83 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_08_001_26_01) >= dbo.GetDecimal(RGA1_06_017_16_01_1) + dbo.GetDecimal(RGA1_06_018_16_01_2) )
  162. UNION ALL
  163. SELECT 84 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_08_002_26_02) >= dbo.GetDecimal(RGA1_07_020_20_24_1) + dbo.GetDecimal(RGA1_07_021_20_24_2) )
  164. UNION ALL
  165. SELECT 85 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_08_003_26_03) >= dbo.GetDecimal(RGA1_06_043_17_14_1) + dbo.GetDecimal(RGA1_06_044_17_14_2) )
  166. UNION ALL
  167. SELECT 86 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_08_004_26_04) >= dbo.GetDecimal(RGA1_07_008_18_18_1) + dbo.GetDecimal(RGA1_07_009_18_18_2) + dbo.GetDecimal(RGA1_07_014_19_21_1) + dbo.GetDecimal(RGA1_07_015_19_21_2) )
  168. UNION ALL
  169. SELECT 88 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_08_019_27_19_2) = dbo.GetDecimal(RGA1_08_023_27_20_2) + dbo.GetDecimal(RGA1_08_027_27_21_2) )
  170. UNION ALL
  171. SELECT 89 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_08_020_27_19_3) = dbo.GetDecimal(RGA1_08_024_27_20_3) + dbo.GetDecimal(RGA1_08_028_27_21_3))
  172. UNION ALL
  173. SELECT 90 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_08_021_27_19_4) = dbo.GetDecimal(RGA1_08_025_27_20_4) + dbo.GetDecimal(RGA1_08_029_27_21_4))
  174. UNION ALL
  175. SELECT 91 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_042_29_01_1) =1 OR  dbo.GetDecimal(RGA1_09_042_29_01_1) =0)
  176. UNION ALL
  177. SELECT 92 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_020_29_09_1) = dbo.GetDecimal(RGA1_10_024_29_10_1) + dbo.GetDecimal(RGA1_10_028_29_11_1) )
  178. UNION ALL
  179. SELECT 93 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_021_29_09_2) = dbo.GetDecimal(RGA1_10_025_29_10_2) + dbo.GetDecimal(RGA1_10_029_29_11_2))
  180. UNION ALL
  181. SELECT 94 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_022_29_09_3) = dbo.GetDecimal(RGA1_10_026_29_10_3) + dbo.GetDecimal(RGA1_10_030_29_11_3))
  182. UNION ALL
  183. SELECT 95 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_023_29_09_4) = dbo.GetDecimal(RGA1_10_027_29_10_4) + dbo.GetDecimal(RGA1_10_031_29_11_4))
  184. UNION ALL
  185. SELECT 96 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_024_29_10_1) = dbo.GetDecimal(RGA1_10_032_29_12_1) + dbo.GetDecimal(RGA1_10_034_29_13_1) + dbo.GetDecimal(RGA1_10_036_29_14_1) + dbo.GetDecimal(RGA1_10_038_29_15_1) + dbo.GetDecimal(RGA1_10_040_29_16_1) + dbo.GetDecimal(RGA1_10_042_29_17_1) )
  186. UNION ALL
  187. SELECT 97 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_025_29_10_2) = dbo.GetDecimal(RGA1_10_033_29_12_2) + dbo.GetDecimal(RGA1_10_035_29_13_2) + dbo.GetDecimal(RGA1_10_037_29_14_2) + dbo.GetDecimal(RGA1_10_039_29_15_2) + dbo.GetDecimal(RGA1_10_041_29_16_2) + dbo.GetDecimal(RGA1_10_043_29_17_2))
  188. UNION ALL
  189. SELECT 98 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_11_007_31_04) >= dbo.GetDecimal(RGA1_11_008_31_05) )
  190. UNION ALL
  191. SELECT 99 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_11_008_31_05) = dbo.GetDecimal(RGA1_11_009_31_06) + dbo.GetDecimal(RGA1_11_010_31_07) + dbo.GetDecimal(RGA1_11_011_31_08) + dbo.GetDecimal(RGA1_11_012_31_09) + dbo.GetDecimal(RGA1_11_013_31_10) + dbo.GetDecimal(RGA1_11_014_31_11) + dbo.GetDecimal(RGA1_11_015_31_12) + dbo.GetDecimal(RGA1_11_016_31_13) + dbo.GetDecimal(RGA1_11_017_31_14) + dbo.GetDecimal(RGA1_11_018_31_15) + dbo.GetDecimal(RGA1_11_019_31_16) + dbo.GetDecimal(RGA1_11_020_31_17) )
  192. UNION ALL
  193. SELECT 100 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_04_009_7_40_1) =0 OR dbo.GetDecimal(RGA1_04_009_7_40_1) >0 )
  194. UNION ALL
  195. SELECT 101 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_010_7_40_2) =0 OR dbo.GetDecimal(RGA1_04_010_7_40_2) >0  )
  196. UNION ALL
  197. SELECT 102 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_03_038_7_31_1)=0 OR ( dbo.GetDecimal(RGA1_03_038_7_31_1)>0 AND ( dbo.GetDecimal(RGA1_06_011_15_80_1)>0 OR dbo.GetDecimal(RGA1_06_013_15_81_1)>0 OR dbo.GetDecimal(RGA1_06_015_15_82_1) >0  )))
  198. UNION ALL
  199. SELECT 103 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_03_039_7_31_2) =0 OR dbo.GetDecimal(RGA1_03_039_7_31_2) >0)
  200. UNION ALL
  201. SELECT 104 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_06_011_15_80_1)>=0)
  202. UNION ALL
  203. SELECT 105 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_04_014_9_42_3) =0 OR ( dbo.GetDecimal(RGA1_04_014_9_42_3)>0 AND  dbo.GetDecimal(RGA1_04_016_9_42_5)>0  ))
  204. UNION ALL
  205. SELECT 106 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_015_9_42_4) =0 OR ( dbo.GetDecimal(RGA1_04_015_9_42_4)>0 AND  dbo.GetDecimal(RGA1_04_016_9_42_5)>0  ))
  206. UNION ALL
  207. SELECT 107 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_047_9_50_3) =0 OR ( dbo.GetDecimal(RGA1_04_047_9_50_3)>0 AND  dbo.GetDecimal(RGA1_04_049_9_50_5)>0  ))
  208. UNION ALL
  209. SELECT 108 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_048_9_50_4) =0 OR ( dbo.GetDecimal(RGA1_04_048_9_50_4)>0 AND  dbo.GetDecimal(RGA1_04_049_9_50_5)>0  ))
  210. UNION ALL
  211. SELECT 109 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_058_9_53_3) =0 OR ( dbo.GetDecimal(RGA1_04_058_9_53_3)>0 AND  dbo.GetDecimal(RGA1_04_060_9_53_5)>0  ))
  212. UNION ALL
  213. SELECT 110 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_059_9_53_4) =0 OR ( dbo.GetDecimal(RGA1_04_059_9_53_4)>0 AND  dbo.GetDecimal(RGA1_04_060_9_53_5)>0  ))
  214. UNION ALL
  215. SELECT 111 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_012_9_42_1)>=dbo.GetDecimal(RGA1_04_013_9_42_2))
  216. UNION ALL
  217. SELECT 112 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_017_9_43_1)>=dbo.GetDecimal(RGA1_04_018_9_43_2))
  218. UNION ALL
  219. SELECT 113 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_021_9_44_1)>=dbo.GetDecimal(RGA1_04_022_9_44_2))
  220. UNION ALL
  221. SELECT 114 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_025_9_45_1)>=dbo.GetDecimal(RGA1_04_026_9_45_2))
  222. UNION ALL
  223. SELECT 115 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_029_9_46_1)>=dbo.GetDecimal(RGA1_04_030_9_46_2))
  224. UNION ALL
  225. SELECT 116 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_033_9_47_1)>=dbo.GetDecimal(RGA1_04_034_9_47_2))
  226. UNION ALL
  227. SELECT 117 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_037_9_48_1)>=dbo.GetDecimal(RGA1_04_038_9_48_2))
  228. UNION ALL
  229. SELECT 118 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_041_9_49_1)>=dbo.GetDecimal(RGA1_04_042_9_49_2))
  230. UNION ALL
  231. SELECT 119 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_045_9_50_1)>=dbo.GetDecimal(RGA1_04_046_9_50_2))
  232. UNION ALL
  233. SELECT 120 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_056_9_53_1)>=dbo.GetDecimal(RGA1_04_057_9_53_2))
  234. UNION ALL
  235. SELECT 121 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_04_061_9_54_1)>=dbo.GetDecimal(RGA1_04_062_9_54_2))
  236. UNION ALL
  237. SELECT 122 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_002_9_55_1)>=dbo.GetDecimal(RGA1_05_003_9_55_2))
  238. UNION ALL
  239. SELECT 123 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_006_9_56_1)>=dbo.GetDecimal(RGA1_05_007_9_56_2))
  240. UNION ALL
  241. SELECT 124 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_010_9_57_1)>=dbo.GetDecimal(RGA1_05_011_9_57_2))
  242. UNION ALL
  243. SELECT 125 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_014_9_58_1)>=dbo.GetDecimal(RGA1_05_015_9_58_2))
  244. UNION ALL
  245. SELECT 126 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_018_9_59_1)>=dbo.GetDecimal(RGA1_05_019_9_59_2))
  246. UNION ALL
  247. SELECT 127 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_022_9_60_1)>=dbo.GetDecimal(RGA1_05_023_9_60_2))
  248. UNION ALL
  249. SELECT 128 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_09_066_29_04_1)>0 OR dbo.GetDecimal(RGA1_09_067_29_04_2)>0 OR dbo.GetDecimal(RGA1_09_068_29_04_3)>0 OR dbo.GetDecimal(RGA1_09_069_29_04_4)>0 OR dbo.GetDecimal(RGA1_09_070_29_04_5)>0 OR dbo.GetDecimal(RGA1_09_071_29_04_6)>0 OR dbo.GetDecimal(RGA1_09_072_29_04_7)>0 OR dbo.GetDecimal(RGA1_09_073_29_04_8)>0)
  250. UNION ALL
  251. SELECT 129 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('DA',RGA1_11_006_31)=0 OR (CHARINDEX('DA',RGA1_11_006_31)>=1 AND dbo.GetDecimal(RGA1_11_007_31_04)>0))
  252. UNION ALL
  253. SELECT 130 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_11_007_31_04)=0 OR (dbo.GetDecimal(RGA1_11_007_31_04)>0 AND (CHARINDEX('18',RGA1_11_021_31_18)>0 OR CHARINDEX('19',RGA1_11_021_31_18)>0 OR CHARINDEX('20',RGA1_11_021_31_18)>0) AND (CHARINDEX('21',RGA1_12_001_31_21)>0 OR CHARINDEX('22',RGA1_12_001_31_21)>0 OR CHARINDEX('23',RGA1_12_001_31_21)>0 OR CHARINDEX('24',RGA1_12_001_31_21)>0)) )
  254. UNION ALL
  255. SELECT 131 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_11_007_31_04)=0 OR (dbo.GetDecimal(RGA1_11_007_31_04)>0 AND  (CHARINDEX('18',RGA1_11_021_31_18)>0 OR CHARINDEX('19',RGA1_11_021_31_18)>0 OR CHARINDEX('20',RGA1_11_021_31_18)>0) AND (CHARINDEX('21',RGA1_12_001_31_21)>0 OR CHARINDEX('22',RGA1_12_001_31_21)>0 OR CHARINDEX('23',RGA1_12_001_31_21)>0 OR CHARINDEX('24',RGA1_12_001_31_21)>0)) )
  256. UNION ALL
  257. SELECT 132 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_12_009_34_03_1) =0 OR (dbo.GetDecimal(RGA1_12_009_34_03_1)  >0 AND dbo.GetDecimal(RGA1_12_009_34_03_1) <=( dbo.GetDecimal(RGA1_05_036_10_66_1) + dbo.GetDecimal(RGA1_05_037_10_66_2)/100)))
  258. UNION ALL
  259. SELECT 133 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_12_010_34_03_2) = 0 OR (dbo.GetDecimal(RGA1_12_010_34_03_2)  >0 AND dbo.GetDecimal(RGA1_12_009_34_03_1) <=( dbo.GetDecimal(RGA1_05_036_10_66_1) + dbo.GetDecimal(RGA1_05_037_10_66_2)/100)))
  260. UNION ALL
  261. SELECT 134 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_12_011_34_04_1) = 0 OR (dbo.GetDecimal(RGA1_12_011_34_04_1)  >0 AND dbo.GetDecimal(RGA1_12_009_34_03_1) <=( dbo.GetDecimal(RGA1_05_036_10_66_1) + dbo.GetDecimal(RGA1_05_037_10_66_2)/100)))
  262. UNION ALL
  263. SELECT 135 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_12_012_34_04_2) = 0 OR (dbo.GetDecimal(RGA1_12_012_34_04_2)  >0 AND dbo.GetDecimal(RGA1_12_009_34_03_1) <=( dbo.GetDecimal(RGA1_05_036_10_66_1) + dbo.GetDecimal(RGA1_05_037_10_66_2)/100)))
  264. UNION ALL
  265. SELECT 136 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_12_013_35_05) <= (dbo.GetDecimal(RGA1_06_017_16_01_1)+ dbo.GetDecimal(RGA1_06_018_16_01_2)))
  266. UNION ALL
  267. SELECT 137 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_12_014_35_06) <= (dbo.GetDecimal(RGA1_06_043_17_14_1)+ dbo.GetDecimal(RGA1_06_044_17_14_2)))
  268. UNION ALL
  269. SELECT 138 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_12_015_35_07) <= (dbo.GetDecimal(RGA1_07_008_18_18_1)+ dbo.GetDecimal(RGA1_07_009_18_18_2)+ dbo.GetDecimal(RGA1_07_014_19_21_1)+ dbo.GetDecimal(RGA1_07_015_19_21_2)))
  270. UNION ALL
  271. SELECT 139 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_12_016_35_08) <= (dbo.GetDecimal(RGA1_07_026_21_27_1)+ dbo.GetDecimal(RGA1_07_027_21_27_2)))
  272. UNION ALL
  273. SELECT 140 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('1',RGA1_12_019_36_01)=0 OR ( CHARINDEX('1',RGA1_12_019_36_01)>0 AND dbo.GetDecimal(RGA1_12_023_36_02_1)>0))
  274. UNION ALL
  275. SELECT 141 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('2',RGA1_12_019_36_01)=0 OR ( CHARINDEX('2',RGA1_12_019_36_01)>0 AND dbo.GetDecimal(RGA1_12_024_36_02_2)>0))
  276. UNION ALL
  277. SELECT 142 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('3',RGA1_12_019_36_01)=0 OR ( CHARINDEX('3',RGA1_12_019_36_01)>0 AND dbo.GetDecimal(RGA1_12_025_36_02_3)>0))
  278. UNION ALL
  279. SELECT 143 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('4',RGA1_12_019_36_01)=0 OR ( CHARINDEX('4',RGA1_12_019_36_01)>0 AND dbo.GetDecimal(RGA1_12_026_36_02_4)>0))
  280. UNION ALL
  281. SELECT 144 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('0',RGA1_13_003_38)=0 OR  (CHARINDEX('1',RGA1_13_003_38)=0 AND RTRIM(LTRIM((RGA1_13_003_38)))<>''))
  282. UNION ALL
  283. SELECT 145 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('1',RGA1_01_018_2)>0 OR CHARINDEX('2',RGA1_01_018_2)>0 OR CHARINDEX('3',RGA1_01_018_2)>0)
  284. UNION ALL
  285. SELECT 146 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('1',RGA1_01_018_2)=0 OR (CHARINDEX('1',RGA1_01_018_2)>0 AND  dbo.GetDecimal(RGA1_01_016_CODCUIIO)>0 AND  dbo.GetDecimal(RGA1_01_017_CODCFP)>0  ))
  286. UNION ALL
  287. SELECT 148 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('1',RGA1_01_022_3)>0    OR   CHARINDEX('0',RGA1_01_022_3)>0 OR CHARINDEX('DA',RGA1_01_022_3)>0    OR   CHARINDEX('NU',RGA1_01_022_3)>0)
  288. UNION ALL
  289. SELECT 149 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('1',RGA1_01_024_5)>0 OR CHARINDEX('2',RGA1_01_024_5)>0)
  290. UNION ALL
  291. SELECT 150 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('2',RGA1_01_024_5)=0  OR  (CHARINDEX('2',RGA1_01_024_5)>0 AND  (CHARINDEX('3',RGA1_01_025_5B)>0 OR  CHARINDEX('4',RGA1_01_025_5B)>0)))
  292. UNION ALL
  293. SELECT 424 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( (dbo.GetDecimal(RGA1_01_001_CODPROVIZORIU) = dbo.GetDecimal(RGA1_03_001_CODPROVIZORIU)) AND (dbo.GetDecimal(RGA1_03_001_CODPROVIZORIU) =dbo.GetDecimal(RGA1_05_001_CODPROVIZORIU)) AND (dbo.GetDecimal(RGA1_05_001_CODPROVIZORIU) =dbo.GetDecimal(RGA1_07_001_CODPROVIZORIU)) AND (dbo.GetDecimal(RGA1_07_001_CODPROVIZORIU) = dbo.GetDecimal(RGA1_09_001_CODPROVIZORIU)) AND (dbo.GetDecimal(RGA1_09_001_CODPROVIZORIU)=dbo.GetDecimal(RGA1_11_001_CODPROVIZORIU)) AND (dbo.GetDecimal(RGA1_11_001_CODPROVIZORIU) = dbo.GetDecimal(RGA1_13_001_CODPROVIZORIU)))
  294. UNION ALL
  295. SELECT 425 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('1',RGA1_01_018_2)>0 OR CHARINDEX('2',RGA1_01_018_2)>0 OR CHARINDEX('3',RGA1_01_018_2)>0)
  296. UNION ALL
  297. SELECT 431 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_01_015_CODCUATM)>0)
  298. UNION ALL
  299. SELECT 436 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_02_016_6_04_1)=0 OR (  dbo.GetDecimal(RGA1_02_016_6_04_1)>0 AND (  dbo.GetDecimal(RGA1_03_038_7_31_1)>0 OR  dbo.GetDecimal(RGA1_03_042_7_33_1)>0 OR  dbo.GetDecimal(RGA1_03_044_7_34_1)>0 OR  dbo.GetDecimal(RGA1_04_007_7_39_1)>0 OR  dbo.GetDecimal(RGA1_04_011_8_41_1)>0 OR  dbo.GetDecimal(RGA1_05_033_9_65_1)>0 OR  dbo.GetDecimal(RGA1_05_038_11_67_1)>0 )  ) )
  300. UNION ALL
  301. SELECT 437 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_02_017_6_04_2)=0 OR dbo.GetDecimal(RGA1_02_018_6_04_3)=0 OR (  dbo.GetDecimal(RGA1_02_017_6_04_2)>0 AND dbo.GetDecimal(RGA1_02_018_6_04_3)>0 AND (  dbo.GetDecimal(RGA1_03_039_7_31_2)>0 OR  dbo.GetDecimal(RGA1_03_043_7_33_2)>0 OR  dbo.GetDecimal(RGA1_03_045_7_34_2)>0 OR  dbo.GetDecimal(RGA1_04_008_7_39_2)>0 OR  dbo.GetDecimal(RGA1_05_035_9_65_5)>0 OR  dbo.GetDecimal(RGA1_05_039_11_67_2)>0 )  ) )
  302. UNION ALL
  303. SELECT 438 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_05_036_10_66_1)=0 OR (  dbo.GetDecimal(RGA1_05_036_10_66_1)>0 AND (  dbo.GetDecimal(RGA1_04_009_7_40_1)>0 OR  dbo.GetDecimal(RGA1_04_011_8_41_1)>0 OR  dbo.GetDecimal(RGA1_05_033_9_65_1)>0 )  ))
  304. UNION ALL
  305. SELECT 439 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_05_037_10_66_2)=0 OR (  dbo.GetDecimal(RGA1_05_037_10_66_2)>0 AND (  dbo.GetDecimal(RGA1_04_010_7_40_2)>0 OR  dbo.GetDecimal(RGA1_05_035_9_65_5)>0 )  ))
  306. UNION ALL
  307. SELECT 440 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_043_29_01_2)=0 OR (  dbo.GetDecimal(RGA1_09_043_29_01_2)>=2 AND  dbo.GetDecimal(RGA1_09_043_29_01_2)<=4   ))
  308. UNION ALL
  309. SELECT 441 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_09_044_29_01_3)=0 OR (  dbo.GetDecimal(RGA1_09_044_29_01_3)>=2 AND  dbo.GetDecimal(RGA1_09_044_29_01_3)<=4   ))
  310. UNION ALL
  311. SELECT 442 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_09_045_29_01_4)=0 OR (  dbo.GetDecimal(RGA1_09_045_29_01_4)>=2 AND  dbo.GetDecimal(RGA1_09_045_29_01_4)<=4   ))
  312. UNION ALL
  313. SELECT 443 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_09_046_29_01_5)=0 OR (  dbo.GetDecimal(RGA1_09_046_29_01_5)>=2 AND  dbo.GetDecimal(RGA1_09_046_29_01_5)<=4   ))
  314. UNION ALL
  315. SELECT 444 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_09_047_29_01_6)=0 OR (  dbo.GetDecimal(RGA1_09_047_29_01_6)>=2 AND  dbo.GetDecimal(RGA1_09_047_29_01_6)<=4   ))
  316. UNION ALL
  317. SELECT 445 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_09_048_29_01_7)=0 OR (  dbo.GetDecimal(RGA1_09_048_29_01_7)>=2 AND  dbo.GetDecimal(RGA1_09_048_29_01_7)<=4   ))
  318. UNION ALL
  319. SELECT 446 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_09_049_29_01_8)=0 OR (  dbo.GetDecimal(RGA1_09_049_29_01_8)>=2 AND  dbo.GetDecimal(RGA1_09_049_29_01_8)<=4   ))
  320. UNION ALL
  321. SELECT 447 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_050_29_02_1)>=0 AND dbo.GetDecimal(RGA1_09_050_29_02_1)<=2)
  322. UNION ALL
  323. SELECT 448 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_051_29_02_2)>=0 AND dbo.GetDecimal(RGA1_09_051_29_02_2)<=2)
  324. UNION ALL
  325. SELECT 449 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_052_29_02_3)>=0 AND dbo.GetDecimal(RGA1_09_052_29_02_3)<=2)
  326. UNION ALL
  327. SELECT 450 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_053_29_02_4)>=0 AND dbo.GetDecimal(RGA1_09_053_29_02_4)<=2)
  328. UNION ALL
  329. SELECT 451 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_054_29_02_5)>=0 AND dbo.GetDecimal(RGA1_09_054_29_02_5)<=2)
  330. UNION ALL
  331. SELECT 452 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_055_29_02_6)>=0 AND dbo.GetDecimal(RGA1_09_055_29_02_6)<=2)
  332. UNION ALL
  333. SELECT 453 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_056_29_02_7)>=0 AND dbo.GetDecimal(RGA1_09_056_29_02_7)<=2)
  334. UNION ALL
  335. SELECT 454 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_057_29_02_8)>=0 AND dbo.GetDecimal(RGA1_09_057_29_02_8)<=2)
  336. UNION ALL
  337. SELECT 455 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_058_29_03_1)>=0 AND  dbo.GetDecimal(RGA1_09_058_29_03_1) <=6 )
  338. UNION ALL
  339. SELECT 456 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_059_29_03_2)>=0 AND  dbo.GetDecimal(RGA1_09_059_29_03_2) <=6 )
  340. UNION ALL
  341. SELECT 457 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_060_29_03_3)>=0 AND  dbo.GetDecimal(RGA1_09_060_29_03_3) <=6 )
  342. UNION ALL
  343. SELECT 458 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_061_29_03_4)>=0 AND  dbo.GetDecimal(RGA1_09_061_29_03_4) <=6 )
  344. UNION ALL
  345. SELECT 459 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_062_29_03_5)>=0 AND  dbo.GetDecimal(RGA1_09_062_29_03_5) <=6 )
  346. UNION ALL
  347. SELECT 460 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_063_29_03_6)>=0 AND  dbo.GetDecimal(RGA1_09_063_29_03_6) <=6 )
  348. UNION ALL
  349. SELECT 461 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_064_29_03_7)>=0 AND  dbo.GetDecimal(RGA1_09_064_29_03_7) <=6 )
  350. UNION ALL
  351. SELECT 462 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_065_29_03_8)>=0 AND  dbo.GetDecimal(RGA1_09_065_29_03_8) <=6 )
  352. UNION ALL
  353. SELECT 463 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_066_29_04_1)>=0 AND  dbo.GetDecimal(RGA1_09_066_29_04_1)<=3  )
  354. UNION ALL
  355. SELECT 464 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_067_29_04_2)>=0 AND  dbo.GetDecimal(RGA1_09_067_29_04_2)<=3  )
  356. UNION ALL
  357. SELECT 465 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_068_29_04_3)>=0 AND  dbo.GetDecimal(RGA1_09_068_29_04_3)<=3  )
  358. UNION ALL
  359. SELECT 466 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_069_29_04_4)>=0 AND  dbo.GetDecimal(RGA1_09_069_29_04_4)<=3  )
  360. UNION ALL
  361. SELECT 467 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_070_29_04_5)>=0 AND  dbo.GetDecimal(RGA1_09_070_29_04_5)<=3  )
  362. UNION ALL
  363. SELECT 468 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_071_29_04_6)>=0 AND  dbo.GetDecimal(RGA1_09_071_29_04_6)<=3  )
  364. UNION ALL
  365. SELECT 469 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_072_29_04_7)>=0 AND  dbo.GetDecimal(RGA1_09_072_29_04_7)<=3  )
  366. UNION ALL
  367. SELECT 470 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_09_073_29_04_8)>=0 AND  dbo.GetDecimal(RGA1_09_073_29_04_8)<=3  )
  368. UNION ALL
  369. SELECT 471 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_001_29_05_1)>=0 AND  dbo.GetDecimal(RGA1_10_001_29_05_1)<=4  )
  370. UNION ALL
  371. SELECT 472 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_002_29_05_2)>=0 AND  dbo.GetDecimal(RGA1_10_002_29_05_2)<=4  )
  372. UNION ALL
  373. SELECT 473 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_003_29_05_3)>=0 AND  dbo.GetDecimal(RGA1_10_003_29_05_3)<=4  )
  374. UNION ALL
  375. SELECT 474 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_004_29_05_4)>=0 AND  dbo.GetDecimal(RGA1_10_004_29_05_4)<=4  )
  376. UNION ALL
  377. SELECT 475 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_005_29_05_5)>=0 AND  dbo.GetDecimal(RGA1_10_005_29_05_5)<=4  )
  378. UNION ALL
  379. SELECT 476 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_006_29_05_6)>=0 AND  dbo.GetDecimal(RGA1_10_006_29_05_6)<=4  )
  380. UNION ALL
  381. SELECT 477 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_007_29_05_7)>=0 AND  dbo.GetDecimal(RGA1_10_007_29_05_7)<=4  )
  382. UNION ALL
  383. SELECT 478 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_008_29_05_8)>=0 AND  dbo.GetDecimal(RGA1_10_008_29_05_8)<=4  )
  384. UNION ALL
  385. SELECT 479 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_009_29_06_1)>=0 AND  dbo.GetDecimal(RGA1_10_009_29_06_1)<=3  )
  386. UNION ALL
  387. SELECT 480 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_010_29_06_2)>=0 AND  dbo.GetDecimal(RGA1_10_010_29_06_2)<=3  )
  388. UNION ALL
  389. SELECT 481 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_011_29_06_3)>=0 AND  dbo.GetDecimal(RGA1_10_011_29_06_3)<=3  )
  390. UNION ALL
  391. SELECT 482 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_012_29_06_4)>=0 AND  dbo.GetDecimal(RGA1_10_012_29_06_4)<=3  )
  392. UNION ALL
  393. SELECT 483 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_013_29_06_5)>=0 AND  dbo.GetDecimal(RGA1_10_013_29_06_5)<=3  )
  394. UNION ALL
  395. SELECT 484 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_014_29_06_6)>=0 AND  dbo.GetDecimal(RGA1_10_014_29_06_6)<=3  )
  396. UNION ALL
  397. SELECT 485 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_015_29_06_7)>=0 AND  dbo.GetDecimal(RGA1_10_015_29_06_7)<=3  )
  398. UNION ALL
  399. SELECT 486 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_016_29_06_8)>=0 AND  dbo.GetDecimal(RGA1_10_016_29_06_8)<=3  )
  400. UNION ALL
  401. SELECT 487 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_017_29_07)>=0 AND  dbo.GetDecimal(RGA1_10_017_29_07)<=3  )
  402. UNION ALL
  403. SELECT 488 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_018_29_08)>=0 AND  dbo.GetDecimal(RGA1_10_018_29_08)<=4 )
  404. UNION ALL
  405. SELECT 489 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_019_29_09)>=0 AND  dbo.GetDecimal(RGA1_10_019_29_09)<=2  )
  406. UNION ALL
  407. SELECT 490 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_022_29_09_3)=0 OR  (dbo.GetDecimal(RGA1_10_022_29_09_3)>0 AND  dbo.GetDecimal(RGA1_10_022_29_09_3)<=365 * dbo.GetDecimal(RGA1_10_020_29_09_1)  ))
  408. UNION ALL
  409. SELECT 491 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_023_29_09_4)=0 OR  (dbo.GetDecimal(RGA1_10_023_29_09_4)>0 AND  dbo.GetDecimal(RGA1_10_023_29_09_4)<=365 * dbo.GetDecimal(RGA1_10_021_29_09_2)  ))
  410. UNION ALL
  411. SELECT 492 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( dbo.GetDecimal(RGA1_10_026_29_10_3)=0 OR  (dbo.GetDecimal(RGA1_10_026_29_10_3)>0 AND  dbo.GetDecimal(RGA1_10_026_29_10_3)<=365 * dbo.GetDecimal(RGA1_10_024_29_10_1)  ))
  412. UNION ALL
  413. SELECT 493 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_027_29_10_4)=0 OR  (dbo.GetDecimal(RGA1_10_027_29_10_4)>0 AND  dbo.GetDecimal(RGA1_10_027_29_10_4)<=365 * dbo.GetDecimal(RGA1_10_025_29_10_2)  ))
  414. UNION ALL
  415. SELECT 494 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_030_29_11_3)=0 OR  (dbo.GetDecimal(RGA1_10_030_29_11_3)>0 AND  dbo.GetDecimal(RGA1_10_030_29_11_3)<=365 * dbo.GetDecimal(RGA1_10_028_29_11_1)  ))
  416. UNION ALL
  417. SELECT 495 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_031_29_11_4)=0 OR  (dbo.GetDecimal(RGA1_10_031_29_11_4)>0 AND  dbo.GetDecimal(RGA1_10_031_29_11_4)<=365 * dbo.GetDecimal(RGA1_10_029_29_11_2)  ))
  418. UNION ALL
  419. SELECT 496 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_046_29_18_3)=0 OR  (dbo.GetDecimal(RGA1_10_046_29_18_3)>0 AND  dbo.GetDecimal(RGA1_10_046_29_18_3)<=365 * dbo.GetDecimal(RGA1_10_044_29_18_1)  ))
  420. UNION ALL
  421. SELECT 497 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(dbo.GetDecimal(RGA1_10_047_29_18_4)=0 OR  (dbo.GetDecimal(RGA1_10_047_29_18_4)>0 AND  dbo.GetDecimal(RGA1_10_047_29_18_4)<=365 * dbo.GetDecimal(RGA1_10_045_29_18_2)  ))
  422. UNION ALL
  423. SELECT 498 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('1',RGA1_08_018_27_19_1)=0 OR ( CHARINDEX('1',RGA1_08_018_27_19_1)>0 AND (  dbo.GetDecimal(RGA1_08_019_27_19_2)>0 OR  dbo.GetDecimal(RGA1_08_020_27_19_3)>0 OR  dbo.GetDecimal(RGA1_08_021_27_19_4)>0 ) ) OR ( CHARINDEX('1',RGA1_08_018_27_19_1)>0 AND (  dbo.GetDecimal(RGA1_08_019_27_19_2)=0 OR  dbo.GetDecimal(RGA1_08_020_27_19_3)=0 OR  dbo.GetDecimal(RGA1_08_021_27_19_4)=0 ) AND (  (dbo.GetDecimal(RGA1_10_044_29_18_1)>0  AND  dbo.GetDecimal(RGA1_10_046_29_18_3)>0) OR ( dbo.GetDecimal(RGA1_10_045_29_18_2)>0 AND  dbo.GetDecimal(RGA1_10_047_29_18_4)>0  )   )))
  424. UNION ALL
  425. SELECT 499 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('1',RGA1_08_030_27_22_1)=0 OR ( CHARINDEX('1',RGA1_08_030_27_22_1)>0 AND (  dbo.GetDecimal(RGA1_08_031_27_22_2)>0 OR  dbo.GetDecimal(RGA1_08_032_27_22_3)>0 OR  dbo.GetDecimal(RGA1_08_033_27_22_4)>0 ) ) OR ( CHARINDEX('1',RGA1_08_030_27_22_1)>0 AND (  dbo.GetDecimal(RGA1_08_031_27_22_2)=0 OR  dbo.GetDecimal(RGA1_08_032_27_22_3)=0 OR  dbo.GetDecimal(RGA1_08_033_27_22_4)=0 ) AND (  (dbo.GetDecimal(RGA1_10_044_29_18_1)>0  AND  dbo.GetDecimal(RGA1_10_046_29_18_3)>0) OR ( dbo.GetDecimal(RGA1_10_045_29_18_2)>0 AND  dbo.GetDecimal(RGA1_10_047_29_18_4)>0  )   )))
  426. UNION ALL
  427. SELECT 527 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT( CHARINDEX('DA',RGA1_11_006_31)>0 OR  CHARINDEX('NU',RGA1_11_006_31)>0 OR  CHARINDEX('1',RGA1_11_006_31)>0 OR  CHARINDEX('0',RGA1_11_006_31)>0)
  428. UNION ALL
  429. SELECT 534 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('DA',RGA1_12_005_32)>0 OR CHARINDEX('NU',RGA1_12_005_32)>0 OR CHARINDEX('1',RGA1_12_005_32)>0 OR CHARINDEX('0',RGA1_12_005_32)>0)
  430. UNION ALL
  431. SELECT 566 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('DA',RGA1_13_003_38)>0 OR CHARINDEX('NU',RGA1_13_003_38)>0 OR CHARINDEX('1',RGA1_13_003_38)>0 OR CHARINDEX('0',RGA1_13_003_38)>0)
  432. UNION ALL
  433. SELECT 570 AS RuleId, CSID as DocumentId,RGA1_01_004_NrMapa AS NrMapa, RGA1_01_015_COdCUATM as CodCUATM FROM dbo.RGA1 WHERE NOT(CHARINDEX('DA',RGA1_12_018_36)>0 OR CHARINDEX('NU',RGA1_12_018_36)>0 OR CHARINDEX('1',RGA1_12_018_36)>0 OR CHARINDEX('0',RGA1_12_018_36)>0)
  434. ) t
  435. inner join RDocuments on RDocuments.CSID = t.DocumentId
Add Comment
Please, Sign In to add comment
Public Pastes
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!