PO_SPND_DISP_VW (SQL View)	Index Back
PO Spend dispatch view

PO_SPND_DISP_VW

(SQL View)

PO Spend dispatch view

SELECT A.DISP_METHOD , B.XLATSHORTNAME ,SUM(A.MERCHANDISE_AMT) FROM PS_PO_SPND_PODTDTL A , PSXLATITEM B WHERE B.FIELDNAME = 'DISP_METHOD' AND B.FIELDVALUE = A.DISP_METHOD GROUP BY A.DISP_METHOD, B.XLATSHORTNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

3 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label