package m05bClasses;


/**
 * Fecha de creación: (17-11-2003)
 */

public class m05bConstantes {
	
	public static final String CODIGO_APLICACION = "M05B";
	
	//PAGINACION
	public static final int PAGINACION_NUMREG_PAGINA	=	10;
	
	// ASIGNACIONES
	public static final String ASIG_PERMANENTE			= 	"S";
	
	// PERSONAL
	public static final String PERS_NOEXISTE			= 	"0";
	public static final String PERS_ACTUALIZABLE		= 	"1";
	public static final String PERS_NOACTUALIZABLE		= 	"2";
	
	// OPERACIONES BANCOS
	public static final String GASTO_PEAJE				= 	"P";
	
	// ITV
	public static final String ITV_NUEVA_ESTADO		= 	"EFECTUADA";
	public static final String ITV_NUEVA_RESULTADO	= 	"FAVORABLE";
	public static final String ITV_PENDIENTE_ESTADO		= "PENDIENTE";
	
	
	// TARJETAS
	public static final String TAR_CANCELADA			= 	"C";
	public static final String TAR_SOLICITADA			= 	"S";
	public static final String TAR_ALTA			        = 	"A";
	public static final String TAR_ABONO				= 	"A";
	public static final String TAR_LIMITE				= 	"605";
	public static final String TAR_VIAT    			    = 	"V";
	public static final String TAR_GASTO    			= 	"G";
	// SEGUROS
	public static final String SEG_CANCELADA			= 	"C";
	public static final String SEG_SOLICITADA			= 	"S";
	public static final String SEG_ALTA			        = 	"A";
	
	
	// VEHICULOS
	public static final String VEH_BAJA					= 	"B";
	public static final String VEH_ALTA					= 	"A";
	public static final String VEH_TODOS				= 	"";
	public static final String VEH_UBI_ASIGNACION		= 	"A";
	public static final String VEH_UBI_ORDENTRAB		= 	"OT";
	public static final String VEH_REG_RENTING			= 	"RENTING";
	public static final String VEH_REG_COMPRA			= 	"COMPRA";
	public static final String VEH_PENDIENTE			= 	"P";
	public static final String VEH_OTRO					= 	"O";
	
	// REVISIONES
	public static final String REV_BAJAVEH				= 	"ALTA DE VEHICULO";
	public static final String REV_PRX_DIAS				=   "14";
	public static final String REV_PRX_KM				=   "500";
	public static final String REV_REALIZADA			=   "S";
	public static final String REV_NOREALIZADA			=   "N";
	
	// ACCIONES
	public static final String ACC_ELIMINAR				= 	"E";
	public static final String ACC_INSERTAR				= 	"I";
	public static final String ACC_ACTUALIZAR			= 	"U";
	public static final String ACC_REVOCAR				= 	"R";
	
    //RESPONSABILIDAD 
    public static final String RESP_PROPIA              =   "P";
    public static final String RESP_AJENA               =   "A";
    
	// SANCIONES
	public static final String SAN_SANCION				= 	"2";
	public static final String SAN_DENUNCIA				=   "1";
	public static final String SAN_RESOLUCION			=   "3";
	public static final String SAN_APREMIO				=   "4";
	
	// TASAS
	public static final String TAS_OBLIG				= 	"2";
	
	// ORDENES TRABAJO
	public static final String OT_TALLER_PROPIO			= 	"0034";

	// RECUPERAR LISTADOS
	public static final String LST_TAR_SOLICITADAS		= 	"TS";
	public static final String LST_TAR_CANCELADAS		= 	"TC";
	public static final String LST_SEG_SOLICITADAS		= 	"SS";
	public static final String LST_SEG_CANCELADAS		= 	"SC";
	public static final String LST_ASIG_ACTADEV			= 	"DV";
	public static final String LST_ASIG_ACTADEC			= 	"DC";
	public static final String LST_TARJ_CAMBIO			= 	"CT";
	 
	//        -------------------------   VARIAS              -------------------------

	public static final String GRUPO_CTK_A				= 	"A";
	public static final String GRUPO_CTK_B				= 	"B";
	public static final String GRUPO_CTK_C				= 	"C";
	public static final String GRUPO_CTK_D				= 	"D";
	public static final String GRUPO_CTK_RA				= 	"RA";
	public static final String GRUPO_CTK_RB 			=   "RB";

	public static final String VERIFICADO_NO			= 	"N";
	public static final String VERIFICADO_SI			= 	"S";
	
	public static final String 	CPTO_COMBUSTIBLE		= 	"C";
	
	
	public static final String O75_RESULTADO_OK			= 	"0";
	public static final String O75_ERR_NO_FICH			= 	"15";
	
	public static final int ERR_INTEGRIDAD			    = 	2292;
	public static final int ERR_DUPLICADOS			    = 	1;
	
	public static final String CMB_CARGATODOS			= 	"***";
	
	public static final String MSG_OK					= 	"true";
	public static final String MSG_FALSE				= 	"false";
	public static final String MSG_NODATOS				= 	"NoDatos";
	public static final String MSG_EXISTE				= 	"Existe";
	public static final String MSG_EXISTEDPTOREL		= 	"ExisteDptoRel";
	public static final String MSG_EXISTETRANS			= 	"ExisteTrans";
	public static final String MSG_EXISTEAMOR			= 	"ExisteAmor";
	public static final String MSG_INTEGRIDAD			= 	"Integridad";
	public static final String MSG_NOEXISTESEGURO		= 	"NoExSeguro";
	public static final String MSG_NOEXISTETARJETA		= 	"NoExTarjeta";
	public static final String MSG_NOEXISTEDNI			= 	"NoExPersona";
	public static final String MSG_EXISTEBASTIDOR		= 	"ExisteNSerie";
	public static final String MSG_EXISTEBASTIDOR2		= 	"ExisteNSerieE";
	public static final String MSG_EXISTETASA		    = 	"ExisteTasa";
	public static final String MSG_EXISTEVEHICULO		= 	"ExisteVehiculo";
	public static final String MSG_GRABACION_OK		    = 	"GrabarOk";
	public static final String PARAM_NOUSADO			= 	"Z";
	public static final String MSG_NOEXISTETALL		    = 	"NoExTall";
	public static final String MSG_NOEXISTECENTRO	    = 	"NoExCentro";
	public static final String MSG_ERRORENFIRMA	    	= 	"ErrorEnFirma";
	public static final String MSG_ERRORNOEXISTEFICHERO	= 	"ErrorNoExisteFichero";
	public static final String MSG_ERRORNOEXISTENDATOSFIRMA = "ErrorNoExistenDatosFirma";
	public static final String MSG_ELIMINAROK	    	= 	"EliminarOk";
	public static final String MSG_ASIGPEND	    	= 	"AsigPendien"; //	Agurtzane Feb12: avisar si más asignaciones
	public static final String 	LOG_NO_USER				= 	"";
	public static final String 	LOG_NO_SRC				= 	"";
	public static final int 	LOG_NIVEL_ALTO		    = 	1;
	public static final int 	LOG_NIVEL_MEDIO		    = 	2;
	public static final int 	LOG_NIVEL_BAJO		    = 	3;
	
	public static final String MSG_ERRORBD		        = 	"ErrorBd";
	

	
	// BASE DE DATOS
		
	// DESCRIPCIONES
		
