RFQ_VNDR_BY_RFQ (SQL View)	Index Back
All Dispatched Suppliers By RF

RFQ_VNDR_BY_RFQ

(SQL View)

All Dispatched Suppliers By RF

select a.business_unit, a.rfq_id, a.vendor_setid, a.vendor_id, a.vndr_loc, a.disp_status, a.disp_method, a.dttm_disp, a.address_seq_num, a.cntct_seq_num, a.sales_cntct_seq_n, b.rfq_ref, b.buyer_id, b.OPRID_MODIFIED_BY, b.LAST_DTTM_UPDATE from PS_RFQ_DISP_HDR a, ps_rfq_hdr b where a.business_unit = b.business_unit and a.rfq_id = b.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
Prompt Table: SP_BU_PM_NONVW

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
Prompt Table: VENDOR_VW

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

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 RFQ_REF Character(30) VARCHAR2(30) NOT NULL RFQ Reference

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

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

15 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 Prompt Table: SP_BU_PM_NONVW
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 Prompt Table: VENDOR_VW
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
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	RFQ_REF	Character(30)	VARCHAR2(30) NOT NULL	RFQ Reference
13	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
14	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.
15	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.