RFQ_RESPHDR_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RFQ_ID	Character(10)	VARCHAR2(10) NOT NULL	RFQ ID
3	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
6	DTTM_RESP	DateTime(26)	TIMESTAMP	Date Time Responded
7	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
8	RESP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Response Method EDX=Electronic Document Exchange FAX=Fax PHN=Phone PRN=Print
9	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. Prompt Table: PYMT_TR_EFF_VW
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: VENDOR_ADDR_VW
11	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT_VW
12	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson Prompt Table: VENDOR_CNTCT_VW
13	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Prompt Table: LOCATION_TBL
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	VENDOR_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Vendor reference quote number
16	RFQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	RFQ Status A=Approved C=Closed H=On Hold O=Open X=Canceled
17	RFQ_REF	Character(30)	VARCHAR2(30) NOT NULL	RFQ Reference
18	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_PO
19	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_ACTIVE_VW
20	RFQ_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
21	RFQ_PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
22	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
23	RATE_DATE	Date(10)	DATE	Exchange Rate Date
24	REQUEST_DATE	Date(10)	DATE	Requested
25	DTTM_OPENED	DateTime(26)	TIMESTAMP NOT NULL	Date Time RFQ is Opened
26	DTTM_CLOSED	DateTime(26)	TIMESTAMP	Date Time RFQ is Closed
27	ADVERTISED_DT	Date(10)	DATE	RFQ Advertised Date
28	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
29	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
30	ENTERED_DT	Date(10)	DATE	Entered on
31	APPROVAL_DT	Date(10)	DATE	Date of Approval
32	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
33	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.