	public static final String DESC_COLORES				= 	"1";
	public static final String DESC_CONCEPTOSGASTOS		= 	"2";
	public static final String DESC_CONCEPTOSTASAS		= 	"3";
	public static final String DESC_DESTINOSBAJA		= 	"4";
	public static final String DESC_ESTACIONESITV		= 	"5";
	public static final String DESC_MARCAS				= 	"7";
	public static final String DESC_MODALIDADES			= 	"8";
	public static final String DESC_SITUACIONES			= 	"9";
	public static final String DESC_INCIDENCIAS			= 	"10";
	public static final String DESC_RANGOS				= 	"11";
	public static final String DESC_UBICACIONES			= 	"12";
	public static final String DESC_REGADQUISICION		= 	"13";
	public static final String DESC_SIT_TARJETAS		= 	"14";
	public static final String DESC_RAMAS				= 	"15";
	public static final String DESC_ESTADO_SEGUROS		= 	"16";
	public static final String DESC_TIPOS_SANCION		= 	"17";
	public static final String DESC_RESPONSABILIDAD		= 	"18";
	public static final String DESC_GRUPOS				= 	"19";
	
	

	// TABLAS
    public static final String TAB_ASIGNACION           =   "M0501T00";
    public static final String TAB_AVISOS		        =   "M0502T00";
    public static final String TAB_CARGOS               =   "M0504T00";
    public static final String TAB_BANCOS               =   "M0503T00";
    public static final String TAB_CENTROS              =   "M0505T00";
    public static final String TAB_DEPARTAMENTOS   		=   "M0506T00";
    public static final String TAB_DESTINOS  	  		=   "M05104T00"; //Agurtzane Ene12: mantenimiento destinos
    public static final String TAB_EMPTALLER            =   "M0507T00";
    public static final String TAB_FESTIVOS             =   "M0508T00";
    public static final String TAB_GASTOS               =   "M0509T00";
    public static final String TAB_HIST_CENTROS         =   "M0510T00";
    public static final String TAB_HIST_DPTOS	        =   "M0511T00";
    public static final String TAB_HIST_PERSONAL        =   "M0512T00";
    public static final String TAB_HIST_SEGUROS         =   "M0513T00";
    public static final String TAB_HIST_TARJETAS        =   "M0514T00";
    public static final String TAB_KUTXAK		        =   "M0516T00";
    public static final String TAB_MODELOS              =   "M0517T00";
    public static final String TAB_OPEBANCOS            =   "M0518T00";
    public static final String TAB_ORDEREPAR            =   "M0519T00";
    public static final String TAB_ORDENESTRAB          =   "M0520T00";
    public static final String TAB_PERSONAL             =   "M0521T00";
    public static final String TAB_PIEZAS	            =   "M0522T00";
    public static final String TAB_PIEZAREP             =   "M0523T00";
    public static final String TAB_POBLACIONES          =   "M0524T00";
    public static final String TAB_REPARACIONES         =   "M0525T00";
    public static final String TAB_FIRMAS		        =   "M0526T00";
    public static final String TAB_ITV                  =   "M0527T00";
    public static final String TAB_SEGUROS              =   "M0528T00";
    public static final String TAB_SINIESTROS           =   "M0529T00";
    public static final String TAB_TALLER               =   "M0530T00";
    public static final String TAB_TARJETAS             =   "M0531T00";
    public static final String TAB_TASAS                =   "M0532T00";
    public static final String TAB_VEHICULOS            =   "M0534T00";
    public static final String TAB_REVISIONES           =   "M0535T00";
    public static final String TAB_GRUPOS	            =   "M0536T00";
    public static final String TAB_REFORMAS             =   "M0537T00";
    public static final String TAB_TIPOREFORMAS         =   "M0538T00";
    public static final String TAB_AMORTIZACION         =   "M0539T00";
    public static final String TAB_TRANSFERENCIAS       =   "M0540T00";
    public static final String TAB_CUOTAS               =   "M0541T00";
    public static final String TAB_CARGAGASTOSTARJETAS  =   "M0543T00";
    public static final String TAB_HIST_VEHICULOS       =   "M0544T00";
    public static final String TAB_SANCIONES            =   "M0545T00";
    public static final String TAB_HIST_OPEBANCOS       =   "M0546T00";
    public static final String TAB_RESTRICCIONES        =   "M0547T00";
    public static final String TAB_ORGANISMOS        	=   "M0548T00";
    public static final String TAB_TMPVEHICULOS			=   "M0590T00";
    public static final String TAB_CTK_KM				=   "M0591T00";
    public static final String TAB_TMPTOTCONSUMOLITROS  =   "M0592T00";
    public static final String TAB_TMPTOTLITROS  	    =   "M0593T00";
    public static final String TAB_CTK_COMBUSTIBLE 	    =   "M0593T00";
    public static final String TAB_TMPLSTGASTOS2	    =   "M0594T00";
	public static final String TAB_TMPLSTGASTOS			=   "M0595T00";
    public static final String TAB_COCHESLIBRES			=   "M0596T00";
    public static final String TAB_CTK					=   "M0597T00";
    public static final String TAB_DESCRIPCIONES		=   "M0599T00";

	// Tablas de la aplicacion
    public static final String COL_01_CODASIG           =   "COD_ASIG_01";
    public static final String COL_01_MATRICULA         =   "MATRIC_01";
    public static final String COL_01_FINALIZA          =   "FINALIZ_01";
    public static final String COL_01_FHASTA            =   "FHASTA_01";
    public static final String COL_01_FDESDE            =   "FDESDE_01";
    public static final String COL_01_DNI               =   "DNI_01";
    public static final String COL_01_KMSALIDA          =   "KM_SAL_01";
    public static final String COL_01_KMLLEGADA         =   "KM_LLEG_01";
    public static final String COL_01_KMRECORRIDO       =   "KM_RECOR_01";
    public static final String COL_01_DESDPTO           =   "DESDPTO_01";
    public static final String COL_01_FECHA             =   "FECHA_01";
    public static final String COL_01_FDEVOL            =   "FDEVOL_01";
    public static final String COL_01_ORDEN             =   "ORDEN_01";
    public static final String COL_01_ASIG              =   "ASIGPERM_01";
    public static final String COL_01_OBSERV            =   "OBSERV_01";
    public static final String COL_01_CODCARGO          =   "CODCARGO_01";
    public static final String COL_01_CODRANGO          =   "CODRANGO_01";
    public static final String COL_01_CODDPTO           =   "CODDPTO_01";
    public static final String COL_01_IMPRESO           =   "IMPRESO_01";
    public static final String COL_01_DECRETO           =   "DECRETO_01";
    public static final String COL_01_ENTREGA           =   "ENTREGA_01";
    public static final String COL_01_FIMPRESO          =   "FIMPRES_01";
    public static final String COL_01_FDECRETO          =   "FDECRETO_01";
    public static final String COL_01_FENTREGA          =   "FENTREGA_01";


    public static final String COL_02_MATRICULA         =   "MATRIC_02";
    public static final String COL_02_TEXTO         	=   "DESCRIP_02";
    public static final String COL_02_ASIGNACION        =   "ASIG_02";
    public static final String COL_02_OT  	        	=   "OT_02";
    public static final String COL_02_VEHICULO          =   "VEHIC_02";

    public static final String COL_03_NCUENTA           =   "NCUENTA_03";
    public static final String COL_03_NOMBRE            =   "NOMBRE_03";
    public static final String COL_03_DIRECCION         =   "DIREC_03";
    public static final String COL_03_TELEFONO          =   "TELEF_03";
    
