BNK_RCN_TRN_LG

(SQL View)
 Index Back

Bank Recon Status View

Related Language View over XLAT

SELECT %Substring(A.FIELDVALUE,1,3) , C.LANGUAGE_CD , C.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG C WHERE A.FIELDNAME = 'RECON_TRANS_CODE' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn) AND A.FIELDNAME = C.FIELDNAME AND A.FIELDVALUE = C.FIELDVALUE AND A.EFFDT = C.EFFDT

  • Related Language Record for BNK_RCN_TRN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECON_TRANS_CODE Character(3) VARCHAR2(3) NOT NULL The PeopleSoft-specific bank transaction code
    ACH=Automated Clearing House
    B=Direct Debit
    BA=Bank Adjustments
    BOE=Bill of Exchange - Disburse
    BOO=Bill of Order - Disburse
    C=Trade Receipt
    CHK=Check
    D=Deposits
    DD=Direct Debit - Disburse
    EFT=Electronic Funds Transfer
    F=Fee Expense
    G=General Transaction
    I=Interest Expense
    M=Miscellaneous Transaction
    MAN=Manual Check
    P=Payment
    R=Drafts
    S=Stop Pay
    TRW=Treasury Wire
    U=Funding Receipt
    V=Voided Payment
    WIR=Wire - Disbursement
    WRI=Wire - Incoming
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description