PO_PLN_CONS_VW (SQL View)	Index Back
PO Planning Consolidation View PO Planning Consolidation View

PO_PLN_CONS_VW

(SQL View)

PO Planning Consolidation View

SELECT PROCESS_INSTANCE , BUSINESS_UNIT_IN , MAX(SEQ_NBR) , PLANNER_CD , VENDOR_SETID , VENDOR_ID , VNDR_LOC , SETID , INV_ITEM_ID , DUE_DT , DUE_TIME , PLAN_FROZEN_FLG , CONFIG_CODE , SUM(QTY_PO) , PL_PO_TYPE , BUYER_ID , OVERRIDE_SUGG_VNDR FROM PS_PL_PO_PLAN_ORD GROUP BY PROCESS_INSTANCE , BUSINESS_UNIT_IN , PLANNER_CD , VENDOR_SETID , VENDOR_ID , VNDR_LOC , SETID , INV_ITEM_ID , DUE_DT , DUE_TIME , PLAN_FROZEN_FLG , CONFIG_CODE , PL_PO_TYPE , BUYER_ID , OVERRIDE_SUGG_VNDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

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

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

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

8 SETID Character(5) VARCHAR2(5) NOT NULL SetID

9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

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

11 DUE_TIME Time(15) TIMESTAMP Due Time

12 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

13 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

14 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity

15 PL_PO_TYPE Character(1) VARCHAR2(1) NOT NULL Purchase Order Type
E=Existing Orders
N=Planned Order

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

17 OVERRIDE_SUGG_VNDR Character(1) VARCHAR2(1) NOT NULL Override Suggested Vendor

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	PLANNER_CD	Character(12)	VARCHAR2(12) NOT NULL	Planner Code
5	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
9	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
10	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.
11	DUE_TIME	Time(15)	TIMESTAMP	Due Time
12	PLAN_FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	11/01/01 PCL (CN#PL900-1): Updated N=No Y=Yes
13	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
14	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
15	PL_PO_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Purchase Order Type E=Existing Orders N=Planned Order
16	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
17	OVERRIDE_SUGG_VNDR	Character(1)	VARCHAR2(1) NOT NULL	Override Suggested Vendor