A continuación encontrará tablas con datos utilizados en el módulo de caja.

Table Name: CJBilletajeMoneda

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
CJBillMonCodigo	smallint	2	NO	NO
CJBillMonDescripcion	varchar	50	NO	NO
CJBillMonUnidad	smallmoney	4	NO	NO
CJBillMonTipo	char	1	NO	NO
CJBillMonEstado	char	1	NO	NO

Table Name: CJBitDocumentos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
CjBitMovNumMovto	int	4	NO	NO
CjBitNoDocumento	decimal	9	NO	NO
CjBitUsuCod	varchar	100	NO	NO
CjBitFecTrx	datetime	8	NO	NO
CjBitFecValor	datetime	8	NO	NO
CjBitTipSerie	char	4	NO	NO
CjBitTipCorrelativo	smallint	2	NO	NO
CjBitEstado	char	1	NO	NO

Table Name: CJBoveda

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJBovCodigo	smallint	2	NO	NO
CJBovNombre	varchar	50	NO	NO
CJBovDescripcion	varchar	75	YES	NO
ApSucCodigo	smallint	2	NO	NO
CJBovCentral	char	1	NO	NO
CJBovEstado	char	1	NO	NO
CJBovEncargado	varchar	10	NO	NO

Table Name: CJBovedaBilletaje

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJBovCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
CJBillMonCodigo	smallint	2	NO	NO
CJBovBillCantidad	int	4	NO	NO
CJBovBillTotal	money	8	NO	NO

Table Name: CJBovedaMonedaParametro

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJBovCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
CJBovMonValMaximo	money	8	NO	NO

Table Name: CJBovedaParametroContable

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJBovCodigo	smallint	2	NO	NO
CJTipTraCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
CJBovParConCorrelativo	smallint	2	YES	NO

Table Name: CJBovedaParametroContableDetalle

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJBovCodigo	smallint	2	NO	NO
CJTipTraCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
CJBovParConDetCorrelativo	smallint	2	NO	NO
CJBovParConDetDebCre	char	1	NO	NO
CatNumCta	char	20	NO	NO
CJBovParConDetSusCueBan	bit	1	NO	NO
CJBovParConDetCueAfeBan	varchar	50	YES	NO

Table Name: CJBovedaUsuario

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

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

Table Name: CJCajaBilletaje

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
ApMonCod	smallint	2	NO	NO
CJBillMonCodigo	smallint	2	NO	NO
CJCajBillCantidad	int	4	NO	NO
CJCajBillTotal	money	8	NO	NO

Table Name: CJCamMov

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
MovNumMovto	int	4	NO	NO
ApCamCod	smallint	2	NO	NO
CaMNumCta	char	14	NO	NO
CaMFecha	datetime	8	NO	NO
CaMDocto	int	4	NO	NO
CaMValor	money	8	NO	NO
CaMText	char	40	NO	NO
CaMOrden	smallint	2	NO	NO
CaMNumerico	money	8	NO	NO

Table Name: CJConsultas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ConNumAutorizacion	int	4	NO	NO
CtaNumero	char	14	NO	NO
ApCooCod	smallint	2	NO	NO
ConFecha	datetime	8	NO	NO
ConHora	char	8	NO	NO
ConValor	money	8	NO	NO

Table Name: CjDetaPlanilla

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
CjPlaCodCop	smallint	2	NO	NO
CjPlaCodSuc	smallint	2	NO	NO
ApTCCodigo	decimal	9	NO	NO
CjPlaDCuenta	char	14	NO	NO
CjPlaDCodSoc	int	4	NO	NO
CjPlaDAhorro	money	8	NO	NO
CjPlaDAporta	money	8	NO	NO
CjPlaDCredito	money	8	NO	NO
CjPlaDTrx	smallint	2	NO	NO
CjPlaDMod	char	2	NO	NO
CjPlaDRef	varchar	128	NO	NO

Table Name: CJDetLote

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
LotCodigo	smallint	2	NO	NO
DetNumMovto	int	4	NO	NO
ApTrxcod	smallint	2	NO	NO
DetFecTrx	datetime	8	NO	NO
DetHorTrx	char	8	NO	NO
DetNumCta	char	14	NO	NO
DetNroDocto	int	4	NO	NO
DetNroAutorizacion	int	4	NO	NO
DetValorTrx	money	8	NO	NO
DetAplicada	char	1	NO	NO
ApMenCod	smallint	2	NO	NO
ApMenDes	char	40	NO	NO

