PC_CMP2_AET

(SQL Table)
Index Back

Project Compression State Rec

State record used in Project Compression for internal processing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
5 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2
6 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC
7 SELECT_CLAUSE_LONG Long Character(4000) CLOB Select Clause