| Tables |
|
LOG_COMOVI
| Tables |
|
LOG_COMOVI
Description
(There is no description for table LOG_COMOVI)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
TIPO |
|
CHAR(5) |
|
|
|
|
|
PREFIJO |
|
CHAR(5) |
|
|
|
|
|
NUMERO |
|
CHAR(10) |
|
|
|
|
|
RENGLON |
|
INTEGER |
|
|
|
|
|
DEBITO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
CREDITO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
BASE |
|
NUMERIC(17,4) |
|
0 |
|
|
|
NOTA |
|
CHAR(80) |
|
|
|
|
|
VALIDACION |
|
CHAR(10) |
|
|
|
|
|
CODCUENTA |
|
CHAR(30) |
|
|
|
|
|
CODTERCERO |
|
CHAR(15) |
|
|
|
|
|
CODCENTRO |
|
CHAR(5) |
|
|
|
|
|
CODACTIVO |
|
CHAR(15) |
|
|
|
|
|
CODPERSONAL |
|
CHAR(15) |
|
|
|
|
|
CODCONCILIACION |
|
INTEGER |
|
|
|
|
|
CONCILIADO |
|
CHAR(1) |
|
|
|
|
|
TIPOREF |
|
CHAR(5) |
|
|
|
|
|
PREFIJOREF |
|
CHAR(5) |
|
|
|
|
|
NUMEROREF |
|
CHAR(10) |
|
|
|
|
|
CODUSUARIO |
|
CHAR(10) |
|
|
|
|
|
FECHA |
|
TIMESTAMP |
|
|
|
|
|
ACCION |
|
CHAR(10) |
|
|
|
Triggers
(There are no triggers for table LOG_COMOVI)
Indices
(There are no indices on table LOG_COMOVI)
References
(There are no references for table LOG_COMOVI)
Referenced By
(There are no tables referenced by table LOG_COMOVI)
Definition
CREATE TABLE LOG_COMOVI (
TIPO CHAR(5),
PREFIJO CHAR(5),
NUMERO CHAR(10),
RENGLON INTEGER,
DEBITO NUMERIC(17,4) DEFAULT 0,
CREDITO NUMERIC(17,4) DEFAULT 0,
BASE NUMERIC(17,4) DEFAULT 0,
NOTA CHAR(80),
VALIDACION CHAR(10),
CODCUENTA CHAR(30),
CODTERCERO CHAR(15),
CODCENTRO CHAR(5),
CODACTIVO CHAR(15),
CODPERSONAL CHAR(15),
CODCONCILIACION INTEGER,
CONCILIADO CHAR(1),
TIPOREF CHAR(5),
PREFIJOREF CHAR(5),
NUMEROREF CHAR(10),
CODUSUARIO CHAR(10),
FECHA TIMESTAMP,
ACCION CHAR(10)
);
|
|
