PO_MSGSEND_AET

(SQL Table)
Index Back

PO Common Msg Send AET

AET record for PO Common message send process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 DOC_ID Character(50) VARCHAR2(50) NOT NULL ID
8 DOC_LINE Number(5,0) INTEGER NOT NULL Document Line Number
9 DOC_SCHED_NBR Number(5,0) INTEGER NOT NULL Document Schedule Number
10 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
11 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Default Value: OPR_DEF_TBL_PM.REQUESTOR_ID

Prompt Table: %EDITTABLE16

12 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
13 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
14 MESSAGE_TEXT_254 Character(254) VARCHAR2(254) NOT NULL Message Text
15 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
16 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
17 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine