SQL MANAGER
DB biketra1_misc ; Table account
*** Table: account (41 recs): Modify data or structure ***
Database Add Drop  | Table: Add Drop    |  Structure  Data
SQL Editor
SITE:
Host-ed

DB's:
biketra1_bike
biketra1_cal
biketra1_food
biketra1_misc
biketra1_music
biketra1_qpb
biketra1_tour

Export SQL DB
Import SQL
Read SQL

LOGOFF
Tables:
account
accttype
blpr
costbasis
dirlist
fininst
master
mort
notes
plot
pmt
smsSched
smssetup

Export SQL Table
Export Table to CVS
Import Table from CSV
Start with Rec # 1 26
.Idfininstdescrtypenocommentdetailfreqtodoaccidaccpassword
381Marlin Family Trust39607-1251Yvonne successor trustee, http://biketrain.net/misc/data/Trust2006.pdfNAMjobtraklitejackieI522543_
481IRA - Paul42023-8417contingent benef K,Y & D 1/3 each per sterpes, chg 3/31/17NAMcheck beneficiariesjobtraklitejackieF522543_
781IRA - Jeanine45086-3387contingent benef K,Y & D 1/3 each per sterpes, chg 3/31/17NAMjobtraklite1jackieF522543_
142Checking - Mercantile5444332Pay on death account subsidiary of United Community Bank?QCheck with bank re transition; bank expects you to change password every once in a whilejobtraklitejackieM522543_
152Certificate of Deposit - Mercantile5X4663orig 5/10/23; matures 08/10/24; 4.15%NAfeldkirchaustria`]5p
176Bright Start TE College savings plan75000258714current beneficiary Izabella; can be changed to next grandchildMFeed Money as needed; contributions are tax deductible on Ill income tax. Current benef Izabella; change when she graduatesjobtraklitejackieB522543_
1870Home, 1815 Hampshire923-1-2087-000-00filed in name of trust; prop tax due 7/15 & 9/1?M
1968Diann and Andrew consolidated rentals + home8current interest 3.5%; balloon due 51 months after 05/22/15, mo pmt 1387.58Monthly auto deposit to Mercantile BankMnonelongmont
2388Home owner insurance - Hampshire10103683293year to year as of Aug 15CC at Quincy Insurance GroupANext renewal 8/15/24
2511Medicare advantage plan - Jeanine10ID 101042214500$0 premium for 2023, includes prescription coverageif premium, then automatically deducted monthly from Mercantile checkingMpay co-pays to providersjobtraklite2jackieC522543_
2613Gas & Electric - Vermont St.103645010249Bill comes via email. Use Bill Pay at MercantileMmarlin@biketrain.netjack_5225
2716Water, Sewer - Quincy1026269-26046Water shut off and account stops when in Florida; no recycle as of May 2023Automatic monthly merc debit card paymentMcall to stop when leaving for Florida. Need someone here to restart.marlin@biketrain.netjackieW522543_
2865IRS quarterly estimated payment10420-54-3257&392-48-9524quaterly pmt = 1/4 prior year tax liabilityCC via pay1040.com (cost 1.88%, earns $.03 toward Amtrak travel)QSelect make a payment
2915Illinois Income tax estimated payment10quaterly pmt = 1/4 prior year tax liabilitybank draft via My Tax Illinois website; go to Payments: Make an IL-1040, IL-1040-ES, paymentQ
3012Sunday collection - SFS10Envelope #: 128$225 when home, $125 when in FLMonthly automatic OSV giving with my FNBO credit cardMchange when movejobtraklitejack5225
3112Alaska parish donation10Envelope #: 128$25/moAutomatic monthly payment OSV Giving with J's FNBO CCM
3271Auto insurance - Honda10971605613pmt semi-ann 8/15 to 2/15, 2/15-8/15. Both policies, same websiteCC at Quincy Insurance Group, 1601 Broadway, Quincy, 217-222-3663Snext due 2/15/24
3418Host-ed Web Hosting Svc10biketrain.netNext due date 08/11/2022; $4-5 per monthinvoice for 3 yrs via email; can call for less time; pay via CC at site3can drop, along with biketrain.net domain name, when no longer neededmarlin@biketrain.netjackieH522543_
3618Domain name registration (biketrain.net)10biketrain.netnext due date 24/11/2022, $11.99email invoice; pay via CC or paypal at siteAcan drop, along with host-ed web hosting service, when no longer neededmarlin@biketrain.netjackieH522543_
4224Internet service - fiber optic103158300 000 000 0000lifetime monthly rate 49.95 + 4.50 modem;FNBO CC on file at https://adams.smarthub.coop/Login.html#login:Mdrop when no longer needed: marlin@biketrain.netjackieI522543_
4329Hosting service - X1010nonebike tour blogs website. CC NOT on fileQapprox $71/yr; automatically updates annually; last pmt Aug 27, 2020. Cancel service as of Aug 23marlin@biketrain.netPv5clQ2c2rhc
4635Quincy Medical Group1011016312Acct # is called Gurarantor ID; via CC at www.quincymedgroup.com/D
471Annuity - Fidelity retirement (tax defered)2233033289DjobtraklitejackieI522543_
4933Hospital & Physicians 104001018201Paul & Jeanine, Account = invoice (amt due)website; account number found on paper statement; otherwise billing office in East Office BldgD
5059Condo HOA dues10354303on 3rd of each month, currently $467ACH draft from Mercantile BankMHow to change?marlin@biketrain.netjack5225