CUSTV_CONVER_VW

(SQL View)
 Index Back

Conversations Header Record


SELECT A.SETID , A.BUSINESS_UNIT , A.CUST_ID , A.CONVER_DTTM_INIT , A.CONVER_DT , A.CONVER_SUBJECT , A.CONVER_SUB_TOPIC , A.ROLENAME , A.CONVER_STATUS , A.DESCR , A.REVIEW_NEXT_DT , A.LETTER_CD , A.DUN_LETTER_COMP , A.FOLLOW_UP_ACTION , A.FOLLOW_UP_COMP , A.FOLLOW_UP_DT , A.SUP_REVIEW , A.CNTCT_SEQ_NUM , A.SUP_STATUS , A.KEYWORD1 , A.KEYWORD2 , A.KEYWORD3 , A.PROMISE_TO_PAY , A.PROMISE_DT , A.PROMISE_AMT , A.PAY_PROMISE_AMT , A.TOLERANCE_DAYS , A.TOLERANCE_PAY , A.PROMISE_ACTION , A.PROMISE_OPRID , A.PROMISE_COMP , A.PROMISE_OVRIDE , A.PROMISE_RVW_DT , A.AR_REASON_TYPE , A.AR_PROMISE_STATUS , A.CURRENCY_CD , A.PROMISE_CONFIDENCE , A.REVIEW_OPRID , A.REVIEW_COMP , A.FOLLOW_UP_OPRID , A.THREAD_COUNT1 , A.ATTACH_EXIST , A.OPRID FROM PS_CUST_CONVER_HDR A , ps_cal_detp_tbl c , PS_BUS_UNIT_OPT_AR B , PS_SET_CNTRL_REC R1 , PS_SET_CNTRL_REC R2 , ps_cal_detp_tbl C1 WHERE A.BUSINESS_UNIT <> ' ' AND R1.SETCNTRLVALUE = A.BUSINESS_UNIT AND R1.RECNAME = 'BUS_UNIT_OPT_AR' AND B.SETID = R1.SETID AND R2.SETCNTRLVALUE = A.business_unit AND R2.RECNAME = 'CAL_DEFN_TBL' AND c.setid = R2.SETID AND c.calendar_id = B.calendar_id AND %CurrentDateIn BETWEEN c.begin_dt AND c.end_dt AND C1.setid = R2.SETID AND C1.calendar_id = B.calendar_id AND C1.FISCAL_YEAR = C.FISCAL_YEAR AND C1.ACCOUNTING_PERIOD = 1 AND A.CONVER_DT >= C1.BEGIN_DT AND A.CONVER_DT <= %CurrentDateIn AND A.PROMISE_TO_PAY = 'Y'

  • 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

    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.
    4 CONVER_DTTM_INIT DateTime(26) TIMESTAMP NOT NULL Initial Conversation 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 FOLLOW_UP_DT Date(10) DATE Date of Follow-up Letter
    17 SUP_REVIEW Character(1) VARCHAR2(1) NOT NULL Supervisor Review

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: CUST_CONTACT

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

    Default Value: N

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

    Prompt Table: KEYWORD1_VW

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

    Prompt Table: KEYWORD2_VW

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

    Prompt Table: KEYWORD3_VW

    23 PROMISE_TO_PAY Character(1) VARCHAR2(1) NOT NULL CWB Promise of Payment

    Y/N Table Edit

    Default Value: N

    24 PROMISE_DT Date(10) DATE Promise Date
    25 PROMISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Forecast
    26 PAY_PROMISE_AMT Number(27,3) DECIMAL(26,3) NOT NULL Promise to Pay amount
    27 TOLERANCE_DAYS Number(6,0) INTEGER NOT NULL CWB Tolerance Days
    28 TOLERANCE_PAY Number(2,0) SMALLINT NOT NULL CWB Payment Tolerance Amount
    29 PROMISE_ACTION Character(4) VARCHAR2(4) NOT NULL CWB Broken Promise Action

    Prompt Table: ACTION_TBL

    30 PROMISE_OPRID Character(30) VARCHAR2(30) NOT NULL Promise Operator ID

    Prompt Table: OPRID_VW2

    31 PROMISE_COMP Character(1) VARCHAR2(1) NOT NULL CWB Promise Complete

    Y/N Table Edit

    Default Value: N

    32 PROMISE_OVRIDE Character(1) VARCHAR2(1) NOT NULL CWB Override Promise Status

    Y/N Table Edit

    Default Value: N

    33 PROMISE_RVW_DT Date(10) DATE Promise Review Date
    34 AR_REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Override Reason
    CNCL=Cancelled
    INVP=Invalid Payment
    PDOV=Promise Date Override
    WRI=Wrong Items
    WRP=Wrong Payment
    35 AR_PROMISE_STATUS Character(1) VARCHAR2(1) NOT NULL Promise Status field used in Collections Workbench
    B=Broken
    C=Cancelled
    K=Kept
    N=None
    O=Open

    Default Value: N

    36 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURR_CD_AR_VW

    37 PROMISE_CONFIDENCE Character(1) VARCHAR2(1) NOT NULL Promise Confidence
    H=High
    L=Low
    M=Medium

    Default Value: M

    38 REVIEW_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

    Prompt Table: OPRID_VW2

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: OPRID_VW2

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: PSOPRDEFN_SRCH