Captaciones
En este apartado encontrará tablas de datos utilizadas en las cuentas de captaciones.
Table Name: CABeneficiarios
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
BenCodigo | smallint | 2 | NO | NO |
|
BenNombre | char | 30 | NO | NO |
|
BenPorcentaje | smallmoney | 4 | NO | NO |
|
BenParentesco | char | 15 | NO | NO |
|
BenDireccion | varchar | 1024 | NO | NO |
|
BenTelefono | char | 20 | NO | NO |
|
BenTidCod | smallint | 2 | YES | NO |
|
BenNumID | char | 25 | YES | NO |
|
Table Name: CaCalificadoresAdicionales
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CaCalCtaNumero | char | 14 | NO | NO |
|
CaCalApCalCod | smallint | 2 | NO | NO |
|
CACalVNum | decimal | 9 | YES | NO |
|
CACalVAlfa | varchar | 254 | YES | NO |
|
CACalVFecha | datetime | 8 | YES | NO |
|
CACalVCaracter | char | 30 | YES | NO |
|
Table Name: CACargosxCuenta
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
ApEmpCodigo | smallint | 2 | NO | NO |
|
ApCarCod | smallint | 2 | NO | NO |
|
Table Name: CACheques
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
ChkNumCheque | int | 4 | NO | NO |
|
ChkEstatus | smallint | 2 | NO | NO |
|
Table Name: CACheRevocados
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
CheRevInicial | int | 4 | NO | NO |
|
CheRevFinal | int | 4 | NO | NO |
|
CheRevMotivo | char | 1 | NO | NO |
|
CheRevRevFec | datetime | 8 | NO | NO |
|
CheRevLevFec | datetime | 8 | NO | NO |
|
CheRevURev | char | 10 | NO | NO |
|
CheRevULev | char | 10 | NO | NO |
|
Table Name: CACuentas
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
CtaEmpCodigo | smallint | 2 | NO | NO |
|
ApPrdCod | smallint | 2 | NO | NO |
|
ApSubCod | smallint | 2 | NO | NO |
|
CtaSucCod | smallint | 2 | NO | NO |
|
CtaCorrelativo | int | 4 | NO | NO |
|
CtaNombre | char | 60 | NO | NO |
|
CtaEnvioCorr | smallint | 2 | NO | NO |
|
ClCliCod | int | 4 | NO | NO |
|
DirCor | smallint | 2 | NO | NO |
|
CtaFirRegistradas | smallint | 2 | NO | NO |
|
CtaFirRequeridas | smallint | 2 | NO | NO |
|
CtaMontoInicial | money | 8 | NO | NO |
|
CtaCondEspeciales | char | 1 | NO | NO |
|
CtaFreCod | smallint | 2 | YES | NO |
|
CtaFrePlanilla | smallint | 2 | YES | NO |
|
CtaNumLibreta | int | 4 | NO | NO |
|
CtaCuotaMensual | money | 8 | NO | NO |
|
CtaForCobroS | smallint | 2 | NO | NO |
|
CtaNumCertificado | char | 30 | NO | NO |
|
CtaPlazoDepositos | smallint | 2 | NO | NO |
|
CtaFecVencimiento | datetime | 8 | NO | NO |
|
CtaTasaFoV | char | 1 | NO | NO |
|
CtaFPagoCap | smallint | 2 | NO | NO |
|
CtaFPagoInt | smallint | 2 | NO | NO |
|
CtaFecProximoPago | datetime | 8 | NO | NO |
|
CtaSpread | decimal | 5 | NO | NO |
|
CtaSpreadSobregiro | decimal | 5 | NO | NO |
|
CtaTasaBaseDep | decimal | 5 | NO | NO |
|
CtaFecApe | datetime | 8 | NO | NO |
|
CtaFecUltMovto | datetime | 8 | NO | NO |
|
CtaFecCancelacion | datetime | 8 | NO | NO |
|
CtaFecInactivacion | datetime | 8 | NO | NO |
|
CtaFecModificacion | datetime | 8 | NO | NO |
|
CtaFecUltRenovacion | datetime | 8 | NO | NO |
|
CtaFecUPago | datetime | 8 | NO | NO |
|
CtaEstado | smallint | 2 | NO | NO |
|
CtaEstaInactiva | char | 1 | NO | NO |
|
CtaSalTotal | money | 8 | NO | NO |
|
CtaSReserva | money | 8 | NO | NO |
|
CtaSobAuto | money | 8 | NO | NO |
|
CtaIntMes | money | 8 | NO | NO |
|
CtaIntAcumulado | money | 8 | NO | NO |
|
CtaImpMes | money | 8 | NO | NO |
|
CtaImpAcumulado | money | 8 | NO | NO |
|
CtaInSoMes | money | 8 | NO | NO |
|
CtaInSoAcumulado | money | 8 | NO | NO |
|
CtaAcuPromedio | money | 8 | NO | NO |
|
CtaMinMes | money | 8 | NO | NO |
|
CtaDebDia | money | 8 | NO | NO |
|
CtaCreDia | money | 8 | NO | NO |
|
CtaSalAnterior | money | 8 | NO | NO |
|
CtaSalLibreta | money | 8 | NO | NO |
|
CtaSalConsultado | money | 8 | NO | NO |
|
CtaUsuIng | varchar | 100 | NO | NO |
|
CtaUsuMod | varchar | 100 | YES | NO |
|
ApBlqCod | smallint | 2 | YES | NO |
|
ApCanCod | smallint | 2 | YES | NO |
|
CtaCredito | char | 14 | YES | NO |
|
CtaUltSol | smallint | 2 | NO | NO |
|
CtaUltMod | smallint | 2 | NO | NO |
|
CtaUltSob | smallint | 2 | NO | NO |
|
ClApCanCod | smallint | 2 | YES | NO |
|
CtaReferencia | char | 14 | NO | NO |
|
CtaUltLinLibreta | smallint | 2 | NO | NO |
|
CtaNoPagLibreta | smallint | 2 | NO | NO |
|
CtaImpCertificado | char | 1 | NO | NO |
|
CtaCredVista | char | 14 | YES | NO |
|
CtaUltBen | smallint | 2 | NO | NO |
|
CafUltGar | smallint | 2 | NO | NO |
|
CtaAcumuladoMesMonedaLocal | money | 8 | YES | NO |
|
CtaAcumuladoMesMonedaExtranjera | money | 8 | YES | NO |
|
CtaPlazoFijoFormaSolicitudRetiro | smallint | 2 | YES | NO |
|
CtaPlazoFijoRequiereActivacionInteresesFechaActivacion | datetime | 8 | YES | NO |
|
CtaPlazoFijoRequiereActivacionInteresesFechaInicioCalculo | datetime | 8 | YES | NO |
|
CtaPlazoFijoRequiereActivacionInteresesEstado | bit | 1 | YES | NO |
|
CtaPrmCod | varchar | 100 | YES | NO |
|
CtaPlazoFijoInstruccionesRenovacion | smallint | 2 | YES | NO |
|
CtaMontoRenovacion | money | 8 | YES | NO |
|
CtaInstruccionesRenovacionComentario | char | 250 | YES | NO |
|
CtaEstadoVerificacion | char | 10 | YES | NO |
|
CtaUltLinLibretaCookieReImprime | smallint | 2 | YES | NO |
|
Table Name: CACuentasBitacoraRenovacionDPF
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
CtaBitCorrelativo | uniqueidentifier | 16 | NO | NO |
|
CtaBitUsuario | char | 20 | NO | NO |
|
CtaBitFecha | datetime | 8 | NO | NO |
|
CtaBitInstruccionAnterior | smallint | 2 | NO | NO |
|
CtaBitInstruccionNueva | smallint | 2 | NO | NO |
|
CtaBitMontoAnterior | money | 8 | NO | NO |
|
CtaBitMontoNuevo | money | 8 | NO | NO |
|
Table Name: CADetalleMovtos
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
MoDNumMovto | int | 4 | NO | NO |
|
DeMCorrelativo | smallint | 2 | NO | NO |
|
DeMCampo | smallint | 2 | NO | NO |
|
DeMCtaNumero | char | 14 | NO | NO |
|
DeMValorTrx | money | 8 | NO | NO |
|
Table Name: CAEstadisticasCuenta
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
EstTrxCod | smallint | 2 | NO | NO |
|
SMeAnoMes | datetime | 8 | NO | NO |
|
EstNumTrx | smallint | 2 | NO | NO |
|
EstValTrx | money | 8 | NO | NO |
|
Table Name: CAFirXcuen
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
CafCorCta | smallint | 2 | NO | NO |
|
CaFCodEmp | smallint | 2 | YES | NO |
|
CaFCodSuc | smallint | 2 | YES | NO |
|
CaFPNombre | varchar | 75 | NO | NO |
|
CaFSNombre | varchar | 75 | YES | NO |
|
CaFPApellido | varchar | 75 | NO | NO |
|
CaFSApellido | varchar | 75 | YES | NO |
|
CaFApeCasa | varchar | 75 | YES | NO |
|
CaFFechaNac | datetime | 8 | NO | NO |
|
CaFNaciona | char | 35 | YES | NO |
|
CaFNit | char | 20 | YES | NO |
|
CaFTipCod | smallint | 2 | NO | NO |
|
CaFNumDoc | char | 15 | NO | NO |
|
CaFAptiValid | char | 1 | YES | NO |
|
CaFAptiProvalid | smallint | 2 | YES | NO |
|
CaFLugarEmi | char | 35 | YES | NO |
|
CaFDirec | varchar | 1024 | NO | NO |
|
CaFTelefono | char | 20 | NO | NO |
|
CaFFax | char | 20 | YES | NO |
|
CaFEmail | char | 35 | NO | NO |
|
CaFRelacion | char | 20 | NO | NO |
|
CaFFirma | varbinary | -1 | YES | NO |
|
CaFFirma_GXI | varchar | 2048 | YES | NO |
|
CaFCISocioNom | char | 60 | NO | NO |
|
CaFSexo | char | 1 | YES | NO |
|
CaFNomPropio | bit | 1 | YES | NO |
|
CaFCalidadActua | nvarchar | 200 | YES | NO |
|
CaFONombre | varchar | 75 | YES | NO |
|
CaFNacPaiCod | int | 4 | YES | NO |
|
CaFNacRegCod | int | 4 | YES | NO |
|
CaFNacDepCod | int | 4 | YES | NO |
|
CaFNacMunCod | int | 4 | YES | NO |
|
CaFCondicionMigratoria | smallint | 2 | YES | NO |
|
CaFDescMigratoria | varchar | 75 | YES | NO |
|
CaFEstCivil | smallint | 2 | YES | NO |
|
CaFProfesionOficio | nvarchar | 200 | YES | NO |
|
CaFPasPaiCod | int | 4 | YES | NO |
|
CaFDirPaiCod | int | 4 | YES | NO |
|
CaFDirRegCod | int | 4 | YES | NO |
|
CaFDirDepCod | int | 4 | YES | NO |
|
CaFDirMunCod | int | 4 | YES | NO |
|
CaFRepCliCod | int | 4 | YES | NO |
|
CaFNacionalidadDescripcion | char | 75 | YES | NO |
|
CaFNacionalidadCodigo | char | 10 | YES | NO |
|
CaFClCliCod | int | 4 | YES | NO |
|
CaFechaVinculacion | datetime | 8 | YES | NO |
|
CaFObservacionVinculacion | varchar | 200 | YES | NO |
|
Table Name: CAHSalDiarios
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
HSDiFecha | datetime | 8 | NO | NO |
|
HSDiSalContable | money | 8 | NO | NO |
|
HSDiSalReserva | money | 8 | NO | NO |
|
HSDiTasa | decimal | 5 | NO | NO |
|
HSDiTasaSob | decimal | 5 | NO | NO |
|
Table Name: CALibretas
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
LibNumero | int | 4 | NO | NO |
|
LibEstado | char | 1 | NO | NO |
|
LibFecEntrega | datetime | 8 | NO | NO |
|
LibFecInactivacion | datetime | 8 | NO | NO |
|
Table Name: CAModCuentas
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
ModSecuencia | smallint | 2 | NO | NO |
|
ModFecModificacion | datetime | 8 | NO | NO |
|
ModEnvCor | smallint | 2 | YES | NO |
|
ModClCliCod | int | 4 | YES | NO |
|
ModClDirCod | smallint | 2 | YES | NO |
|
ModFirRegistradas | smallint | 2 | YES | NO |
|
ModFirRequeridas | smallint | 2 | YES | NO |
|
ModFreCod | smallint | 2 | YES | NO |
|
ModCuotaMensual | money | 8 | YES | NO |
|
ModUsuMod | varchar | 100 | YES | NO |
|
ModFPagoCap | smallint | 2 | YES | NO |
|
ModFPagoInt | smallint | 2 | YES | NO |
|
ModCtaCredito | char | 14 | YES | NO |
|
ModDescripcion | varchar | -1 | YES | NO |
|
ModCtaReferencia | char | 14 | YES | NO |
|
ModCtaCondEspeciales | char | 1 | YES | NO |
|
ModCtaFrePlanilla | smallint | 2 | YES | NO |
|
ModCtaCredVista | char | 14 | YES | NO |
|
ModCtaNumCertificado | char | 30 | YES | NO |
|
ModCtaPlazoDepositos | smallint | 2 | YES | NO |
|
ModCtaFecVencimiento | datetime | 8 | YES | NO |
|
ModCtaTasaFoV | char | 1 | YES | NO |
|
ModCtaFecProximoPago | datetime | 8 | YES | NO |
|
Table Name: CAMovDiario
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
MoDNumMovto | int | 4 | NO | NO |
|
MoDEmpCod | smalllint | 2 | NO | NO |
|
MoDSucCod | smallint | 2 | YES | NO |
|
MoDUsuCod | varchar | 100 | NO | NO |
|
ApTrxCod | smallint | 2 | NO | NO |
|
MoDFecTrx | datetime | 8 | NO | NO |
|
MoDHorTrx | char | 8 | NO | NO |
|
CtaNumero | char | 14 | NO | NO |
|
MoDFecVal | datetime | 8 | NO | NO |
|
MoDNroDocto | int | 4 | NO | NO |
|
MoDValorTrx | money | 8 | NO | NO |
|
MoDConLibreta | char | 1 | NO | NO |
|
MoDSpread | decimal | 5 | NO | NO |
|
MoDIntMes | money | 8 | NO | NO |
|
MoDIntAcum | money | 8 | NO | NO |
|
MoDImpMes | money | 8 | NO | NO |
|
MoDImpAcum | money | 8 | NO | NO |
|
MoDMonPen | money | 8 | NO | NO |
|
MoDEstTrx | smallint | 2 | NO | NO |
|
MoDNumOrigen | int | 4 | YES | NO |
|
MoDFecUltMov | datetime | 8 | NO | NO |
|
MoDForPago | smallint | 2 | NO | NO |
|
MoDMonCancelado | money | 8 | NO | NO |
|
MoDMovCaj | int | 4 | NO | NO |
|
MoDReferencia | char | 250 | NO | NO |
|
MoDApTCCodigo | decimal | 9 | NO | NO |
|
MoDTrxBkOffice | char | 1 | NO | NO |
|
MoDUsuSup | char | 10 | NO | NO |
|
MoDApBlqCod | smallint | 2 | YES | NO |
|
MoDPartida | decimal | 9 | NO | NO |
|
MoDTrxBancario | smallint | 2 | YES | NO |
|
MoDContabilizado | char | 1 | YES | NO |
|
MoDNotificacion | smallint | 2 | YES | NO |
|
Table Name: CAMovMensual
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
MoMFecVal | datetime | 8 | NO | NO |
|
MoMNumMovto | int | 4 | NO | NO |
|
MoMEmpCodigo | smallint | 2 | NO | NO |
|
MoMSucCodigo | smallint | 2 | YES | NO |
|
MoMUsuCod | varchar | 100 | YES | NO |
|
MoMTrxCod | smallint | 2 | NO | NO |
|
MoMFecTrx | datetime | 8 | NO | NO |
|
MoMHorTrx | char | 8 | NO | NO |
|
MoMValor | money | 8 | NO | NO |
|
MoMNumDoc | int | 4 | NO | NO |
|
MoMSpread | decimal | 5 | NO | NO |
|
MoMReferencia | char | 250 | NO | NO |
|
MoMConLibreta | char | 1 | NO | NO |
|
MoMIntMes | money | 8 | NO | NO |
|
MoMIntAcum | money | 8 | NO | NO |
|
MoMImpMes | money | 8 | NO | NO |
|
MoMImpAcum | money | 8 | NO | NO |
|
MoMMonPen | money | 8 | NO | NO |
|
MoMEstTrx | smallint | 2 | NO | NO |
|
MoMNumOrigen | int | 4 | YES | NO |
|
MoMFecUltMov | datetime | 8 | NO | NO |
|
MoMForPago | smallint | 2 | NO | NO |
|
MoMMonCancelado | money | 8 | NO | NO |
|
MoMMovCaja | int | 4 | NO | NO |
|
MoMApTCCodigo | decimal | 9 | NO | NO |
|
MoMTrxBkOffice | char | 1 | NO | NO |
|
MoMUsuSup | char | 10 | NO | NO |
|
MoMApBlqCod | smallint | 2 | NO | NO |
|
MoMPartida | decimal | 9 | NO | NO |
|
MoMTrxBancario | smallint | 2 | YES | NO |
|
MoMContabilizado | char | 1 | YES | NO |
|
Table Name: CAMovPendiente
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
MoPCorrelativo | decimal | 9 | NO | NO |
|
MoPTrxCod | smallint | 2 | NO | NO |
|
MoPNumMovto | int | 4 | NO | NO |
|
MoPUsuCod | varchar | 100 | NO | NO |
|
MoPFecVal | datetime | 8 | NO | NO |
|
MoPHora | char | 8 | NO | NO |
|
MoPValor | money | 8 | NO | NO |
|
MoPImpreso | char | 1 | NO | NO |
|
Table Name: CAParti1
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
ParEmpCodigo | smallint | 2 | NO | NO |
|
ParPrdCod | smallint | 2 | NO | NO |
|
ParSubCod | smallint | 2 | NO | NO |
|
ParSucCodigo | smallint | 2 | NO | NO |
|
ParTrxCod | smallint | 2 | NO | NO |
|
ParParFoPa | smallint | 2 | NO | NO |
|
ParCorrel | int | 4 | NO | NO |
|
DetCuenta | char | 20 | NO | NO |
|
DetDebCre | char | 2 | NO | NO |
|
DetMonto | money | 8 | NO | NO |
|
DetDocRef | int | 4 | NO | NO |
|
Table Name: CAPartidas
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
ParEmpCodigo | smallint | 2 | NO | NO |
|
ParPrdCod | smallint | 2 | NO | NO |
|
ParSubCod | smallint | 2 | NO | NO |
|
ParSucCodigo | smallint | 2 | NO | NO |
|
ParTrxCod | smallint | 2 | NO | NO |
|
ParParFoPa | smallint | 2 | NO | NO |
|
ParCorrel | int | 4 | NO | NO |
|
ParUsuCod | char | 10 | NO | NO |
|
ParFecMovimiento | datetime | 8 | NO | NO |
|
ParFecValor | datetime | 8 | NO | NO |
|
ParDescripcion | char | 60 | NO | NO |
|
ParTipPartida | char | 3 | NO | NO |
|
ParMonCod | smallint | 2 | NO | NO |
|
ParPaTraConta | char | 1 | NO | NO |
|
Table Name: CarCatalogo
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CarCtCodig | smallint | 2 | NO | NO |
|
CarCtDesc | char | 50 | NO | NO |
|
CarCtaModulo | char | 3 | NO | NO |
|
ApEmpCodigo | smallint | 2 | NO | NO |
|
CtCatCod | smallint | 2 | NO | NO |
|
CtTipValidar | smallint | 2 | NO | NO |
|
Table Name: CAResCta
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
ResFechaDep | datetime | 8 | NO | NO |
|
ApPResCod | smallint | 2 | NO | NO |
|
ResMonto | money | 8 | NO | NO |
|
ResDiasFaltan | smallint | 2 | NO | NO |
|
Table Name: CASalDiarios
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
SDiFecha | datetime | 8 | NO | NO |
|
SDiSalContable | money | 8 | NO | NO |
|
SDiSalReserva | money | 8 | NO | NO |
|
SDiTasa | decimal | 5 | NO | NO |
|
SDiTasaSob | decimal | 5 | NO | NO |
|
Table Name: CASalMensuales
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
SMeAnoMes | datetime | 8 | NO | NO |
|
SMeTasaBase | decimal | 5 | NO | NO |
|
SMeTasaSpread | decimal | 5 | NO | NO |
|
SMeSalTotal | money | 8 | NO | NO |
|
SMeSReserva | money | 8 | NO | NO |
|
SMeSDisponible | money | 8 | NO | NO |
|
SMeSobAuto | money | 8 | NO | NO |
|
SMeIntMes | money | 8 | NO | NO |
|
SMeIntAcumulado | money | 8 | NO | NO |
|
SMeImpMes | money | 8 | NO | NO |
|
SMeImpAcumulado | money | 8 | NO | NO |
|
SMeInSoMes | money | 8 | NO | NO |
|
SMeInSoAcumulado | money | 8 | NO | NO |
|
SMeSalPromedio | money | 8 | NO | NO |
|
SMeMinMes | money | 8 | NO | NO |
|
SMeSalAnterior | money | 8 | NO | NO |
|
SMeSalLibreta | money | 8 | NO | NO |
|
SMeSalConsultado | money | 8 | NO | NO |
|
SMeSalMonedaLocal | money | 8 | YES | NO |
|
SMeSalMonedaExtranjera | money | 8 | YES | NO |
|
Table Name: CASobAutorizados
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
SobCorrelativo | smallint | 2 | NO | NO |
|
SobValor | money | 8 | NO | NO |
|
SobFecVen | datetime | 8 | NO | NO |
|
SobSpread | decimal | 5 | NO | NO |
|
SobFecAut | datetime | 8 | NO | NO |
|
SobUsuCod | char | 10 | NO | NO |
|
Table Name: CASolChequeras
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CtaNumero | char | 14 | NO | NO |
|
SolCodigo | smallint | 2 | NO | NO |
|
SolNombre | char | 40 | NO | NO |
|
ApCheCod | smallint | 2 | NO | NO |
|
SolCantChequeras | smallint | 2 | NO | NO |
|
SolFecSolicitud | datetime | 8 | NO | NO |
|
SolEmpCod | smallint | 2 | NO | NO |
|
SolSucCod | smalllint | 2 | NO | NO |
|
SolUsuEnt | varchar | 100 | NO | NO |
|
SolFecEntrega | datetime | 8 | NO | NO |
|
SolCheIni | int | 4 | NO | NO |
|
SolNumCheques | int | 4 | NO | NO |
|
Table Name: CATmp01
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CAT01Uniq | char | 10 | NO | NO |
|
CAT01EmpC | smallint | 2 | NO | NO |
|
CAT01PrdC | smallint | 2 | NO | NO |
|
CAT01SubC | smallint | 2 | NO | NO |
|
CAT01TrxC | smallint | 2 | NO | NO |
|
CAT01TrxN | int | 4 | NO | NO |
|
CAT01SucC | smallint | 2 | NO | NO |
|
CAT01CtaN | char | 14 | NO | NO |
|
CAT01FecT | datetime | 8 | NO | NO |
|
CAT01HorT | char | 8 | NO | NO |
|
CAT01ValT | money | 8 | NO | NO |
|
CAT01Natu | smallint | 10 | NO | NO |
|
CAT01NomC | char | 40 | NO | NO |
|
CAT01SalC | money | 2 | NO | NO |
|
CAT01UsuC | char | 2 | NO | NO |
|
CAT01Referencia | char | 1 | NO | NO |
|
Table Name: TCaListaVerificacionValor
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CaListaVerificacionValor_Correlativo | uniqueidentifier | 16 | NO | NO |
|
CaListaVerificacionValor_CtaNumero | char | 14 | NO | NO |
|
CaListaVerificacionValor_ListaDetalleCodigo | smallint | 2 | YES | NO |
|
CaListaVerificacionValor_ListaDetalleSecuencia | smallint | 2 | YES | NO |
|
CaListaVerificacionValor_ListaNombre | char | 50 | YES | NO |
|
CaListaVerificacionValor_ListaDetalleNombre | char | 50 | YES | NO |
|
CaListaVerificacionValor_Marcado | bit | 1 | NO | NO |
|
CaListaVerificacionValor_Ingreso_ApUsuCod | varchar | 100 | YES | NO |
|
CaListaVerificacionValor_Fecha | datetime | 8 | YES | NO |
|
CaListaVerificacionValor_Modificacion_ApUsuCod | varchar | 100 | YES | NO |
|
CaListaVerificacionValor_Modificacion_Fecha | datetime | 8 | YES | NO |
|
Table Name: TCATmp02
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CAT02Fila | int | 4 | NO | NO |
|
CAT02ClNumId | varchar | 50 | NO | NO |
|
CAT02NomSocio | varchar | 600 | NO | NO |
|
(c) 2020 por SIFC.O, S.A.