IN_ITMEXPWF_TMP

(SQL Table)
Index Back

EDI Workflow Itemloader TMP

EDI Workflow Itemloader Temp TMP

# 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 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
7 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.
8 WORKLIST_FLG Character(1) VARCHAR2(1) NOT NULL If the worklist flag is checked, the item will added to a specific user(s) worklist.
N=No
Y=Yes

Default Value: N

9 EMAIL_FLG Character(1) VARCHAR2(1) NOT NULL When the email flag is checked, the user will notified a specific user regarding an activity.
N=No
Y=Yes

Default Value: N

10 EMAIL_TEXT Character(250) VARCHAR2(250) NOT NULL EMAIL TEXT
11 EMAIL_SUBJECT Character(30) VARCHAR2(30) NOT NULL Subject of the email