CM_PERPAVG_AET(SQL Table) |
Index Back |
---|---|
CM_PERPAVG AE AET12/03/02 lee: This aet record is used by the ae program cm_perpavg. That program upgrades the perpavg demo data in an 880 database. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: %EDITTABLE2 |
4 | ACTION_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Action Flag
A=Action |
5 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field for Hiding Groups |
6 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |