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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035051990 | RFQRSPPROD_ID | Primary Key |
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 |
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 |