    public static final String COL_04_CODCARGO          =   "COD_CARG_04";
    public static final String COL_04_DESCCARG          =   "DESCRIP_04";
    public static final String COL_04_EDESCCARG         =   "EDESCRIP_04";

    public static final String COL_05_CODIGO            =   "COD_CTRO_05";
    public static final String COL_05_DESC              =   "DESCRIP_05";
    
    public static final String COL_06_CODDPTO			=   "COD_DPTO_06";
    public static final String COL_06_DESCDPTO			=   "DESCRIP_06";
    public static final String COL_06_EDESCDPTO			=   "E_DESCRIP_06";
    public static final String COL_06_COD_XLNET			=   "COD_XLNET_06";
    public static final String COL_06_SIT				=   "SIT_06";

//  Agurtzane Ene12: mantenimiento destinos
    public static final String COL_104_CODDEST			=   "COD_DESTINO_104";
    public static final String COL_104_DESCDEST			=   "DESC_CAS_104";
    public static final String COL_104_EDESCDEST		=   "DESC_EUS_104";
//  Fin Agurtzane Ene12: mantenimiento destinos


    public static final String COL_07_NOMBRE            =   "NOMBRE_07";
    public static final String COL_07_CODIGO            =   "COD_EMPL_07";
    public static final String COL_07_PRECHORA          =   "PRECHORA_07";
    public static final String COL_07_ALTA              =   "ALTA_07";

    public static final String COL_08_CODIGO            =   "COD_FEST_08";
    public static final String COL_08_FECHA             =   "FFESTIVO_08";
    public static final String COL_08_DESCRIPCION       =   "DESCRIP_08";

    public static final String COL_09_CODIGO            =   "COD_GAST_09";
    public static final String COL_09_TARJETA           =   "TARJETA_09";
    public static final String COL_09_FECHA             =   "FGASTO_09";
    public static final String COL_09_LITROS            =   "LITROS_09";
    public static final String COL_09_CODCPTO           =   "CODCPTO_09";
    public static final String COL_09_ESTCIF            =   "EST_CIF_09";
    public static final String COL_09_ESTNOM            =   "EST_NCOM_09";
    public static final String COL_09_CARGO             =   "CARG_ABON_09";
    public static final String COL_09_IMPORTE           =   "IMPORTE_09";
    public static final String COL_09_MATRICULA         =   "MATRIC_09";
    public static final String COL_09_KMGASTO           =   "KM_GASTO_09";

    public static final String COL_10_MATRICULA         =   "MATRIC_10";
    public static final String COL_10_TARJETA           =   "TARJETA_10";
    public static final String COL_10_CODCTRANT         =   "CODCTRANT_10";
    public static final String COL_10_DESCTRANT         =   "DESCTRANT_10";
    public static final String COL_10_CODCTRNUE         =   "CODCTRNUE_10";
    public static final String COL_10_DESCTRNUE         =   "DESCTRNUE_10";
    public static final String COL_10_MOTIVO            =   "MOTIVO_10";
    public static final String COL_10_FCAMBIO           =   "FCAMBIO_10";

    public static final String COL_11_ID  		        =   "COD_DPTH_11";
    public static final String COL_11_CODDPTOANT        =   "CODDPTANT_11";
    public static final String COL_11_DESDPTOANT	    =   "DESDPTANT_11";
    public static final String COL_11_EDESDPTOANT       =   "E_DESDPTANT_11";
    public static final String COL_11_CODDPTONUE	    =   "CODDPTNUE_11";
    public static final String COL_11_DESDPTONUE        =   "DESDPTNUE_11";
    public static final String COL_11_EDESDPTONUE	    =   "E_DESDPTNUE_11";
    public static final String COL_11_FCAMBIO		    =   "FCAMBIO_11";
    
    public static final String COL_12_NOMBRE            =   "NOMBRE_12";
    public static final String COL_12_DNI               =   "DNI_12";
    public static final String COL_12_CODCARGO          =   "CODCARGO_12";
    public static final String COL_12_CODDPTO           =   "CODDPTO_12";
    public static final String COL_12_TELEF             =   "TELEF_12";
    public static final String COL_12_DIREC             =   "DIREC_12";
    public static final String COL_12_RANGO             =   "CODRANGO_P_12";
    public static final String COL_12_ACTUALIZA		    =   "ACT_GIP_12";   
    public static final String COL_12_ID	            =   "COD_PERH_12";
    public static final String COL_12_FCAMBIO		    =   "FCAMBIO_12";   

    public static final String COL_13_CODIGO            =   "COD_SEGH_13";
    public static final String COL_13_MATRICULA         =   "MATRIC_13";
    public static final String COL_13_CIA               =   "CIA_13";
    public static final String COL_13_FALTA             =   "FALTA_13";
    public static final String COL_13_FBAJA             =   "FBAJA_13";
    public static final String COL_13_FCADUC            =   "FCADUC_13";
    public static final String COL_13_FSOLIC            =   "FSOLIC_13";
    public static final String COL_13_ESTADO            =   "ESTADO_13";
    public static final String COL_13_IMPRESO           =   "IMPRESO_13";
    public static final String COL_13_FIMPRESION        =   "FIMPRES_13";
    public static final String COL_13_POLIZAV           =   "POLIZA_V_13";
    public static final String COL_13_IMPORTE           =   "IMPORTE_13";
    public static final String COL_13_MODAL             =   "MODAL_13";
    public static final String COL_13_POLIZA            =   "POLIZA_13";

    public static final String COL_14_TARJHIST          =   "COD_TARH_14";
    public static final String COL_14_TARJETA           =   "TARJETA_14";
    public static final String COL_14_MATRICULA         =   "MATRIC_14";
    public static final String COL_14_LIMITE            =   "LIMITE_14";
    public static final String COL_14_FALTA             =   "FALTA_14";
    public static final String COL_14_FBAJA             =   "FBAJA_14";
    public static final String COL_14_FSOLIC            =   "FSOLIC_14";
    public static final String COL_14_FEXPED            =   "FEXPED_14";
    public static final String COL_14_FCADUC            =   "FCADUC_14";
    public static final String COL_14_LITERAL           =   "LITERAL_14";
    public static final String COL_14_BANCO             =   "BANCO_14";
    public static final String COL_14_PLASTIC           =   "PLASTIC_14";
    public static final String COL_14_SITUACION         =   "SITUAC_14";
    public static final String COL_14_INCIDENCIA        =   "INCIDENC_14";
    public static final String COL_14_CTRO              =   "COD_CTRO_14";
    public static final String COL_14_TAG               =   "TAG_14";
    public static final String COL_14_TIPO             =    "TIPO_14";

    public static final String COL_16_UCONOMICA         =   "UECONOMIC_16";
    public static final String COL_16_CENTRO            =   "CENTRO_16";
    public static final String COL_16_MEGE              =   "CODMEGE_16";
    public static final String COL_16_TARJETA           =   "TARJETA_16";
    public static final String COL_16_TIPO              =   "TIPMVTO_16";
    public static final String COL_16_CONCEPTO          =   "CONCEPTO_16";
    public static final String COL_16_CIF		        =   "CIF_ESTAB_16";
    public static final String COL_16_COMERCIO          =   "NCOMER_16";    
    public static final String COL_16_DESCRIPCION       =   "DESESTAB_16";
    public static final String COL_16_FECHA		        =   "FMVTO_16";
    public static final String COL_16_HORA		        =   "HMVTO_16";
    public static final String COL_16_IMPORTE	        =   "IMP_MVTO_16";
    public static final String COL_16_CARG_ABON         =   "CARG_ABON_16";
    public static final String COL_16_MATRICULA         =   "MATRIC_16";

