BNK_ACT_DUPL_VW

(SQL View)
 Index Back

Duplicate Bank Accounts


SELECT OA.BNK_ID_NBR ,OB.BANK_ACCOUNT_NUM ,OA.SETID ,OA.BANK_CD ,OB.BANK_ACCT_KEY ,OB.BUSINESS_UNIT_GL ,OB.CURRENCY_CD ,OB.RECON_TYPE_FLG ,OA.BANK_STATUS ,OB.ACCT_STATUS FROM PS_BANK_CD_TBL OA ,PS_BANK_ACCT_DEFN OB WHERE OB.SETID=OA.SETID AND OB.BANK_CD=OA.BANK_CD AND EXISTS ( SELECT 'X' FROM PS_BANK_CD_TBL IA , PS_BANK_ACCT_DEFN IB WHERE IB.SETID=IA.SETID AND IB.BANK_CD=IA.BANK_CD AND IA.BNK_ID_NBR=OA.BNK_ID_NBR AND IB.BANK_ACCOUNT_NUM=OB.BANK_ACCOUNT_NUM AND NOT(IA.SETID=OA.SETID AND IA.BANK_CD=OA.BANK_CD AND IB.BANK_ACCT_KEY=OB.BANK_ACCT_KEY))

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
5 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 RECON_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates which method has been utilized to reconcile a given source system transaction.
A=Automatic
M=Manual
N=None
S=Semi Manual
9 BANK_STATUS Character(1) VARCHAR2(1) NOT NULL Bank Status - Active/Inactive
A=Active
I=Inactive
P=Potential
10 ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Account Status - Active/Inactive
A=Active
I=Inactive