Tables

REG_NOMINA

Description

(There is no description for table REG_NOMINA)

Fields

Triggers

(There are no triggers for table REG_NOMINA)

Indices

References

Referenced By

(There are no tables referenced by table REG_NOMINA)

Definition

CREATE TABLE REG_NOMINA (
    TIPO         CHAR(5) NOT NULL,
    PREFIJO      CHAR(5) NOT NULL,
    NUMERO       CHAR(10) NOT NULL,
    RENGLON      INTEGER NOT NULL,
    CODCENTRO    CHAR(5),
    CODCUENTA    CHAR(30),
    CODTERCERO   CHAR(15),
    CODPERSONAL  CHAR(15),
    CODNOMINA    CHAR(5),
    DEBITO       NUMERIC(17,4) DEFAULT 0 NOT NULL,
    CREDITO      NUMERIC(17,4) DEFAULT 0 NOT NULL,
    BASE         NUMERIC(17,4) DEFAULT 0 NOT NULL,
    DETALLE      CHAR(80)
);


ALTER TABLE REG_NOMINA ADD CONSTRAINT FK_REG_NOMINA_1 FOREIGN KEY (CODCENTRO) REFERENCES CENTROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NOMINA ADD CONSTRAINT FK_REG_NOMINA_2 FOREIGN KEY (CODCUENTA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NOMINA ADD CONSTRAINT FK_REG_NOMINA_3 FOREIGN KEY (CODTERCERO) REFERENCES TERCEROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NOMINA ADD CONSTRAINT FK_REG_NOMINA_4 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NOMINA ADD CONSTRAINT FK_REG_NOMINA_5 FOREIGN KEY (CODNOMINA) REFERENCES NOMINAS (CODIGO) ON UPDATE CASCADE;