| Tables |
|
TMP_SALDOS
| Tables |
|
TMP_SALDOS
Description
(There is no description for table TMP_SALDOS)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CUENTA |
|
CHAR(30) |
|
|
|
|
|
CENTRO |
|
CHAR(5) |
|
|
|
|
|
TERCERO |
|
CHAR(15) |
|
|
|
|
|
EMPLEADO |
|
CHAR(15) |
|
|
|
|
|
ACTIVO |
|
CHAR(15) |
|
|
|
|
|
DEBITO |
|
NUMERIC(17,4) |
|
|
|
|
|
CREDITO |
|
NUMERIC(17,4) |
|
|
|
|
|
BASE |
|
NUMERIC(17,4) |
|
|
|
|
|
ID |
|
INTEGER |
|
|
|
Triggers
(There are no triggers for table TMP_SALDOS)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CUENTA |
|
|
ASC |
|
ID |
|
|
ASC |
References
(There are no references for table TMP_SALDOS)
Referenced By
(There are no tables referenced by table TMP_SALDOS)
Definition
CREATE TABLE TMP_SALDOS (
CUENTA CHAR(30),
CENTRO CHAR(5),
TERCERO CHAR(15),
EMPLEADO CHAR(15),
ACTIVO CHAR(15),
DEBITO NUMERIC(17,4),
CREDITO NUMERIC(17,4),
BASE NUMERIC(17,4),
ID INTEGER
);
CREATE INDEX TMP_SALDOS_IDX1 ON TMP_SALDOS (CUENTA);
CREATE INDEX TMP_SALDOS_IDX2 ON TMP_SALDOS (ID);
|
|
