| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PAYER_TIN |
Character(20) |
VARCHAR2(20) NOT NULL |
Payer Taxpayer Identification
|
| 2 |
WTHD_CNTL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control ID
|
| 3 |
PROCESS_DTTM |
DateTime(26) |
TIMESTAMP |
Process Date Time
|
| 4 |
WTHD_CONTROL_NAME |
Character(4) |
VARCHAR2(4) NOT NULL |
Withholding Control Name
|
| 5 |
LAST_FILE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Filing
|
| 6 |
COMBINED_FED_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Combined Federal State Filing
|
| 7 |
PAYER_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payer Name 1
|
| 8 |
PAYER_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payer Name 2
|
| 9 |
PAYER_ADDRESS1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payer Address Line 1
|
| 10 |
PAYER_ADDRESS2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payer Address Line 2
|
| 11 |
PAYER_ADDRESS3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payer Address Line 3
|
| 12 |
PAYER_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Payer City
|
| 13 |
PAYER_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Payer State
|
| 14 |
PAYER_POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Payer Postal
|
| 15 |
PAYER_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Payer Country
|
| 16 |
PAYER_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Payer Telephone
|
| 17 |
PAYER_EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Payer Phone Extension
|
| 18 |
ALL_VENDORS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
All Suppliers
|
| 19 |
WTHD_AMT_CODES |
Character(12) |
VARCHAR2(12) NOT NULL |
Withholding Amount Codes
|
| 20 |
DIRECT_SALES |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Sales of $5000 or More
|