PMT_REQUEST_VW

(SQL View)
 Index Back

Search record

Search record for payment request component

SELECT DISTINCT A.PMT_MSG_ID , A.PMT_REQUEST_DATE , %DatePart(A.PMT_REQUEST_DATE) , A.PMT_SOURCE , A.PMT_REQUEST_STATUS , B.XLATLONGNAME , A.PMT_COUNT , A.GRP_ID , A.OPRID , A.PROCESS_INSTANCE FROM PS_PMT_REQUEST_LOG A , PSXLATITEM B WHERE A.PMT_REQUEST_STATUS <> ' ' AND B.FIELDNAME = 'PMT_REQUEST_STATUS' AND B.FIELDVALUE = A.PMT_REQUEST_STATUS AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PSXLATITEM Z WHERE Z.FIELDNAME = B.FIELDNAME AND Z.FIELDVALUE = B.FIELDVALUE AND Z.EFF_STATUS = 'A')

  • Related Language Record: PMT_REQVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PMT_MSG_ID Character(15) VARCHAR2(15) NOT NULL Payment Message ID

    Prompt Table: PMT_REQUEST_VW2

    2 PMT_REQUEST_DATE DateTime(26) TIMESTAMP Request Date
    3 REQUEST_DATE Date(10) DATE Requested
    4 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name

    Prompt Table: PMT_SRC_DEFN

    5 PMT_REQUEST_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Request Status
    A=Request Abended
    C=Complete
    E=Complete with Errors
    6 PMT_REQ_STAT_LONG Character(30) VARCHAR2(30) NOT NULL Payment Request Status
    7 PMT_COUNT Number(6,0) INTEGER NOT NULL Number of Payments
    8 GRP_ID Character(30) VARCHAR2(30) NOT NULL Group id
    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    10 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

    Prompt Table: PMT_PROCINST_VW