CN#WV840-4.0 Portal Acknowledgment

PO_POA_SRCH_VW4

(SQL View)
Index Back

SELECT DISTINCT A.EIP_CTL_ID , A.BUSINESS_UNIT , A.PO_ID , A.PO_POA_STATUS , A.ACKNOWLEGE_DT , A.DATETIME_DISP , B.VENDOR_ID , B.VENDOR_SETID , A.PO_ACK_SOURCE , A.DATETIME_CREATE , A.RESPONDED_DTTM , B.VNDR_LOC , ' ' , A.CHNG_ORD_BATCH , B.BUYER_ID , A.POA_HIST_TYPE FROM PS_PO_POA_HDR_HIST A , PS_PO_HDR B WHERE A.PO_ID = B.PO_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 PO_POA_STATUS Character(3) VARCHAR2(3) NOT NULL 08/07/01 RML Created for Supplier Portal Acknowledgment
BAC=Buyer Accepted
CMP=EDX compare needed
NEW=New
SRP=Supplier Responded
SRV=Supplier Review
5 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date
6 DATETIME_DISP DateTime(26) TIMESTAMP Date and Time Dispatched
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 PO_ACK_SOURCE Character(3) VARCHAR2(3) NOT NULL Created on 08/09/01 CN#WV840-4.0 - Purchase Order Acknowledgment source used in PO_HDR_EC
BUY=Online (Buyer)
EDI=EDX
SUP=Online (Supplier)
10 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
11 RESPONDED_DTTM DateTime(26) TIMESTAMP Represents the date and time a designated operator reviewed and acknowledged an exposure limit vi
12 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
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 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
15 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
16 POA_HIST_TYPE Character(1) VARCHAR2(1) NOT NULL Submitted by
B=Buyer
S=Supplier