BNK_BTB_BANK_VW (SQL View)	Index Back
Book to Bank Search record

BNK_BTB_BANK_VW

(SQL View)

Book to Bank Search record

SELECT DISTINCT A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,C.DESCR ,C.CURRENCY_CD ,C.BUSINESS_UNIT_GL ,A.BASE_CURRENCY FROM PS_BNK_BTB_HDR A ,PS_BANK_CD_TBL B ,PS_BANK_ACCT_DEFN C WHERE B.BNK_ID_NBR=A.BNK_ID_NBR AND C.SETID=B.SETID AND C.BANK_CD=B.BANK_CD AND C.BANK_ACCOUNT_NUM=A.BANK_ACCOUNT_NUM

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 BANK_CURRENCY Character(3) VARCHAR2(3) NOT NULL Bank Account Currency

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

6 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	BANK_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Bank Account Currency
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "