REG_PAGOS

Tables

REG_PAGOS

Description

(There is no description for table REG_PAGOS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		TIPO		CHAR(5)
		PREFIJO		CHAR(5)
		NUMERO		CHAR(10)
		RENGLON		INTEGER
		VALOR		NUMERIC(17,4)
		DOCUMENTO		CHAR(40)
		CODFORMASPAGO		CHAR(5)

Triggers

(There are no triggers for table REG_PAGOS)

Indices

Index	Fields	Order
FK_REG_PAGOS_1	TIPO, PREFIJO, NUMERO	ASC
FK_REG_PAGOS_2	CODFORMASPAGO	ASC
PK_REG_PAGOS	TIPO, PREFIJO, NUMERO, RENGLON	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
COMPROBANTES	FK_REG_PAGOS_1	TIPO, PREFIJO, NUMERO	TIPO, PREFIJO, NUMERO	NO ACTION	CASCADE
FORMASPAGO	FK_REG_PAGOS_2	CODFORMASPAGO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table REG_PAGOS)

Definition

CREATE TABLE REG_PAGOS (
    TIPO           CHAR(5) NOT NULL,
    PREFIJO        CHAR(5) NOT NULL,
    NUMERO         CHAR(10) NOT NULL,
    RENGLON        INTEGER NOT NULL,
    VALOR          NUMERIC(17,4),
    DOCUMENTO      CHAR(40),
    CODFORMASPAGO  CHAR(5)
);


ALTER TABLE REG_PAGOS ADD CONSTRAINT PK_REG_PAGOS PRIMARY KEY (TIPO, PREFIJO, NUMERO, RENGLON);
ALTER TABLE REG_PAGOS ADD CONSTRAINT FK_REG_PAGOS_1 FOREIGN KEY (TIPO, PREFIJO, NUMERO) REFERENCES COMPROBANTES (TIPO, PREFIJO, NUMERO) ON UPDATE CASCADE;
ALTER TABLE REG_PAGOS ADD CONSTRAINT FK_REG_PAGOS_2 FOREIGN KEY (CODFORMASPAGO) REFERENCES FORMASPAGO (CODIGO) ON UPDATE CASCADE;