PO_HDR_EC_VW (SQL View)	Index Back
PO Acknowledgment view Created on 08/09/01 - CN#WV840-4.0 To show purchase order acknowledgments in descending order by purchase order number

PO_HDR_EC_VW

(SQL View)

PO Acknowledgment view

Created on 08/09/01 - CN#WV840-4.0 To show purchase order acknowledgments in descending order by purchase order number

SELECT business_unit , po_id , datetime_create , eip_ctl_id , chng_ord_batch , acknowlege_dt , ack_status , process_flg , po_poa_status FROM PS_PO_HDR_EC

# 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

3 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.

4 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

5 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number

6 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date

7 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

8 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag

9 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

#	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
3	DATETIME_CREATE	DateTime(26)	TIMESTAMP	02/2001 cel WV-802-1.0.
4	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
5	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
6	ACKNOWLEGE_DT	Date(10)	DATE	Acknowledge Date
7	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
8	PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processing Flag
9	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