SS_FORMAT_SVW

(SQL View)
Index Back

Sourcing Event Format XLAT


SELECT B.FIELDVALUE , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'AUC_FORMAT' AND %EffdtCheck(PSXLATITEM A, B, %CURRENTDATEIN) AND B.EFF_STATUS = 'A'

  • Related Language Record: SS_FORMAT_SLVW
  • # 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 AUC_FORMAT_TXT Character(30) VARCHAR2(30) NOT NULL Event Format