Spreadsheet: 672056d1586705198-retriving-most-recent-payment-2020-payment-history-test
Sheet: Payment file

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(LEFT(S1,4)&"-"&MID(S1,5,2)&"-"&RIGHT(S1,2))
TYPE | Month | Year | Record_Type | Record_ID | Original_Txn_Record_Id | Open_Bill_Ref_Num | EGD_Transaction_ID | EGD_Document_ID | Bill_Cycle | Bill_Date | Posted_Date | Late_Payment_Penalty_Date | Billed_Amount | PST_Amount | GST_Amount | HST_Amount | Total_Including_Taxes | Payment_Date | Bill_Type_Code | Rental_Type | Finalized_Indicator | Indicator | Receivable_Owner | Billing_Period_From_Date | Billing_Period_To_Date | Billing_Period_Source_Doc | Manual_Adj_Comments | Customer No. | Address | Payment_Date2
Enbridge | 01 | 2020 | 2 | I | E | [NAME] | 4007173080 | 501001958280 | 5 | 20191211 | 20170711 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 155009366921 | 0 | CU013019 | 555 Silverbell Cres | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81ED89BCFA2B7EB6D1102 | 4007360524 | 501001958367 | 5 | 20191211 | 20180810 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 164009062035 | 0 | CU027983 | 626 Sora Way | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1ED89BCB2502F716000A | 4007347123 | 501001958389 | 5 | 20191211 | 20180710 | 20191231 | 30.74 | 0 | 0 | 4 | 34.74 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 172008662324 | 0 | CU029607 | 271 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61EE89BB137C54E019A0E | 4007360470 | 501001958390 | 5 | 20191211 | 20180810 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 164009062023 | 0 | CU000006 | 2 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1EE89BE87ACAFC8DC50E | 4007360494 | 501001958394 | 5 | 20191211 | 20180810 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 164009062029 | 0 | CU000018 | 3 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | 643150FF56921EE89B838E41EA361E06 | 4007360490 | 501001958407 | 5 | 20191211 | 20180810 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 164009062028 | 0 | CU006264 | 316 Maberly Way | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61EE89BD19CEA5B935108 | 4007127504 | 501001958440 | 5 | 20191211 | 20170408 | 20191231 | 30.23 | 0 | 0 | 3.93 | 34.16 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 817001481005 | 0 | CU000030 | 60 Burning Springs Pl | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81EEA8099E4AC3DFCC404 | 4007487770 | 501001958459 | 5 | 20191211 | 20190209 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191115 | 20191209 | 187006570041 | 0 | CU046921 | 191 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EEA809592960D71DE02 | 4007211903 | 501001958480 | 5 | 20191211 | 20171011 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191106 | 20191209 | 197001639218 | 0 | CU013860 | 207 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1EE784F928C31A1B120E | 4007082527 | 502001942273 | 5 | 20191211 | 20170110 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 129010025671 | 0 | CU026924 | 48 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1EE784F8AC5EF735800A | 4007198809 | 502001942292 | 5 | 20191211 | 20170912 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 166008944284 | 0 | CU006119 | 827 Cedar Creek Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1EE784FF09CAFBD70A0E | 4007173153 | 502001942296 | 5 | 20191211 | 20170711 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 155009366934 | 0 | CU006133 | 824 Cedar Creek Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1ED7859727495E37D60A | 4007173127 | 502001942300 | 5 | 20191211 | 20170711 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 155009366932 | 0 | CU006131 | 820 Cedar Creek Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81ED8AAC4966C64099008 | 4007384880 | 502001942326 | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 165009012827 | 0 | CU036655 | 142 [NAME] Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81ED8AAC674DE22074700 | 4006892258 | 502001942332 | 5 | 20191211 | 20151110 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 128010018166 | 0 | CU036307 | 677 Willowmere Way | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | [NAME] | 4007384816 | 502001942398 | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 165009012811 | 0 | CU036536 | 145 [NAME] Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1ED8AAD9E4E3EA8FC108 | 4007474136 | 502001942404 | 5 | 20191211 | 20190110 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 192001723111 | 0 | CU026558 | 36 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321EE8AADD078DFD5B860C | 4006853336 | 502001942409 | 5 | 20191211 | 20150812 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 175008420613 | 0 | CU036537 | 42 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | B | 643150FF56921EEA81D9DBFE6D16450A | 206221241 | 502001942449 | 5 | 20191211 | 20191210 | 20191231 | 51.54 | 0 | 0 | 6.7 | 58.24 | 20200102 | 51 | 0 | 0 | 0 | E | 20191210 | 20191210 | 41701076011 | 0 | CU032184 | 61 Salamander Way | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | B | D89D67C59F321EDA81E996740D0F940C | 206217384 | 502001942474 | 4 | 20191211 | 20191210 | 20191231 | 21.53 | 0 | 0 | 2.8 | 24.33 | 20200102 | 51 | 0 | 0 | 0 | E | 20191207 | 20191207 | 44501133286 | 0 | CU029326 | 950 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321ED6AE85FF1273E9540A | 4007097848 | 503001935219 | 5 | 20191211 | 20170208 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 807001576922 | 0 | CU006302 | 558 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1ED6ADFE172D9A410A08 | 4007097885 | 503001935221 | 5 | 20191211 | 20170208 | 20191231 | 30.23 | 0 | 0 | 3.93 | 34.16 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 807001576932 | 0 | CU000006 | 2 [NAME] | 2020/02/05
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1ED6AE830F5262930800 | 4007198821 | 503001935263 | 5 | 20191211 | 20170912 | 20191231 | 30.23 | 0 | 0 | 3.93 | 34.16 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 166008944292 | 0 | CU016363 | 68 Streathern Way | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1ED6AEE4BAA452990606 | 4007097858 | 503001935287 | 5 | 20191211 | 20170208 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 807001576925 | 0 | CU004238 | 319 Alasken Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81ED6AEF8399EA4601108 | 4007113298 | 503001935294 | 5 | 20191211 | 20170310 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 110010496189 | 0 | CU006164 | 316 Gracewood Cres | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EE8A194495BABAC8004 | 4007360484 | 503001935310 | 5 | 20191211 | 20180810 | 20191231 | 30.74 | 0 | 0 | 4 | 34.74 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 164009062026 | 0 | CU029580 | 243 [NAME] Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321EE8A1C592C73D03C000 | 4007384864 | 503001935311 | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 165009012823 | 0 | CU008698 | 553 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1EE8A1BF6BE902191F0A | 4007384871 | 503001935312 | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 165009012825 | 0 | CU019737 | 556 Silverbell Cres | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1ED8A1C5A00C9E755E0A | 4007371841 | 503001935334 | 5 | 20191211 | 20180911 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 151009464881 | 0 | CU020421 | 730 Sora Way | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1EE796E539ED3CB40104 | 4007186089 | 504001915747 | 5 | 20191211 | 20170812 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 168008838855 | 0 | CU020357 | 780 Cedar Creek Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | 643150FF56921ED7979A2181FF360406 | 4007226773 | 504001915762 | 5 | 20191211 | 20171109 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 114010359456 | 0 | CU000018 | 3 [NAME] | 2020/02/07
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EE796E85F94EEA3D706 | 4007226795 | 504001915791 | 5 | 20191211 | 20171109 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 114010359466 | 0 | CU006309 | 355 Alasken Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1ED79794CD979D339504 | 4007198902 | 504001915798 | 5 | 20191211 | 20170912 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 166008944320 | 0 | CU006141 | 836 Cedar Creek Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61ED8BDE4EFEE2FBEC602 | 4007473746 | 504001915826 | 5 | 20191211 | 20190110 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 192001723073 | 0 | CU000030 | 60 Burning Springs Pl | 2020/03/11
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61ED8BDDA0A486F789504 | 4007473717 | 504001915827 | 5 | 20191211 | 20190110 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 192001723063 | 0 | CU029686 | 238 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EE8BDD1A27656F69F04 | 4007473768 | 504001915836 | 5 | 20191211 | 20190110 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 192001723077 | 0 | CU036201 | 15 Sagebrush Cres | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61ED8BDF899BC1CAC0F0E | 4007384814 | 504001915860 | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 165009012809 | 0 | CU038907 | 183 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61EE8BDD6AB4AF1658E04 | 4007474171 | 504001915865 | 5 | 20191211 | 20190110 | 20191231 | 37.91 | 0 | 0 | 4.93 | 42.84 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 192001723120 | 0 | CU029681 | [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321EE8BDDCBAB3DC6F9F0C | 4007474032 | 504001915866 | 5 | 20191211 | 20190110 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 192001723101 | 0 | CU037068 | 564 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61ED8BDF369744AA75D04 | 4007474166 | 504001915869 | 5 | 20191211 | 20190110 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 192001723118 | 0 | CU029652 | 6 Lyle Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1ED8BDE3C04F3B5ADD04 | 4007474141 | 504001915877 | 5 | 20191211 | 20190110 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 192001723112 | 0 | CU027953 | 10 Sagebrush Cres | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61EE5A4C135B16BF7900A | 4006919738 | 505001893012 | 5 | 20191211 | 20160112 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 125010100169 | 0 | CU002444 | 240 Wood Acres Grove | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | [NAME] | 4006993322 | 505001893072 | 5 | 20191211 | 20160701 | 20200102 | 30.23 | 0 | 0 | 3.93 | 34.16 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 126010081851 | 0 | CU029456 | 3 [NAME] | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61ED7A4EDE85054EB9E00 | 4007242621 | 505001893102 | 5 | 20191211 | 20171209 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 161009165533 | 0 | CU006305 | 566 Rockrose Way | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321ED7A4CCA215184EC30C | 4007226765 | 505001893112 | 5 | 20191211 | 20171109 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 114010359452 | 0 | CU006151 | 4362 Kelly Farm Dr | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1EE9A4BBC8AB7230DF06 | 4007242753 | 505001893238 | 5 | 20191211 | 20171209 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 161009165556 | 0 | CU020445 | 108 Kestrel St | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EE5A0D90ADA808D8F0E | 4006919776 | 506001892166 | 5 | 20191211 | 20160112 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 125010100177 | 0 | CU002446 | 618 Rockrose Way | 2020/01/02
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81EE79BCA3F2D9C6B010A | 4006853177 | 506001892218 | 5 | 20191211 | 20150812 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | 175008420604 | 0 | CU030054 | 44 [NAME] | 2020/01/02