CDT_CONV_DTL_VW

(SQL View)
 Index Back

Customer Conversations


SELECT SETID ,BUSINESS_UNIT , CUST_ID , CONVER_DTTM_INIT , CONVER_DT , CONVER_SEQ_NUM , CONVER_DTTM , DESCRLONG , OPRID , CONVER_VISIBILITY , CONTACT_ID FROM %Table(CUST_CONVER)

  • Related Language Record: CUST_CONVER_LNG

  • Parent record: CUSTOMER

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

    Default Value: CUST_CONVER_HDR.SETID

    Prompt Table: SP_SETID_NONVW

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BUARDS_NONVW

    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.

    Default Value: CUST_CONVER_HDR.CUST_ID

    Prompt Table: CUSTOMER

    4 CONVER_DTTM_INIT DateTime(26) TIMESTAMP NOT NULL Initial Conversation DateTime

    Default Value: CUST_CONVER_HDR.CONVER_DTTM_INIT

    5 CONVER_DT Date(10) DATE NOT NULL Conversation Date

    Default Value: %date

    6 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number
    7 CONVER_DTTM DateTime(26) TIMESTAMP NOT NULL Conversation DateTime

    Default Value: %datetime

    8 DESCRLONG Long Character CLOB NOT NULL Long Description
    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN_SRCH

    10 CONVER_VISIBILITY Character(1) VARCHAR2(1) NOT NULL Conversation Visibility

    Y/N Table Edit

    11 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: CONTACT_ALL_VW