PV_PO_DIS_ERR_V

(SQL View)

SELECT A.EIP_CTL_ID , A.BUSINESS_UNIT , A.PO_ID , A.PV_PO_STS , B.PO_STATUS , B.PO_DT , B.BUYER_ID , A.DATE_ADDED , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.MESSAGE_TEXT FROM PS_PV_PO_DIS_ERR A , PS_PO_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

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

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

4 PV_PO_STS Character(1) VARCHAR2(1) NOT NULL PO status
1=Sent to MarketPlace
2=Received by MarketPlace
3=Processing MarketPlace Order
4=Accepted MarketPlace Order
5=Not Accepted by MarketPlace
6=Cancelled by MarketPlace
7=Prepayment Required
8=Completed at MarketPlace
9=Other MarketPlace Order Status
D=Dispatched
E=Error
P=Published
R=Rejected

5 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled

6 PO_DT Date(10) DATE NOT NULL Date
Default Value: %date

7 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
Prompt Table: %EDIT_BUYER

8 DATE_ADDED Date(10) DATE Date Added

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

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

11 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	PV_PO_STS	Character(1)	VARCHAR2(1) NOT NULL	PO status 1=Sent to MarketPlace 2=Received by MarketPlace 3=Processing MarketPlace Order 4=Accepted MarketPlace Order 5=Not Accepted by MarketPlace 6=Cancelled by MarketPlace 7=Prepayment Required 8=Completed at MarketPlace 9=Other MarketPlace Order Status D=Dispatched E=Error P=Published R=Rejected
5	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled
6	PO_DT	Date(10)	DATE NOT NULL	Date Default Value: %date
7	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: %EDIT_BUYER
8	DATE_ADDED	Date(10)	DATE	Date Added
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.