FACTORING

Tables

FACTORING

Description

(There is no description for table FACTORING)

Fields

Field	Type	Default
CODIGO	CHAR(10)
FECHA	DATE
VENCE	DATE
CODFACTOR	CHAR(15)
CODTERCERO	CHAR(15)
CODMONEDA	CHAR(5)
DESDE	DATE
HASTA	DATE
CARTERA	CHAR(1)	'S'
TIPO	CHAR(5)
NOTA	CHAR(400)
COMISION	NUMERIC(17,4)	0
ANTICIPO	NUMERIC(17,4)	0
TOTAL_VALOR	NUMERIC(17,4)	0
TOTAL_COMISION	NUMERIC(17,4)	0
TOTAL	NUMERIC(17,4)	0

Triggers

(There are no triggers for table FACTORING)

Indices

Index	Fields	Order
FK_FACTORING_1	CODFACTOR	ASC
FK_FACTORING_2	CODTERCERO	ASC
FK_FACTORING_3	CODMONEDA	ASC
PK_FACTORING	CODIGO	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
FACTORS	FK_FACTORING_1	CODFACTOR	CODIGO	NO ACTION	CASCADE
TERCEROS	FK_FACTORING_2	CODTERCERO	CODIGO	NO ACTION	CASCADE
MONEDAS	FK_FACTORING_3	CODMONEDA	CODIGO	NO ACTION	CASCADE

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
TR_FACTORING	FK_TR_FACTORING_1	CODFACTORING	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE FACTORING (
    CODIGO          CHAR(10) NOT NULL,
    FECHA           DATE NOT NULL,
    VENCE           DATE,
    CODFACTOR       CHAR(15) NOT NULL,
    CODTERCERO      CHAR(15) NOT NULL,
    CODMONEDA       CHAR(5),
    DESDE           DATE NOT NULL,
    HASTA           DATE NOT NULL,
    CARTERA         CHAR(1) DEFAULT 'S',
    TIPO            CHAR(5),
    NOTA            CHAR(400),
    COMISION        NUMERIC(17,4) DEFAULT 0,
    ANTICIPO        NUMERIC(17,4) DEFAULT 0,
    TOTAL_VALOR     NUMERIC(17,4) DEFAULT 0,
    TOTAL_COMISION  NUMERIC(17,4) DEFAULT 0,
    TOTAL           NUMERIC(17,4) DEFAULT 0
);


ALTER TABLE FACTORING ADD CONSTRAINT PK_FACTORING PRIMARY KEY (CODIGO);
ALTER TABLE FACTORING ADD CONSTRAINT FK_FACTORING_1 FOREIGN KEY (CODFACTOR) REFERENCES FACTORS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE FACTORING ADD CONSTRAINT FK_FACTORING_2 FOREIGN KEY (CODTERCERO) REFERENCES TERCEROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE FACTORING ADD CONSTRAINT FK_FACTORING_3 FOREIGN KEY (CODMONEDA) REFERENCES MONEDAS (CODIGO) ON UPDATE CASCADE;