EM_CONVER_LINE

(SQL Table)
 Index Back

eSettlements - Conversation

eSettlements - Conversation Line Record

  • Related Language Record: EM_CONVERLN_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: EM_CONVER_HDR.BUSINESS_UNIT

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Default Value: EM_CONVER_HDR.VOUCHER_ID

    3 CONVER_HDR_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Header Sequence Number

    Default Value: EM_CONVER_HDR.CONVER_HDR_SEQ_NUM

    4 CONVER_LN_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number

    Default Value: 1

    5 CONVER_LN_DTTM DateTime(26) TIMESTAMP Conversation Datetime

    Default Value: %datetime

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