| # |
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 |
EIP_CTL_ID_FROM |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
Prompt Table:
%EDITTABLE
|
| 4 |
EIP_CTL_ID_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
Prompt Table:
%EDITTABLE
|
| 5 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 6 |
ALL_SETID |
Character(1) |
VARCHAR2(1) NOT NULL |
All Item SetIDs
Y/N Table Edit
Default Value: Y
|
| 7 |
ALL_EIP_CTL_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
All EIP_CTL_IDs
Y/N Table Edit
Default Value: Y
|
| 8 |
PROCESS_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-process any Errors in Range
Y/N Table Edit
Default Value: N
|
| 9 |
PROCESS_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-process any Hold in Range
Y/N Table Edit
Default Value: N
|
| 10 |
IN_ITMLOADMSG |
Character(4) |
VARCHAR2(4) NOT NULL |
Item Load Type
0001=Item Sync
0002=Item Pricelist
0003=Item FullSync
0004=Item Export
0005=Item Mfg GPO
0006=Item Load From Excel
0007=Item Change Process
Default Value: 0001
|
| 11 |
VALIDATION_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Only Run Validation portion
Y/N Table Edit
Default Value: N
|
| 12 |
PURGE_CANCELLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Cancelled Transactions
Y/N Table Edit
Default Value: N
|
| 13 |
MARKETCODE |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is added to help the following data entry programs to determine how to handle different coding schemes for CATEGORY_CD:
- Item Categories (Component)
- PV_CP_LOAD (App. Engine)
- IN_ITMLOAD (App. Engine)
Since release 8, CATEGORY_TYPE was added to allow multiple coding schemes for CATEGORY_CD. The limitation imposed upon by how it was implemented is that although multiple coding schemes can be maintained separately but only one coding schemes can be used based on INSTALLATION_PO.CATEGORY_TYPE.
01=User Defined
02=UN/SPSC
Default Value: 01
|
| 14 |
ITM_TMPLT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID
Prompt Table:
PO_SRCH_MASS_VW
|
| 15 |
PRICE_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Standard Price
Y/N Table Edit
Default Value: N
|
| 16 |
BU_UPD_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Update Price
Y/N Table Edit
Default Value: N
|
| 17 |
ALL_INSTANCES |
Character(1) |
VARCHAR2(1) NOT NULL |
All Message Instances
Y/N Table Edit
Default Value: Y
|
| 18 |
PUBNODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
|
| 19 |
CHNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Channel Name (see PSCHNLDEFN).
|
| 20 |
PUBID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Publication Identifier
|
| 21 |
MSGNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
|
| 22 |
SUBNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
|
| 23 |
DELETE_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
DELETE_CONTROL
Y/N Table Edit
Default Value: N
|
| 24 |
TEMPLATE_LIST_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Item Template List ID
Prompt Table:
ITM_TMLSTBHD_VW
|