BNK_BTB_PR_VW (SQL View)	Index Back
Detail Calendar Fiscal Years Available fiscal years by setid / calendar id. Book to Bank recon

BNK_BTB_PR_VW

(SQL View)

Detail Calendar Fiscal Years

Available fiscal years by setid / calendar id. Book to Bank recon

SELECT DISTINCT A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,A.FISCAL_YEAR ,A.ACCOUNTING_PERIOD ,A.BUSINESS_UNIT ,A.LEDGER ,A.BASE_CURRENCY ,B.BEGIN_DT ,B.END_DT FROM PS_BNK_BTB_HDR A , PS_BNK_BTB_HDR_VW B WHERE B.BNK_ID_NBR=A.BNK_ID_NBR AND B.BANK_ACCOUNT_NUM=A.BANK_ACCOUNT_NUM AND B.FISCAL_YEAR=A.FISCAL_YEAR AND B.ACCOUNTING_PERIOD=A.ACCOUNTING_PERIOD

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

4 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

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

6 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

7 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. "

8 BEGIN_DT Date(10) DATE Begin Date

9 END_DT Date(10) DATE End Date

#	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	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
7	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. "
8	BEGIN_DT	Date(10)	DATE	Begin Date
9	END_DT	Date(10)	DATE	End Date