| Tables |
|
TMP_REVELACIONES
| Tables |
|
TMP_REVELACIONES
Description
(There is no description for table TMP_REVELACIONES)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CUENTA |
|
CHAR(30) |
|
|
|
|
|
NOMBRE_CUENTA |
|
CHAR(110) |
|
|
|
|
|
NODO |
|
INTEGER |
|
0 |
|
|
|
INICIAL |
|
NUMERIC(17,4) |
|
0 |
|
|
|
DEBITOS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
CREDITOS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
FINAL |
|
NUMERIC(17,4) |
|
0 |
|
|
|
ID |
|
INTEGER |
|
|
|
Triggers
(There are no triggers for table TMP_REVELACIONES)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CUENTA |
|
|
ASC |
|
ID |
|
|
ASC |
References
(There are no references for table TMP_REVELACIONES)
Referenced By
(There are no tables referenced by table TMP_REVELACIONES)
Definition
CREATE TABLE TMP_REVELACIONES (
CUENTA CHAR(30),
NOMBRE_CUENTA CHAR(110),
NODO INTEGER DEFAULT 0,
INICIAL NUMERIC(17,4) DEFAULT 0,
DEBITOS NUMERIC(17,4) DEFAULT 0,
CREDITOS NUMERIC(17,4) DEFAULT 0,
FINAL NUMERIC(17,4) DEFAULT 0,
ID INTEGER
);
CREATE INDEX IDX_TMP_REVELACIONES_1 ON TMP_REVELACIONES (CUENTA);
CREATE INDEX IDX_TMP_REVELACIONES_2 ON TMP_REVELACIONES (ID);
|
|
