BNK_RCN_CYC_BVW

(SQL View)
 Index Back

Bank Recon Cycle Bu View


SELECT DISTINCT A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,A.STATEMENT_ID ,C.BUSINESS_UNIT_GL ,A.BNK_LOAD_DTTM ,A.ASOFDATE ,A.CYCLE_STATUS ,A.OPRID FROM PS_BANK_STMT_HDR A , PS_BANK_CD_TBL B , PS_BANK_ACCT_TBL C WHERE A.BNK_ID_NBR= B.BNK_ID_NBR AND B.BANK_CD = C.BANK_CD AND A.BANK_ACCOUNT_NUM = C.BANK_ACCOUNT_NUM AND A.BNK_STMT_TYPE = '2'

  • Parent record: BANK_ACCT_TBL

    • # 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).