PV_REQ_MBL_VW

(SQL View)
 Index Back

Mobile Requisitions


SELECT BUSINESS_UNIT , REQ_ID , REQ_NAME , ORIG_TRAN , REQ_DT , REQ_STATUS , REQ_STATUS , 0 , CURRENCY_CD , OPRID_ENTERED_BY , REQUESTOR_ID , BUDGET_CHECK , BUDGET_HDR_STATUS , HOLD_STATUS , REQ_TYPE , ' ' , ' ' FROM PS_REQ_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name
4 ORIG_TRAN Character(3) VARCHAR2(3) NOT NULL Transaction Originated From
EPO=eProcurement Requisition
REQ=Purchasing Requisition
5 REQ_DT Date(10) DATE Requisition Date
6 PV_REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Requisition status
A=Approved
B=Canceled
C=Complete
D=Denied
H=On Hold
I=Initial
LA=See Lines
O=Open
P=Pending
PAC=PO Partially Completed
PC=PO(s) Completed
PD=Partially Dispatched
PPC=PO Partially Created
PPX=PO Partially Canceled
PX=PO(s) Canceled
Q=PO(s) Created
R=PO(s) Dispatched
S=Received
SC=Service Complete
SF=Service Filled
SP=Partially Received
SR=Rate Pending
SRD=Rate Defined
SS=Service Sourced
X=Canceled
7 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled
8 REQ_TOTAL Signed Number(30,5) DECIMAL(28,5) NOT NULL Requisition Total
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 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
11 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
12 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
N=No
Y=Yes
13 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
14 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
15 REQ_TYPE Character(4) VARCHAR2(4) NOT NULL Requisition Type
BO=Bill Only
BR=Bill and Replace
STD=Standard
16 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
17 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