BUSINESS_UNITSO_IDSO_LINEYRSRS_ST_SOCOMPYRS(SQL View) |
Index Back |
|---|
| %Sql(RS_XS_SO_COMPYRS_SEL,'STF') |
| # | 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 | SOID | Character(29) | VARCHAR2(29) NOT NULL | Service Order Line Key |
| 5 | YRS |
Character(32) | VARCHAR2(32) NOT NULL | Experience |
| 6 | REQ | Character(1) | VARCHAR2(1) NOT NULL | Purchasing |
| 7 | RYRS | Character(32) | VARCHAR2(32) NOT NULL | Required Experience |