BNK_BTB_LED_VW (SQL View)	Index Back
Ledger Search for BTB

BNK_BTB_LED_VW

(SQL View)

Ledger Search for BTB

SELECT DISTINCT A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,A.LEDGER ,C.DESCR ,A.BUSINESS_UNIT ,A.BASE_CURRENCY FROM PS_BNK_BTB_HDR A ,PS_SET_CNTRL_REC B ,PS_LED_DEFN_TBL C WHERE B.SETCNTRLVALUE=A.BUSINESS_UNIT AND B.RECNAME='LED_DEFN_TBL' AND C.SETID=B.SETID AND C.LEDGER=A.LEDGER

# 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 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

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

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	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
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. "