RFQRSPPROD

RFQ response and product relationship table. This table stores the products included in a specific RFQ Response.

Column Descriptions:

Name	Type	Description
CATENTRY_ID	BIGINT	The internal reference number of the CatalogEntry.
RFQRSP_ID	BIGINT NOT NULL	The internal reference number of the RFQ Response.
QUANTITY	DOUBLE	Response quantity for this product.
CURRENCY	CHAR (3)	The type of currency in which the price has been specified. This is a currency code as per ISO 4217 standards.
PRICE	DECIMAL (20,5)	Response price for this product.
QTYUNIT_ID	CHAR (16)	Unit of measure for the response quantity. For example, kilos, tons, or millimeters.
RFQCATENTRYID	BIGINT	The CatalogEntry ID of the product requested in the RFQ.
RFQRSPPROD_ID	BIGINT NOT NULL	The internal reference number of the product included in the RFQ response.
RFQPROD_ID	BIGINT	The internal reference number of the product included in the RFQ request.
SKUGENFLAG	INTEGER NOT NULL DEFAULT 0	Reserved for IBM internal use.
PRICEADJUSTMENT	DOUBLE	Response percentage price for this product.
FIELD1	BIGINT	Customizable.
FIELD2	INTEGER	Customizable.
FIELD3	VARCHAR (254)	Customizable.
FIELD4	VARCHAR (254)	Customizable.
OPTCOUNTER	SMALLINT	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	RFQRSPPROD_ID	Primary Key
I0000353	RFQRSP_ID+RFQPROD_ID	Non-Unique Index
I0000733	RFQPROD_ID	Non-Unique Index
I0000734	CATENTRY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_686	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_687	CURRENCY	SETCURR	SETCCURR	Cascade
F_688	QTYUNIT_ID	QTYUNIT	QTYUNIT_ID	Cascade
F_689	RFQRSP_ID	RFQRSP	RFQRSP_ID	Cascade
F_999	RFQPROD_ID	RFQPROD	RFQPROD_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_988	RFQRSPPROD_ID	PATTRVALUE	RFQRSPPROD_ID	Cascade
F_998	RFQRSPPROD_ID	RFQRSPEVAL	RFQRSPPROD_ID	Cascade