A continuación encontrará las tablas de datos que definen la parametrización del sistema.

Table Name: ApActividadEconomica

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApActCod	smallint	2	NO	YES
ApActDes	char	75	NO	NO
ApActPadreCod	smallint	2	YES	NO
ApActRef	char	50	YES	NO

Table Name: ApAseguradoras

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApAseCod	smallint	2	NO	YES
ApAseNombre	char	40	NO	NO
ApAseDireccion	varchar	1024	NO	NO
ApAseTel	char	20	NO	NO
ApAseFax	char	20	NO	NO
ApAseContacto	char	100	NO	NO

Table Name: ApAuxiliares

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
TiAuCodigo	smallint	2	NO	NO
AuxCodigo	int	4	NO	NO
AuxDescripcion	char	40	NO	NO

Table Name: ApBancos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApBanCod	smallint	2	NO	YES
ApBanNombre	char	40	NO	NO
ApBanDireccion	varchar	1024	NO	NO
ApBanTel	char	20	NO	NO
ApBanFax	char	20	NO	NO
ApBanContacto	varchar	100	NO	NO
ApBanCodCompe	smallint	2	YES	NO
ApBanColNumBoleta	smallint	2	YES	NO
ApBanColMontoBoleta	smallint	2	YES	NO
ApBanColCodCliente	smallint	2	YES	NO
ApBanRptNombre	char	80	YES	NO
ApBanRef1	char	256	YES	NO
ApBanRef2	char	256	YES	NO
ApBanRef3	char	256	YES	NO
ApBanRef4	char	256	YES	NO
ApBanRef5	char	256	YES	NO

Table Name: ApBitacora

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApBitacora_CodigoUsuario	varchar	100	NO	NO
ApBitacora_CodigoPrograma	char	8	NO	NO
ApBitacora_Correlativo	decimal	9	NO	NO
ApBitacora_Operacion	smallint	2	NO	NO
ApBitacora_Fecha	datetime	8	NO	NO
ApBitacora_Hora	char	8	NO	NO

Table Name: ApBitClientes

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApBiCIFec	datetime	8	NO	NO
ApBiCIHor	char	8	NO	NO
ApBiCIUsu	char	10	NO	NO
ApBiCICod	int	4	NO	NO
ApBiCINom	char	60	NO	NO

Table Name: ApBkOffice

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
BkOfApEmpCodigo	smallint	2	NO	NO
BkOfTrxDeposito	smallint	2	NO	NO
BkOfTrxRetiro	smallint	2	NO	NO
BkOfSerIngreso	char	4	YES	NO
BkOfTrxAcreditacionPrestamo	smallint	2	NO	NO
BkOfCorIngreso	smallint	2	YES	NO
BkOfSerEgreso	char	4	YES	NO
BkOfCorEgreso	smallint	2	YES	NO
BkOfApSucCodigo	smallint	2	YES	NO
BkOfTrxDepositoTrxMasiva	smallint	2	YES	NO
BkOfTrxRetiroTrxMasiva	smallint	2	YES	NO
BkOfTrxDepositoTrxOtros	smallint	2	YES	NO
BkOfRetiroTrxOtros	smallint	2	YES	NO
BkOfTrxDevolucion	smallint	2	YES	NO
BkOfTrxDepositoFallido	smallint	2	YES	NO

Table Name: ApBkOfficeColocaciones

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApBkOfficeColocacionesEmpresaCodigo	smallint	2	NO	NO
ApBkOfficeColocacionesRTrxCanelaCodigo	smallint	2	YES	NO
ApBkOfficeColocacionesDesInstruccionesActivo	bit	1	YES	NO
ApBkOfficeColocacionesDesInstruccionesNotifica	bit	1	YES	NO
ApBkOfficeColocacionesDesInstruccionesEMail	varchar	100	YES	NO
ApBkOfficeColocacionesDesInstruccionesAsunto	varchar	128	YES	NO
ApBkOfficeColocacionesDesInstruccionesMensaje	varchar	-1	YES	NO
ApBkOfficeColocacionesEditarGarantias	bit	1	YES	NO
ApBkOfficeColocacionesGarantiasId3	smallint	2	YES	NO
ApBkOfficeColocacionesGarantiasId2	smallint	2	YES	NO
ApBkOfficeColocacionesGarantiasId1	smallint	2	YES	NO
ApBkOfficeColocacionesGarantiasCopia	smallint	2	YES	NO

Table Name: ApBloqueoCausa

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApBlqCod	smallint	2	NO	YES
ApBlqDes	char	30	NO	NO
ApBlqAutoriza	char	1	NO	NO
ApBlqInaLibreta	char	1	NO	NO
ApBlqCalInteres	char	1	NO	NO
ApBlqPagInteres	char	1	NO	NO

Table Name: ApCajCod

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
ApCajRecCodigo	smallint	2	NO	NO
ApCamCod	smallint	2	NO	NO
ApParDoC	char	1	NO	NO
CatNumCta	char	20	NO	NO
ApPaCCuentaBancariaCaja	bit	1	NO	NO
ApCajCuentaCatalogo	char	40	YES	NO

Table Name: ApCajContab

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
ApCajRecCodigo	smallint	2	NO	NO

Table Name: ApCajReceptora

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApCajRecCodigo	smallint	2	NO	NO
ApCajRecDescripcion	char	100	NO	NO
ApCajRecEstado	char	1	NO	NO

Table Name: ApCajReceptoraCuentaContable

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApCajRecCodigo	smallint	2	NO	NO
ApCajCuentaContableDetalle_Moneda	smallint	2	NO	NO
ApCajCuentaContableDetalle_Cuenta	char	40	NO	NO

Table Name: ApCalifAdicionales

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCalCod	smallint	2	NO	YES
ApCalEti	char	20	NO	NO
ApCalDes	varchar	256	NO	NO
ApCalTipo	smallint	2	NO	NO
ApCalAplica	char	1	NO	NO
ApCalObligatorio	smallint	2	NO	NO
ApCalIdentificador	varchar	250	YES	NO
ApCalClasificacion	varchar	250	YES	NO
ApCalDescripcionClasificacion	varchar	-1	YES	NO

Table Name: ApCampos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCamCod	smallint	2	NO	NO
ApCamDes	char	30	NO	NO
ApCamClase	smallint	2	NO	NO
ApCamEti	char	20	NO	NO
ApCamTipo	char	1	NO	NO
ApPResCod	smallint	2	YES	NO
ApCamModifica	char	1	NO	NO
ApCamNoVisible	char	1	YES	NO

Table Name: ApCamTransa

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApCamCod	smallint	2	NO	NO
ApCtxOrden	smallint	2	NO	NO

Table Name: ApCancelaCausa

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApCanCod	smallint	2	NO	YES
ApCanDes	char	30	NO	NO

Table Name: ApCapCoD

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApSubCod	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApParFoPa	smallint	2	NO	NO
ApParRubro	smallint	2	NO	NO
ApPaCDoC	char	1	NO	NO
CatNumCta	char	20	NO	NO
ApPaCCuentaBancariaCaptaciones	bit	1	NO	NO

Table Name: ApCapContables

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApSubCod	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApParFoPa	smallint	2	NO	NO

