PYCYCL_FSERR_LV

(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.PAY_DOC_ID , A.PYCYCL_KEY_FIELD1 , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_ID_REF , A.ERROR_MESSAGE , B.MESSAGE_TEXT 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_FSERR_VW

    • # 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 PAY_DOC_ID Character(20) VARCHAR2(20) NOT NULL Advice ID
    7 PYCYCL_KEY_FIELD1 Character(20) VARCHAR2(20) NOT NULL Pay Cycle Mapping Key Field 1
    8 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    9 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    10 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    11 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
    12 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)
    13 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.