Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RFQRSPPROD
RFQ response and product relationship table. This table stores the products included in a specific RFQ Response.
Column Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030422780 RFQRSPPROD_ID Primary Key I0000353 RFQRSP_ID+RFQPROD_ID Non-Unique Index I0000733 RFQPROD_ID Non-Unique Index I0000734 CATENTRY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_988 RFQRSPPROD_ID PATTRVALUE RFQRSPPROD_ID Cascade F_998 RFQRSPPROD_ID RFQRSPEVAL RFQRSPPROD_ID Cascade
Related reference
_vcc_freeselect_bottom_