| Tables |
|
COMISIONES
| Tables |
|
COMISIONES
Description
(There is no description for table COMISIONES)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CODPERSONAL |
|
CHAR(15) |
|
|
|
|
|
CODLINEA |
|
CHAR(5) |
|
|
|
|
|
PVENTAS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
PRECAUDOS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
NVENTAS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
NRECAUDOS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
PDESCUENTO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
NDESCUENTO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
GLOBAL |
|
CHAR(1) |
|
'N' |
|
Triggers
(There are no triggers for table COMISIONES)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CODPERSONAL |
|
|
ASC |
|
CODLINEA |
|
|
ASC |
|
CODPERSONAL, CODLINEA |
|
|
ASC |
References
Table | Foreign Key | Fields | FK Field | Delete Rule | Update Rule |
|---|---|---|---|---|---|
CODPERSONAL |
CODIGO |
NO ACTION |
CASCADE |
||
CODLINEA |
CODIGO |
NO ACTION |
CASCADE |
Referenced By
(There are no tables referenced by table COMISIONES)
Definition
CREATE TABLE COMISIONES (
CODPERSONAL CHAR(15) NOT NULL,
CODLINEA CHAR(5) NOT NULL,
PVENTAS NUMERIC(17,4) DEFAULT 0,
PRECAUDOS NUMERIC(17,4) DEFAULT 0,
NVENTAS NUMERIC(17,4) DEFAULT 0,
NRECAUDOS NUMERIC(17,4) DEFAULT 0,
PDESCUENTO NUMERIC(17,4) DEFAULT 0,
NDESCUENTO NUMERIC(17,4) DEFAULT 0,
GLOBAL CHAR(1) DEFAULT 'N'
);
ALTER TABLE COMISIONES ADD CONSTRAINT PK_COMISIONES PRIMARY KEY (CODPERSONAL, CODLINEA);
ALTER TABLE COMISIONES ADD CONSTRAINT FK_COMISIONES_1 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE COMISIONES ADD CONSTRAINT FK_COMISIONES_2 FOREIGN KEY (CODLINEA) REFERENCES LINEAS (CODIGO) ON UPDATE CASCADE;
|
|
