| Tables |
|
LOG_TESORERIA
| Tables |
|
LOG_TESORERIA
Description
(There is no description for table LOG_TESORERIA)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
TIPO |
|
CHAR(5) |
|
|
|
|
|
PREFIJO |
|
CHAR(5) |
|
|
|
|
|
NUMERO |
|
CHAR(10) |
|
|
|
|
|
RENGLON |
|
INTEGER |
|
|
|
|
|
TIPOREF |
|
CHAR(5) |
|
|
|
|
|
PREFIJOREF |
|
CHAR(5) |
|
|
|
|
|
NUMEROREF |
|
CHAR(10) |
|
|
|
|
|
CUOTA |
|
SMALLINT |
|
|
|
|
|
CODCENTRO |
|
CHAR(5) |
|
|
|
|
|
CODESQCONTABLE |
|
CHAR(5) |
|
|
|
|
|
CODBANCO |
|
CHAR(15) |
|
|
|
|
|
CODCONCILIACION |
|
INTEGER |
|
|
|
|
|
CONCILIADO |
|
CHAR(1) |
|
'N' |
|
|
|
INGRESO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
EGRESO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
PORCENTAJE_INTERES |
|
NUMERIC(17,4) |
|
0 |
|
|
|
INTERES |
|
NUMERIC(17,4) |
|
0 |
|
|
|
PRONTO_PAGO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
DOCUMENTO |
|
CHAR(20) |
|
|
|
|
|
NOTA |
|
CHAR(80) |
|
|
|
|
|
CODUSUARIO |
|
CHAR(10) |
|
|
|
|
|
FECHA |
|
TIMESTAMP |
|
|
|
|
|
ACCION |
|
CHAR(10) |
|
|
|
Triggers
(There are no triggers for table LOG_TESORERIA)
Indices
(There are no indices on table LOG_TESORERIA)
References
(There are no references for table LOG_TESORERIA)
Referenced By
(There are no tables referenced by table LOG_TESORERIA)
Definition
CREATE TABLE LOG_TESORERIA (
TIPO CHAR(5),
PREFIJO CHAR(5),
NUMERO CHAR(10),
RENGLON INTEGER,
TIPOREF CHAR(5),
PREFIJOREF CHAR(5),
NUMEROREF CHAR(10),
CUOTA SMALLINT,
CODCENTRO CHAR(5),
CODESQCONTABLE CHAR(5),
CODBANCO CHAR(15),
CODCONCILIACION INTEGER,
CONCILIADO CHAR(1) DEFAULT 'N',
INGRESO NUMERIC(17,4) DEFAULT 0,
EGRESO NUMERIC(17,4) DEFAULT 0,
PORCENTAJE_INTERES NUMERIC(17,4) DEFAULT 0,
INTERES NUMERIC(17,4) DEFAULT 0,
PRONTO_PAGO NUMERIC(17,4) DEFAULT 0,
DOCUMENTO CHAR(20),
NOTA CHAR(80),
CODUSUARIO CHAR(10),
FECHA TIMESTAMP,
ACCION CHAR(10)
);
|
|
