VCHR_PYCRRCT_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Default Value: NEXT
3	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments Default Value: 1
4	PYMNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Document Type E=Express Payment M=Manual Payment R=Regular payment W=Withholding Payment Z=Zero Payment Check
5	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
6	DSCNT_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Discount Amount
7	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
8	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID Prompt Table: REMIT_SETID_VW
9	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor Prompt Table: VNDR_RMT_VW
10	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_REM_LOC_VW
11	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location Default Value: VNDR_RMTADD2_VW.REMIT_ADDR_SEQ_NUM Prompt Table: VNDR_RMTADD3_VW
12	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
13	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_VW8
14	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 Prompt Table: BANK_ACCT_VW11
15	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
16	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 Prompt Table: PYMNT_MTHD_VW2
17	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Pay Group Code Prompt Table: VNDR_PAYGRP_TBL
18	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling Prompt Table: PYMNT_HNDL_TBL
19	PYMNT_HOLD_CD	Character(5)	VARCHAR2(5) NOT NULL	Payment Hold Code Prompt Table: PYMNT_HOLD_CD
20	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes Y/N Table Edit Default Value: N
21	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
22	VNDR_PYMNT_HLD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Vendor Payment Hold N=No Y=Yes Y/N Table Edit Default Value: N
23	PYMNT_HOLD_REASON	Character(3)	VARCHAR2(3) NOT NULL	Hold Reason ACC=Accounting in Dispute ACV=Federal Supplier Inactive ALC=Agency Location Code Required AMT=Amount in Dispute CCR=CCR Expired CRT=Contract Retention EFT=EFT incomplete or not Prenoted FNS=Financial Sanctions GDS=Goods in Dispute GNV=G-Invoicing Hold IPC=Inbound IPAC Required OTH=Other QTY=Quantity in Dispute SAM=SAM Expired WTH=Withholding Hold
24	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment Y/N Table Edit Default Value: N
25	LATE_CHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Late Charge Amount
26	SCHEDULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID
27	NET_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Netting Select Status H=Hold N=Not Applicable S=Selected Default Value: N
28	ECN_DSCNT_DNIE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Discount Denied Y/N Table Edit Default Value: N
29	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Y/N Table Edit Default Value: N
30	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
31	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
32	PYMNT_APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied N=Approved Status P=Pending
33	PYMNT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Payment Action P=Prepayment Applied R=Record a Payment S=Schedule Payment W=Escheated Payment X=Cancelled
34	PYMNT_MESSAGE	Character(70)	VARCHAR2(70) NOT NULL	Payment Message