PO_EMAIL_Q_AET

(SQL Table)
Index Back

PO Dispatch E-Mail Queue

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PROCESS_INST_STG Number(10,0) DECIMAL(10) NOT NULL Stage Record Process Instance
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 EMAIL_SERVER_DIR Character(80) VARCHAR2(80) NOT NULL E-Mail Server Directory
6 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
8 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
9 RETURN_CODE Signed Number(5,0) DECIMAL(4) NOT NULL Return Code
10 FILE_DIR_SERVER Character(80) VARCHAR2(80) NOT NULL File Directory - Server
11 SLASH Character(1) VARCHAR2(1) NOT NULL Slash
12 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause