DATA_RETENCIONES

Tables

DATA_RETENCIONES

Description

(There is no description for table DATA_RETENCIONES)

Fields

Field	Type	Default
CODTIPORETENCION	CHAR(5)
ANO	INTEGER
BASE	NUMERIC(17,4)	0
VALOR	NUMERIC(17,4)	0
TARIFA	NUMERIC(15,4)	0

Triggers

(There are no triggers for table DATA_RETENCIONES)

Indices

Index	Fields	Active	Unique	Order
FK_DATA_RETENCIONES_1	CODTIPORETENCION			ASC
PK_DATA_RETENCIONES	CODTIPORETENCION, ANO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
TIPORETENCIONES	FK_DATA_RETENCIONES_1	CODTIPORETENCION	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table DATA_RETENCIONES)

Definition

CREATE TABLE DATA_RETENCIONES (
    CODTIPORETENCION  CHAR(5) NOT NULL,
    ANO               INTEGER NOT NULL,
    BASE              NUMERIC(17,4) DEFAULT 0,
    VALOR             NUMERIC(17,4) DEFAULT 0,
    TARIFA            NUMERIC(15,4) DEFAULT 0
);


ALTER TABLE DATA_RETENCIONES ADD CONSTRAINT PK_DATA_RETENCIONES PRIMARY KEY (CODTIPORETENCION, ANO);
ALTER TABLE DATA_RETENCIONES ADD CONSTRAINT FK_DATA_RETENCIONES_1 FOREIGN KEY (CODTIPORETENCION) REFERENCES TIPORETENCIONES (CODIGO) ON UPDATE CASCADE;