WTHDENT_DIAG_VW

(SQL View)

SELECT A.WTHD_ENTITY , B.EFFDT , B.WTHD_ROUND_OPT , B.WTHD_APPL_FLG , E.WTHD_TYPE , E.WTHD_CLASS , E.MINIMUM_AMT , E.WTHD_VAT_FLG , E.FREIGHT_APPL_FLG , E.WTHD_SUT_APPL , E.WHTD_DSCNT_APPL , F.VENDOR_CATEGORY , F.CREATE_PAY_FLG , F.HOLD_PAY_FLG , F.CALENDAR_SETID , F.CALENDAR_ID , F.WTHD_JUR_CD , F.BU_CATEGORY FROM PS_WTHD_ENTITY_DFN A , PS_WTHD_ENTITY_HDR B , PS_WTHD_ENTITY_DTL E , PS_WTHD_CATEGORY F WHERE A.WTHD_ENTITY = B.WTHD_ENTITY AND B.WTHD_ENTITY = E.WTHD_ENTITY AND B.EFFDT = E.EFFDT AND E.WTHD_ENTITY = F.WTHD_ENTITY AND E.EFFDT = F.EFFDT AND E.WTHD_TYPE = F.WTHD_TYPE AND E.WTHD_JUR_CD = F.WTHD_JUR_CD AND E.WTHD_CLASS = F.WTHD_CLASS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 WTHD_ROUND_OPT Character(1) VARCHAR2(1) NOT NULL Withhold Rounding Option to be applied to withhold calculations.
D=Round Down
I=TDS Withholding Round
N=Natural Round
R=Nearest Rupee Rounding
U=Round Up
Default Value: N

4 WTHD_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Withholding
P=Withhold at Payment
V=Withhold at Voucher Posting
Default Value: P

5 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
Default Value: WTHD_TYPE_TBL.WTHD_TYPE
Prompt Table: WTHD_TYPE_TBL

6 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
Default Value: WTHD_CLASS_TBL.WTHD_CLASS
Prompt Table: WTHD_CLASS_TBL

7 MINIMUM_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Amount to Report

8 WTHD_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Apply VAT
Default Value: N

9 FREIGHT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Freight
Default Value: N

10 WTHD_SUT_APPL Character(1) VARCHAR2(1) NOT NULL Apply Sales/Use Tax
Default Value: N

11 WHTD_DSCNT_APPL Character(1) VARCHAR2(1) NOT NULL Apply Discount
Default Value: N

12 VENDOR_CATEGORY Character(5) VARCHAR2(5) NOT NULL Vendor Category
Prompt Table: WTHD_VNDR_CAT

13 CREATE_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Create Withholding Payment
Y/N Table Edit
Default Value: Y

14 HOLD_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Hold Payment
B=Hold wthd & regular payment
N=Do Not Hold
W=Hold Withholding only
Default Value: N

15 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
Prompt Table: SP_SETID_NONVW

16 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
Prompt Table: WTHD_CAL_VW3

17 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
Default Value: WTHD_ENTITY_DTL.WTHD_JUR_CD
Prompt Table: WTHD_JUR_TBL

18 BU_CATEGORY Character(5) VARCHAR2(5) NOT NULL Business Unit Category
Default Value: WTHD_BU_CATVW.BU_CATEGORY
Prompt Table: WTHD_BU_CAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WTHD_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Withholding Entity
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	WTHD_ROUND_OPT	Character(1)	VARCHAR2(1) NOT NULL	Withhold Rounding Option to be applied to withhold calculations. D=Round Down I=TDS Withholding Round N=Natural Round R=Nearest Rupee Rounding U=Round Up Default Value: N
4	WTHD_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Withholding P=Withhold at Payment V=Withhold at Voucher Posting Default Value: P
5	WTHD_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Type Default Value: WTHD_TYPE_TBL.WTHD_TYPE Prompt Table: WTHD_TYPE_TBL
6	WTHD_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Withholding Class Default Value: WTHD_CLASS_TBL.WTHD_CLASS Prompt Table: WTHD_CLASS_TBL
7	MINIMUM_AMT	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	Minimum Amount to Report
8	WTHD_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply VAT Default Value: N
9	FREIGHT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Freight Default Value: N
10	WTHD_SUT_APPL	Character(1)	VARCHAR2(1) NOT NULL	Apply Sales/Use Tax Default Value: N
11	WHTD_DSCNT_APPL	Character(1)	VARCHAR2(1) NOT NULL	Apply Discount Default Value: N
12	VENDOR_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Vendor Category Prompt Table: WTHD_VNDR_CAT
13	CREATE_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Withholding Payment Y/N Table Edit Default Value: Y
14	HOLD_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment B=Hold wthd & regular payment N=Do Not Hold W=Hold Withholding only Default Value: N
15	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID Prompt Table: SP_SETID_NONVW
16	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: WTHD_CAL_VW3
17	WTHD_JUR_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Jurisdiction Default Value: WTHD_ENTITY_DTL.WTHD_JUR_CD Prompt Table: WTHD_JUR_TBL
18	BU_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Category Default Value: WTHD_BU_CATVW.BU_CATEGORY Prompt Table: WTHD_BU_CAT