ROWNo.|| COLUMNNAME || COLUMNNo.|| MESSAGE ---------------------------------------------------------------------------------------------------------------------------------------------- 2 || CONSUMER_ID || 1 ||Consumer Id 1000842004 belong to BS is not allowed for bulk billing. Excluded category - BPL(UM),PL(UM),BS,CCTV ---------------------------------------------------------------------------------------------------------------------------- 2 || KWH || 2 ||Consumer ID 1000842004 : KWH Consumption 2160 cannot be greater than the KVAH Consumption 1880 ------------------------------------------------------------------------------------------------------------------------------------ 3 || KWH || 2 ||Consumer ID 1000317829 : KWH Consumption -151.974 cannot be greater than the KVAH Consumption -1240.81 --------------------------------------------------------------------------------------------------------- 4 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000345219 --------------------------------------------------------------------------------------------------------- 5 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317825 --------------------------------------------------------------------------------------------------------- 6 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317822 --------------------------------------------------------------------------------------------------------- 7 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315245 --------------------------------------------------------------------------------------------------------- 8 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317832 --------------------------------------------------------------------------------------------------------- 9 || KWH || 2 ||Consumer ID 1000317830 : KWH cannot be smaller than the existing KWH 284.1 ----------------------------------------------------------------------------------------------------------- 9 || KVAH || 4 ||Consumer ID 1000317830 : KVAH cannot be smaller than the existing KVAH 327.99 --------------------------------------------------------------------------------------------------------- 10 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000858517 --------------------------------------------------------------------------------------------------------- 11 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317819 --------------------------------------------------------------------------------------------------------- 12 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317818 --------------------------------------------------------------------------------------------------------- 13 || KWH || 2 ||Consumer ID 1000858608 : KWH cannot be smaller than the existing KWH 72 --------------------------------------------------------------------------------------------------------- 14 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317827 --------------------------------------------------------------------------------------------------------- 15 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317835 --------------------------------------------------------------------------------------------------------- 16 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000858669 --------------------------------------------------------------------------------------------------------- 17 || KVAH || 4 ||Consumer ID 1000863098 : KVAH cannot be smaller than the existing KVAH 2.3 --------------------------------------------------------------------------------------------------------- 18 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317834 --------------------------------------------------------------------------------------------------------- 19 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317831 --------------------------------------------------------------------------------------------------------- 20 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315242 --------------------------------------------------------------------------------------------------------- 21 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317823 --------------------------------------------------------------------------------------------------------- 22 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317817 --------------------------------------------------------------------------------------------------------- 23 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000858488 --------------------------------------------------------------------------------------------------------- 24 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000861367 --------------------------------------------------------------------------------------------------------- 25 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315243 --------------------------------------------------------------------------------------------------------- 26 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000861283 --------------------------------------------------------------------------------------------------------- 27 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000319045 --------------------------------------------------------------------------------------------------------- 28 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317833 --------------------------------------------------------------------------------------------------------- 29 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317824 --------------------------------------------------------------------------------------------------------- 30 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317820 --------------------------------------------------------------------------------------------------------- 31 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317828 --------------------------------------------------------------------------------------------------------- 32 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315229 --------------------------------------------------------------------------------------------------------- 33 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317815 --------------------------------------------------------------------------------------------------------- 34 || KWH || 2 ||Consumer ID 1000317806 : KWH cannot be smaller than the existing KWH 68147 ---------------------------------------------------------------------------------------------------------- 34 || KVAH || 4 ||Consumer ID 1000317806 : KVAH cannot be smaller than the existing KVAH 68147 --------------------------------------------------------------------------------------------------------- 35 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317810 --------------------------------------------------------------------------------------------------------- 36 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315239 --------------------------------------------------------------------------------------------------------- 37 || KWH || 2 ||Consumer ID 1000315226 : KWH cannot be smaller than the existing KWH 39677 --------------------------------------------------------------------------------------------------------- 38 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315225 --------------------------------------------------------------------------------------------------------- 39 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315231 --------------------------------------------------------------------------------------------------------- 40 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315234 --------------------------------------------------------------------------------------------------------- 41 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317807 --------------------------------------------------------------------------------------------------------- 42 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000318987 --------------------------------------------------------------------------------------------------------- 43 || KWH || 2 ||Consumer ID 1000839859 : KWH cannot be smaller than the existing KWH 438 --------------------------------------------------------------------------------------------------------- 43 || KVAH || 4 ||Consumer ID 1000839859 : KVAH cannot be smaller than the existing KVAH 446 ---------------------------------------------------------------------------------------------------------- 44 || KWH || 2 ||Consumer ID 1000315222 : KWH cannot be smaller than the existing KWH 1198.41 --------------------------------------------------------------------------------------------------------- 44 || KVAH || 4 ||Consumer ID 1000315222 : KVAH cannot be smaller than the existing KVAH 1260 --------------------------------------------------------------------------------------------------------- 45 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317804 --------------------------------------------------------------------------------------------------------- 46 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317800 --------------------------------------------------------------------------------------------------------- 47 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000630185 --------------------------------------------------------------------------------------------------------- 48 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317821 ----------------------------------------------------------------------------------------------------------- 49 || KWH || 2 ||Consumer ID 1000317809 : KWH cannot be smaller than the existing KWH 42861.69 ------------------------------------------------------------------------------------------------------------- 49 || KVAH || 4 ||Consumer ID 1000317809 : KVAH cannot be smaller than the existing KVAH 44255.65 --------------------------------------------------------------------------------------------------------- 50 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000639221 --------------------------------------------------------------------------------------------------------- 51 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000625889 --------------------------------------------------------------------------------------------------------- 52 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000625894 --------------------------------------------------------------------------------------------------------- 53 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315224 --------------------------------------------------------------------------------------------------------- 54 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000315223 --------------------------------------------------------------------------------------------------------- 55 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000859787 --------------------------------------------------------------------------------------------------------- 56 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000516546 --------------------------------------------------------------------------------------------------------- 57 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000317816 --------------------------------------------------------------------------------------------------------- 58 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000863097 --------------------------------------------------------------------------------------------------------- 59 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000866885 --------------------------------------------------------------------------------------------------------- 60 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000866884 --------------------------------------------------------------------------------------------------------- 61 || CONSUMER_ID || 1 ||Bill has been generated for the SEP-2024 for Consumer ID : 1000866886 ----------------------------------------------------------------------------------------------------------- 62 || KWH || 2 ||Consumer ID 1000640369 : KWH cannot be smaller than the existing KWH 22033.13 ------------------------------------------------------------------------------------------------------------- 62 || KVAH || 4 ||Consumer ID 1000640369 : KVAH cannot be smaller than the existing KVAH 22076.75 ------------------------------------------------------------------------------------------------------------------------------- 62 || METER_STATUS || 8 ||Consumer ID 1000640369 does not belong to DTC failure METER_STATUS should not be OK (DTC Failure) --------------------------------------------------------------------------------------------------------- 63 || KWH || 2 ||Consumer ID 1000864272 : KWH cannot be smaller than the existing KWH 30 --------------------------------------------------------------------------------------------------------- 63 || KVAH || 4 ||Consumer ID 1000864272 : KVAH cannot be smaller than the existing KVAH 36 ------------------------------------------------------------------------------------------------------------------------------- 63 || METER_STATUS || 8 ||Consumer ID 1000864272 does not belong to DTC failure METER_STATUS should not be OK (DTC Failure)