Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

PV_CHNG_REQ_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , B.LINE_NBR , A.PO_DT , A.VENDOR_ID , D.BUSINESS_UNIT , D.REQ_ID , C.REQ_LINE_NBR , B.DESCR254_MIXED , A.PO_STATUS , B.CANCEL_STATUS , A.RECV_STATUS , D.PRICE_REQ , D.UNIT_OF_MEASURE , D.QTY_REQ , D.MERCHANDISE_AMT , B.RECV_REQ , B.INV_ITEM_ID , B.CATEGORY_ID , B.ITM_SETID , D.MFG_ID , D.MFG_ITM_ID , D.ITM_ID_VNDR FROM PS_PO_HDR A , PS_PO_LINE B , PS_PO_LINE_DISTRIB C , PS_REQ_LINE D WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.PO_ID=B.PO_ID AND B.BUSINESS_UNIT=C.BUSINESS_UNIT AND B.PO_ID=C.PO_ID AND B.LINE_NBR=C.LINE_NBR AND D.REQ_ID=C.REQ_ID AND D.LINE_NBR=C.REQ_LINE_NBR AND D.BUSINESS_UNIT=C.BUSINESS_UNIT_REQ AND (A.PO_STATUS = 'D' OR (A.PO_STATUS = 'A' AND A.CHNG_ORD_BATCH > 0)) AND B.CANCEL_STATUS <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

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

Default Value: NEXT

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 PO_DT Date(10) DATE Date
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
7 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
8 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
10 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

Default Value: I

11 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
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

Default Value: N

13 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
15 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
16 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
17 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required
18 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
19 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
20 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
21 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
22 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
23 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID