AR_CONV_MSG_LVW

(SQL View)
 Index Back

Conversation Entries


SELECT C.SETID , C.BUSINESS_UNIT , C.CUST_ID ,C.CONVER_DTTM_INIT ,C.CONVER_DT ,C.CONVER_SEQ_NUM ,L.LANGUAGE_CD , L.DESCRLONG FROM PS_CUST_CONVER_HDR H , PS_CUST_CONVER C , PS_CUST_CONVER_LNG L WHERE H.SETID = L.SETID AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.CUST_ID = L.CUST_ID AND H.CONVER_DTTM_INIT=L.CONVER_DTTM_INIT AND H.CONVER_DT=L.CONVER_DT AND H.SETID = C.SETID AND H.BUSINESS_UNIT = C.BUSINESS_UNIT AND H.CUST_ID = C.CUST_ID AND H.CONVER_DTTM_INIT = C.CONVER_DTTM_INIT AND H.CONVER_DT=C.CONVER_DT AND C.SETID = L.SETID AND C.BUSINESS_UNIT = L.BUSINESS_UNIT AND C.CUST_ID = L.CUST_ID AND C.CONVER_DTTM_INIT=L.CONVER_DTTM_INIT AND C.CONVER_DT=L.CONVER_DT AND C.CONVER_SEQ_NUM=L.CONVER_SEQ_NUM

  • Related Language Record for AR_CONV_MSGS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    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.

    Prompt Table: CUSTOMER

    4 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime
    5 CONVER_DT Date(10) DATE Conversation Date
    6 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCRLONG Long Character CLOB Long Description