Tables

MM_CONCEPTOS

Description

(There is no description for table MM_CONCEPTOS)

Fields

Triggers

(There are no triggers for table MM_CONCEPTOS)

Indices

References

Referenced By

(There are no tables referenced by table MM_CONCEPTOS)

Definition

CREATE TABLE MM_CONCEPTOS (
    CODIGO      CHAR(10) NOT NULL,
    RENGLON     INTEGER NOT NULL,
    NOMBRE      CHAR(100),
    CODFORMATO  CHAR(10) NOT NULL,
    CODCUENTA   CHAR(30),
    TIPO        CHAR(5),
    SALDO       CHAR(10),
    VALOR       CHAR(10),
    TOPE        NUMERIC(17,4) DEFAULT 0,
    CODTERCERO  CHAR(15),
    FORZOSO     CHAR(1) DEFAULT 'N',
    MANDATARIO  CHAR(1) DEFAULT 'N',
    REVELAR     CHAR(1) DEFAULT 'N'
);


ALTER TABLE MM_CONCEPTOS ADD CONSTRAINT PK_MM_CONCEPTOS PRIMARY KEY (CODIGO, RENGLON);
ALTER TABLE MM_CONCEPTOS ADD CONSTRAINT FK_MM_CONCEPTOS_1 FOREIGN KEY (CODFORMATO) REFERENCES MM_FORMATOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE MM_CONCEPTOS ADD CONSTRAINT FK_MM_CONCEPTOS_2 FOREIGN KEY (CODCUENTA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE MM_CONCEPTOS ADD CONSTRAINT FK_MM_CONCEPTOS_3 FOREIGN KEY (CODTERCERO) REFERENCES TERCEROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE MM_CONCEPTOS ADD CONSTRAINT FK_MM_CONCEPTOS_4 FOREIGN KEY (TIPO) REFERENCES DOCUMENTOS (CODIGO) ON UPDATE CASCADE;