CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY, Z_UUID VARCHAR(255), Z_PLIST BLOB);
CREATE TABLE ZTAXLINEITEM ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZFORM VARCHAR, ZLINENUMBER VARCHAR, ZUSERDESCRIPTION VARCHAR );
CREATE TABLE ZFIBALANCE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZFISTATEMENT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZBALANCEVALUE DECIMAL, ZBALANCEDESCRIPTION VARCHAR, ZBALANCETYPE VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZLOTMOD ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZTERMTYPE INTEGER, ZTRANSACTIONQUICKENID INTEGER, ZLOT INTEGER, ZLOTASSIGNMENT INTEGER, ZTRANSACTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZTRANSACTIONDATE TIMESTAMP, ZAFTERCOSTBASIS DECIMAL, ZAFTERPOSITIONCOSTBASIS DECIMAL, ZAFTERPOSITIONUNITS DECIMAL, ZAFTERUNITS DECIMAL, ZBEFORECOSTBASIS DECIMAL, ZBEFOREUNITS DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZCLOUDSYNCDATA ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZQUICKENTIMESTAMP TIMESTAMP, ZMINTWATERMARK VARCHAR, ZRESOURCETYPE VARCHAR );
CREATE TABLE ZBPFIPAYEE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDAYSTOPAY INTEGER, ZDELETIONCOUNT INTEGER, ZPAYEEINFOCHANGED INTEGER, ZPAYEEINFODELETE INTEGER, ZQUICKENID INTEGER, ZUSERPAYEE INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZADDRESS1 VARCHAR, ZADDRESS2 VARCHAR, ZADDRESS3 VARCHAR, ZCITY VARCHAR, ZCLIENTASSIGNEDTRANSACTIONUID VARCHAR, ZCOUNTRY VARCHAR, ZCUSTOMERID VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZONLINEBILLPAYBID VARCHAR, ZPAYEEIDSCOPE VARCHAR, ZPAYEELISTID VARCHAR, ZPHONENUMBER VARCHAR, ZPOSTALCODE VARCHAR, ZSTANDARDPAYEEID VARCHAR, ZSTANDARDPAYEENAME VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZCLOUDFILOGIN ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSTATUSISTERMINAL INTEGER, ZFINANCIALINSTITUTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZCPSTATUS VARCHAR, ZDATASOURCE VARCHAR, ZDISPLAYNAME VARCHAR, ZGUID VARCHAR, ZLOGINNAME VARCHAR, ZPROVIDERTYPE VARCHAR, ZSTATUS VARCHAR, ZSYNCID VARCHAR, ZTOKENFORREFRESHJOB VARCHAR , ZCPLOGINID VARCHAR, ZCPCHANNEL VARCHAR);
CREATE TABLE ZFISTATEMENT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZACCOUNT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZDATEASOF TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAVAILCASH DECIMAL, ZMARGINBALANCE DECIMAL, ZSHORTBALANCE DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZSECURITYQUOTEDETAIL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSECURITYQUOTE INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZCLOSINGPRICE DECIMAL, ZHIGHESTPRICE DECIMAL, ZLOWESTPRICE DECIMAL, ZOPENINGPRICE DECIMAL, ZVOLUME DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZLOTASSIGNMENT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZDESTINATIONTRANSACTION INTEGER, ZLOTMOD INTEGER, ZSOURCETRANSACTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZUNITS DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZDOCUMENTPROPERTY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZINTVALUE INTEGER, ZTYPE INTEGER, ZDATEVALUE TIMESTAMP, ZNAME VARCHAR, ZSTRINGVALUE VARCHAR, ZBINARYVALUE BLOB );
CREATE TABLE ZSECURITYSPLIT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSECURITY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZSPLITDATE TIMESTAMP, ZDENOMINATOR DECIMAL, ZNUMERATOR DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZSYNCERROR ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZERRORLEVEL INTEGER, ZERRORSTATE INTEGER, ZQUICKENID INTEGER, ZRESOLVEOPTIONSELECTED INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZERRORSPECIFICDATA VARCHAR, ZGUID VARCHAR, ZINSTANCECLASSNAME VARCHAR, ZSYNCID VARCHAR, ZSYSTEMDESCRIPTION VARCHAR, ZUSERDESCRIPTION VARCHAR );
CREATE TABLE ZPOSITION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCOSTBASISALGORITHM INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZTYPE INTEGER, ZACCOUNT INTEGER, ZSECURITY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR, ZUNIQUEID VARCHAR, ZUNIQUEIDTYPE VARCHAR );
CREATE TABLE ZQOBJECT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZLOT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZPOSITION INTEGER, ZACQUISITIONDATE TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZINITIALTRANSACTIONDATE TIMESTAMP, ZLATESTTRANSACTIONDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZINITIALCOSTBASIS DECIMAL, ZINITIALUNITS DECIMAL, ZLATESTCOSTBASIS DECIMAL, ZLATESTUNITS DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZSECURITYQUOTE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSECURITY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZQUOTEDATE TIMESTAMP, ZCLOSINGPRICE DECIMAL, ZHIGHESTPRICE DECIMAL, ZLOWESTPRICE DECIMAL, ZOPENINGPRICE DECIMAL, ZVOLUME DECIMAL, ZCHOSENDETAILDATASOURCE VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZSECURITYID ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSECURITY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR, ZUNIQUEID VARCHAR, ZUNIQUEIDTYPE VARCHAR );
CREATE TABLE ZCASHFLOWACTION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZRETIRED INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZIMPORTSOURCEFILEID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZFIPOSITION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSECURITYTYPE INTEGER, ZFISTATEMENT INTEGER, ZCOUPONMATURITYDATE TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZDEBTMATURITYDATE TIMESTAMP, ZEXPIREDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZASSETCLASSPERCENTAGEDOMESTICBOND DECIMAL, ZASSETCLASSPERCENTAGEINTLBOND DECIMAL, ZASSETCLASSPERCENTAGEINTLSTOCK DECIMAL, ZASSETCLASSPERCENTAGELARGESTOCK DECIMAL, ZASSETCLASSPERCENTAGEMONEYMRKT DECIMAL, ZASSETCLASSPERCENTAGEOTHER DECIMAL, ZASSETCLASSPERCENTAGESMALLSTOCK DECIMAL, ZCOUPONRATE DECIMAL, ZMARKETVALUE DECIMAL, ZSECURITYUNITPRICE DECIMAL, ZSHARESPERCONTRACT DECIMAL, ZSTRIKEPRICE DECIMAL, ZUNITPRICE DECIMAL, ZUNITS DECIMAL, ZASSETCLASS VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZISSUETYPE VARCHAR, ZMEMO VARCHAR, ZOPTIONTYPE VARCHAR, ZPOSTYPE VARCHAR, ZSECURITYMEMO VARCHAR, ZSECURITYNAME VARCHAR, ZSECURITYTICKER VARCHAR, ZSECURITYTYPEDESCRIPTION VARCHAR, ZSYNCID VARCHAR, ZUNIQUEID VARCHAR, ZUNIQUEIDTYPE VARCHAR );
CREATE TABLE ZDOWNLOADSESSION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCONNECTIONMETHOD INTEGER, ZDOCUMENTOPENEDCOUNT INTEGER, ZSESSIONNUMBER INTEGER, ZDOWNLOADTIMESTAMP TIMESTAMP );
CREATE TABLE ZBPFINANCIALINSTITUTION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZBILLPAYFILEERRORRECOVERYSUPPORTED INTEGER, ZBILLPAYSUPPORTED INTEGER, ZCANADDPAYEE INTEGER, ZCANSCHEDULETRANSFER INTEGER, ZDEFAULTPAYMENTDAYSTOPAY INTEGER, ZDEFAULTPAYMENTWITHDRAWALDAYS INTEGER, ZDELETIONCOUNT INTEGER, ZMODELWINDOW INTEGER, ZPAYMENTSBYBILLINGADDRESS INTEGER, ZPAYMENTSBYPAYEEID INTEGER, ZPOSTPROCESSINGWINDOW INTEGER, ZQUICKENID INTEGER, ZSTATUSVIAMODIFYRESPONSE INTEGER, ZTRANSFERFILEERRORRECOVERYSUPPORTED INTEGER, ZTRANSFERSUPPORTED INTEGER, ZFINANCIALINSTITUTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZBILLPAYSYNCMODESUPPORTED VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZINTUDATEMODEL VARCHAR, ZPROCESSINGDAYSOFF VARCHAR, ZPROCESSINGENDTIME VARCHAR, ZSYNCID VARCHAR, ZTRANSFERSYNCMODESUPPORTED VARCHAR );
CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB);
CREATE TABLE ZLOANSPLITENTRY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZMISCFLAGS INTEGER, ZQUICKENID INTEGER, ZSEQUENCENUMBER INTEGER, ZACCOUNT INTEGER, ZCATEGORY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR, ZTRANSFER VARCHAR );
CREATE TABLE ZFOREXQUOTE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZQUOTEDATE TIMESTAMP, ZEXCHANGERATE DECIMAL, ZMANUALEXCHANGERATE DECIMAL, ZDATASOURCE VARCHAR, ZFROMCURRENCY VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR, ZTOCURRENCY VARCHAR );
CREATE TABLE ZSCHEDULEADJUSTMENTENTRY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZPARENT INTEGER, ZADJUSTEDDATE TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZORIGINALSCHEDULEDDATE TIMESTAMP, ZADJUSTEDAMOUNT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE IF NOT EXISTS "ZBILLPRESENTMENTPROVIDERLOGIN" ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZISDOCUMENTSYNCINGENABLED INTEGER, ZQUICKENID INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZACCOUNTTYPE VARCHAR, ZBILLERID VARCHAR, ZBILLERNAME VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNOTICE VARCHAR, ZPROVIDERBILLERID VARCHAR, ZPROVIDERLOGINPROVIDERID VARCHAR, ZREFRESHSTATUS VARCHAR, ZSYNCID VARCHAR , ZUSERNAME VARCHAR, ZPREFERREDUSERPAYEENAME VARCHAR, ZMIGRATEDPROVIDERBILLERID VARCHAR, ZISOAUTHDEPRECATING INTEGER);
CREATE TABLE ZALERT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZISREAD INTEGER, ZQUICKENID INTEGER, ZCREATEDAT TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGROUP VARCHAR, ZGUID VARCHAR, ZICON VARCHAR, ZMESSAGE VARCHAR, ZSYNCID VARCHAR, ZTITLE VARCHAR, ZTYPE VARCHAR );
CREATE TABLE ZFISTATEOFX ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZPASSWORDCHANGEREQUIRED INTEGER, ZQUICKENID INTEGER, ZRESPONSENOTRECEIVED INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZLASTATTEMPTTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZCUSTOMERID VARCHAR, ZDATASOURCE VARCHAR, ZDIRECTCONNECTBID VARCHAR, ZFILEUID VARCHAR, ZGUID VARCHAR, ZLASTMAILTOKEN VARCHAR, ZLASTPAYEETOKEN VARCHAR, ZLASTPMTMAILTOKEN VARCHAR, ZREQUESTINERRORRECOVERY VARCHAR, ZRESENDURL VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZFINANCIALINSTITUTION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDIRECTCONNECTINSTITUTIONID INTEGER, ZPROFILEHASRUN INTEGER, ZPROFILEINV401KDOWNLOAD INTEGER, ZPROFILEPINCHANGEALLOWED INTEGER, ZPROFILEPINRULECASESENSITIVE INTEGER, ZPROFILEPINRULEMAX INTEGER, ZPROFILEPINRULEMIN INTEGER, ZPROFILEPINRULESPACESALLOWED INTEGER, ZPROFILEPINRULESPECIALCHARSALLOWED INTEGER, ZWASACTIVEINLASTFIDIRUPDATE INTEGER, ZBPFINANCIALINSTITUTION INTEGER, ZLASTUPDATEDFROMFIDIRTIMESTAMP TIMESTAMP, ZBRANDINGINTU401KDNLDOPT VARCHAR, ZBRANDINGINTULOGINURL VARCHAR, ZDIRECTCONNECTBID VARCHAR, ZDIRECTCONNECTCONTACTPHONE VARCHAR, ZDIRECTCONNECTDCURL VARCHAR, ZDIRECTCONNECTINFOURL VARCHAR, ZDIRECTCONNECTORG VARCHAR, ZNAME VARCHAR, ZOFXPROCESSINGDAYSOFF VARCHAR, ZPROFILEPINRULECHARTYPE VARCHAR );
CREATE TABLE ZSECURITY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCOSTBASISALGORITHM INTEGER, ZDEBTRATINGTYPE INTEGER, ZDEBTTYPE INTEGER, ZDELETIONCOUNT INTEGER, ZHIDEINLISTS INTEGER, ZINTERESTFREQUENCYTYPE INTEGER, ZQUICKENID INTEGER, ZSHOULDDOWNLOADQUOTES INTEGER, ZTAXFREE INTEGER, ZTYPE INTEGER, ZWATCHLIST INTEGER, ZCOUPONMATURITYDATE TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZDEBTCALLDATE TIMESTAMP, ZDEBTMATURITYDATE TIMESTAMP, ZEXPIREDATE TIMESTAMP, ZLATESTQUOTEDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZMOSTRECENTQUOTEDOWNLOADTIMESTAMP TIMESTAMP, ZASSETCLASSPERCENTAGEDOMESTICBOND DECIMAL, ZASSETCLASSPERCENTAGEINTLBOND DECIMAL, ZASSETCLASSPERCENTAGEINTLSTOCK DECIMAL, ZASSETCLASSPERCENTAGELARGESTOCK DECIMAL, ZASSETCLASSPERCENTAGEMONEYMRKT DECIMAL, ZASSETCLASSPERCENTAGEOTHER DECIMAL, ZASSETCLASSPERCENTAGESMALLSTOCK DECIMAL, ZBACKLOADFEERATE DECIMAL, ZCOUPONRATE DECIMAL, ZDEBTMATURITYRATE DECIMAL, ZFACEVALUEUNITPRICE DECIMAL, ZLATESTCLOSINGPRICE DECIMAL, ZLATESTPRICECHANGE DECIMAL, ZLATESTPRICECHANGEPERCENT DECIMAL, ZSHARESPERCONTRACT DECIMAL, ZSTRIKEPRICE DECIMAL, ZASSETCLASS VARCHAR, ZDATASOURCE VARCHAR, ZGOALSTRING VARCHAR, ZGUID VARCHAR, ZISSUETYPE VARCHAR, ZNAME VARCHAR, ZOPTIONTYPE VARCHAR, ZSYNCID VARCHAR, ZTICKER VARCHAR , ZASSETMIXTUREDATAISUSERDEFINED INTEGER, ZASSETCLASSPERCENTAGECASH DECIMAL);
CREATE TABLE ZREPORT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZISPERMANENT INTEGER, ZISTEMPLATE INTEGER, ZQUICKENID INTEGER, ZUSEDINSOURCELIST INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZBASENAME VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR, ZFILTERPARAMETERS BLOB, ZPARAMETERS BLOB, ZPRINTINFOARCHIVE BLOB , ZISTEMPORARY INTEGER, ZFILTERPARAMETERSJSON VARCHAR, ZISTITLEUSERCUSTOMIZED INTEGER, ZPARAMETERSJSON VARCHAR, ZOPENEDTIMESTAMP TIMESTAMP, ZINTERNALNAME VARCHAR, ZEDITEDTIMESTAMP TIMESTAMP, ZOPENEDCOUNT INTEGER, ZFOLDER INTEGER);
CREATE TABLE IF NOT EXISTS "ZBILLPRESENTMENTPROVIDERBILL" ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZREVIEWED INTEGER, ZPROVIDERACCOUNT INTEGER, ZDOCUMENTMETADATA INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZDUEDATE TIMESTAMP, ZLASTPAIDDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZSCHEDULEDDATE TIMESTAMP, ZAMOUNTDUE DECIMAL, ZBALANCE DECIMAL, ZLASTPAIDAMOUNT DECIMAL, ZMINIMUMDUE DECIMAL, ZSCHEDULEDAMOUNT DECIMAL, ZBILLSTATUS VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZPROVIDERDOCUMENTID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE IF NOT EXISTS "ZBILLPRESENTMENTPROVIDERDOCUMENTMETADATA" ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSIZE INTEGER, ZPROVIDERACCOUNT INTEGER, ZCREATED TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZCONTENTTYPE VARCHAR, ZDATASOURCE VARCHAR, ZDOCUMENTHASH VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZPROVIDERDOCUMENTID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZBUDGETTARGET ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZEFFECTIVEDATENUM INTEGER, ZQUICKENID INTEGER, ZLINEITEM INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZROLLOVERRESETAMT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZSMARTREGISTER ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZISPERMANENT INTEGER, ZQUICKENID INTEGER, ZUSEDINSOURCELIST INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZBASEBEHAVIORCLASSNAME VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZLOCALIZABLENAMEKEY VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR, ZUID VARCHAR, ZFILTERS BLOB , ZFILTERSJSON VARCHAR, ZINCOMEFILTERS BLOB, ZSPENDINGFILTERS BLOB);
CREATE TABLE ZFITRANSACTION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCCCATEGORYID INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZTYPE INTEGER, ZACCOUNT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZPOSTEDDATE TIMESTAMP, ZACCRUEDINTEREST DECIMAL, ZAMOUNT DECIMAL, ZCOMMISSION DECIMAL, ZDENOMINATOR DECIMAL, ZFEES DECIMAL, ZLOAD DECIMAL, ZNUMERATOR DECIMAL, ZPENALTY DECIMAL, ZSTATEWITHHOLDING DECIMAL, ZTAXES DECIMAL, ZUNITS DECIMAL, ZWITHHOLDING DECIMAL, ZCCCATEGORYNAME VARCHAR, ZCCPAYEENAME VARCHAR, ZDATASOURCE VARCHAR, ZFITRANSACTIONID VARCHAR, ZGUID VARCHAR, ZIMPORTSOURCEFILEID VARCHAR, ZINCOMETYPE VARCHAR, ZPOSTYPE VARCHAR, ZSERVERTRANSID VARCHAR, ZSTATEMENTPAYEENAME VARCHAR, ZSYNCID VARCHAR, ZUNIQUEID VARCHAR, ZUNIQUEIDTYPE VARCHAR , ZQCSKNOWNCATEGORYID VARCHAR, ZMLINFERREDPAYEE VARCHAR, ZMLKNOWNCATEGORYID VARCHAR);
CREATE TABLE ZRENAMINGRULE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZDONTRENAMEPAYEE INTEGER, ZQUICKENID INTEGER, ZRULETYPE INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZRULELASTUSEDDATE TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZORIGINALQUICKENNAME VARCHAR, ZORIGINALSTATEMENTNAME VARCHAR, ZRULEPATTERN VARCHAR, ZSYNCID VARCHAR, ZTARGETPAYEENAME VARCHAR );
CREATE TABLE ZQUICKFILLRULESPLITENTRY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSEQUENCENUMBER INTEGER, ZCATEGORYTAG INTEGER, ZQUICKFILLRULE INTEGER, ZTRANSFERACCOUNT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZMEMO VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZCASHFLOWTRANSACTIONENTRY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZMISCFLAGS INTEGER, ZQUICKENID INTEGER, ZSEQUENCENUMBER INTEGER, ZCATEGORYTAG INTEGER, ZPARENT INTEGER, Z75_PARENT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZIMPORTSOURCEFILEID VARCHAR, ZIMPORTSOURCEID VARCHAR, ZNOTE VARCHAR, ZSYNCID VARCHAR, ZTRANSFER VARCHAR , ZBUSINESS INTEGER, ZPAYMENT INTEGER, ZCUSTOMER INTEGER, ZPROJECT INTEGER);
CREATE TABLE ZQERROR ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZERRORCODE INTEGER, ZERRORSTATUS INTEGER, ZQUICKENID INTEGER, ZSEVERITYLEVEL INTEGER, ZACCOUNT INTEGER, ZFINANCIALINSTITUTION INTEGER, ZTRANSACTION INTEGER, Z75_TRANSACTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZERRORDESCRIPTION VARCHAR, ZERRORDOMAIN VARCHAR, ZGUID VARCHAR, ZRECOVERYSUGGESTION VARCHAR, ZSUBCLASSNAME VARCHAR, ZSYNCID VARCHAR, ZCUSTOMINFORMATION BLOB , ZCUSTOMINFORMATIONJSON VARCHAR);
CREATE TABLE ZOFXEMAIL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZACCOUNT INTEGER, ZFISTATEOFX INTEGER, ZTRANSACTION INTEGER, Z75_TRANSACTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZDTCREATED TIMESTAMP, ZDTUSER TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZACCOUNTNUMBER VARCHAR, ZACCOUNTTYPE VARCHAR, ZBANKID VARCHAR, ZCHECKNUM VARCHAR, ZCLIENTASSIGNEDTRANSACTIONID VARCHAR, ZDATASOURCE VARCHAR, ZEMAILTYPE VARCHAR, ZGUID VARCHAR, ZMAILFROM VARCHAR, ZMAILTO VARCHAR, ZMSGBODY VARCHAR, ZONLINEBANKINGSERVERID VARCHAR, ZPAYEELISTID VARCHAR, ZPAYEENAME VARCHAR, ZSENDSTATUS VARCHAR, ZSUBJECT VARCHAR, ZSYNCID VARCHAR, ZUSERID VARCHAR );
CREATE TABLE ZRECONCILEDTRANSACTION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZADJUSTMENTTYPE INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZORIGINALTRANSACTION INTEGER, Z75_ORIGINALTRANSACTION INTEGER, ZRECONCILERECORD INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZENTEREDDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZPOSTEDDATE TIMESTAMP, ZAMOUNT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR , ZFITRANSACTION INTEGER, ZUSERPAYEENAME VARCHAR, ZISUNCLEAREDTRANSACTION INTEGER);
CREATE TABLE IF NOT EXISTS "Z_18USERTAGS" ( Z_18CASHFLOWTRANSACTIONENTRIES INTEGER, Z_70USERTAGS INTEGER, PRIMARY KEY (Z_18CASHFLOWTRANSACTIONENTRIES, Z_70USERTAGS) );
CREATE TABLE IF NOT EXISTS "Z_52USERTAGS" ( Z_52QUICKFILLRULESPLITENTRIES INTEGER, Z_70USERTAGS1 INTEGER, PRIMARY KEY (Z_52QUICKFILLRULESPLITENTRIES, Z_70USERTAGS1) );
CREATE TABLE Z_1DOWNLOADSESSIONS ( Z_1ACCOUNTS1 INTEGER, Z_26DOWNLOADSESSIONS INTEGER, PRIMARY KEY (Z_1ACCOUNTS1, Z_26DOWNLOADSESSIONS) );
CREATE TABLE Z_1BUDGETS ( Z_1ACCOUNTS INTEGER, Z_13BUDGETS INTEGER, PRIMARY KEY (Z_1ACCOUNTS, Z_13BUDGETS) );
CREATE TABLE ZCHECKPAYPAYEE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCHECK INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZACCOUNTNUMBER VARCHAR, ZADDRESSLINE1 VARCHAR, ZADDRESSLINE2 VARCHAR, ZCITY VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZSTATE VARCHAR, ZSYNCID VARCHAR, ZZIPCODE VARCHAR );
CREATE TABLE sqlite_stat1(tbl,idx,stat);
CREATE TABLE ZBUDGETLINEITEM ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZROLLOVER INTEGER, ZACCOUNT INTEGER, ZBUDGET INTEGER, ZCATEGORYTAG INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR , ZISTRANSFEROUT INTEGER, ZTYPE INTEGER);
CREATE TABLE ZQUICKFILLRULE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZISNOTEDITABLEBYTRANSACTIONS INTEGER, ZMARKASCLEARED INTEGER, ZNEVERAUTOCATEGORIZE INTEGER, ZQUICKENID INTEGER, ZUSEFORDOWNLOADEDTRANSACTIONS INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZLASTUSEDTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZMEMO VARCHAR, ZPAYEENAME VARCHAR, ZSYNCID VARCHAR, ZTRANSACTIONTYPE VARCHAR );
CREATE TABLE ZQUICKPAYPAYMENT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZPROVIDERACCOUNT INTEGER, ZPAYMENTACCOUNT INTEGER, ZTRANSACTION INTEGER, Z76_TRANSACTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZPAYMENTTIMESTAMP TIMESTAMP, ZAMOUNTPAID DECIMAL, ZFEESPAID DECIMAL, ZTOTALPAID DECIMAL, ZCONFIRMATIONNUMBER VARCHAR, ZDATASOURCE VARCHAR, ZEXTENDEDSTATUS VARCHAR, ZEXTENDEDSTATUSMESSAGE VARCHAR, ZGUID VARCHAR, ZMODE VARCHAR, ZSTATUS VARCHAR, ZSYNCID VARCHAR , ZSCHEDULEDPAYMENTDATE TIMESTAMP, ZBILLPAYFUNDINGACCOUNT INTEGER);
CREATE TABLE ZBUDGET ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSHOWCENTS INTEGER, ZSTARTMONTH INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZCURRENCY VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZRECONCILERECORD ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZACCOUNT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZENDDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZBEGINNINGBALANCE DECIMAL, ZENDINGBALANCE DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR , ZSUPPORTSUNCLEAREDTRANSACTIONS INTEGER);
CREATE TABLE ZCHECKPAYCHECK ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCHECKPAYPAYEE INTEGER, ZPAYMENTACCOUNT INTEGER, ZTRANSACTION INTEGER, Z76_TRANSACTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZPROCESSINGDATE TIMESTAMP, ZSCHEDULEDMAILDATE TIMESTAMP, ZSTATUSMODIFIEDTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZCHECKNUMBER VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZMODE VARCHAR, ZPRINTEDMEMO VARCHAR, ZSTATUS VARCHAR, ZSYNCID VARCHAR , ZBILLPAYFUNDINGACCOUNT INTEGER);
CREATE TABLE ZBILLPAYPAYMENTACCOUNT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZISENABLEDFORCHECKPAY INTEGER, ZISENABLEDFORQUICKPAY INTEGER, ZQUICKENID INTEGER, ZACCOUNT INTEGER, ZACCOUNTHOLDERSDATEOFBIRTH TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZSTARTVERIFICATIONTIMESTAMP TIMESTAMP, ZACCOUNTHOLDERSNAME VARCHAR, ZACCOUNTNUMBER VARCHAR, ZADDRESSLINE1 VARCHAR, ZADDRESSLINE2 VARCHAR, ZCITY VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZOWNERTYPE VARCHAR, ZROUTINGNUMBER VARCHAR, ZSTATE VARCHAR, ZSTATUS VARCHAR, ZSUBTYPE VARCHAR, ZSYNCID VARCHAR, ZTYPE VARCHAR, ZVERIFICATIONSTATUS VARCHAR, ZZIPCODE VARCHAR , ZOWNERTYPECONFIRMEDBYUSER INTEGER, ZAUTOVERIFIEDATTEMPTED INTEGER);
CREATE TABLE ZBILLPAYFUNDINGACCOUNT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZACCOUNT INTEGER, ZACCOUNTHOLDERSDATEOFBIRTH TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZACCOUNTHASH VARCHAR, ZACCOUNTHOLDERSADDRESSCITY VARCHAR, ZACCOUNTHOLDERSADDRESSLINE1 VARCHAR, ZACCOUNTHOLDERSADDRESSLINE2 VARCHAR, ZACCOUNTHOLDERSADDRESSSTATE VARCHAR, ZACCOUNTHOLDERSADDRESSZIPCODE VARCHAR, ZACCOUNTHOLDERSNAME VARCHAR, ZACCOUNTNUMBER VARCHAR, ZACCOUNTNUMBERSUFFIX VARCHAR, ZBANKTYPE VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZOWNERTYPE VARCHAR, ZROUTINGNUMBER VARCHAR, ZSYNCID VARCHAR, ZTYPE VARCHAR, ZVERIFICATIONSTATUS VARCHAR , ZOWNERTYPECONFIRMEDBYUSER INTEGER, ZAUTOVERIFIEDATTEMPTED INTEGER, ZACCEPTEDACHTERMS INTEGER);
CREATE TABLE ZBILLPRESENTMENTPROVIDERACCOUNT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZISPAYABLE INTEGER, ZQUICKENID INTEGER, ZBPSACCOUNT INTEGER, ZPROVIDERLOGIN INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZNICKNAME VARCHAR, ZPROVIDERACCOUNTPROVIDERID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZBILLPRESENTMENTACCOUNT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZAGGPROVIDERACCOUNT INTEGER, ZBPSPROVIDERACCOUNT INTEGER, ZUSERPAYEE INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR , ZLASTAPPLIEDBILLDUEDATE TIMESTAMP);
CREATE TABLE ZACCOUNT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZACTIVE INTEGER, ZAUTORECONCILE INTEGER, ZCANDIDATENOCASHTRANSACTIONS INTEGER, ZCANDIDATESINGLEMUTUALFUND INTEGER, ZCLOSED INTEGER, ZCONFIRMATIONNEEDED INTEGER, ZCOSTBASISALGORITHMDEBT INTEGER, ZCOSTBASISALGORITHMMUTUALFUND INTEGER, ZCOSTBASISALGORITHMOPTION INTEGER, ZCOSTBASISALGORITHMOTHER INTEGER, ZCOSTBASISALGORITHMSTOCK INTEGER, ZDELETIONCOUNT INTEGER, ZIMPORTQID INTEGER, ZLASTCHECKNUM INTEGER, ZLIQUIDITY INTEGER, ZLOANCOMPOUNDINGPERIOD INTEGER, ZLOANHASBEENSETUP INTEGER, ZLOANHASOFFEREDTOCONVERTLIABILITY INTEGER, ZLOANPAYMENTFREQUENCY INTEGER, ZLOANPAYMENTPERIOD INTEGER, ZLOANRATETYPE INTEGER, ZLOANTERMTYPE INTEGER, ZLOANUSEMATURITYDATE INTEGER, ZMOSTRECENTDOWNLOADSESSIONNUMBER INTEGER, ZNOCASHTRANSACTIONS INTEGER, ZOFXPAYMENTSENABLED INTEGER, ZOFXTRANSFERDESTENABLED INTEGER, ZOFXTRANSFERSOURCEENABLED INTEGER, ZONLINEBANKINGACCOUNTINFOSESSIONNEEDED INTEGER, ZONLINEBANKINGACCOUNTISENABLED INTEGER, ZONLINEBANKINGACCOUNTISINBIDCHANGE INTEGER, ZONLINEBANKINGAGGREGATIONDISABLEMENTCOUNT INTEGER, ZONLINEBANKINGAGGREGATIONENABLEMENTCOUNT INTEGER, ZONLINEBANKINGAWAITINGINITIALDOWNLOAD INTEGER, ZONLINEBANKINGCHANGEPINFIRSTCOMPLETED INTEGER, ZQUICKENID INTEGER, ZSCHEDULELOOKAHEADVALUE INTEGER, ZSIMPLEINVESTING INTEGER, ZSINGLEMUTUALFUND INTEGER, ZSTATUSTRANSACTIONCOUNT INTEGER, ZSYNCRESETREQUIRED INTEGER, ZSYNCWITHCLOUD INTEGER, ZTAXABLE INTEGER, ZUSEDINAUTOUPDATES INTEGER, ZUSEDINREPORTS INTEGER, ZBILLPAYFUNDINGACCOUNT INTEGER, ZBILLPAYPAYMENTACCOUNT INTEGER, ZBILLPAYPROVIDERINSTITUTION INTEGER, ZBPSACCOUNT INTEGER, ZCLOUDFILOGIN INTEGER, ZERROR INTEGER, ZFINANCIALINSTITUTION INTEGER, ZLOANINTERESTCATEGORY INTEGER, ZLOANSMARTTRANSACTION INTEGER, ZCLOSEDDATE TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZLOANFIRSTPAYMENTDATE TIMESTAMP, ZLOANNEXTPAYMENTDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZONLINEBANKINGLASTCONNECTEDTIMESTAMP TIMESTAMP, ZONLINEBANKINGLEDGERBALANCEDATE TIMESTAMP, ZREVIEWEDTIMESTAMP TIMESTAMP, ZSTATEMENTCLOSETIMESTAMP TIMESTAMP, ZSTATEMENTDUETIMESTAMP TIMESTAMP, ZSTATEMENTENDTIMESTAMP TIMESTAMP, ZSTATEMENTLASTPAYMENTTIMESTAMP TIMESTAMP, ZSTATUSTRANSACTIONCOUNTTIMESTAMP TIMESTAMP, ZCREDITLIMIT DECIMAL, ZINTERESTRATE DECIMAL, ZLOANOPENINGBALANCE DECIMAL, ZLOANTERM DECIMAL, ZONLINEBANKINGLEDGERBALANCEAMOUNT DECIMAL, ZSTATEMENTAMOUNTDUE DECIMAL, ZSTATEMENTAMOUNTPASTDUE DECIMAL, ZSTATEMENTCLOSINGBALANCE DECIMAL, ZSTATEMENTLASTPAYMENTAMOUNT DECIMAL, ZSTATEMENTMINIMUMAMOUNTDUE DECIMAL, ZBANKROUTINGNUMBER VARCHAR, ZBILLPAYROUTINGNUMBER VARCHAR, ZCHECKPRINTINGPROPERTIESJSON VARCHAR, ZCURRENCY VARCHAR, ZDATASOURCE VARCHAR, ZFILTERSJSON VARCHAR, ZGUID VARCHAR, ZIMPORTSOURCEFILEID VARCHAR, ZIMPORTSOURCEID VARCHAR, ZNAME VARCHAR, ZNOTES VARCHAR, ZNOTIFICATIONSJSON VARCHAR, ZOFXBILLPAYSERVICESTATUS VARCHAR, ZOFXLASTBANKMAILTOKEN VARCHAR, ZOFXLASTPAYMENTTOKEN VARCHAR, ZOFXLASTTRANSFERTOKEN VARCHAR, ZONLINEBANKINGACCOUNTDESCRIPTION VARCHAR, ZONLINEBANKINGACCOUNTNUMBER VARCHAR, ZONLINEBANKINGACCOUNTNUMBERMASKED VARCHAR, ZONLINEBANKINGAGGREGATORACCOUNTID VARCHAR, ZONLINEBANKINGCONNECTIONTYPE VARCHAR, ZONLINEBANKINGCUSTOMERID VARCHAR, ZONLINEBANKINGDTEND VARCHAR, ZONLINEBANKINGOFXACCOUNTTYPE VARCHAR, ZONLINEBANKINGPREVIOUSBID VARCHAR, ZONLINEBANKINGSERVERID VARCHAR, ZONLINEBILLPAYACCOUNTNUMBER VARCHAR, ZONLINEBILLPAYCONNECTIONTYPE VARCHAR, ZONLINEBILLPAYCUSTOMERID VARCHAR, ZONLINEBILLPAYOFXACCOUNTTYPE VARCHAR, ZQ17SYNCID VARCHAR, ZRECONCILEINFOJSON VARCHAR, ZREGIONCODE VARCHAR, ZSCHEDULELOOKAHEADUNITTYPE VARCHAR, ZSYNCID VARCHAR, ZTYPENAME VARCHAR, ZUSERDESCRIPTION VARCHAR, ZANOMALOUSSYNCSTATUS BLOB, ZCHECKPRINTINGPROPERTIES BLOB, ZFILTERS BLOB, ZNOTIFICATIONS BLOB, ZONLINEBANKINGAGGREGATIONPENDINGENABLEMENTINFO BLOB, ZRECONCILEINFO BLOB , ZSHADOWACCOUNTCREATIONABANDONEDATTIMESTAMP TIMESTAMP, ZINCOMEFILTERS BLOB, ZSPENDINGFILTERS BLOB, ZPRIMARYUSE VARCHAR, ZPRIMARYUSEBUSINESS INTEGER);
CREATE TABLE ZCONNECTIVITYEVENTRESULT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZERRORDAYS INTEGER, ZERRORSNOOZEDAYS INTEGER, ZLASTAPPLIEDACTIONCOUNT INTEGER, ZQUICKENID INTEGER, ZREQUESTBODYLENGTH INTEGER, ZRESPONSEBODYLENGTH INTEGER, ZRESPONSESTATUSCODE INTEGER, ZSEQUENTIALOCCURRENCECOUNT INTEGER, ZSKIPPEDCOUNT INTEGER, ZACCOUNT INTEGER, ZBPSPROVIDERLOGIN INTEGER, ZCLOUDFILOGIN INTEGER, ZDOWNLOADSESSION INTEGER, ZSHADOWACCOUNT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZLASTSEENTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAGGCHANNEL VARCHAR, ZCREATIONSIGNATURE VARCHAR, ZDATASOURCE VARCHAR, ZERRORCODE VARCHAR, ZERRORDETAIL VARCHAR, ZERRORMESSAGE VARCHAR, ZERRORSEVERITY VARCHAR, ZERRORSTATUS VARCHAR, ZERRORURI VARCHAR, ZEVALUATIONREASON VARCHAR, ZFIACCOUNTNAME VARCHAR, ZFIACCOUNTSUBTYPE VARCHAR, ZFIBID VARCHAR, ZFINAME VARCHAR, ZGUID VARCHAR, ZLASTAPPLIEDACTION VARCHAR, ZNAME VARCHAR, ZOBJECTGUID VARCHAR, ZOPERATIONGUID VARCHAR, ZOPERATIONTYPE VARCHAR, ZQCSTRACEID VARCHAR, ZREQUESTBODY VARCHAR, ZREQUESTURL VARCHAR, ZRESPONSEBODY VARCHAR, ZREVIEWSTATUS VARCHAR, ZRULERESULTSJSON VARCHAR, ZSESSIONCLASS VARCHAR, ZSESSIONID VARCHAR, ZSKIPPEDSUMMARY VARCHAR, ZSYNCID VARCHAR, ZSYSTEMDETAILS VARCHAR , Z75_TRANSACTION INTEGER, ZTRANSACTION INTEGER);
CREATE TABLE ZBUSINESS ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZIMPORTSOURCEFILEID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR , ZCOLORSTRING VARCHAR, ZISDEFAULT INTEGER, ZTYPESTRING VARCHAR, ZNOTES VARCHAR, ZINDUSTRY VARCHAR, ZCLOSED INTEGER, ZADDRESS2 VARCHAR, ZPOSTALCODE VARCHAR, ZCOUNTRY VARCHAR, ZCITY VARCHAR, ZSTATE VARCHAR, ZADDRESS1 VARCHAR, ZLOGOATTACHMENT INTEGER, ZINVOICEBACKGROUNDATTACHMENT INTEGER);
CREATE TABLE ZTRANSACTION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZEXCLUDEFROMREPORTS INTEGER, ZIMPORTQID INTEGER, ZLOCKED INTEGER, ZMATCHED INTEGER, ZONLINEID INTEGER, ZORDERID INTEGER, ZQUICKENID INTEGER, ZRECONCILESTATUS INTEGER, ZTYPE INTEGER, ZUSERSTATUSOVERRIDE INTEGER, ZACCOUNT INTEGER, ZDOWNLOADSESSION INTEGER, ZERROR INTEGER, ZFITRANSACTION INTEGER, ZPLACEHOLDERACCOUNT INTEGER, ZRECONCILEDTRANSACTION INTEGER, ZRENAMINGRULEUSED INTEGER, ZSENDACCOUNT INTEGER, ZTARGETACCOUNT INTEGER, ZFLAG INTEGER, ZMACHINEGENERATEDCATEGORYSOURCE INTEGER, ZMACHINEGENERATEDPAYEESOURCE INTEGER, ZMACHINEGENERATEDTAGSOURCE INTEGER, ZMISCFLAGS INTEGER, ZSENDREQUESTSTATE INTEGER, ZSOURCESMARTCASHFLOWTRANSACTIONQUICKENID INTEGER, ZACTION INTEGER, ZCHECKPAYCHECK INTEGER, ZQUICKPAYPAYMENT INTEGER, ZUSERPAYEE INTEGER, ZAUTOPOST INTEGER, ZTOBESENT INTEGER, ZLOANACCOUNT INTEGER, ZCOSTBASISALGORITHM INTEGER, ZTAXEXEMPT INTEGER, ZPOSITION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZENTEREDDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZPLACEHOLDERTARGETDATE TIMESTAMP, ZPOSTEDDATE TIMESTAMP, ZBUDGETFLEXIBILITY FLOAT, ZSENTTRANSACTIONSTATUSDATE TIMESTAMP, ZSOURCESMARTCASHFLOWTRANSACTIONORIGINALMODELDATE TIMESTAMP, ZACQUISITIONDATE TIMESTAMP, ZAMOUNT DECIMAL, ZPLACEHOLDERTARGETBALANCE DECIMAL, ZCOMMISSION DECIMAL, ZCOSTBASIS DECIMAL, ZDENOMINATOR DECIMAL, ZNUMERATOR DECIMAL, ZPLACEHOLDERCOSTBASIS DECIMAL, ZPLACEHOLDERCOSTBASISUNITS DECIMAL, ZPLACEHOLDERTARGETUNITS DECIMAL, ZPLACEHOLDERUNITSONTARGETDATE DECIMAL, ZUNITS DECIMAL, ZDATASOURCE VARCHAR, ZFINOTE VARCHAR, ZGUID VARCHAR, ZIMPORTSOURCEFILEID VARCHAR, ZIMPORTSOURCEID VARCHAR, ZMATCHSOURCE VARCHAR, ZNOTE VARCHAR, ZONLINEBANKINGSERVERID VARCHAR, ZPREMATCHPROPERTIESJSON VARCHAR, ZREFERENCE VARCHAR, ZSYNCID VARCHAR, ZCHECKNUMBER VARCHAR, ZCHECKPROPERTIESJSON VARCHAR, ZCLIENTASSIGNEDTRANSACTIONUID VARCHAR, ZOFXPAYEELISTID VARCHAR, ZBILLERWEBSITEURLSTRING VARCHAR, ZRECURRENCEJSON VARCHAR, ZLOCATION BLOB, ZPREMATCHPROPERTIES BLOB, ZCHECKPROPERTIES BLOB , ZIFSPAYMENT INTEGER, ZINVOICE INTEGER, ZEDITBEFOREMARKINGASPAID INTEGER);
CREATE TABLE ZTAXPAYMENTRECORD ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUARTER INTEGER, ZQUICKENID INTEGER, ZYEAR INTEGER, ZBUSINESS INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZMILEAGEENTRY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZBUSINESS INTEGER, ZROUNDTRIPENTRY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZENTEREDDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDISTANCEMILES DECIMAL, ZDATASOURCE VARCHAR, ZENDINGPOINT VARCHAR, ZGUID VARCHAR, ZNOTES VARCHAR, ZPURPOSE VARCHAR, ZSTARTINGPOINT VARCHAR, ZSYNCID VARCHAR, ZTRIPTYPE VARCHAR );
CREATE TABLE ZTAG ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZBUDGETABLE INTEGER, ZEDITABLE INTEGER, ZFAVORITE INTEGER, ZGROUPING INTEGER, ZHIDDEN INTEGER, ZIMPORTQID INTEGER, ZTAXCOPYNUM INTEGER, ZTAXREFCA INTEGER, ZTAXREFUS INTEGER, ZTRENDABLE INTEGER, ZTYPE INTEGER, ZUSERASSIGNABLE INTEGER, ZCATEGORYID INTEGER, ZCUSTOM INTEGER, ZPARENTCATEGORY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZFLEXIBILITY FLOAT, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZINTERNALNAME VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR, ZUSERDESCRIPTION VARCHAR, ZIMPORTSOURCECLASS VARCHAR, ZIMPORTSOURCEFILEID VARCHAR, ZIMPORTSOURCEID VARCHAR, ZCOLORSTRING VARCHAR, ZQCSKNOWNCATEGORYIDS BLOB, ZTAXREFMAPPINGSCA BLOB, ZTAXREFMAPPINGSUS BLOB );
CREATE TABLE ZUSERPAYEEADDRESS ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZHASBEENVERIFIED INTEGER, ZQUICKENID INTEGER, ZUSERPAYEE INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZACCOUNTNUMBER VARCHAR, ZCITY VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZLINE1 VARCHAR, ZLINE2 VARCHAR, ZSTATE VARCHAR, ZSYNCID VARCHAR, ZZIPCODE VARCHAR );
CREATE TABLE ZUSERPAYEE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZEBILLENABLED INTEGER, ZINFOCHANGED INTEGER, ZQUICKENID INTEGER, ZSHOWINBILLCENTER INTEGER, ZVISIBILITYTYPE INTEGER, ZBPSACCOUNT INTEGER, ZCHECKPAYADDRESS INTEGER, ZIFSBILLERACCOUNT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZLASTSELECTEDTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZURL VARCHAR, ZADDRESS VARCHAR, ZADDRESS1 VARCHAR, ZADDRESS2 VARCHAR, ZADDRESS3 VARCHAR, ZCITY VARCHAR, ZCOUNTRY VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZIMPORTSOURCEFILEID VARCHAR, ZINTERNALNAME VARCHAR, ZNAME VARCHAR, ZPHONENUMBER VARCHAR, ZPOSTALCODE VARCHAR, ZSTATE VARCHAR, ZSYNCID VARCHAR, ZUSERACCOUNTNUMBER VARCHAR );
CREATE TABLE ZTAXRATE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZTAXAGENCY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZRATE DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR, ZTAXAGENCYNAME VARCHAR );
CREATE TABLE ZTAXAGENCY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZPROJECT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCUSTOMER INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZNOTES VARCHAR, ZSTATUSSTRING VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZPRODUCTSERVICE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZHIDDEN INTEGER, ZQUICKENID INTEGER, ZTAXABLE INTEGER, ZCATEGORY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZUNITPRICE DECIMAL, ZCURRENCY VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR, ZUSERDESCRIPTION VARCHAR );
CREATE TABLE ZPAYMENTALLOCATION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZINVOICE INTEGER, ZPAYMENT INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZINVOICELINEITEM ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSEQUENCENUMBER INTEGER, ZTAXABLE INTEGER, ZCATEGORY INTEGER, ZINVOICE INTEGER, ZPRODUCTSERVICE INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZUNITS DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR, ZUSERDESCRIPTION VARCHAR , ZFROZEN_PRODUCTSERVICE_NAME VARCHAR);
CREATE TABLE ZIFSBILLPAYPAYMENT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZFUNDINGACCOUNT INTEGER, ZIFSBILLERACCOUNT INTEGER, ZTRANSACTION INTEGER, Z76_TRANSACTION INTEGER, ZADJUDICATIONUPDATEDONTIMETAMP TIMESTAMP, ZCOMPLETEONTIMESTAMP TIMESTAMP, ZCREATIONTIMESTAMP TIMESTAMP, ZCREDITCOMPLETEONTIMESTAMP TIMESTAMP, ZCREDITSTARTONTIMESTAMP TIMESTAMP, ZCREDITUPDATEDONTIMESTAMP TIMESTAMP, ZDEBITCOMPLETEONTIMESTAMP TIMESTAMP, ZDEBITSTARTONTIMESTAMP TIMESTAMP, ZDEBITUPDATEDONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZPROPOSEDARRIVEONDATE TIMESTAMP, ZPROPOSEDINITIATEONDATE TIMESTAMP, ZSTARTONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZADJUDICATIONSTATUS VARCHAR, ZCREDITSTATUS VARCHAR, ZDATASOURCE VARCHAR, ZDEBITSTATUS VARCHAR, ZGUID VARCHAR, ZSTATUS VARCHAR, ZSYNCID VARCHAR, ZTIMEZONEIDENTIFIER VARCHAR );
CREATE TABLE ZIFSBILLPAYBILLERACCOUNT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZUSERPAYEE INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZACCOUNTHOLDERSNAME VARCHAR, ZACCOUNTNUMBER VARCHAR, ZBILLERID VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNICKNAME VARCHAR, ZSYNCID VARCHAR , ZACCOUNTNUMBERSUFFIX VARCHAR);
CREATE TABLE ZCUSTOMER ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZADDRESS1 VARCHAR, ZADDRESS2 VARCHAR, ZCITY VARCHAR, ZCOMPANYNAME VARCHAR, ZCOUNTRY VARCHAR, ZCUSTOMNAME VARCHAR, ZDATASOURCE VARCHAR, ZFIRSTNAME VARCHAR, ZGUID VARCHAR, ZLASTNAME VARCHAR, ZNAME VARCHAR, ZNOTES VARCHAR, ZPOSTALCODE VARCHAR, ZSTATE VARCHAR, ZSYNCID VARCHAR , ZHIDDEN INTEGER, ZPHONENUMBER VARCHAR, ZEMAILADDRESS VARCHAR, ZWEBSITE VARCHAR);
CREATE TABLE ZREPORTFOLDER ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNAME VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER);
CREATE TABLE ZPAYMENT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZBUSINESS INTEGER, ZCUSTOMER INTEGER, ZTRANSACTIONENTRY INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZREMAINDERAMOUNT DECIMAL, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZINVOICE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZINVOICENUMBER INTEGER, ZQUICKENID INTEGER, ZBUSINESS INTEGER, ZCUSTOMER INTEGER, ZINVOICEBACKGROUNDATTACHMENT INTEGER, ZLOGOATTACHMENT INTEGER, ZPROJECT INTEGER, ZTAXRATE INTEGER, ZTRANSACTION INTEGER, Z75_TRANSACTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZDUEDATE TIMESTAMP, ZINVOICEDATE TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZAMOUNT DECIMAL, ZDISCOUNTVALUE DECIMAL, ZFROZEN_TAXRATE_RATE DECIMAL, ZTAXAMOUNT DECIMAL, ZCURRENCY VARCHAR, ZDATASOURCE VARCHAR, ZDISCOUNTTYPESTRING VARCHAR, ZFROZEN_BUSINESS_ADDRESS1 VARCHAR, ZFROZEN_BUSINESS_ADDRESS2 VARCHAR, ZFROZEN_BUSINESS_CITY VARCHAR, ZFROZEN_BUSINESS_COUNTRY VARCHAR, ZFROZEN_BUSINESS_NAME VARCHAR, ZFROZEN_BUSINESS_POSTALCODE VARCHAR, ZFROZEN_BUSINESS_STATE VARCHAR, ZFROZEN_CUSTOMER_ADDRESS1 VARCHAR, ZFROZEN_CUSTOMER_ADDRESS2 VARCHAR, ZFROZEN_CUSTOMER_CITY VARCHAR, ZFROZEN_CUSTOMER_COMPANYNAME VARCHAR, ZFROZEN_CUSTOMER_COUNTRY VARCHAR, ZFROZEN_CUSTOMER_EMAILADDRESS VARCHAR, ZFROZEN_CUSTOMER_FIRSTNAME VARCHAR, ZFROZEN_CUSTOMER_LASTNAME VARCHAR, ZFROZEN_CUSTOMER_PHONENUMBER VARCHAR, ZFROZEN_CUSTOMER_POSTALCODE VARCHAR, ZFROZEN_CUSTOMER_STATE VARCHAR, ZFROZEN_PROJECT_NAME VARCHAR, ZFROZEN_TAXRATE_NAME VARCHAR, ZGUID VARCHAR, ZNOTES VARCHAR, ZSTATUSSTRING VARCHAR, ZSYNCID VARCHAR );
CREATE TABLE ZATTACHMENT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELETIONCOUNT INTEGER, ZQUICKENID INTEGER, ZSYNCWITHCLOUD INTEGER, ZACCOUNT INTEGER, ZBUSINESS INTEGER, ZCUSTOMER INTEGER, ZPROJECT INTEGER, ZTRANSACTION INTEGER, Z75_TRANSACTION INTEGER, ZCREATIONTIMESTAMP TIMESTAMP, ZMODIFICATIONTIMESTAMP TIMESTAMP, ZCLOUDURI VARCHAR, ZDATASOURCE VARCHAR, ZGUID VARCHAR, ZNOTES VARCHAR, ZORIGINALFILEPATH VARCHAR, ZSYNCID VARCHAR );
CREATE INDEX ZFIBALANCE_ZFISTATEMENT_INDEX ON ZFIBALANCE (ZFISTATEMENT);
CREATE INDEX ZLOTMOD_ZLOT_INDEX ON ZLOTMOD (ZLOT);
CREATE INDEX ZLOTMOD_ZLOTASSIGNMENT_INDEX ON ZLOTMOD (ZLOTASSIGNMENT);
CREATE INDEX ZLOTMOD_ZTRANSACTION_INDEX ON ZLOTMOD (ZTRANSACTION);
CREATE INDEX ZBPFIPAYEE_ZUSERPAYEE_INDEX ON ZBPFIPAYEE (ZUSERPAYEE);
CREATE INDEX ZCLOUDFILOGIN_ZFINANCIALINSTITUTION_INDEX ON ZCLOUDFILOGIN (ZFINANCIALINSTITUTION);
CREATE INDEX ZFISTATEMENT_ZACCOUNT_INDEX ON ZFISTATEMENT (ZACCOUNT);
CREATE INDEX ZSECURITYQUOTEDETAIL_ZSECURITYQUOTE_INDEX ON ZSECURITYQUOTEDETAIL (ZSECURITYQUOTE);
CREATE INDEX ZLOTASSIGNMENT_ZDESTINATIONTRANSACTION_INDEX ON ZLOTASSIGNMENT (ZDESTINATIONTRANSACTION);
CREATE INDEX ZLOTASSIGNMENT_ZLOTMOD_INDEX ON ZLOTASSIGNMENT (ZLOTMOD);
CREATE INDEX ZLOTASSIGNMENT_ZSOURCETRANSACTION_INDEX ON ZLOTASSIGNMENT (ZSOURCETRANSACTION);
CREATE INDEX ZDOCUMENTPROPERTY_ZNAME_INDEX ON ZDOCUMENTPROPERTY (ZNAME);
CREATE INDEX ZSECURITYSPLIT_ZSPLITDATE_INDEX ON ZSECURITYSPLIT (ZSPLITDATE);
CREATE INDEX ZSECURITYSPLIT_ZSECURITY_INDEX ON ZSECURITYSPLIT (ZSECURITY);
CREATE INDEX ZSECURITYSPLIT_ZSECURITY_ZSPLITDATE ON ZSECURITYSPLIT (ZSECURITY, ZSPLITDATE);
CREATE INDEX ZPOSITION_ZUNIQUEID_INDEX ON ZPOSITION (ZUNIQUEID);
CREATE INDEX ZPOSITION_ZACCOUNT_INDEX ON ZPOSITION (ZACCOUNT);
CREATE INDEX ZPOSITION_ZSECURITY_INDEX ON ZPOSITION (ZSECURITY);
CREATE INDEX ZLOT_ZPOSITION_INDEX ON ZLOT (ZPOSITION);
CREATE INDEX ZSECURITYQUOTE_ZQUOTEDATE_INDEX ON ZSECURITYQUOTE (ZQUOTEDATE);
CREATE INDEX ZSECURITYQUOTE_ZSECURITY_INDEX ON ZSECURITYQUOTE (ZSECURITY);
CREATE INDEX ZSECURITYQUOTE_ZSECURITY_ZQUOTEDATE ON ZSECURITYQUOTE (ZSECURITY, ZQUOTEDATE);
CREATE INDEX ZSECURITYID_ZUNIQUEID_INDEX ON ZSECURITYID (ZUNIQUEID);
CREATE INDEX ZSECURITYID_ZSECURITY_INDEX ON ZSECURITYID (ZSECURITY);
CREATE INDEX ZFIPOSITION_ZUNIQUEID_INDEX ON ZFIPOSITION (ZUNIQUEID);
CREATE INDEX ZFIPOSITION_ZFISTATEMENT_INDEX ON ZFIPOSITION (ZFISTATEMENT);
CREATE INDEX ZDOWNLOADSESSION_ZSESSIONNUMBER_INDEX ON ZDOWNLOADSESSION (ZSESSIONNUMBER);
CREATE INDEX ZBPFINANCIALINSTITUTION_ZFINANCIALINSTITUTION_INDEX ON ZBPFINANCIALINSTITUTION (ZFINANCIALINSTITUTION);
CREATE INDEX ZLOANSPLITENTRY_ZACCOUNT_INDEX ON ZLOANSPLITENTRY (ZACCOUNT);
CREATE INDEX ZLOANSPLITENTRY_ZCATEGORY_INDEX ON ZLOANSPLITENTRY (ZCATEGORY);
CREATE INDEX ZSCHEDULEADJUSTMENTENTRY_ZORIGINALSCHEDULEDDATE_INDEX ON ZSCHEDULEADJUSTMENTENTRY (ZORIGINALSCHEDULEDDATE);
CREATE INDEX ZSCHEDULEADJUSTMENTENTRY_ZPARENT_INDEX ON ZSCHEDULEADJUSTMENTENTRY (ZPARENT);
CREATE INDEX ZFINANCIALINSTITUTION_ZBPFINANCIALINSTITUTION_INDEX ON ZFINANCIALINSTITUTION (ZBPFINANCIALINSTITUTION);
CREATE INDEX ZSECURITY_ZTICKER_INDEX ON ZSECURITY (ZTICKER);
CREATE INDEX ZBILLPRESENTMENTBILL_ZDOCUMENTMETADATA_INDEX ON "ZBILLPRESENTMENTPROVIDERBILL" (ZDOCUMENTMETADATA);
CREATE INDEX ZBUDGETTARGET_ZLINEITEM_INDEX ON ZBUDGETTARGET (ZLINEITEM);
CREATE INDEX ZFITRANSACTION_ZACCOUNT_INDEX ON ZFITRANSACTION (ZACCOUNT);
CREATE INDEX ZQUICKFILLRULESPLITENTRY_ZCATEGORYTAG_INDEX ON ZQUICKFILLRULESPLITENTRY (ZCATEGORYTAG);
CREATE INDEX ZQUICKFILLRULESPLITENTRY_ZQUICKFILLRULE_INDEX ON ZQUICKFILLRULESPLITENTRY (ZQUICKFILLRULE);
CREATE INDEX ZQUICKFILLRULESPLITENTRY_ZTRANSFERACCOUNT_INDEX ON ZQUICKFILLRULESPLITENTRY (ZTRANSFERACCOUNT);
CREATE INDEX ZCASHFLOWTRANSACTIONENTRY_ZCATEGORYTAG_INDEX ON ZCASHFLOWTRANSACTIONENTRY (ZCATEGORYTAG);
CREATE INDEX ZCASHFLOWTRANSACTIONENTRY_ZPARENT_INDEX ON ZCASHFLOWTRANSACTIONENTRY (ZPARENT);
CREATE INDEX ZOFXEMAIL_ZACCOUNT_INDEX ON ZOFXEMAIL (ZACCOUNT);
CREATE INDEX ZOFXEMAIL_ZFISTATEOFX_INDEX ON ZOFXEMAIL (ZFISTATEOFX);
CREATE INDEX ZOFXEMAIL_ZTRANSACTION_INDEX ON ZOFXEMAIL (ZTRANSACTION);
CREATE INDEX ZQERROR_ZACCOUNT_INDEX ON ZQERROR (ZACCOUNT);
CREATE INDEX ZQERROR_ZFINANCIALINSTITUTION_INDEX ON ZQERROR (ZFINANCIALINSTITUTION);
CREATE INDEX ZQERROR_ZTRANSACTION_INDEX ON ZQERROR (ZTRANSACTION);
CREATE INDEX ZRECONCILEDTRANSACTION_ZORIGINALTRANSACTION_INDEX ON ZRECONCILEDTRANSACTION (ZORIGINALTRANSACTION);
CREATE INDEX ZRECONCILEDTRANSACTION_ZRECONCILERECORD_INDEX ON ZRECONCILEDTRANSACTION (ZRECONCILERECORD);
CREATE INDEX Z_1DOWNLOADSESSIONS_Z_21DOWNLOADSESSIONS_INDEX ON Z_1DOWNLOADSESSIONS (Z_26DOWNLOADSESSIONS, Z_1ACCOUNTS1);
CREATE INDEX Z_1BUDGETS_Z_11BUDGETS_INDEX ON Z_1BUDGETS (Z_13BUDGETS, Z_1ACCOUNTS);
CREATE INDEX Z_15USERTAGS_Z_56USERTAGS_INDEX ON "Z_18USERTAGS" (Z_70USERTAGS, Z_18CASHFLOWTRANSACTIONENTRIES);
CREATE INDEX ZCHECKPAYPAYEE_ZCHECK_INDEX ON ZCHECKPAYPAYEE (ZCHECK);
CREATE INDEX Z_38USERTAGS_Z_56USERTAGS1_INDEX ON "Z_52USERTAGS" (Z_70USERTAGS1, Z_52QUICKFILLRULESPLITENTRIES);
CREATE INDEX ZBUDGETLINEITEM_ZACCOUNT_INDEX ON ZBUDGETLINEITEM (ZACCOUNT);
CREATE INDEX ZBUDGETLINEITEM_ZBUDGET_INDEX ON ZBUDGETLINEITEM (ZBUDGET);
CREATE INDEX ZBUDGETLINEITEM_ZCATEGORYTAG_INDEX ON ZBUDGETLINEITEM (ZCATEGORYTAG);
CREATE INDEX Z_BudgetTarget_effectiveDateNum ON ZBUDGETTARGET (ZEFFECTIVEDATENUM COLLATE BINARY ASC);
CREATE INDEX Z_BudgetTarget_syncID ON ZBUDGETTARGET (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_DocumentProperty_name ON ZDOCUMENTPROPERTY (ZNAME COLLATE BINARY ASC);
CREATE INDEX Z_FIPosition_uniqueID ON ZFIPOSITION (ZUNIQUEID COLLATE BINARY ASC);
CREATE INDEX Z_Lot_syncID ON ZLOT (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_LotAssignment_syncID ON ZLOTASSIGNMENT (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_LotMod_syncID ON ZLOTMOD (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_Position_syncID ON ZPOSITION (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_Position_uniqueID ON ZPOSITION (ZUNIQUEID COLLATE BINARY ASC);
CREATE INDEX Z_ScheduleAdjustmentEntry_originalScheduledDate ON ZSCHEDULEADJUSTMENTENTRY (ZORIGINALSCHEDULEDDATE COLLATE BINARY ASC);
CREATE INDEX Z_SecurityID_uniqueID ON ZSECURITYID (ZUNIQUEID COLLATE BINARY ASC);
CREATE INDEX Z_SecurityQuote_quoteDate ON ZSECURITYQUOTE (ZQUOTEDATE COLLATE BINARY ASC);
CREATE INDEX Z_SecurityQuote_security_quoteDate ON ZSECURITYQUOTE (ZSECURITY COLLATE BINARY ASC, ZQUOTEDATE COLLATE BINARY ASC);
CREATE INDEX Z_SecuritySplit_security_splitDate ON ZSECURITYSPLIT (ZSECURITY COLLATE BINARY ASC, ZSPLITDATE COLLATE BINARY ASC);
CREATE INDEX Z_SecuritySplit_splitDate ON ZSECURITYSPLIT (ZSPLITDATE COLLATE BINARY ASC);
CREATE INDEX ZQUICKPAYPAYMENT_ZPAYMENTACCOUNT_INDEX ON ZQUICKPAYPAYMENT (ZPAYMENTACCOUNT);
CREATE INDEX ZQUICKPAYPAYMENT_ZTRANSACTION_INDEX ON ZQUICKPAYPAYMENT (ZTRANSACTION);
CREATE INDEX ZCHECKPAYCHECK_ZCHECKPAYPAYEE_INDEX ON ZCHECKPAYCHECK (ZCHECKPAYPAYEE);
CREATE INDEX ZCHECKPAYCHECK_ZPAYMENTACCOUNT_INDEX ON ZCHECKPAYCHECK (ZPAYMENTACCOUNT);
CREATE INDEX ZCHECKPAYCHECK_ZTRANSACTION_INDEX ON ZCHECKPAYCHECK (ZTRANSACTION);
CREATE INDEX ZRECONCILEDTRANSACTION_ZFITRANSACTION_INDEX ON ZRECONCILEDTRANSACTION (ZFITRANSACTION);
CREATE INDEX ZRECONCILERECORD_ZACCOUNT_INDEX ON ZRECONCILERECORD (ZACCOUNT);
CREATE INDEX Z_BudgetLineItem_syncID ON ZBUDGETLINEITEM (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_BudgetLineItem_bySyncID ON ZBUDGETLINEITEM (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_BudgetTarget_byEffectiveDateNumIndex ON ZBUDGETTARGET (ZEFFECTIVEDATENUM COLLATE BINARY ASC);
CREATE INDEX Z_BudgetTarget_bySyncID ON ZBUDGETTARGET (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_DocumentProperty_byNameIndex ON ZDOCUMENTPROPERTY (ZNAME COLLATE BINARY ASC);
CREATE INDEX Z_FIPosition_byUniqueIDIndex ON ZFIPOSITION (ZUNIQUEID COLLATE BINARY ASC);
CREATE INDEX Z_Lot_bySyncID ON ZLOT (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_LotAssignment_bySyncID ON ZLOTASSIGNMENT (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_LotMod_bySyncID ON ZLOTMOD (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_Position_byUniqueIDIndex ON ZPOSITION (ZUNIQUEID COLLATE BINARY ASC);
CREATE INDEX Z_Position_bySyncID ON ZPOSITION (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_ScheduleAdjustmentEntry_byOriginalScheduledDateIndex ON ZSCHEDULEADJUSTMENTENTRY (ZORIGINALSCHEDULEDDATE COLLATE BINARY ASC);
CREATE INDEX Z_SecurityID_byUniqueIDIndex ON ZSECURITYID (ZUNIQUEID COLLATE BINARY ASC);
CREATE INDEX Z_SecurityQuote_byQuoteDateIndex ON ZSECURITYQUOTE (ZQUOTEDATE COLLATE BINARY ASC);
CREATE INDEX Z_SecurityQuote_compoundIndex ON ZSECURITYQUOTE (ZSECURITY COLLATE BINARY ASC, ZQUOTEDATE COLLATE BINARY ASC);
CREATE INDEX Z_SecuritySplit_bySplitDateIndex ON ZSECURITYSPLIT (ZSPLITDATE COLLATE BINARY ASC);
CREATE INDEX Z_SecuritySplit_compoundIndex ON ZSECURITYSPLIT (ZSECURITY COLLATE BINARY ASC, ZSPLITDATE COLLATE BINARY ASC);
CREATE INDEX Z_Security_syncID ON ZSECURITY (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_Security_ticker ON ZSECURITY (ZTICKER COLLATE BINARY ASC);
CREATE INDEX Z_Security_byTickerIndex ON ZSECURITY (ZTICKER COLLATE BINARY ASC);
CREATE INDEX Z_Security_bySyncID ON ZSECURITY (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_1DOWNLOADSESSIONS_Z_23DOWNLOADSESSIONS_INDEX ON Z_1DOWNLOADSESSIONS (Z_26DOWNLOADSESSIONS, Z_1ACCOUNTS1);
CREATE INDEX Z_1BUDGETS_Z_12BUDGETS_INDEX ON Z_1BUDGETS (Z_13BUDGETS, Z_1ACCOUNTS);
CREATE INDEX ZBILLPAYFUNDINGACCOUNT_ZACCOUNT_INDEX ON ZBILLPAYFUNDINGACCOUNT (ZACCOUNT);
CREATE INDEX ZBILLPAYPAYMENTACCOUNT_ZACCOUNT_INDEX ON ZBILLPAYPAYMENTACCOUNT (ZACCOUNT);
CREATE INDEX Z_16USERTAGS_Z_58USERTAGS_INDEX ON "Z_18USERTAGS" (Z_70USERTAGS, Z_18CASHFLOWTRANSACTIONENTRIES);
CREATE INDEX ZCHECKPAYCHECK_ZBILLPAYFUNDINGACCOUNT_INDEX ON ZCHECKPAYCHECK (ZBILLPAYFUNDINGACCOUNT);
CREATE INDEX Z_40USERTAGS_Z_58USERTAGS1_INDEX ON "Z_52USERTAGS" (Z_70USERTAGS1, Z_52QUICKFILLRULESPLITENTRIES);
CREATE INDEX ZQUICKPAYPAYMENT_ZBILLPAYFUNDINGACCOUNT_INDEX ON ZQUICKPAYPAYMENT (ZBILLPAYFUNDINGACCOUNT);
CREATE INDEX Z_DownloadSession_sessionNumber ON ZDOWNLOADSESSION (ZSESSIONNUMBER COLLATE BINARY ASC);
CREATE INDEX Z_DownloadSession_bySessionNumberIndex ON ZDOWNLOADSESSION (ZSESSIONNUMBER COLLATE BINARY ASC);
CREATE INDEX Z_1DOWNLOADSESSIONS_Z_24DOWNLOADSESSIONS_INDEX ON Z_1DOWNLOADSESSIONS (Z_26DOWNLOADSESSIONS, Z_1ACCOUNTS1);
CREATE INDEX Z_1BUDGETS_Z_13BUDGETS_INDEX ON Z_1BUDGETS (Z_13BUDGETS, Z_1ACCOUNTS);
CREATE INDEX ZBILLPRESENTMENTACCOUNT_ZAGGPROVIDERACCOUNT_INDEX ON ZBILLPRESENTMENTACCOUNT (ZAGGPROVIDERACCOUNT);
CREATE INDEX ZBILLPRESENTMENTACCOUNT_ZBPSPROVIDERACCOUNT_INDEX ON ZBILLPRESENTMENTACCOUNT (ZBPSPROVIDERACCOUNT);
CREATE INDEX ZBILLPRESENTMENTACCOUNT_ZUSERPAYEE_INDEX ON ZBILLPRESENTMENTACCOUNT (ZUSERPAYEE);
CREATE INDEX ZBILLPRESENTMENTPROVIDERACCOUNT_ZBPSACCOUNT_INDEX ON ZBILLPRESENTMENTPROVIDERACCOUNT (ZBPSACCOUNT);
CREATE INDEX ZBILLPRESENTMENTPROVIDERACCOUNT_ZPROVIDERLOGIN_INDEX ON ZBILLPRESENTMENTPROVIDERACCOUNT (ZPROVIDERLOGIN);
CREATE INDEX ZBILLPRESENTMENTPROVIDERBILL_ZDOCUMENTMETADATA_INDEX ON ZBILLPRESENTMENTPROVIDERBILL (ZDOCUMENTMETADATA);
CREATE INDEX ZBILLPRESENTMENTPROVIDERBILL_ZPROVIDERACCOUNT_INDEX ON ZBILLPRESENTMENTPROVIDERBILL (ZPROVIDERACCOUNT);
CREATE INDEX ZBILLPRESENTMENTPROVIDERDOCUMENTMETADATA_ZPROVIDERACCOUNT_INDEX ON ZBILLPRESENTMENTPROVIDERDOCUMENTMETADATA (ZPROVIDERACCOUNT);
CREATE INDEX Z_17USERTAGS_Z_59USERTAGS_INDEX ON "Z_18USERTAGS" (Z_70USERTAGS, Z_18CASHFLOWTRANSACTIONENTRIES);
CREATE INDEX Z_41USERTAGS_Z_59USERTAGS1_INDEX ON "Z_52USERTAGS" (Z_70USERTAGS1, Z_52QUICKFILLRULESPLITENTRIES);
CREATE INDEX ZQUICKPAYPAYMENT_ZPROVIDERACCOUNT_INDEX ON ZQUICKPAYPAYMENT (ZPROVIDERACCOUNT);
CREATE INDEX ZACCOUNT_ZBILLPAYFUNDINGACCOUNT_INDEX ON ZACCOUNT (ZBILLPAYFUNDINGACCOUNT);
CREATE INDEX ZACCOUNT_ZBILLPAYPAYMENTACCOUNT_INDEX ON ZACCOUNT (ZBILLPAYPAYMENTACCOUNT);
CREATE INDEX ZACCOUNT_ZBILLPAYPROVIDERINSTITUTION_INDEX ON ZACCOUNT (ZBILLPAYPROVIDERINSTITUTION);
CREATE INDEX ZACCOUNT_ZBPSACCOUNT_INDEX ON ZACCOUNT (ZBPSACCOUNT);
CREATE INDEX ZACCOUNT_ZCLOUDFILOGIN_INDEX ON ZACCOUNT (ZCLOUDFILOGIN);
CREATE INDEX ZACCOUNT_ZERROR_INDEX ON ZACCOUNT (ZERROR);
CREATE INDEX ZACCOUNT_ZFINANCIALINSTITUTION_INDEX ON ZACCOUNT (ZFINANCIALINSTITUTION);
CREATE INDEX ZACCOUNT_ZLOANINTERESTCATEGORY_INDEX ON ZACCOUNT (ZLOANINTERESTCATEGORY);
CREATE INDEX ZACCOUNT_ZLOANSMARTTRANSACTION_INDEX ON ZACCOUNT (ZLOANSMARTTRANSACTION);
CREATE INDEX ZCONNECTIVITYEVENTRESULT_ZACCOUNT_INDEX ON ZCONNECTIVITYEVENTRESULT (ZACCOUNT);
CREATE INDEX ZCONNECTIVITYEVENTRESULT_ZBPSPROVIDERLOGIN_INDEX ON ZCONNECTIVITYEVENTRESULT (ZBPSPROVIDERLOGIN);
CREATE INDEX ZCONNECTIVITYEVENTRESULT_ZCLOUDFILOGIN_INDEX ON ZCONNECTIVITYEVENTRESULT (ZCLOUDFILOGIN);
CREATE INDEX ZCONNECTIVITYEVENTRESULT_ZDOWNLOADSESSION_INDEX ON ZCONNECTIVITYEVENTRESULT (ZDOWNLOADSESSION);
CREATE INDEX ZCONNECTIVITYEVENTRESULT_ZSHADOWACCOUNT_INDEX ON ZCONNECTIVITYEVENTRESULT (ZSHADOWACCOUNT);
CREATE INDEX Z_1DOWNLOADSESSIONS_Z_25DOWNLOADSESSIONS_INDEX ON Z_1DOWNLOADSESSIONS (Z_26DOWNLOADSESSIONS, Z_1ACCOUNTS1);
CREATE INDEX ZCASHFLOWTRANSACTIONENTRY_ZBUSINESS_INDEX ON ZCASHFLOWTRANSACTIONENTRY (ZBUSINESS);
CREATE INDEX Z_18USERTAGS_Z_59USERTAGS_INDEX ON "Z_18USERTAGS" (Z_70USERTAGS, Z_18CASHFLOWTRANSACTIONENTRIES);
CREATE INDEX Z_42USERTAGS_Z_59USERTAGS1_INDEX ON "Z_52USERTAGS" (Z_70USERTAGS1, Z_52QUICKFILLRULESPLITENTRIES);
CREATE INDEX ZACCOUNT_ZPRIMARYUSEBUSINESS_INDEX ON ZACCOUNT (ZPRIMARYUSEBUSINESS);
CREATE INDEX Z_18USERTAGS_Z_60USERTAGS_INDEX ON "Z_18USERTAGS" (Z_70USERTAGS, Z_18CASHFLOWTRANSACTIONENTRIES);
CREATE INDEX ZCONNECTIVITYEVENTRESULT_ZTRANSACTION_INDEX ON ZCONNECTIVITYEVENTRESULT (ZTRANSACTION);
CREATE INDEX Z_ConnectivityEventResult_quickenId ON ZCONNECTIVITYEVENTRESULT (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_ConnectivityEventResult_guid ON ZCONNECTIVITYEVENTRESULT (ZGUID COLLATE BINARY ASC);
CREATE INDEX Z_ConnectivityEventResult_byGuidIndex ON ZCONNECTIVITYEVENTRESULT (ZGUID COLLATE BINARY ASC);
CREATE INDEX Z_ConnectivityEventResult_byQuickenidIndex ON ZCONNECTIVITYEVENTRESULT (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_ConnectivityEventResult_byLastSeenTimestampIndex ON ZCONNECTIVITYEVENTRESULT (ZACCOUNT COLLATE BINARY ASC, ZLASTSEENTIMESTAMP COLLATE BINARY ASC);
CREATE INDEX ZMILEAGEENTRY_ZBUSINESS_INDEX ON ZMILEAGEENTRY (ZBUSINESS);
CREATE INDEX ZMILEAGEENTRY_ZROUNDTRIPENTRY_INDEX ON ZMILEAGEENTRY (ZROUNDTRIPENTRY);
CREATE INDEX Z_43USERTAGS_Z_60USERTAGS1_INDEX ON "Z_52USERTAGS" (Z_70USERTAGS1, Z_52QUICKFILLRULESPLITENTRIES);
CREATE INDEX ZTAXPAYMENTRECORD_ZBUSINESS_INDEX ON ZTAXPAYMENTRECORD (ZBUSINESS);
CREATE INDEX ZTRANSACTION_ZACCOUNT_INDEX ON ZTRANSACTION (ZACCOUNT);
CREATE INDEX ZTRANSACTION_ZDOWNLOADSESSION_INDEX ON ZTRANSACTION (ZDOWNLOADSESSION);
CREATE INDEX ZTRANSACTION_ZERROR_INDEX ON ZTRANSACTION (ZERROR);
CREATE INDEX ZTRANSACTION_ZFITRANSACTION_INDEX ON ZTRANSACTION (ZFITRANSACTION);
CREATE INDEX ZTRANSACTION_ZPLACEHOLDERACCOUNT_INDEX ON ZTRANSACTION (ZPLACEHOLDERACCOUNT);
CREATE INDEX ZTRANSACTION_ZRECONCILEDTRANSACTION_INDEX ON ZTRANSACTION (ZRECONCILEDTRANSACTION);
CREATE INDEX ZTRANSACTION_ZRENAMINGRULEUSED_INDEX ON ZTRANSACTION (ZRENAMINGRULEUSED);
CREATE INDEX ZTRANSACTION_ZSENDACCOUNT_INDEX ON ZTRANSACTION (ZSENDACCOUNT);
CREATE INDEX ZTRANSACTION_ZTARGETACCOUNT_INDEX ON ZTRANSACTION (ZTARGETACCOUNT);
CREATE INDEX ZTRANSACTION_ZACTION_INDEX ON ZTRANSACTION (ZACTION);
CREATE INDEX ZTRANSACTION_ZCHECKPAYCHECK_INDEX ON ZTRANSACTION (ZCHECKPAYCHECK);
CREATE INDEX ZTRANSACTION_ZQUICKPAYPAYMENT_INDEX ON ZTRANSACTION (ZQUICKPAYPAYMENT);
CREATE INDEX ZTRANSACTION_ZUSERPAYEE_INDEX ON ZTRANSACTION (ZUSERPAYEE);
CREATE INDEX ZTRANSACTION_ZLOANACCOUNT_INDEX ON ZTRANSACTION (ZLOANACCOUNT);
CREATE INDEX ZTRANSACTION_ZPOSITION_INDEX ON ZTRANSACTION (ZPOSITION);
CREATE INDEX ZTRANSACTION_Z_ENT_INDEX ON ZTRANSACTION (Z_ENT);
CREATE INDEX Z_CashFlowTransaction_enteredDate ON ZTRANSACTION (ZENTEREDDATE COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransaction_reconcileStatus ON ZTRANSACTION (ZRECONCILESTATUS COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransaction_syncID ON ZTRANSACTION (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransaction_onlineID ON ZTRANSACTION (ZONLINEID COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransaction_postedDate ON ZTRANSACTION (ZPOSTEDDATE COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransaction_quickenId ON ZTRANSACTION (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransaction_onlineBankingServerID ON ZTRANSACTION (ZONLINEBANKINGSERVERID COLLATE BINARY ASC);
CREATE INDEX Z_InvestmentTransaction_enteredDate ON ZTRANSACTION (ZENTEREDDATE COLLATE BINARY ASC);
CREATE INDEX Z_InvestmentTransaction_reconcileStatus ON ZTRANSACTION (ZRECONCILESTATUS COLLATE BINARY ASC);
CREATE INDEX Z_InvestmentTransaction_syncID ON ZTRANSACTION (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_InvestmentTransaction_onlineID ON ZTRANSACTION (ZONLINEID COLLATE BINARY ASC);
CREATE INDEX Z_InvestmentTransaction_postedDate ON ZTRANSACTION (ZPOSTEDDATE COLLATE BINARY ASC);
CREATE INDEX Z_InvestmentTransaction_quickenId ON ZTRANSACTION (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_InvestmentTransaction_onlineBankingServerID ON ZTRANSACTION (ZONLINEBANKINGSERVERID COLLATE BINARY ASC);
CREATE INDEX Z_FITransaction_fiTransactionID ON ZFITRANSACTION (ZFITRANSACTIONID COLLATE BINARY ASC);
CREATE INDEX Z_FITransaction_byFiTransactionIDIndex ON ZFITRANSACTION (ZFITRANSACTIONID COLLATE BINARY ASC);
CREATE INDEX Z_1DOWNLOADSESSIONS_Z_26DOWNLOADSESSIONS_INDEX ON Z_1DOWNLOADSESSIONS (Z_26DOWNLOADSESSIONS, Z_1ACCOUNTS1);
CREATE INDEX Z_1BUDGETS_Z_14BUDGETS_INDEX ON Z_1BUDGETS (Z_13BUDGETS, Z_1ACCOUNTS);
CREATE INDEX Z_19USERTAGS_Z_61USERTAGS_INDEX ON "Z_18USERTAGS" (Z_70USERTAGS, Z_18CASHFLOWTRANSACTIONENTRIES);
CREATE INDEX Z_44USERTAGS_Z_61USERTAGS1_INDEX ON "Z_52USERTAGS" (Z_70USERTAGS1, Z_52QUICKFILLRULESPLITENTRIES);
CREATE INDEX ZTAG_ZPARENTCATEGORY_INDEX ON ZTAG (ZPARENTCATEGORY);
CREATE INDEX ZTAG_Z_ENT_INDEX ON ZTAG (Z_ENT);
CREATE INDEX Z_Tag_syncID ON ZTAG (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_Tag_bySyncID ON ZTAG (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTag_syncID ON ZTAG (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_CategoryTag_syncID ON ZTAG (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_UserTag_syncID ON ZTAG (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX ZCASHFLOWTRANSACTIONENTRY_ZPAYMENT_INDEX ON ZCASHFLOWTRANSACTIONENTRY (ZPAYMENT);
CREATE INDEX Z_18USERTAGS_Z_69USERTAGS_INDEX ON Z_18USERTAGS (Z_70USERTAGS, Z_18CASHFLOWTRANSACTIONENTRIES);
CREATE INDEX ZIFSBILLPAYBILLERACCOUNT_ZUSERPAYEE_INDEX ON ZIFSBILLPAYBILLERACCOUNT (ZUSERPAYEE);
CREATE INDEX ZIFSBILLPAYPAYMENT_ZFUNDINGACCOUNT_INDEX ON ZIFSBILLPAYPAYMENT (ZFUNDINGACCOUNT);
CREATE INDEX ZIFSBILLPAYPAYMENT_ZIFSBILLERACCOUNT_INDEX ON ZIFSBILLPAYPAYMENT (ZIFSBILLERACCOUNT);
CREATE INDEX ZIFSBILLPAYPAYMENT_ZTRANSACTION_INDEX ON ZIFSBILLPAYPAYMENT (ZTRANSACTION);
CREATE INDEX ZINVOICELINEITEM_ZCATEGORY_INDEX ON ZINVOICELINEITEM (ZCATEGORY);
CREATE INDEX ZINVOICELINEITEM_ZINVOICE_INDEX ON ZINVOICELINEITEM (ZINVOICE);
CREATE INDEX ZINVOICELINEITEM_ZPRODUCTSERVICE_INDEX ON ZINVOICELINEITEM (ZPRODUCTSERVICE);
CREATE INDEX ZPAYMENTALLOCATION_ZINVOICE_INDEX ON ZPAYMENTALLOCATION (ZINVOICE);
CREATE INDEX ZPAYMENTALLOCATION_ZPAYMENT_INDEX ON ZPAYMENTALLOCATION (ZPAYMENT);
CREATE INDEX ZPRODUCTSERVICE_ZCATEGORY_INDEX ON ZPRODUCTSERVICE (ZCATEGORY);
CREATE INDEX ZPROJECT_ZCUSTOMER_INDEX ON ZPROJECT (ZCUSTOMER);
CREATE INDEX Z_52USERTAGS_Z_69USERTAGS1_INDEX ON Z_52USERTAGS (Z_70USERTAGS1, Z_52QUICKFILLRULESPLITENTRIES);
CREATE INDEX ZTAXRATE_ZTAXAGENCY_INDEX ON ZTAXRATE (ZTAXAGENCY);
CREATE INDEX ZTRANSACTION_ZINVOICE_INDEX ON ZTRANSACTION (ZINVOICE);
CREATE INDEX ZTRANSACTION_ZIFSPAYMENT_INDEX ON ZTRANSACTION (ZIFSPAYMENT);
CREATE INDEX Z_Transaction_onlineBankingServerID ON ZTRANSACTION (ZONLINEBANKINGSERVERID COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_enteredDate ON ZTRANSACTION (ZENTEREDDATE COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_reconcileStatus ON ZTRANSACTION (ZRECONCILESTATUS COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_quickenId ON ZTRANSACTION (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_syncID ON ZTRANSACTION (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_postedDate ON ZTRANSACTION (ZPOSTEDDATE COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_onlineID ON ZTRANSACTION (ZONLINEID COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_byEnteredDateIndex ON ZTRANSACTION (ZENTEREDDATE COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_byOnlineBankingServerIDIndex ON ZTRANSACTION (ZONLINEBANKINGSERVERID COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_byOnlineIDIndex ON ZTRANSACTION (ZONLINEID COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_byPostedDateIndex ON ZTRANSACTION (ZPOSTEDDATE COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_byQuickenIdIndex ON ZTRANSACTION (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_byReconcileStatusIndex ON ZTRANSACTION (ZRECONCILESTATUS COLLATE BINARY ASC);
CREATE INDEX Z_Transaction_bySyncID ON ZTRANSACTION (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX ZUSERPAYEE_ZBPSACCOUNT_INDEX ON ZUSERPAYEE (ZBPSACCOUNT);
CREATE INDEX ZUSERPAYEE_ZCHECKPAYADDRESS_INDEX ON ZUSERPAYEE (ZCHECKPAYADDRESS);
CREATE INDEX ZUSERPAYEE_ZIFSBILLERACCOUNT_INDEX ON ZUSERPAYEE (ZIFSBILLERACCOUNT);
CREATE INDEX ZUSERPAYEEADDRESS_ZUSERPAYEE_INDEX ON ZUSERPAYEEADDRESS (ZUSERPAYEE);
CREATE INDEX Z_18USERTAGS_Z_70USERTAGS_INDEX ON Z_18USERTAGS (Z_70USERTAGS, Z_18CASHFLOWTRANSACTIONENTRIES);
CREATE INDEX Z_52USERTAGS_Z_70USERTAGS1_INDEX ON Z_52USERTAGS (Z_70USERTAGS1, Z_52QUICKFILLRULESPLITENTRIES);
CREATE INDEX ZREPORT_ZFOLDER_INDEX ON ZREPORT (ZFOLDER);
CREATE INDEX Z_Account_syncID ON ZACCOUNT (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_Account_typeName ON ZACCOUNT (ZTYPENAME COLLATE BINARY ASC);
CREATE INDEX Z_Account_quickenId ON ZACCOUNT (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_Account_onlineBankingServerID ON ZACCOUNT (ZONLINEBANKINGSERVERID COLLATE BINARY ASC);
CREATE INDEX Z_Account_byOnlineBankingServerIDIndex ON ZACCOUNT (ZONLINEBANKINGSERVERID COLLATE BINARY ASC);
CREATE INDEX Z_Account_byQuickenIdIndex ON ZACCOUNT (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_Account_byTypeIndex ON ZACCOUNT (ZTYPENAME COLLATE BINARY ASC);
CREATE INDEX Z_Account_bySyncID ON ZACCOUNT (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX ZATTACHMENT_ZACCOUNT_INDEX ON ZATTACHMENT (ZACCOUNT);
CREATE INDEX ZATTACHMENT_ZBUSINESS_INDEX ON ZATTACHMENT (ZBUSINESS);
CREATE INDEX ZATTACHMENT_ZCUSTOMER_INDEX ON ZATTACHMENT (ZCUSTOMER);
CREATE INDEX ZATTACHMENT_ZPROJECT_INDEX ON ZATTACHMENT (ZPROJECT);
CREATE INDEX ZATTACHMENT_ZTRANSACTION_INDEX ON ZATTACHMENT (ZTRANSACTION);
CREATE INDEX ZBUSINESS_ZINVOICEBACKGROUNDATTACHMENT_INDEX ON ZBUSINESS (ZINVOICEBACKGROUNDATTACHMENT);
CREATE INDEX ZBUSINESS_ZLOGOATTACHMENT_INDEX ON ZBUSINESS (ZLOGOATTACHMENT);
CREATE INDEX ZCASHFLOWTRANSACTIONENTRY_ZCUSTOMER_INDEX ON ZCASHFLOWTRANSACTIONENTRY (ZCUSTOMER);
CREATE INDEX ZCASHFLOWTRANSACTIONENTRY_ZPROJECT_INDEX ON ZCASHFLOWTRANSACTIONENTRY (ZPROJECT);
CREATE INDEX Z_CashFlowTransactionEntry_quickenId ON ZCASHFLOWTRANSACTIONENTRY (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransactionEntry_syncID ON ZCASHFLOWTRANSACTIONENTRY (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransactionEntry_byQuickenIdIndex ON ZCASHFLOWTRANSACTIONENTRY (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_CashFlowTransactionEntry_bySyncID ON ZCASHFLOWTRANSACTIONENTRY (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX ZINVOICE_ZBUSINESS_INDEX ON ZINVOICE (ZBUSINESS);
CREATE INDEX ZINVOICE_ZCUSTOMER_INDEX ON ZINVOICE (ZCUSTOMER);
CREATE INDEX ZINVOICE_ZINVOICEBACKGROUNDATTACHMENT_INDEX ON ZINVOICE (ZINVOICEBACKGROUNDATTACHMENT);
CREATE INDEX ZINVOICE_ZLOGOATTACHMENT_INDEX ON ZINVOICE (ZLOGOATTACHMENT);
CREATE INDEX ZINVOICE_ZPROJECT_INDEX ON ZINVOICE (ZPROJECT);
CREATE INDEX ZINVOICE_ZTAXRATE_INDEX ON ZINVOICE (ZTAXRATE);
CREATE INDEX ZINVOICE_ZTRANSACTION_INDEX ON ZINVOICE (ZTRANSACTION);
CREATE INDEX ZPAYMENT_ZBUSINESS_INDEX ON ZPAYMENT (ZBUSINESS);
CREATE INDEX ZPAYMENT_ZCUSTOMER_INDEX ON ZPAYMENT (ZCUSTOMER);
CREATE INDEX ZPAYMENT_ZTRANSACTIONENTRY_INDEX ON ZPAYMENT (ZTRANSACTIONENTRY);
CREATE INDEX Z_SmartCashFlowTransaction_enteredDate ON ZTRANSACTION (ZENTEREDDATE COLLATE BINARY ASC);
CREATE INDEX Z_SmartCashFlowTransaction_reconcileStatus ON ZTRANSACTION (ZRECONCILESTATUS COLLATE BINARY ASC);
CREATE INDEX Z_SmartCashFlowTransaction_syncID ON ZTRANSACTION (ZSYNCID COLLATE BINARY ASC);
CREATE INDEX Z_SmartCashFlowTransaction_onlineID ON ZTRANSACTION (ZONLINEID COLLATE BINARY ASC);
CREATE INDEX Z_SmartCashFlowTransaction_postedDate ON ZTRANSACTION (ZPOSTEDDATE COLLATE BINARY ASC);
CREATE INDEX Z_SmartCashFlowTransaction_quickenId ON ZTRANSACTION (ZQUICKENID COLLATE BINARY ASC);
CREATE INDEX Z_SmartCashFlowTransaction_onlineBankingServerID ON ZTRANSACTION (ZONLINEBANKINGSERVERID COLLATE BINARY ASC);
