| Tables |
|
TMP_TRUPUT
| Tables |
|
TMP_TRUPUT
Description
(There is no description for table TMP_TRUPUT)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
USUARIO |
|
CHAR(10) |
|
|
|
|
|
FECHA |
|
DATE |
|
|
|
|
|
CODMAQUINA |
|
CHAR(10) |
|
|
|
|
|
CODPERSONAL |
|
CHAR(15) |
|
|
|
|
|
CODREFERENCIA |
|
CHAR(20) |
|
|
|
|
|
PRODUCIDAS |
|
INTEGER |
|
0 |
|
|
|
DEFECTUOSAS |
|
INTEGER |
|
0 |
|
|
|
COSTO |
|
DOUBLE PRECISION |
|
0 |
|
|
|
PONDERADO |
|
DOUBLE PRECISION |
|
0 |
|
|
|
VENTA |
|
DOUBLE PRECISION |
|
0 |
|
|
|
VALOR_DEFECTUOSAS |
|
DOUBLE PRECISION |
|
0 |
|
|
|
TRUPUT_COSTO |
|
DOUBLE PRECISION |
|
0 |
|
|
|
TRUPUT_PONDERADO |
|
DOUBLE PRECISION |
|
0 |
|
|
|
CICLOS |
|
INTEGER |
|
0 |
|
Triggers
(There are no triggers for table TMP_TRUPUT)
Indices
(There are no indices on table TMP_TRUPUT)
References
(There are no references for table TMP_TRUPUT)
Referenced By
(There are no tables referenced by table TMP_TRUPUT)
Definition
CREATE TABLE TMP_TRUPUT (
USUARIO CHAR(10),
FECHA DATE,
CODMAQUINA CHAR(10),
CODPERSONAL CHAR(15),
CODREFERENCIA CHAR(20),
PRODUCIDAS INTEGER DEFAULT 0,
DEFECTUOSAS INTEGER DEFAULT 0,
COSTO DOUBLE PRECISION DEFAULT 0,
PONDERADO DOUBLE PRECISION DEFAULT 0,
VENTA DOUBLE PRECISION DEFAULT 0,
VALOR_DEFECTUOSAS DOUBLE PRECISION DEFAULT 0,
TRUPUT_COSTO DOUBLE PRECISION DEFAULT 0,
TRUPUT_PONDERADO DOUBLE PRECISION DEFAULT 0,
CICLOS INTEGER DEFAULT 0
);
|
|
