Módulo Sucursal Electrónica
Table Name: SucursalElectronica_ContratoCliente
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_ContratoCorrelativo | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_ContratoClCliCod | int | 4 | YES | NO |
|
SucursalElectronica_ContratoFechaAcepta | datetime | 8 | YES | NO |
|
Table Name: SucursalElectronica_Cotizacion
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_CotizacionIDTransaccionSifco | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_CotizacionIDTransaccion | char | 50 | NO | NO |
|
SucursalElectronica_CotizacionIDNegocio | char | 50 | NO | NO |
|
SucursalElectronica_CotizacionIDPrestador | char | 50 | NO | NO |
|
SucursalElectronica_CotizacionObservacion | varchar | -1 | NO | NO |
|
SucursalElectronica_CotizacionMontoSolicitado | money | 8 | NO | NO |
|
SucursalElectronica_CotizacionMontoAprobado | money | 8 | NO | NO |
|
SucursalElectronica_CotizacionFecha | datetime | 8 | NO | NO |
|
SucursalElectronica_CotizacionFechaModulo | datetime | 8 | NO | NO |
|
SucursalElectronica_CotizacionUsuarioCod | varchar | 100 | NO | NO |
|
SucursalElectronica_CotizacionEstado | smallint | 2 | NO | NO |
|
SucursalElectronica_CotizacionClienteCod | int | 4 | NO | NO |
|
Table Name: SucursalElectronica_CotizacionDetalle
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_CotizacionIDTransaccionSifco | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_CotizacionDetIDPlanPagoSifco | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_CreditoCotizacionID | smallint | 2 | NO | NO |
|
SucursalElectronica_FrecCotizacionCod | smallint | 2 | NO | NO |
|
SucursalElectronica_CotizacionDetVigenciaCredito | smallint | 2 | NO | NO |
|
SucursalElectronica_CotizacionDetNombrePlanPago | varchar | 100 | NO | NO |
|
SucursalElectronica_CotizacionDetDescPlanPago | varchar | 200 | NO | NO |
|
SucursalElectronica_CotizacionDetNumCuotasPlanPago | smallint | 2 | NO | NO |
|
SucursalElectronica_CotizacionDetValCuotaPlanPago | money | 8 | NO | NO |
|
SucursalElectronica_CotizacionDetDiaVencimiento | smallint | 2 | NO | NO |
|
SucursalElectronica_CotizacionDetVencimientoPrimeraCuota | datetime | 8 | NO | NO |
|
SucursalElectronica_CotizacionDetVencimientoUltimaCuota | datetime | 8 | NO | NO |
|
SucursalElectronica_CotizacionDetTasaMensualPlanPago | smallmoney | 4 | NO | NO |
|
SucursalElectronica_CotizacionDetTasaAnualPlanPago | smallmoney | 4 | NO | NO |
|
SucursalElectronica_CotizacionDetTasaInteresPlanPago | smallmoney | 4 | NO | NO |
|
SucursalElectronica_CotizacionDetIndicadorCrediticio | smallmoney | 4 | NO | NO |
|
SucursalElectronica_CotizacionDetMontoCostoAsociados | money | 8 | NO | NO |
|
SucursalElectronica_CotizacionDetMontoCredito | money | 8 | NO | NO |
|
SucursalElectronica_CotizacionDetEstado | smallint | 2 | NO | NO |
|
SucursalElectronica_CotizacionDetPlazoID | char | 20 | NO | NO |
|
Table Name: SucursalElectronica_CotizacionDocumentos
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_CotizacionIDTransaccionSifco | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_CotizacionDocumentosID | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_PlanPagoID | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_CotizacionEspedienteID | smallint | 2 | YES | NO |
|
SucursalElectronica_CotizacionDocumentosEstado | smallint | 2 | NO | NO |
|
SucursalElectronica_CotizacionDocID | char | 20 | YES | NO |
|
SucursalElectronica_CotizacionDocEmpresa | smallint | 2 | YES | NO |
|
SucursalElectronica_CotizacionDocVersion | smallint | 2 | YES | NO |
|
Table Name: SucursalElectronica_EvaluacionCredito
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_GestionesID | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_SoCrRegla | smallint | 2 | NO | NO |
|
SucursalElectronica_SoCrReglaTitulo | varchar | 100 | NO | NO |
|
SucursalElectronica_SoCrReglaIndicador | money | 8 | NO | NO |
|
SucursalElectronica_SoCrReglaAprobada | bit | 1 | NO | NO |
|
Table Name: SucursalElectronica_Gestiones
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_GestionesID | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_GestionTipo | char | 25 | NO | NO |
|
SucursalElectronica_GestionClienteID | int | 4 | NO | NO |
|
SucursalElectronica_GestionFechaIngreso | datetime | 8 | NO | NO |
|
SucursalElectronica_GestionStatus | char | 10 | NO | NO |
|
SucursalElectronica_GestionCuenta | char | 14 | YES | NO |
|
SucursalElectronica_GestionMonto | money | 8 | YES | NO |
|
SucursalElectronica_GestionSaldoCreditos | money | 8 | YES | NO |
|
SucursalElectronica_GestionSaldoAhorrros | money | 8 | YES | NO |
|
SucursalElectronica_GestionSaldoAportaciones | money | 8 | YES | NO |
|
SucursalElectronica_GestionFechaUltimoRetiro | datetime | 8 | YES | NO |
|
SucursalElectronica_GestionTrx | int | 4 | YES | NO |
|
SucursalElectronica_GestionSoCrEmpresa | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionSoCrSucursal | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionSoCrNumero | int | 4 | YES | NO |
|
SucursalElectronica_GestionSoCrGarantia | varchar | 400 | YES | NO |
|
SucursalElectronica_GestionSoCrDestino | varchar | 400 | YES | NO |
|
SucursalElectronica_GestionSoCrFechaIngreso | datetime | 8 | YES | NO |
|
SucursalElectronica_GestionSoCrUltimoSueldo | money | 8 | YES | NO |
|
SucursalElectronica_GestionSoCrTipoCredito | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionSoCrPlazo | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionSoCrFacPlazo | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionSoCrFelCod | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionSoCrFreCCod | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoPreNumero | char | 14 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoReferencia1 | char | 256 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoReferencia2 | char | 256 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoFecha | datetime | 8 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoFechaPrimerPago | datetime | 8 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoFormaPago | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoPlazo | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoFrecuencia | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoFrecuenciaPlanilla | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoPlazoFact | char | 1 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoFrecuenciaFactor | smallint | 2 | YES | NO |
|
SucursalElectronica_GestionCreditoRapidoFrecuenciaInteres | smallint | 2 | YES | NO |
|
Table Name: SucursalElectronica_GestionesActividad
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_GestionesID | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_GestionActividadTimeStamp | datetime | 8 | NO | NO |
|
SucursalElectronica_GestionUserId | varchar | 100 | NO | NO |
|
SucursalElectronica_GestionActividadStatus | char | 10 | NO | NO |
|
SucursalElectronica_GestionComentarios | varchar | -1 | YES | NO |
|
Table Name: SucursalElectronica_GestionesBeneficiarios
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_GestionesID | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_GestionBeneficiariosID | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_GestionBeneficiariosNombre | char | 30 | NO | NO |
|
SucursalElectronica_GestionBeneficiariosPorcentaje | smallmoney | 4 | NO | NO |
|
SucursalElectronica_GestionBeneficiariosParentesco | char | 15 | NO | NO |
|
SucursalElectronica_GestionBeneficiariosDireccion | varchar | 1024 | NO | NO |
|
SucursalElectronica_GestionBeneficiariosTelefono | char | 20 | NO | NO |
|
Table Name: SucursalElectronica_InvitacionCliente
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_InvitacionID | uniqueidentifier | 16 | NO | NO |
|
SucursalElectronica_InvitacionClCliCod | int | 4 | NO | NO |
|
SucursalElectronica_InvitacionFechaEnvio | datetime | 8 | NO | NO |
|
SucursalElectronica_InvitacionFechaActivacion | datetime | 8 | YES | NO |
|
SucursalElectronica_InvitacionUsuarioInvita | varchar | 100 | NO | NO |
|
SucursalElectronica_InvitacionEnlace | varchar | -1 | YES | NO |
|
SucursalElectronica_InvitacionEstado | smallint | 2 | NO | NO |
|
Table Name: SucursalElectronica_TipoCreditos
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_TipoCreditoID | smallint | 2 | NO | YES |
|
SucursalElectronica_TipoCreditoDescripcion | varchar | 99 | NO | NO |
|
SucursalElectronica_TipoCreditoImagen | varbinary | -1 | NO | NO |
|
SucursalElectronica_TipoCreditoImagen_GXI | varchar | 2048 | YES | NO |
|
SucursalElectronica_TipoCreditoVigente | bit | 1 | NO | NO |
|
SucursalElectronica_TipoCreditoExplicacion | varchar | -1 | NO | NO |
|
SucursalElectronica_TipoCredito_Empresa | smallints | 2 | NO | NO |
|
ApPrdCod | smallint | 2 | NO | NO |
|
ApColCod | smallint | 2 | NO | NO |
|
SoCrPrmCod | varchar | 100 | NO | NO |
|
ApGarClaCod | smallint | 2 | NO | NO |
|
ApGrDCod | smallint | 2 | NO | NO |
|
SucursalElectronica_TipoCreditoGarantia | bit | 1 | NO | NO |
|
SucursalElectronica_TipoCreditoDestion | bit | 1 | NO | NO |
|
SucursalElectronica_TipoCreditoUltimoSueldo | bit | 1 | NO | NO |
|
SucursalElectronica_TipoCreditoFechaContratacion | bit | 1 | NO | NO |
|
SucursalElectronica_TipoCredito_TipoCompromiso | smallint | 2 | NO | NO |
|
TipoCreditos_Clase | smallint | 2 | YES | NO |
|
TipoCreditos_FormaDesembolso | smallint | 2 | YES | NO |
|
TipoCreditos_FormaSeleccionCliente | smallint | 2 | YES | NO |
|
TipoCreditos_OrigenFondos | smallint | 2 | YES | NO |
|
TipoCreditos_Aprobacion | smallint | 2 | YES | NO |
|
Table Name: SucursalElectronica_TipoCreditos_Reglas
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_TipoCreditoID | smallint | 2 | NO | NO |
|
SucursalElectronica_ReglaNumero | smallint | 2 | NO | NO |
|
SucursalElectronica_ReglaDescripcion | varchar | 200 | NO | NO |
|
SucursalElectronica_ReglaFactorEvaluar | varchar | -1 | NO | NO |
|
SucursalElectronica_ReglaComparacion | char | 2 | NO | NO |
|
SucursalElectronica_ReglaIndicador | varchar | -1 | NO | NO |
|
SucursalElectronica_ReglaFactorMostrarEnSolicitud | bit | 1 | NO | NO |
|
SucursalElectronica_ReglaFactorTitulo | char | 50 | NO | NO |
|
Table Name: SucursalElectronica_TipoCreditosDocumentosImprimir
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_TipoCreditoID | smallint | 2 | NO | NO |
|
SucursalElectronica_TipoCreditoDocumentoID | char | 20 | NO | NO |
|
SucursalElectronica_TipoCreditoDocumentoVersion | smallint | 2 | NO | NO |
|
SucursalElectronica_TipoCreditoDocumentoFuncion | char | 20 | NO | NO |
|
SucursalElectronica_TipoCreditoDocTipoCod | smallint | 2 | YES | NO |
|
Table Name: SucursalElectronica_TipoCreditosExpedienteElectronico
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_TipoCreditoID | smallint | 2 | NO | NO |
|
SucursalElectronica_TipoCreditoExpedienteElectronico | smallint | 2 | NO | NO |
|
Table Name: SucursalElectronica_TipoCreditosPlazos
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
SucursalElectronica_TipoCreditoID | smallint | 2 | NO | NO |
|
SucursalElectronica_TipoCredito_SoCrPlazo | smallint | 2 | NO | NO |
|
SoCrFacPlazo | smallint | 2 | NO | NO |
|
SoCrFrelCod | smallint | 2 | NO | NO |
|
SoCrFreCCod | smallint | 2 | NO | NO |
|
SucursalElectronica_TipoCreditoPlazoDescripcion | varchar | 100 | NO | NO |
|
(c) 2020 por SIFC.O, S.A.