TDS_CERT_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	WTHD_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Withholding Class
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	WTHD_RULE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Rule
10	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
11	WTHD_CONT_REF	Character(15)	VARCHAR2(15) NOT NULL	Contract Reference
12	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
13	TDS_CERT_NUM	Character(25)	VARCHAR2(25) NOT NULL	India Withholding Certificate
14	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
15	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
16	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
17	PERIOD	Number(3,0)	SMALLINT NOT NULL	Period
18	FROM_DT	Date(10)	DATE	From Date
19	THRU_DATE	Date(10)	DATE	Through Date
20	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
21	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
22	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
23	PAY_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amt - Base Curr
24	WTHD_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount
25	WTHD_LIABILITY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Liability Amount
26	WTHD_SURCHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withhold Surcharge Amount
27	ADDL_SRCHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Additional Surcharge Amount
28	WTHD_CESS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field to hold the amount value for Wihtholding Cess amount
29	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
30	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
31	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
32	PYMNT_DT	Date(10)	DATE	Payment Date
33	WTHD_DECL_DATE	Date(10)	DATE	withholding declaration date
34	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
35	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
36	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
37	CHALLAN_IDENT_NO	Character(18)	VARCHAR2(18) NOT NULL	TDS Challan Identification Number
38	TDS_CREDIT_DATE	Date(10)	DATE	TDS Credit Date
39	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
40	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
41	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
42	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location