TR_CDP

Tables

TR_CDP

Description

CERTIFICADOS DE DISPONIBILIDAD PRESUPUESTAL - DETALLE MOVIMIENTO

Fields

Field	Type	Default
ITEM	INTEGER
CODCDP	CHAR(20)
CODP_PPTO	CHAR(30)
CODCENTRO	CHAR(5)
VALOR	NUMERIC(17,4)	0
NOTA	VARCHAR(1000)

Triggers

(There are no triggers for table TR_CDP)

Indices

Index	Fields	Order
FK_TR_CDP_1	CODCDP	ASC
FK_TR_CDP_2	CODP_PPTO	ASC
FK_TR_CDP_3	CODCENTRO	ASC
PK_TR_CDP	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
CDP	FK_TR_CDP_1	CODCDP	CODIGO	NO ACTION	CASCADE
P_PPTO	FK_TR_CDP_2	CODP_PPTO	CODIGO	NO ACTION	CASCADE
CENTROS	FK_TR_CDP_3	CODCENTRO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table TR_CDP)

Definition

CREATE TABLE TR_CDP (
    ITEM       INTEGER NOT NULL,
    CODCDP     CHAR(20) NOT NULL,
    CODP_PPTO  CHAR(30) NOT NULL,
    CODCENTRO  CHAR(5) NOT NULL,
    VALOR      NUMERIC(17,4) DEFAULT 0,
    NOTA       VARCHAR(1000)
);


ALTER TABLE TR_CDP ADD CONSTRAINT PK_TR_CDP PRIMARY KEY (ITEM);
ALTER TABLE TR_CDP ADD CONSTRAINT FK_TR_CDP_1 FOREIGN KEY (CODCDP) REFERENCES CDP (CODIGO) ON UPDATE CASCADE;
ALTER TABLE TR_CDP ADD CONSTRAINT FK_TR_CDP_2 FOREIGN KEY (CODP_PPTO) REFERENCES P_PPTO (CODIGO) ON UPDATE CASCADE;
ALTER TABLE TR_CDP ADD CONSTRAINT FK_TR_CDP_3 FOREIGN KEY (CODCENTRO) REFERENCES CENTROS (CODIGO) ON UPDATE CASCADE;