PO_CN_WB_EXP_VW (SQL View)	Index Back
PO Contract exception table 05/10/2021 Nash 32555551 We ensured that closing a purchase order from Buyers Workbench, will log an exception if the purchase order lines with contracts are having unused quantities/amounts.

PO_CN_WB_EXP_VW

(SQL View)

PO Contract exception table

05/10/2021 Nash 32555551 We ensured that closing a purchase order from Buyers Workbench, will log an exception if the purchase order lines with contracts are having unused quantities/amounts.

SELECT DISTINCT BUSINESS_UNIT , WORKBENCH_ID , PO_ID , MESSAGE_SET_NBR , MESSAGE_NBR FROM PS_PO_RC_WB_EXP WHERE MESSAGE_SET_NBR = 10225 AND MESSAGE_NBR IN (52, 54)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 WORKBENCH_ID Character(10) VARCHAR2(10) NOT NULL WorkBench ID

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

4 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

5 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	WORKBENCH_ID	Character(10)	VARCHAR2(10) NOT NULL	WorkBench ID
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
5	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.