BNK_RCN_EDI_VW

(SQL View)
 Index Back

Bank Recon EDI Status


SELECT DISTINCT A.BNK_ID_NBR ,B.BANK_ACCOUNT_NUM ,A.ECQUEUEINSTANCE ,C.ECDRIVERDTTM ,'I' ,' ' ,A.ASOFDATE ,A.ASOFTIME FROM PS_BSP_CYCLEHDR_EC A ,PS_BSP_TRANS_PD_EC B ,PS_ECQUEUE C WHERE C.ECQUEUESTATUS='L' AND A.ECTRANSID=B.ECTRANSID AND A.ECTRANSID=C.ECTRANSID AND A.ECQUEUEINSTANCE=B.ECQUEUEINSTANCE AND A.ECQUEUEINSTANCE=C.ECQUEUEINSTANCE AND A.BNK_ID_NBR=B.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 BNK_LOAD_DTTM DateTime(26) TIMESTAMP The time and date a bank statement is loaded into the system.
    5 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
    6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    7 ASOFDATE Date(10) DATE As of Date

    Default Value: %date

    8 ASOFTIME Time(15) TIMESTAMP As of Time