RFQ Request and Product relationship table. This table stores information about the products requested in an RFQ.
Column Name | Column Type | Column Description |
---|---|---|
CATENTRY_ID | BIGINT NULL |
The internal reference number of the CatalogEntry. |
CHANGEABLE | INTEGER NOT NULL, DEFAULT 0 |
Indicates if the product can be substituted in the response, 0 - no, 1 - yes. |
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 |
Requested price for this product. |
QTYUNIT_ID | CHARACTER (16) NULL |
Unit of measure for the quantity requested. For example, kilos, tons, or millimeters. |
QUANTITY | DOUBLE NULL |
Quantity requested for this product. |
RFQCATEGRY_ID | BIGINT NULL |
The internal reference number of the category of the product in RFQ. |
RFQPRODNAME | VARCHAR (128) NULL |
The name of the made to order item. |
RFQPROD_ID | BIGINT NOT NULL |
The internal reference number of the product included in the RFQ request. |
RFQ_ID | BIGINT NOT NULL |
The internal reference number of the RFQ. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035050660 | RFQPROD_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_678 | CURRENCY | SETCURR | SETCCURR | Cascade |
F_679 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | Cascade |
F_680 | RFQ_ID | RFQ | RFQ_ID | Cascade |
F_681 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_995 | RFQCATEGRY_ID | RFQCATEGRY | RFQCATEGRY_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_989 | RFQPROD_ID | PATTRVALUE | RFQPROD_ID | Cascade |
F_999 | RFQPROD_ID | RFQRSPPROD | RFQPROD_ID | Cascade |