WebSphere Commerce database table: RFQPROD

RFQ Request and Product relationship table. This table stores information about the products requested in an RFQ.

Column Descriptions
Column Name Column Type Description
RFQ_ID BIGINT NOT NULL The internal reference number of the RFQ.
QUANTITY DOUBLE Quantity requested for this product.
PRICE DECIMAL (20,5) Requested price 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.
QTYUNIT_ID CHAR(16) Unit of measure for the quantity requested. For example, kilos, tons, or millimeters.
CATENTRY_ID BIGINT The internal reference number of the CatalogEntry.
RFQPROD_ID BIGINT NOT NULL The internal reference number of the product included in the RFQ.
RFQPRODNAME VARCHAR(128) The name of the made to order item.
RFQCATEGRY_ID BIGINT The internal reference number of the category of the product in RFQ.
CHANGEABLE INTEGER NOT NULL DEFAULT 0 Indicates if the product can be substituted in the response. Valid values are as follows:

  • 0=no

  • 1=yes

PRICEADJUSTMENT DOUBLE Requested percentage pricing for this product.
NEGOTIATIONTYPE INTEGER NOT NULL DEFAULT 1 Identifies the type of negotiation. Valid values are as follows:

  • 1=Item, package, or product fixed pricing

  • 2=Item, package, or product percentage pricing

  • 3=Dynamic kit fixed pricing

  • 4=Dynamic kit percentage pricing

FIELD1 BIGINT Customizable.
FIELD2 INTEGER Customizable.
FIELD3 VARCHAR(254) Customizable.
FIELD4 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235243010 RFQPROD_ID Primary Key
I0000349 RFQ_ID+CATENTRY_ID Non-Unique Index
I0000350 RFQ_ID Non-Unique Index
I0000372 RFQ_ID+NEGOTIATIONTYPE Non-Unique Index
I0000726 CATENTRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_681 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_679 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
F_680 RFQ_ID RFQ RFQ_ID Cascade
F_995 RFQCATEGRY_ID RFQCATEGRY RFQCATEGRY_ID Cascade
F_678 CURRENCY SETCURR SETCCURR Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1032 RFQPROD_ID OICOMPLIST RFQPROD_ID Cascade
F_989 RFQPROD_ID PATTRVALUE RFQPROD_ID Cascade
F_999 RFQPROD_ID RFQRSPPROD RFQPROD_ID Cascade
Related reference