PRORRATEO

Tables

PRORRATEO

Description

(There is no description for table PRORRATEO)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		ITEM		INTEGER
		CODCUENTA		CHAR(30)
		CTA_FUENTE		CHAR(30)

Triggers

(There are no triggers for table PRORRATEO)

Indices

Index	Fields	Order
FK_PRORRATEO_1	CODCUENTA	ASC
FK_PRORRATEO_2	CTA_FUENTE	ASC
PK_PRORRATEO	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
CUENTAS	FK_PRORRATEO_1	CODCUENTA	CODIGO	NO ACTION	CASCADE
CUENTAS	FK_PRORRATEO_2	CTA_FUENTE	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table PRORRATEO)

Definition

CREATE TABLE PRORRATEO (
    ITEM        INTEGER NOT NULL,
    CODCUENTA   CHAR(30),
    CTA_FUENTE  CHAR(30)
);


ALTER TABLE PRORRATEO ADD CONSTRAINT PK_PRORRATEO PRIMARY KEY (ITEM);
ALTER TABLE PRORRATEO ADD CONSTRAINT FK_PRORRATEO_1 FOREIGN KEY (CODCUENTA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE PRORRATEO ADD CONSTRAINT FK_PRORRATEO_2 FOREIGN KEY (CTA_FUENTE) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;