AP_VNDR_CNVR_VW

(SQL View)
 Index Back

Supplier Conversation SF view

Supplier Conversation PTSF view

SELECT a.setid , a.vendor_id , a.conver_dt , a.conver_seq_num , a.conver_topic , a.oprid , a.review_date , a.review_next_date , a.keyword1 , a.keyword2 , a.keyword3 , b.contact_name , a.ses_last_dttm , %Coalesce(C.OPRDEFNDESC, a.oprid) , A.SETID , a.descrlong , A.CONVER_DT , %Substring(%Cast(A.CONVER_DT, Date, Character), 1, 4) , %Substring(%Cast(A.CONVER_DT, Date, Character), 9, 2) , %Substring(%Cast(A.CONVER_DT, Date, Character), 6, 2) , %Substring(%Cast(A.CONVER_DT, Date, Character), 6, 2) , a.keyword1 %Concat ' ' %Concat a.keyword2 %Concat ' ' %Concat a.keyword3 %Concat ' ' %Concat a.conver_topic %Concat ' ' %Concat %CAST(a.descrlong , LONG , CHARACTER) FROM PS_VENDOR_CONVER A LEFT OUTER JOIN PS_VNDR_CNTCT_VW1 B ON B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.CNTCT_SEQ_NUM = A.CNTCT_SEQ_NUM LEFT OUTER JOIN PSOPRDEFN C ON A.OPRID = C.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 CONVER_DT Date(10) DATE NOT NULL Conversation Date

Default Value: %date

4 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number
5 CONVER_TOPIC Character(30) VARCHAR2(30) NOT NULL Conversation Topic
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 REVIEW_DATE Date(10) DATE Review Date
8 REVIEW_NEXT_DATE Date(10) DATE Next Review Date
9 KEYWORD1 Character(10) VARCHAR2(10) NOT NULL Keyword

Prompt Table: KEYWORD_AP

10 KEYWORD2 Character(10) VARCHAR2(10) NOT NULL Keyword

Prompt Table: KEYWORD_AP

11 KEYWORD3 Character(10) VARCHAR2(10) NOT NULL Keyword

Prompt Table: KEYWORD_AP

12 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
13 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp
14 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
15 DESCR120 Character(120) VARCHAR2(120) NOT NULL Description
16 DESCRLONG Long Character CLOB Long Description
17 SES_DOCUMENT_DATE Date(10) DATE Document Date
18 SES_YEAR Character(4) VARCHAR2(4) NOT NULL Document Date Hierarchy
19 SES_DAY Character(2) VARCHAR2(2) NOT NULL Day
20 SES_MONTH Character(2) VARCHAR2(2) NOT NULL Month
01=01: January
02=02: February
03=03: March
04=04: April
05=05: May
06=06: June
07=07: July
08=08: August
09=09: September
10=10: October
11=11: November
12=12: December
21 SES_MONTH2 Character(2) VARCHAR2(2) NOT NULL Month
01=01: January
02=02: February
03=03: March
04=04: April
05=05: May
06=06: June
07=07: July
08=08: August
09=09: September
10=10: October
11=11: November
12=12: December
22 SES_PROC_CMMT Long Character CLOB Common Procurement Comment Field