RFQ response and product relationship table. This
table stores the products included in a specific RFQ Response.
Column Descriptions:
Name | 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 HCL 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | RFQRSPPROD_ID | Primary Key |
I0000353 | RFQRSP_ID+RFQPROD_ID | Non-Unique Index |
I0000733 | RFQPROD_ID | Non-Unique Index |
I0000734 | CATENTRY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | 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 Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_988 | RFQRSPPROD_ID | PATTRVALUE | RFQRSPPROD_ID | Cascade |
F_998 | RFQRSPPROD_ID | RFQRSPEVAL | RFQRSPPROD_ID | Cascade |