PO_SPEND_PVG_VW

(SQL View)
Index Back

PO Spend History Table

PO Spend History Table by PO Date

SELECT A.REPORT_ENTITY ,A.BUYER_ID ,A.VENDOR_SETID ,A.VENDOR_ID ,A.VNDR_LOC ,A.BUSINESS_UNIT ,A.PO_ID ,A.LINE_NBR ,A.SCHED_NBR ,A.FISCAL_YEAR ,A.ACCOUNTING_PERIOD ,A.CURRENCY_CD ,A.MERCHANDISE_AMT ,A.BUYER_DESCR ,A.NAME1 ,A.PO_DT ,A.INV_ITEM_ID ,A.DESCR254_MIXED ,A.CATEGORY_CD ,A.DUE_DT ,A.SHIPTO_ID ,A.ASOF_DTTM , A.SRM_DB_S_ACCT_PER %Concat '/' %Concat %Substring(%NumToChar(A.FISCAL_YEAR), 3, 2) FROM PS_PO_SPEND_PVG A

# 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 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
10 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
11 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.
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 BUYER_DESCR Character(30) VARCHAR2(30) NOT NULL Buyer Desc
15 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
16 PO_DT Date(10) DATE Date
17 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
18 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
19 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
20 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.
21 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
22 ASOF_DTTM DateTime(26) TIMESTAMP Data As Of
23 MONTH_CHAR Character(15) VARCHAR2(15) NOT NULL Accounting Period