TL_PYBLSTS_X_LN

(SQL View)
Index Back

TL Payable Status Xlat Descr

Related Language View for TL_PYBLSTS_X_VW

SELECT A.FIELDVALUE ,A.LANGUAGE_CD ,MAX(A.EFFDT) ,A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME ='PAYABLE_STATUS' AND A.FIELDVALUE <>'OE' GROUP BY A.FIELDVALUE ,A.LANGUAGE_CD ,A.XLATLONGNAME

  • Related Language Record for TL_PYBLSTS_X_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAYABLE_STATUS Character(2) VARCHAR2(2) NOT NULL Payable Status
    AP=Approved
    CL=Closed
    DL=Diluted
    ES=Estimated
    IG=Ignore
    NA=Needs Approval
    NP=No Pay
    OE=Online Estimate
    PD=Distributed
    RP=Rejected by Payroll
    RV=Reversed Check
    SP=Sent to Payroll
    TP=Taken by Payroll
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description