Table Name: ApCaptacionProductos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApSubCod	smallint	2	NO	NO
ApSubDes	char	40	NO	NO
ApMonCod	smallint	2	NO	NO
ApSubHistoria	smallint	2	NO	NO
ApSubCance	smallint	2	NO	NO
ApSubInactiva	smallint	2	NO	NO
ApSubTipo	smallint	2	NO	NO
ApSubDocumento	smallint	2	NO	NO
ApsubSob	char	1	NO	NO
ApSubTSob	smallint	2	YES	NO
ApSubRet	char	1	NO	NO
ApSubInt	char	1	NO	NO
ApSubImp	char	1	NO	NO
ApSubTimp	smallmoney	4	YES	NO
ApSubBasCal	char	2	YES	NO
ApSubTTas	smallint	2	YES	NO
ApSubTInt	smallint	2	YES	NO
ApSubForP	smallint	2	YES	NO
ApSubFreCod	smallint	2	YES	NO
ApSubMes	smallint	2	NO	NO
ApSubAno	smallint	2	NO	NO
ApSubProvision	smallint	2	NO	NO
ApSubPenaliza	char	1	NO	NO
ApSubPorPena	smallmoney	4	NO	NO
ApSubCMinima	money	8	NO	NO
ApSubFPago	char	1	NO	NO
ApSubLMinimo	money	8	NO	NO
ApSubSolicitud	char	1	NO	NO
ApSubRInteres	char	1	NO	NO
ApSubAprobacion	char	1	NO	NO
ApSubLiRepetida	char	1	NO	NO
ApSubCreaAportacion	char	1	NO	NO
ApSubCAhorro	char	1	NO	NO
ApSubApLPenaliza	smallint	2	NO	NO
ApSubMinPlazoDeposito	smallint	2	NO	NO
ApSubMaxPlazoDeposito	smallint	2	NO	NO
ApSubPorta_Permite	bit	1	YES	NO
ApSubPortal_TituloProducto	char	100	YES	NO
ApSubPortal_Imagen	varbinary	-1	YES	NO
ApSubPortal_Imagen_GXI	varchar	204	YES	NO
ApSubPortal_MostrarNumeroCuenta	bit	1	YES	NO
ApSubPortal_MostrarSaldo	bit	1	YES	NO
ApSubPortal_MostrarIntereses	bit	1	YES	NO
ApSubPortal_MostrarDepositos	bit	1	YES	NO
ApSubPortal_MostrarRetiros	bit	1	YES	NO
ApSubPortal_PermiteRetiros	char	20	YES	NO
ApSubPortal_PermiteRetirosAprobacion	bit	1	YES	NO
ApSubPortal_RetirosPoliticaDescripcion	varchar	-1	YES	NO
ApSubPortal_PermitePagosPrestamos	bit	1	YES	NO
ApSubPortal_PermiteCambiosDescuento	char	20	YES	NO
ApSubPortal_RetirosSolicitaDocumento	bit	1	YES	NO
ApSubPortal_RetirosFormato_ApEmpCodigo	smallint	2	YES	NO
ApSubPortal_RetirosFormato_ID	char	20	YES	NO
ApSubPortal_RetirosFormato_Correlativo	smallint	2	YES	NO
ApSubPortal_RetirosExpedienteID	smallint	2	YES	NO
ApSubPortal_DescuentosFormato_ApEmpCodigo	smallint	2	YES	NO
ApSubPortal_DescuentosFormato_ID	char	20	YES	NO
ApSubPortal_DescuentosFormato_Correlativo	smallint	2	YES	NO
ApSubPortal_DescuentosSolicitaDocumento	bit	1	YES	NO
ApSubPortal_DescuentosExpedienteID	smallint	2	YES	NO
ApSubPortal_DescuentosPoliticaDescripcion	varchar	-1	YES	NO
ApSubPenalizaInteresRetiro	bit	1	YES	NO
ApSubPenalizaInteresRetiroForma	smallint	2	YES	NO
ApSubPenalizaInteresRetiroCantidad	decimal	9	YES	NO
ApSubPenalizaInteresRetiroComo	smallint	2	YES	NO
ApSubPenalizaInteresRetiroComoValor	decimal	9	YES	NO
ApSubPortal_MostrarTasa	bit	1	YES	NO
ApSubPortal_MostrarFechaVencimiento	bit	1	YES	NO
ApSubImpuestoComparacion	char	2	YES	NO
ApSubImpuestoIndicador	money	8	YES	NO
ApSubRequiereActivacionIntereses	bit	1	YES	NO
ApSubDiasActivacionCalculaIntereses	smallint	2	YES	NO
ApSubDiasActivacionCalculaInteresesTipo	smallint	2	YES	NO
ApsubRegistraCuotasVencidas	char	1	YES	NO
ApSubCantidadCuotasEnPlan	smallint	2	YES	NO
ApSubMesesParaCuotaVencida	smallint	2	YES	NO
ApSubGeneraCuota	char	1	YES	NO

Table Name: ApCargo

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApCarCod	smallint	2	NO	NO
ApCarDes	char	30	NO	NO
ApCarForma	smallint	2	NO	NO
ApCarNumTrx	smallint	2	NO	NO
ApCarTrx	smallint	2	YES	NO
ApCarSaldo	char	2	NO	NO
ApCarSaBa	money	8	NO	NO
ApCarMonto	money	8	NO	NO
ApTrxCod3	smallint	2	YES	NO

Table Name: ApCatCreditos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCaCCod	smallint	2	NO	YES
ApCaCCuoApCaCDes	char	30	NO	NO
ApCaCCuo	smallint	2	NO	NO

Table Name: ApCategoAso

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApCatCod	smallint	2	NO	NO
ApCatDes	char	30	NO	NO

Table Name: ApCaXSa1

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CaTrxCod	smallint	2	NO	NO
ApSalCod	smallint	2	NO	NO
ApCatPaDoC	char	1	NO	NO
ApCatPaBancario	char	1	NO	NO

Table Name: ApCaXSaI

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CaTrxCod	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO

Table Name: ApCierre

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApModCod	char	2	NO	NO
ApCieFecHoy	datetime	8	NO	NO
ApCieEstado	char	1	NO	NO
ApCieUltProceso	char	1	NO	NO
ApCieUsuario	varchar	100	NO	NO
ApCieFecVal	datetime	8	NO	NO
ApCieHrVal	char	10	NO	NO
ApCieNoVeces	smallint	2	NO	NO

Table Name: ApCjParametros

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCjParametrosEmpresaCodigo	smallint	2	NO	NO
ApCjParametrosTransaccionesMultimoneda	bit	1	NO	NO
ApCjParametrosTrxMultimonedaCompraCodigo	smallint	2	YES	NO
ApCjParametrosTrxMultimonedaVentaCodigo	smallint	2	YES	NO
ApCjParametrosValidacionExpresionUsuario_ID	int	4	YES	NO
ApCjParametrosTrasladosCajaBoveda	bit	1	YES	NO
ApCjParametrosHabilitaTrasEntreBovedasSucursales	bit	1	YES	NO
ApCjParametrosValidarEfectivoDisponible	bit	1	YES	NO

Table Name: ApCobradores

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCobCod	varchar	100	NO	NO
ApCobNombres	varchar	75	NO	NO
ApCobTipo	char	1	NO	NO
ApCobFechaIng	datetime	8	NO	NO
ApCobSupervisor	varchar	100	YES	NO
ApCobActivo	bit	1	NO	NO
ApCobCarteraAsignacion	bit	1	YES	NO
ApCobOrdenAsigAutomatica	int	4	YES	NO

Table Name: ApCobradoresCalificadoresAdicionales

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCobradorCod	varchar	100	NO	NO
ApCobradorApCalCod	smallint	2	NO	NO
ApCobradorCalVNum	decimal	9	NO	NO
ApCobradorCalVAlfa	varchar	254	NO	NO
ApCobradorCalVFecha	datetime	8	NO	NO
ApCobradorCalVCaracter	char	30	NO	NO

Table Name: ApCodAprobacion

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApAprCod	smallint	2	NO	NO
ApAprDes	char	30	NO	NO
ApAprLimites	char	1	NO	NO
ApAprMinimo	money	8	YES	NO
ApAprMaximo	money	8	YES	NO
ApEmpCodigo	smallint	2	YES	NO

Table Name: ApColCo

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApGarCod	smallint	2	NO	NO
ApOrgCod	smallint	2	NO	NO
ApEsCoAct	char	2	NO	NO
ApEsCoAnt	char	2	NO	NO
ApAjuCod	smallint	2	NO	NO
ApCaCoAct	smallint	2	NO	NO
ApCaCoAnt	smallint	2	NO	NO
ApCoPFoPag	smallint	2	NO	NO
ApCoPFoDes	smallint	2	NO	NO

Table Name: ApColCoD

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApGarCod	smallint	2	NO	NO
ApesCoAct	char	2	NO	NO
ApEsCoAnt	char	2	NO	NO
ApAjuCod	smallint	2	NO	NO
ApCaCoAct	smallint	2	NO	NO
ApCaCoAnt	smallint	2	NO	NO
ApCoPFoPag	smallint	2	NO	NO
ApCoPFoDes	smallint	2	NO	NO
CatNumCta	char	20	NO	NO
ApSalCod	smallint	2	NO	NO
ApCoPaDoC	char	1	NO	NO

