CM_PERPAVG_AET

(SQL Table)
Index Back

CM_PERPAVG AE AET

12/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