BNK_BTB_DT_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
3	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
4	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	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.
6	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
7	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
8	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
9	TRAN_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Represents the unique transaction identifier in bank reconciliation processing.
10	TRAN_DT	Date(10)	DATE	Represents the transaction date in bank reconciliation processing.
11	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
12	CASH_FLOW_LINE	Number(15,0)	DECIMAL(15) NOT NULL	A sequential number that indicates the time order sequence of a given deal transaction's cash flows.
13	CASH_FLOW_LEG	Number(1,0)	SMALLINT NOT NULL	A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg
14	TR_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers
15	PYMNT_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Payment ID
16	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
17	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
18	ADJUSTMENT_SIDE	Character(1)	VARCHAR2(1) NOT NULL	Book to bank adjustment side. 1=Reconciled, not posted to GL 2=Reconciled and posted to GL
19	TYPE_ADJUST	Character(1)	VARCHAR2(1) NOT NULL	Book to Bank Adjsutment Type 1=Payments in Transit 2=Deposits in Transit 3=GL Adjustments 4=Fees & Interest 5=Unbooked Payments 6=Unbooked Deposits 7=Bank Adjustments 8=Subtl Bank Adjustments 9=Subtl GL Adjustments
20	SELECT_TRAN	Character(1)	VARCHAR2(1) NOT NULL	Select Transaction 1=Yes 2=No N=No Y=Yes Y/N Table Edit
21	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
22	BANK_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Bank Account Currency
23	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. "
24	BANK_STMT_CODE	Character(8)	VARCHAR2(8) NOT NULL	Bank Statement code - used to identify the codes used on the bank statement for different entires of balances and transactions.
25	RECON_TRANS_CODE	Character(3)	VARCHAR2(3) NOT NULL	The PeopleSoft-specific bank transaction code ACH=Automated Clearing House B=Direct Debit BA=Bank Adjustments BOE=Bill of Exchange - Disburse BOO=Bill of Order - Disburse C=Trade Receipt CHK=Check D=Deposits DD=Direct Debit - Disburse EFT=Electronic Funds Transfer F=Fee Expense G=General Transaction I=Interest Expense M=Miscellaneous Transaction MAN=Manual Check P=Payment R=Drafts S=Stop Pay TRW=Treasury Wire U=Funding Receipt V=Voided Payment WIR=Wire - Disbursement WRI=Wire - Incoming
26	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
27	MONETARY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Monetary Amount - VCHR BU Base
28	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code