AE_DO_PRODUCTAE_DO_APPLIDAE_DO_APPL_VW |
index back |
|---|---|
AE Appl ID view |
| SELECT DISTINCT A.AE_PRODUCT, A.AE_APPL_ID, A.DESCR FROM PS_AE_SECTION_TBL S, PS_AE_APPL_TBL A WHERE S.AE_PRODUCT = A.AE_PRODUCT AND S.AE_APPL_ID = A.AE_APPL_ID |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| AE_DO_PRODUCT |
Character(2) | VARCHAR2(2) NOT NULL | Do Product |
| AE_DO_APPLID |
Character(8) | VARCHAR2(8) NOT NULL | Do Application |
| DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |