CHNG_MSGLG_VWLG

(SQL View)
 Index Back

Change Order Reqt Message Log


SELECT C.PROCESS_INSTANCE , C.BUSINESS_UNIT , C.PO_ID , C.CHNG_SOURCE , C.CHNG_DTTM , C.LINE_NBR , C.SCHED_NBR , C.FIELDNAME , C.MESSAGE_SET_NBR , C.MESSAGE_NBR , M.LANGUAGE_CD , M.DESCRLONG FROM PS_CHNG_RQST_MSGLG C , PSMSGCATLANG M WHERE C.MESSAGE_SET_NBR = M.MESSAGE_SET_NBR AND C.MESSAGE_NBR = M.MESSAGE_NBR

  • Related Language Record for CHNG_MSGLG_VW

    • # 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
    3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    4 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
    BPA=Contract Release to Single PO
    CAP=Contract Batch Auto Approval
    CRT=PAR Replenish/Close Backorders
    CST=Close Short Purchase Orders
    DRP=Order Management Referenced
    EDX=PO Acknowledgments
    EMC=Req. Requester Mass Change
    EPO=eProcurement Change Request
    EPR=User Change Request
    IMC=Inventory Mass Change
    ONL=On-line Purchase Order
    PLN=Planning System
    PMC=PO Buyer Mass Change
    POC=PO Change Batch Process
    PRD=Production/Shop Floor
    5 CHNG_DTTM DateTime(26) TIMESTAMP Change Request Date/Time
    6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    11 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    12 DESCRLONG Long Character CLOB Long Description