WTHD_1099_TMP5

(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 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
6 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
7 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
8 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
9 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
10 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
14 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount
15 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
16 MINIMUM_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Amount to Report
17 PAYER_TIN Character(20) VARCHAR2(20) NOT NULL Payer Taxpayer Identification
18 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number