RFQ_RESP_BYVNDR (SQL View)	Index Back
All RFQs Responded by Supplier

RFQ_RESP_BYVNDR

(SQL View)

All RFQs Responded by Supplier

select a.business_unit, a.vendor_setid, a.vendor_id, a.vndr_loc, a.rfq_id, a.resp_method, a.dttm_resp, a.currency_cd, a.pymnt_terms_cd, a.address_seq_num, a.cntct_seq_num, a.sales_cntct_seq_n, b.vendor_name_short, c.rfq_ref, c.pymnt_terms_cd, c.currency_cd from ps_rfq_resp_hdr a, PS_VENDOR b, ps_rfq_hdr c where a.vendor_setid = b.setid and a.vendor_id = b.vendor_id and a.business_unit = c.business_unit and a.rfq_id = c.rfq_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_VW

4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

5 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID

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

7 DTTM_RESP DateTime(26) TIMESTAMP Date Time Responded

8 CURRENCY_RESP Character(3) VARCHAR2(3) NOT NULL Response Currency Code

9 PYMNT_TERMS_RESP Character(5) VARCHAR2(5) NOT NULL RFQ Resp. Payment Terms

10 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

11 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

12 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson

13 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

14 RFQ_REF Character(30) VARCHAR2(30) NOT NULL RFQ Reference

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

16 CURRENCY_RFQ Character(3) VARCHAR2(3) NOT NULL RFQ Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_VW
4	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
5	RFQ_ID	Character(10)	VARCHAR2(10) NOT NULL	RFQ ID
6	RESP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Response Method EDX=Electronic Document Exchange FAX=Fax PHN=Phone PRN=Print
7	DTTM_RESP	DateTime(26)	TIMESTAMP	Date Time Responded
8	CURRENCY_RESP	Character(3)	VARCHAR2(3) NOT NULL	Response Currency Code
9	PYMNT_TERMS_RESP	Character(5)	VARCHAR2(5) NOT NULL	RFQ Resp. Payment Terms
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
11	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
12	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson
13	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
14	RFQ_REF	Character(30)	VARCHAR2(30) NOT NULL	RFQ Reference
15	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.
16	CURRENCY_RFQ	Character(3)	VARCHAR2(3) NOT NULL	RFQ Currency Code