RFQPROD

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


Column Descriptions:

Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> 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
I0001278 RFQCATEGRY_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_678 CURRENCY SETCURR SETCCURR Cascade
F_679 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
F_680 RFQ_ID RFQ RFQ_ID Cascade
F_681 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_995 RFQCATEGRY_ID RFQCATEGRY RFQCATEGRY_ID Cascade


Referenced By Child Tables:

Constraint Columns Child Table Child Columns 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
Quantity unit - references data model
Request for Quote (RFQ) data model