SS_FORMAT_SLVW

(SQL View)
 Index Back

Sourcing Event Format XLAT Lan


SELECT B.FIELDVALUE ,L.LANGUAGE_CD , L.XLATLONGNAME FROM PSXLATITEM B , PSXLATITEMLANG L WHERE B.FIELDNAME = 'AUC_FORMAT' 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_FORMAT_SVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
    F=Sell
    I=RFI
    R=Buy
    S=Service
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 AUC_FORMAT_TXT Character(30) VARCHAR2(30) NOT NULL Event Format