📊 HOMESAAZ Database Viewer
← Back to Tables

Table: dbo.Bill

BillIDBillNoBillEntryNoAccountIDPlaceIDFinYearIDBillDateBillRelatedGrossAmtDiscPctDiscAmtTaxIDTaxAmtTaxFormAmtForwardChargePctForwardChargeAmtExcisePctExciseAmtOctrioPctOctrioAmtFreightPctFreightAmtOtherChargePctOtherChargeAmtTotalDiscAmtSalesTaxPctAddExciseAmtOrderNoOrderedByNetAmountBillAmountAmountPaidPassedPaidOperatorDuedatePassDateEntryDateGOCBillTailorBillAppButNotToPayBillWithoutGRNCategoryIDRemarksPurchaseIDExpBillFloorIDUserNameUseDateTDSIDTDSAmountBillNo1GrnIDSaleFilePrintBBillOKChallanNoSrNoBillRefGrnNoServiceAmtRecCodeFormNoLocTypeBTrfHSInvIDOtherDiscOtherDiscAmtIImageRGNModBillModDateTCSamtTCsPerResPerForLocSirDiscAmtStkRecInsuranceIDHSFBDINVIDHSRGNINVIDHSLSINVIDHSRJCINVIDApprovalMemoiDHSGGNINVIDKAVINVIDHSDECOINVIDBillCheckedBillCheckBycomHSDQTRQTRDATEHSKRNInvID
1100031214920013/BLL/15640714152013-09-12 00:00:00156620.0000.0000.0000.0000.0000.0000 156620.0000102013-09-12 00:00:002013-09-28 00:00:002013-09-28 00:00:0000000ELECTRICITY C-7,RG-------------------- 1845110ANIL2013-09-28 16:12:210.000010003121492000101100031214920000000000000
225108913/0813/BLL/25642814152013-09-09 00:00:00202.0000.0000.0000.0000.0000.0000 202.0000102013-09-09 00:00:002013-09-30 00:00:002013-09-30 00:00:000000025108913,C-7,RG---------------------- 877410ANIL2013-09-30 12:25:500.000025108913010125108913/0800000000000
325108912/0813/BLL/35642714152013-09-08 00:00:00202.0000.0000.0000.0000.0000.0000 202.0000102013-09-08 00:00:002013-09-30 00:00:002013-09-30 00:00:000000025108912,C-7,RG------------------------- 877410ANIL2013-09-30 12:31:350.000025108912010125108912/08000000000000
425108911/0813/BLL/45642614152013-09-09 00:00:00202.0000.0000.0000.0000.0000.0000 202.0000102013-09-09 00:00:002013-09-30 00:00:002013-09-30 00:00:000000025108911,C-7,RG-------------- 877410ANIL2013-09-30 12:34:220.000025108911010125108911/08000000000000
525108914/0813/BLL/55642914152013-09-09 00:00:00202.0000.0000.0000.0000.0000.0000 202.0000102013-09-09 00:00:002013-09-30 00:00:002013-09-30 00:00:000000025108914,C-7,RG------------------- 877410ANIL2013-09-30 12:35:210.000025108914010125108914/08000000000000
6113/BLL/65646714152013-10-03 00:00:00149120.0000.0000.0000.0000.0000.0000 149120.0000102013-10-03 00:00:002013-10-03 00:00:002013-10-03 00:00:0000000C-7 RGN SHOW ROOM INSURANCE 1996710ANIL2013-10-05 19:30:280.000010101100000000000
7SEPT 1313/BLL/75642514152013-09-09 00:00:00202.0000.0000.0000.0000.0000.0000 202.0000102013-09-09 00:00:002013-10-03 00:00:002013-10-03 00:00:0000000C-7 MTNL BILL 25108899 877410ANIL2013-10-03 19:38:290.000000101SEPT 1300000000000
825108915/0913/BLL/85647014152013-09-08 00:00:00212.0000.0000.0000.0000.0000.0000 212.0000102013-09-08 00:00:002013-10-03 00:00:002013-10-03 00:00:000000025108915 C-7,RG------------------- 575910ANIL2013-10-03 22:09:050.000025108915010125108915/0900000000000
924513/BLL/95653614152013-10-03 00:00:0018876.0000.0000.0000.0000.0000.0000 18876.0000102013-10-03 00:00:002013-10-10 00:00:002013-10-10 00:00:0000000SWIPPER RGN--------------------- 428010ANIL2013-10-10 14:00:4056537378.00002450101245000000000000
10318613/BLL/105654114152013-10-09 00:00:0028500.0000.0000.0000.0000.0000.0000 28500.0000102013-10-09 00:00:002013-10-10 00:00:002013-10-10 00:00:0000000FKG-320,CELFROST SINGLE DOOR COOLER 633310ANIL2013-10-10 17:05:010.0000318601013186000000000000
1141411189/0913/BLL/115654614152013-09-25 00:00:001248.0000.0000.0000.0000.0000.0000 1248.0000102013-09-25 00:00:002013-10-11 00:00:002013-10-11 00:00:0000000AIRTEL INTERNET RGN,41411189--------- 877410ANIL2013-10-11 15:05:150.000041411189010141411189/09000000000000
12211313/BLL/125658814152013-10-13 00:00:00960.0000.0000.0000.0000.0000.0000 960.0000102013-10-13 00:00:002013-10-13 00:00:002013-10-13 00:00:0000000DUSSHERA FESTIVAL SWEETS 428710ANIL2013-10-13 19:52:550.000021130101211300000000000
1310018110373113/BLL/135640714152013-10-07 00:00:00303620.0000.0000.0000.0000.0000.0000 303620.0000102013-10-07 00:00:002013-10-22 00:00:002013-10-22 00:00:0000000ELECTRICITY G-7,RG--------------- 1845110ANIL2013-10-22 15:08:500.00001001811037310101100181103731000000000000
1525108899/1013/BLL/155642514152013-11-07 00:00:001128.0000.0000.0000.0000.0000.0000 1128.0000102013-11-07 00:00:002013-11-07 00:00:002013-11-07 00:00:0000000RGN MTNL 25108899......... 575910ANIL2013-11-07 18:59:270.000025108899010125108899/1000000000000
1625108914/1013/BLL/165642914152013-11-07 00:00:00251.0000.0000.0000.0000.0000.0000 251.0000102013-11-07 00:00:002013-11-07 00:00:002013-11-07 00:00:0000000RGN MTNL 25108914 ........ 575910ANIL2013-11-07 19:00:100.000025108914010125108914/1000000000000
1725108911/1013/BLL/175642614152013-11-07 00:00:00205.0000.0000.0000.0000.0000.0000 205.0000102013-11-07 00:00:002013-11-07 00:00:002013-11-07 00:00:0000000RGN MNTL 25108911.............. 575910ANIL2013-11-07 19:00:490.000025108911010125108911/1000000000000
1825108915/1013/BLL/185647014152013-11-07 00:00:001190.0000.0000.0000.0000.0000.0000 1190.0000102013-11-07 00:00:002013-11-07 00:00:002013-11-07 00:00:0000000RGN MNTL 25108915 ............. 575910ANIL2013-11-07 19:01:200.000025108915010125108915/1000000000000
1925108913/1013/BLL/195642814152013-11-07 00:00:00280.0000.0000.0000.0000.0000.0000 280.0000102013-11-07 00:00:002013-11-07 00:00:002013-11-07 00:00:0000000RGN MNTL 25108913......... 575910ANIL2013-11-07 19:01:450.000025108913010125108913/1000000000000
2025108912/1013/BLL/205642714152013-11-07 00:00:00243.0000.0000.0000.0000.0000.0000 243.0000102013-11-07 00:00:002013-11-07 00:00:002013-11-07 00:00:0000000RGN MNTL 25108912 ......... 575910ANIL2013-11-07 19:02:150.000025108912010125108912/1000000000000
2311/135685514152013-11-01 00:00:002247200.00002247200.0000102013-11-09 12:42:292013-11-09 12:42:292013-11-09 12:42:2900005818119272200000.000000101201311010247200.00000000000000
2526113/BLL/15653614152013-11-05 00:00:0039308.0000.0000.0000.0000.0000.0000 39308.0000102013-11-05 00:00:002013-11-12 00:00:002013-11-12 00:00:0000000SWEESPER---------------- 428010ANIL2013-11-12 20:31:4756537787.00002610101261000000000000
2625/10/10 4141118913/BLL/25654614152013-10-25 00:00:002134.0000.0000.0000.0000.0000.0000 2134.0000102013-10-25 00:00:002013-11-14 00:00:002013-11-14 00:00:0000000INTERNET RGN 41411189 877410ANIL2013-11-14 14:20:250.000025010125/10/10 4141118900000000000
27100061272264/1013/BLL/35640714152013-11-12 00:00:00579510.0000.0000.0000.0000.0000.0000 579510.0000102013-11-12 00:00:002013-11-24 00:00:002013-11-24 00:00:0000000BSES ,C-7,RGN-------------------------- 1845110ANIL2013-11-24 14:18:300.00001000612722640101100061272264/10000000000000
2825108899/10,13/BLL/45642514152013-11-09 00:00:003488.0000.0000.0000.0000.0000.0000 3488.0000102013-11-09 00:00:002013-11-24 00:00:002013-11-24 00:00:000000025108899,C-7,RG----------------- 575910ANIL2013-11-24 17:43:520.000025108899010125108899/10,000000000000
2925108911/10,13/BLL/55642614152013-11-09 00:00:001785.0000.0000.0000.0000.0000.0000 1785.0000102013-11-09 00:00:002013-11-24 00:00:002013-11-24 00:00:000000025108911,C-7,RGN------------------- 575910ANIL2013-11-24 17:44:440.000025108911010125108911/10,00000000000
3025108914/10,13/BLL/65642914152013-11-09 00:00:00298.0000.0000.0000.0000.0000.0000 298.0000102013-11-09 00:00:002013-11-24 00:00:002013-11-24 00:00:000000025108914.C-7,RGN------------------ 575910ANIL2013-11-24 17:45:450.000025108914010125108914/10,000000000000
3125108913/10,13/BLL/75642814152013-11-09 00:00:001330.0000.0000.0000.0000.0000.0000 1330.0000102013-11-09 00:00:002013-11-24 00:00:002013-11-24 00:00:000000025108913,C-7,RGN----------------------- 575910ANIL2013-11-24 17:46:460.000025108913010125108913/10,00000000000
3225108912/10,13/BLL/85642714152013-11-09 00:00:001885.0000.0000.0000.0000.0000.0000 1885.0000102013-11-09 00:00:002013-11-24 00:00:002013-11-24 00:00:000000025108912,C-7,RGN------------------- 575910ANIL2013-11-24 17:47:240.000025108912010125108912/10,000000000000
3325108915/10,13/BLL/95647014152013-11-09 00:00:001456.0000.0000.0000.0000.0000.0000 1456.0000102013-11-09 00:00:002013-11-24 00:00:002013-11-24 00:00:000000025108915,C-7,RGN INTERNET------------ 575910ANIL2013-11-24 17:48:240.000025108915010125108915/10,000000000000
34151213/BLL/105692014152013-11-01 00:00:0028270.0000.0000.0000.0000.0000.0000 28270.0000102013-11-01 00:00:002013-11-26 00:00:002013-11-26 00:00:0000000SECURITY GUARD-BILL DATE 31/10/13 428610ANIL2013-11-26 14:30:1056921566.0000151201011512000000000000
3512/135685514152013-12-01 12:30:002247200.00002247200.0000102013-12-01 12:30:002013-12-01 12:30:002013-12-01 12:30:0000005818156857200000.00000010112/130247200.00000000000000
3627713/BLL/15653614152013-12-02 00:00:0038090.0000.0000.0000.0000.0000.0000 38090.0000102013-12-02 00:00:002013-12-06 00:00:002013-12-06 00:00:0000000SWEEPPAR----------------- 428010ANIL2013-12-06 18:14:1256537762.00002770101277000000000000
3725/11/1313/BLL/25654614152013-11-25 00:00:002151.0000.0000.0000.0000.0000.0000 2151.0000102013-11-25 00:00:002013-12-14 00:00:002013-12-14 00:00:0000000INTERNET C-7,RGN----------------- 877410RB2013-12-14 12:54:160.000025010125/11/13000000000000
38169313/BLL/35692014152013-11-30 00:00:0038203.0000.0000.0000.0000.0000.0000 38203.0000102013-11-30 00:00:002013-12-24 00:00:002013-12-24 00:00:0000000Security Gaurd-------------------- 428610RB2013-12-24 13:50:5656921764.0000169301011693000000000000
3925108912/1113/BLL/45642714152013-12-09 00:00:001607.0000.0000.0000.0000.0000.0000 1607.0000102013-12-09 00:00:002013-12-24 00:00:002013-12-24 00:00:0000000MTNL.RGN 25108912----------------- 575910RB2013-12-24 14:12:020.000025108912010125108912/11000000000000
4025108913/1113/BLL/55642814152013-12-09 00:00:00943.0000.0000.0000.0000.0000.0000 943.0000102013-12-09 00:00:002013-12-24 00:00:002013-12-24 00:00:0000000MTNL RGN 25108913-------------------- 575910RB2013-12-24 14:12:370.000025108913010125108913/11000000000000
4125108899/1113/BLL/65642514152013-12-09 00:00:001873.0000.0000.0000.0000.0000.0000 1873.0000102013-12-09 00:00:002013-12-24 00:00:002013-12-24 00:00:0000000MTNL RGN 25108899------------------ 575910RB2013-12-24 14:13:160.000025108899010125108899/11000000000000
4225108911/1113/BLL/75642614152013-12-09 00:00:00936.0000.0000.0000.0000.0000.0000 936.0000102013-12-09 00:00:002013-12-24 00:00:002013-12-24 00:00:0000000MTNL RGN 25108911------------------ 575910RB2013-12-24 14:13:500.000025108911010125108911/11000000000000
4325108914/1113/BLL/85642914152013-12-09 00:00:00471.0000.0000.0000.0000.0000.0000 471.0000102013-12-09 00:00:002013-12-24 00:00:002013-12-24 00:00:0000000MTNL RGN 25108914---------------- 575910RB2013-12-24 14:14:310.000025108914010125108914/11000000000000
4425108915/1113/BLL/95647014152013-12-08 00:00:001255.0000.0000.0000.0000.0000.0000 1255.0000102013-12-08 00:00:002013-12-24 00:00:002013-12-24 00:00:0000000MTNL RGN 25108915 INTERNET----------- 575910RB2013-12-24 14:17:340.000025108915010125108915/11000000000000
45100031358581/1113/BLL/105640714152013-12-11 00:00:00350610.0000.0000.0000.0000.0000.0000 350610.0000102013-12-11 00:00:002013-12-24 00:00:002013-12-24 00:00:0000000BSES RGN ----------------------- 1845110RB2013-12-24 14:18:300.00001000313585810101100031358581/11000000000000
461/145685514152014-01-01 12:30:002247200.00002247200.0000102014-01-01 12:30:002014-01-01 12:30:002014-01-01 12:30:0000005818156857200000.0000001011/140247200.00000000000000
4729314/BLL/15653614152014-01-02 00:00:0037166.0000.0000.0000.0000.0000.0000 37166.0000102014-01-02 00:00:002014-01-08 00:00:002014-01-08 00:00:0000000SWEPPER------------------- 428010RB2014-01-08 18:17:5456537744.00002930101293000000000000
48178714/BLL/25692014152013-12-31 00:00:0038239.0000.0000.0000.0000.0000.0000 38239.0000102013-12-31 00:00:002014-01-14 00:00:002014-01-14 00:00:0000000Security Guard C-7,Rgn 428610RB2014-01-14 16:39:0956921765.0000178701011787000000000000
494141118914/BLL/35654614152013-12-25 00:00:002235.0000.0000.0000.0000.0000.0000 2235.0000102013-12-25 00:00:002014-01-16 00:00:002014-01-16 00:00:0000000INTERNET C-7,RGN------------------- 877410VIV2014-01-16 13:48:590.00004141118901014141118900000000000
5010009132742214/BLL/45640714152014-01-09 00:00:00333340.0000.0000.0000.0000.0000.0000 333340.0000102014-01-09 00:00:002014-01-22 00:00:002014-01-22 00:00:0000000RGN JAN 14 BILL ......... 1845110VIV2014-01-22 13:49:190.0000100091327422010110009132742200000000000
5125108899/1214/BLL/55642514152014-01-09 00:00:001521.0000.0000.0000.0000.0000.0000 1521.0000102014-01-09 00:00:002014-01-29 00:00:002014-01-29 00:00:0000000MTNL 25108899 RGN--------------- 575910RB2014-01-29 12:38:000.000025108899010125108899/1200000000000
5225108914/1214/BLL/65642914152014-01-09 00:00:00724.0000.0000.0000.0000.0000.0000 724.0000102014-01-09 00:00:002014-01-29 00:00:002014-01-29 00:00:0000000MTNL 25108914 RGN----------------- 575910RB2014-01-29 12:38:340.000025108914010125108914/12000000000000
5325108912/1214/BLL/75642714152014-01-09 00:00:00996.0000.0000.0000.0000.0000.0000 996.0000102014-01-09 00:00:002014-01-29 00:00:002014-01-29 00:00:0000000MTNL 25108912 RGN--------------- 575910RB2014-01-29 12:39:040.000025108912010125108912/12000000000000
5425108911/1214/BLL/85642614152014-01-09 00:00:00509.0000.0000.0000.0000.0000.0000 509.0000102014-01-09 00:00:002014-01-29 00:00:002014-01-29 00:00:0000000MTNL.25108911 RGN----------------- 575910RB2014-01-29 12:39:340.000025108911010125108911/12000000000000