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	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year Prompt Table: BNK_BTB_FY_VW
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. Prompt Table: BNK_BTB_PR_VW
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
7	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header Prompt Table: BNK_BTB_STMT_VW
8	ASOFDATE	Date(10)	DATE	As of Date
9	BANK_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Bank Account Currency
10	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. "
11	RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Rate index
12	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
13	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
14	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
15	BEGIN_DT	Date(10)	DATE	Begin Date
16	END_DT	Date(10)	DATE	End Date
17	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp Default Value: %datetime
18	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_FS.OPRID
19	BTB_RECON_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Book to bank Reconciliation Status 1=Confirmed 2=Awaiting Confirmation 3=Calculating 4=New Default Value: 4
20	ADJUSTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Adjustment Period
21	BANK_STMT_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Book to bank Recon
22	BANK_STMT_BAL_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Book to bank Recon
23	PYMNT_IN_TRANSIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment in Tansit use in Book to bank Recon
24	DEP_IN_TRANSIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Deposits in Transit
25	GL_ADJUSTMENTS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	GL Adj field used in Book to Bank Recon
26	ADJ_BANK_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Use in Book to Bank Recon
27	ADJUSTED_BNK_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Use in Book to Bank Recon
28	ADJ_DIFFERENCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Difference
29	GL_BANK_ACCT_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bank Acct Ledger Balance
30	FEES_INTEREST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unbooked Fees and Interest
31	UNBOOKED_PYMNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unbooked Payments
32	UNBOOKED_DEP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unbooked Deposits
33	BANK_ADJUSTMENTS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bank Adjustments
34	ADJ_GL_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	GL Adjustments Subtotal
35	ADJ_LEDGER_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Adjusted Ledger Balance
36	REVAL_ADJUSTMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revaluation Adjustment Amount
37	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
38	DESCRLONG	Long Character	CLOB	Long Description