TDS_QRETURN_DTL

(SQL Table)
Index Back

TDS Quarterly Return Detail

TDS Quarterly Return Detail

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
3 TDS_QRETURN_NUM Character(25) VARCHAR2(25) NOT NULL TDS Quarterly Return No
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
6 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
7 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
11 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
12 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
13 PRCNT_WTHHLD Number(6,2) DECIMAL(5,2) NOT NULL Percent Withheld
14 PAY_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amt - Base Curr
15 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount
16 WTHD_SURCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withhold Surcharge Amount
17 ADDL_SRCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Additional Surcharge Amount
18 LATE_CHRG_PAID_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Late Charge Paid Base
19 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
20 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
21 PYMNT_DT Date(10) DATE Payment Date
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 CHALLAN_IDENT_NO Character(18) VARCHAR2(18) NOT NULL TDS Challan Identification Number
26 TDS_CREDIT_DATE Date(10) DATE TDS Credit Date
27 WTHD_PAN_NUM Character(15) VARCHAR2(15) NOT NULL PAN No.
28 WTHD_CESS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to hold the amount value for Wihtholding Cess amount