Table Name: ApColocacionProductos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApColDes	char	40	NO	NO
ApMonCod	smallint	2	NO	NO
ApColTCInt	smallint	2	NO	NO
ApColTMin	smallmoney	4	NO	NO
ApColTMax	smallmoney	4	NO	NO
ApColProvision	smallint	2	NO	NO
ApColTTMor	smallint	2	NO	NO
ApColTCMora	smallint	2	YES	NO
ApColFMor	smallint	2	YES	NO
ApColDGracia	smallint	2	YES	NO
ApColDSusp	smallint	2	YES	NO
ApColMes	smallint	2	NO	NO
ApColAno	smallint	2	NO	NO
ApTPolCod	smallint	2	YES	NO
ApColMFija	money	8	NO	NO
ApColIPIntereses	char	1	NO	NO
ApColAport	char	1	NO	NO
ApColVeces	smallmoney	4	NO	NO
ApColMontMaximo	money	8	NO	NO
ApColTasaFoV	char	1	NO	NO
ApColFacPlazo	smallint	2	NO	NO
ApColPlazo	smallint	2	NO	NO
ApColMora	char	1	NO	NO
ApColEstado	bit	1	NO	NO
ApColEncuestaDesempenoSocialObligatoria	smallint	2	NO	NO
ApColEncuestaDesempenoSocialCod	smallint	2	YES	NO
ApColEncuestaDesempenoSocialParametroDias	smallint	2	YES	NO
ApColDiassuspenderMora	smallint	2	YES	NO
ApColCalculoInteresesCancelacion	smallint	2	YES	NO
ApColFactoring	bit	1	YES	NO
ApColFactoring_CompraPorcentaje	smallmoney	4	YES	NO
ApColFactoring_PrestamoRegistro	char	15	YES	NO
ApColFactoring_DeudorTipoOperacion	char	20	YES	NO
ApColFactoring_TasaDescuento	smallmoney	4	YES	NO
ApColFactoring_TasaDescuentoExpresionID	int	4	YES	NO
ApColFactoring_MontoCompraExtensionID	int	4	YES	NO
ApColReestructuraTipo	smallint	2	YES	NO
ApColMoraCalculoExpresionPersonalizada	bit	1	YES	NO
ApColMoraCalculoExpresionForma	smallint	2	YES	NO
ApColMoraCalculoExpresionID	int	4	YES	NO
ApColPagosMoviles	bit	1	YES	NO
ApColBaseCalculoComercial	bit	1	YES	NO

Table Name: ApConvenios

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApConCod	smallint	2	NO	NO
ApConNom	char	40	NO	NO
ApConDir	char	50	NO	NO
ApConTel	char	20	NO	NO
ApConCon	char	40	NO	NO
ApConCita	char	14	NO	NO
APConUltPlanilla	smallint	2	NO	NO

Table Name: ApCooperativas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCooCod	smallint	2	NO	NO
ApCooNombre	char	40	NO	NO
ApCooDireccion	char	50	NO	NO
ApCooSdaDirecc	char	50	NO	NO
ApCooTel	char	20	NO	NO
ApCooFax	char	20	NO	NO
ApCooContrato	char	30	NO	NO
ApCooLimDeb	money	8	NO	NO

Table Name: ApCorDocumento

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCorSucCod	smallint	2	NO	NO
ApCorSerie	char	4	NO	NO
ApCorCorrelativo	smallint	2	NO	NO
ApCorSucDes	char	40	NO	NO
ApCorRInicial	decimal	9	NO	NO
ApCorRFinal	decimal	9	NO	NO
ApCorSiguiente	decimal	9	NO	NO
ApCorResolucion	char	150	NO	NO
ApCorFResolucion	datetime	8	NO	NO
ApCorUsuario	varchar	100	NO	NO
ApCorDescripcion	char	150	NO	NO
ApCorForImpresion	char	150	NO	NO
ApCorEstado	char	1	NO	NO
ApCorPrefijo	char	20	NO	NO
ApCorUsModifico	varchar	100	NO	NO

Table Name: ApCorrelativos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCorCod	char	8	NO	NO
ApCorDes	char	30	NO	NO
ApCorUlt	decimal	9	NO	NO

Table Name: ApCrCalDetalle

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCrCalCod	smallint	2	NO	NO
ApCrValCal	decimal	9	NO	NO
ApCrValdesc	char	30	NO	NO

Table Name: ApCrCalificadores

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCrCalCod	smallint	2	NO	YES
ApCrCalDes	varchar	256	NO	NO
ApCrCalEti	char	20	NO	NO
ApCrCalTipo	smallint	2	NO	NO
ApCrCalObligatorio	smallint	2	NO	NO

Table Name: ApCrCance

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApCrCanCodigo	smallint	2	NO	YES
ApCrCanDescripcion	char	250	NO	NO

Table Name: ApCrCompromiso

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApCrCompromiso	smallint	2	NO	NO
ApCrCompromisoDescripcion	varchar	60	YES	NO

Table Name: ApCrPapeleria

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApCrPapCorrelativo	decimal	9	NO	NO
ApCrPapNombre	char	30	NO	NO
ApCrPapRpt	char	100	NO	NO
ApCrPapParametros	smallint	2	NO	NO

Table Name: ApDeduccionesProductoLevel1

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApDedCod	smallint	2	NO	NO
ApDedTipo	char	1	NO	NO
ApDedValor	money	8	NO	NO
ApDedPorcentaje	decimal	5	NO	NO
ApDedTodoDesem	char	1	NO	NO
ApDedAfectolva	char	1	NO	NO
ApDedAcreditarAhorros	char	1	NO	NO
ApDedFinanciarDeduccion	char	1	NO	NO
ApDedExpresionID	int	4	YES	NO
ApDedFactoring	bit	1	YES	NO
ApDedFactoringFormaDescuento	char	10	YES	NO
ApDedFactoringFormula	varchar	-1	YES	NO
ApDedFactoringExpresionID	int	4	YES	NO
ApDedFactoringFormaOperacion	char	10	YES	NO
ApDedPorcentajePermiteEditar	bit	1	YES	NO

Table Name: ApDeduccionesProductoLevel1Level2

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApDedCod	smallint	2	NO	NO
ApRaDeln	money	8	NO	NO
ApRaDeFi	money	8	NO	NO
ApRaDeVa	money	8	NO	NO

Table Name: ApDepartamento

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApPaiCod	int	4	NO	NO
ApRegCod	int	4	NO	NO
ApDepCod	int	4	NO	NO
ApDepDes	varchar	128	NO	NO
ApDepCodAlfa	char	10	YES	NO

Table Name: ApDocDetalle

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApDoc_ID	smallint	2	NO	YES
ApDoc_Tipo	smallint	2	NO	NO
ApDoc_Obligatorio	bit	1	NO	NO
ApDoc_Clase	smallint	2	NO	NO
ApDoc_EmpCodigo	smallint	2	YES	NO
ApDoc_Producto	smallint	2	YES	NO
ApDoc_PrdColocaciones	smallint	2	YES	NO
ApDoc_PrdColocacionesEmpCodigo	smallint	2	YES	NO
ApDoc_PrdColocacionesPrdCodigo	smallint	2	YES	NO
ApDoc_GarCod	smallint	2	YES	NO
ApDoc_CaptacionEmpCodigo	smallint	2	YES	NO
ApDoc_CaptacionPrdCodigo	smallint	2	YES	NO
ApDoc_CaptacionSubCodigo	smallint	2	YES	NO

Table Name: ApDocImpSubproductoColocacionesLevel1

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApDocImpCod	smallint	2	NO	NO

Table Name: ApDocProducto

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApDocCod	smallint	2	NO	NO

Table Name: ApDocTipoDet

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApDoc_Tipo	smallint	2	NO	NO
ApCalCodEE	smallint	2	NO	NO

Table Name: APDocuementosTipo

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApDoc_Tipo	smallint	2	NO	NO
APDocDescripcion	varchar	100	NO	NO
ApDocMultiple	bit	1	YES	NO
ApDocEsObligatorio	bit	1	YES	NO
ApDocEstadoActivo	bit	1	YES	NO

Table Name: ApDocumentos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApDocCod	smallint	2	NO	YES
ApDocDes	char	50	NO	NO

Table Name: ApDocumentosImprimir

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApDocImpCod	smallint	2	NO	YES
ApDocImpDes	varchar	40	NO	NO
ApDocAccion	char	20	NO	NO
ApDocTipo	char	10	NO	NO
ApDocCrystalReports	varchar	500	YES	NO
ApDocReportingServices	varchar	500	YES	NO
ApDocJasperReports	varchar	500	YES	NO
ApDocFormatoSifco	smallint	2	NO	NO

