Table C_RfQ

PRIMARY KEY
C_RfQ_ID NUMBER (10, 0) NOT NULL

AD_Client_ID NUMBER (10, 0) NOT NULL
AD_Org_ID NUMBER (10, 0) NOT NULL
IsActive CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL
Created DATE default: SYSDATE NOT NULL
CreatedBy NUMBER (10, 0) NOT NULL
Updated DATE default: SYSDATE NOT NULL
UpdatedBy NUMBER (10, 0) NOT NULL
Name NVARCHAR2 (60) NOT NULL
Description NVARCHAR2 (255)
Help NVARCHAR2 (2000)
C_RfQ_Topic_ID NUMBER (10, 0) NOT NULL		C_RfQ_Topic
C_Currency_ID NUMBER (10, 0) NOT NULL		C_Currency
DateResponse DATE NOT NULL
IsRfQResponseAccepted CHAR (1) default: 'Y' CHECK ( IsRfQResponseAccepted in ( 'Y' , 'N' )) NOT NULL
DateWorkStart DATE NOT NULL
DeliveryDays NUMBER (10, 0) NOT NULL
DateWorkComplete DATE NOT NULL
QuoteType CHAR (1) NOT NULL
IsQuoteTotalAmt CHAR (1) default: 'N' CHECK ( IsQuoteTotalAmt in ( 'Y' , 'N' )) NOT NULL
IsQuoteAllQty CHAR (1) default: 'Y' CHECK ( IsQuoteAllQty in ( 'Y' , 'N' )) NOT NULL
DocAction CHAR (2) NOT NULL
DocStatus CHAR (2) NOT NULL
IsSelfService CHAR (1) default: 'N' CHECK ( IsSelfService in ( 'Y' , 'N' )) NOT NULL	Was entered and/or can be edited by user via Self Service
IsInvitedVendorsOnly CHAR (1) default: 'N' CHECK ( IsInvitedVendorsOnly in ( 'Y' , 'N' )) NOT NULL
C_BPartner_ID NUMBER (10, 0)		C_BPartner
C_BPartner_Location_ID NUMBER (10, 0)		C_BPartner_Location
AD_User_ID NUMBER (10, 0)		AD_User
OfferAmt NUMBER default: 0
Margin NUMBER
CreateSO CHAR (1)
CreatePO CHAR (1)
PublishRfQ CHAR (1)
Processing CHAR (1)
Processed CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) NOT NULL
C_Order_ID NUMBER (10, 0)		C_Order
FOREIGN KEY ADUser_CRfQ: AD_User_ID => AD_User CBPartner_CRfQ: C_BPartner_ID => C_BPartner CBPLocation_CRfQ: C_BPartner_Location_ID => C_BPartner_Location CCurrency_CRfQ: C_Currency_ID => C_Currency COrder_CRfQ: C_Order_ID => C_Order CRfQTopic_CRfQ: C_RfQ_Topic_ID => C_RfQ_Topic
REFERENCED BY C_RfQLine, C_RfQResponse