PYCYCL_ERR_LVW2

(SQL View)
 Index Back

Pay cycle runtime error LVW


SELECT A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.ERR_TYPE , A.BUSINESS_UNIT , B.LANGUAGE_CD , A.PYMNT_ID_REF , A.ERROR_MESSAGE , B.MESSAGE_TEXT , B.DESCRLONG FROM PS_PYCYCL_ERR_TMP A , PSMSGCATLANG B WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR

  • Related Language Record for PYCYCL_ERR_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    3 ERR_TYPE Character(3) VARCHAR2(3) NOT NULL Pay Cycle Error Type
    ALL=All Error Types
    S01=Supplier Bank
    S02=IPAC Information
    S03=Federal Payment
    S04=Currency Conversion Related
    S05=Negative Payment
    S06=Financial Gateway Staging
    S07=Payment Error
    S08=Financial Sanctions
    S09=Negative Payment/With.Restored
    S10=Federal Payment Restrictions
    S11=TAS & BETC Required
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
    7 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)
    8 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    9 DESCRLONG Long Character CLOB Long Description