| Tables |
|
TMP_SALDOS_RANGO
| Tables |
|
TMP_SALDOS_RANGO
Description
(There is no description for table TMP_SALDOS_RANGO)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CUENTA |
|
CHAR(30) |
|
|
|
|
|
CENTRO |
|
CHAR(5) |
|
|
|
|
|
TERCERO |
|
CHAR(15) |
|
|
|
|
|
EMPLEADO |
|
CHAR(15) |
|
|
|
|
|
ACTIVO |
|
CHAR(15) |
|
|
|
|
|
INICIAL |
|
NUMERIC(17,4) |
|
0 |
|
|
|
DEBITOS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
CREDITOS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
FINAL |
|
NUMERIC(17,4) |
|
0 |
|
|
|
BASE_I |
|
NUMERIC(17,4) |
|
0 |
|
|
|
BASE_F |
|
NUMERIC(17,4) |
|
0 |
|
|
|
DEBITOS_I |
|
NUMERIC(17,4) |
|
|
|
|
|
CREDITOS_I |
|
NUMERIC(17,4) |
|
|
|
|
|
DEBITOS_F |
|
NUMERIC(17,4) |
|
|
|
|
|
CREDITOS_F |
|
NUMERIC(17,4) |
|
|
|
|
|
EFECTIVO |
|
CHAR(15) |
|
|
|
|
|
ID |
|
INTEGER |
|
|
|
|
|
REVELACIONES_CADENA |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
Triggers
(There are no triggers for table TMP_SALDOS_RANGO)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CUENTA |
|
|
ASC |
|
ID |
|
|
ASC |
References
(There are no references for table TMP_SALDOS_RANGO)
Referenced By
(There are no tables referenced by table TMP_SALDOS_RANGO)
Definition
CREATE TABLE TMP_SALDOS_RANGO (
CUENTA CHAR(30),
CENTRO CHAR(5),
TERCERO CHAR(15),
EMPLEADO CHAR(15),
ACTIVO CHAR(15),
INICIAL NUMERIC(17,4) DEFAULT 0,
DEBITOS NUMERIC(17,4) DEFAULT 0,
CREDITOS NUMERIC(17,4) DEFAULT 0,
FINAL NUMERIC(17,4) DEFAULT 0,
BASE_I NUMERIC(17,4) DEFAULT 0,
BASE_F NUMERIC(17,4) DEFAULT 0,
DEBITOS_I NUMERIC(17,4),
CREDITOS_I NUMERIC(17,4),
DEBITOS_F NUMERIC(17,4),
CREDITOS_F NUMERIC(17,4),
EFECTIVO CHAR(15),
ID INTEGER,
REVELACIONES_CADENA BLOB SUB_TYPE 1 SEGMENT SIZE 80
);
CREATE INDEX TMP_SALDOS_RANGO_IDX1 ON TMP_SALDOS_RANGO (CUENTA);
CREATE INDEX TMP_SALDOS_RANGO_IDX2 ON TMP_SALDOS_RANGO (ID);
|
|
