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 | SUBOWNER | Character(30) | VARCHAR2(30) NOT NULL | Subscription Owner |
2 | EOEW_CODE_OBJ | Character(50) | VARCHAR2(50) NOT NULL | Translation Set |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |