PO_PEGEWN_CTX

(SQL Table)
Index Back

PO Pegging-EWN context record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 VENDOR_NAME Character(30) VARCHAR2(30) NOT NULL Supplier Name
12 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
13 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
14 IN_PEG_EMAIL_GROUP Number(10,0) DECIMAL(10) NOT NULL Pegging process group id
15 IN_PEG_NOTIF_TO Character(30) VARCHAR2(30) NOT NULL Pegging notification user
16 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
17 EMAIL_ADDRESS Long Character CLOB Email Addresses