GP_BNK_RCN_EXCP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BNK_FILE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Auto generated number when Bank File is loaded Prompt Table: GP_BNK_FILE_VW
2	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
3	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
4	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
5	BK_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Bank File Transaction Sequence Number
6	BK_PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Bank Transaction Payment Number
7	BK_TRAN_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Bank Transaction Amount
8	PYMT_DT	Date(10)	DATE	Payment Date
9	TRAN_CD	Character(2)	VARCHAR2(2) NOT NULL	Bank Transaction Code 11=Check 22=Bank Transfer 33=Wire Transfer
10	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
11	RECON_BNK_DT	Date(10)	DATE	Reconciliation Bank Date
12	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
13	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
14	PMT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status field for a generated payment transaction F=Finalized M=Manually Paid N=No Active Allocations P=Prepared T=Payment Transferred V=Hold W=Void
15	PAYMENT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Payment Method A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer
16	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
17	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1