Table Name: ApEmpresa

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApEmpNombre	char	40	NO	NO
ApEmpGerente	char	40	NO	NO
ApEmpEncabezado	char	50	NO	NO
ApEmpDireccion	varchar	1024	NO	NO
ApEmpTel	char	20	NO	NO
ApEmpFax	char	20	NO	NO
ApEmpCor	varchar	100	NO	NO
ApEmpMonBase	smallint	2	NO	NO
ApEmpHeiLog	smallint	2	NO	NO
ApEmpWidLog	smallint	2	NO	NO
ApEmpFiH	smallint	2	NO	NO
ApEmpFiW	smallint	2	NO	NO
ApEmpFoH	smallint	2	NO	NO
ApEmpFoW	smallint	2	NO	NO
ApEmpBaH	smallint	2	NO	NO
ApEmpBaW	smallint	2	NO	NO
ApEmpBaNom	char	30	NO	NO
ApEmpBa2H	smallint	2	NO	NO
ApEmpBa2W	smallint	2	NO	NO
ApEmpBa2Nom	char	30	NO	NO
ApGAporta	char	1	NO	NO
ApGDCApo	int	4	NO	NO
ApGEstSocio	char	1	NO	NO
ApGVerSaldo	char	1	NO	NO
ApGTraPaAutomatico	char	1	NO	NO
ApEmpLogoColores	varbinary	-1	YES	NO
ApEmpLogoColores_GXI	varchar	2048	YES	NO
ApEmpLogoBW	varbinary	-1	YES	NO
ApEmpLogoBW_GXI	varchar	2048	YES	NO
ApEmpObservacion	varchar	1000	YES	NO
ApGExpPerfilTransValor	int	4	YES	NO
ApEmpHeader_PosWeb	varchar	-1	YES	NO
ApEmpToken_PosWeb	varchar	-1	YES	NO
ApEmpUrl_PosWeb	varchar	-1	YES	NO
ApEmpHeader2_PosWeb	varchar	-1	YES	NO
ApEmpToken2_PosWeb	varchar	-1	YES	NO
ApEmpUrl2_PosWeb	varchar	-1	YES	NO
ApEmpHeader3_PosWeb	varchar	-1	YES	NO
ApEmpToken3_PosWeb	varchar	-1	YES	NO
ApEmpUrl3_PosWeb	varchar	-1	YES	NO
ApEmpCtaCapObligatoria	bit	1	YES	NO
ApEmpDepositoCtaReceptoraOmision	bit	1	YES	NO
ApEmpDevolucionPagoCredito	bit	1	YES	NO
ApEmpNumMaximoCuotasForzadas	smallint	2	YES	NO

Table Name: ApEquivalencias

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod1	smallint	2	NO	NO
ApTrxCod2	smallint	2	NO	NO

Table Name: ApEstaCreditos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApEstCod	char	2	NO	NO
ApEstDes	char	30	NO	NO
ApEstCuo	smallint	2	NO	NO
ApEstID	smallint	2	NO	NO
ApEstCam	char	1	NO	NO

Table Name: ApEtapas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApEtpCod	smallint	2	NO	YES
ApEtpDes	char	50	NO	NO

Table Name: ApExternalCallOutDefinitions

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ExternalCallOutID	int	4	NO	YES
ExternalCallOutEvento	char	256	NO	NO
ExternalCallOutTransactions	smallint	2	NO	NO
ExternalCallOutModo	char	3	NO	NO
ExternalCallOutMetodo	smallint	2	NO	NO
ExternalCallOutURL	varchar	-1	NO	NO
ExternalCallOutSIFCOResponse	bit	1	NO	NO
ExternalCallOutJSON	varchar	-1	YES	NO
ExternalCallOutFormatoNotificarCorrelativo	smallint	2	YES	NO
ExternalCallOutFormatoNotificarID	char	20	YES	NO
ExternalCallOutFormatoNotificarEmpresa	smallint	2	YES	NO
ExternalCallOutGestorSeguridadID	smallint	2	YES	NO
ExternalCallOutExpExcepciones	int	4	YES	NO
ExternalCallOutExcepciones	bit	1	NO	NO
ExternalCallOutEjecucionProcesoEspecial	bit	1	YES	NO
ExternalCallOutNombreProcedimientoEspecial	char	200	YES	NO

Table Name: ApExternalCallOutDefinitionsHeaders

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ExternalCallOutID	int	4	NO	NO
ExternalCallOutHeaderID	smallint	2	NO	NO
ExternalCallOutHeaderNombre	char	75	NO	NO
ExternalCallOutHeaderValor	char	256	NO	NO

Table Name: ApExternalCallOutDefinitionsSecurity

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ExternalCallOutDefinitionsSecurityID	smallint	2	NO	YES
ExternalCallOutDefinitionsSecurityName	char	40	NO	NO
ExternalCallOutDefinitionsSecurityType	smallint	2	NO	NO
ExternalCallOutDefinitionsSecurityHeader	char	75	NO	NO
ExternalCallOutDefinitionsSecurityOauthWS	int	4	YES	NO
ExternalCallOutDefinitionsSecurityOauthPrefix	char	100	YES	NO
ExternalCallOutDefinitionsSecurityBasicPassword	char	50	YES	NO
ExternalCallOutDefinitionsSecurityBasicUser	char	30	YES	NO

Table Name: ApFecTasas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApTasCod	smallint	2	NO	NO
ApRaTaFecha	datetime	8	NO	NO

Table Name: ApFeriados

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApFerCorrelativo	smallint	2	NO	YES
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	YES	NO
ApFerTipo	char	1	NO	NO
ApFerDia	smallint	2	YES	NO
ApFerMes	smallint	2	YES	NO
ApFerDes	char	50	NO	NO
ApFerFecha	datetime	8	YES	NO

Table Name: ApFormas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApForCod	smallint	2	NO	NO
ApForNombre	char	30	NO	NO
ApCarAplicacion	char	15	NO	NO

Table Name: ApFormatoArchivoCarga

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
CrForArcCodigo	smallint	2	NO	YES
CrForArcDescrip	char	80	NO	NO
CrForArcTipo	smallint	2	NO	NO
CrForArcPrograma	char	8	NO	NO
CrArcColBoleta	smallint	2	NO	NO
CrArcColFecha	smallint	2	NO	NO
CrArcColMonto	smallint	2	NO	NO
CrArcColPrestamo	smallint	2	NO	NO
CrForArcNumDe	smallint	2	NO	NO
CrArcPIDia	smallint	2	NO	NO
CrArcPFDia	smallint	2	NO	NO
CrArcPIMes	smallint	2	NO	NO
CrArcPFMes	smallint	2	NO	NO
CrArcPIAnio	smallint	2	NO	NO
CrArcPFAnio	smallint	2	NO	NO
CrArcPIMonto	smallint	2	NO	NO
CrArcPFMonto	smallint	2	NO	NO
CrArcPIBoleta	smallint	2	NO	NO
CrArcPFBoleta	smallint	2	NO	NO
CrArcSiDivide	char	1	NO	NO
CrArcTamanio	int	4	NO	NO

Table Name: ApFrecCap

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApFreCod	smallint	2	NO	YES
ApFreDes	char	20	NO	NO
ApFrePer	char	1	NO	NO
ApFreNumP	smallint	2	NO	NO
ApFreFecha	datetime	8	NO	NO

Table Name: ApGarantias

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApGarCod	smallint	2	NO	YES
ApGarDes	char	30	NO	NO
ApGarReal	char	1	NO	NO
ApGarCalificadores	char	1	NO	NO
ApGarValor	char	1	NO	NO
ApGarDireccion	char	1	NO	NO
ApGarCuenta	char	1	NO	NO
ApGarDocumentosAdjuntos	char	1	NO	NO

Table Name: ApGarantiasCalificadores

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApGarCod	smallint	2	NO	NO
ApCalCod	smallint	2	NO	NO

Table Name: ApGranDivision

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApGrDCod	smallint	2	NO	YES
ApGrDDes	char	50	NO	NO
ApGrDCodAgrupacion	smallint	2	YES	NO
ApGrDReferencia	varchar	50	YES	NO

Table Name: ApInstituciones

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApInstituciones_IDInstitucion	int	4	NO	NO
ApInstituciones_TipoRegistro	varchar	1	NO	NO
ApInstituciones_Pais	int	4	NO	NO
ApInstituciones_Descripcion	char	400	NO	NO
IdInstitucionCargo	int	4	YES	NO

Table Name: ApListaVerificacion

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApListaVerificacion_Codigo	smallint	2	NO	YES
ApListaVerificacion_Nombre	char	50	NO	NO
ApListaVerificacion_Descripcion	char	256	YES	NO
ApListaVerificacion_Entidad	smallint	2	YES	NO
ApListaVerificacion_Activa	bit	1	YES	NO

Table Name: ApListaVerificacionDetalle

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApListaVerificacion_Codigo	smallint	2	NO	NO
ApListaVerificacionDetalle_Secuencia	smallint	2	NO	NO
ApListaVerificacionDetalle_Nombre	char	50	NO	NO
ApListaVerificacionDetalle_Obligatorio	bit	1	NO	NO

