| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 2 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 3 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 4 |
AREA_JPN |
Character(76) |
VARCHAR2(76) NOT NULL |
Areas to be loaded in the Import Postal Codes Process.
|
| 5 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Character City
|
| 6 |
AREA_AC_JPN |
Character(76) |
VARCHAR2(76) NOT NULL |
Alternate Character Areas to be loaded in the Import Postal Codes Process.
|
| 7 |
LINE_NUM_JPN |
Number(6,0) |
INTEGER NOT NULL |
Line Number
|
| 8 |
REASON_LOG_JPN |
Character(30) |
VARCHAR2(30) NOT NULL |
Indicates the detailed reason for the Postal Codes Log Report.
|