RFQTARGET

This table holds the target stores for RFQs.

Column Descriptions:

NameTypeDescription
STORE_IDINTEGER NOT NULLThe identifier of the store that is being targeted.
RFQ_IDBIGINT NOT NULLThe internal reference number of the RFQ request.
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>STORE_ID+RFQ_IDPrimary Key
I0000358RFQ_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1020STORE_IDSTORESTORE_IDCascade
F_1021RFQ_IDRFQRFQ_IDCascade