WTHD_CERT_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	WTHD_RPT_ID	Character(10)	VARCHAR2(10) NOT NULL	Withholding Report ID
3	WTHD_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Withholding Entity
4	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
7	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	LINE_NO	Number(3,0)	SMALLINT NOT NULL	Line Number
10	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
11	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
12	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
13	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
14	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	WTHD_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount
17	WTHD_LIABILITY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Liability Amount
18	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
19	PYMNT_DT	Date(10)	DATE	Payment Date
20	WTHD_SURCHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withhold Surcharge Amount