PO_UOM_UPDPO_VW (SQL View)	Index Back
Update PO Detail Table Update PO Detail Table for the Update PO Conversion Rate page.

PO_UOM_UPDPO_VW

(SQL View)

Update PO Detail Table

Update PO Detail Table for the Update PO Conversion Rate page.

SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.ITM_SETID , A.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.UNIT_OF_MEASURE , A.EFFDT , A.PO_DT , A.CNTRCT_SETID , A.CNTRCT_ID , A.PRICE_DT_TYPE , A.PRICE_PO , A.DUE_DT , A.UNIT_MEASURE_STD , A.CONVERSION_RATE , A.CONVERSION_RATE1 , 'N' , A.QTY_PO , B.EFFDT_MAX FROM PS_PO_UOM_UPDPO_V1 A , PS_PO_UOM_UPDPO_V2 B WHERE A.ITM_SETID = B.ITM_SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.VENDOR_SETID = A.VENDOR_SETID AND A.VENDOR_ID = A.VENDOR_ID AND A.VNDR_LOC = A.VNDR_LOC AND A.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

5 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

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

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

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

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

10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

11 EFFDT Date(10) DATE Effective Date
Default Value: %date

12 PO_DT Date(10) DATE Date

13 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID

14 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

15 PRICE_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Date to Use for Prices
D=Due Date
P=PO Date

16 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price

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

18 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

19 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

20 CONVERSION_RATE1 Signed Number(17,8) DECIMAL(15,8) NOT NULL Req UOM conversion rate

21 CB_SELECT_PO Character(1) VARCHAR2(1) NOT NULL Select PO Schedule Checkbox
Y/N Table Edit
Default Value: N

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

23 EFFDT_MAX Date(10) DATE 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_effdt_from.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
6	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
10	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
11	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
12	PO_DT	Date(10)	DATE	Date
13	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
14	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
15	PRICE_DT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Date to Use for Prices D=Due Date P=PO Date
16	PRICE_PO	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Purchase Order Price
17	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.
18	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
19	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
20	CONVERSION_RATE1	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Req UOM conversion rate
21	CB_SELECT_PO	Character(1)	VARCHAR2(1) NOT NULL	Select PO Schedule Checkbox Y/N Table Edit Default Value: N
22	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
23	EFFDT_MAX	Date(10)	DATE	03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_effdt_from.