PO_SPND_POND_VW (SQL View)	Index Back
po spend not dispatched po

PO_SPND_POND_VW

(SQL View)

po spend not dispatched po

SELECT REPORT_ENTITY , BUYER_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , BUSINESS_UNIT , PO_ID , FISCAL_YEAR , ACCOUNTING_PERIOD , CURRENCY_CD , MERCHANDISE_AMT , PO_DT , DISP_METHOD , PEND_FR_DT , PO_STATUS , ENTERED_DT , APPROVAL_DT FROM PS_PO_SPND_PODT_ND

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

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

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

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

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

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

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

9 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.

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

11 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

12 PO_DT Date(10) DATE Date

13 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print

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

15 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

16 ENTERED_DT Date(10) DATE Entered on

17 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	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
3	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
8	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
9	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.
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
12	PO_DT	Date(10)	DATE	Date
13	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
14	PEND_FR_DT	Date(10)	DATE	Select Pend-Cmpl Prdn From Dat
15	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
16	ENTERED_DT	Date(10)	DATE	Entered on
17	APPROVAL_DT	Date(10)	DATE	Date of Approval