    public static final String COL_17_CODMOD            =   "COD_MOD_17";
    public static final String COL_17_DESCRIP           =   "DESCRIP_17";
    public static final String COL_17_CODMARCA          =   "MARCA_17";

    public static final String COL_18_TARJETA           =   "TARJETA_18";
    public static final String COL_18_TIPO              =   "TIPO_18";
    public static final String COL_18_CONCEPTO          =   "CONCEPTO_18";
    public static final String COL_18_ESTAB             =   "EST_DESCR_18";
    public static final String COL_18_FECHA             =   "FOPERAC_18";
    public static final String COL_18_IMPORTE           =   "IMPORTE_18";
    public static final String COL_18_KM                =   "KM_18";
    public static final String COL_18_LITROS            =   "LITROS_18";
    public static final String COL_18_VERIFIC           =   "VERIFIC_18";
    public static final String COL_18_CARGO             =   "CARG_ABON_18";
    public static final String COL_18_MATRICULA         =   "MATRIC_18";
    public static final String COL_18_CONTROL           =   "CTRLDUPL_18";
    public static final String COL_18_ESTCIF            =   "ESTCIF_18";
    public static final String COL_18_CENTRO            =   "CENTRO_18";
    public static final String COL_18_DPTO              =   "DPTO_18";
    public static final String COL_18_SERVICIO          =   "SERVICIO_18";
    public static final String COL_18_UECONO            =   "UECONOMIC_18";
    public static final String COL_18_NCOMERCIO         =   "EST_NCOM_18";

    public static final String COL_19_CODIGO            =   "COD_REP_19";
    public static final String COL_19_COD_ORD           =   "COD_ORD_19";
    public static final String COL_19_CONCEPTO          =   "CONCEPTO_19";
    public static final String COL_19_EMPLEADO          =   "EMPLEADO_19";
    public static final String COL_19_TIEMPO            =   "TIEMPO_19";
    public static final String COL_19_IMPORTE           =   "IMPORTE_19";

    public static final String COL_20_MATRICULA         =   "MATRIC_20";
    public static final String COL_20_FSALIDA           =   "FSALIDA_20";
    public static final String COL_20_FENTRADA          =   "FENTRADA_20";
    public static final String COL_20_CODIGO            =   "COD_OTRA_20";
    public static final String COL_20_DESCRIP           =   "DESCRIP_20";
    public static final String COL_20_NOTAS		        =   "NOTAS_20";
    public static final String COL_20_PERSONA           =   "PERSONA_20";
    public static final String COL_20_KM_ENTRADA        =   "KM_ENTR_20";
    public static final String COL_20_IMPORTE           =   "IMP_FACT_20";
    public static final String COL_20_CODTALLER         =   "CODTALLER_20";
    public static final String COL_20_FACTURA           =   "FACTURA_20";
    public static final String COL_20_FFACTURA          =   "FFACTURA_20";
    public static final String COL_20_CONDUCTOR         =   "CONDUCTOR_20";
    public static final String COL_20_TELEF             =   "TELEF_20";
    public static final String COL_20_DESDPTO           =   "DESDPTO_20";
    public static final String COL_20_KM_SALIDA         =   "KM_SAL_20";
    public static final String COL_20_GARANTIA          =   "FGARANTIA_20";

    public static final String COL_21_NOMBRE            =   "NOMBRE_21";
    public static final String COL_21_DNI               =   "DNI_21";
    public static final String COL_21_CODCARGO          =   "CODCARGO_21";
    public static final String COL_21_CODDPTO           =   "CODDPTO_21";
    public static final String COL_21_TELEF             =   "TELEF_21";
    public static final String COL_21_DIREC             =   "DIREC_21";
    public static final String COL_21_RANGO             =   "CODRANG_P_21";
    public static final String COL_21_ACTUALIZA		    =   "ACT_GIP_21";   
    public static final String COL_21_TIPOPER		    =   "TIPO_PER_21";   
    
    public static final String COL_22_CODIGO            =   "COD_PIE_22";
    public static final String COL_22_DESCRIPCION       =   "PIEZA_22";
    public static final String COL_22_PRECIO       		=   "PRECIO_U_22";

    public static final String COL_23_ORDEN             =   "COD_ORD_23";
    public static final String COL_23_CODIGO            =   "COD_REP_23";
    public static final String COL_23_PIE               =   "COD_PIE_23";
    public static final String COL_23_CANTIDAD          =   "CANTID_23";
    public static final String COL_23_DESCRIP           =   "DESCRIP_23";
    public static final String COL_23_PRECIO            =   "PRECIO_U_23";
    public static final String COL_23_TOTAL             =   "TOTAL_23";
    public static final String COL_23_EMPLEADO          =   "EMPL_23";
    public static final String COL_23_CODREP2           =   "COD_REP2_23";
    

    public static final String COL_24_CODIGO            =   "COD_POB_24";
    public static final String COL_24_DESC              =   "DESCRIP_24";
    
    public static final String COL_25_CODIGO            =   "COD_REP_25";
    public static final String COL_25_DESCRIP           =   "DESCRIP_25";

    public static final String COL_26_CODIGO            =   "COD_RESP_26";
    public static final String COL_26_CARGO	            =   "CARGO_26";
    public static final String COL_26_NOMBRE           	=   "NOMBRE_26";

    public static final String COL_27_CODIGO            =   "COD_REVI_27";
    public static final String COL_27_MATRICULA         =   "MATRIC_27";
    public static final String COL_27_ESTADO            =   "ESTADO_27";
    public static final String COL_27_RESULTADO         =   "RESULT_27";
    public static final String COL_27_ANOMALIA          =   "ANOM_27";
    public static final String COL_27_FINSPEC           =   "FINSPEC_27";
    public static final String COL_27_FPRXINSPEC        =   "FPRXINSP_27";
    public static final String COL_27_FREPINSP          =   "FREPINSP_27";
    public static final String COL_27_IMPRESO           =   "IMPRESO_27";

    public static final String COL_28_MATRICULA         =   "MATRIC_28";
    public static final String COL_28_CIA               =   "CIA_28";
    public static final String COL_28_CODSEG            =   "COD_SEG_28";
    public static final String COL_28_MODAL             =   "MODAL_28";
    public static final String COL_28_DIRECCION         =   "DIREC_28";
    public static final String COL_28_TELEFONO          =   "TELEF_28";
    public static final String COL_28_NCTRL             =   "NCTRL_28";
    public static final String COL_28_FALTA             =   "FALTA_28";
    public static final String COL_28_FBAJA             =   "FBAJA_28";
    public static final String COL_28_FCADUC            =   "FCADUC_28";
    public static final String COL_28_IMPORTE           =   "IMPORTE_28";
    public static final String COL_28_POLIZA            =   "POLIZA_28";
    
    

