SCC_EP_PTRANSVW

(SQL View)
 Index Back

View of valid transaction code

This view display valid transaction codes

SELECT A.SCC_MERCHANT_ID , A.FIELDVALUE , B.XLATLONGNAME , B.XLATSHORTNAME FROM PS_SCC_EP_PTRANS A , PSXLATITEM B WHERE B.FIELDNAME='SCC_EPAY_TRANSACT' AND A.FIELDVALUE = B.FIELDVALUE AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = B.FIELDNAME AND C.FIELDVALUE = B.FIELDVALUE AND C.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A'

  • Related Language Record: SCC_PTRANSVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_MERCHANT_ID Character(16) VARCHAR2(16) NOT NULL Payment Merchant ID
    2 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value

    Prompt Table: SCC_EP_TRANSVW

    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name