LC_EXT_LOG_LN

(SQL View)
 Index Back

SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.BUSINESS_UNIT_RTV , A.RTV_ID , A.RTV_LN_NBR , A.MATCH_RULE_ID , B.LANGUAGE_CD , B.MESSAGE_TEXT FROM PS_LC_EXT_LOG_DETL A , PSMSGCATLANG B WHERE (A.MATCH_RULE_ID = 'MAT-CUR' AND B.MESSAGE_SET_NBR = 7030 AND B.MESSAGE_NBR = 672) OR (A.MATCH_RULE_ID = 'MSC-CUR1' AND B.MESSAGE_SET_NBR = 7030 AND B.MESSAGE_NBR = 673) OR (A.MATCH_RULE_ID = 'MSC-CUR2' AND B.MESSAGE_SET_NBR = 7030 AND B.MESSAGE_NBR = 674) OR (A.MATCH_RULE_ID = 'MSC-AMT' AND B.MESSAGE_SET_NBR = 7030 AND B.MESSAGE_NBR = 675) OR (A.MATCH_RULE_ID = 'RTV-CUR' AND B.MESSAGE_SET_NBR = 7030 AND B.MESSAGE_NBR = 676)

  • Related Language Record for LC_EXT_LOG_DETL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_AP

    3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    4 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
    5 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    6 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    7 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    8 BUSINESS_UNIT_RTV Character(5) VARCHAR2(5) NOT NULL RTV Business Unit
    9 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
    10 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
    11 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID
    12 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    13 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254