    public static final String COL_29_CODIGO            =   "COD_SINI_29";
    public static final String COL_29_DNI               =   "DNI_29";
    public static final String COL_29_MATRICULA         =   "MATRIC_29";
    public static final String COL_29_NOMBREC           =   "NOMBCC_29";
    public static final String COL_29_DNICC             =   "DNICC_29";
    public static final String COL_29_MATRICULAC        =   "MATRICCC_29";
    public static final String COL_29_NOMBREASCC        =   "NOMBACC_29";
    public static final String COL_29_DNIACC            =   "DNIACC_29";
    public static final String COL_29_ASEGURCC          =   "ASEGURCC_29";
    public static final String COL_29_POLIZACC          =   "POLIZACC_29";
    public static final String COL_29_FSINIESTRO        =   "FSINIESTRO_29";
    public static final String COL_29_FRESOLU           =   "FRESOL_29";
    public static final String COL_29_RESPONS           =   "RESPONS_29";
    public static final String COL_29_PERITADO          =   "PERITADO_29";
    public static final String COL_29_TALLER            =   "CODTALLER_29";
    public static final String COL_29_IMPORTE           =   "IMPORTE_29";
    public static final String COL_29_OBSERV            =   "OBSERV_29";

    public static final String COL_30_CODIGO            =   "COD_TAL_30";
    public static final String COL_30_DESCRIP           =   "DESCRIP_30";
    public static final String COL_30_DIRECCION        	=   "DIREC_30";
    public static final String COL_30_POBLACION        	=   "COD_POB_30";
    public static final String COL_30_TELEF	        	=   "TELEF_30";
        
    public static final String COL_31_TARJHIST          =   "COD_TARH_31";
    public static final String COL_31_TARJETA           =   "TARJETA_31";
    public static final String COL_31_MATRICULA         =   "MATRIC_31";
    public static final String COL_31_CENTRO            =   "CENTRO_31";
    public static final String COL_31_LIMITE            =   "LIMITE_31";
    public static final String COL_31_FALTA             =   "FALTA_31";
    public static final String COL_31_FSOLIC            =   "FSOLIC_31";
    public static final String COL_31_FCADUC            =   "FCADUC_31";
    public static final String COL_31_SITUACION         =   "SITUACION_31";
    public static final String COL_31_CUENTA            =   "NCUENTA_31";
    public static final String COL_31_INCIDENCIA        =   "INCIDENC_31";
    public static final String COL_31_PLASTIC           =   "PLASTIC_31";
    public static final String COL_31_TAG               =   "TAG_31";
    public static final String COL_31_FIMPRESION        =   "FIMPRES_31";
    public static final String COL_31_IMPRESO        	=   "IMPRESO_31";
    public static final String COL_31_CAMBIO            =   "CAMBIO_31";
    public static final String COL_31_FCAMBIO           =   "FCAMBIO_31";
    public static final String COL_31_LITERAL           =   "LITERAL_31";
    public static final String COL_31_FBAJA             =   "FBAJA_31";
    public static final String COL_31_TIPO              =    "TIPO_31";


    public static final String COL_32_CODIGO            =   "COD_TASA_32";
    public static final String COL_32_MATRICULA         =   "MATRIC_32";
    public static final String COL_32_CONCEPTO          =   "CONCEPTO_32";
    public static final String COL_32_IMPORTE           =   "IMPORTE_32";
    public static final String COL_32_FECHA             =   "FECHA_32";
    public static final String COL_32_MUNICIPIO         =   "MUNICIPIO_32";
    public static final String COL_32_OBSERV            =   "OBSERV_32";

    public static final String COL_34_MARCA             =   "MARCA_34";
    public static final String COL_34_MATRICULA         =   "MATRIC_34";
    public static final String COL_34_MODELO            =   "COD_MOD_34";
    public static final String COL_34_COLOR             =   "COLOR_34";
    public static final String COL_34_RANGO             =   "RANGO_34";
    public static final String COL_34_APARCADO          =   "APARCADO_34";
    public static final String COL_34_KMACTUALES        =   "KM_ACT_34";
    public static final String COL_34_SITUACION         =   "SITUACION_34";
    public static final String COL_34_KMREVIS           =   "KMREVIS_34";
    public static final String COL_34_MESREVIS          =   "MESREVIS_34";
    // public static final String COL_34_FACTUAL           =   "FACTUAL_34";   **** ELIMINADO PORQUE NO SE USABA
    public static final String COL_34_FKMACT            =   "FKM_ACT_34";
    public static final String COL_34_FMATRIC           =   "FMATRIC_34";
    public static final String COL_34_FGARANTIA         =   "FGARANTIA_34";
    public static final String COL_34_ROTULADO          =   "ROTUL_34";
    public static final String COL_34_EXPDTE            =   "EXPTE_34";
    public static final String COL_34_INF1              =   "INF_ADIC1_34";
    public static final String COL_34_INF2              =   "INF_ADIC2_34";
    public static final String COL_34_NSERIE            =   "NSERIE_34";
    public static final String COL_34_CV                =   "CV_FISC_34";
    public static final String COL_34_NOTA              =   "OBSERV_34";
    public static final String COL_34_AUTORI_APAR       =   "AUTAPARC_34";
    public static final String COL_34_PRECIO            =   "PRECIO_34";
    public static final String COL_34_VIDAUTIL          =   "VIDAUTIL_34";
    public static final String COL_34_VCONTAB           =   "VCONTAB_34";
    public static final String COL_34_AMOANUAL          =   "AMOANUAL_34";
    public static final String COL_34_AMOACUM           =   "AMOACUM_34";
    public static final String COL_34_IMPBAJA           =   "IMP_BAJA_34";
    public static final String COL_34_DESTINO           =   "DESTINO_34";
    public static final String COL_34_MOTIVBAJA         =   "MOTIVBAJA_34";
    public static final String COL_34_FADQUIS           =   "FADQUIS_34";
    public static final String COL_34_REGADQUIS         =   "REGADQUIS_34";
    public static final String COL_34_FBAJA             =   "FBAJA_34";
    public static final String COL_34_FALTA             =   "FALTA_34";
    public static final String COL_34_MATRIC_ANT        =   "MATRIC_ANT_34";
    public static final String COL_34_POLIZA            =   "POLIZA_34";
    public static final String COL_34_CODDPTO           =   "CODDPTO_34";
    public static final String COL_34_DESDPTO           =   "DESDPTO_34";
    public static final String COL_34_CR                =   "CV_REAL_34";
    public static final String COL_34_FBAJATEMP         =   "FBAJATEMP_34";
    public static final String COL_34_FCEDIDO           =   "FCEDIDO_34";


    public static final String COL_35_CODIGO            =   "COD_REVI_35";
    public static final String COL_35_MATRICULA         =   "MATRIC_35";
    public static final String COL_35_ORDEN             =   "ORDEN_35";
    public static final String COL_35_IMPORTE           =   "IMPORTE_35";
    public static final String COL_35_REALIZA           =   "REALIZA_35";
    public static final String COL_35_FECHA             =   "FREVISI_35";
    public static final String COL_35_DESC              =   "DESCRIP_35";
    public static final String COL_35_KMPRE             =   "KMPREVIS_35";
    public static final String COL_35_KMRE              =   "KMREVIS_35";
    public static final String COL_35_FECPRE            =   "FPREVIS_35";


    public static final String COL_36_CODIGO            =   "COD_GRUP_36";
    public static final String COL_36_NOMBRE            =   "NOMBRE_36";
    public static final String COL_36_RANGOS            =   "RANG_36";
    
    
    public static final String COL_37_CODIGO            =   "COD_REF_37";
    public static final String COL_37_MATRICULA         =   "MATRIC_37";
    public static final String COL_37_NUMERO            =   "NUM_37";
    public static final String COL_37_MARCA             =   "MARCA_37";
    public static final String COL_37_TALLER            =   "TALLER_37";
    public static final String COL_37_FECHA             =   "FEC_REF_37";
    public static final String COL_37_OBSERV            =   "OBSERV_37";
    public static final String COL_37_TIPO              =   "COD_TIPREF_37";


