WTHD_TDSCH_VW (SQL View)	Index Back
TDS Challan View

WTHD_TDSCH_VW

(SQL View)

TDS Challan View

SELECT WTHD_ENTITY , WTHD_TYPE , WTHD_JUR_CD , WTHD_CLASS , WTHD_RULE , BANK_SETID , BANK_CD , BANK_ACCT_KEY , PYMNT_METHOD , PYMNT_ID , SUM(PAID_AMT) , WTHD_DECL_DATE , CHALLAN_IDENT_NO , TDS_CREDIT_DATE FROM PS_WTHD_TRXN_TBL GROUP BY WTHD_ENTITY , WTHD_TYPE , WTHD_JUR_CD , WTHD_CLASS , WTHD_RULE , BANK_SETID , BANK_CD , BANK_ACCT_KEY , PYMNT_METHOD , PYMNT_ID , WTHD_DECL_DATE , CHALLAN_IDENT_NO , TDS_CREDIT_DATE HAVING SUM(PAID_AMT) > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
Prompt Table: WTHD_ENTITY_VW4

2 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
Prompt Table: WTHD_ENTITY_VW

3 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
Prompt Table: WTHD_ENTITY_VW1

4 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
Prompt Table: WTHD_ENTITY_VW2

5 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
Prompt Table: WTHD_ENTITY_VW3

6 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

7 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

8 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

9 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

10 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

11 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount

12 WTHD_DECL_DATE Date(10) DATE withholding declaration date

13 CHALLAN_IDENT_NO Character(18) VARCHAR2(18) NOT NULL TDS Challan Identification Number

14 TDS_CREDIT_DATE Date(10) DATE TDS Credit Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WTHD_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Withholding Entity Prompt Table: WTHD_ENTITY_VW4
2	WTHD_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Type Prompt Table: WTHD_ENTITY_VW
3	WTHD_JUR_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Jurisdiction Prompt Table: WTHD_ENTITY_VW1
4	WTHD_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Withholding Class Prompt Table: WTHD_ENTITY_VW2
5	WTHD_RULE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Rule Prompt Table: WTHD_ENTITY_VW3
6	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
7	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
8	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
9	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
10	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
11	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
12	WTHD_DECL_DATE	Date(10)	DATE	withholding declaration date
13	CHALLAN_IDENT_NO	Character(18)	VARCHAR2(18) NOT NULL	TDS Challan Identification Number
14	TDS_CREDIT_DATE	Date(10)	DATE	TDS Credit Date