SQLite format 3@ L@J?>75-.#%  ?<2005-12-24 10:01:54 -0500  jC"]< !? 2005-12-24 10:01:56 -0500V8.0&? 2005-07-14 12:00:00 -0500V15.0D R6&? 2005-05-23 12:00:00 -0500V15.0D R5& ? 2005-01-05 12:00:00 -0500V15.0D R1 ? 2004-01-13 12:00:00 -0500UR& ? 2004-01-13 12:00:00 -0500V13.0D R1& ? 2003-02-18 12:00:00 -0500V12.0D R1% ? 2001-01-24 12:00:00 -0500V9.0D R1%? 2000-12-15 12:00:00 -0500V8.0D R6%? 2000-10-09 12:00:00 -0500V8.0D R5? 2000-01-16 12:00:00 -0500UR%? 2000-01-16 12:00:00 -0500V8.0D R1%? 1999-03-08 12:00:00 -0500V7.0D R1? 1998-09-03 12:00:00 -0500UR%? 1998-09-03 12:00:00 -0500V6.0D R1%? 1998-08-11 12:00:00 -0500V5.0D R4TSQR6Q K~fK%Int'l TravelFlow Thru  Building%Home ServiceVehicleBiblesGeneral  !Newsletter  )Monthly Report       V%  !  Publications0.00$0.00$0#0#1900-00-000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$V  !  Training0.00$0.00$0#0#1900-00-000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$V%  !  Contribution0.00$0.00$0#0#1900-00-000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$V  !  T-Shirts0.00$0.00$0#0#1900-00-000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$ 2F'o''tableschemaHistoryschemaHistoryCREATE TABLE schemaHistory ( version INTEGER NOT NULL, updateDate TEXT )##MtablefileHistoryfileHistoryCREATE TABLE fileHistory ( lastDateUsed TEXT, version TEXT NOT NULL, explanation TEXT NOT NULL )QutableaccountsaccountsCREATE TABLE accounts ( number TEXT, name TEXT, endingBal TEXT, color_red INTEGER, color_green INTEGER, color_blue INTEGER, reimbAccnt INTEGER, parent INTEGER, bits INTEGER, delCount INTEGER, bankNum TEXT, desc TEXT, lastHandDoc TEXT, lastPrintDoc TEXT, firstUnclearedDate TEXT, firstToPrintDate TEXT, firstOpenDate TEXT, serviceChargeAccnt INTEGER, serviceChargeDate TEXT, interestAccnt INTEGER, interestDate TEXT, lastStmtDate TEXT, ccPmtAccnt INTEGER, ccPayee INTEGER, usualVatCode INTEGER, taxLineID INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, fiBID INTEGER, fiAccountNumber TEXT, fiRoutingNumber TEXT, fiDownloadMethod INTEGER, fiAccountType TEXT, hidden INTEGER )7EtableclassesclassesCREATE TABLE classes ( name TEXT, parent INTEGER, bits INTEGER, delCount INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )^''{tablecustomerTypescustomerTypesCREATE TABLE customerTypes ( name TEXT, delCount INTEGER, parent INTEGER, deleted INTEGER, subLevel INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )V%%otablecustomStylescustomStylesCREATE TABLE customStyles ( name TEXT, delCount INTEGER, deleted INTEGER, printBits INTEGER, screenBits INTEGER, dateTitle TEXT, invNumTitle TEXT, termsTitle TEXT, dueDateTitle TEXT, billToTitle TEXT, shipToTitle TEXT, poNumTitle TEXT, other1Title TEXT, itemTitle TEXT, descTitle TEXT, qtyTitle TEXT, rateTitle TEXT, amountTitle TEXT, serviceDateTitle TEXT, other2Title TEXT, other3Title TEXT, repTitle TEXT, fobTitle TEXT, shipDateTitle TEXT, shipViaTitle TEXT, title TEXT, customerMsgTitle TEXT, totalTitle TEXT, jobTitle TEXT, printBits2 INTEGER, amountDueTitle TEXT, amountEncTitle TEXT, balanceTitle TEXT, amountDueFtrTitle TEXT, currentTitle TEXT, due130Title TEXT, due3160Title TEXT, due6190Title TEXT, dueOver90Title TEXT, custFieldPrintBits INTEGER, custFieldScreenBits INTEGER, tabFields0 TEXT, tabFields1 TEXT, tabFields2 TEXT, tabFields3 TEXT, tabFields4 TEXT, boxFields0 TEXT, boxFields1 TEXT, boxFields2 TEXT, boxFields3 TEXT, boxFields4 TEXT, boxFields5 TEXT, boxFields6 TEXT, boxFields7 TEXT, boxFields8 TEXT, boxFields9 TEXT, boxFields10 TEXT, boxFields11 TEXT, boxFields12 TEXT, boxFields13 TEXT, boxFields14 TEXT, clas TEXT, serviceDateOrder INTEGER, itemOrder INTEGER, descOrder INTEGER, other2Order INTEGER, qtyOrder INTEGER, other3Order INTEGER, rateOrder INTEGER, amountOrder INTEGER, serviceDateWidth TEXT, itemWidth TEXT, descWidth TEXT, other2Width TEXT, qtyWidth TEXT, other3Width TEXT, rateWidth TEXT, amountWidth TEXT, custFieldOrders0 INTEGER, custFieldOrders1 INTEGER, custFieldOrders2 INTEGER, custFieldOrders3 INTEGER, custFieldOrders4 INTEGER, classOrder INTEGER, custFieldWidths0 TEXT, custFieldWidths1 TEXT, custFieldWidths2 TEXT, custFieldWidths3 TEXT, custFieldWidths4 TEXT, classWidth TEXT, styleView INTEGER, screenBits2 INTEGER, estItemTotalTitle TEXT, estMarkupTitle TEXT, estItemTotalOrder INTEGER, estMarkupOrder INTEGER, estItemTotalWidth TEXT, estMarkupWidth TEXT, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY )  ~GmtableitemsitemsCREATE TABLE items ( type INTEGER, taxable INTEGER, printSubs INTEGER, subLevel INTEGER, special INTEGER, isGroup INTEGER, isPassedThru INTEGER, deleted INTEGER, depositType INTEGER, delCount INTEGER, name TEXT, desc0 TEXT, desc1 TEXT, desc2 TEXT, salesPrice TEXT, postAccnt INTEGER, paymentMethod INTEGER, taxAgency INTEGER, taxDistrict TEXT, subCount INTEGER, subItems0 INTEGER, subItems1 INTEGER, subItems2 INTEGER, subItems3 INTEGER, subItems4 INTEGER, subItems5 INTEGER, subItems6 INTEGER, subItems7 INTEGER, subItems8 INTEGER, subItems9 INTEGER, subItems10 INTEGER, subItems11 INTEGER, subItems12 INTEGER, subItems13 INTEGER, subItems14 INTEGER, subItems15 INTEGER, subItems16 INTEGER, subItems17 INTEGER, subItems18 INTEGER, subItems19 INTEGER, usualVatCode INTEGER, usualPurchVatCode INTEGER, invAccnt INTEGER, cogsAccnt INTEGER, qtyOnHand TEXT, valOnHand TEXT, avgCost TEXT, reorderPoint TEXT, unitCost TEXT, qtyOnOrder TEXT, parent INTEGER, latestTargDate TEXT, latestTargNum INTEGER, prefVendor INTEGER, purchaseDesc0 TEXT, purchaseDesc1 TEXT, purchaseDesc2 TEXT, groupQty0 TEXT, groupQty1 TEXT, groupQty2 TEXT, groupQty3 TEXT, groupQty4 TEXT, groupQty5 TEXT, groupQty6 TEXT, groupQty7 TEXT, groupQty8 TEXT, groupQty9 TEXT, groupQty10 TEXT, groupQty11 TEXT, groupQty12 TEXT, groupQty13 TEXT, groupQty14 TEXT, groupQty15 TEXT, groupQty16 TEXT, groupQty17 TEXT, groupQty18 TEXT, groupQty19 TEXT, custFieldData0 TEXT, custFieldData1 TEXT, custFieldData2 TEXT, custFieldData3 TEXT, custFieldData4 TEXT, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )OqtablejobTypesjobTypes CREATE TABLE jobTypes ( name TEXT, parent INTEGER, deleted INTEGER, delCount INTEGER, subLevel INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )! !tablememosmemos CREATE TABLE memos ( name TEXT, delCount INTEGER, bits INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )| OtablememRptsmemRpts CREATE TABLE memRpts ( name TEXT, memRptRecNum INTEGER, delCount INTEGER, timeStamp INTEGER, deleted INTEGER, modTimeStamp INTEGER, subLevel INTEGER, isGroup INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY ) QtablememTransmemTransCREATE TABLE memTrans ( name TEXT, tView INTEGER, amount TEXT, freq INTEGER, nextDate TEXT, subseqDate TEXT, origDay INTEGER, subseqOrigDay INTEGER, delCount INTEGER, parent INTEGER, masterRec INTEGER, bits INTEGER, timeStamp INTEGER, sourceAccnt INTEGER, numLeft INTEGER, daysInAdvance INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY )  L Thanks so much for your gift and prayer support! May God bless!(GHey, We sure appreciate you!   "p? f0 { C  o ! L "( +Year End Report@M@n3 G•Accountant - Trial Balance>R_`4 I•Accountant - General Ledger>R_`3 G•Accountant - Profit & Loss>R_`3 G•Accountant - Balance Sheet>R_`L y•Accountant - Journal Entries Entered/Modified Today>R_`: U•Company - Statement of Cash Flows:o?0 A•Company - Balance Sheet:o?0 A•Company - Profit & Loss:o?2 E•Customers - Open Invoices:o?6 M•Customers - A/R Aging Summary :o?< Y•Customers - Customer Balance Detail :o?= [•Customers - Customer Balance Summary :o?6 M•Vendors - Unpaid Bills Detail :o?4 I•Vendors - A/P Aging Summary :o?8 Q•Vendors - Vendor Balance Detail:o?9 S•Vendors - Vendor Balance Summary:o?. 7Monthly Expense Recap6O-BO2 ?Year-End Giving Statement6O:o@E/ 9Monthly Receipts Recap5ߚSB9/ ?•Banking - Check Detail:o?. 7Annual Receipts Recap6OxA- 5Annual Expense Recap6OwA L: !!0.00$1900-00-001900-00-00 : !!0.00$1900-00-001900-00-00 : !!0.00$1900-00-001900-00-00 : !!0.00$1900-00-001900-00-00 WV-U  2 }: StablenamesnamesCREATE TABLE names ( hasNotes INTEGER, is1099Vendor INTEGER, deleted INTEGER, subLevel INTEGER, taxable INTEGER, type INTEGER, delCount INTEGER, name TEXT, addr0 TEXT, addr1 TEXT, addr2 TEXT, addr3 TEXT, addr4 TEXT, shipTo0 TEXT, shipTo1 TEXT, shipTo2 TEXT, shipTo3 TEXT, shipTo4 TEXT, tel1 TEXT, tel2 TEXT, initials TEXT, faxNum TEXT, contact1 TEXT, contact2 TEXT, taxID TEXT, resaleNum TEXT, note TEXT, parent INTEGER, rep INTEGER, creditLimit TEXT, terms INTEGER, nameType INTEGER, nameOnCheck TEXT, endingBal TEXT, firstOpenDate TEXT, noteOrAccNum TEXT, taxItem INTEGER, first TEXT, mi TEXT, last TEXT, cityOLD TEXT, stateOLD TEXT, zipOLD TEXT, jobDescription TEXT, jobType INTEGER, jobStatus INTEGER, jobStart TEXT, jobProjectedEnd TEXT, jobEnd TEXT, estimateTotal TEXT, estimateRecNum INTEGER, salutation TEXT, companyName TEXT, customField0 TEXT, customField1 TEXT, customField2 TEXT, customField3 TEXT, customField4 TEXT, customField5 TEXT, customField6 TEXT, customField7 TEXT, customField8 TEXT, customField9 TEXT, customField10 TEXT, customField11 TEXT, customField12 TEXT, customField13 TEXT, customField14 TEXT, email TEXT, emailUUID TEXT, street10 TEXT, street11 TEXT, street20 TEXT, street21 TEXT, street30 TEXT, street31 TEXT, street40 TEXT, street41 TEXT, city0 TEXT, city1 TEXT, region0 TEXT, region1 TEXT, postalCode0 TEXT, postalCode1 TEXT, country0 TEXT, country1 TEXT, addressUUID0 TEXT, addressUUID1 TEXT, nameUUID TEXT, mainPhoneUUID TEXT, groupUUID TEXT, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER, shipToNote TEXT )0 !!+tablepayMethodspayMethodsCREATE TABLE payMethods ( name TEXT, delCount INTEGER, bits INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )|%%;tablepaymentTermspaymentTermsCREATE TABLE paymentTerms ( name TEXT, delCount INTEGER, dueDays INTEGER, discPerc INTEGER, discDays INTEGER, bits INTEGER, minDays INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )-)tableshipTypesshipTypesCREATE TABLE shipTypes ( name TEXT, delCount INTEGER, bits INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )6KtabletoDostoDosCREATE TABLE toDos ( toDoText TEXT, remindDate TEXT, delCount INTEGER, bits INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )X##wtablevendorTypesvendorTypesCREATE TABLE vendorTypes ( name TEXT, delCount INTEGER, parent INTEGER, deleted INTEGER, subLevel INTEGER, updateCount INTEGER, recNum INTEGER NOT NULL PRIMARY KEY, hidden INTEGER )k!!!tableactivitiesactivitiesCREATE TABLE activities ( job INTEGER, employee INTEGER, item INTEGER, pItem INTEGER, duration TEXT, proj INTEGER, noteID INTEGER, bits INTEGER, date TEXT NOT NULL, recNum INTEGER NOT NULL PRIMARY KEY )2''#tableattributeDefsattributeDefsCREATE TABLE attributeDefs ( name TEXT, ownerIdStr TEXT, dataType INTEGER, controlFlags INTEGER, listAccess INTEGER, txnAccess INTEGER, deleted INTEGER, delCount INTEGER, isHidden INTEGER, timeStamp INTEGER, modTimeStamp INTEGER, recNum INTEGER NOT NULL PRIMARY KEY )))]tableauditDictItemsauditDictItemsCREATE TABLE auditDictItems ( usageCount INTEGER, dictString TEXT, recNum INTEGER NOT NULL PRIMARY KEY )%%CtableauditMastersauditMastersCREATE TABLE auditMasters ( transNum INTEGER, modTime INTEGER, date TEXT, refDoc INTEGER, addr0 INTEGER, shipTo0 INTEGER, fob INTEGER, invTitle INTEGER, terms INTEGER, rep INTEGER, dunningMemo INTEGER, via INTEGER, firstTarg INTEGER, numTargets INTEGER, shipDate TEXT, sourceDoc INTEGER, deleteTime INTEGER, addr1 INTEGER, addr2 INTEGER, addr3 INTEGER, addr4 INTEGER, shipTo1 INTEGER, shipTo2 INTEGER, shipTo3 INTEGER, shipTo4 INTEGER, custFieldData0 INTEGER, custFieldData1 INTEGER, custFieldData2 INTEGER, custFieldData3 INTEGER, custFieldData4 INTEGER, key INTEGER NOT NULL, recNum INTEGER NOT NULL )     !1900-00-00    iU:ϰz)Joe MissionaryƳ$)Funds TransfereStaples"7CInternational Medical Group9Deposit䊁=)Service Charge @Admin `1003 @1002 1001   jji 2{%%CtableauditTargetsauditTargetsCREATE TABLE auditTargets ( accnt INTEGER, master_key INTEGER, master_record INTEGER, clas INTEGER, document INTEGER COLLATE documentCollation, name INTEGER, amount TEXT, quantity TEXT, unitPrice TEXT, item INTEGER, payMeth INTEGER, memo INTEGER, dueDate TEXT, bits INTEGER, openBalance TEXT, openQty TEXT, siblingAccnt INTEGER, siblingName INTEGER, view INTEGER, vatAmount TEXT, vatCode INTEGER, cogsAmount TEXT, bits2 INTEGER, billedDate TEXT, custFieldData0 INTEGER, custFieldData1 INTEGER, custFieldData2 INTEGER, custFieldData3 INTEGER, custFieldData4 INTEGER, recNum INTEGER NOT NULL PRIMARY KEY )l/tablebudgetsbudgetsCREATE TABLE budgets ( year INTEGER, account INTEGER, nameRID INTEGER, classRID INTEGER, Jan TEXT, Feb TEXT, Mar TEXT, Apr TEXT, May TEXT, Jun TEXT, Jul TEXT, Aug TEXT, Sep TEXT, Oct TEXT, Nov TEXT, Dec TEXT ) ++KtablecompanySettingscompanySettingsCREATE TABLE companySettings ( key TEXT NOT NULL PRIMARY KEY, value TEXT, updateCount INTEGER )=Q+indexsqlite_autoindex_companySettings_1companySettings119tablecustomEdListFieldscustomEdListFieldsCREATE TABLE customEdListFields ( recNum INTEGER NOT NULL PRIMARY KEY, blobData BLOB )F//;tablecustomFieldsDictscustomFieldsDicts CREATE TABLE customFieldsDicts ( hdr_dictVersion INTEGER, hdr_numEntries INTEGER, entry00_label TEXT, entry00_dictClient INTEGER, entry00_offset INTEGER, entry01_label TEXT, entry01_dictClient INTEGER, entry01_offset INTEGER, entry02_label TEXT, entry02_dictClient INTEGER, entry02_offset INTEGER, entry03_label TEXT, entry03_dictClient INTEGER, entry03_offset INTEGER, entry04_label TEXT, entry04_dictClient INTEGER, entry04_offset INTEGER, entry05_label TEXT, entry05_dictClient INTEGER, entry05_offset INTEGER, entry06_label TEXT, entry06_dictClient INTEGER, entry06_offset INTEGER, entry07_label TEXT, entry07_dictClient INTEGER, entry07_offset INTEGER, entry08_label TEXT, entry08_dictClient INTEGER, entry08_offset INTEGER, entry09_label TEXT, entry09_dictClient INTEGER, entry09_offset INTEGER, entry10_label TEXT, entry10_dictClient INTEGER, entry10_offset INTEGER, entry11_label TEXT, entry11_dictClient INTEGER, entry11_offset INTEGER, entry12_label TEXT, entry12_dictClient INTEGER, entry12_offset INTEGER, entry13_label TEXT, entry13_dictClient INTEGER, entry13_offset INTEGER, entry14_label TEXT, entry14_dictClient INTEGER, entry14_offset INTEGER, entry15_label TEXT, entry15_dictClient INTEGER, entry15_offset INTEGER, entry16_label TEXT, entry16_dictClient INTEGER, entry16_offset INTEGER, entry17_label TEXT, entry17_dictClient INTEGER, entry17_offset INTEGER, entry18_label TEXT, entry18_dictClient INTEGER, entry18_offset INTEGER, entry19_label TEXT, entry19_dictClient INTEGER, entry19_offset INTEGER, recNum INTEGER NOT NULL PRIMARY KEY )StabledictItemsdictItems!CREATE TABLE dictItems ( usageCount INTEGER, dictString TEXT, recNum INTEGER NOT NULL PRIMARY KEY )  iEi#IhideInactiveItemsSetting.151200YAcContactSyncOtherGroupUUIDcom.intuit.quickbooks.53026A30-5C02-41CF-9631-E395D2BFC250ZCcContactSyncVendorGroupUUIDcom.intuit.quickbooks.E1527236-029A-4456-8D78-8A893B0AD807\GcContactSyncCustomerGroupUUIDcom.intuit.quickbooks.647EDCB5-6AE8-4AAF-AB7C-D91CEF32DBD1[EcontactSyncEmployeeGroupUUIDcom.intuit.quickbooks.8C4C0DF3-B6DD-4745-92D0-E9314DC6D829 [~["IhideInactiveItemsSetting.15120AcContactSyncOtherGroupUUIDCcContactSyncVendorGroupUUID!GcContactSyncCustomerGroupUUID EcontactSyncEmployeeGroupUUID +++ pp