PR_REQUEST_VW

(SQL View)
 Index Back

Payment Request


SELECT REQ.REQUEST_ID , REQ.OPRID , REQ.ENTERED_DT , REQ.PR_STATUS , REQ.ENTERED_DTTM , REQ.LASTUPDT_DTTM , REQ.ROLENAME , REQ.PR_TEMPLATE_ID , REQ.BUSINESS_UNIT , REQ.VOUCHER_ID , REQ.SCHEDULED_PAY_DT , REQ.VENDOR_ID , REQ.NAME1 , REQ.DESCR50 , REQ.INVOICE_ID , REQ.INVOICE_DT , REQ.GROSS_AMT , REQ.TXN_CURRENCY_CD FROM PS_PR_REQUEST REQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 ENTERED_DT Date(10) DATE Entered on
4 PR_STATUS Character(1) VARCHAR2(1) NOT NULL To detemine Payment Request Status
1=New
2=Denied
3=Submitted
4=Pending
5=Approved
6=Vouchered
7=Cancelled
5 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime

Default Value: %Datetime

6 LASTUPDT_DTTM DateTime(26) TIMESTAMP Last Upd Dttm
7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
8 PR_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Payment Request Template Name
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
11 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
13 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
14 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
15 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
16 INVOICE_DT Date(10) DATE Invoice Date
17 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code