-- Deleting TCAMPOSCONSULTABLES... delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCATEGORIASDETALLE'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTARIFARIOCUENTA'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTARIFARIOGENERAL'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTARIFARIOPRODUCTO'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTARIFARIOSUCURSAL'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTRANSACCIONRUBROSDEFINICION'); -- Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TCATEGORIASDETALLE'; delete from tCamposConsultablesId where tablabase='TTARIFARIOCUENTA'; delete from tCamposConsultablesId where tablabase='TTARIFARIOGENERAL'; delete from tCamposConsultablesId where tablabase='TTARIFARIOPRODUCTO'; delete from tCamposConsultablesId where tablabase='TTARIFARIOSUCURSAL'; delete from tCamposConsultablesId where tablabase='TTRANSACCIONRUBROSDEFINICION'; -- Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(2551001,'TTARIFARIOCUENTA','CCANAL',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2551002,'TTARIFARIOCUENTA','CCUENTA',5,null,null,'T','0','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2551003,'TTARIFARIOCUENTA','CMONEDA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2551004,'TTARIFARIOCUENTA','COBROMAXIMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2551005,'TTARIFARIOCUENTA','COBROMINIMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2551006,'TTARIFARIOCUENTA','COMANDO',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(200)',200,0,'0'); insert into tCamposConsultablesId values(2551007,'TTARIFARIOCUENTA','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2551008,'TTARIFARIOCUENTA','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2551009,'TTARIFARIOCUENTA','CTRANSACCION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2551010,'TTARIFARIOCUENTA','FDESDE',5,null,null,'S','0','0','1','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2551011,'TTARIFARIOCUENTA','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2551012,'TTARIFARIOCUENTA','MONTOMAXIMO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2551013,'TTARIFARIOCUENTA','MONTOMINIMO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2551014,'TTARIFARIOCUENTA','PORCENTAJE',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2551015,'TTARIFARIOCUENTA','RUBRO',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2551016,'TTARIFARIOCUENTA','TASA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2551017,'TTARIFARIOCUENTA','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2551018,'TTARIFARIOCUENTA','VERSIONTRANSACCION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2551019,'TTARIFARIOCUENTA','CESTATUSCUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2551022,'TTARIFARIOCUENTA','SECUENCIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0'); insert into tCamposConsultablesId values(2551023,'TTARIFARIOCUENTA','CSUBSISTEMA_CUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2551024,'TTARIFARIOCUENTA','TIPOCOMANDO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2551025,'TTARIFARIOCUENTA','VALORADICIONAL',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2552001,'TTARIFARIOGENERAL','CCANAL',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2552002,'TTARIFARIOGENERAL','CMONEDA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2552003,'TTARIFARIOGENERAL','COBROMAXIMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2552004,'TTARIFARIOGENERAL','COBROMINIMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2552005,'TTARIFARIOGENERAL','COMANDO',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(200)',200,0,'0'); insert into tCamposConsultablesId values(2552006,'TTARIFARIOGENERAL','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2552007,'TTARIFARIOGENERAL','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2552008,'TTARIFARIOGENERAL','CTARIFARIO',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2552009,'TTARIFARIOGENERAL','CTRANSACCION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2552010,'TTARIFARIOGENERAL','FDESDE',5,null,null,'S','0','0','1','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2552011,'TTARIFARIOGENERAL','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2552012,'TTARIFARIOGENERAL','MONTOMAXIMO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2552013,'TTARIFARIOGENERAL','MONTOMINIMO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2552014,'TTARIFARIOGENERAL','PORCENTAJE',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2552015,'TTARIFARIOGENERAL','RUBRO',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2552016,'TTARIFARIOGENERAL','SECUENCIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0'); insert into tCamposConsultablesId values(2552017,'TTARIFARIOGENERAL','TASA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2552018,'TTARIFARIOGENERAL','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2552019,'TTARIFARIOGENERAL','VERSIONTRANSACCION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2552020,'TTARIFARIOGENERAL','CESTATUSCUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2552021,'TTARIFARIOGENERAL','CSUBSISTEMA_CUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2552022,'TTARIFARIOGENERAL','TIPOCOMANDO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2552023,'TTARIFARIOGENERAL','VALORADICIONAL',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2554001,'TTARIFARIOPRODUCTO','CCANAL',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2554002,'TTARIFARIOPRODUCTO','CGRUPOPRODUCTO',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2554003,'TTARIFARIOPRODUCTO','CMONEDA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2554004,'TTARIFARIOPRODUCTO','COBROMAXIMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2554005,'TTARIFARIOPRODUCTO','COBROMINIMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2554006,'TTARIFARIOPRODUCTO','COMANDO',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(200)',200,0,'0'); insert into tCamposConsultablesId values(2554007,'TTARIFARIOPRODUCTO','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2554008,'TTARIFARIOPRODUCTO','CPRODUCTO',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2554009,'TTARIFARIOPRODUCTO','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2554010,'TTARIFARIOPRODUCTO','CTRANSACCION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2554011,'TTARIFARIOPRODUCTO','FDESDE',5,null,null,'S','0','0','1','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2554012,'TTARIFARIOPRODUCTO','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2554013,'TTARIFARIOPRODUCTO','MONTOMAXIMO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2554014,'TTARIFARIOPRODUCTO','MONTOMINIMO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2554015,'TTARIFARIOPRODUCTO','PORCENTAJE',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2554016,'TTARIFARIOPRODUCTO','RUBRO',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2554017,'TTARIFARIOPRODUCTO','SECUENCIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0'); insert into tCamposConsultablesId values(2554018,'TTARIFARIOPRODUCTO','TASA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2554019,'TTARIFARIOPRODUCTO','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2554020,'TTARIFARIOPRODUCTO','VERSIONTRANSACCION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2554021,'TTARIFARIOPRODUCTO','CESTATUSCUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2554022,'TTARIFARIOPRODUCTO','CSUBSISTEMA_CUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2554023,'TTARIFARIOPRODUCTO','TIPOCOMANDO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2554024,'TTARIFARIOPRODUCTO','VALORADICIONAL',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2555001,'TTARIFARIOSUCURSAL','CCANAL',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2555002,'TTARIFARIOSUCURSAL','CMONEDA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2555003,'TTARIFARIOSUCURSAL','COBROMAXIMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2555004,'TTARIFARIOSUCURSAL','COBROMINIMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2555005,'TTARIFARIOSUCURSAL','COMANDO',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(120)',120,0,'0'); insert into tCamposConsultablesId values(2555006,'TTARIFARIOSUCURSAL','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2555007,'TTARIFARIOSUCURSAL','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2555008,'TTARIFARIOSUCURSAL','CSUCURSAL',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2555009,'TTARIFARIOSUCURSAL','CTRANSACCION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2555010,'TTARIFARIOSUCURSAL','FDESDE',5,null,null,'S','0','0','1','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2555011,'TTARIFARIOSUCURSAL','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2555012,'TTARIFARIOSUCURSAL','MONTOMAXIMO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2555013,'TTARIFARIOSUCURSAL','MONTOMINIMO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,null,'NUMBER(19,7)',19,7,'0'); insert into tCamposConsultablesId values(2555014,'TTARIFARIOSUCURSAL','PORCENTAJE',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2555015,'TTARIFARIOSUCURSAL','RUBRO',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2555016,'TTARIFARIOSUCURSAL','SECUENCIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0'); insert into tCamposConsultablesId values(2555017,'TTARIFARIOSUCURSAL','TASA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2555018,'TTARIFARIOSUCURSAL','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2555019,'TTARIFARIOSUCURSAL','VERSIONTRANSACCION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2555020,'TTARIFARIOSUCURSAL','CESTATUSCUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2555021,'TTARIFARIOSUCURSAL','CSUBSISTEMA_CUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2555022,'TTARIFARIOSUCURSAL','TIPOCOMANDO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2555023,'TTARIFARIOSUCURSAL','VALORADICIONAL',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2560001,'TTRANSACCIONRUBROSDEFINICION','AFECTACAJAMULTIPLE',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560002,'TTRANSACCIONRUBROSDEFINICION','CATEGORIA',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2560003,'TTRANSACCIONRUBROSDEFINICION','CCODIGOPLANTILLA',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2560004,'TTRANSACCIONRUBROSDEFINICION','CCONCEPTO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2560006,'TTRANSACCIONRUBROSDEFINICION','CGRUPOBALANCE',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2560007,'TTRANSACCIONRUBROSDEFINICION','CPERSONA_COMPANIA',5,null,null,'N','0','0','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2560008,'TTRANSACCIONRUBROSDEFINICION','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2560009,'TTRANSACCIONRUBROSDEFINICION','CTRANSACCION',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2560010,'TTRANSACCIONRUBROSDEFINICION','DEBITOCREDITO',5,null,null,'T','0','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560011,'TTRANSACCIONRUBROSDEFINICION','GENERAMOVIMIENTO',5,null,null,'T','1','0','0','1','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560012,'TTRANSACCIONRUBROSDEFINICION','GENERASOBREGIRO',5,null,null,'T','1','0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560013,'TTRANSACCIONRUBROSDEFINICION','OCULTAESTADODECUENTA',5,null,null,'T','1','0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560014,'TTRANSACCIONRUBROSDEFINICION','RUBRO',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2560015,'TTRANSACCIONRUBROSDEFINICION','RUBRO_PADRE',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2560016,'TTRANSACCIONRUBROSDEFINICION','RUBRO_PAR',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2560017,'TTRANSACCIONRUBROSDEFINICION','TIENETARIFARIO',5,null,null,'T','0','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560018,'TTRANSACCIONRUBROSDEFINICION','USACACHE',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560020,'TTRANSACCIONRUBROSDEFINICION','VERSIONCONTROL',5,null,null,'N','0','0','1','0','0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2560021,'TTRANSACCIONRUBROSDEFINICION','VERSIONTRANSACCION',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2560023,'TTRANSACCIONRUBROSDEFINICION','CALCULAIMPUESTO',5,null,null,'T','1','0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560024,'TTRANSACCIONRUBROSDEFINICION','CALCULAINTERESCOMISION',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560025,'TTRANSACCIONRUBROSDEFINICION','CESTATUSCUENTA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2560026,'TTRANSACCIONRUBROSDEFINICION','RUBRO_ASOCIADO',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2560027,'TTRANSACCIONRUBROSDEFINICION','GENERAINTERSUCURSAL',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2560028,'TTRANSACCIONRUBROSDEFINICION','AJUSTEPORDECIMALES',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582004,'TCATEGORIASDETALLE','CGRUPOBALANCE',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2582005,'TCATEGORIASDETALLE','CESTRUCTURACUENTA',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(2582007,'TCATEGORIASDETALLE','CATEGORIA',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2582008,'TCATEGORIASDETALLE','ACTUALIZASALDOFECHAVALOR',5,null,null,'T','1','0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582009,'TCATEGORIASDETALLE','ACTUALIZASALDOENLINEA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582010,'TCATEGORIASDETALLE','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2582011,'TCATEGORIASDETALLE','USACACHE',5,null,null,'T','1','0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582012,'TCATEGORIASDETALLE','PROVISIONA',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582013,'TCATEGORIASDETALLE','PRINCIPAL',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582016,'TCATEGORIASDETALLE','CTIPOCATEGORIA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(2582017,'TCATEGORIASDETALLE','CTIPOSALDOCATEGORIA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2582018,'TCATEGORIASDETALLE','EFECTIVO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582021,'TCATEGORIASDETALLE','CAGRUPACIONCONTABLE_AUTOMATICA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2582022,'TCATEGORIASDETALLE','CESTATUSCUENTA_AUTOMATICA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2582025,'TCATEGORIASDETALLE','CSUBSISTEMA_CUENTAAUTOMATICA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2582028,'TCATEGORIASDETALLE','COMANDO_CUENTAAUTOMATICA',5,null,null,'T','0','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(40)',40,0,'0'); insert into tCamposConsultablesId values(2582029,'TCATEGORIASDETALLE','PERMITESALDONEGATIVO',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582030,'TCATEGORIASDETALLE','SUBCUENTAGENERAL',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582031,'TCATEGORIASDETALLE','REGISTRAENSALDOS',5,null,null,'T',null,'0','1','1','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582032,'TCATEGORIASDETALLE','NOCIERREEJERCICIO',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2582033,'TCATEGORIASDETALLE','CODIGOCONTABLE',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2582034,'TCATEGORIASDETALLE','NUMERODECIMALES',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); -- Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables values('ES',2551001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de canal'); insert into tCamposConsultables values('ES',2551002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Numero de cuenta'); insert into tCamposConsultables values('ES',2551003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de moneda'); insert into tCamposConsultables values('ES',2551004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto maximo de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2551005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto minimo de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2551006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Comando especial para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2551007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania a la que pertenece la cuenta, puede ser externa o compania licenciada'); insert into tCamposConsultables values('ES',2551008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del subsistema'); insert into tCamposConsultables values('ES',2551009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la transaccion'); insert into tCamposConsultables values('ES',2551010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha desde la que esta vigente un tarifario por cuenta'); insert into tCamposConsultables values('ES',2551011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha hasta la que esta vigente un tarifario.'); insert into tCamposConsultables values('ES',2551012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto maximo establecido a la base de calculo del tarifario.'); insert into tCamposConsultables values('ES',2551013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto minimo establecido a la base de calculo del tarifario.'); insert into tCamposConsultables values('ES',2551014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Porcentaje flat aplicado para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2551015,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia de rubro dentro de la transaccion.'); insert into tCamposConsultables values('ES',2551016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Tasa anual aplicada para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2551017,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic loking'); insert into tCamposConsultables values('ES',2551018,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de la transaccion'); insert into tCamposConsultables values('ES',2551019,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de estatus de cuenta'); insert into tCamposConsultables values('ES',2551022,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia del tarifario por cuenta '); insert into tCamposConsultables values('ES',2551023,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de subsistema de la cuenta'); insert into tCamposConsultables values('ES',2551024,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de tipo de Comando MAN mantenimiento , CON Consulta'); insert into tCamposConsultables values('ES',2551025,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Valor adicional de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2552001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de canal'); insert into tCamposConsultables values('ES',2552002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de moneda'); insert into tCamposConsultables values('ES',2552003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto maximo de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2552004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto minimo de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2552005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Comando especial para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2552006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania'); insert into tCamposConsultables values('ES',2552007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del subsistema'); insert into tCamposConsultables values('ES',2552008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de tarifario'); insert into tCamposConsultables values('ES',2552009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la transaccion'); insert into tCamposConsultables values('ES',2552010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha desde la que esta vigente un tarifario general'); insert into tCamposConsultables values('ES',2552011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha hasta la que esta vigente un tarifario general'); insert into tCamposConsultables values('ES',2552012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto maximo establecido a la base de calculo del tarifario.'); insert into tCamposConsultables values('ES',2552013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto minimo establecido a la base de calculo del tarifario.'); insert into tCamposConsultables values('ES',2552014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Porcentaje flat aplicado para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2552015,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia de rubro dentro de la transaccion.'); insert into tCamposConsultables values('ES',2552016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia tarifario producto.'); insert into tCamposConsultables values('ES',2552017,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Tasa aplicada para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2552018,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic loking'); insert into tCamposConsultables values('ES',2552019,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de la transaccion'); insert into tCamposConsultables values('ES',2552020,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de estatus de cuenta'); insert into tCamposConsultables values('ES',2552021,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de subsistema de la cuenta'); insert into tCamposConsultables values('ES',2552022,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de tipo de Comando MAN mantenimiento , CON Consulta'); insert into tCamposConsultables values('ES',2552023,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Valor adicional de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2554001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de canal'); insert into tCamposConsultables values('ES',2554002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del grupo de productos'); insert into tCamposConsultables values('ES',2554003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de moneda'); insert into tCamposConsultables values('ES',2554004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto maximo de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2554005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto minimo de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2554006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Comando especial para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2554007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania'); insert into tCamposConsultables values('ES',2554008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del producto'); insert into tCamposConsultables values('ES',2554009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del subsistema'); insert into tCamposConsultables values('ES',2554010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la transaccion'); insert into tCamposConsultables values('ES',2554011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha desde la que esta vigente un tarifario de producto'); insert into tCamposConsultables values('ES',2554012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha hasta la que esta vigente un tarifario de producto'); insert into tCamposConsultables values('ES',2554013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto maximo establecido a la base de calculo del tarifario.'); insert into tCamposConsultables values('ES',2554014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto minimo establecido a la base de calculo del tarifario.'); insert into tCamposConsultables values('ES',2554015,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Porcentaje flat aplicado para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2554016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia de rubro dentro de la transaccion.'); insert into tCamposConsultables values('ES',2554017,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia tarifario producto.'); insert into tCamposConsultables values('ES',2554018,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Tasa aplicada para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2554019,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic loking'); insert into tCamposConsultables values('ES',2554020,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de la transaccion'); insert into tCamposConsultables values('ES',2554021,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de estatus de cuenta'); insert into tCamposConsultables values('ES',2554022,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de subsistema de la cuenta'); insert into tCamposConsultables values('ES',2554023,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de tipo de Comando MAN mantenimiento , CON Consulta'); insert into tCamposConsultables values('ES',2554024,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Valor adicional de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2555001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de canal'); insert into tCamposConsultables values('ES',2555002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de moneda'); insert into tCamposConsultables values('ES',2555003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto maximo de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2555004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto minimo de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2555005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Comando especial para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2555006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania'); insert into tCamposConsultables values('ES',2555007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del subsistema'); insert into tCamposConsultables values('ES',2555008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la sucursal'); insert into tCamposConsultables values('ES',2555009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la transaccion'); insert into tCamposConsultables values('ES',2555010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha desde la que esta vigente un tarifario de producto'); insert into tCamposConsultables values('ES',2555011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha hasta la que esta vigente un tarifario de producto'); insert into tCamposConsultables values('ES',2555012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto maximo establecido a la base de calculo del tarifario.'); insert into tCamposConsultables values('ES',2555013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto minimo establecido a la base de calculo del tarifario.'); insert into tCamposConsultables values('ES',2555014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Porcentaje flat aplicado para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2555015,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia de rubro dentro de la transaccion.'); insert into tCamposConsultables values('ES',2555016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia tarifario producto.'); insert into tCamposConsultables values('ES',2555017,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Tasa aplicada para el calculo del tarifario.'); insert into tCamposConsultables values('ES',2555018,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic loking'); insert into tCamposConsultables values('ES',2555019,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de la transaccion'); insert into tCamposConsultables values('ES',2555020,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de estatus de cuenta'); insert into tCamposConsultables values('ES',2555021,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de subsistema de la cuenta'); insert into tCamposConsultables values('ES',2555022,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de tipo de Comando MAN mantenimiento , CON Consulta'); insert into tCamposConsultables values('ES',2555023,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Valor adicional de cobro aplicado al tarifario.'); insert into tCamposConsultables values('ES',2560001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el rubro afecta o no los saldos de caja multiple'); insert into tCamposConsultables values('ES',2560002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de categoria. '); insert into tCamposConsultables values('ES',2560003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de plantilla de cuentas por cobrar'); insert into tCamposConsultables values('ES',2560004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de concepto credito. '); insert into tCamposConsultables values('ES',2560006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del grupo de balance'); insert into tCamposConsultables values('ES',2560007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania. '); insert into tCamposConsultables values('ES',2560008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del subsistema'); insert into tCamposConsultables values('ES',2560009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la transaccion'); insert into tCamposConsultables values('ES',2560010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de concepto debito.'); insert into tCamposConsultables values('ES',2560011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el rubro genera movimiento y actualiza saldos de la cuenta. '); insert into tCamposConsultables values('ES',2560012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el rubro genera un sobregiro indirecto automaticamente. '); insert into tCamposConsultables values('ES',2560013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el movimiento se oculta en el estado de cuenta.'); insert into tCamposConsultables values('ES',2560014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia de rubro dentro de la transaccion.'); insert into tCamposConsultables values('ES',2560015,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia de subro padre para calcular impuestos cargos comisiones.'); insert into tCamposConsultables values('ES',2560016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de rubro que arma el par contable.'); insert into tCamposConsultables values('ES',2560017,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el rubro calcula valores de impuestos, cargos o comisiones'); insert into tCamposConsultables values('ES',2560018,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si la el registro se almacena en cache utilizado en transacciones utilizadas frecuentemente.'); insert into tCamposConsultables values('ES',2560020,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic locking.'); insert into tCamposConsultables values('ES',2560021,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de la transaccion'); insert into tCamposConsultables values('ES',2560023,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el rubro es un impuesto para enviar el calculo del valor no cobrado a cuentas por cobrar'); insert into tCamposConsultables values('ES',2560024,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si se toma la categoria grupo de balance para el calculo de intereses y/o comisiones'); insert into tCamposConsultables values('ES',2560025,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de estatus contable de cuenta'); insert into tCamposConsultables values('ES',2560026,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de rubro que se dispara automaticamente especialmente para registrar cuentas de orden o contingeneres'); insert into tCamposConsultables values('ES',2560027,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si la cetagoria genera movimiento intersucursales o no'); insert into tCamposConsultables values('ES',2560028,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el rubro genera o no el valor de la diferencia del comprobante contable por ajuste de decimales.'); insert into tCamposConsultables values('ES',2582004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del grupo de balance'); insert into tCamposConsultables values('ES',2582005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de estructura de la cuenta'); insert into tCamposConsultables values('ES',2582007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de categoria. '); insert into tCamposConsultables values('ES',2582008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si la categoria lleva saldos fecha valor'); insert into tCamposConsultables values('ES',2582009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'indica si la categoria actuliza saldo con cada movimiento o lo hace en batch'); insert into tCamposConsultables values('ES',2582010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania de la categoria.'); insert into tCamposConsultables values('ES',2582011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el registro se almacena en cache utilizado en transacciones utilizadas frecuentemente.'); insert into tCamposConsultables values('ES',2582012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si la categoria genera provision de intereses o no'); insert into tCamposConsultables values('ES',2582013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el saldo de la cuenta se obtiene de esta categoria grupo balance'); insert into tCamposConsultables values('ES',2582016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de tipo de categoria hasta la fecha de vencimiento de la cuota anual'); insert into tCamposConsultables values('ES',2582017,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del tipo de saldo de la categoria SAL (Saldos de cuentas), ACC (provisiones)'); insert into tCamposConsultables values('ES',2582018,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si es la categoria del efectivo de caja, se utiliza para identificarla en el cuadre de caja y en el control de lavado de dinero'); insert into tCamposConsultables values('ES',2582021,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de agrupacion contable para generar cuentas automaticas.'); insert into tCamposConsultables values('ES',2582022,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Estatus default de una cuenta automatica. '); insert into tCamposConsultables values('ES',2582025,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de subsistema de cuentas automaticas. '); insert into tCamposConsultables values('ES',2582028,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Comando para la obtencion de la agrupacion contable de cuenta automatica'); insert into tCamposConsultables values('ES',2582029,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si la categoria permite saldos negativos o no '); insert into tCamposConsultables values('ES',2582030,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si la categoria utiliza solo la subcuenta general especialmente para la cuenta transitoria de plazo fijo y colocaciones'); insert into tCamposConsultables values('ES',2582031,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Identifica si la categoria contable de la cuota lleva el saldo adeudado o solo el cobrado en la tabla de saldos'); insert into tCamposConsultables values('ES',2582032,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si la categoiria contable no participa en el cierre del ejercicio contable o participa dependiendo de lo que determina el grupo de balance'); insert into tCamposConsultables values('ES',2582033,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo contable de la categoria'); insert into tCamposConsultables values('ES',2582034,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Numero de decimales que maneja la categoria contable, si la categoria no tiene definida un numero de decimales, se tomara el numero de decimales de la moneda.'); commit; -- Done.