TR_AVF_BKST_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
2	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
3	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
4	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
5	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
6	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
7	RECON_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	The transaction reference identifier on the inbound bank statement.
8	RECON_BANK_DT	Date(10)	DATE	The bank statement date.
9	RECON_TRAN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement transaction amount.
10	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
11	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
12	RECON_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Reconciliation Status ALG=Alignment Check AMB=Ambiguous Match AMT=Amounts Not Equal CUR=Currency not Defined DAT=Tran Date <> Value Date DPI=Duplicate Input Transactions DUP=Duplicate Transaction MSC=Miscellaneous Transaction NAM=Payee Names Not Equal NTB=Not Found in Statement NTF=Not Found In System NTP=Not Found in POS Data NUL=Null Transaction ID Ref OVR=Overflow PND=Pending Reconciliation REC=Reconciled RPR=Reprinted Check RR=Requires Review - BSAC STP=Stop Payment TYP=Wrong Transaction Type UNR=Unreconciled VOI=Voided Check
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
14	STMT_ACTIVITY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Represents a series of values that provide a more granular definition of a given reconcil Prompt Table: BANK_ACT_TYPE
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
16	FUNDS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Funds Availability Type 0=Immediate Availability 1=One-day Availability 2=Two-or more-day Availability D=Distributed Availability-vary S=Distributed Availability-fixed V=Value Dated Z=unknown
17	RECON_RUN_ID	Character(15)	VARCHAR2(15) NOT NULL	Recon Run ID
18	BANK_REF_ID	Character(16)	VARCHAR2(16) NOT NULL	A reference identifier associated with a given bank/counterparty transaction.
19	BANK_TRANS_CODE	Character(20)	VARCHAR2(20) NOT NULL	A code that describes the type of transaction submitted by the bank via report or flat file.
20	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. Prompt Table: BSP_TXN_CODE_VW
21	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
22	AVAILABLE_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Available Balance
23	FLOAT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	One Day Float Balance
24	FLOAT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Two or More Days Float Balance
25	DESCRLONG	Long Character	CLOB	Long Description