# |
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
|