CM_WIPHIST2_AET(SQL Table) |
Index Back |
|---|---|
CM_WIPHIST State record06/20/03: This record is used by CM_WIPHIST, the AE that extracts data for the WIP Value Report. Orig aet record too large - breakup into 3 records |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Prompt Table: %EDITTABLE10 |
| 2 | INSERT_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Insert Clause used for Inheritance. |
| 3 | GROUP_BY_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Group by text |
| 4 | WHERE_CLAUSE4 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 5 | WHERE_CLAUSE5 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 6 | WHERE_CLAUSE6 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 7 | WHERE_CLAUSE7 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 8 | WHERE_CLAUSE_AE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause AE |