BNK_BTB_HDR_VW (SQL View)	Index Back
Book To Bank Header Book to Bank Header Record

BNK_BTB_HDR_VW

(SQL View)

Book To Bank Header

Book to Bank Header Record

SELECT A.BNK_ID_NBR , B.BANK_ACCOUNT_NUM , G.FISCAL_YEAR , G.ACCOUNTING_PERIOD , H.STATEMENT_ID , H.ASOFDATE , H.BTB_STATUS , B.BUSINESS_UNIT_GL , E.SETID , E.LEDGER_GROUP , E.LEDGER , B.CURRENCY_CD , C.BASE_CURRENCY , B.RATE_INDEX , B.CUR_RT_TYPE , G.SETID , G.CALENDAR_ID , G.BEGIN_DT , G.END_DT FROM PS_BANK_CD_TBL A , PS_BANK_ACCT_DEFN B , PS_BU_LED_GRP_TBL C , PS_SET_CNTRL_REC D , PS_LED_GRP_LED_TBL E , PS_SET_CNTRL_REC F , PS_CAL_DETP_TBL G , PS_BANK_STMT_HDR H WHERE B.SETID = A.SETID AND B.BANK_CD = A.BANK_CD AND C.BUSINESS_UNIT = B.BUSINESS_UNIT_GL AND C.DEFAULT_LEDGER_GRP = 'Y' AND D.SETCNTRLVALUE = B.BUSINESS_UNIT_GL AND D.RECNAME = 'LED_GRP_LED_TBL' AND E.SETID = D.SETID AND E.LEDGER_GROUP = C.LEDGER_GROUP AND E.PRIMARY_LEDGER = 'Y' AND F.SETCNTRLVALUE = B.BUSINESS_UNIT_GL AND F.RECNAME = 'CAL_DETP_TBL' AND G.SETID = F.SETID AND G.CALENDAR_ID = C.CALENDAR_ID AND H.BNK_STMT_TYPE = '2' AND H.BNK_ID_NBR = A.BNK_ID_NBR AND H.BANK_ACCOUNT_NUM = B.BANK_ACCOUNT_NUM AND H.ASOFDATE BETWEEN G.BEGIN_DT AND G.END_DT

# 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 STATEMENT_ID Number(10,0) DECIMAL(10) NOT NULL Statement ID for bank statements, key on Bank Statement Header

6 ASOFDATE Date(10) DATE As of Date

7 BTB_STATUS Character(1) VARCHAR2(1) NOT NULL Book to Bank ready flag.
N=No
Y=Yes

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

9 SETID_LEDGER_GROUP Character(5) VARCHAR2(5) NOT NULL Ledger Group SetID

10 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

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

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

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

14 RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Rate index

15 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

16 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

17 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

18 BEGIN_DT Date(10) DATE Begin Date

19 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	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
6	ASOFDATE	Date(10)	DATE	As of Date
7	BTB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Book to Bank ready flag. N=No Y=Yes
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	SETID_LEDGER_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Ledger Group SetID
10	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
11	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
12	BANK_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Bank Account Currency
13	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. "
14	RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Rate index
15	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
16	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
17	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
18	BEGIN_DT	Date(10)	DATE	Begin Date
19	END_DT	Date(10)	DATE	End Date