SQLite format 3@   cc%!MODIFIEDDATE2010-03-13USERNAMErsanjose)BASECURRENCYID6!DATEFORMAT%m/%d/%y!!CREATEDATE2010-03-13#MMEXVERSION0#DATAVERSION2 tU6&   ! RUBр.,Рублькоп.d+ #  SWISS FRANCCHF.,franccentimesd$   UK POUND£.,PoundPenced !   EURO-SPAIN€,.d !   EURO-ITALY€,.d %   EURO-BELGIUM€,.d #   EURO-FRANCE€, d %   EURO-GERMANY€,.d(  US DOLLAR$.,dollarcentsdUSD a$=9  Mi tarjeta de créditoCheckingOpenzTRUE;5  Mi cuenta remuneradaCheckingOpen@QTRUE;5  Mi cuenta de valoresCheckingOpen@ TRUE:3  Mi cuenta corrienteCheckingOpen@l \)TRUE$  CajaCheckingOpensTRUE O%%tableINFOTABLE_V1INFOTABLE_V1CREATE TABLE INFOTABLE_V1(INFOID integer primary key, INFONAME TEXT NOT NULL, INFOVALUE TEXT).11tableCURRENCYFORMATS_V1CURRENCYFORMATS_V1CREATE TABLE CURRENCYFORMATS_V1(CURRENCYID integer primary key, CURRENCYNAME TEXT NOT NULL, PFX_SYMBOL TEXT, SFX_SYMBOL TEXT, DECIMAL_POINT TEXT, GROUP_SEPARATOR TEXT, UNIT_NAME TEXT, CENT_NAME TEXT, SCALE numeric, BASECONVRATE numeric, CURRENCY_SYMBOL TEXT) ''s))!tableACCOUNTLIST_V1ACCOUNTLIST_V1CREATE TABLE ACCOUNTLIST_V1(ACCOUNTID integer primary key, ACCOUNTNAME TEXT NOT NULL, ACCOUNTTYPE TEXT NOT NULL, ACCOUNTNUM TEXT, STATUS TEXT NOT NULL, NOTES TEXT, HELDAT TEXT, WEBSITE TEXT, CONTACTINFO TEXT, ACCESSINFO TEXT, INITIALBAL numeric, FAVORITEACCT TEXT NOT NULL, CURRENCYID numeric NOT NULL)`11ktableCHECKINGACCOUNT_V1CHECKINGACCOUNT_V1CREATE TABLE CHECKINGACCOUNT_V1(TRANSID integer primary key, ACCOUNTID numeric NOT NULL, TOACCOUNTID numeric, PAYEEID numeric NOT NULL, TRANSCODE TEXT NOT NULL, TRANSAMOUNT numeric NOT NULL, STATUS TEXT, TRANSACTIONNUMBER TEXT, NOTES TEXT, CATEGID numeric, SUBCATEGID numeric, TRANSDATE TEXT, FOLLOWUPID numeric, TOTRANSAMOUNT numeric)  +Unidad familiar Otros!Matrimonio+Hijos por igual Esposo + Esposa + UUM*'tablePAYEE_V1PAYEE_V1CREATE TABLE PAYEE_V1(PAYEEID integer primary key, PAYEENAME TEXT NOT NULL, CATEGID numeric, SUBCATEGID numeric)##ctableCATEGORY_V1CATEGORY_V1 CREATE TABLE CATEGORY_V1(CATEGID integer primary key, CATEGNAME TEXT NOT NULL)7)))tableSUBCATEGORY_V1SUBCATEGORY_V1 CREATE TABLE SUBCATEGORY_V1(SUBCATEGID integer primary key, SUBCATEGNAME TEXT NOT NULL, CATEGID numeric NOT NULL)''{tableBUDGETYEAR_V1BUDGETYEAR_V1 CREATE TABLE BUDGETYEAR_V1(BUDGETYEARID integer primary key, BUDGETYEARNAME TEXT NOT NULL) ))YtableBUDGETTABLE_V1BUDGETTABLE_V1 CREATE TABLE BUDGETTABLE_V1(BUDGETENTRYID integer primary key, BUDGETYEARID numeric, CATEGID numeric, SUBCATEGID numeric, PERIOD TEXT NOT NULL, AMOUNT numeric NOT NULL) .}th\P=. !Vacaciones)Transferencias Seguros Sanidad Regalos Ocio #Inversiones Ingresos ImpuestosHogar Facturas !Educación%Desgravables ComidasCoche Ahorro7   dv:d@ !!TransferAhorro2010-03-132010-03-05L !!Deposit@nQNómina +2010-03-13@nQ2010-03-05 D! !!!Withdrawal&Sindicatos 2010-03-13&2010-04-01:! !!Withdrawal<2010-04-01<2010-03-01L !!Deposit@ =pNómina +2010-03-13@ =p2010-03-01 :! !!Withdrawal22010-03-1322010-03-25 { --)tableBILLSDEPOSITS_V1BILLSDEPOSITS_V1CREATE TABLE BILLSDEPOSITS_V1(BDID integer primary key, ACCOUNTID numeric NOT NULL, TOACCOUNTID numeric, PAYEEID numeric NOT NULL, TRANSCODE TEXT NOT NULL, TRANSAMOUNT numeric NOT NULL, STATUS TEXT, TRANSACTIONNUMBER TEXT, NOTES TEXT, CATEGID numeric, SUBCATEGID numeric, TRANSDATE TEXT, FOLLOWUPID numeric, TOTRANSAMOUNT numeric, REPEATS numeric, NEXTOCCURRENCEDATE TEXT, NUMOCCURRENCES numeric)o 1tableSTOCK_V1STOCK_V1CREATE TABLE STOCK_V1(STOCKID integer primary key, HELDAT numeric, PURCHASEDATE TEXT NOT NULL, STOCKNAME TEXT, SYMBOL TEXT, NUMSHARES numeric, PURCHASEPRICE numeric NOT NULL, NOTES TEXT, CURRENTPRICE numeric NOT NULL, VALUE numeric, COMMISSION numeric)   AA tableBUDGETSPLITTRANSACTIONS_V1BUDGETSPLITTRANSACTIONS_V1CREATE TABLE BUDGETSPLITTRANSACTIONS_V1(SPLITTRANSID integer primary key, TRANSID numeric NOT NULL, CATEGID numeric, SUBCATEGID numeric, SPLITTRANSAMOUNT numeric)o 55tableSPLITTRANSACTIONS_V1SPLITTRANSACTIONS_V1CREATE TABLE SPLITTRANSACTIONS_V1(SPLITTRANSID integer primary key, TRANSID numeric NOT NULL, CATEGID numeric, SUBCATEGID numeric, SPLITTRANSAMOUNT numeric)' tableASSETS_V1ASSETS_V1CREATE TABLE ASSETS_V1(ASSETID integer primary key, STARTDATE TEXT NOT NULL, ASSETNAME TEXT, VALUE numeric, VALUECHANGE TEXT, NOTES TEXT, VALUECHANGERATE numeric, ASSETTYPE TEXT)   7ujYL;*yiWC4(|k[O>/# 7Salud 6Hogar 5Auto 4Otros 3Oculista 2%Medicamentos 1Dental 0Otros /Comidas .5Cine y espectáculos -!Matrimonio ,Hijos +Salarios *!Reembolsos )Otros (Intereses '!Dividendos &)Bonificaciones %9Beneficios inversiones $!Vehículos##Retenciones "Otros!9Contribución y basura 'Supermercados Ropa Reformas Otros Hipoteca'Hipermercados#DecoraciónTeléfono5Tarjetas de Crédito Otros Limpieza Internet GimnasioGasFarmacias%Electricidad'DisposicionesComunidad Otros !Matrícula !Materiales Libros !Sindicatos ONGs5Comida fuera de casa'Alimentación Otros'Mantenimiento#Combustible Compra!Matrimonio Hijos  ;Viajes:#Alojamiento9'Alimentación 8Vida