C_RECORD_TMP

(SQL Table)
Index Back

IRS 1099 C-Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_TYPE Character(3) VARCHAR2(3) NOT NULL Transaction Type
2 TOTAL_PAYEES Number(8,0) INTEGER NOT NULL Total number of payees being reported on the IRS 1099 file
3 RENT Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Rent withhold class for 1099 Reporting AE
4 ROYALTIES Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Royalties withhold class for 1099 Reporting AE
5 PRIZES Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Prizes withhold class for 1099 Reporting AE
6 BACKUP_WTHD Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Backup Withholding withhold class for 1099 Reporting AE
7 FISHING Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Fishing withhold class for 1099 Reporting AE
8 MED_PYMNTS Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Medical Payments withhold class for 1099 Reporting AE
9 NON_EMP_COMP Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Nonemployee Compensation withhold class for 1099 Reporting AE.
10 SUB_PYMNTS Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Substitute Payments withhold class for 1099 Reporting AE.
11 CROPS Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Crops withhold class for 1099 Reporting AE
12 PARACHUTE Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Parachute withhold class for 1099 Reporting AE
13 ATTORNEY Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 Attorney withhold class for 1099 Reporting AE