PO_PO_TYPE_VW_N

(SQL View)
 Index Back

PO Type Prompt VW


SELECT X.fieldvalue , X.xlatshortname , X.xlatlongname FROM PSXLATITEM X WHERE X.FIELDNAME = 'PO_TYPE' AND X.FIELDVALUE <> 'KAN' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A'

  • Related Language Record: PO_POTYPE_VWNLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
    GEN=General
    KAN=Kanban
    2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name