EOEW_CODETBL_VW(SQL View) |
Index Back |
|---|---|
Translation Set tableUsed to capture translation set or equivalent code values. Example for unit of measure - EA = Each, IN = Inch, GAL = Gallons. |
| SELECT DISTINCT B.EOEW_OBJ_OWNER , A.EOEW_CODE_OBJ , A.DESCR FROM PS_EOEW_CODE_TBL A , PS_EOEW_OBJOWN_VW B WHERE A.EOEW_OBJ_OWNER = B.EOEW_OBJ2_OWNER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Subscription Owner | |
| 2 | Character(50) | VARCHAR2(50) NOT NULL | Translation Set | |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |