CS_POSTATUS_VW

(SQL View)
 Index Back

PO Status Xlat VW

view needed for query translation

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

  • Related Language Record: CS_POSTAT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
    A=Approved
    C=Complete
    D=Dispatched
    DA=Denied
    I=Initial
    LD=Line Denied
    O=Open
    PA=Pending Approval/Approved
    PX=Pending Cancel
    X=Canceled
    2 CS_CLSTYP_DESC Character(30) VARCHAR2(30) NOT NULL Clause Type