PV_MS_PO_STS_HD

(SQL Table)

# 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 PV_MS_PO_STS Character(1) VARCHAR2(1) NOT NULL MarketPlace PO Status
5=Change Order Created
C=MarketSite Complete
E=MarketSite Error
N=Not Sent to MarketSite
W=Waiting for Response

4 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

5 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

6 DATE_ADDED Date(10) DATE Date Added

7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description

#	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	PV_MS_PO_STS	Character(1)	VARCHAR2(1) NOT NULL	MarketPlace PO Status 5=Change Order Created C=MarketSite Complete E=MarketSite Error N=Not Sent to MarketSite W=Waiting for Response
4	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
5	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
6	DATE_ADDED	Date(10)	DATE	Date Added
7	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description