RFQ_BY_VNDR (SQL View)	Index Back
All RFQs dispatched to Supplie

RFQ_BY_VNDR

(SQL View)

All RFQs dispatched to Supplie

select a.business_unit, a.vendor_setid, a.vendor_id, a.vndr_loc, a.rfq_id, a.disp_status, a.disp_method, a.dttm_disp, a.address_seq_num, a.cntct_seq_num, a.sales_cntct_seq_n, b.vendor_name_short, c.rfq_ref, c.origin, c.buyer_id, c.pymnt_terms_cd, c.bill_location, c.request_date, c.dttm_opened, c.dttm_closed, c.currency_cd, c.rfq_status, c.rt_type, %subrec(last_update_sbr, c) from ps_rfq_disp_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 DISP_STATUS Character(1) VARCHAR2(1) NOT NULL Dispatch Status
Y/N Table Edit

7 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print

8 DTTM_DISP DateTime(26) TIMESTAMP Date Time Dispatched

9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Default Value: VENDOR.PRIM_ADDR_SEQ_NUM
Prompt Table: VENDOR_ADDR_VW

10 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
Prompt Table: VENDOR_CNTCT_VW

11 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson
Prompt Table: VENDOR_CNTCT_VW

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

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

14 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

15 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

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

17 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

18 REQUEST_DATE Date(10) DATE Requested

19 DTTM_OPENED DateTime(26) TIMESTAMP Date Time RFQ is Opened

20 DTTM_CLOSED DateTime(26) TIMESTAMP Date Time RFQ is Closed

21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

22 RFQ_STATUS Character(1) VARCHAR2(1) NOT NULL RFQ Status
A=Approved
C=Closed
H=On Hold
O=Open
X=Canceled

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

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

25 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 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	DISP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Dispatch Status Y/N Table Edit
7	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
8	DTTM_DISP	DateTime(26)	TIMESTAMP	Date Time Dispatched
9	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: VENDOR.PRIM_ADDR_SEQ_NUM Prompt Table: VENDOR_ADDR_VW
10	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT_VW
11	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson Prompt Table: VENDOR_CNTCT_VW
12	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
13	RFQ_REF	Character(30)	VARCHAR2(30) NOT NULL	RFQ Reference
14	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
15	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
16	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.
17	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location
18	REQUEST_DATE	Date(10)	DATE	Requested
19	DTTM_OPENED	DateTime(26)	TIMESTAMP	Date Time RFQ is Opened
20	DTTM_CLOSED	DateTime(26)	TIMESTAMP	Date Time RFQ is Closed
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
22	RFQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	RFQ Status A=Approved C=Closed H=On Hold O=Open X=Canceled
23	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.
24	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.
25	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.