RFQ response and product relationship table. This table stores the products included in a specific RFQ Response.
Column Descriptions
| Column Name
| Column 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 IBM 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
| Reserved for IBM internal use.
|