Contabilidad
A continuación encontrará los parámetros contables para el manejo de la contabilidad. Estos registran movimientos contables.
Table Name: BaInterfazMovimientos
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
BaInterfaz_Id | decimal | 9 | NO | YES |
|
BaInterfaz_Cuenta | int | 4 | YES | NO |
|
BaInterfaz_TipoMovimiento | char | 2 | NO | NO |
|
BaInterfaz_TipoMovimiento_F | char | 3 | YES | NO |
|
BaInterfaz_NumeroMovimiento | decimal | 9 | YES | NO |
|
BaInterfaz_CorrelativoMovimiento_F | decimal | 9 | YES | NO |
|
BaInterfaz_Status | smallint | 2 | NO | NO |
|
BaInterfaz_ReferenciaCliente | int | 4 | YES | NO |
|
BaInterfaz_ReferenciaGrupo | int | 4 | YES | NO |
|
BaInterfaz_ReferenciaCuenta | char | 14 | YES | NO |
|
BaInterfaz_ReferenciaDescripcion | varchar | 250 | NO | NO |
|
BaInterfaz_ReferenciaModulo | char | 2 | NO | NO |
|
BaInterfaz_ReferenciaGiradoA | varchar | 100 | NO | NO |
|
BaInterfaz_Monto | money | 8 | NO | NO |
|
BaInterfaz_FechaMovimiento | datetime | 8 | NO | NO |
|
BaInterfaz_UsuarioInsert | varchar | 100 | NO | NO |
|
BaInterfaz_TimeStampInsert | datetime | 8 | NO | NO |
|
BaInterfaz_UsuarioAnula | varchar | 100 | YES | NO |
|
BaInterfaz_TimeStampAnulacion | datetime | 8 | YES | NO |
|
BaInterfaz_ReferenciaMovimientoCaja | int | 4 | YES | NO |
|
BaInterfaz_CuentaBancoCliente | char | 20 | YES | NO |
|
Table Name: BaInterfazMovimientosCuentas
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
BaInterfaz_Id | decimal | 9 | NO | NO |
|
BaInterfazDetalle_Cuenta | char | 14 | NO | NO |
|
BaInterfazDetalle_Transaccion | decimal | 9 | NO | NO |
|
BaInterfazDetalle_Monto | money | 8 | NO | NO |
|
Table Name: BaInterfazMovimientosPartida
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
BaInterfaz_Id | decimal | 9 | NO | NO |
|
BaInterfaz_PartidaCuenta | char | 20 | NO | NO |
|
BaInterfaz_PartidaDebitoCredito | char | 2 | NO | NO |
|
BaInterfazPartidaMonto | money | 8 | NO | NO |
|
Table Name: BASolChe
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
ApEmpCodigo | smallint | 2 | NO | NO |
|
ApSucCodigo | smallint | 2 | NO | NO |
|
BASoChFecha | datetime | 8 | NO | NO |
|
BASoChCorrelativo | int | 4 | NO | NO |
|
BASoChCtaNumero | char | 14 | NO | NO |
|
BASoChUsuario | char | 10 | NO | NO |
|
BASoChTrx | smallint | 2 | NO | NO |
|
BASoChHora | char | 8 | NO | NO |
|
BASoChValor | money | 8 | NO | NO |
|
BASoChObservaciones | char | 40 | NO | NO |
|
BASoNomCh | char | 40 | NO | NO |
|
Table Name: CTInterfazMovimientos
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CTInterfaz_ID | uniqueidentifier | 16 | NO | NO |
|
CTInterfaz_Modulo | char | 2 | NO | NO |
|
CTInterfaz_MovNumMovto | int | 4 | YES | NO |
|
CTInterfaz_MoDNumMovto | int | 4 | YES | NO |
|
CTInterfaz_CrMoNuMov | decimal | 9 | YES | NO |
|
CTInterfaz_EstadoMovimiento | smallint | 2 | NO | NO |
|
CTInterfaz_ModuloDestino | char | 2 | YES | NO |
|
CTInterfaz_EmpresaCodigo | smallint | 2 | YES | NO |
|
CTInterfaz_SucursalCodigo | smallint | 2 | YES | NO |
|
CTInterfaz_TransaccionCodigo | smallint | 2 | YES | NO |
|
CTInterfaz_MonedaCodigo | smallint | 2 | YES | NO |
|
TraBovCodigo | decimal | 9 | YES | NO |
|
Table Name: CTInterfazMovimientosPartida
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CTInterfaz_ID | uniqueidentifier | 16 | NO | NO |
|
CTInterfaz_PartidaID | uniqueidentifier | 16 | NO | NO |
|
CTInterfaz_PartidaCuenta | char | 30 | NO | NO |
|
CTInterfaz_PartidaDebidoCredito | char | 2 | NO | NO |
|
CTInterfaz_PartidaMonto | money | 8 | NO | NO |
|
CTInterfaz_PartidaReferenciaSaldo | smallint | 2 | YES | NO |
|
Table Name: CTPartA1
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CTPACorrelativo | decimal | 9 | NO | NO |
|
ApTrxCod | smallint | 2 | NO | NO |
|
CTPACuenta | char | 20 | NO | NO |
|
ApMonCod | smallint | 2 | NO | NO |
|
ApSucCodigo | smallint | 2 | NO | NO |
|
CTPADebe | money | 8 | NO | NO |
|
CTAPHaber | money | 8 | NO | NO |
|
CTTrxCodBoveda | smallint | 2 | YES | NO |
|
Table Name: CTPartAuto
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
CTPACorrelativo | decimal | 9 | NO | NO |
|
ApEmpCodigo | smallint | 2 | NO | NO |
|
CTPAFecha | datetime | 8 | NO | NO |
|
ApModCod | char | 2 | NO | NO |
|
CTPANumPartida | decimal | 9 | NO | NO |
|
Table Name: Det1_Pol
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
Tpol_codigo | char | 2 | NO | NO |
|
Pol_numero | int | 4 | NO | NO |
|
Pol_linea | smallint | 2 | NO | NO |
|
Nom_codigo | smallint | 2 | NO | NO |
|
Nom_clasif | smallint | 2 | NO | NO |
|
Nom_mayor | smallint | 2 | NO | NO |
|
Nom_detalle | smallint | 2 | NO | NO |
|
Pol_debe | money | 8 | NO | NO |
|
Pol_haber | money | 8 | NO | NO |
|
Pol_Documento | char | 45 | NO | NO |
|
Table Name: Det2_Pol
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
Tpol_codigo | char | 2 | NO | NO |
|
Pol_numero | int | 4 | NO | NO |
|
Pol_linea | smallint | 2 | NO | NO |
|
Suc_codigo | smallint | 2 | NO | NO |
|
Proy_codigo | smallint | 2 | NO | NO |
|
Fon_codigo | smallint | 2 | NO | NO |
|
Pol_habes | money | 8 | NO | NO |
|
Pol_debes | money | 8 | NO | NO |
|
Table Name: Enc_Pol
SchemaName: SIFCO
ColumnName | DataType | MaxLength | IsNull | IsIdentity | Description |
|---|---|---|---|---|---|
Tpol_codigo | char | 2 | NO | NO |
|
Pol_numero | int | 4 | NO | NO |
|
Pol_fecha | datetime | 8 | NO | NO |
|
Pol_ddia1 | char | 40 | NO | NO |
|
Pol_ddia2 | char | 40 | NO | NO |
|
Pol_ddia3 | char | 40 | NO | NO |
|
Pol_dmayor | char | 30 | NO | NO |
|
Pol_status | char | 3 | NO | NO |
|
Pol_ulinea | smallint | 2 | NO | NO |
|
Pol_persona | char | 10 | NO | NO |
|
(c) 2020 por SIFC.O, S.A.