    public static final String COL_38_CODIGO            =   "COD_TIPREF_38";
    public static final String COL_38_DESC              =   "DESC_38";


    public static final String COL_39_CODIGO            =   "COD_AMO_39";
    public static final String COL_39_MATRICULA         =   "MATRIC_39";
    public static final String COL_39_RANGO             =   "RANG_39";
    public static final String COL_39_IMPORTE           =   "IMPORTE_39";
    public static final String COL_39_FECHA             =   "FECHA_39";
    public static final String COL_39_AMORTIZA          =   "AMORTIZ_39";

    public static final String COL_40_MATRICULA         =   "MATRIC_40";
    public static final String COL_40_FDESDE            =   "FDESDE_40";
    public static final String COL_40_FHASTA            =   "FHASTA_40";
    public static final String COL_40_RANGO             =   "RANG_40";
    public static final String COL_40_IMPORTE           =   "IMPORTE_40";
    public static final String COL_40_CODIGO            =   "COD_TRA_40";

    public static final String COL_41_CODIGO            =   "COD_REN_41";
    public static final String COL_41_MATRICULA         =   "MATRIC_41";
    public static final String COL_41_FECHA             =   "FECHA_41";
    public static final String COL_41_IMPORTE           =   "IMPORTE_41";
    
    public static final String COL_43_ID		        =   "ID_43";
    public static final String COL_43_FECHA		        =   "FEC_CARGA_43";
    public static final String COL_43_NOMBRE	        =   "NOMFICHE_43";
    public static final String COL_43_NUMREG         	=   "NUM_REG_43";
    public static final String COL_43_PRIMERREG         =   "PRI_REG_43";
    public static final String COL_43_FICHERO	        =   "FICHERO_43";

    public static final String COL_44_MATRICULA         =   "MATRIC_44";
    public static final String COL_44_ID                =   "ID_44";
    public static final String COL_44_MARCA             =   "MARCA_44";
    public static final String COL_44_MODELO            =   "COD_MOD_44";
    public static final String COL_44_COLOR             =   "COLOR_44";
    public static final String COL_44_RANGO             =   "RANGO_44";
    public static final String COL_44_APARCADO          =   "APARCADO_44";
    public static final String COL_44_KMACTUALES        =   "KM_ACT_44";
    public static final String COL_44_SITUACION         =   "SITUACION_44";
    public static final String COL_44_KMREVIS           =   "KMREVIS_44";
    public static final String COL_44_MESREVIS          =   "MESREVIS_44";
    // public static final String COL_44_FACTUAL           =   "FACTUAL_44";   **** ELIMINADO PORQUE NO SE USABA
    public static final String COL_44_FKMACT            =   "FKM_ACT_44";
    public static final String COL_44_FMATRIC           =   "FMATRIC_44";
    public static final String COL_44_FGARANTIA         =   "FGARANTIA_44";
    public static final String COL_44_ROTULADO          =   "ROTUL_44";
    public static final String COL_44_EXPDTE            =   "EXPTE_44";
    public static final String COL_44_INF1              =   "INF_ADIC1_44";
    public static final String COL_44_INF2              =   "INF_ADIC2_44";
    public static final String COL_44_NSERIE            =   "NSERIE_44";
    public static final String COL_44_CV                =   "CV_FISC_44";
    public static final String COL_44_NOTA              =   "OBSERV_44";
    public static final String COL_44_AUTORI_APAR       =   "AUTAPARC_44";
    public static final String COL_44_PRECIO            =   "PRECIO_44";
    public static final String COL_44_VIDAUTIL          =   "VIDAUTIL_44";
    public static final String COL_44_VCONTAB           =   "VCONTAB_44";
    public static final String COL_44_AMOANUAL          =   "AMOANUAL_44";
    public static final String COL_44_AMOACUM           =   "AMOACUM_44";
    public static final String COL_44_IMPBAJA           =   "IMP_BAJA_44";
    public static final String COL_44_DESTINO           =   "DESTINO_44";
    public static final String COL_44_MOTIVBAJA         =   "MOTIVBAJA_44";
    public static final String COL_44_FADQUIS           =   "FADQUIS_44";
    public static final String COL_44_REGADQUIS         =   "REGADQUIS_44";
    public static final String COL_44_FBAJA             =   "FBAJA_44";
    public static final String COL_44_FALTA             =   "FALTA_44";
    public static final String COL_44_MATRIC_ANT        =   "MATRIC_ANT_44";
    public static final String COL_44_POLIZA            =   "POLIZA_44";
    public static final String COL_44_CODDPTO           =   "CODDPTO_44";
    public static final String COL_44_DESDPTO           =   "DESDPTO_44";
    public static final String COL_44_FCAMBIO           =   "FCAMBIO_44";
    public static final String COL_44_FFIN              =   "FFIN_44";
    public static final String COL_44_CR                =   "CV_REAL_44";
    public static final String COL_44_FBAJATEMP         =   "FBAJATEMP_44";
    public static final String COL_44_FCEDIDO           =   "FCEDIDO_44";

    public static final String COL_45_CODIGO            =   "COD_SANCION_45";
    public static final String COL_45_TIPO              =   "TIPO_45";
    public static final String COL_45_COD_ORG           =   "COD_ORG_45";
    public static final String COL_45_DESC_ORG          =   "DESC_ORG_45";
    public static final String COL_45_FRECEPC           =   "FRECEPC_45";
    public static final String COL_45_NEXP_DENUNCIA     =   "NEXP_DENUNCIA_45";
    public static final String COL_45_FSANCION          =   "FSANCION_45";
    public static final String COL_45_NEXP_SANCION      =   "NEXP_SANCION_45";
    public static final String COL_45_DNI               =   "DNI_45";
    public static final String COL_45_MATRICULA         =   "MATRIC_45";
    public static final String COL_45_FDENUNCIA         =   "FDENUNCIA_45";
    public static final String COL_45_FREC_DATOS        =   "FREC_DATOS_45";
    public static final String COL_45_FNOTIF_DPTO       =   "FNOTIF_DPTO_45";
    public static final String COL_45_FNOTIF_COND       =   "FNOTIF_COND_45";
    public static final String COL_45_FRESOLUCION       =   "FRESOLUCION_45";
    public static final String COL_45_FAPREMIO          =   "FAPREMIO_45";
    
    
    public static final String COL_46_MATRICULA       	=   "MATRIC_46";
    public static final String COL_46_TARJETA       	=   "TARJETA_46";
    public static final String COL_46_TIPO		       	=   "TIPO_46";
    public static final String COL_46_EJER		       	=   "EJER_46";
    public static final String COL_46_MES		       	=   "MES_46";    
    public static final String COL_46_IMPORTE       	=   "IMPORTE_46";
    public static final String COL_46_KM		       	=   "KM_46";
    public static final String COL_46_LITROS	       	=   "LITROS_46";


    public static final String COL_47_DNI		       	=   "DNI_47";
    public static final String COL_47_DESCRIPCION      	=   "DESCRIP_47";
    
    public static final String COL_48_COD_ORG           =   "COD_ORG_48";
    public static final String COL_48_DESC_ORG          =   "DESCRIP_48";
    public static final String COL_48_EDESC_ORG         =   "E_DESCRIP_48";
    
	// Tablas Temporales
	
