PYCYCL_ERR_VW2

(SQL View)
 Index Back

Pay cycle runtime error


SELECT A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.ERR_TYPE , A.SOURCE_TXN , A.BUSINESS_UNIT , A.PAY_DOC_ID , A.PAY_DOC_SEQ , A.PYCYCL_KEY_FIELD1 , A.PYCYCL_KEY_FIELD2 , A.PYCYCL_KEY_FIELD3 , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_METHOD , A.PYMNT_ID_REF , B.MESSAGE_SET_NBR , B.MESSAGE_NBR , A.ERROR_MESSAGE , B.MESSAGE_TEXT , B.DESCRLONG FROM PS_PYCYCL_ERR_TMP A , PSMSGCATDEFN B WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR

  • Related Language Record: PYCYCL_ERR_LVW2

    • # 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 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction

    Prompt Table: PYMNT_SOURCE

    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 PAY_DOC_ID Character(20) VARCHAR2(20) NOT NULL Advice ID
    7 PAY_DOC_SEQ Number(5,0) INTEGER NOT NULL Advice Sequence
    8 PYCYCL_KEY_FIELD1 Character(20) VARCHAR2(20) NOT NULL Pay Cycle Mapping Key Field 1
    9 PYCYCL_KEY_FIELD2 Date(10) DATE Pay Cycle Mapping Key Field 2
    10 PYCYCL_KEY_FIELD3 Number(15,0) DECIMAL(15) NOT NULL Pay Cycle Mapping Key Field 3
    11 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    12 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    13 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
    14 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer
    15 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
    16 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    17 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    18 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)
    19 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.
    20 DESCRLONG Long Character CLOB Long Description