STMT_CODE_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	TYPE_CODE	Character(1)	VARCHAR2(1) NOT NULL	Uniform Type Code 1=Account Status 2=Activity Summary 3=Transaction Detail
3	CR_DB	Character(1)	VARCHAR2(1) NOT NULL	Credit / Debit 0=Not Applicable 1=Credit 2=Debit Default Value: 0
4	PICK_BALANCE	Character(1)	VARCHAR2(1) NOT NULL	Default Display Y/N Table Edit Default Value: N
5	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
6	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_TYP_VW
7	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
8	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50