	public static final String COL_90_USUARIO			= 	"USUARIO_90";
	public static final String COL_90_MATRICULA			= 	"MATRIC_90";
	public static final String COL_90_FINIRANGO		    = 	"FINIRANGO_90";
	public static final String COL_90_FFINRANGO		    = 	"FFINRANGO_90";
	public static final String COL_90_RANGO  			= 	"RANGO_90";
	public static final String COL_90_DIAS				= 	"DIAS_90";
	public static final String COL_90_ORDEN				= 	"ORDEN_90";
	public static final String COL_90_DESCRIPCION		= 	"DESCRIP_90";
	public static final String COL_90_FINIKM		    = 	"FINIKM_90";
	public static final String COL_90_INIKM			    = 	"INIKM_90";
	public static final String COL_90_FFINKM			= 	"FFINKM_90";
	public static final String COL_90_FINKM				= 	"FINKM_90";
	public static final String COL_90_DIFKM				= 	"DIFKM_90";
	public static final String COL_90_SUMALITROS		= 	"SUMALITROS_90";
	public static final String COL_90_SITUACION			= 	"SITUAC_90";
	
	
	
	public static final String COL_91_USUARIO			= 	"USUARIO_91";
	public static final String COL_91_MATRICULA			= 	"MATRIC_91";
	public static final String COL_91_KM	    		= 	"KM_91";
	public static final String COL_91_FECHA	    		= 	"FECHA_91";
	
	public static final String COL_92_USUARIO			= 	"USUARIO_92";
	public static final String COL_92_MATRICULA			= 	"MATRIC_92";
	public static final String COL_92_LITROS    		= 	"LITROS_92";

    public static final String COL_93_USUARIO			= 	"USUARIO_93";
	public static final String COL_93_MATRICULA			= 	"MATRIC_93";
	public static final String COL_93_FECHA				= 	"FECHA_93";
	public static final String COL_93_LITROS    		= 	"VALOR_93";
	public static final String COL_93_IMPORTE    		= 	"VALOR_93";

	public static final String COL_94_USUARIO			= 	"USUARIO_94";
	public static final String COL_94_MATRICULA			= 	"MATRIC_94";
	public static final String COL_94_FINICIO		    = 	"FINICIO_94";
	public static final String COL_94_FFIN			= 	"FFIN_94";
	public static final String COL_94_NOMBRE			= 	"NOMBRE_94";

	
	public static final String COL_95_USUARIO			= 	"USUARIO_95";
	public static final String COL_95_TARJETA			= 	"TARJETA_95";
	public static final String COL_95_MATRICULA			= 	"MATRIC_95";
	public static final String COL_95_TIPO				= 	"TIPO_95";
	public static final String COL_95_CONCEPTO  		= 	"CONCEPTO_95";
	public static final String COL_95_KM    		    = 	"KM_95";
	public static final String COL_95_LITROS			= 	"LITROS_95";
	public static final String COL_95_IMPORTE			= 	"IMPORTE_95";
	public static final String COL_95_CARGABONO			= 	"CARGABONO_95";
	public static final String COL_95_VERIFIC		    = 	"VERIFIC_95";
	public static final String COL_95_FECHA			    = 	"FECHA_95";
	public static final String COL_95_RANGO				= 	"RANGO_95";
	public static final String COL_95_SITUACION			= 	"SITUACION_95";
	public static final String COL_95_DESDPTO			= 	"DESDPTO_95";
	public static final String COL_95_NOMBRE			= 	"NOMBRE_95";
	
	public static final String COL_96_USUARIO			= 	"USUARIO_96";
	public static final String COL_96_MATRICULA			= 	"MATRIC_96";
	public static final String COL_96_RANGO				= 	"RANGO_96";
	public static final String COL_96_MARCA				= 	"MARCA_96";
	public static final String COL_96_COLOR				= 	"COLOR_96";
	public static final String COL_96_KMACT				= 	"KMACT_96";	
	public static final String COL_96_UBICACION			= 	"UBICACION_96";
	public static final String COL_96_MODELO			= 	"MODELO_96";
	public static final String COL_96_LIBRE				= 	"LIBRE_96";

	public static final String COL_97_USUARIO			= 	"USUARIO_97";
	public static final String COL_97_MATRICULA			= 	"MATRIC_97";
	public static final String COL_97_FDESDE			= 	"FDESDE_97";
	public static final String COL_97_FHASTA			= 	"FHASTA_97";
	public static final String COL_97_RANGO				= 	"RANGO_97";
	public static final String COL_97_GRUPO				= 	"GRUPO_97";
	public static final String COL_97_TOTAL				= 	"TOTAL_97";
	public static final String COL_97_DIAS				= 	"DIAS_97";
	public static final String COL_97_PORCENT			= 	"PORCENTAJE_97";
	public static final String COL_97_INTERV_TP			= 	"NINTERV_TP_97";
	public static final String COL_97_INTERV_TE			= 	"NINTERV_TE_97";
	public static final String COL_97_GASTOS_TP			= 	"GASTOS_TP_97";
	public static final String COL_97_GASTOS_TE			= 	"GASTOS_TE_97";
	public static final String COL_97_COMBUSTIBLE		= 	"COMBUSTIBLE_97";
	public static final String COL_97_AMORTDIARIA		= 	"AMORTDIARIA_97";
	public static final String COL_97_AMORTIZACION		= 	"AMORTIZACION_97";
	public static final String COL_97_FINIKM			= 	"FINIKM_97";
	public static final String COL_97_FFINKM			= 	"FFINKM_97";
	public static final String COL_97_INIKM				= 	"INIKM_97";
	public static final String COL_97_FINKM				= 	"FINKM_97";	
	public static final String COL_97_KMRECORRIDOS		= 	"KMRECOR_97";
	public static final String COL_97_DIASKM			= 	"DIASKM_97";
	public static final String COL_97_MEDIAKM			= 	"MEDIAKM_97";


	// Tabla de Descripciones
	public static final String COL_99_CODTABLA			= 	"COD_TAB_99";
	public static final String COL_99_CODDESC			= 	"COD_DESC_99";
	public static final String COL_99_DESCRIPCION		= 	"DESCRIP_99";


	// j47
		//  VISTAS
    public static final String J47_VIS_RELACIONES		=   "J47G2S00";
    public static final String J47_VIS_PERSONAS			=   "J47G3S00";
    public static final String J47_VIS_ORGANIGRAMAS		=   "J47G4S00";
    public static final String J47_VIS_GENERAL			=   "J47G5S00";
    public static final String J47_VIS_DESGLOSES		=   "J47G6S00";

		//  COLUMNAS
    public static final String J47_PUESTO				=   "PUESTO";
    public static final String J47_DNI					=   "DNI";
    public static final String J47_NOMBRE				=   "NOMBRE || ' ' ||APELLIDO1 || ' ' ||APELLIDO2";
    public static final String J47_TELEFONO				=   "TELEFONO";
    public static final String J47_CODDPTO				=   "DEPARTAMENTO";
    public static final String J47_DIRECCION			=   "DOMICILIO";
    public static final String J47_CODCTRO				=   "CENTRO_ORGANICO";
    public static final String J47_CODIGO				=   "CODIGO";
    public static final String J47_SUBCODIGO			=   "SUBCODIGO";
    public static final String J47_ESTRUCTURA			=   "CODIGO_ESTRUCTURA";
    public static final String J47_DESCRIPCION			=   "DESCRIPCION_CASTELLANO_AMP";
    public static final String J47_EDESCRIPCION			=   "DESCRIPCION_EUSKERA_AMP";
    public static final String J47_CAUSACESE			=   "CAUSA_CESE";
    public static final String J47_SITADMIN				=   "SITUACION_ADMINISTRATIVA";
    public static final String J47_FINICIO				=   "FECHA_INICIO";

