VCHR_PYMT_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VCHR_BLD_KEY_C1	Character(25)	VARCHAR2(25) NOT NULL	Voucher Build Key Char 1
3	VCHR_BLD_KEY_C2	Character(25)	VARCHAR2(25) NOT NULL	Voucher Build Key Char 1
4	VCHR_BLD_KEY_N1	Number(10,0)	DECIMAL(10) NOT NULL	Voucher Build Key Num 1
5	VCHR_BLD_KEY_N2	Number(10,0)	DECIMAL(10) NOT NULL	Vchr Build Key Num 2
6	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
7	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
8	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
9	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Bank account.
10	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Type or Method of payment. Indicator as to how the payment should be handled ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Customer Initiated Draft CHK=System Check DD=Direct Debit DFT=Vendor Initiated Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire Flat File WIR=Wire Report
11	PYMNT_MESSAGE	Character(70)	VARCHAR2(70) NOT NULL	Payment Message
12	PYMNT_VCHR_PCT	Signed Number(33,15)	DECIMAL(31,15) NOT NULL	Used to hold the percentage of a closed voucher.
13	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment handling code. HD=High Dollar Payment IN=Internal Distribution PO=Route to Purchasing RE=Regular Payments
14	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Payment on hold. Default Value: N
15	PYMNT_HOLD_REASON	Character(3)	VARCHAR2(3) NOT NULL	Hold Reason
16	MESSAGE_CD	Character(6)	VARCHAR2(6) NOT NULL	Message Code
17	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
18	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment
19	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
20	PYMNT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Payment Action
21	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
22	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Paygroup code.
23	EFT_LAYOUT_CD	Character(10)	VARCHAR2(10) NOT NULL	EFT Layout Code