| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
EIP_CTL_ID_FROM |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
|
| 5 |
EIP_CTL_ID_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
|
| 6 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 7 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 8 |
ALL_SETID |
Character(1) |
VARCHAR2(1) NOT NULL |
All Item SetIDs
Y/N Table Edit
Default Value: Y
|
| 9 |
ALL_EIP_CTL_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
All EIP_CTL_IDs
Y/N Table Edit
Default Value: Y
|
| 10 |
PROCESS_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-process any Errors in Range
Y/N Table Edit
Default Value: N
|
| 11 |
IN_RECS_EXTRACTED |
Number(7,0) |
INTEGER NOT NULL |
12/99: Created to tract number of records extracted.
|
| 12 |
IN_MSTITM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 13 |
IN_INVITM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record found
Y/N Table Edit
Default Value: Y
|
| 14 |
IN_INVITMUOM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 15 |
IN_INVITMUPN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 16 |
IN_BUITM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 17 |
IN_BUITMWTVL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 18 |
IN_ITMREV_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 19 |
IN_ITMVND_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 20 |
IN_ITMVNDLOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 21 |
IN_ITMVNDUOM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 22 |
IN_ITMVNDUMP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 23 |
IN_PURITM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 24 |
IN_ITMCAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 25 |
IN_ITMMFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 26 |
IN_ITMMFGGPO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Y/N Table Edit
Default Value: Y
|
| 27 |
PROCESS_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-process any Hold in Range
Y/N Table Edit
Default Value: N
|
| 28 |
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
|
| 29 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
|
| 30 |
EDIT_ACCOUNT |
Character(15) |
VARCHAR2(15) NOT NULL |
Account Edit Table
|
| 31 |
EDIT_ALTACCT |
Character(15) |
VARCHAR2(15) NOT NULL |
Alternate Account Edit Table
|
| 32 |
VALIDATION_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Only Run Validation portion
Y/N Table Edit
Default Value: N
|
| 33 |
PURGE_CANCELLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Cancelled Transactions
Y/N Table Edit
Default Value: N
|
| 34 |
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
|
| 35 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
Default Value: N
|
| 36 |
DUMMY_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
TEST DUMMY
|
| 37 |
FIELDCOUNT |
Number(4,0) |
SMALLINT NOT NULL |
Field Count
|
| 38 |
FIELDLIST |
Character(254) |
VARCHAR2(254) NOT NULL |
Used to store a list of FieldNames
|
| 39 |
ITM_TMPLT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID
|
| 40 |
WF_CHECK_EXP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Item Exception Flag
Y/N Table Edit
Default Value: N
|
| 41 |
PRICE_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Standard Price
Y/N Table Edit
Default Value: N
|
| 42 |
BU_UPD_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Update Price
Y/N Table Edit
Default Value: N
|
| 43 |
ALL_INSTANCES |
Character(1) |
VARCHAR2(1) NOT NULL |
All Message Instances
Y/N Table Edit
Default Value: Y
|
| 44 |
PUBNODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
|
| 45 |
CHNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Channel Name (see PSCHNLDEFN).
|
| 46 |
PUBID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Publication Identifier
|
| 47 |
MSGNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
|
| 48 |
SUBNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
|
| 49 |
DELETE_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
DELETE_CONTROL
Y/N Table Edit
Default Value: N
|
| 50 |
LAST_DTTM_UPDATE |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 51 |
EDIT_INTRA01 |
Character(15) |
VARCHAR2(15) NOT NULL |
Affiliate Intra1 Edit Table
|
| 52 |
EDIT_INTRA02 |
Character(15) |
VARCHAR2(15) NOT NULL |
Affiliate Intra2 Edit Table
|
| 53 |
EDIT_BU_PC |
Character(15) |
VARCHAR2(15) NOT NULL |
Common PC Business Unit field.
|
| 54 |
EDIT_PROJECT |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit table for Project id.
|
| 55 |
EDIT_ACTIVITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity Edit Table
|
| 56 |
EDIT_RES_CAT |
Character(15) |
VARCHAR2(15) NOT NULL |
Category Edit Table
|
| 57 |
EDIT_RES_SUB |
Character(15) |
VARCHAR2(15) NOT NULL |
SubCategory Edit Table
|
| 58 |
TEMPLATE_LIST_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Item Template List ID
|
| 59 |
USE_TEMPLATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use a Template
Y/N Table Edit
Default Value: N
|
| 60 |
IN_ITEM_CHG_PRCS |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Change process
Default Value: N
|
| 61 |
IN_SUBITM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 62 |
IN_PURITMBU_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 63 |
IN_PRODITM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 64 |
IN_PRODUOM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 65 |
IN_ITMPLATTR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 66 |
IN_ITMPICKZON_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 67 |
IN_ITMPTWYZON_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 68 |
IN_ITMFXDLOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 69 |
IN_ITMDFLTLOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 70 |
IN_ITMPTYRLIN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 71 |
IN_ITMDFSTP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 72 |
IN_ITMAUTOSRL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 73 |
IN_PRODCURR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 74 |
IN_ASSITEMATR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 75 |
IN_BUITMCFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 76 |
IN_BUITMUTLCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 77 |
IN_ITMSPEXPUR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 78 |
IN_ITMVNDMFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 79 |
IN_ITMVNDRTV_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 80 |
IN_ITMSFREV_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 81 |
IN_PRITMCURR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
|
| 82 |
IN_GS1UPN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Found
Default Value: Y
|
| 83 |
GS1_CLAS2_ITM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record found
Default Value: Y
|