RFQRSPPROD

RFQ response and product relationship table. This table stores the products included in a specific RFQ Response.

Column Descriptions:

NameTypeDescription
CATENTRY_IDBIGINTThe internal reference number of the CatalogEntry.
RFQRSP_IDBIGINT NOT NULLThe internal reference number of the RFQ Response.
QUANTITYDOUBLEResponse quantity for this product.
CURRENCYCHAR (3)The type of currency in which the price has been specified. This is a currency code as per ISO 4217 standards.
PRICEDECIMAL (20,5)Response price for this product.
QTYUNIT_IDCHAR (16)Unit of measure for the response quantity. For example, kilos, tons, or millimeters.
RFQCATENTRYIDBIGINTThe CatalogEntry ID of the product requested in the RFQ.
RFQRSPPROD_IDBIGINT NOT NULLThe internal reference number of the product included in the RFQ response.
RFQPROD_IDBIGINTThe internal reference number of the product included in the RFQ request.
SKUGENFLAGINTEGER NOT NULL DEFAULT 0Reserved for HCL internal use.
PRICEADJUSTMENTDOUBLEResponse percentage price for this product.
FIELD1BIGINTCustomizable.
FIELD2INTEGERCustomizable.
FIELD3VARCHAR (254)Customizable.
FIELD4VARCHAR (254)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RFQRSPPROD_IDPrimary Key
I0000353RFQRSP_ID+RFQPROD_IDNon-Unique Index
I0000733RFQPROD_IDNon-Unique Index
I0000734CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_686CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_687CURRENCYSETCURRSETCCURRCascade
F_688QTYUNIT_IDQTYUNITQTYUNIT_IDCascade
F_689RFQRSP_IDRFQRSPRFQRSP_IDCascade
F_999RFQPROD_IDRFQPRODRFQPROD_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_988RFQRSPPROD_IDPATTRVALUERFQRSPPROD_IDCascade
F_998RFQRSPPROD_IDRFQRSPEVALRFQRSPPROD_IDCascade