WTHD_1099_TMP2

(SQL Table)
Index Back

Withholding basis amounts

Temp table used in 1099_RPT_PST application engine to store the withholding basis amounts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 WTHD_TRXN_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies how the entry was generated in the WTHD_TRXN_TBL record.
M=Manually generated
S=System generated
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
7 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
8 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
9 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
10 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
11 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
13 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
16 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount
17 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
18 MINIMUM_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Amount to Report
19 PAYER_TIN Character(20) VARCHAR2(20) NOT NULL Payer Taxpayer Identification