Table Name: ApMensajesParametros

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApNotificacionID	uniqueidentifier	16	NO	NO
ApNotificacionDescripcion	varchar	250	NO	NO
ApNotificacionVigente	bit	1	NO	NO
ApNotificacionProxima	datetime	8	NO	NO
ApNotificacionTipo	smallint	2	NO	NO
ApNotificacionConfiguracion	varchar	-1	YES	NO
ApNotificacionUltimoCambioPor	varchar	100	NO	NO
ApNotificacionFechaUltimoCambio	datetime	8	NO	NO
ApNotificacionRemitente	smallint	2	YES	NO

Table Name: ApMenuBarraTareas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApMenuBarraTareasID	int	4	NO	YES
ApMenuBarraTareasNombre	varchar	30	NO	NO
ApMenuBarraTareasDescripcion	varchar	100	NO	NO

Table Name: ApMenuBarraTareasOpciones

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApMenuBarraTareasID	int	4	NO	NO
ApMenuBarraTareasOpcionesOpcion	varchar	30	NO	NO
ApMenuBarraTareasOpcionesTipoAccion	smallint	2	NO	NO
ApMenuBarraTareasOpcionesAccion	varchar	150	NO	NO
ApMenuBarraTareasOpcionesPermiso	varchar	30	NO	NO
ApMenuBarraTareasOpcionesIcono_GXI	varchar	2048	YES	NO
ApMenuBarraTareasOpcionesIcono	varbinary	-1	YES	NO

Table Name: ApMenuBarraTareasOpcionesParametros

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApMenuBarraTareasID	int	4	NO	NO
ApMenuBarraTareasOpcionesOpcion	varchar	30	NO	NO
ApMBTOpcionesParametrosOrden	smallint	2	NO	NO
ApMBTOpcioinesParametrosNombreAtributo	char	50	NO	NO
ApMBTOpcionesParametrosValorPredet	varchar	50	YES	NO

Table Name: ApModulos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApModCod	char	2	NO	NO
ApModNom	char	40	NO	NO
ApModFechoy	datetime	8	NO	NO
ApModFecsig	datetime	8	NO	NO
ApModFecant	datetime	8	NO	NO
ApModFeccie	datetime	8	NO	NO
ApModEstado	char	1	NO	NO
ApModOSab	char	1	NO	NO
ApModODom	char	1	NO	NO
ApModCoPartidas	smallint	2	NO	NO
ApModPath	char	60	NO	NO
ApModPro	char	12	NO	NO

Table Name: ApMonedas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApMonCod	smallint	2	NO	NO
ApMonNombre	char	30	NO	NO
ApMonSimbolo	char	3	NO	NO
ApMonCodAlfa	char	10	YES	NO

Table Name: ApMotAjustes

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApAjuCod	smallint	2	NO	YES
ApAjuDes	char	50	NO	NO

Table Name: ApMotRechazo

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApMotResCod	smallint	2	NO	YES
ApMotResDes	char	30	NO	NO
ApMotResCargo	char	1	NO	NO

Table Name: ApMunicipio

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApPaiCod	int	4	NO	NO
ApRegCod	int	4	NO	NO
ApDepCod	int	4	NO	NO
ApMunCod	int	4	NO	NO
ApMunDes	varchar	128	NO	NO
ApMunGeoUbicacion	char	50	NO	NO
ApMunCodAlfa	char	10	YES	NO

Table Name: ApOrigenFondos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApOrgCod	smallint	2	NO	NO
ApOrgDes	char	50	NO	NO

Table Name: ApOrigenFondosSerieCorrelativo

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApEmpCodigo	smallint	2	NO	NO	Código
ApOrgCod	smallint	2	NO	NO	Código de Origen de Fondos
ApOrigenFondosSerieCodigo	char	40	NO	NO	Nombre de la serie para origen de fondos
ApOrigenFondosSerieRangoInicial	decimal	9	NO	NO	Secuencia inicial para serie de origen de fondos
ApOrigenFondosSerieRangoFinal	decimal	9	NO	NO	Secuencia final para serie de origen de fondos
ApOrigenFondosSerieRangoSiguiente	decimal	9	NO	NO	Secuencia siguiente para serie de origen de fondos
ApOrigenFondosSerieRangoUltimo	decimal	9	NO	NO	Ultimo correlativo de la serie para origen de fondos
ApOrigenFondosSerieActiva	bit	1	NO	NO	Estado de la serie para origen de fondos

Table Name: ApPais

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApPaiCod	int	2	NO	NO
ApPaiNombre	varchar	128	NO	NO
ApPaiCodAlfa	char	10	YES	NO

Table Name: ApParametros

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApGCodigo	smallint	2	NO	NO
ApGUbFirma	char	150	NO	NO
ApFUbFoto	char	150	NO	NO
ApGArFirma	char	5	NO	NO
ApGArFoto	char	5	NO	NO
ApGNFirma	char	8	NO	NO
ApGNFoto	char	8	NO	NO
ApGDBDatos	char	30	NO	NO
ApGUbCrRep	varchar	256	NO	NO
ApGEntorno	char	2	NO	NO
ApGUbCICryRep	varchar	256	NO	NO
ApGFlaScreen	char	1	NO	NO
ApGLoHeiLog	smallint	2	NO	NO
ApGLoWidLog	smallint	2	NO	NO
ApGBDSistemaF	char	30	NO	NO
ApGVersion	char	10	NO	NO
ApGUbSistF	char	150	NO	NO
ApGP1IniLibreta	smallint	2	NO	NO
ApGP1FinLibreta	smallint	2	NO	NO
ApGP1NomLibreta	char	100	NO	NO
ApGP2IniLibreta	smallint	2	NO	NO
ApGP2FinLibreta	smallint	2	NO	NO
ApGP2NomLibreta	char	100	NO	NO
ApGCajLibreta	char	1	NO	NO
ApGTHiSalDiario	char	1	NO	NO
ApGATMDigito	char	1	NO	NO
ApGLiberaPcs	char	2	NO	NO
ApGEstCtaGrupal	char	100	NO	NO
ApGEstCtaIndividual	char	100	NO	NO
ApGDistrGeolden	smallint	2	NO	NO
ApGDistrGeoDir	smallint	2	NO	NO
ApGNivelMaximo	smallint	2	NO	NO
ApGRegistrarAprobacionCredito	char	1	NO	NO
ApGPais	char	3	NO	NO
ApGOperacionesAhorro	bit	1	NO	NO
ApGOperacionesAportaciones	bit	1	NO	NO
ApGOperacionesCredito	bit	1	NO	NO
ApGFechaInicioOperaciones	datetime	8	NO	NO
ApgEstadoInstalacion	char	3	NO	NO
ApGDestinosColocaciones	smallint	2	NO	NO
ApEmpDocGarantias	char	2	NO	NO
ApEmpInactClienteCredito	int	4	NO	NO
ApGLugarInversion	smallint	2	NO	NO
ApGRedondeo	smallint	2	NO	NO
ApGDBMS	smallint	2	YES	NO
ApGDBMS_Version	varchar	256	YES	NO
ApGConexionContable	char	1	NO	NO
ApGUbReportingServices	varchar	256	NO	NO
ApGUbJasperReports	varchar	256	NO	NO
ApgC	smallint	2	NO	NO
ApGServerName	varchar	100	NO	NO
ApGOperacionesCaja	bit	1	NO	NO
ApGOperacionesDesempenoSocial	bit	1	NO	NO
ApGNumeroPagsLibreta	smallint	2	NO	NO
ApGPLocalizacionCampos	varchar	-1	NO	NO
ApGSucursalElectronica_Logo	varbinary	-1	YES	NO
ApGSucursalElectronica_Logo_GXI	varchar	2048	YES	NO
ApGSucursalElectronica_IconoAhorro	varbinary	-1	YES	NO
ApGSucursalElectronica_IconoAhorro_GXI	varchar	2048	YES	NO
ApGSucursalElectronica_IconoCredito	varbinary	-1	YES	NO
ApGSucursalElectronica_IconoCredito_GXI	varchar	2048	YES	NO
ApGSucursalElectronica_IconoGestion	varbinary	-1	YES	NO
ApGSucursalElectronica_IconoGestion_GXI	varchar	2048	YES	NO
ApGSucursalElectronica_IconoTiendaVirtual	varbinary	-1	YES	NO
ApGSucursalElectronica_IconoTiendaVirtual_GXI	varchar	2048	YES	NO
ApGSucursalElectronica_IconoInformacion	varbinary	-1	YES	NO
ApGSucursalElectronica_IconoInformacion_GXI	varchar	2048	YES	NO
ApGUbHangfire	varchar	256	YES	NO
ApGOperacionesPOS	bit	1	YES	NO
ApGSucursalElectronica_Banner_GXI	varchar	2048	YES	NO
ApGSucursalElectronica_Banner	varbinary	-1	YES	NO
ApGCuentasFirmaObligatorio	bit	1	YES	NO
ApGCuentasHuellaObligatorio	bit	1	YES	NO
ApGCuentasFotoObligatorio	bit	1	YES	NO
ApGCuentasDocumentacionObligatorio	bit	1	YES	NO
ApGClientesTelefonoExpresionRegular	char	60	YES	NO
ApGUtilizaCupos	char	1	YES	NO
ApGDocumentoClienteJuridico	char	1	YES	NO
ApGFlujoFactoring	char	1	YES	NO
ApGCuentasProcesoVerificacion	bit	1	YES	NO
ApGClientesPromotorAsignado	bit	1	YES	NO
ApGClientesProcesoVerificacion	bit	1	YES	NO
ApGSuRSWebService	char	150	YES	NO
ApGUbRSArcGen	varchar	256	YES	NO
ApGUbRSSSRS	varchar	256	YES	NO
ApGUbRSArcEnt	varchar	256	YES	NO
ApGUbRSUtilitario	varchar	256	YES	NO
ApGIdiomaPredef	char	20	NO	NO	Idioma predefinido para el sitio
ApGubEasyQuery	varchar	256	YES	NO
ApGCajaTransaccionesEnOtraMoneda	bit	1	YES	NO
ApGControlCorrelativosOrigenFondos	bit	1	YES	NO
ApG_IngresoRecargosSolicitud	bit	1	YES	NO
ApG_IngresoDeduccionesSolicitud	bit	1	YES	NO
ApG_IngresoSubProductoSolicitud	bit	1	YES	NO
ApG_IngresoTasaSolicitud	bit	1	YES	NO
ApGRequiereGarantia	char	1	YES	NO
ApG_RequiereFirmanteEnCliente	bit	1	YES	NO
ApGExternalTimeOut	smallint	2	YES	NO

