RFQ response and product relationship table. This table stores the products included in a specific RFQ Response.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_988 |
RFQRSPPROD_ID |
PATTRVALUE |
RFQRSPPROD_ID |
Cascade |
F_998 |
RFQRSPPROD_ID |
RFQRSPEVAL |
RFQRSPPROD_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.