| # |
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 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 5 |
STARTDATETIME |
DateTime(26) |
TIMESTAMP |
Start Datetime
|
| 6 |
ENDDATETIME |
DateTime(26) |
TIMESTAMP |
End Datetime
|
| 7 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
Prompt Table:
PROCESS_VW
|
| 8 |
SEL_BAL_NOTIFY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit
Default Value: N
|
| 9 |
MSG_TYPE_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for labels
|
| 10 |
SEL_RFQ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created.
Y/N Table Edit
Default Value: N
|
| 11 |
SEL_PO_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11//99 Created.
Y/N Table Edit
Default Value: N
|
| 12 |
SEL_RTV_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retrun To Vendor (Supplier)
Y/N Table Edit
|
| 13 |
SEL_PO_ER_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit
Default Value: N
|
| 14 |
SEL_SHPNTC_ASN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
12/99 Create: Shipping Notices Selection Button
Y/N Table Edit
Default Value: N
|
| 15 |
SEL_SHPNTC_IL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
12/99:Created
Y/N Table Edit
Default Value: N
|
| 16 |
SEL_SHPNTC_IU_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
12/99:Created
Y/N Table Edit
Default Value: N
|
| 17 |
SEL_SHPNTC_FRT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Request
Y/N Table Edit
Default Value: N
|
| 18 |
SEL_ORD_REL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit
Default Value: N
|
| 19 |
SEL_BI_INV_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Invoice Notice
Y/N Table Edit
Default Value: N
|
| 20 |
SEL_ACKNOW_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Order Acknowledgement
Y/N Table Edit
Default Value: N
|
| 21 |
SEL_CHG_ACKNOW_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Order Change Notice
Y/N Table Edit
Default Value: N
|
| 22 |
SEL_QUOTE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Quote Notice
Y/N Table Edit
Default Value: N
|
| 23 |
SEL_PROD_PRICE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Price List
Y/N Table Edit
Default Value: N
|
| 24 |
SEL_ORD_STATUS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Order/Quote Status
Y/N Table Edit
Default Value: N
|
| 25 |
SEL_PRDN_UPD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing created this for Production Order Update message
N=NO
Y=YES
|
| 26 |
SEL_ITEM_SYNC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing created this for Item Sync message
N=No
Y=Yes
|
| 27 |
SEL_ITEM_RPL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing created this for Production Order Update message
N=NO
Y=YES
|
| 28 |
SEL_ITEM_STAT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Status Option
Y/N Table Edit
Default Value: N
|
| 29 |
SEL_TMS_ORDREL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
TMS Option
Y/N Table Edit
Default Value: N
|
| 30 |
SEL_GTIN_NOTF_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
GTIN Data Notification
Y/N Table Edit
|
| 31 |
SEL_SHPVMI_IU_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/04:Created
Y/N Table Edit
|
| 32 |
SEL_CS_CNT_SN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Contract Syndication
Y/N Table Edit
|
| 33 |
SEL_CT_ACTX_R_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Remote Contract Activity
Y/N Table Edit
|