Database Table: RFQPROD

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035050660 RFQPROD_ID Primary Key
Constraints:
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

Referenced By:
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