SS_EVT_TYPE_SLW

(SQL View)
 Index Back

Sourcing Event Type XLAT Lang


SELECT B.FIELDVALUE ,L.LANGUAGE_CD , L.XLATLONGNAME FROM PSXLATITEM B , PSXLATITEMLANG L WHERE B.FIELDNAME = 'AUC_TYPE' AND %EffdtCheck(PSXLATITEM A, B, %CURRENTDATEIN) AND B.FIELDNAME = L.FIELDNAME AND B.FIELDVALUE = L.FIELDVALUE AND B.EFFDT = L.EFFDT AND B.EFF_STATUS = 'A'

  • Related Language Record for SS_EVT_TYPE_SVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
    E=Auction
    S=RFx
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 AUC_XLAT_DESCR Character(30) VARCHAR2(30) NOT NULL Unit of Measure