PO_SPND_ND_VW (SQL View)	Index Back
po spend not dispatched view Detail table for Spend AE by PO Date 06/25/2008 PKL F-AHAYT-S60K7 Contract Enhancements

PO_SPND_ND_VW

(SQL View)

po spend not dispatched view

Detail table for Spend AE by PO Date 06/25/2008 PKL F-AHAYT-S60K7 Contract Enhancements

SELECT A.PO_STATUS ,B.XLATSHORTNAME , COUNT(A.PO_ID) FROM PS_PO_SPND_PODT_ND A , PSXLATITEM B WHERE B.FIELDNAME = 'PO_STATUS' AND B.FIELDVALUE = A.PO_STATUS GROUP BY PO_STATUS, B.XLATSHORTNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

3 COUNT1 Number(10,0) DECIMAL(10) NOT NULL Counter

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	COUNT1	Number(10,0)	DECIMAL(10) NOT NULL	Counter