TR_FACTORING

Tables

TR_FACTORING

Description

(There is no description for table TR_FACTORING)

Fields

Field	Type	Default
ITEM	INTEGER
CODFACTORING	CHAR(10)
TIPO	CHAR(5)
PREFIJO	CHAR(5)
NUMERO	CHAR(10)
VALOR	NUMERIC(17,4)	0
COMISION	NUMERIC(17,4)	0
SUBTOTAL	NUMERIC(17,4)
FECHA	DATE
VENCE	DATE
ACTIVAR	CHAR(1)	'S'
MODO	CHAR(20)

Triggers

(There are no triggers for table TR_FACTORING)

Indices

Index	Fields	Order
FK_TR_FACTORING_1	CODFACTORING	ASC
FK_TR_FACTORING_2	TIPO, PREFIJO, NUMERO	ASC
PK_TR_FACTORING	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
FACTORING	FK_TR_FACTORING_1	CODFACTORING	CODIGO	NO ACTION	CASCADE
COMPROBANTES	FK_TR_FACTORING_2	TIPO, PREFIJO, NUMERO	TIPO, PREFIJO, NUMERO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table TR_FACTORING)

Definition

CREATE TABLE TR_FACTORING (
    ITEM          INTEGER NOT NULL,
    CODFACTORING  CHAR(10) NOT NULL,
    TIPO          CHAR(5) NOT NULL,
    PREFIJO       CHAR(5) NOT NULL,
    NUMERO        CHAR(10) NOT NULL,
    VALOR         NUMERIC(17,4) DEFAULT 0,
    COMISION      NUMERIC(17,4) DEFAULT 0,
    SUBTOTAL      NUMERIC(17,4),
    FECHA         DATE NOT NULL,
    VENCE         DATE,
    ACTIVAR       CHAR(1) DEFAULT 'S',
    MODO          CHAR(20)
);


ALTER TABLE TR_FACTORING ADD CONSTRAINT PK_TR_FACTORING PRIMARY KEY (ITEM);
ALTER TABLE TR_FACTORING ADD CONSTRAINT FK_TR_FACTORING_1 FOREIGN KEY (CODFACTORING) REFERENCES FACTORING (CODIGO) ON UPDATE CASCADE;
ALTER TABLE TR_FACTORING ADD CONSTRAINT FK_TR_FACTORING_2 FOREIGN KEY (TIPO, PREFIJO, NUMERO) REFERENCES COMPROBANTES (TIPO, PREFIJO, NUMERO) ON UPDATE CASCADE;