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

PO_PODT_NDA_VW

(SQL View)

PO SWL not dispatched

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

SELECT A.REPORT_ENTITY , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.BUSINESS_UNIT , A.PO_ID , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.PEND_FR_DT , A.PO_STATUS , A.APPROVAL_DT FROM PS_PO_SPND_PODT_ND A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID

2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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

4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

8 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

9 PEND_FR_DT Date(10) DATE Select Pend-Cmpl Prdn From Dat

10 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

11 APPROVAL_DT Date(10) DATE Date of Approval

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
2	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
9	PEND_FR_DT	Date(10)	DATE	Select Pend-Cmpl Prdn From Dat
10	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
11	APPROVAL_DT	Date(10)	DATE	Date of Approval