    public static final String J47_SUBC_20				=   "20";
    public static final String J47_SUBC_24				=   "24";



	// *********************
	// SOLICITUD DE RESERVAS
	// *********************

	// ESTADOS SOLICITUD
	public static final String SOLICITADA				=	"SOL";
	public static final String RECHAZADA				=	"REC";
	public static final String ACEPTADASINASIGNAR		=	"ASA";
	public static final String ACEPTADASINENTREGAR		=	"ASE";
	public static final String ACEPTADASINDEVOLVER		=	"ASD";
	public static final String FINALIZADA				=	"FIN";
//	Agurtzane Mar12: caducar solicitudes
	public static final String CADUCADA					=	"CAD";
//	Fin Agurtzane Mar12: caducar solicitudes

	// ORÍGENES DE RECHAZO DE SOLICITUD
	public static final String ORIGENPARQUEMOVIL				=	"B";
	public static final String ORIGENWEBSOLICITUDESVALIDADOR	=	"J";
	public static final String ORIGENWEBSOLICITUDESSOLICITANTE	=	"S";

	// TIPOS DE FIRMAS DE LAS ASIGNACIONES
	public static final String FIRMAENTREGA				= 	"E";
	public static final String FIRMADEVOLUCION			= 	"D";
	public static final String FIRMAENTREGA_PM			= 	"EP";
	public static final String FIRMADEVOLUCION_PM		= 	"DP";

	// ACCIONES DE LAS FIRMAS
	public static final String ACC_FIRMARENTREGA		= 	"FE";
	public static final String ACC_FIRMARDEVOLUCION		= 	"FD";
	
	public static final String ACC_GUARDAREINICIARFIRMARENTREGA		= 	"GFE";
	public static final String ACC_GUARDAREINICIARFIRMARDEVOLUCION	= 	"GFD";

	// ACCIONES DE LOS ESTADOS
	public static final String ACCION_APROBAR = "APROBAR";
	public static final String ACCION_RECHAZAR = "RECHAZAR";
	public static final String ACCION_VER_DETALLE = "VER_DETALLE";
	public static final String ACCION_ASIGNAR = "ASIGNAR";

	// SITUACIONES
	public static final String SITUACION_ALTA = "A";
	public static final String SITUACION_BAJA = "B";


	// *************
	// BASE DE DATOS
	// *************
	
	// TABLAS
	public static final String TAB_SOLICITUD            =   "M05100T00";
    public static final String TAB_PROVINCIA            =   "M05199S00_NORA_PROVINCIAS";
    public static final String TAB_MUNICIPIO            =   "M05198S00_NORA_MUNICIPIOS";
    
	// Tablas de la aplicacion

    public static final String COL_100_CODSOLICITUD      =   "CODSOLICITUD_100";
    public static final String COL_100_USUARIORESERVADOR =   "USUARIORESERVADOR_100";
    public static final String COL_100_FECHASOLICITUD    =   "FECHASOLICITUD_100";
    public static final String COL_100_NOMBRE   	     =   "NOMBRE_100";
    public static final String COL_100_APELLIDOS         =   "APELLIDOS_100";
    public static final String COL_100_DNI         		 =   "DNI_100";
    public static final String COL_100_TELEFONO          =   "TELEFONO_100";
    public static final String COL_100_DOMICILIO         =   "DOMICILIO_100";
    public static final String COL_100_CODPROVINCIA      =   "CODPROVINCIA_100";
    public static final String COL_100_CODMUNICIPIO      =   "CODMUNICIPIO_100";
    public static final String COL_100_CODPOSTAL         =   "CODPOSTAL_100";
    public static final String COL_100_PUESTO            =   "PUESTO_100";
    public static final String COL_100_CODDEPARTAMENTO   =   "CODDEPARTAMENTO_100";
    public static final String COL_100_DESCCDEPARTAMENTO =   "DESCCDEPARTAMENTO_100";
    public static final String COL_100_DESCEDEPARTAMENTO =   "DESCEDEPARTAMENTO_100";
    public static final String COL_100_FECHAINI          =   "FECHAINI_100";
    public static final String COL_100_FECHAFIN          =   "FECHAFIN_100";
    public static final String COL_100_MOTIVOSOLICITUD   =   "MOTIVOSOLICITUD_100";
    public static final String COL_100_ESTADO	         =   "ESTADO_100";
    public static final String COL_100_MOTIVORECHAZO     =   "MOTIVORECHAZO_100";
    public static final String COL_100_USUARIORECHAZO    =   "USUARIORECHAZO_100";
    public static final String COL_100_FECHAAPROBACION   =   "FECHAAPROBACION_100";
    public static final String COL_100_FECHAASIGNACION   =   "FECHAASIGNACION_100";
    public static final String COL_100_FECHAENTREGA      =   "FECHAENTREGA_100";
    public static final String COL_100_FECHADEVOLUCION   =   "FECHADEVOLUCION_100";
    public static final String COL_100_FECHAANULACION	 =   "FECHAANULACION_100";
    public static final String COL_100_MAILSOLENVIADO    =   "MAILSOLENVIADO_100";
    public static final String COL_100_MAILRECENVIADO    =   "MAILRECENVIADO_100";
    public static final String COL_100_CODVALIDADOR      =   "CODVALIDADOR_100";

	// Tabla de Provincias
	public static final String COL_199_ID				= 	"ID";
	public static final String COL_199_DS_O				= 	"DS_O";
	public static final String COL_199_AUTONOMIA_ID		= 	"AUTONOMIA_ID";

	// Tabla de Municipios
	public static final String COL_198_ID				= 	"ID";
	public static final String COL_198_DS_O				= 	"DS_O";
	public static final String COL_198_PROVINCIA_ID		= 	"PROVINCIA_ID";
	public static final String COL_198_COMARCA_ID		= 	"COMARCA_ID";

	
	//TIPOS DE INFORMES
	public static final int INF_ALTASVEHICULOS=0;
	public static final int INF_BAJASVEHICULOS=1;
	public static final int INF_ASIGPORTIPOVEH=2;
	public static final int INF_ASIGFECHAS=3;
	public static final int INF_ASIGPERSONAS=4;
	public static final int INF_ASIGVIVAS=5;
	public static final int INF_COCHES=6;
	public static final int INF_CONDUCTORES=7;
	public static final int INF_CTKAMORTIZACION=8;
	public static final int INF_LISTADOGENERAL=9;
	public static final int INF_LISTADOORDENES=10;
	public static final int INF_LISTADOORDENESDETALLE=11;
	public static final int INF_LISTADOORDENESFECHAS=12;
	public static final int INF_CTKCOMBUSTIBLE=13;
	public static final int INF_CTKKILOMETRAJE=14;
	public static final int INF_CTKVEHICULOS=15;
	public static final int INF_BUSCMATRI=16;
	public static final int INF_TASAS=17;
	public static final int INF_SANCIONES=18;
	//FORMATOS DE INFORMES
	public static final int INF_FORMATOHTML=0;
	public static final int INF_FORMATOEXCEL=1;
	public static final int INF_FORMATOPDF=2;
	
	public static final int INF_TIPOLISTADO=0;
	public static final int INF_TIPORESUMEN=1;
	public static final int INF_TIPORESUMEN2=2;
public m05bConstantes() {

		super();

	}

}