PO_SSRFQHDR_VW (SQL View)	Index Back
SS eRFQ view. Used by PO_SSRFQ_RESP page.

PO_SSRFQHDR_VW

(SQL View)

SS eRFQ view.

Used by PO_SSRFQ_RESP page.

SELECT BUSINESS_UNIT , RFQ_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , STATUS , RESP_METHOD , DTTM_RESP , PYMNT_TERMS_CD , ADDRESS_SEQ_NUM , CNTCT_SEQ_NUM , SALES_CNTCT_SEQ_N , BILL_LOCATION , CURRENCY_CD , VENDOR_REF_ID , %Sql(LAST_UPDATE_SBR) FROM PS_RFQ_RESP_HDR

# 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 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

7 RESP_METHOD Character(3) VARCHAR2(3) NOT NULL Response Method
EDX=Electronic Document Exchange
FAX=Fax
PHN=Phone
PRN=Print

8 DTTM_RESP DateTime(26) TIMESTAMP Date Time Responded
Default Value: %date

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: PAY_TRMS_AP_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
Default Value: RFQ_HDR.BILL_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 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.

17 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.

#	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	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
7	RESP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Response Method EDX=Electronic Document Exchange FAX=Fax PHN=Phone PRN=Print
8	DTTM_RESP	DateTime(26)	TIMESTAMP	Date Time Responded Default Value: %date
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: PAY_TRMS_AP_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 Default Value: RFQ_HDR.BILL_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	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.
17	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.