| Tables |
|
TMP_PANORAMA
| Tables |
|
TMP_PANORAMA
Description
(There is no description for table TMP_PANORAMA)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
USUARIO |
|
CHAR(10) |
|
|
|
|
|
GRUPO |
|
CHAR(20) |
|
|
|
|
|
GASTO |
|
CHAR(1) |
|
|
|
|
|
FECHA |
|
DATE |
|
|
|
|
|
CODTERCERO |
|
CHAR(15) |
|
|
|
|
|
CODPERSONAL |
|
CHAR(15) |
|
|
|
|
|
CODREFERENCIA |
|
CHAR(20) |
|
|
|
|
|
TIPO_LINEA |
|
CHAR(20) |
|
|
|
|
|
BRUTO |
|
DOUBLE PRECISION |
|
0 |
|
|
|
DESCUENTOS |
|
DOUBLE PRECISION |
|
0 |
|
|
|
IMPUESTOS |
|
DOUBLE PRECISION |
|
0 |
|
|
|
RETENCIONES |
|
DOUBLE PRECISION |
|
0 |
|
|
|
TOTAL |
|
DOUBLE PRECISION |
|
0 |
|
|
|
ENTRADAS |
|
DOUBLE PRECISION |
|
0 |
|
|
|
SALIDAS |
|
DOUBLE PRECISION |
|
0 |
|
Triggers
(There are no triggers for table TMP_PANORAMA)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
GASTO |
|
|
ASC |
|
GRUPO |
|
|
ASC |
|
USUARIO |
|
|
ASC |
References
(There are no references for table TMP_PANORAMA)
Referenced By
(There are no tables referenced by table TMP_PANORAMA)
Definition
CREATE TABLE TMP_PANORAMA (
USUARIO CHAR(10),
GRUPO CHAR(20),
GASTO CHAR(1),
FECHA DATE,
CODTERCERO CHAR(15),
CODPERSONAL CHAR(15),
CODREFERENCIA CHAR(20),
TIPO_LINEA CHAR(20),
BRUTO DOUBLE PRECISION DEFAULT 0,
DESCUENTOS DOUBLE PRECISION DEFAULT 0,
IMPUESTOS DOUBLE PRECISION DEFAULT 0,
RETENCIONES DOUBLE PRECISION DEFAULT 0,
TOTAL DOUBLE PRECISION DEFAULT 0,
ENTRADAS DOUBLE PRECISION DEFAULT 0,
SALIDAS DOUBLE PRECISION DEFAULT 0
);
CREATE INDEX IDX_TMP_PANORAMA_1 ON TMP_PANORAMA (GASTO);
CREATE INDEX IDX_TMP_PANORAMA_2 ON TMP_PANORAMA (GRUPO);
CREATE INDEX IDX_TMP_PANORAMA_3 ON TMP_PANORAMA (USUARIO);
|
|
