-- Deleting TCAMPOSCONSULTABLES... delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCOMPROBANTESCONTABLESDETALLE'); -- Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TCOMPROBANTESCONTABLESDETALLE'; -- Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(553003,'TCOMPROBANTESCONTABLESDETALLE','CCONCEPTO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(553004,'TCOMPROBANTESCONTABLESDETALLE','CCUENTA',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(553006,'TCOMPROBANTESCONTABLESDETALLE','CMONEDA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(553007,'TCOMPROBANTESCONTABLESDETALLE','CODIGOCONTABLE',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(553009,'TCOMPROBANTESCONTABLESDETALLE','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(553011,'TCOMPROBANTESCONTABLESDETALLE','DEBITOCREDITO',5,null,null,'T','1','0','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(553012,'TCOMPROBANTESCONTABLESDETALLE','DESCRIPCIONADICIONAL',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(500)',500,0,'0'); insert into tCamposConsultablesId values(553013,'TCOMPROBANTESCONTABLESDETALLE','FDESDE',5,null,null,'S','0','0','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(553014,'TCOMPROBANTESCONTABLESDETALLE','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(553015,'TCOMPROBANTESCONTABLESDETALLE','NUMEROCOMPROBANTE',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(12)',12,0,'0'); insert into tCamposConsultablesId values(553016,'TCOMPROBANTESCONTABLESDETALLE','SCOMPROBANTECONTABLE',5,null,null,'N','0','1','0',null,'1','0',null,'1','C','SCOMPROBANTECONTABLE','0','NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(553017,'TCOMPROBANTESCONTABLESDETALLE','TIPODECAMBIO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(553018,'TCOMPROBANTESCONTABLESDETALLE','VALORMONEDAEXTRANJERA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(553019,'TCOMPROBANTESCONTABLESDETALLE','VALORMONEDAOFICIAL',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(553028,'TCOMPROBANTESCONTABLESDETALLE','COFICINA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(553029,'TCOMPROBANTESCONTABLESDETALLE','CSUCURSAL',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(553030,'TCOMPROBANTESCONTABLESDETALLE','SUBCUENTA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(553031,'TCOMPROBANTESCONTABLESDETALLE','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(553032,'TCOMPROBANTESCONTABLESDETALLE','CAREA',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); -- Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553003,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 concepto de debito o credito'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553004,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 de una subcuenta'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553006,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 del movimiento contable'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553007,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'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553009,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553011,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'),'Marca si aplica a D Debito, C Credito'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553012,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'),'Descripcion adicional del movimiento contable'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553013,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 la informacion del movimiento del comprobante contable'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553014,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 la informacion del movimiento del comprobante contable'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553015,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 del comprobante'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553016,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 detalle del comprobante '); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553017,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 del tipo de cambio aplicado al movimiento contable'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553018,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 del movimiento contable en moneda extranjera'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553019,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 del movimiento contable en la moneda oficial'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553028,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 oficina'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553029,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553030,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 subcuenta'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553031,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',553032,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 area: cre = credito, ope=operaciones, etc'); commit; -- Done.