TR_BANK_ID_VW

(SQL View)
 Index Back

Bank Statement Header

Header record for bank statement and balances tables

SELECT A.BANK_CD ,A.BNK_ID_NBR ,%Substring(B.FIELDVALUE,1,1) ,%Substring(C.FIELDVALUE,1,1) FROM PS_BANK_CD_TBL A , PSXLATITEM B , PSXLATITEM C WHERE A.BANK_TYPE='E' AND A.BANKING_SW='Y' AND A.BANK_STATUS = 'A' AND B.FIELDNAME='BNK_STMT_TYPE' AND C.FIELDNAME='CYCLE_STATUS' AND C.FIELDVALUE IN ('E','L','N')

  • Parent record: BANK_ACCT_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    2 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    3 BNK_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Bank statement type
    1=Current Day
    2=Previous Day
    3=Statement Analysis
    4 CYCLE_STATUS Character(1) VARCHAR2(1) NOT NULL Cycle Status
    C=Complete
    E=Load Failed
    F=Fatal Error
    I=EDI Loaded
    L=Loading
    N=Ready
    P=Selected
    R=Ready
    X=Reconciling

    Default Value: R