BNK_RCN_EDI_BVW

(SQL View)
 Index Back

Bank Recon EDI Bu View


SELECT DISTINCT A.BNK_ID_NBR ,E.BANK_ACCOUNT_NUM ,A.ECQUEUEINSTANCE ,C.BUSINESS_UNIT_GL ,D.ECDRIVERDTTM ,A.ASOFDATE ,'I' ,' ' FROM PS_BSP_CYCLEHDR_EC A ,PS_BANK_CD_TBL B ,PS_BANK_ACCT_TBL C ,PS_ECQUEUE D ,PS_BSP_TRANS_PD_EC E WHERE A.BNK_ID_NBR=B.BNK_ID_NBR AND B.BANK_CD=C.BANK_CD AND E.BANK_ACCOUNT_NUM=C.BANK_ACCOUNT_NUM AND A.ECQUEUEINSTANCE=D.ECQUEUEINSTANCE AND D.ECQUEUESTATUS='L' AND D.ECTRANSID='BSP' AND A.ECQUEUEINSTANCE=E.ECQUEUEINSTANCE AND A.BNK_ID_NBR=E.BNK_ID_NBR

  • Parent record: BANK_ACCT_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    3 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 BNK_LOAD_DTTM DateTime(26) TIMESTAMP The time and date a bank statement is loaded into the system.
    6 ASOFDATE Date(10) DATE As of Date
    7 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
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).