--Generales
insert into fentity values ('TTERMINALES','gene','Terminal',null,null,null,'0','0',null,'0');
insert into fentity values ('TRESULTADOS','gene','Tresult',null,null,null,'0','0',null,'0');
insert into fentity values ('TPREFIJOID','gene','Tprefixid',null,null,null,'0','0',null,'0');
insert into fentity values ('TPREFIJO','gene','Tprefix',null,null,null,'0','0',null,'0');
insert into fentity values ('TPREFIJOCODCONTABLESEC','gene','Taccountingprefix',null,null,null,'0','0',null,'0');
insert into fentity values ('TPREFIJOESTATUSCUENTA','gene','Tstatusaccountprefix',null,null,null,'0','0',null,'0');
insert into fentity values ('TPREFIJOPLAZOS','gene','Ttermprefix',null,null,null,'0','0',null,'0');
insert into fentity values ('TESTRUCTURACUENTAAUTOMATICA','gene','Tautomaticaccountstructure',null,null,null,'0','0',null,'0');
insert into fentity values ('TMONEDASID','gene','Tcurrencyid',null,null,null,'0','0',null,'0');
insert into fentity values ('TMONEDAS','gene','Tcurrency',null,null,null,'0','0',null,'0');
insert into fentity values ('TSUBSISTEMAID','gene','Tsubsystemid',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSIDENTIFICACIONID','gene','Tidentificationtypesid',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSIDENTIFICACION','gene','Tidentificationtypes',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSPERSONAID','gene','Tpersontypeid',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSPERSONA','gene','Tpersontype',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSDATO','gene','Tdatatypes',null,null,null,'0','0',null,'0');
insert into fentity values ('TFRECUENCIASID','gene','Tfrecuencyid',null,null,null,'0','0',null,'0');
insert into fentity values ('TFRECUENCIAS','gene','Tfrecuency',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSBANCAID','gene','Tbanktypeid',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSBANCA','gene','Tbanktype',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSBANCA','gene','Tbanktype',null,null,null,'0','0',null,'0');
insert into fentity values ('TGRUPOCONTABLEGRACIA','gene','Taccountantgroupgrace',null,null,null,'0','0',null,'0');
insert into fentity values ('TBEANS','gene.mng','Tbean',null,null,null,'0','0',null,'0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TSUBSISTEMA', 'gene', 'Tsubsystem', null, null, null, '0', '0', null, '0');
insert into fentity values ('TFORMATOXML','gene.front','Tforms',null,null,null,'0','0',null,'1');
insert into fentity values ('TPARAMETROSSISTEMAID','gene','Tsystemparameterid',null,null,null,'0','0',null,'0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TIDIOMAS', 'gene', 'Tlanguage', null, null, null, '0', '0', null, '1');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TFORMATOREPORTE', 'gene.front', 'Treports',null,null,null,'0','0',null,'0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TFORMATOREPORTEJASPER', 'gene.front', 'Tjasperreports',null,null,null,'0','0',null,'0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TUSUARIONOTIFICACIONES', 'gene', 'Tusernotification',null,null,null,'0','0',null,'0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TTIPOSVINCULACION', 'gene', 'Tvinculationtype', null, null, null, '0', '0', null, '0');


--localization
insert into fentity values ('TPAISESID','loc','Tcountryid',null,null,null,'0','0',null,'0');
insert into fentity values ('TPAISES','loc','Tcountry',null,null,null,'0','0',null,'0');
insert into fentity values ('TPROVINCIASID','loc','Tprovinceid',null,null,null,'0','0',null,'0');
insert into fentity values ('TPROVINCIAS','loc','Tprovince',null,null,null,'0','0',null,'0');
insert into fentity values ('TOFICINASID','loc','Tofficeid',null,null,null,'0','0',null,'0');
insert into fentity values ('TOFICINAS','loc','Toffice',null,null,null,'0','0',null,'0');
insert into fentity values ('TSUCURSALESID','loc','Tbranchid',null,null,null,'0','0',null,'0');
insert into fentity values ('TSUCURSALES','loc','Tbranch',null,null,null,'0','0',null,'0');
insert into fentity values ('TOFICINASSUCURSAL','loc','Tbranchoffice',null,null,null,'0','0',null,'0');
--fin Financieros

insert into fentity values ('TGRUPOBALANCEID','fin','Tbalancegroupid',null,null,null,'0','0',null,'0');
insert into fentity values ('TGRUPOBALANCE','fin','Tbalancegroup',null,null,null,'0','0',null,'0');
insert into fentity values ('TCATEGORIASID','fin','Tcategoriesid',null,null,null,v,'0',null,'0');
insert into fentity values ('TCATEGORIAS','fin','Tcategories',null,null,null,'0','0',null,'0');

insert into fentity values ('TMOVIMIENTOS','fin','Tmovement',null,null,null,'0','0',null,'0');
insert into fentity values ('TSALDOSMONEDACUENTA','fin','Taccountbalance','com.fitbank.common.financial.acco.BalanceTransport',null,null,'0','0',null,'0');
insert into fentity values ('TSALDOSMONEDAOFICIAL','fin','Tofficialbalance','com.fitbank.common.financial.acco.BalanceTransport',null,null,'0','0',null,'0');
insert into fentity values ('TSALDOSFECHAVALOR','fin','Tvaluedatebalance','com.fitbank.common.financial.acco.BalanceTransport',null,null,'0','0',null,'0');
insert into fentity values ('TPROVISIONDIARIA','fin','Tdailyprovision','com.fitbank.common.financial.acco.BalanceTransport',null,null,'0','0',null,'0');
insert into fentity values ('TSUCURSALFECHACONTABLE','fin','Taccountingdatebranch',null,null,null,'0','0',null,'0');


--Productos
insert into fentity values ('TPRODUCTOID','prod','Tproductid',null,null,null,'0','0',null,'0');
insert into fentity values ('TPRODUCTO','prod','Tproduct',null,null,null,'0','0',null,'0');
insert into fentity values ('TCOMPANIAPRODUCTOS','prod','Tproductcompany',null,null,null,'0','0',null,'0');
insert into fentity values ('TPRODUCTOMONEDA','prod','Tproductcurrency',null,null,null,'0','0',null,'0');
insert into fentity values ('TBASESCALCULO','prod','Tcalculationbase',null,null,null,'0','0',null,'0');
insert into fentity values ('TBASESCALCULOID','prod','Tcalculationbaseid',null,null,null,'0','0',null,'0');
insert into fentity values ('TORIGENFONDOS','prod','Toriginfounds',null,null,null,'0','0',null,'0');
insert into fentity values ('TORIGENFONDOSID','prod','Toriginfoundsid',null,null,null,'0','0',null,'0');
insert into fentity values ('TGRUPOCONTABLEID','prod','Taccountantgroupid',null,null,null,'0','0',null,'0');
insert into fentity values ('TGRUPOCONTABLE','prod','Taccountantgroup',null,null,null,'0','0',null,'1');
insert into fentity values ('TDESTINOFONDOS','prod','Tdestinyfounds',null,null,null,'0','0',null,'0');
insert into fentity values ('TDESTINOFONDOSID','prod','Tdestinyfoundsid',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSPRODUCTO','prod','Tproducttype',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSPRODUCTOID','prod','Tproducttypeid',null,null,null,'0','0',null,'0');
insert into fentity values ('TESTADOOPERACION','prod','Toperationstatus',null,null,null,'0','0',null,'0');
insert into fentity values ('TESTADOOPERACIONID','prod','Toperationstatusid',null,null,null,'0','0',null,'0');
insert into fentity values ('TGRUPOSPRODUCTOID','prod','Tproductgroupid',null,null,null,'0','0',null,'0');
insert into fentity values ('TGRUPOSPRODUCTO','prod','Tproductgroup',null,null,null,'0','0',null,'0');

--productos vista
insert into fentity values ('TPRODUCTOCAPTACIONESVISTA','prod.view','Tviewproduct',null,null,null,'0','0',null,'0');

--producto colocaciones
insert into fentity values ('TPRODUCTOCOLOCACIONES','prod.loan','Tloanproduct',null,null,null,'0','0',null,'0');

--acco datos de cuentas 
insert into fentity values ('TCUENTAID','acco','Taccountid',null,null,null,'0','0',null,'0');
insert into fentity values ('TCUENTA','acco','Taccount',null,null,null,'0','0',null,'0');
insert into fentity values ('TESTATUSMADURACIONID','acco','Tmaturationstatusid',null,null,null,'0','0',null,'0');
insert into fentity values ('TESTATUSMADURACION','acco','Tmaturationstatus',null,null,null,'0','0',null,'1');
insert into fentity values ('TSUBCUENTASID','acco','Tsubaccountid',null,null,null,'0','0',null,'0');
insert into fentity values ('TCUENTAFECHACONTABLE','acco','Taccountingdateaccount',null,null,null,'0','0',null,'0');


--receive account
insert into fentity values ('TCUENTASPORCOBRARPLANTILLAS','acco.receive','Templetereceiveaccount',null,null,null,'0','0',null,'0');
insert into fentity values ('TCUENTASPORCOBRAR','acco.receive','Treceiveaccount',null,null,null,'0','0',null,'1');

--person account 
insert into fentity values ('TCUENTASPERSONA','acco.person','Tpersonaccount',null,null,null,'0','0',null,'1');
insert into fentity values ('TOFICIALESCUENTAID','acco.person','Taccountoficerid',null,null,null,'0','0',null,'1');
insert into fentity values ('TOFICIALESCUENTA','acco.person','Taccountoficer',null,null,null,'0','0',null,'1');

--loan account 
insert into fentity values ('TCUENTACOLOCACIONES','acco.loan','Tloanaccount',null,null,null,'0','0',null,'1');


--trans  Transacciones

insert into fentity values ('TSUBSISTEMATRANSACCIONES','trans','Transaction',null,null,null,'0','0',null,'0');
insert into fentity values ('TSUBSISTEMATRANSACCIONESID','trans','Transactionid',null,null,null,'0','0',null,'0');
insert into fentity values ('TCOMANDOSTRANSACCION','trans','Tcommandtransaction',null,null,null,'0','0',null,'0');
insert into fentity values ('TTRANSACCIONRUBROS','trans','Itemtransaction',null,null,null,'0','0',null,'0');
insert into fentity values ('TCOMANDOSRUBRO','trans','Tcommanditem',null,null,null,'0','0',null,'0');
insert into fentity values ('TTRANSACCIONPROVISIONES','trans','Tprovisiontransaction',null,null,null,'0','0',null,'0');
insert into fentity values ('TMAPEOCOMPONENTERUBRO','trans','Tmappercomponets',null,null,null,'0','0',null,'0');
insert into fentity values ('TCOMANDOSMANTENIMIENTO','trans','Tcommandmanagement',null,null,null,'0','0',null,'0');
insert into fentity values ('TSUBSISTEMAEVENTOS','trans','Tsubsystemevents',null,null,null,'0','0',null,'1');
insert into fentity values ('TCOMPANIATRANSACCIONESPRODUCTO','trans','Tproducttransactioncompany',null,null,null,'0','0',null,'0');

-- tariff  Tarifarios
insert into fentity values ('TTARIFARIOCUENTA','tariff','Taccounttariff',null,'com.fitbank.common.financial.tariff.AbstractTariff',null,'0','0',null,'0');
insert into fentity values ('TTARIFARIOGENERAL','tariff','Tgeneraltariff',null,'com.fitbank.common.financial.tariff.AbstractTariff',null,'0','0',null,'0');
insert into fentity values ('TTARIFARIOPRODUCTO','tariff','Tproducttariff',null,'com.fitbank.common.financial.tariff.AbstractTariff',null,'0','0',null,'0');
insert into fentity values ('TPRODUCTOTASAS','tariff','Tproductratetariff',null,null,null,'0','0',null,'0');
insert into fentity values ('TCUENTAVISTATASAS','tariff','Taccountratetariff',null,null,null,'0','0',null,'0');
insert into fentity values ('TTASASREFERENCIALES','tariff','Treferencialrates',null,null,null,'0','0',null,'0');

--view  Cuentas a  la vista.

insert into fentity values ('TCATEGORIAINTERESVISTA','acco.view','Tcategoryinterest',null,null,null,'0','0',null,'0');
insert into fentity values ('TORDENFONDOSVISTA','acco.view','Torderviewfounds',null,null,null,'0','0',null,'0');
insert into fentity values ('TORDENCOBROSOBREGIROS','acco.view','Treceiveoverdraft',null,null,null,'0','0',null,'0');
insert into fentity values ('TCUENTASVISTA','acco.view','Tviewaccount',null,'com.fitbank.common.financial.acco.ProductAccount',null,'0','0',null,'0');
insert into fentity values ('TCUENTASSOLIDARIAS','acco.view','Tsolidaryaccount',null,null,null,'0','0',null,'0');
insert into fentity values ('TCUENTACHEQUES','acco.view','Tcheck',null,null,null,'0','0',null,'0');

--Seguridad
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TUSUARIOSID', 'safe', 'Tuserid', null, null, null, '0', '0', null, '0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TUSUARIOS', 'safe', 'Tuser', null, null, null, '0', '0', null, '1');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TROLESHORARIO', 'safe', 'Tschedulerole', null, null, null, '0', '0', null, '0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TCOMPANIAUSUARIOS', 'safe', 'Tusercompany', null, null, null, '0', '0', null, '0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TCOMPANIAROLES', 'safe', 'Trolecompany', null, null, null, '0', '0', null, '0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TPASSWORDPALABRASRESERVADAS', 'safe', 'Treservedwordpassword', null, null, null, '0', '0', null, '0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TNIVELESMENUID', 'safe', 'Tmenulevelid', null, null, null, '0', '0', null, '0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TNIVELESMENU', 'safe', 'Tmenulevel', null, null, null, '0', '0', null, '0');
insert into FENTITY (TNAME, PAC, ENTITY, JAVAEXTENDS, JAVAIMPLEMENTS, INSERTDML, CREATEREFERENCES, OPTIMISTICLOCKING, UPDATEDML, HISTORY)
values ('TUSUARIOPASSWORD', 'safe', 'Tpassworduser', null, null, null, '0', '0', null, '0');




--Contabilidad
insert into fentity values ('TCATALOGOCUENTAS','accounting','Taccountingcatalog',null,null,null,'0','0',null,'0');

--Cuotas
insert into fentity values ('TCUOTAS','quota','Tquota',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSCUOTAID','quota','Tquotatypeid',null,null,null,'0','0',null,'0');
insert into fentity values ('TTIPOSCUOTA','quota','Tquotatype',null,null,null,'0','0',null,'0');

--Interceptor
insert into fentity values ('TOBJETOPARAMETROS','inter','Tobjetoparametros',null,null,null,'0','0',null,'0');
insert into fentity values ('TOBJETOS','inter','Tobjetos',null,null,null,'0','0',null,'0');
insert into fentity values ('TLOVTITULOCAMPOS','inter','Tlovfieldheader',null,null,null,'0','0',null,'0');
insert into fentity values ('TOBJETOSCOMPOSICION','inter','Tobjetoscomposicion',null,null,null,'0','0',null,'0');
insert into fentity values ('TOBJETOSCOMPOSICIONPARAMETROS','inter','Tobjetoscomposicionparametros',null,null,null,'0','0',null,'0');


--Solicitues
insert into fentity values ('TSOLICITUDID','soli','Tsolicitudeid',null,null,null,'0','0',null,'0');
insert into fentity values ('TSOLICITUD','soli','Tsolicitude',null,null,null,'0','0',null,'1');
insert into fentity values ('TSOLICITUDTABS','soli','Ttabsolicitude',null,null,null,'0','0',null,'0');
insert into fentity values ('TESTATUSSOLICITUDID','soli','Tsolicitudestatusid',null,null,null,'0','0',null,'0');
insert into fentity values ('TESTATUSSOLICITUD','soli','Tsolicitudestatus',null,null,null,'0','0',null,'1');
insert into fentity values ('TSECUENCIASOLICITUD','soli','Tsolicitudesequence',null,null,null,'0','0',null,'0');
insert into fentity values ('TSOLICITUDPERSONASID','soli','Tpersonsolicitudeid',null,null,null,'0','0',null,'0');
insert into fentity values ('TSOLICITUDPERSONAS','soli','Tpersonsolicitude',null,null,null,'0','0',null,'1');
insert into fentity values ('TRELACIONPRODUCTOID','soli','Tproductrelationshipid',null,null,null,'0','0',null,'0');
insert into fentity values ('TRELACIONPRODUCTO','soli','Tproductrelationship',null,null,null,'0','0',null,'1');
insert into fentity values ('TSOLICITUDTABLACUOTAS','soli','Tsolicitudequotetable',null,null,null,'0','0',null,'1');
insert into fentity values ('TPRODUCTOLIQUIDACION','soli','Tproductliquidation',null,null,null,'0','0',null,'1');
insert into fentity values ('TSOLICITUDLIQUIDACION','soli','Tsolicitudeliquidation',null,null,null,'0','0',null,'1');
insert into fentity values ('TSOLICITUDADEBITAR','soli','Tsolicitudedebitaccount',null,null,null,'0','0',null,'1');
insert into fentity values ('TSOLICITUDACREDITAR','soli','Tsolicitudecreditaccount',null,null,null,'0','0',null,'1');




--Solicitud colocaciones
insert into fentity values ('TSOLICITUDCOLOCACIONES','soli.loan','Tloansolicitude',null,null,null,'0','0',null,'1');

--Personas
insert into fentity values ('TPERSONA','person','Tperson',null,null,null,'0','0',null,'1');
insert into fentity values ('TPERSONADIRECCIONESID','person','Tpersonaddressid',null,null,null,'0','0',null,'0');
insert into fentity values ('TPERSONADIRECCIONES','person','Tpersonaddress',null,null,null,'0','0',null,'1');

--Personas naturales
insert into fentity values ('TNATURALINFORMACIONBASICA','person.natural','Tnaturalbasicinformation',null,null,null,'0','0',null,'1');