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

PV_RTV_REQ_UPD

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT ,A.RTV_ID ,A.BUSINESS_UNIT_PO ,A.PO_ID ,A.BUSINESS_UNIT_REQ ,A.REQ_ID ,A.REQUESTOR_ID ,A.OPRID_ENTERED_BY ,A.ENTERED_DT ,A.BUYER_ID ,A.OPRID_MODIFIED_BY ,A.ENTERED_BY ,A.ITM_SETID ,A.INV_ITEM_ID ,A.DESCR254_MIXED ,A.QTY_REQ ,A.PV_MERCH_AMT_REQ ,A.PRICE_REQ ,A.VENDOR_SETID ,A.VENDOR_ID ,A.RECEIVER_ID ,A.RTV_STATUS ,A.CURRENCY_CD ,A.CATEGORY_ID ,A.UNIT_OF_MEASURE ,A.MFG_ID ,A.MFG_ITM_ID ,A.VNDR_CATALOG_ID ,A.ITM_ID_VNDR ,A.QTY_AM_RETRN_VUOM ,A.QTY_AM_SHIP_VUOM ,A.PV_RECV_MSG1 ,A.REQ_NAME ,A.HTML_AREA_01 FROM PS_PV_RTV_REQ_UP2 A , PS_REQ_HDR B WHERE A.REQ_ID = B.REQ_ID(+) AND A.BUSINESS_UNIT_REQ=B.BUSINESS_UNIT(+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
3 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
6 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
7 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
8 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
9 ENTERED_DT Date(10) DATE Entered on
10 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
11 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
12 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
13 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
16 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
17 PV_MERCH_AMT_REQ Signed Number(28,3) DECIMAL(26,3) NOT NULL Req Merchandise Amout
18 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
19 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
20 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
21 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
22 RTV_STATUS Character(1) VARCHAR2(1) NOT NULL Return Status
C=Closed
O=Open
S=Shipped
X=Cancelled
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
24 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
25 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
26 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
27 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: %EDIT_MFGITM_ID

28 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
29 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
30 QTY_AM_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vendor Returned Qty
31 QTY_AM_SHIP_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Supplier Shipped Qty
32 PV_RECV_MSG1 Character(254) VARCHAR2(254) NOT NULL Inquire Receipts
33 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name
34 HTML_AREA_01 Long Character CLOB HTML Area