Table Name: CjDPla2

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
CjPlaCodCop	smallint	2	NO	NO
CjPlaCodSuc	smallint	2	NO	NO
ApTCCodigo	decimal	9	NO	NO
CjDPla2Cuenta	char	14	NO	NO
CjDpla2Linea	int	4	NO	NO
CjDpla2CodSoc	int	4	NO	NO
CjDpla2Ahorro	money	8	NO	NO
CjDpla2Aporta	money	8	NO	NO
CjDpla2Credito	money	8	NO	NO
CjDpla2Trx	smallint	2	NO	NO
CjDpla2Mod	char	2	NO	NO
CjDpla2Ref	char	80	NO	NO

Table Name: CJEncPa1

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
PaCEmpCod	smallint	2	NO	NO
PaCTrxCod	smallint	2	NO	NO
PaCSucCod	smallint	2	NO	NO
PaCMonCod	smallint	2	NO	NO
PaCCajRecCodigo	smallint	2	NO	NO
PaCCorrel	int	4	NO	NO
DeCCamCod	smallint	2	NO	NO
DeCCuenta	char	20	NO	NO
DeCDebCre	char	2	NO	NO
DeCMonto	money	8	NO	NO
DeCDocRef	int	4	NO	NO

Table Name: CJEncPartidas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
PaCEmpCod	smallint	2	NO	NO
PaCTrxCod	smallint	2	NO	NO
PaCSucCod	smallint	2	NO	NO
PaCMonCod	smallint	2	NO	NO
PaCCajRecCodigo	smallint	2	NO	NO
PaCCorrel	int	4	NO	NO
PaCUsuCod	char	10	NO	NO
PaCFecMovimiento	datetime	8	NO	NO
PaCFecValor	datetime	8	NO	NO
PaCDescripcion	char	60	NO	NO
PaCTipPartida	char	3	NO	NO
PaCTraConta	char	1	NO	NO

Table Name: CJHCamMov

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
HMovNumMovto	decimal	9	NO	NO
HApCampCod	smallint	2	NO	NO
HCaMNumCta	char	14	NO	NO
HCaMFecha	datetime	8	NO	NO
HCaMDocto	int	4	NO	NO
HCaMValor	money	8	NO	NO
HCaMText	char	40	NO	NO
HCaMOrden	smallint	2	NO	NO
HCaMNumerico	money	8	NO	NO

Table Name: CJHMovimi

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
HMovNumMovto	decimal	9	NO	NO
HMovUsuCod	char	10	NO	NO
HMovTrxCod	smallint	2	NO	NO
HMovFecTrx	datetime	8	NO	NO
HMovHorTrx	char	8	NO	NO
HMovFecValor	datetime	8	NO	NO
HMovNroDocto	int	4	NO	NO
HMovEmpCod	smallint	2	NO	NO
HMovSucCod	smallint	2	NO	NO
HMovMonCod	smallint	2	NO	NO
HMovCodSup	char	10	NO	NO
HMovNumCta	char	14	NO	NO
HMovTotalTrx	money	8	NO	NO
HMovEstTrx	smallint	2	NO	NO
HMovNumOrigen	decimal	9	NO	NO
HMovParCaj	decimal	9	NO	NO
HMovTipSerie	char	4	NO	NO
HMovTipCorrelativo	smallint	2	NO	NO
HMovEstado	char	1	NO	NO
HMovApCajRecCodigo	smallint	2	NO	NO
HMovAfectaBancos	bit	1	YES	NO
HMovReferenciaReversion	char	256	YES	NO
HMovDocOrigenFondosCorrelativo	int	4	YES	NO

Table Name: CJLotes

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
LotCodigo	smallint	2	NO	NO
ApCooCod	smallint	2	NO	NO
ApBanCod	smallint	2	NO	NO
LotTotDebitos	money	8	NO	NO
LotTotCreditos	money	8	NO	NO
LotCtaBanco	char	12	NO	NO
LotUltMov	int	4	NO	NO

