WebSphere Commerce database table: RFQRSPPROD

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 NOT NULL DEFAULT 0 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

Related reference
Quantity unit - references data model
Request for Quote (RFQ) data model

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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

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

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

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