| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
|
| 3 |
SO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
|
| 4 |
MERCHANTID |
Character(30) |
VARCHAR2(30) NOT NULL |
Merchant ID
|
| 5 |
RS_USERID |
Character(15) |
VARCHAR2(15) NOT NULL |
Resource ID
|
| 6 |
RS_RATE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
External Resource Rate
|
| 7 |
RS_AVAILABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Available Date
|
| 8 |
RS_RATING |
Number(3,0) |
SMALLINT NOT NULL |
Match Rating
|
| 9 |
RS_BUYER_RATING |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Customer Satisfaction
|
| 10 |
RS_LOC_STR |
Character(30) |
VARCHAR2(30) NOT NULL |
Location String
|