Table Name: ApParCajero

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApUsuCod	varchar	100	NO	NO
ApMonCod	smallint	2	NO	NO
ApCajMaximo	money	8	NO	NO
ApCajEstado	char	1	NO	NO
ApCajSIngr	char	4	NO	NO
ApCajSEgr	char	4	NO	NO
ApCajCIngr	smallint	2	NO	NO
ApCajCEgr	smallint	2	NO	NO
ApCajSucCod	smallint	2	NO	NO
ApCajCajReceptora	smallint	2	NO	NO

Table Name: ApParMon

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
PaMMinEfe	money	8	NO	NO
PaMMaxEfe	money	8	NO	NO
PaMComRem	money	8	YES	NO

Table Name: ApParValuacion

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApCaCCod	smallint	2	NO	NO
ApGarCod	smallint	2	NO	NO
ApValDiln	smallint	2	NO	NO
ApValDiFn	smallint	2	NO	NO
ApValPorRes	smallmoney	4	NO	NO

Table Name: ApPerAnalisis

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApAnaCod	smallint	2	NO	NO
ApDiaInicial	int	4	NO	NO
ApDiaFinal	int	4	NO	NO

Table Name: ApPerPlazo

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPlaCod	smallint	2	NO	NO
ApPlaDescripcion	char	50	NO	NO
ApPlaDDia	int	4	NO	NO
ApPlaHDia	int	4	NO	NO

Table Name: ApPerReserva

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApPResCod	smallint	2	NO	YES
ApPResDes	char	60	NO	NO
ApPResDias	smallint	2	NO	NO

Table Name: ApPrmGral

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApPrmGral_IDParam	int	4	NO	YES
ApPrmGral_Etiqueta	varchar	30	NO	NO
ApPrmGral_Titulo	varchar	100	NO	NO
ApPrmGral_Descrip	varchar	-1	NO	NO

Table Name: ApPrmGralDeta

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApPrmGral_IDParam	int	4	NO	NO
ApPrmGralDeta_IDParam	int	4	NO	NO
ApPrmGralDeta_Descrip	varchar	100	NO	NO
ApPrmGralDeta_Valor	varchar	10	NO	NO

Table Name: ApProductos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApPrdNombre	char	30	NO	NO
ApPrdTipProd	smallint	2	NO	NO
ApPrdTipDig	smallint	2	NO	NO
ApPrdPe1	smallint	2	NO	NO
ApPrdPe2	smallint	2	NO	NO
ApPrdPe3	smallint	2	NO	NO
ApPrdPe4	smallint	2	NO	NO
ApPrdPe5	smallint	2	NO	NO
ApPrdPe6	smallint	2	NO	NO
ApPrdPe7	smallint	2	NO	NO
ApPrdPe8	smallint	2	NO	NO
ApPrdPe9	smallint	2	NO	NO
ApPrdP10	smallint	2	NO	NO
ApPrdP11	smallint	2	NO	NO
ApPrdP12	smallint	2	NO	NO
ApPrdP13	smallint	2	NO	NO

Table Name: ApProgramas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApProCod	char	8	NO	NO
ApProDes	char	40	NO	NO
ApProTip	smallint	2	NO	NO

Table Name: ApPromotores

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApPrmCod	varchar	100	NO	NO
ApPrmNombre	char	40	NO	NO
ApPrmTipo	char	1	YES	NO
ApPrmFecIng	datetime	8	YES	NO
ApPrmSupervisor	varchar	100	YES	NO
ApPrmRefCod	char	10	YES	NO
ApPrmActivo	bit	1	NO	NO

Table Name: ApPromotoresCalificadoresAdicionales

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
PromotorCod	varchar	100	NO	NO
PromApCalCod	smallint	2	NO	NO
PromCalVNum	decimal	9	YES	NO
PromCalVAlfa	varchar	254	YES	NO
PromCalVFecha	datetime	8	YES	NO
PromCalVCaracter	char	30	YES	NO

Table Name: ApProTransaCaptacion

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApPrdCodTransaCaptacion	smallint	2	NO	NO
ApSubCaptaTransaCaptacion	smallint	2	NO	NO

Table Name: ApProTransaColocacion

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApPrdCodTransaColocacion	smallint	2	NO	NO
ApColCodTransaColocacion	smallint	2	NO	NO

Table Name: ApRanPlazos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApSubCod	smallint	2	NO	NO
ApRaPlaIn	smallint	2	NO	NO
ApRaPlaFn	smallint	2	NO	NO
ApRaCodTasa	smallint	2	NO	NO

Table Name: ApRanTasas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApTasCod	smallint	2	NO	NO
ApRaTaFecha	datetime	8	NO	NO
ApRaTaInSa	money	8	NO	NO
ApRaTaFnSa	money	8	NO	NO
ApRaTaVal	decimal	5	NO	NO

Table Name: ApRecargosxProductoColocacionesLevel1

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApRecCod	smallint	2	NO	NO

Table Name: ApRegiones

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApPaiCod	int	4	NO	NO
ApRegCod	int	4	NO	NO
ApRegDes	varchar	128	NO	NO
ApRegCodAlfa	char	10	YES	NO

Table Name: ApReportes

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApRepCod	int	4	NO	NO
ApRepNombre	varchar	50	NO	NO
ApRepDescripcion	varchar	1000	NO	NO
ApRepModulo	char	2	NO	NO
ApRepClase	varchar	20	NO	NO
ApRepTecnologia	char	10	NO	NO
ApRepObservaciones	varchar	1000	NO	NO
ApRepSistema	bit	1	NO	NO
ApRepFechaActualizacion	datetime	8	NO	NO
ApRepVersion	varchar	10	NO	NO
ApRepActivo	bit	1	NO	NO
ApRepTipo	smallint	2	NO	NO
ApRepPath	varchar	500	YES	NO
ApSelectionFormula	varchar	2000	YES	NO
ApQueryJSON	varchar	-1	YES	NO
ApQuerySQL	varchar	-1	YES	NO
ApReporteUsuarioPublico	smallint	2	YES	NO
ApReporteUsuarioEditable	bit	1	YES	NO
ApReporteUsuarioModifica	varchar	100	YES	NO
ApReporteUsuarioRegistra	varchar	100	YES	NO
ApRepXML	varchar	-1	YES	NO
ApRepUbReporte	varchar	256	YES	NO
ApRepArcEnt	varchar	256	YES	NO
ApRepBin	varbinary	-1	YES	NO

Table Name: ApReportesLevel1

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApRepCod	int	4	NO	NO
ApRepTech_Correlativo	smallint	2	NO	NO
ApRepTech_ID	varchar	40	NO	NO
ApRepTech_Valor	varchar	1000	NO	NO

Table Name: ApRoles

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApRolCod	smallint	2	NO	NO
ApRolDes	char	40	NO	NO

