VCHR_PYM_UP2_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
4	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
5	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PRIM_VW
7	VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher
8	VOUCHER_ID_RELATED	Character(8)	VARCHAR2(8) NOT NULL	Related Voucher
9	ENTRY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down. C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Reviewed through Maintenance M=Modified O=Open P=Postable R=Recycle S=Scheduled for Payment T=Template Voucher X=Deleted
10	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
11	INVOICE_DT	Date(10)	DATE	Invoice Date
12	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
13	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
14	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
15	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
16	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
17	CUR_RT_TYPE_PAID	Character(5)	VARCHAR2(5) NOT NULL	Payment Rate Type
18	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid
19	SCHEDULED_PAY_DT	Date(10)	DATE NOT NULL	Scheduled to Pay
20	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
21	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor Prompt Table: VNDR_RMT_VW
22	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_REM_LOC_VW
23	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location Prompt Table: VNDR_RMTADD3_VW
24	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
25	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_V_CD_VW8
26	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_VACCT_VW11
27	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: BNK_PYMTHD_VW1
28	PYMNT_MESSAGE	Character(70)	VARCHAR2(70) NOT NULL	Payment Message
29	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes Y/N Table Edit
30	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
31	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment Y/N Table Edit
32	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Pay Group Code Prompt Table: VNDR_PAYGRP_TBL
33	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling Prompt Table: PYMNT_HNDL_TBL
34	EFT_LAYOUT_CD	Character(10)	VARCHAR2(10) NOT NULL	EFT Layout Code
35	STL_THROUGH	Character(2)	VARCHAR2(2) NOT NULL	Settle through 01=Financial Gateway 02=Pay Cycle
36	GRP_PYMNT_DT	Character(1)	VARCHAR2(1) NOT NULL	Group by Payment Date Default Value: N
37	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System
38	DFT_SIGHT_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Sight Code
39	DFT_MAT_DT	Date(10)	DATE	Draft Maturity Date
40	DFT_SCHED_MAT_DT	Date(10)	DATE	Draft Scheduled Maturity Date
41	DFT_GROUP_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Group Code
42	DFT_MASTER_ID	Character(10)	VARCHAR2(10) NOT NULL	Draft Master ID
43	DFT_CREATE_KEY	Character(10)	VARCHAR2(10) NOT NULL	Draft Create Key
44	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number
45	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable
46	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
47	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month
48	SPEC_PYMNT_EX_RT	Character(1)	VARCHAR2(1) NOT NULL	Specify Pymnt Ex Rate Default Value: N
49	PAID_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determing whether a currency exchange spot rate is stored either as
50	PAID_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determing whether a currency exchange spot rate is store
51	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
52	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
53	NET_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Netting Select Status H=Hold N=Not Applicable S=Selected
54	PREPAID_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prepaid Status A=Applied B=Pending Application C=Pending Unapply D=Pending Change F=Fully Applied I=Inactive P=Available Prepayment R=Restricted U=Unapplied X=Cancelled
55	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
56	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
57	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
58	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
59	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
60	CUR_RT_TYPE_PYMNT	Character(5)	VARCHAR2(5) NOT NULL	Payment Currency Rate Type
61	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
62	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
63	BNK_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is stored either as
64	BNK_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is store
65	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
66	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
67	PAID_AMT_GROSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Paid Amount
68	PAID_AMT_GROSS_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Payment Amount
69	PAID_AMT_DSCNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount on Paid Amount
70	PAID_AMT_DSCNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Paid Amount
71	DSCNT_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Discount Amount
72	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
73	LATE_CHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Late Charge Amount
74	BUSINESS_UNIT_BANK	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty.
75	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description