IN_ITMEXPWF_AET

(SQL Table)
Index Back

EDI Workflow Itemloader AET

EDI Workflow Itemloader Temp AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
8 ALL_SETID Character(1) VARCHAR2(1) NOT NULL All Item SetIDs
9 ALL_EIP_CTL_ID Character(1) VARCHAR2(1) NOT NULL All EIP_CTL_IDs
10 EIP_CTL_ID_FROM Character(25) VARCHAR2(25) NOT NULL EIP control ID selection
11 EIP_CTL_ID_TO Character(25) VARCHAR2(25) NOT NULL EIP control ID selection
12 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
13 RTE_FROM_VAL_1 Number(5,0) INTEGER NOT NULL RTE_FROM_VAL_1
14 RTE_TO_VAL_1 Number(5,0) INTEGER NOT NULL RTE_TO_VAL_1
15 RTE_FROM_VAL_2 Number(5,0) INTEGER NOT NULL RTE_FROM_VAL_2
16 RTE_TO_VAL_2 Number(5,0) INTEGER NOT NULL RTE_TO_VAL_2
17 AE_APPL_ABORT Character(1) VARCHAR2(1) NOT NULL AE Application Abort Indicator
18 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.