CDT_CONV_HDR_VW

(SQL View)
 Index Back

CSR Desktop Conversations


SELECT SETID ,BUSINESS_UNIT , CUST_ID , CONVER_DTTM_INIT , CONVER_DT , CONVER_SUBJECT , CONVER_SUB_TOPIC , ROLENAME , CONVER_STATUS , DESCR , REVIEW_NEXT_DT , LETTER_CD , DUN_LETTER_COMP , FOLLOW_UP_ACTION , FOLLOW_UP_COMP , SUP_REVIEW , CNTCT_SEQ_NUM , SUP_STATUS , KEYWORD1 , KEYWORD2 , KEYWORD3 , PROMISE_DT , PROMISE_AMT , PROMISE_CONFIDENCE , REVIEW_OPRID , REVIEW_COMP , FOLLOW_UP_OPRID , THREAD_COUNT1 , ATTACH_EXIST , OPRID FROM PS_CUST_CONVER_HDR

  • Related Language Record: CUS_CNV_HDR_LNG

    • # 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 NOT NULL Initial Conversation DateTime

    Default Value: %datetime

    5 CONVER_DT Date(10) DATE Conversation Date
    6 CONVER_SUBJECT Character(30) VARCHAR2(30) NOT NULL Conversation Subject

    Prompt Table: SUBJECT_VW

    7 CONVER_SUB_TOPIC Character(30) VARCHAR2(30) NOT NULL Subject Topic

    Prompt Table: SUB_TOPIC_VW

    8 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    9 CONVER_STATUS Character(1) VARCHAR2(1) NOT NULL Conversation Status
    C=Closed
    N=New
    O=Open

    Default Value: N

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 REVIEW_NEXT_DT Date(10) DATE Next Review Date
    12 LETTER_CD Character(3) VARCHAR2(3) NOT NULL Specifies a type of correspondence used for follow-up letters or dunning notices. A letter code is associated with a customizable template to facilitate form letters.

    Prompt Table: LTR_CD_FOL_VW

    13 DUN_LETTER_COMP Character(1) VARCHAR2(1) NOT NULL Dunning Letter Complete

    Y/N Table Edit

    14 FOLLOW_UP_ACTION Character(10) VARCHAR2(10) NOT NULL Follow-Up Action

    Prompt Table: FOLLOWUP_TBL

    15 FOLLOW_UP_COMP Character(1) VARCHAR2(1) NOT NULL Follow Up Completed

    Y/N Table Edit

    Default Value: N

    16 SUP_REVIEW Character(1) VARCHAR2(1) NOT NULL Supervisor Review

    Y/N Table Edit

    Default Value: N

    17 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CONTACT

    18 SUP_STATUS Character(1) VARCHAR2(1) NOT NULL Supervisor Review Status
    I=Incomplete
    N=New
    R=Reviewed

    Default Value: N

    19 KEYWORD1 Character(10) VARCHAR2(10) NOT NULL Keyword

    Prompt Table: KEYWORD1_VW

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

    Prompt Table: KEYWORD2_VW

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

    Prompt Table: KEYWORD3_VW

    22 PROMISE_DT Date(10) DATE Promise Date
    23 PROMISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Forecast
    24 PROMISE_CONFIDENCE Character(1) VARCHAR2(1) NOT NULL Promise Confidence
    H=High
    L=Low
    M=Medium
    25 REVIEW_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

    Prompt Table: OPRID_VW

    26 REVIEW_COMP Character(1) VARCHAR2(1) NOT NULL Review Completed

    Y/N Table Edit

    Default Value: N

    27 FOLLOW_UP_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

    Prompt Table: OPRID_VW

    28 THREAD_COUNT1 Number(6,0) INTEGER NOT NULL Number of Entries
    29 ATTACH_EXIST Character(1) VARCHAR2(1) NOT NULL Attachments

    Y/N Table Edit

    Default Value: N

    30 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN_SRCH