| Tables |
|
LOG_PRODUCCION
| Tables |
|
LOG_PRODUCCION
Description
(There is no description for table LOG_PRODUCCION)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
TIPO |
|
CHAR(5) |
|
|
|
|
|
PREFIJO |
|
CHAR(5) |
|
|
|
|
|
NUMERO |
|
CHAR(10) |
|
|
|
|
|
RENGLON |
|
INTEGER |
|
|
|
|
|
CODCENTRO |
|
CHAR(5) |
|
|
|
|
|
CODREFERENCIA |
|
CHAR(20) |
|
|
|
|
|
CODBODEGA |
|
CHAR(5) |
|
|
|
|
|
CODBODEGA_DESTINO |
|
CHAR(5) |
|
|
|
|
|
CODLABOR |
|
INTEGER |
|
|
|
|
|
CODLOTE |
|
CHAR(20) |
|
|
|
|
|
CODCATEGORIA |
|
CHAR(15) |
|
|
|
|
|
CANTIDAD |
|
NUMERIC(17,4) |
|
0 |
|
|
|
MODO |
|
CHAR(10) |
|
'NORMAL' |
|
|
|
DOCUMENTO |
|
CHAR(20) |
|
|
|
|
|
NOTA |
|
CHAR(80) |
|
|
|
|
|
VALIDACION |
|
CHAR(10) |
|
|
|
|
|
SIN_SERIE |
|
INTEGER |
|
0 |
|
|
|
CODUSUARIO |
|
CHAR(10) |
|
|
|
|
|
FECHA |
|
TIMESTAMP |
|
|
|
|
|
ACCION |
|
CHAR(10) |
|
|
|
Triggers
(There are no triggers for table LOG_PRODUCCION)
Indices
(There are no indices on table LOG_PRODUCCION)
References
(There are no references for table LOG_PRODUCCION)
Referenced By
(There are no tables referenced by table LOG_PRODUCCION)
Definition
CREATE TABLE LOG_PRODUCCION (
TIPO CHAR(5),
PREFIJO CHAR(5),
NUMERO CHAR(10),
RENGLON INTEGER,
CODCENTRO CHAR(5),
CODREFERENCIA CHAR(20),
CODBODEGA CHAR(5),
CODBODEGA_DESTINO CHAR(5),
CODLABOR INTEGER,
CODLOTE CHAR(20),
CODCATEGORIA CHAR(15),
CANTIDAD NUMERIC(17,4) DEFAULT 0,
MODO CHAR(10) DEFAULT 'NORMAL',
DOCUMENTO CHAR(20),
NOTA CHAR(80),
VALIDACION CHAR(10),
SIN_SERIE INTEGER DEFAULT 0,
CODUSUARIO CHAR(10),
FECHA TIMESTAMP,
ACCION CHAR(10)
);
|
|
