PO_SPEND_PG_VW

(SQL View)
Index Back

PO Spend History View

PO Spend History View by PO Date

SELECT REPORT_ENTITY , BUYER_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , BUSINESS_UNIT , PO_ID , LINE_NBR , FISCAL_YEAR , CURRENCY_CD , MERCHANDISE_AMT , CNTRCT_FLAG , BUYER_DESCR , NAME1 , PO_DT , INV_ITEM_ID , DESCR254_MIXED , CATEGORY_CD , MFG_ID , MFG_ITM_ID , ITM_ID_VNDR , CNTRCT_SETID , CNTRCT_ID , VERSION_NBR , CNTRCT_LINE_NBR , CAT_LINE_NBR , DUE_DT , SHIPTO_ID , DISP_METHOD , SRM_DB_PER_LBL , ASOF_DTTM FROM PS_PO_SPEND_PVG

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
9 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
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 CNTRCT_FLAG Character(1) VARCHAR2(1) NOT NULL PO Contract Spend
A=All
N=Non PO Contract
P=PO Contract
13 BUYER_DESCR Character(30) VARCHAR2(30) NOT NULL Buyer Desc
14 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
15 PO_DT Date(10) DATE Date
16 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
17 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
18 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
19 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
20 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: %EDIT_MFGITM_ID

21 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
22 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
23 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
24 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
25 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

Prompt Table: %EDIT_CNTRCT_LN

26 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number

Prompt Table: %EDITTABLE4

27 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
28 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
29 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
30 SRM_DB_PER_LBL Character(10) VARCHAR2(10) NOT NULL Chart Period Label
31 ASOF_DTTM DateTime(26) TIMESTAMP Data As Of