Tables

REG_CARTERA

Description

(There is no description for table REG_CARTERA)

Fields

Triggers

(There are no triggers for table REG_CARTERA)

Indices

References

Referenced By

(There are no tables referenced by table REG_CARTERA)

Definition

CREATE TABLE REG_CARTERA (
    TERCERO       CHAR(15),
    TIPO          CHAR(5),
    PREFIJO       CHAR(5),
    NUMERO        CHAR(10),
    FECHA         DATE,
    VENCE         DATE,
    TIPOREF       CHAR(5),
    PREFIJOREF    CHAR(5),
    NUMEROREF     CHAR(10),
    CENTRO        CHAR(5),
    ESQ_CONTABLE  CHAR(5),
    DEBITO        NUMERIC(17,4) DEFAULT 0,
    CREDITO       NUMERIC(17,4) DEFAULT 0,
    CONDICIONADO  NUMERIC(17,4) DEFAULT 0
);


ALTER TABLE REG_CARTERA ADD CONSTRAINT FK_REG_CARTERA_1 FOREIGN KEY (TERCERO) REFERENCES TERCEROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_CARTERA ADD CONSTRAINT FK_REG_CARTERA_2 FOREIGN KEY (TIPO, PREFIJO, NUMERO) REFERENCES COMPROBANTES (TIPO, PREFIJO, NUMERO) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE REG_CARTERA ADD CONSTRAINT FK_REG_CARTERA_3 FOREIGN KEY (TIPOREF, PREFIJOREF, NUMEROREF) REFERENCES COMPROBANTES (TIPO, PREFIJO, NUMERO) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE REG_CARTERA ADD CONSTRAINT FK_REG_CARTERA_4 FOREIGN KEY (CENTRO) REFERENCES CENTROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_CARTERA ADD CONSTRAINT FK_REG_CARTERA_5 FOREIGN KEY (ESQ_CONTABLE) REFERENCES ESQCONTABLE (CODIGO) ON UPDATE CASCADE;