TDS_QTR_RETURN

(SQL Table)
Index Back

TDS_Quarterly_Return

TDS Quarterly Return Reporting Table

# 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 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
4 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
5 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
6 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
7 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
9 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
12 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
13 ACK_NUM Character(20) VARCHAR2(20) NOT NULL Field to store Acknowledgement Number
14 TAX_DED Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to store amount of tax dededucted
15 TAX_DEP Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to store amount of tax deposited