| Tables |
|
TR_ABONOS
| Tables |
|
TR_ABONOS
Description
(There is no description for table TR_ABONOS)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
TIPO |
|
CHAR(5) |
|
|
|
|
|
PREFIJO |
|
CHAR(5) |
|
|
|
|
|
NUMERO |
|
CHAR(10) |
|
|
|
|
|
RENGLON |
|
INTEGER |
|
0 |
|
|
|
TIPOREF |
|
CHAR(5) |
|
|
|
|
|
PREFIJOREF |
|
CHAR(5) |
|
|
|
|
|
NUMEROREF |
|
CHAR(10) |
|
|
|
|
|
PROCESAR |
|
CHAR(1) |
|
'N' |
|
|
|
FECHA |
|
DATE |
|
|
|
|
|
VENCE |
|
DATE |
|
|
|
|
|
CARTERA |
|
NUMERIC(17,4) |
|
0 |
|
|
|
CONDICIONADO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
VALOR |
|
NUMERIC(17,4) |
|
0 |
|
|
|
ABONO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
INTERES |
|
NUMERIC(17,4) |
|
0 |
|
|
|
DOCUMENTO |
|
CHAR(20) |
|
|
|
|
|
CODBANCO |
|
CHAR(15) |
|
|
|
Triggers
(There are no triggers for table TR_ABONOS)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
TIPO, PREFIJO, NUMERO |
|
|
ASC |
|
TIPOREF, PREFIJOREF, NUMEROREF |
|
|
ASC |
|
CODBANCO |
|
|
ASC |
|
TIPO, PREFIJO, NUMERO, RENGLON |
|
|
ASC |
References
Table | Foreign Key | Fields | FK Field | Delete Rule | Update Rule |
|---|---|---|---|---|---|
TIPO, PREFIJO, NUMERO |
TIPO, PREFIJO, NUMERO |
NO ACTION |
CASCADE |
||
TIPOREF, PREFIJOREF, NUMEROREF |
TIPO, PREFIJO, NUMERO |
NO ACTION |
CASCADE |
||
CODBANCO |
CODIGO |
NO ACTION |
CASCADE |
Referenced By
(There are no tables referenced by table TR_ABONOS)
Definition
CREATE TABLE TR_ABONOS (
TIPO CHAR(5) NOT NULL,
PREFIJO CHAR(5) NOT NULL,
NUMERO CHAR(10) NOT NULL,
RENGLON INTEGER DEFAULT 0 NOT NULL,
TIPOREF CHAR(5),
PREFIJOREF CHAR(5),
NUMEROREF CHAR(10),
PROCESAR CHAR(1) DEFAULT 'N',
FECHA DATE,
VENCE DATE,
CARTERA NUMERIC(17,4) DEFAULT 0,
CONDICIONADO NUMERIC(17,4) DEFAULT 0,
VALOR NUMERIC(17,4) DEFAULT 0,
ABONO NUMERIC(17,4) DEFAULT 0,
INTERES NUMERIC(17,4) DEFAULT 0,
DOCUMENTO CHAR(20),
CODBANCO CHAR(15)
);
ALTER TABLE TR_ABONOS ADD CONSTRAINT PK_TR_ABONOS_1 PRIMARY KEY (TIPO, PREFIJO, NUMERO, RENGLON);
ALTER TABLE TR_ABONOS ADD CONSTRAINT FK_TR_ABONOS_1 FOREIGN KEY (TIPO, PREFIJO, NUMERO) REFERENCES COMPROBANTES (TIPO, PREFIJO, NUMERO) ON UPDATE CASCADE;
ALTER TABLE TR_ABONOS ADD CONSTRAINT FK_TR_ABONOS_2 FOREIGN KEY (TIPOREF, PREFIJOREF, NUMEROREF) REFERENCES COMPROBANTES (TIPO, PREFIJO, NUMERO) ON UPDATE CASCADE;
ALTER TABLE TR_ABONOS ADD CONSTRAINT FK_TR_ABONOS_3 FOREIGN KEY (CODBANCO) REFERENCES BANCOS (CODIGO) ON UPDATE CASCADE;
|
|