Table Name: ApRutinas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApRutCod	smallint	2	NO	NO
ApRutDes	char	30	NO	NO
ApRutTip	char	1	NO	NO
ApRutConfiguracion	varchar	8000	YES	NO
ApRutExpresionID	int	4	YES	NO

Table Name: ApRutTransa

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApRutxTrx	smallint	2	NO	NO
ApRutSec	smallint	2	NO	NO
ApRutAplicaPagosMoviles	bit	1	NO	NO

Table Name: ApSalCre

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApColCod	smallint	2	NO	NO
ApSalCod	smallint	2	NO	NO
ApSalCrePri	smallint	2	NO	NO

Table Name: ApSaldos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApSalCod	smallint	2	NO	NO
ApSalDes	char	30	NO	NO
ApSalTipo	char	2	NO	NO

Table Name: ApSalProductos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApSubCod	smallint	2	NO	NO
ApSalCod	smallint	2	NO	NO

Table Name: ApSalTransa

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApSalCod	smallint	2	NO	NO
ApCamCod	smallint	2	NO	NO
ApStxOpe	char	1	NO	NO

Table Name: ApSecSucursal

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApPrdCod	smallint	2	NO	NO
ApSecRInicial	decimal	9	NO	NO
ApSecRFinal	decimal	9	NO	NO
ApSecSiguiente	decimal	9	NO	NO
ApSecCorporativa	char	1	NO	NO

Table Name: ApSucursales

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApSucDescripcion	char	40	NO	NO
ApSucJefe	char	40	NO	NO
ApSucDireccion	varchar	1024	NO	NO
ApSucTel	char	20	NO	NO
ApSucFax	char	20	NO	NO
ApSucEstado	char	3	NO	NO
ApSucURemesa	int	4	YES	NO
ApUltMoCJ	int	4	YES	NO
ApSucMensaje	char	255	NO	NO
ApSucMunCod	int	4	YES	NO
ApSucDepCod	int	4	YES	NO
ApSucRegCod	int	4	YES	NO
ApSucPaiCod	int	4	YES	NO
ApSucCodFEL	smallint	2	YES	NO
ApSucNombreComercial	varchar	100	YES	NO
ApSucDirCodPostal	varchar	15	YES	NO
ApSucCodSistemaExterno	int	4	YES	NO

Table Name: ApTasas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApTasCod	smallint	2	NO	YES
ApTasNombre	char	30	NO	NO
ApTasAplicacion	char	1	NO	NO
ApTasTipo	char	1	NO	NO

Table Name: ApTipAuxilia

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
TiAuCodigo	smallint	2	NO	NO
TiAuDescripcion	char	30	NO	NO

Table Name: ApTipCalendario

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApTCCodigo	decimal	9	NO	NO
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApTCFreCod	smallint	2	NO	NO
ApTCDescripcion	char	250	NO	NO
ApTCFecPago	datetime	8	NO	NO
ApTCOperado	char	1	NO	NO
ApTCImpExcell	char	1	NO	NO
ApTCSiPagoFecPlanilla	char	1	NO	NO
ApTCImpArchBan	char	1	NO	NO
ApTCBan	smallint	2	YES	NO

Table Name: ApTipCambio

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApMonCod	smallint	2	NO	NO
ApMonCod1	smallint	2	NO	NO
ApTipCamFecha	datetime	8	NO	NO
ApTipCamValor	decimal	9	NO	NO
ApTipCamValorVentaP	decimal	9	YES	NO
ApTipCamValorCompraP	decimal	9	YES	NO
ApTipCamValorVenta	decimal	9	YES	NO
ApTipCamValorCompra	decimal	9	YES	NO

Table Name: ApTipChequera

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCheCod	smallint	2	NO	NO
ApCheDes	char	30	NO	NO
ApCheCan	smallint	2	NO	NO

Table Name: ApTipDeducciones

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApDedCod	smallint	2	NO	NO
ApDedDes	char	30	NO	NO

Table Name: ApTipEscolaridad

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApTipCod	smallint	2	NO	YES
ApTipDes	char	30	NO	NO

Table Name: ApTipIdentificacion

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApTipCod	smallint	2	NO	YES
ApTidDes	varchar	128	NO	NO
ApTidForma	char	40	NO	NO
ApTidExpReg	varchar	256	YES	NO
ApTidValidacion	smallint	2	NO	NO
ApTidCodAlfa	char	10	YES	NO

Table Name: ApTipoRecargos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApRecCod	smallint	2	NO	NO
ApRecDes	char	30	NO	NO
ApRecFCob	char	1	NO	NO
ApRecValFijo	money	8	NO	NO
ApRecPor	decimal	9	NO	NO
ApRecIncluye	char	1	NO	NO
ApRecIntVariable	char	1	NO	NO
ApRecInteresesIva	char	1	NO	NO
ApRecInteresesMora	char	1	NO	NO
ApRecFrecuenciaPago	char	1	NO	NO
ApRecCaptaciones	char	1	NO	NO
ApRecAfectoIva	char	1	NO	NO
ApCalcCancelacion	char	1	NO	NO
ApCalcIndFinanciero	char	1	NO	NO

Table Name: ApTipoSerie

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApTipSCod	char	4	NO	NO
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApTipSDescripcion	char	30	NO	NO
ApCorIngEgreso	char	1	NO	NO

Table Name: ApTipPoliza

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApTPolCod	smallint	2	NO	YES
ApTPolDes	char	30	NO	NO

Table Name: APTipRelCli

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
APTipRelCli_TipoRelCli	smallint	2	NO	YES
APTipRelCli_Descripcion	char	120	NO	NO
APTipRelCli_ReqDocLegal	char	1	NO	NO
APTipRelCli_ReqPorcParticipa	char	1	NO	NO
APTipRelCli_AdmCargo	char	1	NO	NO
APTipRelCli_PEPParentesco	char	1	NO	NO
APTipRelCli_PEPMotivoAsoc	char	1	NO	NO
APTipRelCli_Etiqueta	varchar	40	NO	NO
APTipRelCli_ReqCuentaCap	char	1	YES	NO

Table Name: ApTipSociedad

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApSocCod	char	2	NO	NO
ApSocDes	char	30	NO	NO

Table Name: ApTotCajero

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
ApTocCod	smallint	2	NO	NO
ApTocDes	char	30	NO	NO

Table Name: ApTotTransa

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApTocCod	smallint	2	NO	NO
ApCamCod	smallint	2	NO	NO
ApTtxOpe	char	1	NO	NO

Table Name: ApTransacciones

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApTrxCod	smallint	2	NO	NO
ApTrxDes	char	40	NO	NO
ApModCod	char	2	NO	NO
ApTrxUso	smallint	2	NO	NO
ApTrxNaturaleza	smallint	2	NO	NO
ApTrxSigla	char	10	NO	NO
ApTrxEstadisticas	char	1	NO	NO
ApTrxTipCer	smallint	2	NO	NO
ApTrxTC1Rut	smallint	2	YES	NO
ApTrxTC2Rut	smallint	2	YES	NO
ApTrxAutoSup	char	1	NO	NO
ApTrxUltPar	int	4	NO	NO
ApTrxConta	char	1	NO	NO
ApTrxActiva	char	1	NO	NO
ApTrxEsAjuste	char	1	NO	NO
ApTrxRptCertifica	char	100	NO	NO
ApTrxEnlace	smallint	2	NO	NO
ApTrxExpresionID	int	4	YES	NO
ApTipTransacciones_EsPrioritaria	bit	1	YES	NO

Table Name: ApUsuarios

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApUsuCod	varchar	100	NO	NO
ApUsuNom	varchar	100	NO	NO
ApUsuCieModulo	char	1	NO	NO
ApUsuPreferencias	varchar	-1	NO	NO

Table Name: ApUsuSucursal

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApSucCodigo	smallint	2	NO	NO
ApUsuCod	varchar	100	NO	NO

Table Name: ApValCalif

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCalCod	smallint	2	NO	NO
ApValCod	smallint	2	NO	NO
ApValdesc	varchar	254	NO	NO
ApValRangoInicio	money	8	YES	NO
ApValRangoFin	money	8	YES	NO

Table Name: ApValTasas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApTasCod	smallint	2	NO	NO
ApVaTasFecha	datetime	8	NO	NO
ApVaTasValor	decimal	9	NO	NO

Table Name: TApCaptacionProductosCalificadoresAdicionales

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ProductoCaptacionEmpresa	smallint	2	NO	NO
ProductoCaptacionCodigo	smallint	2	NO	NO
ProductoCaptacionSubProducto	smallint	2	NO	NO
ApCapProdApCalCod	smallint	2	NO	NO
ApCapProdCalVNum	decimal	9	YES	NO
ApCapProdCalVAlfa	varchar	254	YES	NO
ApCapProdCalVFecha	datetime	8	YES	NO
ApCapProdCalVCaracter	char	30	YES	NO

