AR_CONV_LIST_VW

(SQL View)
 Index Back

All Customers Search Record

Conversations Search Record

SELECT DISTINCT B.SETID , B.BUSINESS_UNIT , B.CUST_ID , B.CONVER_DTTM_INIT , B.NAME1 , B.DESCR , B.CONVER_DT , B.CONVER_STATUS , B.THREAD_COUNT1 , B.ATTACH_EXIST , A.CONVR_QUAL_FIELD , A.ITEM_LINE , A.CONVR_QUAL_BU , A.CONVR_QUAL_FIELD3 , B.CONVER_SUBJECT , B.CONVER_SUB_TOPIC , B.SUP_REVIEW , B.SUP_STATUS , B.REVIEW_COMP , B.REVIEW_NEXT_DT , B.PROMISE_AMT , B.PAY_PROMISE_AMT , B.CURRENCY_CD , B.PROMISE_DT , B.AR_PROMISE_STATUS , B.OPRID FROM PS_AR_CUST_AL_SRVW B , PS_CUST_CONVER_DTL A WHERE B.SETID = A.SETID(+) AND B.CUST_ID = A.CUST_ID(+) AND B.CONVER_DTTM_INIT = A.CONVER_DTTM_INIT(+) AND A.CONVR_QUALIFIER_CD(+) = 'I'

  • Related Language Record: AR_CONV_LSTL2VW

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_AR_SET_OPRVW

    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: AR_CUST_AL2_VW

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

    Default Value: %datetime

    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 CONVER_DT Date(10) DATE Conversation Date
    8 CONVER_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    C=Closed
    N=New
    O=Open
    9 THREAD_COUNT1 Number(6,0) INTEGER NOT NULL Number of Entries
    10 ATTACH_EXIST Character(1) VARCHAR2(1) NOT NULL Attachments

    Y/N Table Edit

    Default Value: N

    11 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

    Prompt Table: CONVR_ALIT_I_VW

    12 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
    13 ITEM_BU Character(5) VARCHAR2(5) NOT NULL Item Business Unit
    14 ITEM_CUSTID Character(15) VARCHAR2(15) NOT NULL Item Customer ID
    15 CONVER_SUBJECT Character(30) VARCHAR2(30) NOT NULL Subject

    Prompt Table: CONVER_SUBJ_VW

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

    Prompt Table: CONVER_TOPIC_VW

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

    Y/N Table Edit

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

    Y/N Table Edit

    20 REVIEW_NEXT_DT Date(10) DATE Next Review Date
    21 PROMISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Referenced
    22 PAY_PROMISE_AMT Number(27,3) DECIMAL(26,3) NOT NULL Promise to Pay amount
    23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    24 PROMISE_DT Date(10) DATE Promise Date
    25 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
    26 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).