EM_CONVER_HDRVW

(SQL View)
 Index Back

eSettlements - Conversation

eSettlements - Conversation Header Record

SELECT a.business_unit , a.voucher_id , a.conver_hdr_seq_num , a.conver_hdr_dttm , a.em_topic_status , a.oprid_from , a.oprid_to , a.em_message_topic FROM PS_EM_CONVER_HDR a

  • Related Language Record: EM_CONVERHDR_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 CONVER_HDR_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Header Sequence Number

    Default Value: 1

    4 CONVER_HDR_DTTM DateTime(26) TIMESTAMP NOT NULL Conversation Datetime

    Default Value: %datetime

    5 EM_TOPIC_STATUS Character(1) VARCHAR2(1) NOT NULL Topic Status
    C=Closed
    O=Open

    Default Value: O

    6 OPRID_FROM Character(30) VARCHAR2(30) NOT NULL A user's ID
    7 OPRID_TO Character(30) VARCHAR2(30) NOT NULL A user's ID

    Prompt Table: EM_SUP_USER_VW

    8 EM_MESSAGE_TOPIC Character(50) VARCHAR2(50) NOT NULL Message Topic