BNK_BSAC_HDR_VW (SQL View)	Index Back
Bank Statement Accouunting Add record associates bank accounts to reconciliation process

BNK_BSAC_HDR_VW

(SQL View)

Bank Statement Accouunting

Add record associates bank accounts to reconciliation process

SELECT DISTINCT C.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , ' ' , A.DESCR FROM PS_BANK_ACCT_DEFN A , PS_BANK_CD_TBL C WHERE A.SETID=C.SETID AND A.BANK_CD=C.BANK_CD AND A.BANK_CD=A.BANK_CD_CPTY AND A.RECON_TYPE_FLG='A'

# 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.
Prompt Table: BANK_ID_VW

2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: BANK_ACCTNUM_VW

3 STMT_ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Represents a series of values that provide a more granular definition of a given reconcil
Prompt Table: BANK_ACT_TYPE

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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. Prompt Table: BANK_ID_VW
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account. Prompt Table: BANK_ACCTNUM_VW
3	STMT_ACTIVITY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Represents a series of values that provide a more granular definition of a given reconcil Prompt Table: BANK_ACT_TYPE
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description