WTHD_1099_TMP1

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 WTHD_RPT_ID Character(10) VARCHAR2(10) NOT NULL Withholding Report ID
3 WTHD_SETID Character(5) VARCHAR2(5) NOT NULL Setid for the Withholding Code
4 WTHD_CNTL_ID Character(10) VARCHAR2(10) NOT NULL Control ID
5 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
6 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
9 PAYER_TIN Character(20) VARCHAR2(20) NOT NULL Payer Taxpayer Identification
10 DTL_TIN Character(20) VARCHAR2(20) NOT NULL 1099 Detail TIN
11 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount
12 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
13 TOT_LIABILITY Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Withholding Liability