RFQPROD

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

Column Descriptions:

NameTypeDescription
RFQ_IDBIGINT NOT NULLThe internal reference number of the RFQ.
QUANTITYDOUBLEQuantity requested for this product.
PRICEDECIMAL (20,5)Requested price 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.
QTYUNIT_IDCHAR (16)Unit of measure for the quantity requested. For example, kilos, tons, or millimeters.
CATENTRY_IDBIGINTThe internal reference number of the CatalogEntry.
RFQPROD_IDBIGINT NOT NULLThe internal reference number of the product included in the RFQ.
RFQPRODNAMEVARCHAR (128)The name of the made to order item.
RFQCATEGRY_IDBIGINTThe internal reference number of the category of the product in RFQ.
CHANGEABLEINTEGER NOT NULL DEFAULT 0Indicates if the product can be substituted in the response. Valid values are as follows:
  • 0=no
  • 1=yes
PRICEADJUSTMENTDOUBLERequested percentage pricing for this product.
NEGOTIATIONTYPEINTEGER NOT NULL DEFAULT 1Identifies 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
FIELD1BIGINTCustomizable.
FIELD2INTEGERCustomizable.
FIELD3VARCHAR (254)Customizable.
FIELD4VARCHAR (254)Customizable.
OPTCOUNTERSMALLINTThe 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>RFQPROD_IDPrimary Key
I0000349RFQ_ID+CATENTRY_IDNon-Unique Index
I0000350RFQ_IDNon-Unique Index
I0000372RFQ_ID+NEGOTIATIONTYPENon-Unique Index
I0000726CATENTRY_IDNon-Unique Index
I0001278RFQCATEGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_678CURRENCYSETCURRSETCCURRCascade
F_679QTYUNIT_IDQTYUNITQTYUNIT_IDCascade
F_680RFQ_IDRFQRFQ_IDCascade
F_681CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_995RFQCATEGRY_IDRFQCATEGRYRFQCATEGRY_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1032RFQPROD_IDOICOMPLISTRFQPROD_IDCascade
F_989RFQPROD_IDPATTRVALUERFQPROD_IDCascade
F_999RFQPROD_IDRFQRSPPRODRFQPROD_IDCascade