Tables

REG_NIIFS

Description

(There is no description for table REG_NIIFS)

Fields

Triggers

Indices

References

Referenced By

(There are no tables referenced by table REG_NIIFS)

Definition

CREATE TABLE REG_NIIFS (
    ITEM          INTEGER NOT NULL,
    PERIODO       CHAR(4),
    MES           CHAR(2),
    FECHA         DATE,
    TIPO          CHAR(5),
    PREFIJO       CHAR(5),
    NUMERO        CHAR(10),
    CODCUENTA     CHAR(30),
    CODTERCERO    CHAR(15),
    CODCENTRO     CHAR(5),
    CODPERSONAL   CHAR(15),
    CODACTIVO     CHAR(15),
    CODESCENARIO  CHAR(10),
    DEBITO        NUMERIC(17,4) DEFAULT 0,
    CREDITO       NUMERIC(17,4) DEFAULT 0,
    BASE          NUMERIC(17,4) DEFAULT 0,
    MODULO        CHAR(20),
    ANTICIPO      CHAR(1) DEFAULT 'N'
);


ALTER TABLE REG_NIIFS ADD CONSTRAINT PK_REG_NIIFS PRIMARY KEY (ITEM);
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_1 FOREIGN KEY (TIPO) REFERENCES DOCUMENTOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_2 FOREIGN KEY (PREFIJO) REFERENCES PREFIJOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_3 FOREIGN KEY (CODCUENTA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_4 FOREIGN KEY (CODTERCERO) REFERENCES TERCEROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_5 FOREIGN KEY (CODCENTRO) REFERENCES CENTROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_6 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_7 FOREIGN KEY (CODACTIVO) REFERENCES ACTIVOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_8 FOREIGN KEY (CODESCENARIO) REFERENCES ESCENARIOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_NIIFS ADD CONSTRAINT FK_REG_NIIFS_9 FOREIGN KEY (PERIODO, MES) REFERENCES NIIFS (PERIODO, MES) ON DELETE CASCADE ON UPDATE CASCADE;