Table Name: TApCierreApCieProceso

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApModCod	char	2	NO	NO
ApCieFecHoy	datetime	8	NO	NO
ApCieProcesoID	uniqueidentifier	16	NO	NO
ApCieProceso	char	1	NO	NO
ApCieProcesoTimeStamp	datetime	8	NO	NO

Table Name: TApColocacionProductosCalificadoresAdicionales

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ProductoColocacionEmpresa	smallint	2	NO	NO
ProductoColocacionCodigo	smallint	2	NO	NO
ProductoColocacionSubProducto	smallint	2	NO	NO
ApColProdApCalCod	smallint	2	NO	NO
ApColProdCalVNum	decimal	9	YES	NO
ApColProdCalVAlfa	varchar	254	YES	NO
ApColProdCalVFecha	datetime	8	YES	NO
ApColProdCalVCaracter	char	30	YES	NO

Table Name: TApParametroPlanilla

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApParametroPlanilla_Codigo	smallint	2	NO	YES
ApParametroPlanilla_Nombre	char	100	NO	NO
ApParametroPlanilla_Descripcion	char	500	NO	NO
ApParametroPlanilla_Genera	smallint	2	NO	NO
ApParametroPlanilla_TipoArchivo	smallint	2	NO	NO
ApParametroPlanilla_Formato	char	10	NO	NO
ApParametroPlanilla_CampoIdentificador	smallint	2	NO	NO
ApParametroPlanilla_AplicaAhorro	bit	1	NO	NO
ApParametroPlanilla_AplicaCredito	bit	1	NO	NO
ApParametroPlanilla_AplicaCuentaCorrientes	bit	1	NO	NO
ApParametroPlanilla_UtilizaNoCuenta	bit	1	YES	NO
ApParametroPlanilla_OrdenNoCuenta	smallint	2	YES	NO
ApParametroPlanilla_UtilizaNombre	bit	1	YES	NO
ApParametroPlanilla_OrdenNombre	smallint	2	YES	NO
ApParametroPlanilla_UtiliizaGrupo	bit	1	YES	NO
ApParametroPlanilla_OrdenGrupo	smallint	2	YES	NO
ApParametroPlanilla_UtilizaSolicitud	bit	1	YES	NO
ApParametroPlanilla_OrdenSolicitud	smallint	2	YES	NO
ApParametroPlanilla_UtilizaBoleta	bit	1	YES	NO
ApParametroPlanilla_OrdenBoleta	smallint	2	YES	NO
ApParametroPlanilla_UtilizaProducto	bit	1	YES	NO
ApParametroPlanilla_OrdenProducto	smallint	2	YES	NO
ApParametroPlanilla_OrdenMonto	smallint	2	YES	NO
ApParametroPlanilla_UtilizaIdentificacion	bit	1	YES	NO
ApParametroPlanilla_OrdenIdentificacion	smallint	2	YES	NO
ApParametroPlanilla_UtilizaReferenciaSolicitud	bit	1	YES	NO
ApParametroPlanilla_OrdenReferenciaSolicitud	smallint	2	YES	NO
ApParametroPlanilla_UtilizaReferenciaCliente	bit	1	YES	NO
ApParametroPlanilla_OrdenReferenciaCliente	smallint	2	YES	NO
ApParametroPlanilla_ExpresionCodigoReferencia	int	4	YES	NO

Table Name: TApParametroPlanillaDetalleMonto

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApParametroPlanilla_Codigo	smallint	2	NO	NO
ApParametroPlanilla_OrdenColumna	smallint	2	NO	NO
ApParametroPlanilla_FormaBusqueda	smallint	2	NO	NO
ApParametroPlanilla_Texto	varchar	60	YES	NO

Table Name: TApParametroPlanillaDetalleMontoProducto

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApParametroPlanilla_Codigo	smallint	2	NO	NO
ApParametroPlanilla_OrdenColumna	smallint	2	NO	NO
ApParametroPlanillaColumna_Codigo	uniqueidentifier	16	NO	NO
ApParametroPlanilla_PrdCaptaCod	smallint	2	YES	NO
ApParametroPlanilla_PrdCodSubCap	smallint	2	YES	NO
ApParametroPlanilla_EmpCodigoSubCap	smallint	2	YES	NO
ApParametroPlanilla_EmpCodigoSubCap	smallint	2	YES	NO
ApParametroPlanilla_PrdColCod	smallint	2	YES	NO
ApParametroPlanilla_PrdCodSubCol	smallint	2	YES	NO
ApParametroPlanillaColumna_EmpCodigoSubCol	smallint	2	YES	NO
ApParametroPlanillaColumna_Concepto	char	40	YES	NO

Table Name: TApParametrosExtendidos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
TApParametrosExtendidos_Codigo	smallint	2	NO	NO
TApParametrosExtendidos_Contenido	varchar	6000	NO	NO
TApParametrosExtendidos_Estado	bit	1	NO	NO

Table Name: TApTipoDocLeg

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApTipDocLeg_ApTipoDocLegal	smallint	2	NO	YES
ApTipDocLeg_Descripcion	char	120	NO	NO
ApTipDocLeg_ReqNumero	char	1	NO	NO
ApTipDocLeg_ReqFolio	char	1	NO	NO
ApTipDocLeg_ReqLibro	char	1	NO	NO
ApTipDocLeg_ReqInscripModif	char	1	NO	NO
ApTipDocLeg_ReqNotarioAutoridad	char	1	NO	NO
ApTipDocLeg_ReqPlazo	char	1	NO	NO
ApTipDocLeg_ReqInstRegistro	char	1	NO	NO

Parametrización

Table Name: ApActividadEconomica

Table Name: ApAseguradoras

Table Name: ApAuxiliares

Table Name: ApBancos

Table Name: ApBitacora

Table Name: ApBitClientes

Table Name: ApBkOffice

Table Name: ApBkOfficeColocaciones

Table Name: ApBloqueoCausa

Table Name: ApCajCod

Table Name: ApCajContab

Table Name: ApCajReceptora

Table Name: ApCajReceptoraCuentaContable

Table Name: ApCalifAdicionales

Table Name: ApCampos

Table Name: ApCamTransa

Table Name: ApCancelaCausa

Table Name: ApCapCoD

Table Name: ApCapContables

Table Name: ApCaptacionProductos

Table Name: ApCargo

Table Name: ApCatCreditos

Table Name: ApCategoAso

Table Name: ApCaXSa1

Table Name: ApCaXSaI

Table Name: ApCierre

Table Name: ApCjParametros

Table Name: ApCobradores

Table Name: ApCobradoresCalificadoresAdicionales

Table Name: ApCodAprobacion

Table Name: ApColCo

Table Name: ApColCoD

Table Name: ApColocacionProductos

Table Name: ApConvenios

Table Name: ApCooperativas

Table Name: ApCorDocumento

Table Name: ApCorrelativos

Table Name: ApCrCalDetalle

Table Name: ApCrCalificadores

Table Name: ApCrCance

Table Name: ApCrCompromiso

Table Name: ApCrPapeleria

Table Name: ApDeduccionesProductoLevel1

Table Name: ApDeduccionesProductoLevel1Level2

Table Name: ApDepartamento

Table Name: ApDocDetalle

Table Name: ApDocImpSubproductoColocacionesLevel1

Table Name: ApDocProducto

Table Name: ApDocTipoDet

Table Name: APDocuementosTipo

Table Name: ApDocumentos

Table Name: ApDocumentosImprimir

Table Name: ApEmpresa

Table Name: ApEquivalencias

Table Name: ApEstaCreditos

Table Name: ApEtapas

Table Name: ApExternalCallOutDefinitions

Table Name: ApExternalCallOutDefinitionsHeaders

Table Name: ApExternalCallOutDefinitionsSecurity

Table Name: ApFecTasas

Table Name: ApFeriados

Table Name: ApFormas

Table Name: ApFormatoArchivoCarga

Table Name: ApFrecCap

Table Name: ApGarantias

Table Name: ApGarantiasCalificadores

Table Name: ApGranDivision

Table Name: ApInstituciones

Table Name: ApListaVerificacion

Table Name: ApListaVerificacionDetalle

Table Name: ApMensajesParametros

Table Name: ApMenuBarraTareas

Table Name: ApMenuBarraTareasOpciones

Table Name: ApMenuBarraTareasOpcionesParametros

Table Name: ApModulos

Table Name: ApMonedas

Table Name: ApMotAjustes

Table Name: ApMotRechazo

Table Name: ApMunicipio