PYMNT_VCHR_W_C

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	COMPARE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Compare report type 1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results
3	COMPARE_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Compare data source (Actuals or Expected results). A=Actuals E=Expected
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
6	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
7	WTHD_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Withholding Entity
8	WTHD_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Type
9	WTHD_JUR_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Jurisdiction
10	WTHD_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Withholding Class
11	WTHD_RULE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Rule
12	WTHD_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount
13	WTHD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Amount
14	ORG_WTHD_BASIS_ENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Original withholding amount calculated by the withholding calculation ae.
15	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
16	POSTING_DATE	Date(10)	DATE	Posting Date
17	POST_STATUS_WTHD	Character(1)	VARCHAR2(1) NOT NULL	Post Withholding Status N=Not Postable P=Posted U=Unposted X=Cancelled Withholding
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	CREATE_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Withholding Payment
20	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. "
21	WTHD_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount Base
22	WTHD_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Amount Base
23	WTHD_DECL_DATE	Date(10)	DATE	withholding declaration date
24	WTHD_AMT_ENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withhold Amount (Entity Curr)
25	ENT_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Entity Currency Code
26	ENT_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Rate Type for Wthd Entity
27	ENT_RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	TE Rate Multiplier
28	ENT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	TE Rate Divisor
29	WTHD_BASIS_AMT_ENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount
30	BU_REGIST_ID	Character(20)	VARCHAR2(20) NOT NULL	BU Tax Identification Number
31	VNDR_REGIST_ID	Character(20)	VARCHAR2(20) NOT NULL	Supplier Tax ID
32	APPL_VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Wthd Applicable Supplier Setid
33	APPL_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Wthd Applicable Supplier ID
34	APPL_VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Wthd Applicable Supplier Loc
35	APPL_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Wthd applic Address Seq Num
36	WTHD_PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Wthd Payment Count Default Value: 0
37	WTHD_SURCHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withhold Surcharge Amount
38	ADDL_SRCHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Additional Surcharge Amount
39	WTHD_CESS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field to hold the amount value for Wihtholding Cess amount
40	WTH_SRCHRG_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withhold Surcharge Amount
41	ADD_SRCHRG_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Additional Surcharge Amount
42	WTHD_CESS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field to hold the amount value for Wihtholding Cess amount