PO_POA_ERR_SRC1

(SQL View)
 Index Back

POA Error Panel Srch


SELECT A.EIP_CTL_ID , A.BUSINESS_UNIT , A.PO_ID , A.ACK_STATUS , A.REVIEWED , A.ACKNOWLEGE_DT , A.REVIEWED_DT , B.BUYER_ID , B.VENDOR_ID , C.VENDOR_NAME_SHORT FROM PS_PO_HDR_EC A , PS_PO_HDR B , PS_VENDOR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND B.VENDOR_SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID AND A.PO_ACK_SOURCE = 'EDI'

# 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

Prompt Table: SP_BU_PM_NONVW

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: PO_HDR_EC

4 ACK_STATUS Character(3) VARCHAR2(3) NOT NULL Acknowledgement Status
AC=Ack - With Detail and Change
AD=Ack - With Detail, No Change
AE=Ack - Exception Detail Only
AH=Acknowledge - Hold Status
AK=Ack - No Detail or Change
AT=Accepted
BP=Accepted - Partial Shipment
DR=Accepted - Date Rescheduled
IA=Accepted - Price Pending
IB=Backordered
IC=Accepted - Changes Made
ID=Deleted
IF=On Hold-Incomplete Description
IH=On Hold
IP=Accepted - Price Changed
IQ=Accepted - Quantity Changed
IS=Accepted - Substitution Made
IW=On Hold - Waiver Required
RD=Rejected With Detail
RF=Rej - Exception Detail Only
RJ=Rejected - No Detail
RO=Rejected With Counter Offer
SP=Accpted-Schedule Date Pending
ZZ=Mutually Defined Value
5 REVIEWED Character(1) VARCHAR2(1) NOT NULL Review Complete
N=No
Y=Yes
6 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date
7 REVIEWED_DT Date(10) DATE Reviewed On
8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW

9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

10 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

Prompt Table: VENDOR_PO_NM_VW