UA_WTHD_UPG

#	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	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
5	PYMNT_CNT_MAX	Number(5,0)	INTEGER NOT NULL	Max payment count
6	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
7	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
8	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
9	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.
10	DSCNT_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Discount Amount
11	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
12	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
13	PAID_AMT_GROSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Paid Amount
14	PAID_AMT_DSCNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount on Paid Amount
15	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
16	RVL_DTTM	DateTime(26)	TIMESTAMP	Revaluation DateTime
17	SELECT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Select Status
18	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
19	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
20	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
21	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location
22	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
23	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
24	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
25	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
26	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
27	PYMNT_MESSAGE	Character(70)	VARCHAR2(70) NOT NULL	Payment Message
28	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes
29	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
30	PYMNT_HOLD_WTHD	Character(1)	VARCHAR2(1) NOT NULL	On Withholding Hold N=No Y=Yes
31	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment
32	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number
33	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
34	REMIT_BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit Bank Setid
35	REMIT_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Remit Bank Code
36	REMIT_BNK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Remit Bank Account
37	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
38	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
39	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
40	EFT_PYMNT_FMT_CD	Character(3)	VARCHAR2(3) NOT NULL	Payment Format 00=Standard SWIFT transfer 10=Urgent SWIFT 15=Euro-Transfer 21=Check, w/ receipt confirmation 22=Check, Urgent 23=Check, urgent w/ receipt 40=Postal Order CTX=Corp Trade Exchange PBC=Check, standard PPD=Prearranged Pay & Deposit WRT=Wire Transfer
41	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag
42	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
43	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
44	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
45	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
46	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
47	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
48	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
49	BUSINESS_UNIT_BANK	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty.
50	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
51	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable
52	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
53	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month
54	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System
55	ORIG_PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Original Payment Count
56	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. "
57	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.
58	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
59	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
60	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
61	DSCNT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Amount
62	CUR_RT_TYPE_PYMNT	Character(5)	VARCHAR2(5) NOT NULL	Payment Currency Rate Type
63	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
64	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
65	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
66	PAID_AMT_GROSS_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Payment Amount
67	PAID_AMT_DSCNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Paid Amount
68	RVL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Rate Type
69	RVL_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	Revaluation Exchange Rate Mult
70	RVL_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Revaluation Exchange Rate Div
71	RVL_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revalued Amount
72	RVL_AMT_DSCNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revalued Discount Amount
73	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
74	PREPAID_APPLIED_BU	Character(5)	VARCHAR2(5) NOT NULL	Applied Business Unit
75	PREPAID_APPL_VCHR	Character(8)	VARCHAR2(8) NOT NULL	Applied Voucher ID
76	PREPAID_APPL_PYMNT	Number(5,0)	INTEGER NOT NULL	Applied Payment Count
77	POST_STATUS_WTHD	Character(1)	VARCHAR2(1) NOT NULL	Post Withholding Status N=Not Postable P=Posted U=Unposted X=Cancelled Withholding
78	GRP_PYMNT_DT	Character(1)	VARCHAR2(1) NOT NULL	Group by Payment Date
79	SOURCE_TXN	Character(4)	VARCHAR2(4) NOT NULL	Source Transaction
80	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Pay Group Code
81	CUR_RT_TYPE_PAID	Character(5)	VARCHAR2(5) NOT NULL	Payment Rate Type
82	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
83	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
84	SPEC_PYMNT_EX_RT	Character(1)	VARCHAR2(1) NOT NULL	Specify Pymnt Ex Rate
85	UA_WTHD_PR_PCT	Number(9,7)	DECIMAL(8,7) NOT NULL	Withholding Percent
86	WTHD_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Withholding Entity
87	WTHD_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Type
88	WTHD_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Withholding Class