| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
HP_CONTACT_NM_1042 |
Character(40) |
VARCHAR2(40) NOT NULL |
Withholding Agent's contact name for 1042 Magnetic Tape process
|
| 3 |
CONTACT_PHONE |
Character(12) |
VARCHAR2(12) NOT NULL |
Contact Phone
|
| 4 |
CONTACT_PHONE_EXT |
Character(4) |
VARCHAR2(4) NOT NULL |
Contact Phone Extension
|
| 5 |
DEPT_TITLE |
Character(45) |
VARCHAR2(45) NOT NULL |
Department Title - use for 1042-S process parameter that keep withholding agent's department title.
|
| 6 |
HP_USE_WH_CONTACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Withholding Agent contact information on transmitter record.
Y/N Table Edit
Default Value: Y
|
| 7 |
HP_TRM_CONTACT_NM |
Character(40) |
VARCHAR2(40) NOT NULL |
Transmitter contact name for 1042 Magnetic Tape process
|
| 8 |
HP_TRM_CONTACT_PH |
Character(12) |
VARCHAR2(12) NOT NULL |
Transmitter Contact Phone number
|
| 9 |
HP_TRM_CONTACT_EXT |
Character(4) |
VARCHAR2(4) NOT NULL |
Transmitter contact phone extension for 1042 Magnetic Tape process
|
| 10 |
HP_CH3_STATUS_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Chapter 3 Status Code defined for 1042-S report
01=U.S. Withholding Agent - FI
01=U.S. Withholding Agent - FI
02=U.S. Withholding Agent - Other
02=U.S. Withholding Agent - Other
15=Corporation
18=Private Foundation
18=Corporation
19=Government / International Org
19=International Organization
20=Tax Exempt Organization
21=Private Foundation
21=Private Foundation
22=International Organization
22=International Organization
23=Tax Exempt Organization
23=Tax Exempt Organization
29=Government of U.S. territory
29=Government of U.S. territory
|