EB_CONVR_LST_VW

(SQL View)
 Index Back

eBilll Conversation List

eBilll Conversation List

SELECT A.SETID , A.BUSINESS_UNIT , A.CUST_ID , A.CONVER_DTTM_INIT , A.CONVER_DT , A.CONVER_SUBJECT , A.CONVER_SUB_TOPIC , A.CONVER_STATUS , A.INVOICE_ID , A.ITEM_LINE , A.CONVR_QUALIFIER_CD , A.OPRID , A.DESCRLONG , A.CONVER_DTTM FROM PS_EB_CONVR_VW A WHERE A.CONVER_DTTM = ( SELECT MIN(B.CONVER_DTTM) FROM PS_CUST_CONVER B WHERE B.SETID = A.SETID AND B.CUST_ID = A.CUST_ID AND B.CONVER_DTTM_INIT = A.CONVER_DTTM_INIT AND B.CONVER_VISIBILITY = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime
5 CONVER_DT Date(10) DATE Conversation Date
6 CONVER_SUBJECT Character(30) VARCHAR2(30) NOT NULL Conversation Subject
7 CONVER_SUB_TOPIC Character(30) VARCHAR2(30) NOT NULL Subject Topic
8 CONVER_STATUS Character(1) VARCHAR2(1) NOT NULL Conversation Status
C=Closed
N=New
O=Open
9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
10 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
11 CONVR_QUALIFIER_CD Character(2) VARCHAR2(2) NOT NULL Conversation Qualifier Code
BA=Buy Agremt
BI=Invoice #
CP=Cust Pay
CT=Contract
D=Document
I=Item
L=Lading
P=PO Number
PY=Payment ID
QU=Quote
RM=RMA
SC=Case Num
SO=Sale Order
12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
13 DESCRLONG Long Character CLOB Long Description
14 CONVER_DTTM DateTime(26) TIMESTAMP Conversation DateTime