RFQCATEGRY

This table holds categories created in each RFQ.

Column Descriptions:

NameTypeDescription
RFQCATEGRY_IDBIGINT NOT NULLThe internal reference number of the category used in the RFQ.
NAMEVARCHAR (200) NOT NULLThe external name that is used to identify the category of the products in RFQ.
RFQ_IDBIGINT NOT NULLThe internal reference number of the RFQ.
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>RFQCATEGRY_IDPrimary Key
I0000297RFQ_ID+NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_994RFQ_IDRFQRFQ_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_995RFQCATEGRY_IDRFQPRODRFQCATEGRY_IDCascade