1099_RPT_AET

(SQL Table)
Index Back

1099 Report Post State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 WTHD_RPT_ID Character(10) VARCHAR2(10) NOT NULL Withholding Report ID
5 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
6 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
7 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
8 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
9 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
10 PERIOD Number(3,0) SMALLINT NOT NULL Period
11 FROM_DT Date(10) DATE From Date
12 THRU_DATE Date(10) DATE Through Date
13 RPT_DT Date(10) DATE Report Date
14 SETID Character(5) VARCHAR2(5) NOT NULL SetID
15 WTHD_CNTL_ID Character(10) VARCHAR2(10) NOT NULL Control ID
16 MANUAL_CHANGE_SW Character(1) VARCHAR2(1) NOT NULL Include withholding manual adjustments/overrides
17 LINE_NO Number(3,0) SMALLINT NOT NULL Line Number
18 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
19 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
20 DESCR Character(30) VARCHAR2(30) NOT NULL Description