Table Name: CJMovCooperativas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApCooCod	smallint	2	NO	NO
MovNumMovto	int	4	NO	NO
MoCEmpCod	smallint	2	NO	NO
MoCTrxCod	smallint	2	NO	NO
MoCFecTrx	datetime	8	NO	NO
MoCNumCta	char	14	NO	NO
MoCNroDocto	int	4	NO	NO
MoCNroAutorizacion	int	4	NO	NO
MoCValorTrx	money	8	NO	NO

Table Name: CJMovimientoBilletaje

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
MovNumMovto	int	4	NO	NO
ApEmpCodigo	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
CJBillMonCodigo	smallint	2	NO	NO
CJMovBillCantidad	int	4	NO	NO
CJMovBillTotal	money	8	NO	NO
CJMovEstadoBilletaje	bit	1	YES	NO

Table Name: CJMovimientos

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
MovNumMovto	int	4	NO	NO
MovUsuCod	varchar	100	NO	NO
MovTrxCod	smallint	2	NO	NO
MovFecTrx	datetime	8	NO	NO
MovHorTrx	char	8	NO	NO
MovFecValor	datetime	8	NO	NO
MovNroDocto	int	4	NO	NO
MovEmpCod	smallint	2	NO	NO
MovSucCod	smallint	2	NO	NO
MovMonCod	smallint	2	NO	NO
MovCodSup	varchar	100	YES	NO
MovNumCta	char	14	NO	NO
MovTotalTrx	money	8	NO	NO
MovEstTrx	smallint	2	NO	NO
MovNumOrigen	int	4	YES	NO
MovParCaj	decimal	9	NO	NO
MovNoCertifica	smallint	2	NO	NO
MovTipSerie	char	4	NO	NO
MovTipCorrelativo	smallint	2	NO	NO
MovEstado	char	1	NO	NO
MovApCajRecCodigo	smallint	2	NO	NO
MovAfectaBancos	bit	1	YES	NO
MovReferenciaReversion	char	256	YES	NO
MovDocumentoOrigenFondosCorrelativo	int	4	YES	NO
MovTraCodDestino	smallint	2	YES	NO
MovCliCod	int	4	YES	NO

Table Name: CjPlanilla

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
CjPlaCodCop	smallint	2	NO	NO
CjPlaCodSuc	smallint	2	NO	NO
ApTCCodigo	decimal	9	NO	NO
CjPlaObserva	varchar	128	NO	NO
CjPlaCheque	char	10	NO	NO
CjPlaGenerada	char	1	NO	NO
CjPlaFecGenerada	datetime	8	NO	NO
CjPlaFecAhorro	datetime	8	NO	NO
CjPlaFecCredito	datetime	8	NO	NO
CjPlaUsuGenera	char	10	NO	NO
CjPlaUsuOpero	char	10	NO	NO

Table Name: CJRemesas

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
RemSucOrigen	smallint	2	NO	NO
RemNumDocto	int	4	NO	NO
RemFecEmision	datetime	8	NO	NO
ClCliCod	int	4	NO	NO
ReApTidCod	smallint	2	NO	NO
ReApTidValid	smallint	2	NO	NO
ReApTidProValid	smallint	2	NO	NO
RemClNumID	char	15	NO	NO
RemNomRem	char	50	NO	NO
RemMonto	money	8	NO	NO
RemNomBenef	char	50	NO	NO
RemDirBenef	char	50	NO	NO
RemTelBenef	char	12	NO	NO
RemMonCod	smallint	2	NO	NO
RemComision	smallmoney	4	NO	NO
RemSucDestino	smallint	2	NO	NO
ApCooCod	smallint	2	NO	NO
RemFecPago	datetime	8	NO	NO
RemEstado	char	1	NO	NO

Table Name: CJTipoTransaccionBoveda

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJTipTraCodigo	smallint	2	NO	NO
CJTipTraDescripcion	varchar	50	NO	NO
CJTipTraEstado	char	1	NO	NO
CJTipTraMovimiento	char	1	NO	NO
CJTipTraIngObligatorio	char	2	NO	NO
CJTipTraTipImpresion	char	2	NO	NO
CJTipTraContabiliza	char	1	NO	NO
CJTipTraIngresaBilletaje	char	1	NO	NO
EmpresaFormatoImpreTipoTranBovedaEmpresa	smallint	2	YES	NO
FormadoIdImpreTipoTranBovedaFormadoID	char	20	YES	NO
CorrelativoFormatoImpreTipoTranBovedaCorrelativo	smallint	2	YES	NO
FormatosImpresionBovedasFormadoId	char	20	YES	NO
FormatosImpresionBovedasEmpresaFormato	smallint	2	YES	NO
FormatosImpresionBovedasFormatoCorrelativo	smallint	2	YES	NO

