IN_ITMEXP_PRM

(SQL Table)
Index Back

Run Control for Export AE

This is the run control table for the Export AE process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

4 CRITERIA_ID Character(10) VARCHAR2(10) NOT NULL Selection Criteria ID
5 ITM_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Template ID
6 DELETE_FLAG Character(1) VARCHAR2(1) NOT NULL Deletion Flag
7 INSERT_MASTER_ITEM Character(1) VARCHAR2(1) NOT NULL Insert Master Item EC record
8 INSERT_BU_ITEM Character(1) VARCHAR2(1) NOT NULL Insert BU Item EC record
9 INSERT_PUR_ITEM Character(1) VARCHAR2(1) NOT NULL Insert Purchase Item EC record
10 INSERT_VENDOR Character(1) VARCHAR2(1) NOT NULL Insert Item Supplier EC Record
11 INSERT_VEN_LOC Character(1) VARCHAR2(1) NOT NULL Insert Item Supplier Location
12 INSERT_VEN_UOM Character(1) VARCHAR2(1) NOT NULL Insert Itm Supplier UOM EC Rec
13 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field