| Tables |
|
LOG_INVENTARIO
| Tables |
|
LOG_INVENTARIO
Description
(There is no description for table LOG_INVENTARIO)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
TIPO |
|
CHAR(5) |
|
|
|
|
|
PREFIJO |
|
CHAR(5) |
|
|
|
|
|
NUMERO |
|
CHAR(10) |
|
|
|
|
|
RENGLON |
|
INTEGER |
|
|
|
|
|
ORDEN |
|
INTEGER |
|
|
|
|
|
TIPOREF |
|
CHAR(5) |
|
|
|
|
|
PREFIJOREF |
|
CHAR(5) |
|
|
|
|
|
NUMEROREF |
|
CHAR(10) |
|
|
|
|
|
CUOTA |
|
SMALLINT |
|
|
|
|
|
CODCENTRO |
|
CHAR(5) |
|
|
|
|
|
CODBODEGA |
|
CHAR(5) |
|
|
|
|
|
CODREFERENCIA |
|
CHAR(20) |
|
|
|
|
|
ENTRADA |
|
NUMERIC(17,4) |
|
0 |
|
|
|
SALIDA |
|
NUMERIC(17,4) |
|
0 |
|
|
|
OTRA_ENTRADA |
|
NUMERIC(17,4) |
|
0 |
|
|
|
OTRA_SALIDA |
|
NUMERIC(17,4) |
|
0 |
|
|
|
UNITARIO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
BRUTO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
PORCENTAJE_DESCUENTO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
DESCUENTO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
CODLOTE |
|
CHAR(20) |
|
|
|
|
|
CODCATEGORIA |
|
CHAR(15) |
|
|
|
|
|
CODTERCERO |
|
CHAR(15) |
|
|
|
|
|
CODLABOR |
|
INTEGER |
|
|
|
|
|
NOTA |
|
CHAR(80) |
|
|
|
|
|
VALIDACION |
|
CHAR(10) |
|
|
|
|
|
IMPRESO |
|
CHAR(1) |
|
'N' |
|
|
|
SIN_SERIE |
|
INTEGER |
|
0 |
|
|
|
CODUSUARIO |
|
CHAR(10) |
|
|
|
|
|
FECHA |
|
TIMESTAMP |
|
|
|
|
|
ACCION |
|
CHAR(10) |
|
|
|
Triggers
(There are no triggers for table LOG_INVENTARIO)
Indices
(There are no indices on table LOG_INVENTARIO)
References
(There are no references for table LOG_INVENTARIO)
Referenced By
(There are no tables referenced by table LOG_INVENTARIO)
Definition
CREATE TABLE LOG_INVENTARIO (
TIPO CHAR(5),
PREFIJO CHAR(5),
NUMERO CHAR(10),
RENGLON INTEGER,
ORDEN INTEGER,
TIPOREF CHAR(5),
PREFIJOREF CHAR(5),
NUMEROREF CHAR(10),
CUOTA SMALLINT,
CODCENTRO CHAR(5),
CODBODEGA CHAR(5),
CODREFERENCIA CHAR(20),
ENTRADA NUMERIC(17,4) DEFAULT 0,
SALIDA NUMERIC(17,4) DEFAULT 0,
OTRA_ENTRADA NUMERIC(17,4) DEFAULT 0,
OTRA_SALIDA NUMERIC(17,4) DEFAULT 0,
UNITARIO NUMERIC(17,4) DEFAULT 0,
BRUTO NUMERIC(17,4) DEFAULT 0,
PORCENTAJE_DESCUENTO NUMERIC(17,4) DEFAULT 0,
DESCUENTO NUMERIC(17,4) DEFAULT 0,
CODLOTE CHAR(20),
CODCATEGORIA CHAR(15),
CODTERCERO CHAR(15),
CODLABOR INTEGER,
NOTA CHAR(80),
VALIDACION CHAR(10),
IMPRESO CHAR(1) DEFAULT 'N',
SIN_SERIE INTEGER DEFAULT 0,
CODUSUARIO CHAR(10),
FECHA TIMESTAMP,
ACCION CHAR(10)
);
|
|