Table Name: CJTransaccionBoveda

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJTraBovCodigo	decimal	9	NO	NO
CJBovCodigo	smallint	2	NO	NO
CJTipTraCodigo	smallint	2	NO	NO
CJTraBovEstado	char	1	NO	NO
CJTraBovVale	decimal	9	YES	NO
ApCajRecCodigo	smallint	2	YES	NO
CJTraBovBovCodigo	smallint	2	YES	NO
CJTraBovFecha	datetime	8	NO	NO
CJTraBovCajCodigo	smallint	2	YES	NO
CJTraBovNombreInstitucion	char	50	YES	NO
CJTraBovNumeroBoleta	char	50	YES	NO
CJTraBovMontoEfectivoSolicitado	money	8	YES	NO
CJTraBovSolicitudEfectivo	bit	1	YES	NO
CJTraBovFechaValor	datetime	8	YES	NO
CJTraBovReferenciaSExterno	char	256	YES	NO

Table Name: CJTransaccionBovedaBilletaje

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJTraBovCodigo	decimal	9	NO	NO
ApMonCod	smallint	2	NO	NO
CJBillMonCodigo	smallint	2	NO	NO
CJTraBovBillCantidad	int	4	NO	NO
CJTraBovBillTotal	money	8	NO	NO

Table Name: CJTransaccionCajaBilletaje

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJTraCajBillCodigo	decimal	9	NO	NO
ApTrxCod	smallint	2	NO	NO
CJTraCajBillVale	decimal	9	YES	NO
CJBovCodigo	smallint	2	YES	NO
ApCajRecCodigo	smallint	2	YES	NO
CJTraCajBillEstado	char	1	NO	NO

Table Name: CJTransaccionCajaBilletajeDetalle

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJTraCajBillCodigo	decimal	9	NO	NO
ApMonCod	smallint	2	NO	NO
CJBillMonCodigo	smallint	2	NO	NO
CJTraCajBillDetCantidad	int	4	NO	NO
CJTraCajBillDetTotal	money	8	NO	NO

Table Name: CJTRTransaccionCajaBilletajeDetalle

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApEmpCodigo	smallint	2	NO	NO
CJTraCajBillCodigo	decimal	9	NO	NO
ApMonCod	smallint	2	NO	NO
CJBillMonCodigo	smallint	2	NO	NO
CJTraCajBillDetCantidad	int	4	NO	NO
CJTraCajBillDetTotal	money	8	NO	NO

Table Name: CJValCajero

SchemaName: SIFCO

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
ApUsuCod	varchar	100	NO	NO
ApTocCod	smallint	2	NO	NO
ApMonCod	smallint	2	NO	NO
ValTotal	money	8	NO	NO

DOCUMENTACION SIFCO

Módulo Caja

Table Name: CJBilletajeMoneda

Table Name: CJBitDocumentos

Table Name: CJBoveda

Table Name: CJBovedaBilletaje

Table Name: CJBovedaMonedaParametro

Table Name: CJBovedaParametroContable

Table Name: CJBovedaParametroContableDetalle

Table Name: CJBovedaUsuario

Table Name: CJCajaBilletaje

Table Name: CJCamMov

Table Name: CJConsultas

Table Name: CjDetaPlanilla

Table Name: CJDetLote

Table Name: CjDPla2

Table Name: CJEncPa1

Table Name: CJEncPartidas

Table Name: CJHCamMov

Table Name: CJHMovimi

Table Name: CJLotes

Table Name: CJMovCooperativas

Table Name: CJMovimientoBilletaje

Table Name: CJMovimientos

Table Name: CjPlanilla

Table Name: CJRemesas

Table Name: CJTipoTransaccionBoveda

Table Name: CJTransaccionBoveda

Table Name: CJTransaccionBovedaBilletaje

Table Name: CJTransaccionCajaBilletaje

Table Name: CJTransaccionCajaBilletajeDetalle

Table Name: CJTRTransaccionCajaBilletajeDetalle

Table Name: CJValCajero