RFQRSP

RFQ Response table. This table stores the basic RFQ response information.

Column Descriptions:

NameTypeDescription
RFQ_IDBIGINT NOT NULLThe ID of the RFQ to which this RFQ response relates.
TFTRADENG_IDBIGINTReserved for HCL internal use.
MAJORVERSIONINTEGER NOT NULLReserved for HCL internal use.
MEMBER_IDBIGINT NOT NULLThe ID of the member who created the RFQ Response.
MINORVERSIONINTEGER NOT NULLReserved for HCL internal use.
NAMEVARCHAR (200) NOT NULLThe name of the RFQ Response.
STATEINTEGER NOT NULLThe state of the RFQ Response. Valid values are as follows:
  • 1=draft
  • 2=active
  • 3=canceled
  • 4=in-evaluation
  • 5=pending approval
  • 6=rejected
  • 7=retracted
  • 8=won
  • 9=lost
  • 10=won completed
  • 11=lost completed
  • 12=won next round
  • 13=lost next round
REJECTREASONVARCHAR (254)If a response is in a rejected state, this field indicates why the response was rejected.
REMARKSVARCHAR (254)Free-form remarks that a seller provides when creating an RFQ Response.
CREATETIMETIMESTAMPDate and time the RFQ Response was created.
UPDATETIMETIMESTAMPDate and time the RFQ Response was updated.
CANCELTIMETIMESTAMPDate and time the RFQ Response was canceled.
MARKFORDELETEINTEGERIndicates if this RFQ Response is marked for deletion. Valid values are as follows:
  • 0=No
  • 1=Yes, this RFQ Response is marked for deletion
RFQRSP_IDBIGINT NOT NULLThe internal reference number of the RFQ Response.
DESCRIPTIONVARCHAR (254)Description of RFQ Response.
VERSIONFLAGSINTEGERReserved for HCL internal use.
STORE_IDINTEGER NOT NULLThe identifier of the store that this RFQ response was created in.
PREVRSPBIGINTReserved for HCL internal use.
ACCEPTACTIONINTEGER NOT NULL DEFAULT 0Indicates if all products in the response must be accepted. Valid values are as follows:
  • 0=all products must be accepted or rejected at the same time
  • 1=not all products must be accepted
EXTRFQRESPONSENUMVARCHAR (64)External RFQ response number used for customization.
FIELD1BIGINTCustomizable.
FIELD2INTEGERCustomizable.
FIELD3VARCHAR (254)Customizable.
FIELD4VARCHAR (254)Customizable.
FIELD5TIMESTAMPCustomizable.
FIELD6TIMESTAMPCustomizable.
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>RFQRSP_IDPrimary Key
I0000209NAME+MAJORVERSION+MINORVERSIONUnique Index
I0000351RFQ_ID+MEMBER_IDNon-Unique Index
I0000352NAMENon-Unique Index
I0000727MEMBER_IDNon-Unique Index
I0001279TFTRADENG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_682RFQ_IDRFQRFQ_IDCascade
F_683RFQRSP_IDTRADINGTRADING_IDCascade
F_684TFTRADENG_IDTFTRADENGTFTRADENG_IDCascade
F_685MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1000RFQRSP_IDRFQRSPTCRLRFQRSP_IDCascade
F_689RFQRSP_IDRFQRSPPRODRFQRSP_IDCascade
F_991RFQRSP_IDRFQRSPPARLRFQRSP_IDCascade
F_997RFQRSP_IDRFQRSPEVALRFQRSP_IDCascade