TDS_QRETURN_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	WTHD_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Withholding Entity
4	TDS_QRETURN_NUM	Character(25)	VARCHAR2(25) NOT NULL	TDS Quarterly Return No
5	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
6	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	PERIOD	Number(3,0)	SMALLINT NOT NULL	Period
9	FROM_DATE	Date(10)	DATE	From Date
10	THRU_DATE	Date(10)	DATE	Through Date
11	ASSESSMENT_YEAR	Character(8)	VARCHAR2(8) NOT NULL	Assessment Year
12	ORG_SETID	Character(5)	VARCHAR2(5) NOT NULL	Organization SetID.
13	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
14	ORG_NAME	Character(50)	VARCHAR2(50) NOT NULL	Organization Name.
15	ORG_TAN	Character(20)	VARCHAR2(20) NOT NULL	Tax Deduction Account Number. A number allotted by the Income Tax Authority to identify an Organization for withholding payments.
16	ORG_TAN_CIRCLE	Character(30)	VARCHAR2(30) NOT NULL	Income Tax Circle. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority.
17	ORG_TAN_WARD	Character(30)	VARCHAR2(30) NOT NULL	Income Tax Ward. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority.
18	ORG_PAN	Character(20)	VARCHAR2(20) NOT NULL	Personal Account Number. This is allotted by the Income Tax Authority to identify an organization in their tax returns.
19	ORG_PAN_CIRCLE	Character(30)	VARCHAR2(30) NOT NULL	PAN Circle. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority.
20	ORG_PAN_WARD	Character(30)	VARCHAR2(30) NOT NULL	PAN Ward. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority.
21	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.
22	LOCATION_SETID	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
23	ORG_TAX_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Organization Tax Location
24	PREV_STMT_FILED	Character(1)	VARCHAR2(1) NOT NULL	Previous statement filed N=No Y=Yes
25	PROV_RECPT_NO	Character(30)	VARCHAR2(30) NOT NULL	Filed Statement Receipt Number
26	TDS_REP_NAME	Character(50)	VARCHAR2(50) NOT NULL	NAME
27	WTHD_RPT_ID	Character(10)	VARCHAR2(10) NOT NULL	Withholding Report ID
28	RPT_DT	Date(10)	DATE	Report Date
29	WTHD_CNTL_ID	Character(10)	VARCHAR2(10) NOT NULL	Control ID
30	DUP_CHK	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Check
31	ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Event Status N=Inactive Y=Active