GP_BNK_FILE_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
2	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
3	BNK_FILE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Auto generated number when Bank File is loaded
4	BK_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Bank File Transaction Sequence Number
5	BK_PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Bank Transaction Payment Number
6	RECON_BNK_DT	Date(10)	DATE	Reconciliation Bank Date Default Value: %date
7	BK_TRAN_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Bank Transaction Amount
8	TRAN_CD	Character(2)	VARCHAR2(2) NOT NULL	Bank Transaction Code 11=Check 22=Bank Transfer 33=Wire Transfer
9	RECON_STAT	Character(2)	VARCHAR2(2) NOT NULL	Reconciliation Status 01=Unreconciled 02=Reconciled 03=Date Difference 04=Not Found 05=Amount Difference 06=Duplicate 07=Expired 08=Stop Payment 09=Unclaimed 10=Different Pay Method 11=Void 12=Re-Numbered
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance