BNK_BTB_FY_VW (SQL View)	Index Back
Detail Calendar Fiscal Years Available fiscal years by setid / calendar id.

BNK_BTB_FY_VW

(SQL View)

Detail Calendar Fiscal Years

Available fiscal years by setid / calendar id.

SELECT DISTINCT BNK_ID_NBR ,BANK_ACCOUNT_NUM ,LEDGER ,FISCAL_YEAR ,BUSINESS_UNIT ,BASE_CURRENCY FROM PS_BNK_BTB_HDR

# 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 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

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	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
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. "