WebSphere Commerce database table: RFQRSPPROD

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


Column Description(s):
Column NameColumn TypeDescription
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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031305420 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(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_686 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_688 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
F_999 RFQPROD_ID RFQPROD RFQPROD_ID Cascade
F_689 RFQRSP_ID RFQRSP RFQRSP_ID Cascade
F_687 CURRENCY SETCURR SETCCURR Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_988 RFQRSPPROD_ID PATTRVALUE RFQRSPPROD_ID Cascade
F_998 RFQRSPPROD_ID RFQRSPEVAL RFQRSPPROD_ID Cascade

Feedback