RFQ Request and Product relationship table. This table stores information about the products requested in an RFQ.
Column Description(s):
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:
|
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031304880 |
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 |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | 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
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.