PO_ACK_SRCH (SQL View)	Index Back
PO Acknowledgment Search

PO_ACK_SRCH

(SQL View)

PO Acknowledgment Search

select A.BUSINESS_UNIT, A.PO_ID, B.CNTRCT_ID, B.RELEASE_NBR, A.ACK_STATUS, A.REVIEWED, A.ACKNOWLEGE_DT from PS_PO_HDR_EC a, PS_PO_LINE_EC b where A.BUSINESS_UNIT = B.BUSINESS_UNIT and A.PO_ID = B.PO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Prompt Table: PO_SRCH

3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
Prompt Table: PO_CNTRCT_SRCH

4 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number

5 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

6 REVIEWED Character(1) VARCHAR2(1) NOT NULL Review Complete
N=No
Y=Yes

7 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: PO_SRCH
3	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID Prompt Table: PO_CNTRCT_SRCH
4	RELEASE_NBR	Number(5,0)	INTEGER NOT NULL	Release Number
5	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
6	REVIEWED	Character(1)	VARCHAR2(1) NOT NULL	Review Complete N=No Y=Yes
7	ACKNOWLEGE_DT	Date(10)	DATE	Acknowledge Date