Spreadsheet: 672087d1586719870-retriving-most-recent-payment-2020-payment-history-test
Sheet: Payment file

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
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61EE89BB137C54E019A0E | 4007360470 | [PHONE] | 5 | 20191211 | 20180810 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU000006 | 2 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1ED6ADFE172D9A410A08 | 4007097885 | [PHONE] | 5 | 20191211 | 20170208 | 20191231 | 30.23 | 0 | 0 | 3.93 | 34.16 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU000006 | 2 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1EE89BE87ACAFC8DC50E | 4007360494 | [PHONE] | 5 | 20191211 | 20180810 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU000018 | 3 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | 643150FF56921ED7979A2181FF360406 | 4007226773 | [PHONE] | 5 | 20191211 | 20171109 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU000018 | 3 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61EE89BD19CEA5B935108 | 4007127504 | [PHONE] | 5 | 20191211 | 20170408 | 20191231 | 30.23 | 0 | 0 | 3.93 | 34.16 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU000030 | 60 Burning Springs Pl
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61ED8BDE4EFEE2FBEC602 | 4007473746 | [PHONE] | 5 | 20191211 | 20190110 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200103 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU000030 | 60 Burning Springs Pl
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61EE5A4C135B16BF7900A | 4006919738 | [PHONE] | 5 | 20191211 | 20160112 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200103 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU002444 | 240 Wood Acres Grove
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EE5A0D90ADA808D8F0E | 4006919776 | [PHONE] | 5 | 20191211 | 20160112 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU002446 | 618 Rockrose Way
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1ED6AEE4BAA452990606 | 4007097858 | [PHONE] | 5 | 20191211 | 20170208 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU004238 | 319 Alasken Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1EE784F8AC5EF735800A | 4007198809 | [PHONE] | 5 | 20191211 | 20170912 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006119 | 827 Cedar Creek Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1ED7859727495E37D60A | 4007173127 | [PHONE] | 5 | 20191211 | 20170711 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006131 | 820 Cedar Creek Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1EE784FF09CAFBD70A0E | 4007173153 | [PHONE] | 5 | 20191211 | 20170711 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006133 | 824 Cedar Creek Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1ED79794CD979D339504 | 4007198902 | [PHONE] | 5 | 20191211 | 20170912 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006141 | 836 Cedar Creek Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321ED7A4CCA215184EC30C | 4007226765 | [PHONE] | 5 | 20191211 | 20171109 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006151 | 4362 Kelly Farm Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81ED6AEF8399EA4601108 | 4007113298 | [PHONE] | 5 | 20191211 | 20170310 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006164 | 316 Gracewood Cres
Enbridge | 01 | 2020 | 2 | I | E | 643150FF56921EE89B838E41EA361E06 | 4007360490 | [PHONE] | 5 | 20191211 | 20180810 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006264 | 316 Maberly Way
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321ED6AE85FF1273E9540A | 4007097848 | [PHONE] | 5 | 20191211 | 20170208 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006302 | 558 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61ED7A4EDE85054EB9E00 | 4007242621 | [PHONE] | 5 | 20191211 | 20171209 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006305 | 566 Rockrose Way
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EE796E85F94EEA3D706 | 4007226795 | [PHONE] | 5 | 20191211 | 20171109 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU006309 | 355 Alasken Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321EE8A1C592C73D03C000 | 4007384864 | [PHONE] | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU008698 | 553 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | [NAME] | 4007173080 | [PHONE] | 5 | 20191211 | 20170711 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU013019 | 555 Silverbell Cres
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EEA809592960D71DE02 | 4007211903 | [PHONE] | 5 | 20191211 | 20171011 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191106 | 20191209 | [PHONE] | 0 | CU013860 | 207 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1ED6AE830F5262930800 | 4007198821 | [PHONE] | 5 | 20191211 | 20170912 | 20191231 | 30.23 | 0 | 0 | 3.93 | 34.16 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU016363 | 68 Streathern Way
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1EE8A1BF6BE902191F0A | 4007384871 | [PHONE] | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU019737 | 556 Silverbell Cres
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1EE796E539ED3CB40104 | 4007186089 | [PHONE] | 5 | 20191211 | 20170812 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU020357 | 780 Cedar Creek Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1ED8A1C5A00C9E755E0A | 4007371841 | [PHONE] | 5 | 20191211 | 20180911 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU020421 | 730 Sora Way
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1EE9A4BBC8AB7230DF06 | 4007242753 | [PHONE] | 5 | 20191211 | 20171209 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU020445 | 108 Kestrel St
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59D5E1ED8AAD9E4E3EA8FC108 | 4007474136 | [PHONE] | 5 | 20191211 | 20190110 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU026558 | 36 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1EE784F928C31A1B120E | 4007082527 | [PHONE] | 5 | 20191211 | 20170110 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU026924 | 48 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C5A53E1ED8BDE3C04F3B5ADD04 | 4007474141 | [PHONE] | 5 | 20191211 | 20190110 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU027953 | 10 Sagebrush Cres
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81ED89BCFA2B7EB6D1102 | 4007360524 | [PHONE] | 5 | 20191211 | 20180810 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU027983 | 626 Sora Way
Enbridge | 01 | 2020 | 2 | I | B | D89D67C59F321EDA81E996740D0F940C | 206217384 | [PHONE] | 4 | 20191211 | 20191210 | 20191231 | 21.53 | 0 | 0 | 2.8 | 24.33 | 20200102 | 51 | 0 | 0 | 0 | E | 20191207 | 20191207 | [PHONE] | 0 | CU029326 | 950 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | [NAME] | 4006993322 | [PHONE] | 5 | 20191211 | 20160701 | 20200102 | 30.23 | 0 | 0 | 3.93 | 34.16 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU029456 | 3 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EE8A194495BABAC8004 | 4007360484 | [PHONE] | 5 | 20191211 | 20180810 | 20191231 | 30.74 | 0 | 0 | 4 | 34.74 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU029580 | 243 [NAME] Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DCA1ED89BCB2502F716000A | 4007347123 | [PHONE] | 5 | 20191211 | 20180710 | 20191231 | 30.74 | 0 | 0 | 4 | 34.74 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU029607 | 271 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61ED8BDF369744AA75D04 | 4007474166 | [PHONE] | 5 | 20191211 | 20190110 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU029652 | 6 Lyle Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61EE8BDD6AB4AF1658E04 | 4007474171 | [PHONE] | 5 | 20191211 | 20190110 | 20191231 | 37.91 | 0 | 0 | 4.93 | 42.84 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU029681 | [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61ED8BDDA0A486F789504 | 4007473717 | [PHONE] | 5 | 20191211 | 20190110 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU029686 | 238 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81EE79BCA3F2D9C6B010A | 4006853177 | [PHONE] | 5 | 20191211 | 20150812 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU030054 | 44 [NAME]
Enbridge | 01 | 2020 | 2 | I | B | 643150FF56921EEA81D9DBFE6D16450A | 206221241 | [PHONE] | 5 | 20191211 | 20191210 | 20191231 | 51.54 | 0 | 0 | 6.7 | 58.24 | 20200102 | 51 | 0 | 0 | 0 | E | 20191210 | 20191210 | [PHONE] | 0 | CU032184 | 61 Salamander Way
Enbridge | 01 | 2020 | 2 | I | E | 3C4A924803B61EE8BDD1A27656F69F04 | 4007473768 | [PHONE] | 5 | 20191211 | 20190110 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU036201 | 15 Sagebrush Cres
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81ED8AAC674DE22074700 | 4006892258 | [PHONE] | 5 | 20191211 | 20151110 | 20191231 | 42.53 | 0 | 0 | 5.53 | 48.06 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU036307 | 677 Willowmere Way
Enbridge | 01 | 2020 | 2 | I | E | [NAME] | 4007384816 | [PHONE] | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU036536 | 145 [NAME] Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321EE8AADD078DFD5B860C | 4006853336 | [PHONE] | 5 | 20191211 | 20150812 | 20191231 | 27.99 | 0 | 0 | 3.64 | 31.63 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU036537 | 42 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81ED8AAC4966C64099008 | 4007384880 | [PHONE] | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU036655 | 142 [NAME] Dr
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59F321EE8BDDCBAB3DC6F9F0C | 4007474032 | [PHONE] | 5 | 20191211 | 20190110 | 20191231 | 42.01 | 0 | 0 | 5.46 | 47.47 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU037068 | 564 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59BF61ED8BDF899BC1CAC0F0E | 4007384814 | [PHONE] | 5 | 20191211 | 20181010 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191109 | 20191209 | [PHONE] | 0 | CU038907 | 183 [NAME]
Enbridge | 01 | 2020 | 2 | I | E | D89D67C59DB81EEA8099E4AC3DFCC404 | 4007487770 | [PHONE] | 5 | 20191211 | 20190209 | 20191231 | 43.06 | 0 | 0 | 5.6 | 48.66 | 20200102 | 51 | 510001 | 0 | 0 | E | 20191115 | 20191209 | [PHONE] | 0 | CU046921 | 191 [NAME]