Database Table: RFQRSPPROD

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

Column Name Column Type Column Description
CATENTRY_ID BIGINT
NULL
The internal reference number of the CatalogEntry.
CURRENCY CHARACTER (3)
NULL
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)
NULL
Response price for this product.
QTYUNIT_ID CHARACTER (16)
NULL
Unit of measure for the response quantity. For example, kilos, tons, or millimeters.
QUANTITY DOUBLE
NULL
Response quantity for this product.
RFQCATENTRYID BIGINT
NULL
The CatalogEntry ID of the product requested in the RFQ.
RFQPROD_ID BIGINT
NULL
The internal reference number of the product included in the RFQ request.
RFQRSPPROD_ID BIGINT
NOT NULL
The internal reference number of the product included in the RFQ response.
RFQRSP_ID BIGINT
NOT NULL
The internal reference number of the RFQ Response.
SKUGENFLAG INTEGER
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035051990 RFQRSPPROD_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
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