PV_PO_DISP_VW2 (SQL View)	Index Back
PO Dispatch Status View Market site items is included in this process. AND NOT EXISTS( SELECT 'X' FROM PS_PV_CP_MFG_XREF S WHERE S.SETID = A.ITM_SETID AND S.MFG_ITM_ID = A.MFG_ITM_ID AND S.MFG_ID = A.MFG_ID) 12/27/2001 Removed the above condition from the view to include direct connect merchants.

PV_PO_DISP_VW2

(SQL View)

PO Dispatch Status View

Market site items is included in this process. AND NOT EXISTS( SELECT 'X' FROM PS_PV_CP_MFG_XREF S WHERE S.SETID = A.ITM_SETID AND S.MFG_ITM_ID = A.MFG_ITM_ID AND S.MFG_ID = A.MFG_ID) 12/27/2001 Removed the above condition from the view to include direct connect merchants.

SELECT H.business_unit , H.po_id , H.buyer_id , H.change_status , H.chng_ord_batch , H.chng_ord_seq , H.disp_action , H.disp_method , H.hold_status , H.po_dt , H.po_status , H.recv_status , H.vendor_id , H.CURRENCY_CD , H.TAX_EXEMPT , H.VENDOR_SETID , H.VNDR_LOC , H.PYMNT_TERMS_CD FROM PS_PO_HDR H WHERE H.DISP_METHOD = 'EDX' AND H.PO_STATUS = 'A' GROUP BY H.business_unit, H.po_id, H.buyer_id, H.change_status, H.chng_ord_batch, H.chng_ord_seq, H.disp_action, H.disp_method, H.hold_status, H.po_dt, H.po_status, H.recv_status, H.vendor_id, H.VENDOR_SETID, H.VNDR_LOC, H.CURRENCY_CD, H.TAX_EXEMPT, H.PYMNT_TERMS_CD

# 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 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

4 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged

5 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number

6 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number

7 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr

8 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print

9 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

10 PO_DT Date(10) DATE Date

11 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

12 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

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

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

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

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

18 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

#	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	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
4	CHANGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Order Status C=Changed U=Unchanged
5	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
6	CHNG_ORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Change Order Sequence Number
7	DISP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Allow Dispatch When Appr
8	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
9	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing
10	PO_DT	Date(10)	DATE	Date
11	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
12	RECV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Status C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled
13	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
16	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
17	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
18	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.