📊 HOMESAAZ Database Viewer
← Back to TablesTable: dbo.EmpPAdv
| EmpPAdvID | EmpCode | EmpName | AdjPMonth | AdjCMonth | AdjNMonth | AdvAmt | RemarkID | PF | AdvDate | AdjustedAmt | FinYear | SalaryID | EmpID | DedDate | addremark | UseDate | LoanID | UserName | MobileID | MobileAmt | NextBill | MobType | ECS |
|---|
| 1 | 11 | SATRUGHAN TIWARI | 0 | 5 | 0 | 5000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 5000.0000 | 2023 | 0 | 396 | 2023-05-24 00:00:00 | — | 2023-05-24 20:13:06 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 2 | 38 | ASHWANI KUMAR | 0 | 5 | 0 | 7000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 7000.0000 | 2023 | 0 | 2977 | 2023-05-24 00:00:00 | — | 2023-05-24 20:13:55 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 3 | 16 | MANOJ | 0 | 5 | 0 | 6000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 6000.0000 | 2023 | 0 | 3036 | 2023-05-24 00:00:00 | — | 2023-05-24 20:15:43 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 4 | 6 | MOHAN LAL | 0 | 5 | 0 | 5000.0000 | 5 | 1 | 2023-05-24 00:00:00 | 5000.0000 | 2023 | 0 | 2413 | 2023-05-24 00:00:00 | — | 2023-05-24 20:17:48 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 5 | 4 | AMIT KUMAR | 0 | 5 | 0 | 8000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 8000.0000 | 2023 | 0 | 3022 | 2023-05-24 00:00:00 | — | 2023-05-24 20:18:57 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 6 | 24 | BHARAT KUMAR | 0 | 5 | 0 | 3500.0000 | 5 | 0 | 2023-05-24 00:00:00 | 3500.0000 | 2023 | 0 | 3078 | 2023-05-24 00:00:00 | — | 2023-05-24 20:19:29 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 7 | 34 | PRADEEP THAKUR | 0 | 5 | 0 | 3500.0000 | 5 | 0 | 2023-05-24 00:00:00 | 3500.0000 | 2023 | 0 | 2999 | 2023-05-24 00:00:00 | — | 2023-05-24 20:19:48 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 8 | 7 | SATDEV | 0 | 5 | 0 | 3000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 3000.0000 | 2023 | 0 | 3165 | 2023-05-24 00:00:00 | — | 2023-05-24 20:22:43 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 9 | 36 | ARUN SINGH | 0 | 5 | 0 | 6000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 6000.0000 | 2023 | 0 | 3087 | 2023-05-24 00:00:00 | — | 2023-05-24 20:23:05 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 10 | 8 | VICKY VERMA | 0 | 5 | 0 | 6000.0000 | 5 | 1 | 2023-05-24 00:00:00 | 6000.0000 | 2023 | 0 | 3048 | 2023-05-24 00:00:00 | — | 2023-05-24 20:23:21 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 11 | 30 | SUNIL KUMAR, | 0 | 5 | 0 | 4500.0000 | 5 | 0 | 2023-05-24 00:00:00 | 4500.0000 | 2023 | 0 | 3082 | 2023-05-24 00:00:00 | — | 2023-05-24 20:23:46 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 12 | 1 | LALTA PRASAD | 0 | 5 | 0 | 6000.0000 | 5 | 1 | 2023-05-24 00:00:00 | 6000.0000 | 2023 | 0 | 3166 | 2023-05-24 00:00:00 | — | 2023-05-24 20:24:05 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 13 | 19 | PURAN ADHIKARI | 0 | 5 | 0 | 4000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 4000.0000 | 2023 | 0 | 1630 | 2023-05-24 00:00:00 | — | 2023-05-24 20:24:25 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 14 | 37 | VINOD SHAH | 0 | 5 | 0 | 1000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 1000.0000 | 2023 | 0 | 3202 | 2023-05-24 00:00:00 | — | 2023-05-24 20:24:50 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 15 | 25 | HARISH KUMAR | 0 | 5 | 0 | 4000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 4000.0000 | 2023 | 0 | 2555 | 2023-05-24 00:00:00 | — | 2023-05-24 20:25:14 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 16 | 22 | KANHAIYA LAL | 0 | 5 | 0 | 2000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 2000.0000 | 2023 | 0 | 2488 | 2023-05-24 00:00:00 | — | 2023-05-24 20:25:40 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 17 | 8 | DEEPANKAR | 0 | 5 | 0 | 6000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 6000.0000 | 2023 | 0 | 3023 | 2023-05-24 00:00:00 | — | 2023-05-24 20:25:50 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 18 | 1 | VIVEK DUBEY | 0 | 5 | 0 | 6000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 6000.0000 | 2023 | 0 | 2448 | 2023-05-24 00:00:00 | — | 2023-05-24 20:26:22 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 19 | 12 | PRAVESH KUMAR | 0 | 5 | 0 | 5000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 5000.0000 | 2023 | 0 | 2861 | 2023-05-24 00:00:00 | — | 2023-05-24 20:27:12 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 20 | 43 | PANKAJ SHARMA | 0 | 5 | 0 | 4000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 4000.0000 | 2023 | 0 | 3205 | 2023-05-24 00:00:00 | — | 2023-05-24 20:27:32 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 21 | 42 | PANKAJ GOYAL | 0 | 5 | 0 | 8000.0000 | 5 | 0 | 2023-05-24 00:00:00 | 8000.0000 | 2023 | 0 | 2214 | 2023-05-24 00:00:00 | — | 2023-05-24 20:27:52 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 22 | 18 | DHARMENDER KAMAT | 0 | 6 | 0 | 2000.0000 | 5 | 0 | 2023-06-22 00:00:00 | 2000.0000 | 2023 | 0 | 1416 | 2023-06-22 00:00:00 | — | 2023-06-22 21:13:03 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 23 | 37 | VINOD SHAH | 0 | 6 | 0 | 1000.0000 | 5 | 0 | 2023-06-22 00:00:00 | 1000.0000 | 2023 | 0 | 3202 | 2023-06-22 00:00:00 | — | 2023-06-22 21:13:43 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 24 | 24 | BHARAT KUMAR | 0 | 6 | 0 | 3500.0000 | 5 | 0 | 2023-06-22 00:00:00 | 3500.0000 | 2023 | 0 | 3078 | 2023-06-22 00:00:00 | — | 2023-06-22 21:16:10 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 25 | 7 | SATDEV | 0 | 6 | 0 | 3500.0000 | 5 | 0 | 2023-06-22 00:00:00 | 3500.0000 | 2023 | 0 | 3165 | 2023-06-22 00:00:00 | — | 2023-06-22 21:17:39 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 26 | 12 | PRAVESH KUMAR | 0 | 6 | 0 | 6000.0000 | 5 | 0 | 2023-06-22 00:00:00 | 6000.0000 | 2023 | 0 | 2861 | 2023-06-22 00:00:00 | — | 2023-06-22 21:19:32 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 27 | 6 | MOHAN LAL | 0 | 6 | 0 | 5000.0000 | 5 | 1 | 2023-06-22 00:00:00 | 5000.0000 | 2023 | 0 | 2413 | 2023-06-22 00:00:00 | — | 2023-06-22 21:20:24 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 28 | 38 | ASHWANI KUMAR | 0 | 6 | 0 | 7000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 7000.0000 | 2023 | 0 | 2977 | 2023-06-23 00:00:00 | — | 2023-06-23 21:04:52 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 29 | 22 | KANHAIYA LAL | 0 | 6 | 0 | 2000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 2000.0000 | 2023 | 0 | 2488 | 2023-06-23 00:00:00 | — | 2023-06-23 21:06:46 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 30 | 11 | SATRUGHAN TIWARI | 0 | 6 | 0 | 6000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 6000.0000 | 2023 | 0 | 396 | 2023-06-23 00:00:00 | — | 2023-06-23 21:08:25 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 31 | 42 | PANKAJ GOYAL | 0 | 6 | 0 | 8000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 8000.0000 | 2023 | 0 | 2214 | 2023-06-23 00:00:00 | — | 2023-06-23 21:09:17 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 32 | 4 | AMIT KUMAR | 0 | 6 | 0 | 9000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 9000.0000 | 2023 | 0 | 3022 | 2023-06-23 00:00:00 | — | 2023-06-23 21:11:03 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 33 | 16 | MANOJ | 0 | 6 | 0 | 6000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 6000.0000 | 2023 | 0 | 3036 | 2023-06-23 00:00:00 | — | 2023-06-23 21:13:44 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 34 | 36 | ARUN SINGH | 0 | 6 | 0 | 6000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 6000.0000 | 2023 | 0 | 3087 | 2023-06-23 00:00:00 | — | 2023-06-23 21:14:58 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 35 | 40 | SANJAY PANDEY | 0 | 6 | 0 | 5000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 5000.0000 | 2023 | 0 | 2592 | 2023-06-23 00:00:00 | — | 2023-06-23 21:16:24 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 36 | 8 | VICKY VERMA | 0 | 6 | 0 | 6000.0000 | 5 | 1 | 2023-06-23 00:00:00 | 6000.0000 | 2023 | 0 | 3048 | 2023-06-23 00:00:00 | — | 2023-06-23 21:17:05 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 37 | 19 | PURAN ADHIKARI | 0 | 6 | 0 | 5000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 5000.0000 | 2023 | 0 | 1630 | 2023-06-23 00:00:00 | — | 2023-06-23 21:17:29 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 38 | 25 | HARISH KUMAR | 0 | 6 | 0 | 4000.0000 | 5 | 0 | 2023-06-23 00:00:00 | 4000.0000 | 2023 | 0 | 2555 | 2023-06-23 00:00:00 | — | 2023-06-23 21:18:42 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 39 | 1 | LALTA PRASAD | 0 | 6 | 0 | 6000.0000 | 5 | 1 | 2023-06-23 00:00:00 | 6000.0000 | 2023 | 0 | 3166 | 2023-06-23 00:00:00 | — | 2023-06-23 21:19:32 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 40 | 7 | SUNIL KUMAR | 0 | 6 | 0 | 5000.0000 | 5 | 1 | 2023-06-23 00:00:00 | 5000.0000 | 2023 | 0 | 481 | 2023-06-23 00:00:00 | — | 2023-06-23 21:20:56 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 41 | 43 | PANKAJ SHARMA | 0 | 6 | 0 | 4500.0000 | 5 | 0 | 2023-06-23 00:00:00 | 4500.0000 | 2023 | 0 | 3205 | 2023-06-23 00:00:00 | — | 2023-06-23 21:21:37 | 0 | UJJWAL | 0 | .0000 | 0 | 0 | 0 |
| 42 | 8 | DEEPANKAR | 0 | 6 | 0 | 6000.0000 | 5 | 0 | 2023-06-27 00:00:00 | 6000.0000 | 2023 | 0 | 3023 | 2023-06-27 00:00:00 | — | 2023-06-27 21:03:45 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 43 | 22 | KANHAIYA LAL | 0 | 7 | 0 | 2000.0000 | 5 | 0 | 2023-07-22 00:00:00 | 2000.0000 | 2023 | 0 | 2488 | 2023-07-22 00:00:00 | — | 2023-07-22 21:40:52 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 44 | 7 | SATDEV | 0 | 7 | 0 | 500.0000 | 5 | 0 | 2023-07-22 00:00:00 | 500.0000 | 2023 | 0 | 3165 | 2023-07-22 00:00:00 | — | 2023-07-22 21:41:14 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 45 | 11 | SATRUGHAN TIWARI | 0 | 7 | 0 | 7000.0000 | 5 | 0 | 2023-07-22 00:00:00 | 7000.0000 | 2023 | 0 | 396 | 2023-07-22 00:00:00 | — | 2023-07-22 21:41:33 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 46 | 38 | ASHWANI KUMAR | 0 | 7 | 0 | 7000.0000 | 5 | 0 | 2023-07-22 00:00:00 | 7000.0000 | 2023 | 0 | 2977 | 2023-07-22 00:00:00 | — | 2023-07-22 21:41:46 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 47 | 12 | PRAVESH KUMAR | 0 | 7 | 0 | 5000.0000 | 5 | 0 | 2023-07-22 00:00:00 | 5000.0000 | 2023 | 0 | 2861 | 2023-07-22 00:00:00 | — | 2023-07-22 21:42:10 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 48 | 7 | SUNIL KUMAR | 0 | 7 | 0 | 5000.0000 | 5 | 1 | 2023-07-22 00:00:00 | 5000.0000 | 2023 | 0 | 481 | 2023-07-22 00:00:00 | — | 2023-07-22 21:42:48 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 49 | 16 | MANOJ | 0 | 7 | 0 | 6000.0000 | 5 | 0 | 2023-07-22 00:00:00 | 6000.0000 | 2023 | 0 | 3036 | 2023-07-22 00:00:00 | — | 2023-07-22 21:43:36 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |
| 50 | 4 | AMIT KUMAR | 0 | 7 | 0 | 8000.0000 | 5 | 0 | 2023-07-22 00:00:00 | 8000.0000 | 2023 | 0 | 3022 | 2023-07-22 00:00:00 | — | 2023-07-22 21:44:11 | 0 | SANYAM | 0 | .0000 | 0 | 0 | 0 |